PROFESSIONAL SUMMARY:

• Self motivated Senior Consultant with over 10+ years of experience and a passion for technology. Wealth of functional, technical, presentation and communication skills that help to lead an excellent team with client facing roles. Now seeking next challenging and rewarding opportunity to demonstrate abilities and make an effective contribution in a dynamic & successful software organization. A quick learner likes to learn new technology and innovative ways to accomplish goals.
• A result - oriented and enthusiastic Software Professional with experience in analysis, design, development and testing in Banking domain with skill set including ETL with tools like Informatica Powercentre, IDQ(Informatica Developer and Informatica Analyst tool) and IBM Infosphere Datastage, Informatica Metadata Manager, Oracle SQL, Sybase, Interactive SQL, DB2, IBM Data Studio, Control-M, Business Objects Xi R3(Designer, Universe Builder, Desktop Intelligence, Web Intelligence Rich Client), WinSCP, Mainframe programming in CA­IDEAL DATACOM and JCL.
• Strong background working with cross functional teams in the development, and quality control of applications, systems, and databases.
• Experience in working with both SDLC and Agile methodology of projects.
• Extensive experience in Oracle, Sybase and DB2 database programming and debugging including developing stored procedures and other database objects.
• Extensive experience in testing using HP ALM Quality Center. Writing Test Cases, executing the test cases.
• Experience in guiding a product from ‘Concept’ through ‘Implementation’, preparing High and Low level design documents.
• Effective leader & excellent interpersonal skills, people management skills.
• Sincere, enthusiastic, hardworking with good communication and interpersonal skills and appetite to learn as well as lead a team.
• Implementing Data Quality Solutions using Informatica Data Quality by creating and managing business glossary terms, mappings, profiles and scorecards in IDQ 10.1.0.
• Building ETL mappings and workflows using Informatica Powercenter.
• Database and SQL performance tuning

TECHNICAL SKILLS:

Tools: Informatica Developer 10.1.0, Informatica Analyst 10.1.0, Informatica Powercentre 9.6.1, IDQ, Informatica Metadata Manager, IBM Infosphere Datastage Designer and Director, Oracle SQL Developer, SQL * Plus, CA ERwin Data Modeler, Sybase Central, Interactive SQL, IBM Data Studio, Control-M, XML, Unix shell scripting (ksh), Web Services, Business Objects Xi R3(Designer, Universe Builder, Desktop Intelligence, Web Intelligence Rich Client) and CA IDEAL DATACOM

Operating System: Windows 95, NT, 2003, Vista, 7

Relational Databases: Oracle, DB2, Sybase

Reporting Tools: Business Objects Reporting

Third Party Tools: MS Office, HP ALM Quality Center, MKS Integrity Client, RTC.

WORK EXPERIENCE:

Confidential

IDQ Consultant, Minneapolis, MN

Responsibilities:

• Designing, implementing and supporting Data Quality initiative of the bank.
• Creating and maintaining business glossary terms using the Informatica Analyst Tool.
• Building Data Quality rules for all the lines of businesses across the bank using various advanced transformations in IDQ.
• Building profiles and scorecards and working closely with the data stewards using the Data Analyst Tool.
• Creating business rules in Informatica Developer and imported them to Informatica Powercenter to load the standardized and good format of data to staging tables.
• Creating mappings using transformations like Source Qualifier, Address Doctor, Joiner, Aggregator, Expression, Parser, Filter, Router and Lookup.
• Creating and Loading resources in Informatica Metadata Manager to show data lineage.
• Conducting Demo sessions for the various lines of business to project the data quality metrics using Data Analyst Tool.
• Documenting procedures for various builds, installations and support projects for internal use.

Environment: Informatica Developer 10.1.0, Informatica Analyst Tool 10.1.0, Informatica Metadata Manager, UNIX, SQL Developer, TOAD, VersionONE, Stonebranch, GITHub, Oracle, HP ALM

Confidential

Senior Informatica Consultant, New Jersey

Responsibilities:

• I am driving the Confidential Orchestra project as a Lead and handled a team of 6 members.
• Developed the Orchestra application using Oracle, Informatica Powercentre 9.6 and Control-M .
• Developed Informatica ETL jobs to load the oracle tables test the web services which generated XML files.
• Create slowly changing dimension type 1 and 2.
• Worked with Informatica workflow monitor in running and debugging its components and monitoring the resulting executable version
• Developed ETL mappings for data cleansing using various transformations like Standardizer, match, consolidation in IDQ .
• Developed Control-M jobs to load and schedule the load for these tables in Oracle.
• Regular Customer Interaction on all the phases of the project.
• Involved in High level design, development, SIT, UAT support.
• Involved in coding, testing and deployment activities.
• Involved in Release Management, configuration activities in Domdoc, Audits
• Played the role of Scrum Master and conducted daily scrum meetings for the project.
• Involved in progress reporting, weekly and monthly status reports.
• Participated in knowledge sharing sessions by giving presentations to the entire BU.
• Handling the SIT, UAT and performance testers as well.

Environment: s: Oracle, SQL Developer, Informatica Powercenter 9.6.1, Informatica Developer 9.6.1, Unix Shell scripting (ksh), XML Web Services, Control-M and RTC.

Confidential

ETL Technical Lead/Onsite Coordinator

Responsibilities:

• I lead the Confidential project as a Technical Lead and Onsite coordinator in Geneva.
• Developed tables in DB2 database.
• Developed Informatica ETL jobs to load the DB2 tables and generate XML files using the ALM application.
• Developed Control-M jobs to execute and schedule the load of tables.
• People Management skills, Single person to drive the project from offshore.
• Regular Customer Interaction on all the phases of the project.
• Involved in High level design, development, SIT, UAT support
• Involved in coding, testing, deployment and support.
• Involved in Release Management, configuration activities in Domdoc, Audits
• Played the role of SCM as well as DPC for the project.
• Involved in progress reporting, weekly and monthly status reports.
• Participated in knowledge sharing sessions by giving presentations to the entire BU.
• Handling the SIT, UAT and performance testers as well.

Environment: s: DB2, Informatica 9.6, Unix shell scripting (ksh), SQL, WinSCP, Control-M, RTC for Version Control, Textpad, HP ALM Quality Center.

Confidential

Technical Analyst/Onsite Coordinator

Responsibilities:

• I lead the Confidential project as a Technical Analyst and Onsite coordinator in Geneva.
• People Management skills, Single person to drive the project from offshore.
• Developed tables in Oracle database.
• Developed Datastage jobs to execute and schedule the load of tables.
• Regular Customer Interaction on all the phases of the project.
• Involved in High level design, development, SIT, UAT support
• Involved in coding, testing, deployment and support.
• Involved in Release Management, configuration activities in Domdoc, Audits
• Played the role of SCM.
• Involved in progress reporting, weekly and monthly status reports.
• Participated in knowledge sharing sessions by giving presentations to the entire BU.
• Handling the SIT, UAT and performance testers as well.
• Optimized stored procedures to increase application performance.

Environment: s: Oracle, IBM Infosphere Datastage Designer and Director, Unix shell scripting (ksh), SQL, WinSCP, Business Objects Xi R3, MKS for Version Control, Textpad, HP ALM Quality Center.

Confidential, New Jersey

Senior Developer

Responsibilities:

• Developed the Confidential application using Sybase and Business Objects Xi R3.
• I was involved in the Confidential Ever greening project, Confidential roll out to Guernsey project.
• People Management skills, Single person to drive the project from offshore.
• Regular Customer Interaction on all the phases of the project.
• Involved in High level design, development, SIT, UAT support
• Involved in coding, deployment when the developers were on leave.
• Involved in Release Management, configuration activities in Domdoc, Audits
• Played the role of SCM.
• Involved in progress reporting, weekly and monthly status reports.
• Participated in knowledge sharing sessions by giving presentations to the entire BU.
• Handling the SIT, UAT and performance testers as well.

Environment: s: Sybase 12.5, Sybase 15, Unix shell scripting (ksh), SQL, WinSCP, Business Objects Xi R3, MKS for Version Control, Textpad, HP ALM Quality Center.

Confidential

Senior Developer/Onsite Coordinator

Responsibilities:

• Onsite co­ordinator in Geneva for UAT and Go Live .
• Interact with Business to gather application requirement
• Involved in analysis, design and coding of Business Objects and Sybase requirements.
• Worked on Business Logic and code reviews.
• Regular Customer Interaction on all the phases of the project.
• Involved in High level design, development, SIT, UAT support
• Involved in coding, deployment when the developers were on leave.
• Involved in Release Management, configuration activities in Domdoc, Audits
• Played the role of SCM.
• Involved in progress reporting, weekly and monthly status reports.
• Participated in knowledge sharing sessions by giving presentations to the entire BU.
• Handling the SIT, UAT and performance testers as well.

Environment: s: Sybase 12.5, Sybase 15, Unix shell scripting (ksh), SQL, WinSCP, Business Objects Xi R2, MKS for Version Control, Textpad, Mercury Quality Center.

Confidential

Senior Developer

Responsibilities:

• Interact with user to gather application requirement
• Involved in analysis, design and coding of Business Objects and Sybase requirements.
• Worked on Business Logic and code reviews.
• Worked on testing, deploying in Unix server.
• Involved in interacting with clients for further requirements.
• Thus involved in the analysis, design, coding, testing and implementation of the project.

Environment: s: Sybase 12.5, Unix shell scripting (ksh), SQL, WinSCP, Business Objects Xi R2, MKS for Version Control, Textpad, Mercury Quality Center.

Confidential ­

Senior Database Developer

Responsibilities:

• Interact with business users to gather application requirement
• Involved in analysis, design and coding of Sybase requirements.
• Designed Sybase database tables, which would store the information.
• Write stored procedures using SQL.
• Worked on Business Logic and code reviews.
• Worked on testing, deploying in Unix server.
• Involved in interacting with clients for further requirements.
• Thus Involved in the analysis, design, coding, testing and implementation of the project.

Environment: s: Sybase 12.5, Unix shell scripting (ksh), SQL, WinSCP, MKS for Version Control, Textpad, Mercury Quality Center.