SUMMARY

• More than 10.9 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.
• Also got 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 projects.
• Successfully co-coordinated for the project activities in off-shore/onsite model with a team of 12 members.
• Worked on Webservices as a part of Informatica and obtained the successful connection of the external Webservice call.
• 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 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 Powercenter 8.6, Informatica Powercenter 9.6, Informatica Cloud 9.6,Informatica Data Quality 9.6, 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, TX

Senior Informatica Developer

Responsibilities:

• Interact with Business users to understand their requirements.
• Update offshore teams with the technical design document and share ETL design
• Build the code using Informatica and PL/SQL as per the client’s requirements
• Share the test results to Business and get the sign-off from them
• Deploy the code in production.
• Provide the support to the code in production for 2 weeks.

Environment: Informatica Power Center 9.6, Salesforce, Oracle 11, MySQL, PL/SQL, Unix, Cron Scheduler and TOAD.

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 anymoreand 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
• Did 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 8.6, Informatica Power Center 9.6, Informatica Cloud 9.6, Salesforce, Oracle 11,SQL Server, PL/SQL, Unix, Autosysand TOAD.

Confidential, Atlanta, GA

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 Flatfiles, Relational database and Webservices 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 upstreams.
• 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 andMainframes.

Confidential, Tampa, FL

ETL Informatica Tech Lead, SeniorInformatica 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, Tampa, FL

Senior Informatica Developer

Responsibilities:

• Worked with Business analysts to understand business/system requirements in order to transform business requirements into effective technology solutions by creating Technical Specifications (Source to Target Documents) for the ETL from the Functional Specifications.
• Arranged weekly meetings with the offshore team and discuss both the technical and non-technical issues along with the status of work from time to time.
• Worked on Informatica tools like Designer, Workflow Manager, and Workflow Monitor.
• Worked mostly on Lookup, Aggregator, and Expression Transformations to implement complex logics while coding a Mapping.
• Worked with Memory cache for static and dynamic cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Monitoring the Jobs, observing the performance of the individual transformations and tuning the code(Performance Tuning)
• Migrating objects between different Environments using XML Export/Import (using Repository Manager).
• Developed code to load the data from Flat File to stage and stage to DWH.
• Developed mappings with XML as target and formatting the target data according to the requirement.
• Designed and developed Informatica mappings for data loads and data cleansing.
• Created mappings to in corporate Incremental loads.
• Developed Mapplets to make use of re-usable logic at different mapping levels.
• Working with Power Center Versioning (Check-in, Check-out), Querying to retrieve specific objects, maintaining the history of objects.
• Designed the Workflow for the ODS load following the load Dependencies.
• Involved in fixing Invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Solely responsible for the daily loads and handling the reject data.
• Generated queries using SQL to check for consistency of the data in the tables and to update the tables as per the requirements.
• Creating stored procedures and sequences to insert key into the database table.
• Involved in writing PERL scripts for file transfers, file renaming and few other database scripts to be executed from UNIX.
• Extensively Used Perl Scripting to schedule the Informatica Jobs.
• Maintained/Fixed bugs in existing PERL scripts.
• Guided the testing team and the development team and monitored the Implementation.
• Provided support for the Nightly jobs.
• Used Autosys as the scheduler for executing the Informatica workflows.

Environment: Informatica Power Center 8.6, Erwin 4.5, Oracle 10g, PL/SQL Developer, XML, Windows XP, PL/SQL, PERL, TOAD

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 datamodel 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