SUMMARY

• 10+ years of IT experience with Confidential .
• Strengths in ETL software development, in - depth analysis of systems/requirements, technical support, and QA testing on enterprise level projects related to improving production support, automated solutions and reporting/analytical solutions for global operations, FX, and securities groups.
• Highly-proficient in developing web based .Net applications to automate manual tasks, analyzing code and troubleshooting to effectively resolve issues combined with strong database/SQL skills (queries, stored procedures, functions, triggers, cursors).
• Excellent communication skills to effectively interact with clients, BAs, PMs, development/QA teams, and provide guidance to on/offshore support team members.

TECHNICAL SKILLS

Data Warehouse: ETL Concepts, Informatica 9.6

Databases: Oracle 11g, SQL Server 2012

Languages/Packages: C#, .Net, VB

Operating systems: Windows / Unix

Reporting tools: Microsoft Reporting Services, Actuate, Crystal Reports

Scripting languages: VB Script, Java Script, Unix Shell Scripting

Database tools: Toad, SQL Server Client

Script Maintenance tool: VSS

PROFESSIONAL EXPERIENCE

Confidential - Chicago, IL

Informatica Developer

Responsibilities:

• Understood the new system to be used due to BOA-ML merging activity and prepared the Knowledge Transition documents.
• Provided the details about the existing application to the merging team.
• Interacted with clients and other teams for any enhancements.
• Analyzed source data and decided on appropriate extraction, transform and load strategy.
• Created mappings with different transformations like Expression transformation, Lookups, Filter, Router, Joiner, Union transformations, mapplets, sessions and workflows.
• Wrote Oracle stored procedures and functions, and called them from Informatica.
• Created DB objects for the given requirements in Oracle and SQL server.
• Created workflows to read data from heterogeneous environments like Oracle, SQL server and Sybase.
• Performed ETL operations with Excel and flat files.
• Implemented performance tuning in mappings and sessions.
• Maintained development, test and production mapping migration in Repository manager.
• Wrote Unix shell scripts to call the Informatica workflow.
• Modified the Informatica mappings, transformations, sessions and workflows in Informatica PowerCenter Designer/Manager if any changes were requested from clients.
• Monitored the Informatica jobs in the Informatica Workflow monitor.
• Prepared all of the DB scripts and Informatica objects for the implementation in production environment.
• Tools Used: Windows Platform, Informatica PowerCenter 9.6, Oracle 11g-SQL, PL/SQL, TOAD, SQL Server 2012, Unix scripts, Microsoft Reporting Services.

Data Analyst / Informatica Developer

Confidential, Chicago, IL

Responsibilities:

• Created mappings with different transformations, mapplets, sessions and workflows.
• Wrote Oracle stored procedures and functions, and called them from Informatica.
• Created DB objects for the given requirements in Oracle and SQL server.
• Created workflows to read data from heterogeneous environments.
• Performed ETL operations with Excel and flat files.
• Wrote complex SQL queries in Oracle/SQL server to test data in the system and provide expected result to users.
• Analyzed SQL procedures and .Net code when the queries were raised on the data.
• Checked the Informatica mappings, transformations, sessions and workflows in Informatica PowerCenter Designer/Manager to find out the business logic for data related queries.
• Monitored the Informatica jobs in the Informatica Workflow monitor for jobs health check.
• Deployed jobs in Autosys and Windows scheduler.
• Interacted with clients and users for any critical issues during APAC, London and NY starting hours.
• Created major incident tickets for any kind of critical issues and communicated the details to client managers.
• Resolved production issues within the SLA defined and properly escalated if the issue was not resolved within the SLA.
• Conferenced all upstream and downstream systems in case of major issues.
• Identified the root cause of issues and passed details to development team; also identified the support activities to be automated.
• Automation Activity: As part of Six Sigma activities in TCS, many of the complex manual activities in the project were automated. The GBOSS project team was manually doing various adhoc activities like the report generation for the users on daily, weekly and monthly basis and the delivery of feed files to downstream and some more activities.
• Automated these tasks using .Net, SQL DTS and Informatica which resulted in saving 10 hours of manual work per month.
• Tools used: Windows Platform, Microsoft .Net, Oracle 9i-SQL, PL/SQL, TOAD, SQL Server 2005
• Assisted team members on support activities and trained them on all new implementations happening in the system.
• Prepared the status report of the issues by region wise, issue category wise, etc. This helped the client managers to get the high level view of the issues and also the development team to fix the recurrent issues.
• Attended weekly calls with client managers and development team to communicate details about the issues and about the users’ concerns. Interacted with high-level managers and explained about the project and the team activities.
• Gathered all details about the release from development team, obtained the scripts of all objects to be implemented, worked with the database team to execute the database objects and finally implemented the objects in production and completed a round of post-production testing.
• Followed up with business analysts to do the post-production testing and obtained approval from them.
• Informed users’ group about the release implementation.
• Maintained all the valuable documents of the team.
• Managed team members and ensured that the project activities were not disturbed at any case.
• Tools Used: Windows Platform, Oracle 9i-SQL, PL/SQL, TOAD, SQL Server 2005, Informatica PowerCenter 8.5, Microsoft Reporting Services

Data Analyst / Support Team Lead

Confidential, New Jersey

Responsibilities:

• Interacted with many upstream and downstream systems in GMI and also with vendors.
• Wrote complex SQL queries in Oracle / SQL server to test data in the system and provided expected result to users.
• Analyzed SQL procedures and .Net code when the queries were raised on the data.
• Checked the Informatica mappings, transformations, sessions and workflows in Informatica PowerCenter Designer/Manager to find out the business logic for data related queries.
• Monitored the Informatica jobs in the Informatica Workflow monitor for jobs health check.
• Deployed jobs in Autosys and Windows scheduler.
• Interacted with clients and users for critical issues during NY hours and sometimes with other region users also. Created major incident tickets for any kind of critical issues.
• Passed the client expectations to offshore team members and managers and vice versa.
• Took care of the production environment and do the checks as per the support checklist.
• Resolved production issues within the SLA defined.
• Handled the queries or requests from users, upstreams and downstreams.
• Assisted onsite and offshore team members on support activities.
• Prepared documents for all new or updated activities in the team and shared it with team members.
• Tracked the issues and resolutions for quickly resolving the recurrent issues in the future and to help the new team members to understand the system and the user queries.
• Prepared the status report of the issues by region wise, issue category wise, etc. This helped the client managers to get the high level view of the issues and also the development team to fix the recurrent issues.
• Attended weekly calls with client managers and development team to communicate details about the issues and about the users’ concerns. Attended calls with client business analysts to pass on clarifications about the system if any.
• Attended Change Analysis Board meeting to communicate the details about any oncoming production release and obtained approval from them to execute the release.
• Gathered all details about the release from the development team, obtained the scripts of all objects to be implemented, worked with the database team to execute the database objects and finally implemented the objects in production and completed a round of post-production testing.
• Followed up with business analysts to do the post-production testing and obtained approval from them.
• Informed users’ group about the release implementation.
• Identified the support activities to be automated.
• Tools Used: Windows Platform, Oracle 9i-SQL, PL/SQL, TOAD, SQL Server 2005, Informatica PowerCenter 7.1, Microsoft Reporting Services

Data Analyst / Developer

Confidential

Responsibilities:

• Interacted with many upstream and downstream systems in GMI and also with vendors.
• Took care of the production environment and do the checks as per the support checklist. Identified the support activities to be automated. Resolved production issues within the SLA defined.
• Handled the queries or requests from users, upstreams and downstreams.
• Assisted onsite and offshore team members on support activities.
• Prepared documents for all new or updated activities in the team and shared it with team members.
• Tracked the issues and resolutions to quickly resolve the recurrent issues in the future and to help the new team members to understand the system and the user queries.
• Prepared the status report of the issues by region wise, issue category wise, etc. This helped the client managers to get the high level view of the issues and also the development team to fix the recurrent issues.
• Attended weekly calls with client managers / development team to communicate details about the issues and about the users’ concerns.
• Tools Used: Windows Platform, Oracle 9i-SQL, PL/SQL, TOAD, SQL Server 2005, Informatica PowerCenter 7.1, Microsoft Reporting Services
• Developer on the Production Matrix Project: Internal application mainly used by the high-level managers in Confidential to know the status of production issues in different formats or categories. The reports were developed in MS Reporting Services and Oracle was used as a backend. The reports were mostly shown in graphical format for better and easy understanding.
• Gathered requirements from business analysts or from the onsite coordinator of the team.
• Created functional and technical specs from business requirement document.
• Designed the report template and script as per the requirement.
• Developed the stored procedures, packages, triggers and other database objects.
• Created test cases and test scripts for Unit testing.
• Supported the QA team in the system and regression testing.
• Prepared the overall technical test plans to ensure that source code is working properly.
• Passed details to the business analyst/onsite coordinator for interacting with clients for UAT.
• Moved the objects to production environment.
• Tools Used: Windows Platform, Oracle 9i-SQL, PL/SQL, TOAD, Microsoft Reporting Services

Data Analyst / Developer

Confidential

Responsibilities:

• Project Summary: The objective of Debt Application support team was to provide production support to many different applications of Confidential . Most of the applications were the Mission Critical Applications and required quick and timely responses to the users, upstream and downstream systems. The data transmissions were mostly done through the message queues and the systems were mostly in Unix. Some of the systems had web applications also to support. There were many different upstream and downstream systems to work with in different locations and the users were also present across the world.
• Provided support for some of the applications including Unix and Web based applications.
• Took care of the production environment and performed the checks as per the support checklist.
• Resolved production issues within the SLA defined.
• Handled the queries or requests from users, upstreams and downstreams.
• Tracked the issues and resolutions to quickly resolve the recurrent issues in the future and also to help the new team members to understand the system and the user queries.
• Attended weekly calls with client managers and development team to communicate details about the issues and about the users’ concerns.
• Identified the support activities to be automated.
• Automation Activity 1: The XPORT application in the team had more manual support checks and took more time of a support team member twice a day. In order to help the team do the checks quickly and not to miss out any check by mistake:
• Developed a web application in .Net to perform all the checks automatically and to display the result of each check in coloured way, so that anyone in the support team could view the web page and find out the check that was failing and which checks were passing.
• This proved very helpful to the team and reduced an hour of support team’s work.
• Automation Activity 2: The reporting environment in one of the applications was required to be checked daily and each report in the environment was required to be opened to check the data in the report; which was time consuming work for the support team.
• Developed a .Net console application to do this activity automatically, to perform all adequate checks in the backend and to send an email alone to all in the support team with the status of the checks.
• This proved very helpful to the team and reduced an hour of support team’s work.

Developer

Confidential

Responsibilities:

• The report templates were developed in Actuate and shown to users through the Intranet applications.
• The data extraction and load were done through SQL DTS.
• The responsibility of the project team was to concentrate on development, maintenance and production support for a suite of reporting applications. Interacted with many upstream and downstream systems in GMI and also with vendors.
• Developed Reports in Actuate, wrote SQL procedures and SQL DTS packages.
• Participated in requirement gathering meeting with Business Analysts and Business Users.
• Created functional and technical specs from business requirement document.
• Designed the report template as per the requirement.
• Developed the front-end script for the reporting logic.
• Developed the SQL procedures for the reporting logic.
• Created test cases and test scripts for Unit testing.
• Supported the QA team in the system and regression testing.
• Prepared the overall technical test plans to ensure that source code worked properly.
• Coordinated with Users during UAT.
• Helped the support team to move the objects to production.