data warehouse developer resume

Upload: dinesh-reddy-g

Post on 02-Apr-2018

217 views

Category:

Documents


0 download

TRANSCRIPT

  • 7/27/2019 Data Warehouse Developer Resume

    1/7

    Data Warehouse Developer Resume

    Title

    Data Warehouse Developer

    Primary SkillsSQL Server,SSIS,SSRS, BO, Hyperion Essbase, OBIEE

    LocationIndia-Mumbai (will consider relocating)

    Posted

    Aug-15-09

    RESUME DETAILSSummary

    Myself, Tushar Gore is a Senior Software Engineer working since September 2006 in

    Information Technology and I have worked on various projects involving Data Warehousingplatforms like ETL, OLAP reporting etc. I was involved during various phases of SDLC such as

    Requirements and Analysis, Design and Construction, Testing etc. My core areas of skill are

    design and development using Microsoft SQL Server Integration Services, Business Objects,Microsoft SQL Server Reporting Services, Informatica & Oracle Interactive Dashboard. My

    technical Knowledge is complemented with good communication skill. I had always taken the

    initiative in meeting project deadlines without compromising on the quality of the deliverables.

    Skills

    Business Intelligence Microsoft SQL Server Integration Services, Business Objects 6.1, SQL

    Server Reporting Services, Informatica, Hyperion Essbase, Oracle Interactive Dashboard(OBIEE).

    Tools Erwin Data Modeler, GS Data Generator 2.4, Visual Source Safe, Case Studio

    Database Oracle 9i, SQL Server2005

    Language C, C++, Visual Basic 6.0

    Internet Technology HTML, Java Script

    OS / Environment Windows 98/2k/XP/2003 server

  • 7/27/2019 Data Warehouse Developer Resume

    2/7

    Job Functions Requirement Analysis, Design, Coding, Testing, Documentation, Reporting,

    Application Support.

    Others Good Knowledge of Mechanical Engineering Design Softwares such as AutoCAD,

    AutoDesk Inventor, Ansys, Catia.

    Personal Achievements

    Valuable Contribution Award for ITP Data Migration Project in Q2 -- 2008.

    Awarded by 'STAR -- Pat on the Back' award for working on Complex Reconciliation and

    Document & Reference Module in ITP Data Migration Project.

    Won the 'STAR- Dream Team' award of the year 2008 for 'ITP Data Migration Project'.

    Awarded by 'Letter Of Appreciation' from BICoE for Equity BO Redesign Project.

    Won the 'STAR- Dream Team' award of the year 2006 for 'Project Cornerstone - HLR Data

    Mart' project.

    Professional Profile

    Employer : Patni Computer Systems Limited, India

    Title : Sr. Software EngineerDates of employment : 09/27/2006 till date

    Project 1

    Title : Project Cornerstone - HLR Data MartType : Development

    Platform : SQL Server 2005

    Software : Microsoft SQL Server Integration Services, Hyperion Web Analyzer, Case Studio.

    Client : Hannover Life Reinsurance Co.Duration : 10/10/2006 to 01/15/2007

    Role : Developer

    The project has three modules, BPI, Reinsurance & Merica. BPI, being internal, data from source

    DB is loaded to staging & thereon to EDW (Enterprise Data Warehouse). Reinsurance has two

    phases. In the first phase, data received from various clients in the form of flat files, will beparsed & then meaningfully loaded into Reinsurance source database. In the second phase of

  • 7/27/2019 Data Warehouse Developer Resume

    3/7

    reinsurance, data from source will be loaded into EDW.

    HLR America has designed MERICA (Medical Risk Calculator) rules to provide immediateunderwriting decisions on life and other selected coverage. The Merica Engine has been

    integrated with two front-end systems. The Data from both the systems is populated in Enterprise

    Data Warehouse after ETL process. The ultimate objective of this system is to bestowUnderwriting Department, Marketing Department and Actuaries with the reports to analyze data,so as to help them in making tactical decisions. Multidimensional Cubes are built from the

    Decision Support System (Data Warehouse) and are used for further analysis and slice and dice.

    Reports are sourced from these cubes.

    My responsibilities in this project include:

    1) Development of source to staging and staging to EDW ETL mappings using SQL ServerIntegration Services for MERICA.

    2) Testing of Flat Files which were used as a source for Source to Staging Mappings.

    3) Code Review of mappings from Source to Staging and Staging to Warehouse.4) Defect Fixing on various functional levels.

    5) Data Generation from testing point of view (flat file creation using GS Data Generator 2.4

    Tool),

    6) Unit Testing, Crash Testing, Integration Testing of Mappings.7) Formatting the end reports created using Hyperion Web Analyzer.

    8) Updating the Low Level Design Documents.

    9) Creation of Reusable Component for HLR.

    Project 2

    Title : EQUITY BO REDESIGN PROJECT

    Type : Development

    Platform : Oracle9iSoftware : Business Objects 6.1

    Client : The Guardian Life Insurance Company of America

    Duration : 02/21/2007 to 07/13/2007

    Role : Developer

    The Guardian Life Insurance Company has already existing Equity Data Mart on which Analysis

    Reports were developed. But due to complications in the Data Mart, report queries werebecoming tedious and time consuming. Thus GLIC has demanded that these reports are to be

  • 7/27/2019 Data Warehouse Developer Resume

    4/7

    Redesigned on the source System rather than Data Mart. The project scope is to redesign those

    Reports on source system using Business Objects 6.1.

    My responsibilities in this project include:

    1) Analysis of queries of existing Data Mart based reports.2) Making necessary changes in the Business Objects Source Universe as per the requirement.3) Designing the reports based on source universe using Business objects 6.1.

    4) Development of reports using multiple data providers, prompts, Variables, Sections.

    5) Reports creation using pre defined conditions, filters, Alerter, Ranking.6) Creation of deliverable Design Document for Reports.

    7) Developing the test cases for testing the reports.

    8) Report testing and defect fixing.

    9) Providing support for User Acceptance Testing.10) During Acceptance Testing, the customer sent a long list of queries related to the use of

    universe and reports. I thoroughly analyzed each query and provided detailed resolution along

    with appropriate examples, sample reports.

    A very demanding Customer as well as project managers, BU Heads have appreciated me for his

    excellence and promptness in work.

    Project 3

    Title : Agency Database Reporting

    Platform : Windows Server

    Tools/Software : Business Objects 6.1, Informatica 8.1.1, Oracle 9iClient : Guardian Life Insurance Company

    Type : Data Mart implementation, Development of Reports

    Duration : Feb 2007 to Apr 2007Role : Software Developer

    The Guardian Life Insurance is the fourth largest Insurance & Mutual Fund Company Located inNew York, USA. Guardian is currently into business of life and disability income insurance,

    retirement services and investment products such as mutual funds, securities, variable life

    Insurance and variable annuities.

    Guardian has taken an initiative to consolidate agency expense, production and management data

    in a centralized database for reporting and analysis. The project aims to exploit the power of data

    warehousing tool Business Objects (BO). BO shall be used to generate 4 standard reports that

    shall be scheduled at a specific frequency. In addition to this, the Universe developed shall helpbusiness users, who will be located at single location (NY), to generate ad-hoc reports on their

    own.

    Responsibilities:

  • 7/27/2019 Data Warehouse Developer Resume

    5/7

    As an Analyst/Designer:

    1) Carrying out detailed analysis of functionality of Agency Finance system and understandingclient requirements for database design and reporting purpose.

    2) Creating Requirement Analysis deliverable document.

    3) Designing Data Model, High level and Low level Design.4) Estimation of Database size.

    As a Developer:

    1) Testing of COBOL files using Inforamatica tool.

    2) Designing of ETL strategy using Informatica.

    3) Designing Reports to checking the feasibility of Data Mart using Business Objects 6.1

    Project 4

    Title : ITP Data MigrationType : Development

    Platform : Windows Server 2003

    Software : SQL Server Integration Services 2005, Trillium Discovery 5.Client : The Fund, Florida

    Duration : 7/23/2007 to 6/28/2008

    Role : Software Engineers

    The Fund has embarked upon a program called the Intelligent Title Plan (ITP) to upgrade its

    market offerings for title insurance, with a repository of public records provided in a state-of-the-

    art Microsoft SQL Server 2005 database.

    The project includes Data Assessment task, which assesses data to frame different business rules

    that needs to be applied on the data before loading it to ITP and ITP Interface task, whichextracts data from Mainframe, after which data undergoes various transformations based on the

    rules framed during data assessment and loads it to ITP.

    My Crucial Tasks and Responsibilities:-1) Complete Reconciliation Development where field wise record count is compared through

    various stages of Data migration. The reconciliation code is developed in such a way that, only

    one mapping is executed multiple times using For Each Loop in SSIS. For each Iteration,

    respective source query was passed dynamically to this mapping. This has saved almost 70%efforts as far as coding was concerned.

    2) Creation of Audit Trail Prototype. This was very complex and tedious requirement where

    customer was interested to see and track the change in data from all three stages of datamigration along with Business Rules applied. I had successfully designed the Prototype using

  • 7/27/2019 Data Warehouse Developer Resume

    6/7

    SQL Server Reporting Services.

    3) Report Building using SSRS. The complex reports such as reconciliation, audit trail and

    exception summary reports were created using SQL Server Reporting Services.

    My other responsibilities in this project include:

    1) High level process control package development.(i.e. SSIS Main control Package

    development).2) Code Template creation and updation for SSIS packages.

    4) Data model and physical Database creation for Property, Policy, SUBD, Acreage and

    Control tables.

    5) UTC template, code checklist creation.6) Making necessary changes in the database as per the requirement.

    7) Development of Data Anomalies Extraction Reports.

    8) ETL development, review, testing for various Domains related packages.9) Complete integration of Document and Reference Domain packages along with the integration

    Testing.

    Project 5

    Title : Member Health Data MartPlatform : Windows Server, SQL Server 2005

    Tools/Software : SSIS, SQL Server 2005, Hyperion, SSRS

    Client : Hannover Life Reinsurance Co.

    Type : Data Mart implementation, Development of Reports in Hyperion, SSRSDuration : 07/01/2008 till date

    Role : Developer, Analyst, Onsite co-coordinator

    Member Health is one of the largest accounts in HLR and renewal of the business would be

    critical for HLR's success. The reports would provide the ability to analyze the Member Healthdata in order to prepare the upcoming renewals.

    This project will bring the Member Health data into the EDW in order for HLR's actuarial staff

    to analyze the results and changes that may be necessary for the 208 renewal process. Providingthe ability to analyze the data in house will allow actuarial staff to identify possible issues,

    prepare and make decisions for the upcoming renewals.

    Responsibilities:As an Analyst/Designer:

    1) Analysis of Member Health source files -- Monthly Membership, Plan crosswalk, ClaimsMilliman and Enrollment file.

  • 7/27/2019 Data Warehouse Developer Resume

    7/7

    2) Analysis of the report requirements and layouts.

    3) Designing Data Model, High level and Low level Design.

    4) Estimation of Database size.5) Deciding the rejection strategy.

    6)

    As a Developer:

    1) Designing the ETL process flow / summary.

    2) Design of ETL strategy using SSIS along with the business rules applied.

    3) Report creation using Hyperion Web Analyzer.4) Testing the ETL, reports and data as per the business requirements.

    Educational Qualification:

    B.E. MECHANICAL from K. J. Somaiya College Of Engineering, Vidyavihar, MumbaiUniversity, India with Distinction (76.6%).

    CertificationsB.E. MECHANICAL from K. J. Somaiya College Of Engineering, Vidyavihar, Mumbai

    University, India with Distinction (76.6%).