PROFESSIONAL SUMMARY:

• Over 9 years' experience in the IT Industry as an Sr. Lead Oracle/ETL Developer in Requirement gathering, Analysis, Design, Development , Migration and Customization of Business Applications using the Oracle Relational Database Management System.
• Experience in Dimensional Data modeling using Star Schema/Snowflake modeling, Fact and Dimensions tables. Worked on applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Extensive ETL experience using and maintaining OWB Oracle Warehouse Builder 11.2.0.4, 10.1, 10.2, Oracle Data Integrator 10g/11g, SSIS SQL server Integration Services , Informatica Power Center 8.1/7.1/6.2/5.1, Informatica Power Mart 5.1. Designer, Workflow Manager, Workflow Monitor and Server Manager , Cognos DataManager.
• Worked in ETL process consisting of data analysis, metrics, data transformation, sourcing, mapping, conversion and loading.
• Experience in using Business Intelligence tools such as Oracle Apex 3.1 and Cognos Frame work manager 10.1, Business objects 6.1., SSAS, MS visual studio 2008
• Substantial development experience in creating stored procedures, PL/SQL Packages, Triggers and Functions, cursor's and exception handling.
• Involved in Tuning SQL Statements using EXPLAIN PLAN, SQLTRACE, SQL TKPROF and Procedures for enhancing the load performance in various schemas across databases.
• Expertise in Software Development Life Cycle SDLC of Projects - System study, Analysis, Physical and Logical design, Resource Planning, Coding, Testing and implementing business applications.
• Experience in gathering and analyzing requirements, data analysis, mapping and converting business requirement's into technical requirements and prepare ROM estimate.
• Good experience in interacting and helping business users and translating Business requirements to understandable IT systems requirements.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

ETL Lead Developer

Responsibilities:

• Analyzed the existing setup of OWB 10.1 and provided a detailed plan on migration in various environments.
• Worked with DBA team in gathering the information of the database such as nodes on the database, linux server on which the database is installed etc. Aided DBA team in validating invalid objects during the database migration.
• Configured OWB 11.2.0.4 on two nodes of the cluster for Oracle RAC database on multiple database topology.
• Migrated all the modules by using import export logic of the mdl files from old environment OWB 10.1 to new environment OWB 11.2.0.4.
• Created workspaces, users, configured locations to corresponding control centers in repository browser and configured Workflow manager to execute process flows.
• Worked on testing mappings and process flows by deploying and executing from OWB control centrer manager and through PL/SQL scripts.
• Resolved post migration issues and made the mappings and process flows execute in the new environment. Worked on unit testing mappings and process flows.
• Regularly participated in meetings and coordinate with DBA's, Testing and reporting teams to make sure ETL part is working fine.
• Conducted sessions on installing OWB client and configuring it on user machines. Prepared end to end documentation on configuring, migrating and testing OWB 11.2.0.4.

Environment: Oracle 11.2.0.4, OWB 10.1, OWB 11.2.0.4, SUSE Linux server 9, SQL developer, Linux 2.6.9-67.0.0.0.1.ELsmp x86 64.

Confidential

Oracle / ETL Lead

Responsibilities:

• Worked with end users and business Analysts to gather and understand the requirements. Worked with SME's to understand the existing business process for various solutions under different LOB's.
• Worked on Installing OWB patches, analyzing existing solutions in OWB consisting of complex mappings, data base connections to various sources and processing source files in Linux environment.
• Analyzed existing mappings and modified to improve performance. Created mappings and process flows using aggregator, table function, look up, joiner, filter, pivot etc operators.
• Recreated partitions on existing tables, modified indexes, worked with DBA in rebuilding the statistics. Analyzed existing SQL queries used in reports and tuned by applying hints.
• Developed SSIS packages with control flows and data flows to load data from source to staging and staging to target database using various control flow items, data flow transformations, data flow sources and destinations. Used BI Express for debugging the SSI packages.
• Created stored procedures, functions in oracle for ongoing development projects. Created a stored procedure to invoke the stored procedure in DB2.Developed shell scripts to process the files from various source systems.
• Worked on cleaning the ETLs by removing redundant components and connection issues. Worked on testing the SSIS packages in development and TEST environments.
• Coordinated with offshore team conduct KT sessions, assigning development tasks to team and scheduled review and status meetings.
• Provided tier 2 production support for OWB and SSIS jobs. Worked on various service tickets which involved OWB mapping issues ,SSIS packages, files placing on Linux server, modifying the data in the data files , changing trigger files etc raised using HP service desk.

Environment: Oracle 11g, OWB 10.2, SQL server 2008, MS Visual studio 2008, SUSE Linux server 9, BI Express, HP helpdesk, SharePoint, UC4, sql developer.

Confidential

Sr. Oracle / ETL Developer

Responsibilities

• Oracle data Integrator: Designed Oracle Data Integrator ETL processes to collect and summarize data for reporting from various sources such as sql server, flat files etc.
• Configured ODI Master, Development and Execution repositories. Developed ODI Physical and Logical Topology.
• Worked on creating agents, interfaces, procedures, packages. Generated scenarios and created load plans.
• Worked on creating joins, group by, filter conditions, look ups and used various knowledge modules, features like Journalizing/CDC Near Real Time Extract, Simple and Consistent Mode .Did reverse engineering for the data sources and targets. Migrated ETL structures from development to test to production environments.
• Created and executed test scenarios and data reconciliation routines. Maintained load plan schedules and monitored ODI production processes.

Confidential

Responsibilities

• Developed various OWB objects including Table functions, pluggable mappings, pivot operator, lookups, expressions, complex joins, mappings, locations, and process flows. Deployed all objects in their respective schemas using appropriate deploy option in Control Center via OWB locations.
• Developed ETL mappings to perform business rules. Created OWB locations for multiple oracle sources.
• Applied reconcile option available in OWB to synchronize OWB objects with repository in a multi-user environment to reduce sharing violations. Used generate function available in OWB mapping editor to debug complex mappings and view intermediate data on an object-by-object basis. Performed ETL review to ensure adherence to business standards.
• Worked on implementing slowly changing dimensions SCD , lately arrived dimensions LAD .Configured the mappings by removing the hints to improve the performance.
• Participate regularly in meetings with Business Analysts, clients for gathering requirements and participate in Design review discussions with architects. Work on the items or tasks created on individual contributor basis.
• Cognos Data manager: Modified existing builds and job streams, Worked on creating new catalog, new dimension builds, fact builds, hierarchies and job streams implementing the business logic to retrieve data from sql server database. Worked on using look ups and condition nodes. Worked on creating and importing packages.

Confidential

Responsibilities

• Cognos Framework Manager: Developed and modified BI reports using Report Studio and Query Studio. Worked on developing metadata model in Cognos Framework Manager. Created list, crosstab and drill through reports and Master Detail Reports. Worked on creating cubes using Cognos Transformer. Extensively used prompts, filters, cascading prompts, calculations, conditional variables, multiple queries for data extraction in reports.
• Enterprise Architect EA : Used EA for creating logical work flows, and design documents.
• Worked with Testing team, participated in code walkthrough sessions with production support teams, used subversion svn to check in the objects and Writing design review document and Implementation document.

Environment: Oracle Database 10g/11g Enterprise Edition Release 10.1, ODI 11g,Cognos Data manager, Enterprise Architect, Oracle SQL Developer, SQL Server 2008, Subversion.

Confidential

Sr. ETL Developer

Responsibilities:

• Working with various team members from different projects in Oracle and Informatica platforms.
• Attend meetings with key employees from the client side understand the business process and requirement.
• Communicate with the developers, explain the requirement in technical terms and assign regular tasks to the developers.
• Working on improving the PL/SQL code written by the developers, checking the functionality and perform data validation.
• Working with DBA in creating table spaces, indexes, DB links and privileges.
• Involved in dimensional modeling using logging and nonlogging tables.
• Created work repository. Utilized ODI Designer to develop Interfaces, Procedures, Variable Global/Local and generated necessary Scenarios. Utilized ODI Toolbox to perform a variety of functions including operational functions. Worked on managing scenarios using the operator navigator.
• Create complex mappings such as Expression, Joiner, and Update strategy, Aggregator, Filter and Look up transformations using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, SQL Server, flat files and loading to Oracle target database.
• Worked on implementing complex mappings using slowly Changing Dimension methodology.
• Used workflow manager for session management, database connection management and scheduling of jobs.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed.

Environment: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0, PL/SQL Release 10.2.0.3.0, ODI, Informatica 8.1, Oracle SQL Developer.

Confidential

Sr. ETL Developer

Responsibilities:

• Aided in configuration of development, testing and production environments. Provided Development-level, Testing-level and Production-level support. Developed scripts for transporting metadata from Development to Test and finally to Production environments. Performed data validation at all levels to ensure all objects perform as intended. Developing pre- and post- mapping procedures.
• Connected Oracle to heterogeneous sources to load staging data into a central staging environment.
• SQL Server Stored Procedures: Set up and applied JTDS and JCIFS framework to connect Oracle to SQL Server via JAVA stored procedures. Applied load java procedure to load java procedures to Oracle database. Authored PL/SQL Wrapper procedures in ORACLE to invoke the JAVA procedure to extract data from SQL Server and load it into Oracle staging tables.
• Created Oracle database objects including Tables, Views, Transformations - Packages, Procedures and Functions, Triggers, Java classes, PL/SQL Wrapper procedures, Indexes, various Constraints, and Grants as necessary.
• Developed various OWB objects including pluggable mappings, mappings, lookups, expressions, complex joins, mappings, locations, and process flows. Deployed all objects in their respective schemas using appropriate deploy option in Control Center via OWB locations.
• Worked on creating ODI Master and work repositories. Created new models for the data sources flat files, MS SQL server and Oracle. Worked on creating interfaces, procedures, packages. Worked on creating joins, filter conditions, look ups. Migrated ETL structures from development to test to production environments. Worked on designer, operator and topology navigators. Worked on importing and using various knowledge modules.
• Assisted in defining and developing reports as per the needs of the business. Designed pages, summary and detail reports, interactive reports, and linked pages using Oracle Apex to present underlying data in a comprehensive format. Implemented functionality in web pages using shared components including list of values, page processing including processes and branches. Applied templates and themes to standardize all pages of the front-end application. Created pages with multiple regions and items in Apex. Provided data drill-down and roll-up functionality to better understand and classify data. Managed all visual objects in central dashboard available in web-page format for easy access and linking.
• Built horizontal bar charts, dials, gauges, bulbs with different scales, colors and thresholds available in FusionCharts for easy data interpretation.
• Abided by existing database standards and object naming conventions. Completed documentation and aided in data validation for subject areas. Authored validation checklists that entailed all objects in developed subject areas. Followed logging principles while developing objects.
• Applied JIRA to classify and document status of subject areas development and bug tracking.
• Extensively aided client employees in creating, defining and resolving inconsistencies in user-input location hierarchies and data validity.
• Communicated through meetings, conference calls and emails with key employees to understand the needs of the business and to collect connection information of source databases. Corresponded in a timely fashion with client employees most closely related to a particular subject area to gain clarification, resolve design conflicts, development issues, and to validate a subject area and gain approval on successful completion to transport all objects related to a subject area to the production instance.

Environment: Oracle Database 10g Enterprise Edition Release 10.2.0.3.0, PL/SQL Release 10.2.0.3.0, Oracle Warehouse Builder 10g Release 2 10.2.0.1, ODI 10g, Oracle Application Express Release 3.1.1.00.09, Fusion Charts, JAVA, JDBC, JTDS, JCIFS, Oracle SQL Developer 1.5.1, JIRA, Citrix Met frame XenApp plug-in, Microsoft Project, and Microsoft Office.

Confidential

Sr. PL/SQL Programmer analyst

Responsibilities:

• Involved in Coordinating with DBA in creating and managing tables, indexes, table spaces, triggers, database links and privileges.
• Developed various Oracle sub functions like Stored Procedures, Functions, and Packages as per design documents.
• Changes made to improve performance or process of existing programs, using PLSQL advanced technologies like Collections, NOCOPY, Table partitioning, materialized views and Dynamic Cursors.
• Worked on various data staging methods and worked on loading the data into different databases.
• Developed several Mappings and Mapplets using corresponding Sources,Targets and Transformations
• Extensively used various types of transformations such as Expression, Joiner, and Update strategy, Aggregator, Filter and Look up.
• Developed ETL processes for loading the warehouse and backend data retrieval logic for ad-hoc querying and batch reporting
• Worked with SQL tuner Use of EXPLAIN PLAN, SQL Trace, ANALYZE,HINTS for improving the performance.
• Involved in preparation of detailed design document, test cases and use cases for business requirements.
• Involved in performing technical data analysis, design and development for multiple transactional and warehousing initiatives.
• Developed automated Corn shell scripts to schedule load of flat files on daily, weekly and monthly basis.
• Involved in monitoring production performance issues and providing technical support to end users and other developers.

Environment: Oracle 10 g, SQL server, Informatica power center 7.1, PL/SQL, SQL Plus, SQL Loader, Toad, UNIX HP-UX , Windows, MS Office

Confidential

PL/SQL Programmer analyst

Responsibilities:

• Extensively involved in developing database applications with Oracle 10g.
• Interact with business analysts to develop data modeling techniques and re-structuring strategies.
• Worked on developing various Oracle sub functions like Stored Procedures, Functions, and Packages as per design documents.
• Analyzed the business requirements and involved in developing new logical model.
• Involved in creating custom database Tables, Views, Functions, Procedures, and Packages .
• Worked on creating dimensions, sharing data using viewer.
• Developing reports such as annual reports and customer account reports using Business Objects and Microstrategy.
• Created the reports using Business Objects functionalities like Queries,slice and Dice, Drill down, Functions, Cross Tab, Master/Detail and formulas etc.
• Worked on creating and modifying OLAP work sheets, creation of rational work sheets, scheduling with Oracle Discoverer.
• Worked with SQL workshop to create hypertext linked reports, data entry forms.
• Worked with table partitioning methods when dealing with large databases.
• Involved in Unit Testing of each module and worked on error Management.

Environment: Oracle 10 g, PL/SQL, Business Objects XI/6.1, SQL Plus, SQL Loader, Toad, Oracle Discover, UNIX HP-UX , Windows, MS Office

Confidential

Software Engineer

Responsibilities:

• Extensively involved in developing database applications with Oracle 10g.
• Interact with online team, involved in day to day meetings for understanding and implementing business logic.
• Created various Oracle sub functions like Stored Procedures, Functions, and Packages as per design documents
• Worked on performance tuning Using of EXPLAIN PLAN,SQL Trace, ANALYZE,HINTS
• Worked with SQL workshop to create reports, data entry forms.
• Worked on creating triggers, table partitioning methods when dealing with large databases.
• Worked with testing team on the module and worked on error management.

Environment: Oracle 10 g, PL/SQL, SQL Loader, Toad, Windows