Summary:

• More than 7 years of hands on experience in the analysis, development and maintenance of business applications using Oracle PL/SQL
• Excellent experience of Oracle PLSQL application development Performance tuning and database Administration for large databases > 6 Terabytes
• Worked as Tech Lead/Coordinator for Oracle financial services software Ltd. handled FLEXCUBE development, implementation support for different regions like Caissecentrale Desjardins.
• Worked as IT Analyst for sales and channels program for Cisco systems on behalf of Tata Consultancy Services.
• Good working experience in database programming on Oracle SQL/PLSQL and/or related technologies that encapsulate SQL, including Cursors, Ref-cursors, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Table Indexing
• Working knowledge in parsing and loading data using oracle XML packages.
• Extensive experience in Unix Shell Scripting to analyze and provide solutions to integrate the changes needed and suggest the best practices for different projects.
• Highly skilled in Query Optimization, Debugging, and Performance Tuning for improving the performance of Application.
• Worked independently in the development, testing, implementation and maintenance of moderate/complex systems.
• Expert in data modeling and define data entities and attributes. Also performed extensive business process analysis including data analysis and GAP analysis.
• Serve as a process expert for a defined functional area, which includes managing key data sources inputs, planning and ensuring implementation of end state automation activities and providing guidance and support for the design, development, and implementation of automated processes.
• Working Knowledge of ETL tool like Informatica to establish strategy for extracting, transforming, and loading data tables between different databases.
• Good Experience in Data loading using SQL Loader, Export and Import utilities.
• Working knowledge of Version Control Migration Tool: Rational Clear Case, PVCS, HP-Kintana.
• More than 1 Year of industrial working experience as Intermediate level DBA skills. Working Knowledge on test support for System Integration Testing SIT , Live and End to End testing.
• Expertise on FLEXCUBE Core Banking Product development, implementation support.
• Experienced in all phases of Software Development Life Cycle SDLC
• Good experience to document Functional and technical Specification and process flow.
• Ability to manage multiple tasks efficient in organizing and prioritizing assigned duties.
• Having good Client Relationship Management, Co-ordination and People Management skills and have the ability to understand and analyze both the business and technology drivers.
• A highly motivated self-starter, able to hit the ground running with little or no supervision and enjoy attention to detail. Having the ability to work autonomously and as part of a team. Also can adapt quickly to rapidly changing/new technologies.
• Received Best Performance award I-appreciate from Oracle Financial services software Ltd.

Work Summary

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Tested Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions.
• Worked on off shore for this project and tested all the Informatica mappings involving complex Router, lookups and update strategies.
• Extensively wrote user SQL coding for overriding generated SQL query in Informatica
• Created workflows and Worklets for tested mappings.
• Created Shell scripts for Automating of Worklets and Session schedule using PMCMD.
• Created automation scripts using cucumber features, jruby - fixtures, classes automation tool in Agile for iteration testing.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Wrote pre-session shell scripts to check session model enable/ disable before running/scheduling batches
• Worked with Agile methodology.
• Strong testing Quality Assurance experience within agile environment.
• Validated Extract/Transform/Load ETL processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
• Worked as Data Management SME on Data Integration, Data Extraction, Data Cleansing or Data scrubbing, and Data Validation.
• Worked with T-SQL for validating the SQL Server2000
• Worked closely with and carried out User Acceptance Testing UAT .
• Used HP Quality Center to plan, create and execute functional tests for each component.
• Written complex SQL queries to validate the target data.
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Handled release tickets for defects, enhancements, maintenance system upgrades, and process optimization activities.
• Exposed in Java, J2EE technologies using JDK, EJB, XML, XSD, HTML, Servlets, JSP, SOAP and Web Services.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Performed data quality and integrity testing within EDW and Star Dimensional Model Data Mart
• Worked with all teradata utilities including MLOAD, FLOAD, TPUMP, BTEQ and FEXPORT
• Reversed engineer and documented existing ETL program codes.
• The reports that were created in Business Objects were testing by running the SQL statements
• Hands on experience in Trouble Shooting problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting
• Designing and developing complex mappings using mapplets and reusable transformations.
• Extensively used parameter file to pass mapping and session variables.
• Wrote UNIX shell Scripts for file validation and scheduling

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange 8.X, SQL, Oracle 10g/9i Windows NT, Toad 9.0.1, PL/SQL, Business objects XIR2/6.5.1/6.0/5.1.x/4.0, UNIX, HP Quality Center 10.0

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Extensively used Informatica Client tools - PowerCenter Designer, Workflow Manager, Workflow Monitor and Repository Manager
• Extracted data from various heterogeneous sources like Oracle, SQL Server, Flat Files, Teradata.
• Developed complex mapping using Informatica PowerCenter tool.
• Extracting data from Oracle and Flat file, Excel files and performed complex joiner, Expression, Aggregate, Lookup, Stored procedure, Filter, Router transformation, Update strategy transformations to load data into the target systems.
• Created Sessions, Tasks, Workflows and worklets using Workflow manager.
• Worked with Data modeler in developing STAR Schemas
• Involved in performance tuning and query optimization.
• Used TOAD, SQL Developer to develop and debug procedures and packages.
• Involved in developing the Deployment groups for deploying the code between various environment Dev, QA
• Created pre sql and post sql scripts which need to be run at Informatica level.
• Worked extensively with session parameters, Mapping Parameters, Mapping Variables and Parameter files for Incremental Loading
• Used Debugger to fix the defects/ errors and data issues.
• Expertise in using both connected and unconnected Lookup Transformations.
• Extensively worked with various Lookup caches like Static cache, Dynamic cache and Persistent cache.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD
• Monitored and improved query performance by creating views, indexes, hints and sub queries
• Extensively involved in enhancing and managing Unix Shell Scripts.
• Developed workflow dependency in Informatica using Event Wait Task, Command Wait.

Environment: Informatica Power Center 9.1.0/8.6.1, Flat Files, Mainframe Files, Oracle 11i, Quest Toad Central 9.1, Oracle 11, SQL Server 2008, Web services

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Tested Mappings between sources to operational staging targets, using Star Schema, Implemented logic for Slowly Changing Dimensions.
• Worked on off shore for this project and tested all the Informatica mappings involving complex Router, lookups and update strategies.
• Extensively wrote user SQL coding for overriding generated SQL query in Informatica
• Created workflows and Worklets for tested mappings.
• Created Shell scripts for Automating of Worklets and Session schedule using PMCMD.
• Created automation scripts using cucumber features, jruby - fixtures, classes automation tool in Agile for iteration testing.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Wrote pre-session shell scripts to check session model enable/ disable before running/scheduling batches
• Worked with Agile methodology.
• Strong testing Quality Assurance experience within agile environment.
• Validated Extract/Transform/Load ETL processes that load Teradata test databases with data feeds from upstream applications and provided information deliveries of warehouse data to downstream users.
• Worked as Data Management SME on Data Integration, Data Extraction, Data Cleansing or Data scrubbing, and Data Validation.
• Worked with T-SQL for validating the SQL Server2000
• Worked closely with and carried out User Acceptance Testing UAT
• Used HP Quality Center to plan, create and execute functional tests for each component.
• Written complex SQL queries to validate the target data.
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements.
• Tested the reports using Business Objects functionalities like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae etc.
• Created/Enhanced Teradata Stored Procedures to generate automated testing SQLs.
• Handled release tickets for defects, enhancements, maintenance system upgrades, and process optimization activities.
• Exposed in Java, J2EE technologies using JDK, EJB, XML, XSD, HTML, Servlets, JSP, SOAP and Web Services.
• Responsible for testing Business Reports developed by Business Objects XIR2.
• Extensively used Informatica to load data from Flat Files to Teradata, Teradata to Flat Files and Teradata to Teradata.
• Performed data quality and integrity testing within EDW and Star Dimensional Model Data Mart
• Worked with all teradata utilities including MLOAD, FLOAD, TPUMP, BTEQ and FEXPORT
• Reversed engineer and documented existing ETL program codes.
• The reports that were created in Business Objects were testing by running the SQL statements
• Hands on experience in Trouble Shooting problems by checking Sessions and Error Logs. Also used Debugger for complex problem troubleshooting
• Designing and developing complex mappings using mapplets and reusable transformations.
• Extensively used parameter file to pass mapping and session variables.
• Wrote UNIX shell Scripts for file validation and scheduling

Environment: Informatica PowerCenter 8.6.1, Informatica Power Exchange 8.X, SQL, Oracle 10g/9i Windows NT, Toad 9.0.1, PL/SQL, Autosys 5.x, UNIX, Shell Scripting

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Involved in full Software Development Life Cycle SDLC - Business Requirements Analysis, preparation of Technical Design documents, Data Analysis, Logical and Physical database design, Coding, Testing, Implementing, and deploying to business users.
• Providing technical support and guidance to the offshore team to address complex business problems.
• Involved in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.
• Defining the schema, staging tables, and landing zone tables, configuring base objects, foreign-key relationships, complex joins, and building efficient views.
• Worked on Informatica Power Center tools - Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Using various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developing as well as modifying existing mappings for enhancements of new business requirements mappings to load into staging tables and then to target tables in EDW. Also created mapplets to use them in different mappings.
• Working on different tasks in Workflows like sessions, events raise, event wait, e-mail, command, worklets and scheduling of the workflow.
• Creating sessions, configuring workflows to extract data from various sources, transforming data, and loading into enterprise data warehouse.
• Running and monitoring daily scheduled jobs by using Work Load manager for supporting EDW Enterprise Data Warehouse loads for History as well as incremental data.
• Investigating failed jobs and writing SQL to debug data load issues in Production.
• Writing SQL Scripts to extract the data from Database and for Testing Purposes.
• Interacting with the Source Team and Business to get the Validation of the data.
• Involved in Transferring the Processed files from mainframe to target system.
• Supported the code after postproduction deployment.
• Familiar with Agile software methodologies scrum .

Environment: Informatica Power Center 9, UNIX, SQL, PL/SQL, Work Load Manager, MS Access, UNIX, BO XI R2, Erwin, Sun Solaris, Shell Scripts, Rapid SQL, PVCS, Visio, AutoSys.

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Interacted with the business community, QA team and database administrators to identify and analyze the business requirements for new or existing project and data realties.
• Lead projects in different phases of analysis, design, coding, testing and documentation.
• Responsible for projects estimates, design documents, resource utilization and allocations.
• Performing both ETL Architect and Developer role.
• Established best practice and standard for ETL process documents.
• Developed mappings in Informatica to load the data from various sources using transformations like Source Qualifier, Expression, Lookup connected and unconnected , Aggregator, Update Strategy, Filter, Router, SQL transformation etc.
• Used Autosys to create, schedule, monitor and send the messages in case of process failures.
• Tuning and performance improvement of the jobs in Informatica. Translated business requirements to Informatica Mappings. Involved in Unit testing of mappings.
• Delegating and Tracking the change requests in Informatica.
• Designing Web Services Consumption framework mappings

Environment: Informatica 9.5/9.1, Power Exchange, TOAD, Oracle, DB2, Autosys, PL/SQL, Unix/Shell Scripting

Confidential

Sr. Oracle Pl/SQL Developer

Responsibilities:

• Participated in the design and development of Dimensional modeling.
• Contributed in the development of system requirements and design specifications.
• Created and modified table scripts using Erwin forward and reverse engineering in Development.
• Created database Partitions and Sub-Partitions of type Range-List on fact tables to improve the performance.
• Created indexes on partitioned and non-partitioned tables.
• Created Views, Materialized Views MV and Stored Procedures to refresh the MV's as and where needed.
• Have used different Informatica Developer IDQ components like Case, Comparison, Key Generator, Match, Parser, Standardizer, Weight, Exception, Rule Based Analyzer, Lookup, SQL, Expression etc. and created IDQ mappings.
• Created profiles on source tables with Informatica Data Explorer IDE / Informatica Analyst.
• Performed single/cross table structure profiling and drill down the data with IDE.
• Exported IDQ mappings to Informatica Power Center as mapplets.
• Extracted data from SAP BW Open hubs using ABAP Integration into Stage tables.
• Created mapplets and reusable transformation wherever reusability can be implemented.
• Created simple to complex mappings using different transformations available Informatica Power center Ex: Lookup, Joined, Expression, Sequence etc
• Created and Scheduled Job Steams and Jobs in Tivoli TWS .
• Involved in database, ETL and Tivoli Jobs migration to QA and Production environments.
• Supported the application during UAT and Production.

Environment: Informatica Power Center 9.6.1, Informatica Power Exchange for SAP NetWeaver, Informatica Data Quality 9.6.1, Microstrategy, Unix Shell Scripting, SQL Developer