SUMMARY

• Around 11 years of experiencein teh IT Industry with specialization in Data Warehousing & Business Intelligence area as Data Architect, ETL Architect and ETL Developer.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data mapping, ETL Development, metadata management, data migration and reporting solutions) me have been key in delivering innovative database /data warehousing solutions to teh Retail, Automotive, Media and Finance Industries.
• Extensive experience in managing support and development teams.
• Experience in project implementation using Agile, Waterfall methodologies.
• Experience in all aspects of project development life cycle including Analysis, Design, Development, Implementation, Modeling, Testing, Deployment and supporting for various ETL/DWH projects.
• Worked on Salesforce implementation using Informatica
• Expertise in design and implementation of SCD - Slowly changing dimensions.
• Extensive experience with Data Extraction, Transformation, and Loading (ETL) from multiple data sources Oracle, DB2, SQL Server, Salesforce.com, Flat files and XML files into Enterprise Data Model.
• Broad Experience in Database Development including effective use of Database objects, Explain Plan, Hints, Indexes, Table Partitions, Sub Partitions, Materialized Views and Temporary tables
• Expertise in Architecture, Development of SQL, PL/SQL Stored procedures, Packages and Functions, Query and Jobs tuning for better performance.
• Extensively worked with Teradata utilities likeBTEQ, Fast Export, Fast Load, Multi Loadto export and load data to/from different source systems including flat files.
• Extensive experience in production support in resolving tickets of severity level Critical (sev1) and Urgent (sev2) and troubleshooting issues arising post deployment.
• Experienced in writing Unix Shell Scripts for teh automation of ETL processes and using schedulers like Autosys and Control-M.
• Experience in migration projects across different tools and versions. Implemented migration project from SAS to Ab Initio and Informatica upgrade(8.6 to 9.5)
• Involved in transition of 30 applications from Client and lead BI team across multiple technologies.
• Superior communication skills, strong decision making and organizational skills along with outstanding analytical and problem solving skills to undertake challenging jobs. Able to work well independently and also lead a team by helping to troubleshoot technology and business related problems.

TECHNICAL SKILLS

ETL Tools: Ab Initio (GDE 3.1.7.1, Co>Op 3.0.4.0) and Informatica 8.x/9.x

OLAP: OBIEE 11g

CRM: Salesforce.com(SFDC)

Schedulers: Control-M, Autosys and Maestro

RDBMS: Teradata 12x/14x, Oracle 11g/10g/9i/8i, SQL Server, DB2, Netezza and Informix

DB Tool: SQL*Loader, TOAD, Teradata SQL Assistant, SQL plus and WinSQL

Scripting Languages: SQL, PL/SQL, XML and UNIX Shell Scripting

Operating Systems: UNIX (HP-UX, IBM AIX 4.2/4.3), Windows 2003/2000/XP/98/7

Data Modelling: E/R Modeling, Dimensional Modeling (Star, Snowflakes Schema Modeling)

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Senior Informatica Developer

Responsibilities:

• Involved as primary on-site ETL Developer during teh analysis, planning, design, development, and implementation stages of project
• Prepared Data Mapping Documents and Design teh ETL jobs based on teh Requirement Document.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis.
• Reviewed data mapping, design documents, Informatica mappings and Unit Test Cases.
• Designed and developed different slowly changing dimension procedures for multiple data extracts based on business requirements
• Extensively worked with Netezza database to implement data cleanup, performance tuning techniques.
• Daily stand up meeting on multiple sprints as part of agile project.
• Extracted data from SalesForce.com(SFDC) using Informatica ETL mappings/SQL scripts and loaded to Data Store Area
• Created complex Informatica mappings using Unconnected Lookup, joiner, Source Qualifier, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations to extract, transform and loaded data mart area
• Informatica Migration experience(8.6 to 9.5)

Environment: Informatica 8.6 /9.5, Oracle12c, Salesforce.com, Netezza, Shell Scripting, AIX UNIX and Autosys

Confidential, Lisle, IL

BI Support Lead/ Senior Informatica Developer

Responsibilities:

• Met with business users to understand teh business process and gather requirements.
• Integration of various heterogeneous source system data to Oracle, SQL*Server, Teradata, DB2 to Oracle using Power Center
• Extensively created Source to Target Mapping documentation using Data Mapping documentation
• Extensively designed ETL Logic designs and implemented teh same in Power Center Mappings along with Oracle SQL, PL/SQL, Unix Shell Scripting, Troubleshooting of ETL
• Definition and Design of Audit Control Logic, Error/Exception Handling logic and implemented teh same in Power Center Mappings
• Extensively used Power Center, Source Analyzer, Mapping Designer, Transformation Developer, Mapplet Designer, Repository Manager, Task Developer, Workflow Manager and Workflow Monitor.
• Define & create various UNIX Korn Shell Scripts and used them in Informatica Mappings in Pre and Post session events.
• Define & Create Re-usable mappings, mapplets, transformations, mapping parameters, session variables and used it in Informatica mappings for better performance
• Involved in teh ETL development and provide teh technical assistance to teh team.
• Work with QA team on defining test approach
• Handling L2 and L3 support and make sure meet teh SLA’s
• Performance tuning of teh existing long running sessions/jobs.
• Technical lead responsible to come out with teh design patterns to load teh data in data warehouse (ETL & ELT).
• Technical SME, responsible for Enterprise Technical Governance for all teh Business intelligence projects across organization
• Lead teh team to develop teh mappings with complex logic applying various transformations.
• Preparing teh Visio diagrams for Control M jobs.
• Prepared High Level Design of Source Data Analysis, ETL Process flow, Error Handling, Re-startability and Auditing.
• Mentoring teh team members on Data warehouse, ETL, Database, UNIX concepts.
• Reviewed data mapping, design documents, code and Unit Test Cases.
• Created multiple Dashboards, Reports, Agents and RPD in OBIEE 11g.

Environment: Informatica 8.6, Oracle 10g/11g, Informix, SQL Server, DB2, Teradata 14, OBIEE 11g, XML, Shell Scripting, Teradata SQL Assistant, AIX UNIX and Control-M.

Confidential, Greenville, SC

Senior AbInitio Developer

Responsibilities:

• Lead and co-ordinate ETL efforts of teh project.
• Designed teh entire Purge project and automated teh process.
• Analyzed business needs and documented functional and technical specifications based upon user requirements with extensive interactions with business users.
• Creating effort/duration estimates and deliverable lists for proposed project.
• Design walk through with teh internal and external stake holders of teh project.
• Using both teh approaches called ETL and ELT to load teh data into target tables.
• Designed and developed ETL processes using AbInitio to load data from Flat Files (Fixed Width/Delimiter) and Mainframe datasets to landing schema/database.
• Extensively worked on AbInitio Tool using various components likerollup, scan, normalize, denormalize,join, reformat, merge etc.
• Worked with multi file system and flat UNIX files processing.
• Developed dynamic graphs to load data from data sources into tables.
• UtilizedParallelismthrough different partition methods to optimize performance in a large database environment.
• Involved in teh development of AbInitio graphs and also modified them for better performance.
• Implemented handling of reject records automatically by sending them to teh users for maintaining data integrity and reduce teh job failures.
• Implemented only delta load logic vs teh entire refresh of teh data mart tables.
• Created test scripts for system and regression testing.
• Created ETL best practices and Developers guide.

Environment: AbInitio, Oracle 9g, Shell Scripting, SQL-Loader, Toad, AIX UNIX and Maestro.

Confidential

Senior Ab Initio Developer

Responsibilities:

• Provided Technical support to teh team as Ab Initio developer. Addressed best practices and productivity enhancing issues.
• Participated in Design walk-throughs, Test case reviews with attention to performance, stability, scalability and testability and provide inputs for Go/No Go decision.
• Provide clear communication to project team and managers.
• Worked in teh Data Management Team on Data Extraction, Data Cleansing, Data Validation and loading Target tables.
• Developed number of Ab Initio Graphs based on business requirements using various Ab Initio Components such as Partition by Key, Reformat, Rollup, Join, Scan, Normalize, Read Multiple Files, Update Table etc.
• Developed Ab Initio graphs to fetch data from Oracle, Teradata, Flat Files and mainframe Files.
• Developed jobs to load data for Teradata using FAST Load, Multi Load and T-Pump techniques.
• Involved in Re-designing teh load flow by eliminating teh intermediate steps and Optimizations in order to get significant ETL conversion performance gains.
• Wrote BTEQ scripts to transform data from landing to staging.
• Performance tuned and optimized various complex SQL’s.
• Implemented SCD type2 for History maintenance.
• Responsible for code migration, Code review, test plans, test scenarios, test cases as part of Unit and system testing.
• Automate teh Ab Initio jobs using UNIX script in teh scheduler.

Environment: Ab Initio 2.14, Oracle 9i, Teradata 12, Netezza, CA-7, Shell Scripting, PL/SQL, Toad, SQL-Plus, Teradata SQL Assistant, HP UX, Data Modelling and Autosys.

Confidential

Ab Initio Developer

Responsibilities:

• Actively participate in understanding business requirements, analysis and designing Data Migration Process.
• Understood teh existing SAS code and developed Ab Initio graphs to implement teh same logic as part of Re-engineering project.
• Identified teh gaps in teh existing system and suggested data model changes for teh better visibility of teh data to teh business users.
• Created AS-IS and TO-BE design documents which served as reference for teh developers in teh migration project.
• Created test cases for unit testing and integration testing and also created implementation plan.
• Created Ab Initio graphs for loading summary tables.
• Created jobs to load teh history data.
• Implemented auditing and reconciliation procedures to ensure data integrity.
• Implemented phasing and checkpoint approach in ETL process to prevent data loss and to maintain uninterrupted data flow against process failures.
• Worked on preparing AUTOSYS scripts for scheduling jobs in Prod environment.
• Extensive experience on converting copybooks from FDR and reading teh EBCIDIC files.
• Used Ab Initio EME for Check-In/Check-Outs and Version control.

Environment: Ab Initio 2.14, Oracle 8i, SAS, Python 3.3, Shell Scripting, PL/SQL, Toad, AIX UNIX and Autosys.