SUMMARY

• Served as ETL Developer for the Data Warehouse 2.0 Project.
• Worked on the Staging of some of the Omniture and Epiphany tables. Technologies used included Informatica 9.1, Erwin Data Modeler, and Oracle SQL Developer.
• Sourced from flat file, and Oracle direct database connections.
• Target was Oracle SQL Developer. Project goal was to create a Data Warehouse for the Marketing Department.
• Served as Project Coordinator for multiple projects.
• Worked on Project financials, documentation, requirements, meetings, and weekly status reports.
• Served as ETL Developer for Analytics Repository Project.
• The goal was to create the Analytics Repository - Data Warehouse. Worked on the Staging of some of the CRM tables.
• Technologies used included Informatica 8.5. Sourced from flat file, and direct database connections.
• Also worked on documenting Runbooks for the different sources like CRM and H2I.
• Served as ETL Developer for the TEV Migration Project.
• The goal was to migrate the Student, Teacher, Principal, etc. data from TEV to EDW for HCPS. Documented the necessary tables by creating Source to Target Mapping Documents on EDW side.
• Served as ETL Developer. Documented the necessary tables by creating Source to Target Mapping Documents, created Workflows, Mappings for Staging, Dims and Facts in Informatica.
• Served as ETL Developer/Project Manager.

TECHNICAL SKILLS

• Informatica 9.5.1
• Informatica 10
• Erwin Data Modeler
• IBM Cognos Cube Designer Version 10.2.1
• IBM Cognos Performance Modeler Version 10.2.0
• IBM Cognos Insight
• Oracle SQL Developer
• SQL Server
• SAP BODS 4.2
• SSIS
• TFS
• JIRA
• Confluence
• Azure Dev Ops
• Azure Data Warehouse

PROFESSIONAL EXPERIENCE

Confidential

Data Warehouse Consultant/ Project Manager

Responsibilities:

• Served as ETL Developer for the TEV Migration Project. The goal was to migrate the Student, Teacher, Principal, etc. data from TEV to EDW for HCPS.
• Decomposed reports and data flows and documented the necessary tables by creating Source to Target Mapping Documents on TEV side. Worked on designing UW Extract, UW Import, and Residuals as well as Reports on EDW side.
• Served as ETL Developer for the GUCI project.
• The goal was to assign each Dine Reward customer a unique global ID in EDW along with corresponding check detail data which would give the business insight into Dine Reward customer purchases.
• Informatica was used to source data from the daily Paytronix stage tables and load to tables in the Customer Subject Area of the Base layer. Once these tables have been loaded to Base, they would act as the source for the mappings to load to the reporting layer GUCI Dimension and Fact tables.
• In addition to the above a one - time historical Workflow was created to source from the already existing Base tables to load to the reporting tables.
• Served as TM1/Cognos Dynamic Cubes Developer for clients Strategic Planning Scorecard Project to automate the collection of metrics related to school district performance and present those in a drillable report and enable real-time performance management of a select number of metrics.
• Technologies used included IBM Cognos Cube Designer Version 10.2.1, IBM Cognos Performance Modeler Version 10.2.0, and IBM Cognos Insight.
• Served as ETL Developer for the Data Warehouse 2.0 Project.
• Worked on the Staging of some of the Omniture and Epiphany tables. Technologies used included Informatica 9.1, Erwin Data Modeler, and Oracle SQL Developer.
• Sourced from flat file, and Oracle direct database connections.
• Target was Oracle SQL Developer. Project goal was to create a Data Warehouse for the Marketing Department.
• Served as Project Coordinator for multiple projects.
• Worked on Project financials, documentation, requirements, meetings, and weekly status reports.
• Served as ETL Developer for Analytics Repository Project.
• The goal was to create the Analytics Repository- Data Warehouse. Worked on the Staging of some of the CRM tables.
• Technologies used included Informatica 8.5. Sourced from flat file, and direct database connections.
• Also worked on documenting Runbooks for the different sources like CRM and H2I.
• Served as ETL Developer for the TEV Migration Project.
• The goal was to migrate the Student, Teacher, Principal, etc. data from TEV to EDW for HCPS. Documented the necessary tables by creating Source to Target Mapping Documents on EDW side.
• Served as ETL Developer. Documented the necessary tables by creating Source to Target Mapping Documents, created Workflows, Mappings for Staging, Dims and Facts in Informatica.
• Served as ETL Developer/Project Manager.
• Documented necessary tables by creating Source to Target Mapping Documents, created Staging, Archive, Integration, Dims and Facts in SSIS. In addition, as Project Manager performed the following tasks: managed the team budget and allocation, on-boarding of team members, set up and took meeting minutes, created weekly status reports and presented to client, managed risk and issue logs, ran daily standup meetings.
• Served as Business Analyst. Gathered requirements, created Source to Target Documentation, created DIT testing cases, and assisted Client QA team with testing. Part of the 1st team to work on Azure Data Warehouse at a Confidential Project.
• Served as Project Manager/Scrum Master for Analytics Project’s latest SOW.
• Worked on Project Financials, set up and ran meetings, created and presented weekly status reports, managed risk and issue logs, team allocation and budget, ran the daily standup meeting, Ad Hoc request process and documentation, as well as helped prioritize the work for the team on Azure DevOps.

Confidential

Intern

Responsibilities:

• Worked as a Business Analyst on the Patch Management System