CAREER OBJECTIVE

Seeking a challenging position in information technology, that leverages my 20 years of experience in design, development, quality assurance, implementation and maintenance of critical business applications.

For the past 13 years, my career focus has been in ETL Design and Development for Insurance and Financial systems.

SUMMARY:

Expertise in System Analysis, Design, Development and Implementation in Insurance, Financial and Government Domains.

Extensive experience in designing and creating data marts using ETL tool Informatica Power Center 9.6/9.1/8.6/8.1.1/7.1.1

Experience in Business Objects architecture, universes and managing repository, users.

Extensive experience in Dimensional Data modeling using Erwin.

Extensively worked on Oracle 12.1/10g/9i, DB2, SQL server 2000, MS Access, XML files, COBOL files and flat files.

In Depth knowledge of SQL, PL/SQL, triggers, stored procedures, and performance tuning.

Experience in writing UNIX scripts for ETL specific routines.

Expertise in Unit Testing, Integration Testing, System Testing and Data Validation.

Solid understanding of Data Warehousing life cycle methodologies.

Around six years of Production Support and Maintenance experience with data warehouse applications.

Self-Motivated, Highly Skilled, Outstanding Organizational Skills and Excellent Communication Skills.

Strong Interpersonal and Analytical skills with a proven track record of success in Dynamic environments.

CORE COMPETENCIES

Big Data : Hadoop, HDFS, MapReduce, Pig, Hive, HBase, Flume, Sqoop, Oozie, Talend

ETL Tools : Informatica Power Center 9.1/8.6/8.1.1/7.1.1/6.1

OLAP Tools : Business Objects 6.5

Databases : Oracle, DB2, SQL Server, IMS BD/DC, MS-ACCESS, Netezza

Data Modeling : Erwin 4.1

Languages : COBOL, CICS, DB2 SQL, JCL, ORACLE, JAVA1.3, J2EE, XML,

ASP, VB Script, JAVA Script, HTML, SAS

OS : UNIX, MVS/ESA, OS390, Windows 2000/XP

Servers : Oracle Web Server, WebLogic, IIS Web Server, Apache Tomcat 5.5

Utilities : TSO, MS Office, MS-Project and VISIO, TOAD, Process Studio, Visual

Source Safe 6.0, Share Point, Quality Centre 9.2, Tivoli (Job scheduling console)

PROFESSIONAL EXPERIENCE

AVIVA Insurance

Senior ETL Consultant Nov’15 - Present

As part of Horizon Guidewire Policy Center (PC) / Billing Center (BC) implementation, PC/ BC data is extracted and merged with existing N0110 from The General Ledger System for Personal Lines (Auto/Property) to feed MIS & EDW systems

Responsibilities:

Analyzed the Policy Center (Guidewire) Business requirements and created detailed design and technical design documents for loading data from Policy Center to downstream Systems

Designed and developed Batch Integration Frame work and Financial Reconcile process against PC/BC/N0110.

Extensively used Informatica Power Center to design multiple mappings with embedded business logic.

Promoted project code ( Informatica, UNIX & Oracle Scripts) across multiple environments using deployment groups and provided the support for PROD deployments

Worked on performance tuning of the ETL Jobs to achieve faster data loads as part of ETL Code Re-factoring

Setup ETL load schedules for batch processing using Zena

Conduct impact analysis and provide feedback on problems and recommends solutions.

Environment: Informatica Power center 9.1, XML, Oracle 12.1, GIT, ALM, JIRA, Guidewire Policy Center, Downstream N0110 process.

SCOTIA BANK

Team Lead/ Senior ETL Consultant Jun’11 - Nov’15

Scotia Bank Enterprise Data warehouse is created to provide user access to key decision making business information. Data feeds are received from multiple source systems on daily, weekly and monthly frequencies.

A single and detailed view of the entire Scotia Bank Data Warehouse is inclusive of more than 3000 business attributes.

Responsibilities:

Interacting with end users and business analysts to gather requirements and prepare design specifications.

Analyzed the Business requirements and created detailed design and technical documents for loading data from source to target.

Designed and developed Informatica Mappings to load data from Source systems to data warehouse.

Extensively used Informatica Power Center to design multiple mappings with embedded business logic.

Created session tasks and workflows in the workflow manager and deployed them across the DEV, QA, UAT and PROD repositories

Worked on performance tuning of the SQL queries, informatica mappings, sessions, and workflows to achieve faster data loads to the data warehouse

Scheduling Jobs and Job streams using Maestro (Tivoli).

Preserve versions of code using Informatica and PVCS.

Carry pager and was on-call supporting all EDW batch processes. Resolve Incident ticket within SLA and document the solutions.

Acting as a team lead and Conduct impact analysis and provide feedback on problems and recommends solutions.

Support the team of SAS Migration from version 9.1.3 to 9.3.

SAS Admin for SAS platforms (Base SAS, SAS MO, Enterprise Minor/Guide. SNA, Fraud Frame Work)

Perform Root Cause and Diagnostic Analysis.

Support all EDW applications in 30 TB of Production environments.

Environment: Informatica Power center 9.1, DB2, SQL Server, Business Objects, PVCS, Share Point,

SAS 9.1.3, SAS 9.3, DataFlux 8.2, Tivoli, Unix, Cognos 10, Netezza, Big Data

Allstate Insurance Company of Canada

Senior ETL Consultant Jan’07 – May’11

Property and Casualty Insurance Claims Data mart

Allstate Canada is one of Canada's leading producers and distributors of home and auto insurance products.

This project is to build property and casualty insurance claims datamart and generate reports to help the Management and claims employees identify trends and implement timely action plans to improve claim quality and cost management. The ETL process reads data from the source system flat files and writes to target SQL Server datamart.

Responsibilities:

Requirement gathering, Analysis, Coding, Code Review, testing, and Implementation.

Involved in Dimensional modeling to Design and develop Star schemas, using Erwin 4.1.

Performed data analysis on all feeds to ensure granularity matching on targets.

Wrote standards documents, code templates, and introduced reusable objects to speed up development.

Involved in design and development complex ETL mappings and stored procedures in an optimized manner. Used Power exchange for mainframe sources.

Conduct code walkthroughs and review peer code and documentation.

Wrote PL/SQL stored procedures & packages for implementing business rules and transformations.

Load operational data from Oracle, flat files, xml files, Excel Worksheets into various data marts.

Designed error handling strategy for ETL loads and performance tuning

Created UNIX shell scripts used to FTP files, archive data feeds, and to execute Informatica sessions.

Environment: Informatica Power center 8.6/8.1.1, SQL Server, Business Objects, Quality Center, PVCS

MFXchange Holding inc., Fairfax Group, Toronto, Canada

Senior ETL Analyst Sep’02 – Jan’07

Fairfax, a global financial services holding company is engaged in property, casualty and life insurance as well as reinsurance, investment management and insurance claims management.

The project was implemented in various phases. The main objective of the project was to build an Insurance Data mart. As an ETL developer, I was responsible for claims, Finance data mart using Informatica Power Center.

Responsibilities:

Coordinated with the client in gathering user requirements.

Worked with BA’s to develop business requirements and translated into technical specifications.

Design the Technical Documentation for Source to Target Mappings.

Extract, Transform & Load the data from Mainframe to Oracle target database.

Created various transformations in Power Center Designer.

Worked on caching optimization techniques in Aggregator, Lookup, and Joiner transformation.

Developed mapping to implement type 2 slowly changing dimensions.

Environment: IBM Mainframe, Informatica Power center 7.1.1/6.1, Striva, COBOL, DB2,

ORACLE, MS-ACCESS, TOAD

Singapore Network services, Singapore

Systems Analyst Jan 98 - July’02

I was involved in the following Client Server and Mainframe projects for Government of Singapore organizations.

BizNet-- an electronic information database service provided by the Registry of Companies and Businesses offering users online access to information relating to Singapore Companies and businesses.

LawNet – This application which links government agencies such as the Judiciary, the Attorney General's Chambers and the Ministry of Law to the private organizations.

Responsibilities:

Involved in Analysis and Design, discussed with client requirements, prepared necessary specifications, prepared analysis and design documents using Rational Rose.

Developed and maintained the mainframe online systems, migrating to J2EE application.

Generated various types of web reports by using JBuilder 3.5.

Migration of applications from CSP V3.3 to CSP V4.1 and CICS/ESA TO CICS TS FOR S/390

Coded in HTML, PL/SQL procedures, JavaScript, Shell Scripting

Environment:

Mainframe : COBOL, CICS, CSP, DB2, VSAM, IMS, JCL and EASYTRIEVE PLUS 6.2, PL/SQL, Web : Oracle WebServer, Java 1.3.1, Servlets 2.1, Java Beans, JBuilder 3.5, JDBC 2.0, JSP 1.0, HTML and DHTML, XML, VB Script, Java Script, Oracle 9i, UNIX, WIN NT

Indus Computers Pvt.Ltd, India

Software Engineer Jan96 - Dec'97

The process includes Impact Analysis, Planning for Conversion, conversion of source code, Testing and delivery.

Receive the source code from client, prepare the inventory and analyse for obtaining various requisites reports.

Responsibilities:

Involved in Design & Development Software to perform Issuing purchase Orders to vendors, Inventory Maintaining, Opening letter of credits for banks, Analysis of status of vendors & letter.

Involved in Impact Analysis for Y2K conversions and Documentation of application programs.

Mainframe: VS COBOL-II, CICS, DB2, VSAM and JCL, XPEDITER, MF-Revolve/2000

Education

Bachelor of Technology Engineering (B.Tech), Nagarjuna University, India

Post Graduate diploma in Industrial Pollution Management. India

Diploma in Software Applications. India

Adv. Course Internet Technologies, OO Analysis & Design using UML. Singapore

Java & J2EE Developers Workshop (in-house training)

SNS Team challenge Certificate of Achievement

Course on Teradata Database and SAS Administration

SAS Platform Administrator for SAS 9.1, 9.2 and 9.3 (SAS Institute, CANADA)

SAS Enterprise Minor and Enterprise Guide Administration ( SAS Institute, CANADA)

SAS Data Integration Studio ( SAS Institute, Canada)

Completed iLead Courses for Personal Leadership/Management skills Development (in-house Scotiabank)

Selected as a 2013 Best of the best top individual at Scotiabank

Course on Big Data Ecosystems and 2 hands on projects

Contact this candidate