SUMMARY:

• 9+ years of Data Warehousing & Business Intelligence experience as Data Architect , ETL Architect and ETL Lead.
• Specialize in ETL methodology for supporting data analysis in a corporate - wide-ETL solution using Informatica.
• Experience in Conceptual Data Modeling, Enterprise Data Modeling, Logical Data Modeling, Physical Data Modeling, Enterprise Data Warehouse Design, DataMart Design, Data Quality, Master Data Management and Data Governance.
• Experience to create vision, scope, and use case documents, business process models, use case diagrams, activity diagrams , and state chart diagrams
• Hands on Experience using various Databases such as Teradata, Oracle, DB2 and SQL Server & Greenplum
• Experience working with Flat Files, COBOL, XML and Web Services.
• Working knowledge of Hadoop Big data, Pig, Hive, Sqoop
• 6+ years of customer facing experience in analyzing and developing their business requirements across different functional areas and developing strategies for Extraction, Transformation and Loading (ETL) mechanism.
• About 4 years of experience in leading/engaging and coordinating the activities across midsize teams internal and external to the organizations (vendor management).
• A thorough understanding of SDLC and project management life cycle.
• Exemplary written and verbal communication with Confidential ention to detail in order to meet customer expectations and maintain high levels of client satisfaction
• After project inception, the budget was cut into 1/3rd. Worked with the technical team to come up with an alternative design plan to still meet Client objectives by making only very little scope reduction
• Critical SLA Risk Mitigation effort which enabled department to meet client imposed deadlines by proactively identifying exposures and working with the client to mitigate risks to their key production environments.
• Overhaul change to production process by re-organize informatica folders that helped in saving at least 20-30% in time & effort per every deployment
• Oversaw the implementation of QA/QC system to streamline existing processes, identify inefficiencies, and realize cost savings by reducing overhead
• Design, develop & automate multiple regulatory files mandated by government to reduce 20% resource utilization on a monthly basis
• Design and Build a new Mortgage Data Mart reducing redundancy, cutting costs and finishing ahead of schedule and under budget with zero downtime for users

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 9.6/9.5/9.1/8.6.1/8.1/7.1 , Abinitio 2.15, Informatica DT Studio 9.6, DataValidator, Informatica Analyst, IDQ

RDBMS: Greenplum 4.3.x, Oracle 11g/10g/9i/8i, IBM DB2 8.1/7.0MS SQL Server 2008/2000, Teradata 13, MS Access

Database Tools: Toad for Oracle, AQT, Quest Central for DB2, SQL DeveloperWin SQL, pgAdmin

BI Tools: Business Objects XI R2/6.x, Congo’s 8

Modeling Tools: Erwin 3.5.2/3.x

Job Scheduling Tools: Control-M, Tidal, Autosys

Other Tools: EA Enterprise Architect, MS Visio, Humming Bird for FTPPutty, MS Visual SourceSafe, Winscp, CuteFTP, JIRA, Harvest

HP Service Manager, CA Software Change Manager, Version One: Metacenter, TFS

Languages: SQL, PL/SQL, UNIX Shell Scripting, C, C++

Operating Systems: Windows 7, XP,2000, UNIX-AIX, IBM MVS/390, Linux

PROFESSIONAL EXPERIENCE:

Confidential, Madison, WI

Information Architect

Responsibilities:

• Analyze business needs and document functional and technical specifications based upon user requirements with extensive interactions with business users.
• Create architectural and high level design documents in accordance with business requirements and enterprise standards.
• Design details include Source Data Analysis, ETL Process flows, Error Handling, Re-start ability and Extendibility.
• Provide detail level estimates for all project work & estimate the amount of resources & their durations
• Collaborate with the Project Manager
• To lay out a detail Project Plan with details like timelines for various tasks like development, testing, UAT & production implementation
• Identify the resources needed to complete each task & allocate appropriate hours to them
• Hold daily status meetings to track the status of the project
• Help ETL team to develop complex mappings applying various transformations
• Review the mappings & test cases implemented by the developers & suggest changes if needed.
• Help the Test Lead with Testing Strategy, review the final document & provide feedback to add new test cases or modifying existing

Environment: Informatica PowerCenter 9.6.1/9.5.1/9.0.1 , Informatica Analyst, Informatica DT studio 9.6, EA Enterprise Architect, Microsoft Visio, Metacenter, Greenplum 4.3.x, Oracle 11g, DB2, Win SQL, SQL Developer, pgAdmin, XML Spy, Harvest, Windows 7 Enterprise, Autosys Scheduler, CA Software Change Manager, CuteFTP 9, JIRA, TFS

Confidential, MN

ETL Architect

Responsibilities:

• Assisted in design & build of new data mart for mortgage data
• Performed various duties involved in agile process like Requirements gathering/Grooming stories, Prioritize stories based on feedback from Product Owners
• Create & maintain stories in backlog, identify tasks/resources needed (like ETL, QA, Data Modelling, BI etc.), create tasks for each story & provide a detailed estimate.
• Analyze the data model & finalize the design changes needed with the modeler.
• Design, and delegate the tasks to the developers.

Environment: Informatica PowerCenter 9.1/8.6.1, DataValidator, Informatica Analyst, IDQ, Oracle 11g, MS SQL Server 2008, Flat Files, Toad for Oracle v10.1, PuTTy, WinSCP, MS Visual SourceSafe, Version One Enterprise Fall ‘13, Windows 7, Unix Aix 6, Tidal Enterprise Scheduler 5.3, IBM Congo’s 8, Control - M 6.3, Abinito 2.15, Teradata 13, EMPOWER, HP Service Manager, Business Objects XI R2

Confidential, Cedar Rapids, IA

ETL Technical Lead

Responsibilities:

• Prepare the source to target mapping specification documents for various steps in the warehouse load like source tables to XML, XML to Staging, Staging to Data Warehouse & Warehouse to Data Mart Layer for the Informatica Routines.
• Create & Maintain Informatica Definitions (Source & Target Definitions, Re usable lookups/Mapplets/Transformations).
• Design & Develop Data Mart Layer to be Snow Flake to help reporting using various front end reporting tools (CUBES of MS-SQL SERVER 2005/Business Objects (BO)/MS-Excel Services/POD (Custom Application).
• Perform Change Data Capture ( Confidential ) of source data using informatica Hash Key function & control tables
• Design, develop & test mappings, session & workflows
• Review & Unit Test/Functional test of the mappings developed by the team members.
• Update & Monitor the ETL standards (defined in the ETL Developer Guide) of the code from the team members (queries ran on OPB tables rather than individually checking the session log file names/Transformation Name/ Connection Object Name/ Description Fields).
• Developed shell scripts for data validation, load validation and to archive files.
• Support the nightly cycle & fix if any issues & follow up to improve performance & avoid failures

Environment: Informatica PowerCenter 8.6.1, Oracle 11g, Flat Files, XML, Toad for Oracle v10.1, MS Visio, PuTTy, MS Visual SourceSafe, Windows 2008, Unix Aix 6,CONTROL-M v6.3.01, Stylus Studio 2009, Business Objects XI R2

Confidential, Des Moines, IA

ETL Designer/Developer

Responsibilities:

• Gathering requirements from the marketing and customer service groups.
• Analysis of the business information from various source systems and understand the source data (data profiling), data transformation and data aggregation.
• Designed process to capture needed data points, trigger and event data, metrics, reporting and analysis data.
• Implementation of the design using informatica objects: Sources, Targets and various transformations like Expression, Router, Aggregator and Filter.
• Developed processes to capture events occurred in the operational source systems to feed the CRM PRA conversion stream.
• Designed and developed mappings to automate the process of tracking the status of participants by feeding the captured events along with the context data to the CRM PRA State Machine.
• Designed ETL processes to transform data from mainframe files and other relational sources to DB2.
• Designed and developed reusable transformations, mappings, sessions and mapplets.
• Created and maintained high level design documents, functional documents and technical design documents.
• Tested and implemented the mappings, scripts and sessions in phases with in the timelines.

Environment: Informatica PowerCenter 7.1.3, UDB DB2, Flat Files, Cobol, Quest Central v5.0, Extra Session, MS Visio, Humming Bird, IBM MVS/390, Windows 2000, Unix Aix 5.1