Over 5 years and 10 Months of experience in Data migration and Data warehousing projects in insurance domain.
Experience in building Data Warehouse/ Data Marts using IBM WebSphere Datastage 9.1/8.7/8.1 developing and implementing of Datastage jobs using Transformer, Join, Lookup, Merge, Funnel, Filter, ODBC, Oracle Enterprise stage, Data change capture stage , change apply stage, Sequential File, Dataset, File Set, Copy, and Modify Stages Unix shell scripts.
Experience in creating and processing XML file using input and output stages and Web sphere MQ connectors and Web service stages.
Expertise in ETL Architecture and Job flow design for complex projects
Strong understanding of the Data Warehouse principles using Fact Tables, Dimension Tables, Dimensional Data Modelling - Star Schema and Snow Flake Schema.
Experience in Oracle PL/SQL to write stored procedures, packages and triggers. Good understanding of SQL and RDBMS.
Experience in Datastage migration from 8.1 to 8.7 versions.
Experience in scheduling jobs in Autosys scheduler
Exposure to UNIX shell scripts
Exposure to Cognos 10.1
Experience in different types of partitioning methods like Round Robin, Hash Partitioning, Random Partitioning, Same Partitioning etc.
Self motivated, fast learner, excellent communication, interpersonal analytical skills
Have good experience in interacting with various stakeholders such as Data Architect, Database Administrators, Business Analysts, Business Users, Application Developers and Senior Management
Lead a team of 5 associates in development projects.
Good Team Player and key contributor in development team.
Technology Skills
Operating Systems
Databases
Languages
Tools
Win XP/7
DOS
UNIX
Sun Solaris
Oracle 11g
SQL server 2003
DB2/UDB
Teradata
PL/SQL
Unix Shell script
Vista 4GL
IBM Datastage 8.1/ 8.7/9.1
Cognos 8.1
Autosys
SQL tools
TOAD
Application Area
Line of Business Insurance
Line of Technology Data Warehousing
Professional Experience
Confidential
Description
The Guaranteed Cost Workers Compensation Predictive Modeling application, eDecile is as java based Webservice that uses the predictive analytics model for calculating the Decile, Centile scores and reason messages for New business policies and policies that are due to renewal in next 90 days.
eDECILE collects the below information on a monthly basis using Datastage
The policy information from the under writing applications
Related Claim information id pulled from Claims data warehouse.
The Financial information from Billing and invoicing
Interact with Business Analyst and Application team to understand requirements.
Preparing design documents for implementation i.e. functional design and technical design documents.
Creating High level and low level ETL flow diagram in visio.
Providing appropriate solutions and design on the client requirements
Expertise in integrating data sources like Oracle, Flat Files, MS Excel using Active/Passive stages available in Datastage.
Interact with Data Architect to design tables.
Designing jobs in Datastage using Data change Capture and Web service stage
Interact with data architect in database re-modelling to enhance performance of Datastage jobs
Performance Tuning of ETL jobs and SQL queries.
Ensure compliance to Standards
Providing support to business users during user acceptance testing.
Preparing JIL files for scheduling datastage jobs in Autosys scheduler.
Project
Confidential
L
Description
iFEED / Managing General Agent MGA is the insurance sales office that sells contracts of insurance policies on behalf of an insurer. They have a contract with an AIG company to sell certain type of insurance in return for a percentage of the premium as commission. The MGA's have their own systems to capture policy information.
Managing General Agent System is a batch system that receives electronic files through an online system called iFEED from individual agents and processes the information through Datastage and Mainframes and provides the following:
Automated policy premium feeds to report sales to Chartis's Corporate Reporting System CRS .
With new brokers, the volume of files processing each day was increasing and system was not able to process a huge load of files with in a day. Hence, the system was revamped with a new design to support multiple instance features. This helped the system to process more files with 2 times faster than usual.
Interact with Business Analyst and Application team to understand requirements.
Proposed the new design to improve the system performance.
Providing appropriate solutions and design on the client requirements and propose enhancements on the system
Interact with Data Architect to design necessary tables.
Impact analysis on existing components and identify reusable jobs.
Designed jobs in Datastage to run in multiple instances to meet increased loads during month/year ends.
Interact with data architect in database re-modelling to enhance performance of Datastage jobs
Ensure compliance to Standards
Involved excessively in deployment process.
Training and mentoring of new people coming into the team. Communicating and coordinating with Onsite and client.
Confidential
Description
Confidential is the insurance sales office that sells contracts of insurance policies on behalf of an insurer. They have a contract with an AIG company to sell certain type of insurance in return for a percentage of the premium as commission. The MGA's have their own systems to capture policy information.
Managing General Agent System is a batch system that receives electronic files through an online system called iFEED from individual agents and processes the information through Datastage and Mainframes and provides the following:
Automated policy premium feeds to report sales to Chartis's Corporate Reporting System CRS .
Automated account current feeds to report accounting information to SAP.
iFeed has been in production for premium processing since mid-2006
In 2008, the number of premium files processed more than doubled and 2009 files processed grew by 23 as new feeds were added. In 2009, database transactions tables grew by 53 as new feeds and new record types were added and more feeds started to process installments. For transactions' tables alone, the number of records is greater than 16 million rows.
This made an industrial strength enhancement inevitable for making the application capable to meet with the growing needs.
IFEED industrial strength enhancement
Following changes were done as a part of this project.
The existing Datastage server jobs converted to Parallel jobs to handle large volume of data.
Also the jobs were re-designed to process the feeds in real-time rather than in a batch scheduled mode.
The database was remodeled to enhance performance of the Datastage jobs.
The application has been enhanced to accept feeds in an Acord compliant XML file format in addition to the existing flat file format .
IFEED is now integrated EDW enterprise Data Warehousing and the daily manual reporting have been automated through scheduled Cognos reporting from EDW tables.
IFEED Web Front-end has been enhanced with more user friendly screens and now supports application table maintenance which reduces the huge number of DML requests raised the application maintenance team.
Cognos BI Reports
Develop 15 new reports in Cognos using the new EDW data mart, which are currently semi-automated using Datastage.
Increase the volume of batches processed by the application by redesigning the jobs in Datastage 8.1 parallel extender from the existing server design.
Design the jobs to process the batch feeds in near real-time.
Interact with data architect in database re-modelling to enhance performance of Datastage jobs
Interact with data architect in designing the data mart.
Design new jobs to create and process feeds in XML Acord standards compliant format.
Preparation of mapping sheets by analysing each and every job.
Performance tuning of ETL jobs and SQL queries used in the project.
Ensuring the Data Accuracy and Consistency
Assist in Designing and verification of Cognos reports.
Impact analysis on existing components and identify reusable components.
Ensure compliance to Standards
System Testing and UAT Support.
Scheduling Datastage jobs through Autosys scheduler
As a Project lead, following were my responsibilities.
Interact with Business Analyst and Application team to understand requirements.
Conduct regular meeting within the team and delegate and track the status of tasks to team members
Co-ordinating between different technologies like Java, Datastage and Cognos and responsible for the final delivery.
Share the project status report to customer
Establish Best Practices and plan for continuous improvement of processes
Knowledge transition and clarifications to new team members for understanding the business requirement, data model and ETL architecture.
Involved in maintenance of application once it is deployed into live.
Confidential
Description
Offline Dataload project consists Extracts the data from the Vista system, transform and load the data into a repository, CREP Teradata, SQL Server 2005 back and forth. is a leading provider of analytical legal information in print and CD-ROM formats. It offers various legal solutions for libraries worldwide. This entire application is developed on Vista 4GL language. It enables the users to enter their business and process daily
Flat files Vista/ VMS -> CREP Teradata -> CPS SQL Server/MS Access -> BI Teradata -> many Downstream systems.
CREP is the Hub of the customer data. From CREP, the data is flown down to all the downstream systems.
CREP is also used as one-stop shop datastore for the project related data.
Role
DataStage Trainee/ Developer
Solution Environment
Server: Sun Solaris
Databases: Teradata
Tools
DataStage Enterprise 8.1 ETL tool , SSH
Responsibilities
Analysed and understood business requirements provided.
Created high level and low level functional specification document for each code release.
Created ETL high level flow diagram and share it with the architect.
Developed datastage jobs with proper coding standards.
Coordinated with large team including onsite and offshore.
Creating weekly status report on the development to customer and other stake holders.
Documented the existing flow of the project and interfaces.
Tuned performance of ETL jobs and sequences.
System Testing and UAT Support.
Involved in deployment process.
Prepared handshake document to the maintenance team once the release is moved to production.
Monitored periodically for any production issues and provided immediate fix.
Privacy Policy
