SUMMARY

• Database Developer with 8+ years of IT experience in domains like Finance, Telecom, Banking in highly distributed, real - time, event driven large enterprise systems like CRM MIS and Online Banking.
• Client facing experience in UK, and USA for different implementation assignments.
• Extensive experience in agile development processes.
• Experience inDesigning, Development, Administration, and Implementationof Data Warehouse Data marts withInformatica Power Center 9.x/8.xandOracle Data Integrator 10g/11g/12cas an ETL tool.
• Hands on Informatica 7.x/8.x/9.x installation, configuration, debugging, tuning and administration.
• Systems implementation, operations and its optimization as Informatica admin
• Extensive development experience in PL/SQL.
• Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, development, System testing, Implementation and production support.
• Experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting.
• Expertise in working with relational databases such as Oracle 11g/10g/9i.
• Expertise in documenting the client and technical information in a timely and well-organized manner.

TECHNICAL SKILLS

Programming Languages: SQL, PL/SQL, UNIX, Shell scripts

Databases: Oracle 11g/10g/9i, MS SQL Server 2008/2005.

Tools: Oracle D2K, Oracle Developer Suite, Developer/2000 Forms 5.0/6i,10g & Reports 6i,10g, TOAD, SQL Developer, Pl/SQL Developer, SQL*Loader, SQL*PLUS

ETL Tools: ODI 10g/11g/12c, Informatica Power Center 9.0.1/9.1/8.6

BI Tool: Qlik View, OBIEE 10.1.3.4/10.1.3.3

Operating Systems: Windows XP/2000, UNIX

Web Technologies: HTML, XML

Office Applications: Word, Outlook, Power point, Excel

PROFESSIONAL EXPERIENCE

Confidential

ETL Lead Developer

Responsibilities:

• Involved in business analysis and technical design sessions with business and technical staff to develop data models, requirements document, and ETL specifications.
• Involved in designing the system and designing the logical database design using ER Studio.
• Involved in designing the physical database system.
• Involved in data quality and cleansing of data source.
• Involved in creation of database schema and capacity planning of schema for the warehouse.
• Responsible for migration of applications from dev environment to Test and finally to Production.
• Performance tuning is performed at the Mapping level as well as the Database level to increase the data throughput
• Involved in Informatica power center setup, configuration, user security and administration.
• Design, implement and perform administration functions for Enterprise data integration environments including Informatica PowerCenter, Master Data Management (MDM), and Informatica Data Quality (IDQ)
• Performed the performance and tuning at source, Target levels using Indexes, Hints and Partitioning in DB2, ORACLE and Informatica.
• Developed Reusable transformations and Mapplets.
• Designed the Process Control Table and maintained the status of all the CDC jobs.
• Tuning SQL queries for performance improvement.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Developed UNIX scripting for data feed files for making ready to processing as per System.
• Designed and developed various PL/SQL stored procedures to perform various calculations related to fact measures.
• Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.
• Prepared technical designs for Informatica mappings.
• Developed mapping for fact loading from various dimension tables

Environment: Informatica 9.0.1, Oracle, PL/SQL, UNIX, Autosys Scheduler, Sub Version Control Tool

Confidential

ETL Lead Developer

Environment: Informatica 9.1, PL/SQL, Oracle 11g, SOA

Responsibilities:

• Data modeling design to handle each scenario happens at FileOnBording Process.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Managed the Informatica domain and Application Services including PowerCenter and IDQ.
• Managed and administered the Informatica PowerExchange for source environments
• Worked on converting some of the PL/SQL scripts into Informatica mappings.
• Worked with filter transformations and flat files to identify source and target bottlenecks
• Worked with various transformations including router transformation, update strategy, expression transformation, lookup transformation, sequence generator, aggregator transformation and sorter transformation
• Work with peers from various functional areas to define IT wide processes like code reviews, unit test documentation and knowledge sharing sessions.
• Developing Informatica Mapping and workflows for the different stages of E-T-L.
• Analyzing the Debugging the workflow, sessions by utilizing the session’s log.
• Developing packages, procedures in PL/SQL for Post data load validation.
• Assigning Batch Id and Record Id for unique identification of each file and records in it.
• Tuning SQL queries for performance improvement.
• Collaborate and work with business analysts and data analysts to support their data warehousing and data analysis needs.
• Worked on different types of sources like flat files (fixed width as well as delimited) and relational database (Oracle).

Confidential

Sr. ETL Developer

Environment: Informatica 9.0.1, Oracle 10g/11g, PL/SQL, UNIX, Toad 9.0.

Responsibilities:

• Designed DW tables and Mappings.
• Developed mappings of ETL processes.
• Converted the PL/SQL Procedures to Informatica mappings and at the same time created procedures in the database level for optimum performance of the mappings.
• Extensively developed and modified PL/SQL packages, procedures, functions, triggers
• Developed SCD type2 loading process using Informatica.
• Reusable transformations and Mapplets were built wherever redundancy is needed.
• Designed the Process Control Table that would maintain the status of all the CDC jobs and thereby drive the load of Derived Master Tables.
• Documented and maintained ETL specifications and processes.
• Experience in using SQL* loader to load data from flat files to the database tables in Oracle.
• Coded SQL/PL-SQL, SQL* Loader and Unix Shell scripts for high volume data warehouse instances.
• Maintained data integration measures and reviewed peer codes and requirement.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Data Warehouse.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time

Confidential

Sr. ETL/ODI Developer

Environment: ODI 10g/11g, OBIEE 10g, PL/SQL, Oracle 10g/11g, SQL Server 2005, UNIX, Toad 9.0.

Responsibilities:

• Designed DW tables, scripts and ODI Extracts.
• Documented and maintained ELT specifications and processes.
• Maintained data integration measures and reviewed peer codes and requirement.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Data Warehouse.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Coded SQL/PL-SQL, SQL* Loader and Unix Shell scripts for high volume data warehouse instances.
• Used Security Manager for managing privileges to the users.
• Interacted with BI team during design and development of facts and dimensions to accommodate all the reporting requirements.
• Ensure availability and security of the analytic data and system
• Develop and implement Metadata, Reports and Dashboards using the OBIEE tool
• Perform testing sessions for reports and dashboards
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time

Confidential

Sr. Oracle Developer

Environment: Oracle 10g, Oracle Forms & Reports 10g, SQL plus, PL/SQL, Windows XP/NT, Toad 9.0, Putty Connection Manager, WinSCP

Responsibilities:

• Designed various interactive UI and modified various Forms.
• Extensively developed and modified PL/SQL packages, procedures, functions, triggers.
• Designed & developed various reports.
• Prepared SQL scripts to validate the data in the Report.
• Participated in regular project status meetings related to testing.
• Performed Report testing by validating layout, data in the report.
• Developed and modified PL/SQL packages, procedures, functions, triggers
• Performed Change Request whenever the customer needs to change their existing Business Rules or they may integrate a new rule.
• Knowledge sharing with team members.
• Creating and maintaining project documents.
• Worked on SQL scripts to load data in the tables.

Confidential

Oracle PL/SQL Developer

Environment: Oracle 10g/11g, PL/SQL, SQL Developer, Windows XP/NT, UNIX, Toad 9.0, Clear Case

Responsibilities:

• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per User requirements to make new enhancements.
• Developed and designed UI using Oracle forms developer tool.
• Designed and developed interfaces b/w Java (frontend) and Oracle (backend) using PL/SQL.
• Designed & developed reports.
• Prepared SQL scripts to validate the data in the Report.
• Participated in regular project status meetings related to testing.
• Performed Report testing by validating layout, data in the report.
• Performed Change Request whenever the customer needs to change their existing Business Rules or they may integrate a new rule.
• Seamless Client / Onsite Co ordination with the Offshore Team to proactively identify and mitigate risks / issues.
• Worked on SQL scripts to load data in the tables.
• Performed UAT.
• Source Code Version Controlling.
• Handling Problem Requests of end users.

Confidential

Oracle PL/SQL Developer

Environment: Oracle Forms & Reports Developer 6i/9i/10g, Oracle10g/9i, PL/SQL, Qlik View.

Responsibilities:

• Developed and modified PL/SQL packages, procedures, functions, triggers, reports as per User requirements to make new enhancements.
• Developed User Interfaces.
• Designed & Developed Procedure based forms.
• Designed, developed and tested various Outstanding/CN/DN/Adjustment reports.
• Involved in Performance tuning which included creating indexes and modifying tables using explain plan utility.
• Prepared SQL scripts to validate the data in the Report
• Performed Report unit testing by validating layout, data in the report.
• Creating and maintaining project documents. Ensuring appropriate use of methods, tools and techniques within the team.