PROFESSIONAL SUMMARY:

• Over 10 years of IT experience in system analysis, design, coding, implementation, customization, testing and production support of business applications in Client/Server environment.
• Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development, Testing and Production.
• Experience in Informatica Designer Tools like Mapping Designer, Source Analyzer, Target Analyzer, Transformation Developer, and Mapplets Designer to do the ETL process.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle/Sybase, XML files, worked on integrating data from flat files like fixed width and delimited.
• Extensively used the transformation components like Source Qualifier, Expression, Aggregator, Filter, Router, Sorter, Update Strategy, Lookup, Joiner and Sequence Generator.
• Good experience in performance tuning of Informatica mappings and SQL queries.
• Extensive experience in designing and working with Oracle 8i/9i/10g/11g and writing SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Cursors, Database Objects using PL/SQL and possess good understanding of oracle data dictionary.
• Experience in physical and logical data modeling techniques like Dimensional/ Star Schema, Snowflake modeling, Slowly Changing Dimensions using Erwin and TOAD Data Modeler.
• Experience in Actuate ERD Pro 8.0/7.0, Actuate Report Server, API, Actuate Active Portal.
• Having knowledge of Big Data technologies.
• Experience in working with scheduling tools like Autosys.
• Performed various kinds of testing like Integration, Unit and User Acceptance testing.
• Excellent Interpersonal and Communication skills, coupled with strong technical and problem solving capabilities.
• Work well independently or as a part of team.

TECHNICAL SKILLS:

ETL/ Database Tools: Informatica PowerCenter 9.x, Toad, PL/SQL developer, ERwin, Toad Data Modler.

Programming Languages: PL - SQL, SQL, Shell Scripting, C, Pro*C, Vb 6.0

RDBMS: Oracle, Sybase

Reporting tools: Actuate 7/8, Crystal Reports and Orcale6i report builder

Operating System: Unix, Window 2000/XP

Other Tools: Autosys, ClearCase, HP Quality center, RTC, Github, Rational team concert, HP service manager

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Senior developer

Responsibilities handling:

• Developed and enhanced various powercenter mapping to perform ETL operation while loading data from flat file, database to Oracle database.
• Created various PL/SQL objects like packages, procedures, functions, triggers etc to perform business operation.
• Extensively working on performance tuning of SQL queries and informatica mapping.
• Developed PL/SQL code for new requirements, enhancements and debugging of procedures, packages and other Oracle objects.
• Performing data analysis, identify data patterns to understand requirement more precisely.
• Working with business analyst to deep understanding of the business requirements and analyzing the various scenarios and use cases.
• Working with business analysis to understand requirement and created logical/physical data model.
• Working on re-engineering of SDR application’s CFTC module to come up more scalable solution.
• Working closing with database migration team to migrate database from Solaris to Linux box.
• Coordinating with various supporting team like Ops, DBA and release management team to deploy code in production environment etc.

Environment: Informatica 9.1.0, PL/SQL, Oracle 11g, Unix, Shell Scripting, ERwin, Toad Data Modeler, HP Quality Center, ClearCase, Rational team concert, Autosys.

Technology Lead

Responsibilities handling:

• Perform data analysis and identify data patterns, issues and trends.
• Developing a deep understanding of the business domain, document business requirements and analyzing the various scenarios and use cases.
• Working closely with the system analysts and project managers on multiple tracks.
• Developed PL/SQL code for new requirements, enhancements and debugging of procedures, packages and other Oracle objects.
• Created database objects like tables, views, synonyms, indexes, and sequences.
• Worked with Power Center -Designer tool to develop mappings to extract and load the data from flat files, Oracle to Oracle.
• Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.
• Created reusable transformations and mapplets to use in multiple mappings.
• Created and ran debug sessions in the Debugger to monitor and test the sessions prior to their normal run in the Workflow Manager.
• Tuned Mappings for optimum performance.
• Generated SQL and PL/SQL scripts to create and drop database objects including tables, views, primary keys, indexes, constraints, packages, sequences, synonyms.
• Wrote SQL queries for data and report validation in TOAD.
• Co-ordination with different team within FIMT (e.g DBA, Release engineering and DB Ops) at both onsite and offshore for any technical issue, deployment, migration, database dumps. Also handing 4 members teams at offshore.
• L3 support and working on long term solution of frequent occurring incidents.
• Creation of UNIX shell scripts and using Autosys to schedule the triggering of these UNIX shell script jobs.

Environment: Informatica PowerCenter 9.1.0, PL/SQL, Oracle 11g, Unix, Toad, HP Quality Center, RTC, Github, Rational team concert, HP service manager, Autosys.

Technology Lead

Responsibilities handled:

• Identified technical solutions to solve business requirements and provide technical leadership during enhancements and development.
• Provided analysis and fix for emergency production issues.
• Gathered business requirements by conducting detailed interviews and one on one meeting with business users, stakeholders and SME's.
• Extensively used TOAD and PL/SQL Developer for daily development jobs.
• Worked with Business Systems Analysts and Database Administrators to understand and implement functional and non-functional requirements into the project.
• Identified issues with current database and resolved them. Installed and configured relevant components to ensure database access. Diagnosed and resolved database access and performances issues.
• Extensively worked on Actuate ERD Pro 8.0/7.0 report designer tool to develop the complex repots using PL/SQL and T-SQL stored procedures.
• Worked with Power Center -Designer tool to develop mappings to extract and load the data from flat files, Oracle to Oracle.
• Created various transformations like Source Qualifier, Joiner, Update Strategy, Rank, Expressions, Aggregator and Sequence Generator to load data into targets.
• Co-ordination different team like production support, application release team to deploy code in production environment.
• Performed unit testing of Actuate erdpro 7/8 reports, Informatica tasks and also supported QA team for their QA/UAT testing.

Environment: T-SQL, Oracle 10g,PL/SQL, Sybase, Unix, Infromatica PowerCenter 8.x, Actuate e.Report designer professional 7/8, Perforce, Autosys, Rapid SQL

Confidential

Associate Consultant

Responsibilities handled:

• Worked as a developer in creating complex Stored Procedures, packages, triggers, cursors, tables, views and other SQL joins and statements for applications.
• Designed and implemented complex Pro*C batches, stored procedures and packages. Implemented constraints on tables.
• Created code packages to deploy the code in higher environments like QA, UAT and Production.
• Independent unit testing(IUT) and System Integration testing of applications for performance, data Integrity
• Provided production support after the system was delivered to the client.
• Created indexes, constraints and rules on database objects.

Environment: Pro*c, PL/SQL, SQL, Oracle 10g, Java, Unix, SQL Developer, Toad.

Confidential

Project Coordinator

Responsibilities handled:

• To understand the business involved and related it to the design of different components of the generic system.
• Developed low-level designs (LLDs) and URS (user requirement specification) to suit business requirements.
• Developed and enhancing of Pro*C programs and schedule the programs through Autosys scheduler.
• Provided production support after the system was delivered.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using SQL and PL/SQL in Development and Production environment for Oracle 9i.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.

Environment: PL-SQL, Oracle9i, Pro* C, Orcale6i report builder, Unix, TOAD, PLSQL Developer.

Confidential

Programmer

Responsibilities handled:

• To understand business requirement from development.
• Developed and enhancing of Pro*C programs.
• Provided production support after the system was delivered.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using SQL and PL/SQL in Development and Production environment for Oracle 9i.
• Created Seagate crystal reports, data extraction and data loading scripts for different databases and schemas
• Development of vb6.0 code to enhance the functionality of ERP to handle business needs.

Environment: PL-SQL, Oracle9i, Pro* C, UNIX, VB6.0, Seagate crystal report, TOAD, PLSQL Developer.