SUMMARY:

• More than 12 years of experience in Information Technology predominantly in the area of Banking, Finance, Insurance and Telecommunication.
• Expertise experience as ETL Integration SME in setting up Data Ware housing environment, replicating Salesforce data and using ETL tool like Informatica to extract, transform and load data from several legacy systems into several systems mainly Confidential and Salesforce.
• Expertise experience as Informatica SME and in Informatica LOB admin duties which includes but not limited to set - up Informatica repositories and its related plug-ins, maintain all non-prod Informatica environments with prompt upgrades, install Power-Center binaries, set-up Informatica users, roles, folders, set-up code deployment for Informatica and deploy Informatica codes in all non-prod environments.
• Expertise Technical experience in setting up of Informatica 9.x in the UNIX/Linux server, power center binaries (9.0.1/ 9.5.1/9.6.1 ) in client servers, set-up Cipher for informatica repositories, MQ, Confidential and Salesforce plug-in binaries.
• Expertise Technical experience in setting up UNIX scripts to execute Informatica workflows using pmcmd to schedule jobs through ESP, code deployment using pmrep commands and experience in Informatica Metadata Queries.
• Expertise Technical Experience in Informatica Power Center 9.x/8.x tool - Mapping Designer & Mapplets, Workflow designer & worklets and Various Complex Transformations.
• Expertise Technical Experience in UNIX Shell (Ksh, bash, csh), Perl, Informatica 9.x/8.x, Oracle SQL (SME), MS-SQL, SOA, MQ services, Web service calls, CDC, ESP, Confidential, Salesforce, Informatica IDQ, Business Objects (BO) and Core JAVA.
• Strong Technical experience in investigating Confidential issues using Confidential Tools and reading through Object Manager logs, EIM launcher logs etc.
• Strong Technical experience in investigating Salesforce issue using Force.com, monitoring batch jobs, querying in salesforce developer console, set up users and reset user id, create cases in salesforce to resolve issues if needed.
• Strong Technical experience in Oracle databases (12c/11g/10g/9i) PL/SQL programming, SQL loader, Database tuning, building complex queries, Hierarchical Queries, Dynamic SQL, Varrays, Associative arrays, Collections, Nested tables and Exception Handling.
• Strong Technical experience in using Oracle development tools such as Tool for Oracle Application Development (TOAD), SQL developer, SQL* Plus, and PL/SQL Developer.
• Strong experience in design, implementation, customization and production support of Oracle Applications 11i (GL module).
• Experience in supporting various environments, handling incidents, escalation procedures and providing immediate solution for real-time issues.
• Experience in retrieving structured and unstructured data from HDFS (Hadoop Distributed File System) using Pig, MapReduce and querying data using Hive.
• Experience in using version control tools like Sub-Version, Harvest, GitLab, GitHub, PC based version control (PVCS) and star team
• Experience in creating test plan, unit test cases, debug and writing technical specification documents using tools like Word, Excel, PowerPoint, Visio.
• Experience in Quality process like PCMM, CMMi, Agile, SDLC and Six sigma practices.
• Excellent communicating skills with multiple levels of management including external vendors, Leadership skills, Organizational skills, Problem solving skills, Trouble shooting skills, Analytical skills and Triage skills. Self-motivated, Hardworking, ability to work Independently or Co-operatively in a team.

TECHNICAL SKILLS:

Databases (DB) : ORACLE 12c/11g/10g/9i, DB2, Netezza, Teradata and MS-SQL.

Database Languages: SQL, PL/SQL, T-SQL, MS-SQL, SQR and DB2.

Oracle Utilities: EXP/IMP, SQL * Loader, EXPLAIN PLAN, STATS PACK, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM).

DB Development Tools : QUEST TOAD, Force.com, Oracle Enterprise Manager, SQL Developer, PL/SQL Developer, SQL Navigator, SQL* Plus, iSQL* Plus, Erwin and SQL Server management studio.

Reporting Tools: Oracle Developer 2000, Business Objects, Tableau and Crystal Reports.

ETL Tools : Informatica 9.6.1/9.5.1/9.0.1/8.6.1/8.5.0, DataStage.

Data Tools : Informatica IDQ, Hadoop (Pig and Hive).

Applications (CRM) : Oracle Application 11i (General Ledger - Financial Module), Confidential 8.1.1.14 and Salesforce.

Encryption Tool : Cipher Cloud.

Operating System: UNIX, LINUX, AIX, Solaris, WINDOWS NT/2000 and DOS.

Version Control Tools : Subversion, GitHub, GITLab, Harvest, PC based version control system (PVCS) and Star team.

Scheduling Tools: Cybermation ESP, Zeke Scheduler, Maestro, Tivoli, Control-M.

Other Languages : VB, Shell programming, Perl, COBOL, C /C++ and JAVA.

Other Apps/Tools/Utilities: HP Quality Center 9.2, HP OpenView Service Center, Infra Enterprise, Defect change management system (DCMS), Lotus Notes 8, Microsoft Outlook, Mercury Load Runner, Putty, Telnet, WinSCP, Hummingbird, AnyClient.

PROFESSIONAL EXPERIENCE:

Confidential, Columbus, OH

Informatica Tech Lead / Architect / LOB Administrator

Responsibilities:

• Analyze the existing environments and provide a business solution to support business needs using Informatica tool.
• Analyze Complex PL/Sql code and convert them into Informatica mapping.
• Write Complex Informatica mappings to use XML source, targets, MQ source and targets and extensively use transformations such as Update Strategy, Stored Procedure, Sequence Generator, Transaction control, Custom transformation, SQL, Aggregator, Look-up, Normalizer, Filter, Joiner, Router, Sorter, Union, Java, XML parser, XML generator etc.
• Set up Informatica connections to load data into different databases.
• Write complex Unix scripts to invoke Informatica workflows from command line.
• Write sql scripts to load data about the job.
• Use parameter files to pass dynamic values to the Informatica workflows.
• Define Informatica standards for the version control.
• Version controlling all Informatica Code using GitHub and using GitHub to deploy codes in non-prod environments.
• Automate the workflow using 3rd party scheduler like maestro and ESP.

Environment: Confidential 8.1.1, Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, RAC, PL/SQL, ESP, Maestro, Informatica 9.0.1, Harvest, Sub-Version, HP Quality Center and HP Service center.

Confidential

Informatica Tech Lead / Architect / LOB Administrator

Responsibilities:

• Gather 9.5.1 to 9.6.1 merge requirements and details.
• Merge the IDS repository in 9.5.1 Informatica version control environment to 9.6.1 Informatica environment.
• Identify the SOAP mismatch error between Informatica and salesforce.
• Informatica provides a 27.0 Soap version by default where as salesforce has stopped supporting SOAP version 27.0 in its application.
• Work with Project team and salesforce vendor to identify the columns in Salesforce that are visible only in certain SOAP version.
• Identify the TLS upgrade from 1.1 to 1.2 in salesforce upgrade for non-prod environments.
• Work with Informatica vendor and get the SOAP upgraded from 27.0 to 33.0 with backward compatibility in the 9.6.1 repository.
• Work with EICC team to install the SOAP upgrade in lower environments and test the changes.
• Open high priority incident with Informatica Vendor and receive the patch for TLS upgrade.
• Work with EICC team to install the changes in lower environments and test it successfully with backward compatibility.
• Install both the fix in PROD 9.6.1 environment.
• Verify all the Informatica objects like workflows, worklets, session, mapping, mapplets, sources, targets, shortcuts and connection objects in the Informatica repository
• Communicate client side changes to the team who use 9.6.1 environment.

Environment: Oracle 11g/10g, Linux/UNIX, TOAD, RAC, ESP, Informatica 9.5.1, Informatica 9.6.1, Sub-Version, HP Quality Center and HP Service center.

Confidential

Informatica Tech Lead / Architect / LOB Administrator

Responsibilities:

• Gather 9.6.1 upgrade requirements and details.
• Make key decision like using SAN over NAS for Informatica server to keep all high availability applications available 24/7.
• Define the number of non-prod environments required before prod environment.
• Define the order of the environment DEV, TEST (Alpha), PT (Beta) and PROD in which code deployment will happen.
• Size SAN according to our repository requirements.
• Install power center binaries on the client side implementation after repository and integration services are created on the Informatica server.
• Set up generic id access for Informatica Linux servers.
• Design and set up Informatica folder set up for Informatica servers and client side servers.
• Set up and Validate Confidential Plug-in and Salesforce Plug-in.
• Configure MQ client for Informatica 9.6.1 environment.
• Define roles and user set up for the repository access.
• Create folder and provide access to the users in the repository.
• Set up and verify PMCMD and PMREP commands in the bin scripts.
• Set up all bin scripts to point to the new binaries of Informatica 9.6.1 repositories.
• Verify all the Informatica objects like workflows, worklets, session, mapping, mapplets, sources, targets, shortcuts and connection objects in the Informatica repository.
• Set up purge jobs at the repository level to purge session logs from filling up of repository.
• Help team to set up 9.6.1 client in their machines after sending out the detailed email communication.
• Use code deployment tool to move code in all non-prod environments.

Environment: Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, RAC, PL/SQL, ESP, Informatica 9.5.1, Informatica 9.6.1, Sub-Version, HP Quality Center and HP Service center.

Confidential

Informatica Tech Lead / Data Integration Architect

Responsibilities:

• Define number of generic ids for all environments needed for the project.
• Name the generic id’s as per the NW policy.
• Work with architect and get approval for generic id’s.
• Submit the non-expiring access id request for all the generic id’s.
• Verify home directory for the generic id.
• Size the NAS needed for the project in all environments.
• Define the directory structure for the NAS.
• Work with the architect and get approval for NAS sizing.
• Submit ITTL for creating NAS and work with server team.
• Create the directory structure for all the environment.
• Create soft-link to point to the NAS directory.
• Give appropriate permission to the directories.
• Size the MQ client after analyzing the requirement.
• Define back-out MQ size.
• Define the permissible limit that MQ can reject in to the back-out MQ.
• Work with architect to set the alerts for the MQ.
• Get the XSD from Salesforce and provide it to SOA to write it to MQ.
• Get the XSD from Confidential and provide it to SOA to get the proper input from them.
• Work with SOA team on the end-point URL’s needed.
• Work with the SOA team on the Salesforce and Confidential Date formats.
• Work on the web service-call for the several salesforce object values.
• Test the XMLs from SOA Data-Power.
• Test the web service call created.
• Work with ECIF team to understand CDC and how they have implemented CDC in their project.
• Create directory structure for CDC to write files into the NAS path.
• Create sticky bit on group id for CDC Output directory so that CDC user group has access to the directory.
• Work with RMS DBA and create utility scripts to change permissions for the file created by CDC application.
• Work with RMS-DBA, Oracle run DBA and EICC to sync the redo log switch in the database.
• Work with RMS DBA to define and create parent and child set of subscription.
• Define time intervals for each set of subscriptions.
• Work with scheduling team for the ESP infrastructure.
• Define the jobs that needs to be scheduled in ESP based on the real time SLA.
• Group the parent and child subscriptions under different ESP application folder based on CDC subscription that is defined.
• Run Parent ESP jobs between 01 to 59 mins every hour.
• Run Child ESP jobs between 05 to 59 mins every hour.
• Work with EICC team to get generic id access to the informatica servers.
• Size informatica SAN environment for informatica directory structure.
• Generate RSA key for the generic id in the application server and add it to the informatica servers for easy communication between the servers.
• Set up sticky-bit on application user group in the informatica folder in informatica server.
• Work with EICC team to set up MQ client in the informatica repositories.
• Work with EICC and informatica vendor to set up Confidential informatica plug-in in the informatica repositories.
• Work with EICC, informatica and salesforce vendor to set up Salesforce plug-in (Informatica cloud) in the informatica repositories.
• Set up pmcmd and pmrep command for Invoking informatica workflows and code movement.
• Define users, group, roles in the informatica repositories.
• Define temporary process for the code movement with in informatica.
• Grant roles and permissions on the other Database schemas to user created for this project.
• Create the DB Objects needed for project along with their indexes and foreign key definitions.
• Modify DB tables to add few salesforce data into the Confidential database.
• Update Confidential tables with Salesforce row-id for the roundtrip.
• Work with Confidential team to create Confidential business service that will be invoked by informatica mapping.
• Work with the Confidential team and get the XML format that Confidential business service accepts.
• Define round-trip logics and log the input XML to the database with the Confidential SME.
• Install Confidential -plug-in binaries in the Informatica Power center client.
• Work with Salesforce team to create custom objects that will be used by informatica mapping.
• Work with the Salesforce team and get the XML format for the SOA to work on.
• Install Salesforce-plug-in (Informatica cloud) binaries in the Informatica Power center client.
• One-time data load of legacy Confidential data into salesforce environment.
• Update Salesforce data with Confidential Row-ids for the roundtrip.
• Install Cipher certificates in Informatica bin directory.
• In corporate Cipher URL with in the informatica workflows.
• Provide the Cipher URL to the SOA team.
• Work with Cipher Vendor to resolve issues that occur during informatica development.
• Work with Informatica and Firewall team to open up port in the informatica server to use salesforce plug-in.
• Submit necessary firewall request needed for the project.
• Gather business requirements.
• Analyze the existing Confidential environment and provide a business solution to support business needs in Salesforce using Informatica as Data Integration tool.
• Design and Set up Informatica environments.
• Design and Set up the UNIX environment for informatica to stage files before the actual database Load.
• Design and Set up the Oracle Database to host the data using intermediate tables before actually loading the data into Salesforce.
• Write Complex informatica mappings to use Confidential source along with Confidential Business Service Objects, Confidential EIM Read, Confidential Load and Confidential Invoker transformations via informatica Confidential plug-in.
• Write Complex informatica mappings to use Salesforce source and targets using several transformations including Salesforce look-ups, Salesforce Merge etc. via informatica salesforce plug-in.
• Write Complex informatica mappings to use XML source, targets, MQ source and targets and extensively use transformations such as Update Strategy, Stored Procedure, Sequence Generator, Transaction control, Custom transformation, SQL, Aggregator, Look-up, Normalizer, Filter, Joiner, Router, Sorter, Union, Java, XML parser, XML generator etc.
• Write complex shell scripts to execute informatica workflows using pmcmd and control source code movement using pmrep command.
• Write complex shell scripts to pass mapping parameter values to the informatica workflow from Linux command line.
• Write complex reusable shell scripts to run the ESP jobs on hourly basis along with maintaining parent child relationships and near real time SLA of 20 minutes.
• Create and populate data in to DB table to maintain a log of jobs that ran and input files that they used.
• Write complex SOQL to query Salesforce cloud data.
• Write Informatica mappings to replicate Salesforce data into local database.
• Set up subscriptions in IBM Data stage environment to Capture Data Change in Oracle database and load them into Salesforce.
• Automate the informatica code movement in informatica environments like Dev, Test, PT.
• Write purge scripts to purge old logs and data in compliance with Nationwide Data retention policy accepted by business.
• Automate the workflow using 3rd party scheduler like ESP.

Environment: Confidential 8.1.1, Salesforce, Force.com, Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, PL/SQL, ESP, Maestro, Informatica 9.5.1/9.6.1, Harvest, Sub-Version, GIT, HP Quality Center, Service One and HP Service center.

Confidential

Informatica Tech Lead

Responsibilities:

• Work on the service center incidents P0, P1, P2, P3 and P4 and depending on the priorities take action on the incidents.
• Understand the business criticality and lower or increase priority of the incident depending on the incident in service center.
• Identify the Data that needs to be corrected using the SQL queries, create a DML statement to fix the identified data and submit an ADS request to fulfill required Data changes.
• Work to improve the performance of existing Informatica jobs, improving performance of the views by tuning the queries or creating point-in-time to frequently used queries.
• Work on Confidential screens like adding a new tab or change the query in the screen to populate different set of data by moving the Confidential SRF using Confidential Tools.
• Create EIM jobs to populate data for one-time data fixes as well as creating new EIM jobs to populate data on the Confidential tables using IFB files and PL/SQL programs.
• Work on Code-deployment using Informatica version control on all Informatica environments.
• Work on highly critical P0 service interruption incidents and resolve the issue to restore service.
• Work with management team and provide business case for the Confidential Plug-in.
• Work with other teams inside Nationwide and external vendor if needed.
• Excellent communication skills and ability to work with all levels of management during any issues.

Environment: Confidential 8.1.1, Confidential Tools, Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, PL/SQL, ESP, Maestro, Informatica 9.5.1, Harvest, Sub-Version, GIT, HP Quality Center and HP Service center.

Confidential

Senior Informatica Consultant

Responsibilities:

• Gather business requirements.
• Analyze the existing environments and provide a business solution to merge 2 data warehousing environments (RETL and BEST) into a 1 data warehouse environment using Informatica tool.
• Set up the UNIX environment for informatica to stage files before the actual database Load.
• Write complex Unix scripts to invoke informatica workflows and daemon jobs in UNIX to load the environment files.
• Write complex SQL queries, Pl/sql, cursors, stored procedures, functions, packages, triggers, materialized views, dynamic SQL and handle exceptions.
• Design Mappings, Create Workflows using Informatica 9.0.1 as per the business requirement.
• Design Relational model between the database objects.
• Automate the workflow using 3rd party scheduler like maestro and ESP.

Environment: Confidential 8.1.1, Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, RAC, PL/SQL, ESP, Maestro, Informatica 9.0.1, Harvest, Sub-Version, HP Quality Center and HP Service center.

Confidential

Informatica Consultant

Responsibilities:

• Gather requirements from business and vendor, analyze, design database objects, code, automate, debug, test and implement.
• Design Relational model between the database objects and set up Type 4 Dimension data warehousing environment.
• Write complex SQL queries, PLSQL cursors, stored procedures, functions, packages, triggers, materialized views, dynamic SQL and handle exceptions.
• Set up Informatica client infrastructure for the Data Integrator environment.
• Design Mappings, Create Workflows and monitor the jobs using Informatica 9.0.1
• Write complex shell scripts to execute informatica workflows using PMCMD and control source code movement using PMREP command.
• Generate files from the informatica 9.0.1 in a specified format.
• Setup up eb2b connections to send encrypted files to the vendor.
• Automate Informatica workflow with the 3rd party scheduler.
• Generate success e-mail for the business.

Environment: Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, RAC, PL/SQL, Erwin Data Modeler, ESP, Informatica 9.0.1, Sub-Version, HP Quality Center and HP Service center.

Confidential

Senior Data Warehouse Consultant

Responsibilities:

• Gather requirements from different source systems, analyze, design database objects, code, automate, debug, test and implement.
• Set up database objects relational model.
• Write complex SQL queries, PLSQL cursors, stored procedures, functions, packages, triggers, materialized views, dynamic SQL and handle exceptions.
• Load the Source system files to the Database staging area and to the Relational Data Model progressively after implementing the business logic.
• Generate reports using PL/SQL package UTL FILE and e-mail it to the business.
• Automate the process and provide Warranty support for the project after implementation.

Environment: Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, RAC, PL/SQL, Erwin Data Modeler, ESP, Zeke, Sub-Version, HP Quality Center and HP Service center.

Confidential

Senior Oracle Database Consultant

Responsibilities:

• Gather requirements from different source systems, analyze, design database objects, code, automate, debug, test and implement.
• Create database objects and set up database objects relational model.
• Write complex SQL queries, PLSQL cursors, stored procedures, functions, packages, triggers, materialized views, dynamic SQL, SQL Loader scripts and handle exceptions.
• Set up file monitoring scripts in the operating system to look for the source system file and trigger the Input file validation job.
• Load the Source system files to the Database staging area and to the Common Data Model progressively.
• Send success e-mail to the business.
• Automate the scripts for the daily process.
• Warranty Support for the project.

Environment: Oracle 11g/10g, Linux/UNIX, TOAD, Oracle SQL Developer, RAC, PL/SQL, Erwin Data Modeler, ESP, Zeke, Sub-Version, HP Quality Center and HP Service center.

Confidential, Irving, TX

Senior Oracle Database Consultant

Responsibilities:

• Gather business requirements, analyze, design, code, debug, test and implement.
• Set up the oracle 11g database as per the requirements.
• Write complex SQL queries, advanced PL/SQL, triggers, materialized views, dynamic SQL, UTL FILE and handle exceptions.
• Set up connectivity between MS-SQL 2008 and oracle 11g database.
• Load data into MS-SQL database and Oracle 11g database.
• Size database objects for effective space management and optimal performance.
• Install application, web and ETL server in the LINUX environment to host MERCED application.
• Schedule jobs to archive application logs and load data into the MERCED database.
• Work with the MERCED vendor to resolve application issues.

Environment: Oracle 11g/10g/9i, SQLServer2008/2005, Linux/UNIX, TOAD, Windows 2003, RAC, PL/SQL.

Confidential, San Antonio, TX

Senior Oracle Database Consultant

Responsibilities:

• Gather business requirements, analyze, design, code, debug, test and implement.
• Write complex SQL queries, PLSQL cursors, stored procedures, functions, packages, triggers, materialized views, dynamic SQL and handle exceptions.
• Sizing database objects for effective space management and optimal performance.
• Make structural changes to the database when design changes are made.
• Tune long running SQL queries.
• Monitors, analyzes and tunes performance bottlenecks in the client’s application database infrastructure using UNIX-based tools and Quest TOAD.
• Create and execute test plan.
• Write shell, Perl and JAVA utility scripts.

Environment: Oracle 11g/10g/9i, SQLServer2005/2000, Linux/UNIX, TOAD, Windows2003, RAC, PL/SQL, Crystal reports, Informatica, IBM AIX, IBM Tivoli Enterprise, Infra Enterprise, Star team.