TECHNICAL EXPERTISE:

Operating Systems : Windows /NT/XP, UNIX, MS - DOS

ETL Tools: InformaticaPowerCenter 9.6.1/9.6/8.6/8.5/8.1/7.1 (Designer, Workflow Manager, Workflow Monitor, Repository Manager (IDQ, Power Exchange, SSIS (SQL Server Integration Services)

Databases : Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005, DB2 v8.1

Data Modeling Tools: ERwin, MS Visio

Languages: SQL, PL/SQL, UNIX, Shell Scripts, COBOL, JCL, CICS

Scheduling Tools: Autosys, Control-M, CA-7, Zeke

Testing Tools: Quality Center

Change Management: ITSM, CDT, WASP, Changeman

Incident Management: Peregrine; Alarm Point,Service Now,Workday

EMPLOYMENT:

Confidential, Dublin, Ohio

Informatica ETL Lead Developer

Responsibilities:

• This project is to support Siebel to Sales force Integration
• Responsibilities include supporting any defects Identified after warranty period during Siebel to sales force integration.
• Worked as an ETL Developer Identifying and supporting business to either synch any polices that didn’t made or lost during the round-trip back to Siebel
• Monitor data compliance and proactively address compliance concerns and needs. This position is responsible for identifying data, process and system issues, structuring reporting and full management of data integrity.
• Others responsibilities Includes working with Informatica Admin team and hold Jobs during Patching activity to avoid Informatica job failures which is difficult to find in current scenario to Identify why it failed
• Advised best practices working with EICC team to communicate any maintenance activities to respective support teams to avoid priority one Incident when our Informatica job fails
• Worked in Kings Guard line to support to analyze SEC Audit Quarterly report which in current process they are running in manually and providing it to business Quarterly
• We were asked to analyze that report and develop it in ETL breaking the current manual steps and build mapping out of it after files got FTP into landing Zone.

Environment: Informatica Power Center 9.6.1, Power Exchange, UNIX Shell Script, SQL Server 2008,Siebel, Salesforce, MQ Series, CDC, ESP Scheduling, Mainframe, JCL, FTP, SFTP, WINSCP, BMC Remedy, Quality Center.

Confidential, Plano, TX

Production Support Lead

Responsibilities:

• Responsible for supporting managing monitoring and coordinating fraud AML, ISPII,
• SPIRIT, MSRB Applications.
• Provide IT support of entire AML lifecycle
• Responsible supporting Mainframe batch Applications.
• Responsible for Identifying Jobs and dependencies and document the batch flow to provide confidence to business that we would be able to run the whole batch process manually.
• Worked with different Scheduling and Change management tools like CA7, Zeke, and Changeman.
• Worked with creating new JCL’S and modify CA7 Scheduling and Job dependencies working With Data Canter Operations
• Provide technical solutions to automate processes or functions to improve business Operations
• Support and provide insight into contingency planning initiatives
• Provide after-hours problem escalation coverage, as necessary
• Install patches and updates, determine impact on applications
• Work directly with customers on issues
• Good understanding of application, middleware and database interactions and
• Connectivity
• Experience supporting Web servers and applications
• Strong problem solving and time management skills
• Review Prior Cases and Alerts.
• Responsible for coordinating and Implementing DR Activity for all those first set of 40 compliance
• Applications with an offshore team.

Environment: Informatica Power Center 9.6.1, Power Exchange, UNIX Shell Script, SQL Server 2008, MAINFRAME, CHANGEMAN, FILEAID, JCL FTP, SFTP, WINSCP, AUTOSYS, BMC Remedy, SERVICENOW, QUALITY CENTER.

Confidential, Columbus, OH

Informatica ETL Lead Developer

Responsibilities:

• Created labels based on release and migrate the code from development to UAT environments.
• Worked in team for migrating PowerCenter from 9.1 to 9.5.
• Strong experience in performing Informatica administrative tasks like Domain administration & Repository administration that included software installation/upgrades, Repository Backups and Object Migrations to different environments.
• Led and managed a version control solution (Subversion). Worked on deploying Subversion POC.
• Implemented Subversion in one of the DEV environments.
• Prepared training guide and provided training to a group of developers after implementation.
• Led and managed version control solution (Control-M).
• Trained in Control-M and converted the Rewrite Projects onto Control-M Jobs.
• Built the Control-M Jobs from Scratch and schedule the Jobs in Enterprise Manager.
• WASP: Developed a Standard checker tool in Control-M where XML can be uploaded and run through Standard checker, which will be used before code Promotion to system testing.
• Created EURC requests to create access routes and soft links. Converted all FTP’s to SFTP
• Worked with ITSM Support team and learned the ITSM Process.
• Worked with different teams to make process better within DM&A.
• Completed the ITSM on time and worked with different Approval Groups.
• Assisted offshore developers and prod readiness team while implementing the ITSM.

Confidential, Columbus, OH

Senior Developer

Responsibilities:

• Commercial Lines Production Support / West Virginia Migration / Rate Revision
• Enhancement Projects, Renewal Premium Comparison, Automated Forms Roll on Project,
• Customer Underwriting Rules Rewrite Project
• This is one of the major Initiatives in Nationwide Commercial. The technology platform lacked flexibility and limited new initiative speed to market (Commercial Lines service Center, Geographic Expansion and New Product development). The main aim of this
• Program was automated systems with increased flexibility in the architectural design;
• Improve delivery time for new products/services. Catalyst Conversion: Converting the
• Nationwide’s existing Commercial data, unloading the data from the DB2 Data Base after the daily production flow has completed. This was done in different builds. Catalyst Consolidation: The scope of this project was to consolidate and develop automated features on Allied system. The below list of projects were done as part of Savings as well as adding new functionalities on existing allied systems.
• Converted Nationwide’s existing commercial data, unloading the data from the DB2 database after the daily production flow has completed. This was done in different builds.
• Catalyst Consolidation:
• The scope of this project was to consolidate and develop automated features on allied system. The below list of projects was done as part of savings as well as adding new functionalities on existing allied systems.
• Automate the Property Forms Roll on Process:
• The scope of the project was to automate the property forms roll on process and to create the new form roll on modules and changing the property system and automatic renewal system to interface with them. This module should be able to be used by the Internet system as well for forms roll-on.
• Renewal Premium Comparison:
• Production support (24/7) of Confidential Farm Application.
• Analysis, design coding and testing of mainframe Batch and Online Modules.
• Functioned as a technical expert in the design, development, modification and debugging of Mainframe by writing new customized code as per client requirement.
• Prepared detail technical design document, program specifications, unit test cases and unit test reports, unit test plan, system test plan, system test cases, system test report.
• Designed and developed new table base table for property Forms Automation.
• Worked with Business Analysts to identify technical solutions and prepare technical design documents for Property Forms Roll on Process.
• The scope of the Renewal Premium Comparison project was to increase the percentage of polices that were automatically renewed by the system and consequently reduce the number of polices that are manually reviewed by the processors and Underwriters.
• Converted the outdated SP1 flow and brought it up-to-date with the current test systems for Catalyst Conversion.
• Created document with instructions how to download and load polices to test flows.
• Nationwide Commercial Underwriting System, Columbus, OH
• CUS is executed within the CLIPS II batch stream. CLIPS II formats files to send to the knowledge bases and receives data back with the rules results.
• Solely designed, developed, tested and deployed the whole project.
• Created/modified over 1500 rules that will ensure the policy flow as well as reduce manual intervention during the policy renewal process. Trained the end users on new rules.
• Created FTP process that will upload the reports to electronic file and send it to service centers which created huge saving over printing and mailing.
• Designed and developed separate test flow for testing underwriting rules.
• Confidential, Commercial System Support, OH
• The base of this system is CLIPS II batch. The initial stages of batch flow. Policies are selected off the DB2 master tables and converted to CLIPS II VSAM work format.
• Worked closely with business customers to develop and maintain commercial systems.
• Worked as Lead developer in Front end back end Conversion.
• Involved in programming and unit testing on projects that implements pricing and state mandated changes to the existing system like direct written premium (DWP).
• Generated web enabled non-daily commercial reports.
• Generated FTP transfers of catastrophic modeling reports to outside vendors.
• Prepared disaster recovery plans and performed disaster recovery testing.
• Involved in Unit Testing, Subsystem Testing, System Integration Testing (SIT)

Environment: Informatica Power Center 9.6.1, Power Exchange, UNIX Shell Script, SQL Server 2008, CDC, ESP Scheduling, Mainframe, JCL, FTP, SFTP, WINSCP, BMC Remedy, Quality Center, COBOL, CICS, JCL, VSAM, ORACLE,ZEKEAutosys, ControlM, Service Now, Workday, BMC Remedy ITSM.