Sachin A.

Lead Software Engineer @Wells Fargo

Commercial Lending Datawarehouse (Jan 2014 – ongoing) It’s Datawarehouse application with multiple analytical products and automation frameworks. On daily basis It performs ELT operations on the 80+ OLTP applications to feed industry standard OFSAA OLAP model. Top of it projects data in simplified structures to achieve furnished data desires of bank in stipulated timeframe- Lead ELT team to build solutions to transform ODS data, data project projection - Developed frameworks to perform data quality checks, data anomalies detection - Designed and developed optimal solutions to do daily average balances - Architected and developed rule based daily data trends analysis solution using python - Architected and developed rule-based data in motion solution with SQL, python APIs, UI - Manage entire data warehouse logical/physical data models with artifacts - Build complex SQLs to ensure the data integrity, business data matrices, data anomalies - Developed PL/SQL framework to do gather database stats optimal way to improve performance - Designed and developed PL/SQL framework to generate ETL/ELT status reporting data - Implemented PL/SQL dynamic partitioning framework to load or purge data effectively - Architected metadata driven dynamic ETL solution using Ab Initio XFR feature - Research and developed explanatory analytical solution using Python data frames, matplotlib - Own complete backend design, development, maintenance activities across application - Developed Teradata DataMart SQLs based solution to generate COVID 19 reporting data - Design and developed physical data modeling framework using Python and pySQL that expedite development by 60%- Optimize and tune the complex SQLs built by team member to reduce performance bottlenecks - Documented DFDs, FSDs, data model artifacts and technical presentations - Ensured team’s deliveries and task tracking with JIRA system - Bridged business and technology on requirements, technical solutions, impact analysis