Senior ETL ArchitectÂ Resume

SUMMARY

7 years of professional experience, in the field of Data Warehousing/Business Intelligence using industry’s leading tools and technologies such as Informatica 7x/8x/9x, OBIEE 10/11g and databases such as Oracle, SQL server, Informix.
Go to person for problem solving and root cause analysis for business data issues.
Experienced in leading cross functional teams across geographies while managing multiple aspects of data warehousing projects.
Experience and skill in all levels of SDLC life cycle from requirement gathering, preparing estimation, design, development, executing test scenarios to code deployment and technical support.
Extensive experience in Relational Data Modeling, Dimensional Data Modeling, Logical/Physical Design, ER Diagrams, Forward and Reverse Engineering
Experience in developing ETL Data Mapping, ETL design, and Data Governance.
Proficient in designing Star Schema, Snow Flake Schema, OLAP and OLTP Data Modeling
Strong RDBMS concepts and well experience in creating database Tables, Views, Sequences, triggers, Stored Procedures, Standalone Functions, Nested Functions, building Packages and developing Sub-Programs using PLSQL taking the Performance and Reusability into consideration.

TECHNICAL EXPERTISE

ETL Tools: Informatica

Databases : Oracle, SQL server, Informix

Scripting Language : Unix Scripting

Reporting Tool : OBIEE

Other Tools : WinSCP, DAC

PROJECT EXPERIENCE

Confidential

Senior ETL Architect

Roles and Responsibilities

Plan data integration process by developing common definitions of sourced data
Establish data integration specifications, examining data applications data models and data warehouse schema determining best-fit data interchange methods
Investigate, analyze and resolve complex technical problems related to system functions, environment and procedures
Identifying and managing interfaces, service levels, standards and configurations, performing integration and migration with SAP using Informatica SAP connector.
Automation of data flow from multiple sources like workday, concur, ADP and other payroll systems through UNIX scripts and informatica to SAP system.
Design an ETL system to send iDOCS to SAP system and also send in alerts to users in case of incorrect source data.
Prepare release notes and support documents as part of end-user and production support training.

Confidential

Senior Associate - Role and Responsibilities

Collect and formalize requirements expressed by stakeholders, assess the primary needs and evaluate the viability of possible improvements.
Interact with the business users to know their Business views while gathering the Report requirements and provide several Report Mock-ups to finalize the requirements
Investigate existing systems and define elements of logical data design for required systems.
Contribute to schema definition for a given business scenario.
Construct and validate data models from a business processing perspective
Data Acquisition & Reporting in OLAP environment using OBIEE
Environment: Informatica Power Center (8.5.1, 9.1), Oracle (10G), SQL, PL/SQL, UNIX
Prepare release notes and support documents as part of end-user and production support training.
Walk through reviews of design documentation and code for each software release
Supported the UAT testing and worked on the future enhancements.
Co-ordinate with the onsite team for all ETL deliverables
Migration of ETL code from development to test environment and then production
Using DAC (Batch/job scheduler) to schedule the mappings through jobs

Confidential

ETL Developer

Role and Responsibilities

Development and Integration including creating mappings and workflows for loading data in Informatica Designer
Provide training and support documents.
Troubleshooting and provide Production Support.
Efficient communication and co-ordination with various teams.
Knowledge transfer and training new recruits.

Confidential

BI Developer

Role and Responsibilities

Conducted user interviews and created BRD to document user requirements and reporting needs.
Developed data model in a star schema format using Erwin to extend Oracle Financial Analytics
Created and optimized materialized views for optimal performance of reports
Performed extensive testing of reports to ensure faster performance and bug free reports
Created non-functional requirement document, report design, report test documents, bus matrix and user manuals to help in end-user training.
Supported QA team and project manager while performing System Testing, Integration Testing, Regression Testing, and support for User Acceptance Testing (UAT)