SUMMARY

• More than 8 years’ experience with proven ability in the area of Client/Server and Distributed Multi - tier Application Development, Database Design, Data processing, Data Warehouse mainly with Oracle technology on different platforms.
• More than 4 years’ experience Experienced in Repository Configuration/using Transformations, creating Informatica Mappings, Mapplets, Sessions, Worklets, Workflows, Processing tasks using Informatica Designer / Workflow Manager to move data from multiple source systems into targets.
• Experienced in Installation, Configuration, and Administration of Informatica Power Center 8.x/7.x/6.x, 9.1
• Expertise on PL/SQL that includes Cursors, Ref-cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools and knowledge of SAP BO.
• Experience in implementation of the Stored Procedures, Triggers, Functions using T-SQL
• Expert in developing Data Conversions/Migration from Legacy System of various sources (flat files, Oracle, Non Oracle Database) to Oracle system Using SQL LOADER, External table and Calling Appropriate Interface tables and API’s Informatica.
• Experienced in Performance tuning of Informatica (sources, mappings, targets and sessions)
• Extensive experience in Complex SQL Queries, Dynamic SQL, Analytical function, Oracle Object etc.
• Wrote complex batch process in PL/SQL for handling huge data.
• Expert in Query Optimization, Debugging and Tuning for improving performance of the applications using Explain Plan, SQL Trace and TKprof.
• Handled large scale Multi-terabyte databases.
• Skillful problem solver with excellent analytical skills.
• Experience in Data flow Diagram, ER Diagrams using Oracle Designer.
• Strong interpersonal skills, ability to interact with people at all levels. Good communication and presentation skills.
• Experienced in all phases of the system development life cycle (SDLC) and Best Practices (Oracle CDM) and Development methodologies/guidelines.
• Accomplished in working with users/upper-level management in translating their business needs into logical systems designs, as well as working in a technical capacity to implement the designs.

TECHNICAL SKILLS

Languages: SQL, PL/SQL, SQL Plus, C,SAP BO

RDBMS: Oracle 11g/10g/9i, MS SQL Server 2000, MySQL

ETL TOOLS: Informatica Power Center 8.x/7.x/6.,9.1

Other Tools: TOADS, SQL Developer, SQL Navigator, SQL Loader, Oracle EXP, Oracle IMP, QTP, ODBC, Test cases, Test scripts

Other Application: MS Office, Fuse, AdTempus, Control-M

Operating Systems: HP Unix True 64, Unix, IBM AIX, Solaris, Linux, Windows.

Version Control: PVCS., Subversion

Methodology/Best Practice: Oracle CDM Advantage 2.0

Change Control: PVCS Tracker

Case Tools: Oracle Designer

PROFESSIONAL EXPERIENCE

Confidential, Watertown, MA

Oracle PL/SQL and data migration

Responsibilities:

• Partnered with business users to understand and document business processes, reporting requirements and designed enterprise data warehouse solutions.
• Developed a detailed work flow and proposed solutions to facilitate the data conversion of the chain level and hotel level monitoring database.
• Analyzed the requirements and framed the business logic for the ETL process. Identified and designed process flows to transform data and populate the target databases.
• Led the data conversion effort.
• Extracted data from different data sources - Oracle, Access databases and Excel spreadsheets, transformed and mapped non-standard data to standard codes for data integrity and loaded the target Oracle warehouse database
• Created/modified various Packages, Stored Procedure & Functions as part of the data migration and cleansing process.

Environment: Oracle 11g SQL, Oracle Database 11g PL/SQL, SQL developer, sabre now, Sql loader, Excel, UNIX, PL/SQL developer 8.5.

Confidential, Seattle, WA

Oracle PL/SQL Developer

Responsibilities:

• Analyzed complex data structures to generate useful business insights.
• Responsible for the analysis, design, development, also maintenance and support of software applications in UAT and Production.
• Designed and developed a pivot application while performing aggregations over a finite set of values using Oracle PL/SQL procedures, packages, triggers, inline views.
• Performed the following activities: requirements definition, design, development, testing and implementation.
• Used to gather requirements from data analysts and data architects and performed technical analysis to reach a viable solution for the tags to be send downstream only after they get business approved.
• Created packages and procedures to perform ETL processes like data loading, transformation, extraction, validation and reporting.
• Modified existing PL/SQL modules by using Bulk Collect, Pl/SQL tables, varrays and other collection types to improve the performance of the system.
• Supported Teamwork’s developers and created views and stored procedures to aid with their reporting needs.
• Used unit testing and user acceptance testing and provided support to QA and other downstream systems.
• Wrote technical documents giving an outline of job flows and the process involved.
• Worked with various tools like Esmart, JIRA, GIT, JDA UI etc for defect tracking and version management.
• Gained necessary input/approval of requirements and design and participated in code reviews ensuring applications meet requirements and are error free.
• Worked on periodic maintenance releases of applications, including enhancements and defects.
• Looked for ways to incrementally improve the architecture of legacy systems.
• Managed workload to deliver quality deliverables that meet requirements and timelines.
• Assisted Manager in tracking progress, prioritizing work, developing time estimates and work plans and assisting less experienced team members.

Environment: Oracle 11g SQL, Oracle Database 11g PL/SQL, TOAD 8.5, Git, Lombardi Teamworks 6(Mapping Repository), Sybase Power Designer (Data Mapping), UNIX, PL/SQL developer 8.5.

Confidential, Lewisville, TX

Oracle PL/SQL & Informatica Developer

Responsibilities:

• Developed and maintained PL SQL packages, procedures and functions to support the reports by retrieving the data from for the application.
• Extensively involved in writing SQL queries (Sub queries and Join conditions), co-related sub queries, in-line views and PL/SQL programming.
• Extensively used the advanced features of PL/SQL like collections, nested table and dynamic SQL.
• Work with cursor and ref cursor in PL/SQL scripts. Used ref cursor in functions to write the record set of cursor.
• Used Public Synonyms, read only User Accounts and Database Links to remote database.
• SQL, PL-SQL code tuning using hints, Explain Plan, SQL Trace, and TKPROF.
• Defining requirements by interacting with business group, application development group.
• Creating job flow diagrams, data flow diagrams, ER-Diagrams and process specifications as part of design.
• Developed Code Units, testing, debugging and implemented business rules using SQL, PLSQL (functions, procedures, packages, triggers), SQL*Loader, Unix Korn shell scripts
• Application tuning, Query tuning using Explain plan, SQL tuning sets, BULK Collect, BULK Load
• Designed and developed complex static and dynamic mappings by using Lookup, Expression, Update, Sequence generator, Aggregator, Router, Stored Procedure, etc., transformations to implement complex logics while coding a mapping.
• Worked with Informatica power center Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, SQL server and Flat files and loaded into Oracle.
• Developed Informatica Workflows and sessions associated with the mappings using Workflow Manager.

Confidential, Denton, TX

Oracle PL/SQL Developer

Responsibilities:

• Analyzed data to check for Data Integrity and Referential Integrity when loaded to source-staging tables.
• Created tables to capture errors and data that failed Validation Checks.
• Re-validated corrected data from source and re-processed to get them loaded to the oracle target.
• Re-worked on the BAD Files that were generated by SQL Loader.
• Used SED and AWK in UNIX Shell scripting to correct the data issues in the SQL-Loader data file.
• Responsible to write scripts which identify the legacy data and the valid data.
• Created Database Objects such as Tables, Views and Synonyms to provide data access to subscribing parties.
• Created/modified various Packages, Stored Procedure & Functions as part of the data validation and cleansing process.
• Pro-actively participated in SQL tuning, Used ANALYZE, DBMS STATS, EXPLAIN PLAN, SQL TRACE and TKPROF.
• Used SQL hints and Indexes as needed to improve SQL performance.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Wrote UNIX Shell scripts for performing development and DBA activities.
• Tested the ETL process in testing environment and created test cases.

Environment: Oracle 11g SQL, Oracle Database 11g PL/SQL, SQL Server 2012, TOAD 8.5, Tortoise SVN (Subversion), ECM(Enterprise Change Management), ITSM, Visio, UNIX, PL/SQL developer 8.5, Eclipse, Java, Control-M.

Confidential, Houston, TX

SQL PL/SQL Developer

Responsibilities:

• Performed as a key team player in Client/Server and Distributed Multi-tier Application
• Development, Data modeling: Conceptual, Logical and Physical design for both Relational and
• Dimensional schema also simulation and analysis.
• Worked on problem solving the evaluation of specifications for complex business requirements and maintaining new processes, developed and prepared solutions.
• Extensively worked with testing (test cases, test scripts), mainly Manual Testing which are also known to be test cases.
• Performed with data modeling, TOAD, code versioning and other SDLC tools.
• Wrote high performance queries/PL/SQL and T SQL codes using Collections, Bulk Collects, Materialized
• Views (MV), Objects, Nested Tables, REF Cursors, and Indexing etc.
• Created nightly batch jobs, one time jobs and queues.
• Performed SQL tuning, Optimized SQL and tuning existing codes with the help of Explain plan, Trace utility & TKProf.
• Used features like cut, sed for UNIX shell scripting.
• Did Data modeling and have understanding of the physical data model concepts.
• Have SDLC Experience, Analysis, Requirement Gathering and experience in technical design documentation and work related to interacting directly with end clients, the QA team and the developers to enhance product deliverables.
• Engaged in production release preparation and post go live support for different systems.
• Documented all PL/SQL and T SQL code, packages, procedures, functions and triggers to trace the system performance.
• Resolve daily support tickets including detailed data analysis and bug fixes to meet client requirements and provide apt solutions.
• Maintained different version of software (version control) using CVS

Environment: Oracle 10g, Oracle Database 9i PL/SQL, TOAD 8.5, CVS, AIX/UNIX.

Confidential, Dallas, TX

SQL, T SQL PL/SQL Developer

Responsibilities:

• Designed and modified Database tables, keys, indexes, packages, functions and procedures etc using oracle and SQL server.
• Used Collections, Bulk Binds to improve performance by minimizing the number of context switches between the PL/SQL and SQL engines.
• Created partitioned tables, partitioned indexes for manageability and scalability of the application.
• Utilized data profiling, rules for data analyzing and cleansing.
• Created and deployed mappings, process flows to transfer data from legacy sources to staging area and from staging area to data warehouse using Oracle Warehouse Builder.
• Support Data warehouse, ETL Process.
• Developed Database Triggers for the integrity and security purpose.
• Used Oracle Job Scheduling and Maintain Batch jobs.
• Improved query performances by query optimization - tracing the query explain plan and Used TKPROF SQL scripts to monitor the performance.

Environment: Oracle Database 9i, SQL Server 2008, TOAD, UNIX