SUMMARY:

• Experienced Senior DWBI (ETL) Developer; worked for Health Care, Banking, Finance, Brokerage and Telecom Domains
• 14+ years of experience in software requirements, Architecture, design, development, implementation, maintenance and Production Support.
• 10 years of experience in Data Warehousing and Business Intelligence using Informatica Power Center.
• Managed and executed all phases of a Data warehouse project life cycle during the tenure that includes Scoping Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance, Application Support for end - to-end IT solution offerings in Datawarehousing, OLAP & BI space
• 4 Years of experience in maintaining the various application’s on Legacy Mainframes.
• Extensively used SQL and PL/SQL to write stored procedures, Functions Packages and Triggers.
• Knowledge on Relational Databases ORACLE, TERADATA and DB2 and SQL Server.
• Experience in Agile (Iterative Model) software development Process.
• Worked as Scrum Master and lead a scrum team of 10 people.
• Extensively used UNIX Shell scripting.
• Experience in Star and Snow Flake schema design and De-normalization techniques.
• Good exposure in Software quality process (QMS) consists of all the phases.

TECHNICAL SKILLS:

Operating Systems: WINDOWS, UNIX (Sun-Solaris), MVS Z/90.

ETL Tools: Informatica Power Center.

Languages: SQL, UNIX Shell Scripts. PL/SQL, COBOL, CICS, JCL, SAS on MVS.

Database: DB2, ORACLE, SQL Server, Teradata, VSAM.

Tools: /UTILITIES: TOAD, Remedy 7.6, HPSM, Rally, SQL developer, T-SQL, Visio, Harvest., BTEQ

Scheduler: CA-7 CA-11, ESP, AUTOSYS,CONTROL-M.

Reporting Tools: Cognos 8.4.1, HYPERION.

PROFESSIONAL EXPERIENCE:

Confidential (Greenwood Village, CO)

Lead ETL Developer

Responsibilities:

• Worked in various roles as Tech Lead, Architect, Scrum Master for the different Risk Management project and Informatica Upgrade to 10.1
• As lead application designer across multiple key initiatives within many IHUB and Risk Management Domain.
• Worked closely with various business partners, Enterprise architects/teams, vendors and built effective working relationship with them.
• Automated the file transfers for CSR file submission.
• Worked with Confidential Information Protection (CIP) team and created the CIP documentation for various new risk projects involving External vendors Altegra, Infogix, Wakely and CMS.
• Designed and automated data copy of the masked data to lower environments.
• Worked with Informatica and resolved issues in reading large XML files using Informatica B2B DTS transformation.
• Created the proto type to parse and load the CMS provider JSON files using Oracle JQURIES.
• Designed and implemented the technical solutions for various Risk projects which include external vendors and applications.
• Code and design reviews.
• Performance tuning involving Informatica objects and Database Quires.
• Reviewed the technical and non-technical design with external applications.
• As a Scrum master lead a scrum team of 10 people.
• Coded and designed the complex ETL mappings.
• Created reusable scripts to transfer the files across platforms (UNIX, Windows, Mainframes)
• Worked with DBA’s on various performance issues.

Confidential (Aurora Co)

DWBI Senior Consultant

Responsibilities:

• As a Senior ETL Consultant, created the mappings, assisted and lead a team of Junior Developers, did code reviews, set-up the ETL environment, did planning, coordinating design, accountable for doing designs, development and Implementation support as required.
• Designed Informatica Mappings as per business requirements using various transformations to implement simple and complex business logic.
• Created high level design document and presented all design options for design review of ETL solutions.
• Handle the most complex design and development tasks and provide mentoring and guidance to other ETL developers.
• Developed BTEQ scripts to export, import and transform the data.
• Analyze user requirements, procedures and problems to automate processing and improve existing computer applications, data models, reports and systems. Perform custom program development and implementation, system analysis, design, testing and coding.
• Worked closely with Modelers and BA’s for in DB and ETL designs.
• Worked closely with BA’s to convert the Business requirements into ETL design document.
• Worked with DBA’s to partition the tables in Claims DW.
• Designed Sales and Demand reporting (star schema).
• Worked closely with Cognos team to test and model the SDR project.
• Designed and re-wrote the SAS All Claims into Informatica.
• Developed the Shell scripts to preprocess and archive the flat files.
• Created jobs to create and add objects to the deployment groups.
• Used Tivoli to schedule the Informatica jobs.
• Created the mapplets for MRN validations.
• Created parsers using Informatica expressions to parse the delimited strings.
• Created the mapping to parse the pharmacy D.0 file and load them to relational tables.
• Created the mappings to parse HL7 ADT messages and load them to relational tables.
• Used T-SQL to analyze the Teradata data.
• Performance tuning of Mappings and SQL’s.
• Coach and assist other developers.
• Created mappings to load Health Registry Data mart.
• 24 Hour on-call support for trouble shooting and resolving issues in Production.
• Designed and developed the SDR (supply and demand reporting) data mart.

Confidential (Denver Co)

Lead Software Development Engineer

Responsibilities:

• As a Lead DWBI Engineer, I assisted and Lead a team of Junior Developers, did code reviews, set-up the ETL environment, did planning, coordinating design, accountable for doing designs, development and Implementation support as required.
• As an Architect created the Mapping templates using the “Mapping Architect for Visio “, Used the template to stage 100+ tables.
• 24 Hour on-call support for trouble shooting and resolving issues in Production.
• Created the Templates for the flat file processing.
• Developed Oracle stored Procedures.
• Used PVCS to migrate the non-Informatica objects across environments.
• Used Informatica Partitioning options to Performance tune the workflows.
• Used PM EROOR table to log the errors.
• Worked on both Iterative (Agile Software Development) and the Waterfall Model.
• Used Mainframes DB2 tools (Platinum, File-aid) to analyze the data.
• Worked as an analyst to create source to target mappings, Volume Metrics and DDL’s.
• Experience in creating Informatica web-services.
• Review and analysis of the existing systems.
• Used Trillium tool for address cleansing.
• Created Unix Shell scripts/ Mapping’s to automate the meta data movement to different environments.
• Working with Analysts for Business requirements.
• Designed Informatica Mappings as per business requirements using various transformations to implement simple and complex business logic.
• Created high level design document and presented all design options for design review of ETL solutions.
• Handle the most complex design and development tasks and provide mentoring and guidance to other ETL developers.
• Used Infomatica IDQ Data Quality for profiling.
• Used Control-M to Schedule the jobs.
• Used SQL tools like TOAD SQL*PLUS for unit testing, data validation and develop Stored Procedures.
• Involved in Code reviews.
• Used Team Based Development as change Management Tool

Environment: Informatica 8.6, Oracle 10.2, MVS, Flat files (GDG) on UNIX/Mainframes/Windows, Unix, and Windows XP, TOAD, SQL*PLUS, ERWIN, AUTOSYS, Shell Scripts and Control-M, DB2, Trillium, Caliber, Remedy.