Sachin A.
- Role
- Lead Software Engineer at Wells Fargo
- Location
- Fremont, CA, US
- LinkedIn followers
- 500 followers
About Sachin A.
SUMMARY: • 18+ years of experience in designing and implementing large-scale data…
Experience
Lead Software Engineer
Jan 2014 — Present
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
Find verified contacts for anyone on LinkedIn
Unifers gives sales teams verified emails and direct dials, enriched profiles, and outreach that lands in the inbox.
Free plan included · No credit card required
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.