PROFESSIONAL SUMMARY:

• 14.8 Years of IT experience.
• Worked in complete Software Development Life Cycle (SDLC), starting from requirement gathering, analysis, design, testing, debugging, implementation, post implementation support and till maintenance.
• Good team player, strong interpersonal and communication skills combined with self - motivation initiative and positive attitude.
• Good in Onsite-Offshore work co-ordination.
• Worked on Oracle Database supporting OLTP and Data Warehouses.
• Also worked on the ETL Tools like Informatica, Ab-Initio and Reporting tools like Cognos, OBIEE.
• Strong experience with Informatica tools - Mapping designer, Mapplet Designer, Transformations Developer, Informatica Repository Manager, Workflow Manager and Workflow Monitor, and DAC as Scheduler tool.
• Created worklets by grouping different sessions related to a subject area.
• Have knowledge about the Informatica PowerExchange.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Developed effectively different type of SCD’s based on the specifications.
• Sound experience in Performance tuning of ETL process. Reduced the execution time for huge volumes of data for a company merger project.
• Successfully co-coordinated for the project activities in off-shore/onsite model with a team of 12 members.
• Experience in interacting with onsite clients while being responsible for deliverables.
• Ability to work with limited resources, capable of multi-tasking, planning works around concurrent and time sensitive deliveries.
• Quick to learn.
• Worked in Agile work environment.
• Handle the work independently.
• Had a good knowledge and completed training in Oracle Data Integrator (ODI)
• Looking ahead for great personal and professional career in a fair working environment with opportunities to grow.
• Organizing timely meetings with Business and other teams, then sharing the MoM based on the meeting outcome.

TECHNICAL SKILLS:

Operating Systems: UNIX, Windows XP/2003/2007/8

Languages: C, C++, Java, SQL, PL/SQL

Databases: Oracle, MS Access, DB2

Web Related: Salesforce, HTML

ETL Tools: Informatica Power center 9.6, Informatica Cloud 9.6, Informatica Power center 8.6, Informatica Data Quality 9.6, ESP, Ab Initio

Schedulers: DAC (Data Warehouse Administration Console), CA7 in Mainframes, Crontab, Autosys

Reporting Tools: Cognos, OBIEE

Utilities: TOAD, SQL Developer

Domain Knowledge: Banking, Healthcare, Telecommunications, Credit Card Business, Insurance, Re-Insurance, Retail, Mutual Funds

PROFESSIONAL EXPERIENCE:

Confidential, Boston, MA

Tech Lead, Senior Informatica Developer, ESP

Responsibilities:

• Gather and analyze the requirements from Business Analysts of Confidential .
• Prepare the technical design documents.
• Perform project activities in compliance with the Agile/Scrum methodology.
• Estimate the efforts (in terms of hours) based on the tasks assigned and plan the work accordingly.
• Make use of the ETL tool like Informatica PowerCenter, ESP and Oracle SQL/PL-SQL appropriately in the project considering multiple factors such as optimal performance and easy maintenance of code by maintaining the industry standards.
• Design and develop new code for bringing in new functionality as per the Business expectations
• Providing knowledge to the code for handling multiple Business cases for a given scenario thus reducing the efforts for doing re-work.
• Migrate the code from development to UAT
• Do the unit testing and integration testing as per test cases.
• Fix the bugs that get popped up during this process
• Provide test results to Business and get their sign-off to go-ahead for further process.
• Creating scripts in Unix for auditing and scheduling of batches by considering their dependencies
• Deploy the code to Production following the process from end to end.
• Track the issues and work on them on priority issues.
• Include enhancements in the code based on the on-going business changes.
• Preparing the documentation for easy maintenance of project.
• Update Business and Manager about the timely status of work completion and projected timelines.

Environment: Informatica Powercenter 9.6, ESP, Oracle 11, PL/SQL, Unix, Autosys

Confidential, New York, NY

Senior Informatica Developer

Responsibilities:

• Discussed with Business users to understand their current requirements
• Analyzed the list of existing workflows at each subject area level.
• Prepared the technical design documents.
• Estimated the efforts (in terms of hours) based on the tasks assigned to team and guide them accordingly.
• Designed and developed new workflows wherein the functionality was not incorporated in existing code.
• Purged a part of the existing code that is not required anymore and enhanced where needed.
• Used Informatica Cloud to extract the data from Salesforce to Oracle database.
• Track the issues and work on them on priority issues.
• Tuned the workflows that are having performance issues by taking the statistics from the production environment.
• Created PL/SQL procedures in the instances wherein PL/SQL works much more efficiently than Informatica
• Prepared the test cases and got the sign-off from Business.
• Created deployment groups and migrated the code from Dev to QA environments
• Performed the unit testing and integration testing as per test cases.
• Involved Business wherever needed and got necessary approvals by contacting various teams (like Business users, Informatica Admins, Change Management)
• Deployed the code to Production following the process from end to end.
• Update the Business and Managers about the timely status of work completion and projected timelines.

Environment: Informatica Power Center 9.6, Informatica Cloud 9.6, Informatica Power Center 8.6, Salesforce, Oracle 11, SQL Server, PL/SQL, Unix, Autosys and TOAD.

Confidential

ETL Informatica Tech Lead, Senior Informatica Developer

Responsibilities:

• Leading a team of 11 members in the role of Tech Lead.
• Actively involving in the 24*7 support and doing the enhancements wherever required.
• Analyzing and fixing the code in production instantly after doing quick testing in production-like environment whenever there is a job failure due to the code issue.
• Tuning the Informatica workflows for optimal performance.
• Used various sources such as Flat files, Relational database and Web services as part of Informatica Mappings.
• Creating scripts in Unix for auditing and scheduling of Informatica batches
• Providing the permanent fix whenever the jobs get failed due to repeated issues.
• Preparing the documentation for easy maintenance of project.
• Automated the jobs by considering their internal dependencies and based on upstream.
• Integrated data from different sources.
• Closely working with Business users during the month-end batches and provides timely updates in terms of status of the batches (as they get executed continuously for 2 days) as these are very critical to the Business for reporting purpose.
• Creating the OBIEE reports based on adhoc requirements from Business.
• Providing necessary support for OBIEE queries whenever required.
• Working over the incidents/tickets that are created by different business users by prioritizing them based on issue criticality. Using the Tivoli scripts for creating the alerts/incidents whenever there is a job failure in Informatica and when OBIEE services go down.
• Actively participating in the DR (Disaster Events) that take place over the weekends in every quarter.
• Update Business whenever there is any delay in the batches (for any reason) and plan accordingly so that there should not be much impact to Business.
• Working along with the team as a part of the regular activities in day-to-day work along with the other responsibilities.
• Assign the team members accordingly to complete the work based on their competent.
• Created partitions to handle huge data at database level.
• Track the status of work from time to time and provide timely updates to team lead.
• Provides spontaneous response to the queries posted by business users and supporting teams.
• Handling escalations in the best way whenever there are any.
• Scheduling the calls with Business users to understand the issues clearly and solve the issue accordingly.
• Encouraging the team to participate in multiple events that are conducted by Organization.

Environment: Informatica Power Center 9.6, Informatica Data Quality (IDQ), Oracle 11, SQL Server, Unix, Tivoli, OBIEE 10, TOAD and Mainframes.

Confidential

ETL Informatica Tech Lead, Senior Informatica Developer

Responsibilities:

• Participated in discussion with senior management team for the better understanding of business requirements.
• Involved in Analysis phase of business requirement and design of the Informatica mappings using low level design documents.
• Designed the project in such a way that there are 2 phases, SDE and SIL, as per the BI standards at Informatica (9.1) level. SDE - Source Dependent Extraction, where the data gets extracted from different source systems to staging tables. This is the staging area. SIL- Source Independent loading, where the transformed data will be loaded into the final target tables.
• Helping the team in resolving technical/non-technical issues.
• Participated in the DAC implementation.
• Handling the work in best way between Onsite and Offshore teams.
• The EP’s were scheduled at DAC level as per client specifications after creating the tasks, assembling ‘subject areas’ and building the ‘Execution plans’.
• Prepare the road-map for the completion of tasks and plan to share the work among the team as per each individual capability.
• Created Sessions, Reusable Worklets and workflows in Workflow Manager and Scheduled workflows and sessions at specified frequency.
• Hands on experience in handling large volumes of data in production environments.
• Involved in Performance tuning by determining bottlenecks in sources, mappings and sessions.
• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Used Teradata as one of the source systems to extract the data using Informatica.
• Troubleshooting the loading failure cases, including database problems
• Prepared Documents like Technical Design Doc, Production Support Doc, Deployment Doc
• Documented Mappings, Transformations and Informatica sessions.
• Also involved in the data integration from multiple sources.
• Analyzed Session Log in case session fails to resolve errors in mapping or session configurations.
• Used TOAD to run SQL queries and validate the data in warehouse and mart.
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Created Materialized views at database level and refresh them at ETL level for ease access of data for OBIEE.

Environment: Informatica Power Center 9.1, OBIEE 10, DAC, Unix, Oracle 11, SQL, PL/SQL and Teradata.

Confidential

Informatica ETL Code Designer and Developer, PL/SQL Developer

Responsibilities:

• Created effective Test Cases and did Unit and Integration Testing to ensure the successful execution of data loading process.
• Tracked the status of work from time to time and provided timely updates to team lead.
• Gathered requirements from Client through calls and emails.
• Development and testing of mappings at Informatica level.
• Created PL/SQL Packages in Oracle for data validations (like Database Validations i.e. primary, foreign key and check constraints) as per the functional and technical documents.
• Provided test results to client and get sign-off for the same to deploy code in live environment.
• Migrated the code from UAT to production environments.
• Fix the issues as per the results of validations from PL/SQL packages in production.
• Provided spontaneous response to the queries posted by business users and supporting teams.
• Involved in designing the ETL testing strategies for functional, integration and system testing for Data warehouse implementation.
• Used normalized data model in the target database.

Environment: Oracle 9i, SQL, Informatica 8.1, TOAD, SQL Developer, PL/SQL, Unix, Shell Scripts.

Confidential

ETL Designer and Developer

Responsibilities:

• Analyzed the existing business model.
• Interacted with business users on weekly basis in finalizing high-level business requirements.
• Prepared detail-level design documents based on the discussions to get sign-off from business.
• Analyzed the impact and provided estimations in PD’s to Client whenever there was a change in client requirements.
• Created Informatica jobs to extract data from different external sources and populate into data warehouse tables/flat files by transforming the data as per business rules.
• Involved in Unit testing and Integration testing of Informatica workflows.
• Responsible for tuning the Performance of Informatica ETL mappings.
• Reviewing and testing of mappings, sessions, workflows.
• Analyzing the impact and providing the Estimations to Client in PD’s whenever there is a change in the requirement.
• Provided the warranty support by interacting with production support teams.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, UNIX, Shell Scripts.

Confidential

Informatica Developer

Responsibilities:

• Created the detail design documents after analyzing the business and the databases.
• Interaction with the business users for gathering the requirements.
• Created Informatica Workflows as per the business rules to load data into oltp databases.
• Responsible for Tuning the Performance of the ETL mappings.
• Reviewing and testing of mappings, sessions, workflows.
• Created scripts in Unix for scheduling the Informatica jobs
• Shared the test results to Business and got the sign-off for migrating the code to Production.
• Created scripts in Unix for scheduling the Informatica jobs
• To add on, Unix scripts were also created for validating the data between sources and corresponding targets.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, Unix, Shell Scripts.

Confidential

Informatica Developer

Responsibilities:

• Created Workflows in Informatica as per the new requests from Onsite team.
• Embedded new business logic in the Informatica code with minimal effect to existing code in production environment.
• Tested the workflows and providing the test data to users.
• After getting sign-off, moving them to the production environment.
• Also providing support to the existing workflows in Production by debugging them whenever there they failed and resolving the issue.
• Development of Cognos Cubes, Impromptu Reports according to the Requirements
• Testing and proving the test data to users.
• Publishing Cubes and impromptu reports to Upfront.
• Support and Maintenance of Existing Cognos Cubes.

Environment: Oracle 9i, SQL, Informatica, TOAD, SQL Developer, PL/SQL, UNIX, Shell Script, Cognos 7.0

Confidential

Informatica Developer

Responsibilities:

• Loading of data using ETL tool as Ab Initio.
• Understanding the specific requirements of the module
• Interaction with the client.
• Coding using PL/SQL.
• Database management and connectivity
• Integration of the modules.
• Creating test cases
• Resolving the issues asked by Users
• Responsible for overseeing the Quality procedures related to the project.

Environment: Informatica, Oracle, SQL Developer, PL/SQL, Autosys