Jul 2023 – Mar 2025 · 1 yr 8 mos · Foster City, California, United States · Hybrid

• As a Data Engineer, I focus on creating and implementing automated solutions that optimize data performance and drive efficiency. I've successfully led initiatives in optimizing BigQuery operations and developed a scalable FinTech data quality framework, resulting in significant performance gains and cost savings.

Aug 2021 – Jul 2023 · 1 yr 11 mos

• Designed and implemented large-scale data processing systems using technologies such as Apache Hadoop, Apache Spark, and NoSQL databases to support data-driven decision-making across the organization.
• Built and maintained data pipelines and ETL processes to ingest, transform, and store large and complex data sets from various sources, resulting in improved data quality and accessibility.
• Implemented data governance policies and procedures to ensure compliance with internal and external data privacy regulations and standards, improving data security and privacy.
• Collaborated with data scientists and business stakeholders to identify data requirements and develop scalable data architectures that support both real-time and batch processing of data.
• Worked closely with cross-functional teams to define and deliver complex data solutions, providing technical leadership and guidance throughout the project lifecycle.
• Mentored and trained junior data engineers on data engineering best practices and technologies, contributing to the growth and development of the team.
• Managed cloud infrastructure using Amazon Web Services (AWS), optimizing resource usage, and reducing operational costs while improving the scalability and performance of data processing workflows.

May 2021 – Aug 2021 · 3 mos

• Transactional solution to spark architecture and behaviours
• Design, implement, automate deployment of our distributed system for collecting, processing log events from multiple sources
• Design schema, operate internal data warehouses and SQL/NoSQL database systems, resolve data issues in the data pipelines
• Own the design, development, and maintenance of ongoing metrics, reports, analyses, dashboards to drive business decisions
• Drive architectural plans and implementation for data storage, and analytic solutions on AWS Athena, EMR, Redshift Spectrum
• Tools: Python, DAG Apache Airflow, Apache Spark, Scala, Hive, Presto

Feb 2020 – Dec 2020 · 10 mos · San Francisco, California, United States

Mar 2019 – Dec 2019 · 9 mos · Pune, Maharashtra, India · On-site

• Credit Suisse-Investment banking domain as Senior Data Analyst.
• In-Scope Products: Investment (all types), Deposits (Savings and DDA), Time (CD), Insurance
• Analysis: Churn Prediction, Cohort Analysis, Survival Analysis
• Activities:
• Developing the Informatica web services (ICRT) processes based upon Informatica cloud application integration.
• Developing REST API’s from Data Sources and Service Connectors for exposing the aggregated functionality to Consumers.
• Involved in Technical Design Document Preparation of the Project.
• Made necessary for incremental loads to populate data based on CRM Dynamics needs which are related to case creation.
• Performance tuned Informatica cloud mappings/ ICRT services using the data access services.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Performed Unit testing, System testing to verify the data loads and services are returning the results as per SLA.
• Tools and Technologies :
• R and Python Programming
• Data Analysis, Data Cleansing
• Data modeling
• ETL Informatica Cloud(ICS, ICSRT)
• Tableau
• IBM Congos Impromptu
• SQL Server Management Studio
• Project Management:
• Agile Scrum - Jira Board

Sep 2017 – Mar 2019 · 1 yr 6 mos · Pune, Maharashtra, India · On-site

• Leveraged expertise in data analysis, modeling, and visualization to deliver insights and recommendations for business growth and optimization
• Managed end-to-end data projects, from requirements gathering to solution design and implementation, ensuring high quality and timely delivery
• Conducted statistical analysis and modeling to drive better decision-making and identify opportunities for cost savings and revenue generation
• Utilized tools such as SQL, Python, and Tableau to extract, transform, and analyze data from diverse sources, including structured and unstructured data
• Collaborated with cross-functional teams to design and develop predictive models, dashboards, and reports that provided valuable insights to stakeholders
• Mentored junior data analysts and provided technical leadership in complex data projects, resulting in increased productivity and enhanced skillset of team members
• Developed and maintained strong relationships with clients, delivering excellent customer service and ensuring alignment with their business needs and objectives
• Demonstrated expertise in agile methodology and led the agile scrum process, enabling the team to achieve high performance and continuous improvement
• Certificate:
• Agile 101
• Agile SAFe
• Agile Scrum

Oct 2014 – Sep 2017 · 2 yrs 11 mos · Pune, Maharashtra, India

• As an Data Analyst in American Express Inc., credit card domain, I got an opportunity to work with both back-end as well as front-end team where I got a chance to learn new languages such as Unix, Python, SAP Business Object, SAS E-Minor for web interface at back-end mainly in Credit-Cycle
• An ETL resource with a good understanding of ETL flows and mechanisms.
• Understanding of Database and practice in DB2, Oracle, and MS-SQL
• Understanding of Data Migration Projects.
• Experience in Data warehousing, Data Analysis and Data Migration, Development, ETL, Maintenance, Unit Testing and Documentation
• Data Warehouse experience using Informatica Power Center 9.x (Source Analyzer, Repository Manager, Mapping Designer, Mapplet Designer, Transformation Designer, Workflow Manager, Monitor) as ETL tool on DB2/Oracle/ Microsoft SQL Server Database
• Knowledge of Dimensional data modeling, Star schema modeling, Snowflake modeling, with experience in TOAD and SQL Developer
• Knowledge of end to end Data Migration projects, the approach, the dependencies and flow
• Extensively used Microsoft SQL Server and DB2
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, Deployment, Maintenance and Production support
• Experience in creating Transformations (Lookup, Joiner, Aggregator, Expression, Update Strategy, Router, Filter, Normalizer, Transaction control, Source Qualifier, Sequence Generator, Sorter, and Rank), Mappings using Informatica Designer and Tasks (Sessions, Command, Email) using Workflow Manager to move data from multiple sources into targets
• Achievements:
• Achieved Kudos award for outstanding work done in the 1st year of joining and delivered the GMWB project within the timeframe
• Certification:
• Agile 101
• Agile SaFe
• Lean certification