SUMMARY:

• 9+ years of IT experience in Enhancements/ Development projects as a data warehousing Professional.
• E xp e rie n ce in working with Oracle S QL & PL / S QL & Informatica Power Center & Informatica Intelligent Cloud Services.
• E xp e rie n ce w ith Bu s ines s In te llige n c e t ools n am e ly SS R S, Qli k vi ew, Salesforce CRM.
• Handling the Lead role for the past 3 years. Single Point of Contact for all ETL related deliveries and data modeling for warehouse projects.
• Expertise in Requirement Analysis, Functional Analysis, Design, Development, Implementation, Testing, Debugging, Productions Support, Informatica PowerCenter Administration and Maintenance of various Applications.
• Participated in Agile team activities including daily standups, sprint planning, PSI planning, product demos.
• Implemented applications in both SDLC (System Development Life Cycle) and agile models with effective implementations and timely delivery.
• Highly proficient in ETL using Informatica Power Center 10.1, 9.5, 9.1/8.x and good working skills on Informatica tools such as Designer, Workflow Manager, Workflow Monitor, Debugger and Repository Manager.
• Strong expertise in designing and developing Business Intelligence solutions in staging, populating Enterprise Data Warehouse (EDW), Data Marts / Decision Support Systems using Informatica Power Center 10.x/9.x/8.x Versions.
• Extensive experience working with databases like Oracle, MS SQL Server and Netezza
• Experience in Performance tuning of Informatica (sources, mappings, targets and sessions) and tuning the SQL queries.
• Experience in scheduling the Informatica workflows or Oracle Scripts using $Universe and Informatica Scheduler.
• Extensive experience in Data Warehousing Concepts like Star Schema, Snow Flake Schema, Fact Table, Dimension Table, and Dimension Data Modeling.
• Proficiency in using different sources and transformations, partitions in informatica.
• Experienced in working on Oracle 11g/10g database systems.
• Expertise in creating stored procedures, triggers, functions, packages, views, PL/SQL Collections, cursors and optimizing query performance
• Effectively made use of all database objects like creating Tables, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, primary keys, indexes, constraints, packages, sequences, grants and synonyms & Query Re - Write.
• Extensive experience with Oracle 11g which includes Bulk Collect and Bulk Bind.
• Experience in Performance Tuning using various types of Hints, Partitioning and Indexes, Used Explain Plan to monitor execution path and to decide on which hints to use.
• Have working Knowledge in Oracle's built in Packages.
• Working experience in Customizing, Bug Fixing and Source Code maintaining of Oracle Database.
• Experience on Logical / Physical Data Models, Conceptual Design & Data Architecture using microsoft Viso.
• Good experience in UNIX shells scripting with sh, bash, csh and ksh shells.
• Efficient in writing complex SQL queries, hierarchical queries, use of analytical functions, regular expressions.
• Experienced in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, Data Pump utility and batch processing.
• Experienced in scheduling the jobs using $Universe and Crontab and monitor the batch processing.
• Experienced in backend database development using tools SQL*PLUS, Oracle Designer, Oracle TOAD and PL/SQL Developer.
• Have good experience in SSRS reporting.
• Effectively participated in End-to End Data Warehouse testing (UAT, SIT)
• Understanding in Web D e v e lopm e n t techn ologie s like J A VA, Salesforce Apex code, REST and SOAP UI, Splunk Queries.
• Ve ry go od und e rs tandin g o f th e d at a m od e ling an d Big d at a ( H adoo p, Pig, H i v e ) con c e p ts.
• Experience working with onsite-offshore model projects while working closely with clients and team members.
• Excellent communication skills and analytical skills and ability to Lead & perform as team player.
• Strong problem-solving skills, committed team player with excellent interpersonal skills
• Domain Experience: Diversified experience in multiple domains like Healthcare,Telecom and insurance.
• Awarded ' Confidential gem’ dedication to work and crucial and timely project delivery.

PROFESSIONAL EXPERIENCE:

Confidential, Louisville, KY

ETL Lead

Responsibilities:

• Understanding design documentation & assist data base mapping fields.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Experience in Supporting & Developing in Data Warehouses.
• Debugging, Coding and tuning complex SQL statements and scripts.
• Experienced in debugging the Informatica, IICS and Saleforce Debug Logs.
• Expericed in working on Incidents within SLA and procvide RCA.
• Monitoring and Fixing the Informatica, IICS Jobs, Cipher cloud and Salesforce Cloud Issues.
• Involved in Data Extraction from Oracle, SOQL DB, Flat files.
• Writing Unix scripts for handling the source data and mapping.
• Coordinating the source, target teams, dev teams or admin teams for any data issues or outages.

E n vi ronm en t: Informatica, Oracle pl/sql, Unix shell scripting, SSRS

Confidential, Louisville, KY

S en i o r ETL Developer

Responsibilities:

• Develop design documentation & assist data base mapping fields.
• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Developed Oracle SQL Queries and Scripts to process the data.
• Involved in Data Extraction from Oracle, SQL server, Flat files.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules as per the business requirement.
• Conduct code walkthroughs and review peer code and documentation.
• Writing Unix scripts for handling the source data and mapping
• Experienced in data migration techniques using Oracle External Tables, SQL* Loader, Import/Export, Data Pump utility and batch processing.
• Providing support and quality validation thru test cases for all stages Unit and Integration testing.
• Developed several SSRS Reports.

E n vi ronm en t: Informatica, Oracle pl/sql, Unix shell scripting, SSRS

Confidential, Louisville, KY

S en i o r ETL Developer

Responsibilities:

• Interact with the Product Owners to get a brief knowledge of business logics.
• Participate in Agile team activities including daily standups, sprint planning and product demos, etc. Worked with the Product Owner to understand requirements and translate them into the design, development and implementation of ETL process using Informatica 9.x.
• Developed Oracle SQL Queries and procedures, packages and functions to process the data.
• Involve in Data validating, Data integrity, performances related to DB, Field size validation, check Constraints and Data Manipulation and updates by using SQL.
• Implementing various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy for HEDIS.
• Responsible for determining the bottlenecks and fixing the bottlenecks with performance tuning.
• Writing Unix scripts for handling the source data and mapping.
• Experience in scheduling the jobs using $Universe and Crontab and monitor the batch processing.
• Experience in backend database development using tools SQL*PLUS, Oracle Designer, Oracle TOAD and PL/SQL Developer.

E n vi ronm en t: Informatica, Oracle pl/sql, Unix shell scripting,

Confidential,

Lead Developer

Responsibilities:

• Designed and implemented appropriate ETL mappings to extract and transform data from various sources to meet requirements
• Developed Oracle SQL Queries and Scripts to process the data.
• Involved in Data Extraction from Oracle, SQL server, Flat files.
• Defining a suitable architecture for data integration from multiple, disparate data sources.
• Analyzing source systems and creating a Best Practices mapping to the target database schema.
• Defining and implementing the required business transformation rules and logic (ETL development).
• Designing and developing exception handling and data cleansing / standardization procedures.
• Optimizing ETL performance.
• Assessment and recommendation of ETL/other tools.

E n vi ronm en t: Informatica, Oracle pl/sql, Unix shell scripting, Data pump, Fast Reader

Confidential

Developer

Responsibilities:

• To Support vendor product Ranger developed by SUBEX.
• To identify fraudulent customers and to facilitate immediate action.
• Events are configured, upon breaching of which alarms are generated by Ranger.
• Involved in developing new enhancements
• Utilized SQL*Loader to load flat files to database tables.
• Responsible for analysing & Identifying the causes for the defects in the project and providing the corrective & preventive actions if required.
• Developed several Unix shell scripts to automate data extraction using VI editor, SQL scripts and PL/SQL scripts. And Korn SHELL scripts for automation of jobs.

TECHNICAL SKILLS

ETL: Informatica 9.1/9.6/10.1

Databases: Oracle-9i, Oracle 10g, Oracle 11g, MS SQL Server

Languages/ Utilities: Oracle SQL, PL/SQL, UNIX Shell Scripting,TOAD

Operating Systems: Windows XP/7/8, Mac, Linux, Unix

Reporting Tools: SSRS, QlikView

Functional Domain: Health C are, Telecom