MIS Report Sample Resume Format in Word Free Download

735Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Kabita Khuraci

EXECUTIVE SUMMARY

 

Highly motivated, dedicated software professional with more than 7 years of IT experience focused primarily on Business Intelligence and Data warehousing. Result oriented approach with proven skills in database, Data Modeling, ETL and reporting tools. Quick to learn and assimilate new concepts and technologies.

Skills Summary

 

Business Areas

·          Insurance Industry

·          Health Care

·          Life science & health care

 

           Experience

·          Reporting experience with business intelligence tools such as Cognos, Crystal Reports, Qlikview, SSRS and Oracle Discoverer.

·          Experience in ETL (Extract – Transform – Load) using SQL Server Integration Services 2005 (SSIS)

·          Experience in data cleansing/transformation activities as part of the ETL effort

·          Experience in the design and development of data marts for creating reports of different business units

·          Involved extensively in Data Analysis, quality assurance, logical data modeling support

·          Collaborate with business units to analyze, define, and model existing and future state business processes

·          Validate requirements against business principles, business goals, and strategic business drivers of the organization

·          Identify common business processes to coordinate and standardize across the enterprise for consistency and re-use.

·          Lead efforts to design and interpret business requirements for data warehouse/mart initiatives.

·          Participate in project QA reviews and milestone checkpoints

	SOFTWARE SKILLS

 

Reporting Tools	Cognos (Framework Model , Transformer, Report Studio, Query Studio, Analysis Studio), Crystal reports, Oracle Discoverer , Qlikview, SSRS
ETL	SSIS
Programming Languages	SQL/PL SQL
Microsoft	MS Word, MS Excel, MS Power Point, MS Project, MS Visio
Data Modeling	Toad , Erwin
Databases	Oracle 9i/10g/11g, SQL Server
IDE	Eclipse
J2EE Technologies	EJB 2.0, JSP, Servlets, Struts, XML

	EMPLOYMENT DETAILS

 

Lockton Companies (Nov-2010 –Till Date)

Lockton is the world's largest, privately owned, independent insurance broker.

Project:

Datawarehouse for Reporting:

Analyse and document the business requirements for reporting needs and design/develop the data marts accordingly. Ensure the proper data validation rules are applied along the ETL process to create reliable reports.

Roles:

·          Lead the requirement gathering sessions to analyse the business reporting needs

      and prepare technical documentation as needed.

·          Design/Develop data models for the data marts for Qlikview reporting tool.

·          Analysis and maintainance of the existing ETL processes for the datawarehouse.

·          Responsible for monitoring progress and maintaining responsibility for delivering project

      Deliverables accurately and on time

·          Responsible for validating data through the production and delivery phases of the Business

      Intelligence initiative

·          Generate standard and ad hoc reports on a regular basis using SSRS.

·          Manage communication  with business departments  via face-to-face meetings, conference

      calls and written correspondence

Kansas Health Solutions (KHS) (Mar-2008 –Oct-2011)

KHS is the managed-care organization for Medicaid mental health benefits in Kansas, functioning as a Pre-paid Ambulatory Health Plan (PAHP) for persons with Medicaid needing mental health services. As a Business Intelligence analyst, responsible for supporting internal and external clients accessing data, interpreting requests, and programming and creating outputs in order to maximize the value of the information captured in the company's systems.

Projects:

Data Warehouse and Reporting System: Implementing a data warehouse for a reporting system, extracting data from different software systems that are used to incorporate clinical, administrative, provider, authorization, claims, and billing data into one information management system. Responsible for all designing, developing, testing, implementing Cognos reports and dashboards delivered in line with business objectives.

Flex care Reporting System: Lead and implemented the business reporting system, using  Cognos, as part of migration to a new clinical data management solution , Beacon (Flex care).Was responsible for design and implementation of the reporting and data migration efforts.

Role:

·          Lead the development and reporting initiatives, including gathering business requirements, testing, and the preparation of technical documentation

·          Identify, assess, and implement process improvement needs to continually increase operational efficiencies

·          Develop data architect and modeling for Cognos reporting tool

·          Expertise in OLTP/OLAP System Study, developing Database Schemas like Star Schema

      and Snowflake Schema used in relational, dimensional and multidimensional modeling

·          Experience in analysis, design and construction of Data warehouses and Data marts

·          Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.

·          Developed complex T-SQL queries and designed SSIS packages to load the data into warehouse.

·          Implemented Slowly Changing Dimension (SCD) type 2 to maintain Historical Data using SSIS as a part of ETL.

·          Facilitate production of ad-hoc and parameter-driven reporting using Cognos Report Studio

·          Managing communication  with vendors/business departments  via face-to-face meetings, conference calls and written correspondence

·          Manage user access, application, and data security in compliance with HIPPA standards

·          Managed the team, assigned and reviewed tasks and monitored progress.

Cambridge Technology Enterprises Inc

Cambridge Technology Enterprises Inc. (CTE), a CMMI Level 5 next-generation business solutions provider.

Key Roles & Responsibilities:

Project: PIP Data Warehouse

Client: Hillspet Inc.

Role: Data Analyst

Duration: May-2007 to Mar-2008

PIP (Profile and Proprietary Information Database) A database and data warehouse that integrates the results of the lab experiments (from the Raw Data Database) with the data from the Bio Data Repository. It facilitates data integration of multiple databases, data mining and provides sophisticated querying capability. 

Role Description:

·          Define the Data Cleansing strategy  and roadmap

·          Responsible for Perform Data Quality Assurance Of operation systems on quarterly basis

·          Involved in the Data Quality Analysis and data cleaning 

·          Responsible for defining business areas and creation of data dictionaries/business area definitions.

·          Involved in Test Data Preparation

·          Analyze the Business Reporting needs and design the report templates.

·          Knowledge of Oracle Discoverer Plus (Business Intelligence tool)

·          Assist in writing data source mapping documents to extract, transform, data from diverse data sources into the corporate data warehouse.

Project: Biology Database - Data Cleansing Project

Client: Hillspet Inc.

Role: Data Analyst

Duration: Apr-2006 to Mar-2007

Project Description: The goal of a Data Cleansing Services effort is to eliminate data inconsistencies and invalid values within the below databases. The scope included converting the existing data from different databases to the format required for the Applications.

The initial scope of the data conversion and cleanup services was defined by preparing the Data Quality Analysis report. This report detailed the issues found in the Databases and specifies the tasks/activities to be performed jointly with the customers IT teams for Databases cleanup.

Role Description:

•    Lead the Data Analysis and planning phase

·          Responsibilities included Project planning and scheduling, Statement of work

·          Define the Data Cleansing and Conversion Methodology

•    Prepare the Data Quality Analysis report:  classifies ‘dirty data’ as data quality, availability or integrity problems. Potential defects included:

-       Absence of a value in a required field

-       Violation of a range or check constraint

-       Violation of a formatting rule

-       Invalid value for a column which has value set (domain) validation.

•    Perform Data Analysis: Analyzed the source of the problem (the table and column from which the defective data was extracted), the extent of the problem (the percentage of records in which the problem was detected), the nature of the defect, and the record in which it occurred.

   •   Perform Data Management: Working with the Database administrators to maintain and version control varies revisions to datasets.

•   Perform Data Cleansing: Based on the nature of the dirty data detected, recommend the strategy to be used to clean the defects.

•   Responsible for Perform Data Quality Assurance: Establish and maintain an effective quality assurance program that provides standard methodologies, techniques and metrics for assuring data quality.

•   Participated in Data Testing

Project: Bio Data Repository Application

Client: Hillspet Inc.

Role: JAVA Programmer

Duration: Feb -2006 to Mar-2006

Project Description:

Hill’s Pet Nutrition Inc., a subsidiary of Colgate-Palmolive, is the market leader in the premium specialty category of pet foods sold through veterinarians and finer pet specialty stores. 

BDR application was designed as a data collection tool for animal tissues, animal demographic information, lab data, ingredient information, and ingredient samples to propose and perform sophisticated laboratory experiments to obtain the needed research data and results to determine the effect of an ingredient on an identified gene or protein.

Role Description:

·          Responsible for developing/coding the EJB components for assigned module

·          Used JSP and 

L pages to develop the web interface and jsp tag libraries for creating complex web pages.

·          Involved in Requirements gathering/analysis

·          Responsible for maintaining and managing the Data Clarification Log

·          Involved in the Data Quality Analysis and data cleaning 

·          Involved in Test Data Preparation

·          Responsible for Design and development of End User Reports

·          Assisted in Preparation of the Design document along with technical lead

·          Involved in User Acceptance testing and test case reviews

·          End User Training and Application rollout

Project: Outside Application Agency

Client: Hillspet Inc.

Role: JAVA Programmer

Duration: Mar-2005 to Jan-2006

Project Description:

The outside agency application allows outside agencies such as veterinarians and outside labs to enter information requested by Hill’s Pet personnel via a web application.

Role Description:

·          Responsible for developing/coding the EJB components for assigned the module

·          Used JSP and HTML pages to develop the web interface and jsp tag libraries for creating complex web pages.

·          Involved in Requirements gathering/analysis and development efforts

·          Involved in User Acceptance testing and test case reviews

·          End User Training and Application rollout

	TRAININGS

 

Attended trainings/seminars on:

·          Cognos Reports Studio and Framework model

·          SSIS (SQL Server Integration Services)

·          Requirements Gathering and analysis

·          J2EE (Struts Framework)

·          Core Java

·          C++(OOPs)

	PERSONAL DETAILS

 

Education	Bachelor of Technology  in Chemical Engineering
University	Indian Institute of Technology (IIT) Mumbai.
Contact Email	neeta.sarangal@gmail.com
Contact Number	785-506-4020

Download Resume Format