Informatica
Sriharsha Pasupuleti
Data Architect
Littleton,CO
Summary
Motivated and Dedicated Data Solutions Architect with 12+ years' experience in Architecture, Modelling, Design and Development of Scalable and Innovative Data Solutions, with a proven track record of achieving improved sustainability, overall cost reduction while configuring and enabling the best practices for the most seamless and efficient product delivery.
Overview
13
13
years of professional experience
4
4
years of post-secondary education
Work History
Data Solutions Architect
Charles Schwab
Lone Tree, CO
09.2018 - Current
- Responsible for maintaining the Data Integrity,Quality & Security of the Retail Cloud Data Platform.
- Served as subject matter expert for the Org wide Data Integration patterns.
- Developed database architectural strategies at modeling, design and implementation stages to address large-scale system wide business applications.
- Established high-level data flow diagram, data standards, and naming conventions and evaluated the consistency and integrity of the model and repository.
- Served as team leader for cross-functional teams, making decisions on team-wide goals, timelines and personnel assignments.
- Performed preemptive resolution of technical issues by utilizing detailed knowledge of ongoing processes and policies.
- Initiated and Delivered Scalable, Forward-thinking BI Solutions using the ETL platform to meet the ever growing data needs.
- Developed conversion and system implementation plans for multiple Acquisition and Data Conversion involving huge volumes of data and complexity.
- Collaborated with system architects, design analysts and others to cater various business needs.
- Mentored team, sharing skills and expertise and encouraged each member to bring forward ideas and suggestions for improvement.
Senior Data Engineer
Capgemini US LLC
Bellevue, WA
02.2016 - 09.2018
- Designed and Developed integration methodologies to combine data from multiple, varied data sources such as RDBMS, SQL and big data installations.
- Analyzed complex data and identified anomalies using Audit Based Framework to generate trends and risks report to provide useful insights.
- Addressed ad hoc analytics requests and facilitated data acquisitions to support internal projects, special projects and investigations.
- Planned and Executed the Data Encryption Initiatives to address the NPI Data Leak identified during my research.
- Collaborated with internal and external stakeholders to optimize data sourcing pipelines and verify data quality.
- Prepared documentation and analytic reports effectively and efficiently delivering summarized results, analysis and conclusions to stakeholders.
Senior ETL Developer
Infosys Ltd.
Hyderabad, India
06.2009 - 01.2016
- Designed and created ETL code installations, aiding in transitions from one data warehouse to another.
- Mapped data between source systems and warehouses.
- Interpreted data models for conversion into ETL diagrams and code.
- Directed data transformations and transitions using Informatica.
- Prepared functional and technical documentation data for warehouses.
- Cooperated fully with product owners and enterprise architects to understand requirements.
- Completed quality reviews for designs, codes, test plans and documentation methods.
- Managed data quality issues during ETL processes, directing qualitative failures to team lead for improvement.
Education
Bachelor of Technology - Computer Science And Engineering
Acharya Nagarjuna University
India 09.2005 - 04.2009
Skills
Warehousing Solutions
System Architecture Design
SQL Programming
ETL processes
Engineering standards
Analytical and Critical Thinking
Interpersonal Communication
Planning and Coordination
Training and mentoring
Relational Database Management
Accomplishments
· Modernized legacy ETL Code by implementing best ETL practices with minimal changes and improved the overall performance by 33%.
· Architected, Designed and Developed the Scalable Data Pipelines to accommodate 8-10% of growth in Data Volumes.
· Created Frameworks and implemented reusable Design & Development practices to enforce Data Quality which drastically improved User Satisfaction as well as reduction in issue turn-around time.
· Developed and Deployed Reporting Mechanisms to address & answer data metrics as well as to implement Pro-Active Monitoring.
Software
Teradata
Oracle
SQL
Splunk
Shell Scripting
Salesforce
Splunk
Mongo DB
Hive
R
Spark
Scala
Python
Fivetran
Dbt
Interests
Data Architecture
Data Quality
Data Analytics
Scalability
Performance Optimization
Data Modelling
Automation
Framework Development
Timeline
Data Solutions Architect
Charles Schwab
09.2018 - Current
Senior Data Engineer
Capgemini US LLC
02.2016 - 09.2018
Senior ETL Developer
Infosys Ltd.
06.2009 - 01.2016
Bachelor of Technology - Computer Science And Engineering
Acharya Nagarjuna University
09.2005 - 04.2009