Summary
Overview
Work History
Education
Skills
Certification
Training
Timeline
Generic

ANUPA JOSE

Atlanta,GA

Summary

Data enthusiast, result oriented, and a servant leader with over 17 years of experience in Enterprise Business Intelligence and Analytics projects designing and delivering complex ETL solutions and Data Models (On Prem and Cloud). Experienced with creating and optimizing data warehouse architectures. Utilizes comprehensive knowledge of ETL processes to ensure efficient data integration.

Overview

18
18
years of professional experience
1
1
Certification

Work History

Custom Software Engineering Specialist

Accenture
08.2021 - Current
  • Lead Data Modeler in Federal Client; performed deep dive data analysis, conducted requirement sessions with stakeholders and designed/delivered star schema and data vault models for enterprise data platform application support. Implemented the data model using databricks and deployed pipelines following devops procedures
  • Data Architect for financial client and lead effort in moving on prem application to snowflake in AWS. Lead team on day to day activities from build to delivery, ran scrum ceremonies and coordinated closely with client leadership on requirements/clarifications and status updates
  • Data Architect at Telecommunications client; Stood up a self service reporting platform across enterprise in AWS. Lead efforts during data modelling/ETL design/ Build/ QA / Deployment phases and implemented project within timeline.
  • Collaborated with cross-functional teams to gather requirements and translate them into logical and physical data models.
  • Facilitated effective communication between technical and non-technical stakeholders through clear documentation of data model specifications and diagrams.
  • Championed change management activities by providing training and support to end-users during the adoption of newly implemented data models and systems.
  • Supported business intelligence initiatives by constructing dimensional models optimized for reporting purposes.
  • Assisted in the migration of legacy systems to modern platforms, ensuring seamless data transfer and minimal downtime.
  • Gathered, defined and refined requirements, led project design and oversaw implementation.
  • Designed data models for complex analysis needs.

Consultant

Slalom Consulting
07.2018 - 07.2021
  • ETL expert on Public Sector Data Migration project creating complex SQL queries to manipulate and migrate data from MySQL to SQL Server as per the target requirement. Designed and created SSIS packages to move data from source to target and lead the effort to completion. Worked proactively with the team to make sure the milestones were achieved.
  • ETL Resource on Healthcare Data Source Migration project to convert complex SQL queries from Health Catalyst (SAM) into Exasol. Converted, optimized, and tuned the queries achieving significant performance improvement.
  • Designed and created STAR dimensional data models for Public Sector client. Performed analysis on the raw source data for several subject areas. Designed STAR data models using Toad data modeler. Implemented the physical data model and source to target mappings and strategy for ETL team.

Digital Business & Integration Manager

Accenture LLP
02.2010 - 07.2021
  • Lead ETL Architect and Developer on Business Intelligence projects spanning several industries and implemented ETL solutions using Informatics Power Center. Demonstrated excellent problem solving and troubleshooting skills on critical projects. Lead and coordinated teams through design, build , QA and implementation in both agile and waterfall methodologies.
  • ETL Architect in Chemical giants' merger and spinoff efforts. Coordinated extensive analysis efforts, designed interim/future state ETL designs (Informatica Power Center). Databases included SQL Server, DB2, Oracle. Deadlines were met on the time critical project and managed parallel efforts efficiently resulting in successful delivery.
  • ETL Technical Architect responsible for designing and leading development of innovative BI/Data Warehousing solutions in Telecommunications Client. This included leading multiple teams of ETL development resources in producing the Technical Design and ETL deliverables. Implemented enhancement to major data marts without impacting reporting SLA for the country wide strategy decision. Also added new process in existing datamart for new reporting requirement. In addition, worked with the client business stakeholders in the analysis phases of the projects to collect application and technical requirements. Delivered 5 projects successfully on time.
  • Performed 2 major database merges to implement one Enterprise Data Warehouse on Telecommunications project. Defined the entire process end to end and coordinated and facilitated the critical process including contingency.
  • ETL Lead Developer responsible for implementing Data Warehouse for number of subject areas for Telecommunications client.
  • For phase 1, Performed Build/QA/Production Coordination responsibilities. Worked with client teams and successfully implemented data warehouse for 6 subject areas.
  • For phase 2 & 3 handled production support and enhancement of existing data warehouse. Designed/implemented new subject areas, became subject matter expert on complex data marts.
  • Designed STAR data models using Toad data modeler, Visio and ErWin. Created the physical data model on various database platforms – Oracle, SQL Server, DB2. Created source to target mappings and load strategy for ETL team.
  • Enhanced the data models for new requirements for the data warehouse environment. Tuned the data models for performance improvement.
  • Responsibilities included Informatica workflow performance tuning, provide guidance on teams' technical needs and collaborate closely with client stakeholders as well as technical teams.

Programmer Analyst

Cognizant Technology Solutions
11.2007 - 05.2009
  • ETL Developer on multiple BI/data warehouse projects.
  • Performed analysis of specifications, designed and developed Informatica mappings and customized workflows for the interfaces in Life Sciences and Healthcare client.
  • QA Tester on data warehouse projects ensuring the Informatica workflows meet the design requirements.
  • Performed documentation of TDD and unit / system /QA testing.

Education

Bachelor of Technology - Electronics & Communication Engineering

Mahatma Gandhi University
08-2007

Skills

  • ETL Tools: Informatica PowerCenter, SQL Server Integration Services (SSIS), Alteryx, Databricks
  • Databases: SQL Server, Oracle, DB2, Exasol, MySQL, PostGreSQL, Athena, BigQuery, Snowflake
  • Cloud & DBs: AWS, Microsoft Azure, Databricks
  • Languages: SQL, PL/SQL, T-SQL, Python

Certification

  • AWS Cloud Practitioner (September 2022)
  • AWS Solutions Architect – Associate (March 2021)
  • Snowflake – Snowpro Core Certification (March 2021)

Training

  • Completed Instructor led Snowflake fundamentals training.
  • Completed ACloudGuru Udemy course – AWS Certified Solutions Architect Associate 2020-
  • Currently attending Udemy training on Python

Timeline

Custom Software Engineering Specialist

Accenture
08.2021 - Current

Consultant

Slalom Consulting
07.2018 - 07.2021

Digital Business & Integration Manager

Accenture LLP
02.2010 - 07.2021

Programmer Analyst

Cognizant Technology Solutions
11.2007 - 05.2009

Bachelor of Technology - Electronics & Communication Engineering

Mahatma Gandhi University

Similar Profiles

CREATE PROFILE
ANUPA JOSE