PROFESSIONAL SUMMARY:

• Database Developer with 9 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.
• Experience in agile development processes.
• Strong experience in writing SQL queries, PL/SQL Code and Performance Tuning.
• Excellent Techno Functional experience in Informatica Power Center, Oracle Data Integrator.
• Expertise in Data Warehouse/Data mart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, development, System testing, Implementation and production support.
• Experienced in tools- Informatica Power Center, Oracle Data Integrator 10g/11g and OBIEE 10g.
• 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, DB2, Teradata, MS SQL Server.
• 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, JavaScript

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

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.6/9.1/8.6, IDQ, Talend

Frameworks: Big Data/ Hadoop, Agile

BI Tool: Qlik View, OBIEE 10.1.3.4/10.1.3.3

Operating Systems: Windows XP/2000, UNIX, LINUX

Web Technologies: HTML, XML

Office Applications: Word, Outlook, Power point, Excel

PROGRAMS ATTENDED: Finance and Health Care Domain s attended.

Technical s attended on: Big Data, Hadoop and Talend ETL

PROFESSIONAL EXPERIENCE:

Confidential

ETL Developer

Responsibilities:

• Prepared technical designs for Informatica mappings.
• Developed mapping for fact loading from various dimension tables
• Developed UNIX scripting for data feed files for making ready to be processing as per System.
• Unit testing of the mappings.
• Involved in Functional Testing, Integration Testing, Performance Testing.
• Defect tracking through Quality Center and SharePoint portal.
• Created and executed mapping using Slowly Changing Dimensions Type 2, Slowly Growing Target, and Simple Pass Through.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Tuning SQL queries for performance improvement.
• 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 data quality and cleansing of data source.
• Performance tuned and optimized various complex SQL queries and PL/SQL code.
• Writing PL/SQL packages, procedures for sub-programs being called from ETL.
• Involved in creation of database schema and capacity planning of schema for the warehouse.

Environment: Informatica 9.6.1 and Informatica 10.2.0, Oracle, UNIX, Autosys Scheduler, Sub Version Control Tool, SQL, PL/SQL

Confidential

ETL/ PLSQL 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.
• Performance tuned and optimized various complex SQL queries and PL/SQL code.
• Writing PL/SQL packages, procedures for sub-programs being called from ETL.
• Involved in creation of database schema and capacity planning of schema for the warehouse.
• Unit testing of the mappings.
• Involved in Functional Testing, Integration Testing, Performance Testing.
• Responsible for migration of applications from dev environment to Test and finally to Production.
• Tuning SQL queries for performance improvement.
• Developed UNIX scripting for data feed files for making ready to processing as per System.
• Continuous support through conference calls with mapping team and development team to provide accurate data in new environment.
• Preparation of test cases to validate the output data generated using the mapping documents.
• Defect tracking through Quality Center and SharePoint portal.
• 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, UNIX, Autosys Scheduler, Sub Version Control Tool, SQL, PL/SQL

Confidential

ETL/ PLSQL Developer.

Environment: Informatica 9.4.1, SQL, PL/SQL, Oracle 11g, SOA, Autosys

Responsibilities:

• Data modeling design to handle each scenario happens at FileOnBording Process.
• Develop design document which mentions the approach, business rules, validations being used in developing interfaces, packages, load plans.
• Developing Mapping and workflows for the different stages of ETL.
• Analyzing the Debugging the workflow, sessions by utilizing the session’s log.
• Developed mappings of ETL processes.
• Implemented CDC using mapping variables.
• Developed SCD type2 loading process in Informatica.
• Extensively involved in creating PL/SQL objects i.e. Procedures, Functions, and Packages.
• Extensively involved in debugging the existing PL/SQL objects.
• Extensively used SQL*LOADER and UTL FILE to load data from flat files obtained from various facilities every day.
• Tuning SQL queries for performance improvement.
• Involved in peer review, unit testing etc.
• Responsible for scheduling and monitoring ETL jobs.
• Involved in writing and maintaining batch jobs.
• 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.
• Worked on different types of sources like flat files (fixed width as well as delimited) and relational database (Oracle).

Confidential

ETL/ PLSQL Developer

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

Responsibilities:

• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Created database objects, tables, triggers, views, stored procedures, functions, Packages, joins and hash indexes in Teradata database.
• Extensively worked with Teradata utilities like Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Applied business logic to load the data into Data Warehouse.
• Writing large/complex SQL queries.
• Monitoring and Tuning SQL queries using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Created Materialized views, Ref cursors, Bulk processing, collections, nested tables.
• Performed bug verification, release testing and provided support for Oracle based applications.
• Involved in performance tuning the existing objects.
• Designed DW tables, scripts and ODI Extracts.
• Developed mappings of ETL processes.
• Developed SCD type2 loading process using Informatica.
• Documented and maintained ETL specifications and processes.
• Maintained data integration measures and reviewed peer codes and requirement.

Confidential

ETL/ PLSQL Developer

Environment: ODI 10g/11g, OBIEE 10g, SQL, 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

PL/SQL - ETL Developered information like demographic, transaction, billing related information etc. are being received as files, which is processed under ETL using ODI and then processed data is loaded into target tables.

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

Responsibilities:

• Responsible for scheduling and monitoring ETL jobs.
• Involved in writing and maintaining batch jobs.
• Developing packages, procedures in PL/SQL for Post data load validation.
• Designed DW tables, scripts and ODI Extracts.
• Customized Knowledge Modules for better performance of interfaces.
• Developed dynamic ODI mappings.
• 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.
• Maintained data integration measures and reviewed peer codes and requirement
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time

Confidential

Oracle PL/SQL 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 Coordination 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.