Sr. Business AnalystETL/Reporting Lead
Resume:
KISHOR KHOBRE
ETL/Reporting Lead
*******@*****.***
WORK EXPERIENCE
About 5 years of total work experience with Systime Global Solutions
Working as a ETL/Reporting Lead and have experience that includes successful stints in all areas related to software life cycle, i.e. requirement gathering and analysis, design, development, release, implementation and support
Worked extensively on BI specific projects as Technical consultant/Lead both at onsite and offshore
Technical expertise includes implementing ETL and Reporting projects for HR and Finance domains
Managed international customers and ensured successful communication via actively listening and probing questions
Proven skills in Technical implementation for BI Development projects
Part of Presales team in BI area. Responsible for providing scope, assumptions and estimations along with multiple solution approaches
Worked for customers like UltraTech, Dulsco, Tenaris, Dole Foods, Invitrogen, AMEX, GAIL, IBM, etc.
Currently deputed at UltraTech as a Business Intelligence & Data Warehouse Lead
Highly Experienced in creating Enterprise Reporting Solutions using COGNOS 8.4 , SSIS 2008 & informatica
Good Experience of Data Warehouse Lifecycle from ETL, FM Design to BI Reporting
Good exposure of SDLC Phases like Requirement Gathering, System Design & Development, Documenting HLD & LLD and Testing
EUCATIONAL QUALIFICATION
Master of Science in Computer Management
TECHNICAL SKILLS
Reporting Tool COGNOS 8.4/10, Cognos Analytics
ETL Tool SSIS 2005 & 2008, Informatica 7.3/8.1/4/9.1
Database SQL 2005 & 2008, Oracle 9.0, DB2, MS-Access
Operating System Windows XP, Windows NT, Windows Server 2003, MS DOS
Tools and Utilities TOAD, PL SQL Developer, Visual Basic 6.0, MS Office
Languages C, C++
PROFESSIONAL CERTIFICATIONS
Certification Exam
IBM Cognos Cognos 8/10 BI Reports
IBM Cognos Cognos 8 BI Metadata Models
PROFESSIONAL IT TRAINING
Professional training on Cognos
Professional training on Informatica
Professional training on SSIS
RESPONSIBILITIES
Responsible for Requirements Gathering and Specification Preparation
Responsible for Client Liaison and Process Analysis
Responsible for doing PoCs (Proof of Concepts), Demonstrating standard product capabilities and features
Responsible for maintaining effective communication with diverse client teams, working closely with clients for all project implementations
Responsible in leading the day-to-day operations of the implementation team ensuring project delivery within agreed timelines and scope
PROJECT HIGHLIGHTS
Project No. 1 UltraTech Cement – Informatica and Cognos Development
Duration
Client
Technology Used
Team Size
Role
May’11 - Till Date
UltraTech Cement
Informatica 9.1, COGNOS 8.4
12
Team Lead
Responsibilities Analyzed the requirements for BI
Designed the ETL processes using Informatica tool to load Data from SAP server,Oracle,Excel and CSV file to Data Warehouse Oracle tables
Designed and developed the ETL Mapping for Manufacturing and Marketing modules
Scheduled ETL packages
Worked with business users on continuous basis
Provided directions to team during entire phases of the project
Handled responsibilities of delivering entire application to the business and end-users
Responsible for timely project delivery
Actively involved in client meetings for requirement gathering & provided comprehensive solutions for their needs
Handled team of 6 members, including senior & junior team members, assigned tasks and monitored development, resolved day to day technical issues and problems
Worked with senior BAs, stakeholders and other team members on complex business requirements
Helped in creation & review of Business Requirements Document (BRD) and Low Level Design (LLD) documents
Project No. 2 Vestergaard Frandsen – SSIS and Cognos Support
Duration
Client
Technology Used
Team Size
Role
Responsibility
May’11- Till Date
Vestergaard Frandsen
SSIS 2008, SQL 2008, Cognos 8.4
5
ETL Lead
Working on Service Requests raised by customer
Summary Analyzed the requirements for changes/enhancements/new developments
Designed the ETL processes using SSIS tool
Designed and developed the ETL Packages
Scheduled ETL packages
Worked with business users on continuous basis
Provided directions to team during entire phases of the project
Actively involved in client meetings for understanding the service requests raised
Project No. 3 Tenaris – SSIS Development
Duration
Client
Technology Used
Team Size
Role
Responsibility
Jan’ 11 – Apr’ 11
Tenaris
SSIS 2005, SQL 2005
2
ETL Lead
Req. Gathering, HLD & LLD Preparation, Development, Testing, Deployment, User Trainings
Summary Involved in requirement analysis to understand the business needs
Involved in preparation of Low level Design Document (LLD) for this project
Created Packages according to Business Requirements with the help of transformations like SQL Task, OLEDB Source , Lookup Aggregator, Spilt, Union etc during ETL development
Error handling using data grid
Performance tuning of the Packages
Involved in Preparation of Unit Test Plan (UTP) for all the components which were developed
Done unit testing and system testing for the components which we have developed.
Performed integration testing
Project No. 4 Dulsco LLC – SSIS and Cognos Development
Duration
Client
Technology Used
Team Size
Role
Feb’ 10 – Dec’ 10
Dulsco LLC
SSIS, COGNOS
12
Team Lead
Summary Analyzed the requirements for BI
Designed the ETL processes using SSIS tool
Designed and developed the ETL Packages for HR, WMS, HRS, Marketing, Finance and Payroll modules
Scheduled ETL packages
Worked with business users on continuous basis
Provided directions to team during entire phases of the project
Handled responsibilities of delivering entire application to the business and end-users
Responsible for timely project delivery
Actively involved in client meetings for requirement gathering & provided comprehensive solutions for their needs
Handled team of 8 members, including senior & junior team members, assigned tasks and monitored development, resolved day to day technical issues and problems
Worked with senior BAs, stakeholders and other team members on complex business requirements
Helped in creation & review of Business Requirements Document (BRD) and Low Level Design (LLD) documents
Development of Framework Manager
Development of Complex reports development as per business requirements
Project No. 5 Dole Foods
Duration
Client
Technology Used
Team Size
Role
Responsibility Oct’ 09 – Jan’ 10
Dole Foods
Cognos, IBM Infosphere, DB2
10
ETL and Reporting Developer
Req. Gathering, HLD & LLD Preparation, Development, Testing, Deployment, User Trainings
Summary Interpreted complex Business specifications developed by the client and generated reports to meet customer specifications
and provided end to end solution for DWH and BI
Designed the ETL processes using IBM Infosphere tool to load Data
Designed and developed the ETL Package based on company standards
Scheduled the ETL packages
Developed Framework Manager model
Created Standard Reports using Report Studio and Ad-Hoc Reports using Query Studio, like List Reports, Cross tab Reports and Chart Reports with drill through, drill up and drill down functionality
Developed Reports with filters Calculations and Prompts
Project No. 6 Invitrogen
Duration
Client
Technology Used
Team Size
Role
Responsibility
Aug’ 09 – Nov’ 09
Invitrogen
Informatica, Cognos
3
ETL and Reporting Developer
Req. Gathering, HLD & LLD Preparation, Development, Testing, Deployment, User Trainings
Summary End to End solution for DWH and BI
Analyzed BI requirements
Designed the ETL processes using Informatica tool to load Data
Designed and developed the ETL Mapping based on company standards
Scheduled the ETL packages
Created Master Detail Reports Using Report Studio
Worked on Framework Manager to identify the intended use of data, represented by a Query Item, by setting the Usage Property
Worked on Framework manager - Defined Function Sets and specified the aggregation rules for a Query item by setting the Regular Aggregate property
Developed and Published the Packages and Cube into Cognos Connection
Project No. 7 Amex
Duration
Client
Technology Used
Team Size
Role
Responsibility
Sep’ 08 – Jul’09
Amex
Cognos 8.4
3
Reporting Developer
Req. Gathering, HLD & LLD Preparation, Development, Testing, Deployment, User Trainings
Summary Responsible for interacting with business users to identify information needs and business requirements for reports
Created Master Detail Reports Using Report Studio
Worked on Framework Manager to identify the intended use of data, represented by a Query Item, by setting the Usage Property, defined function sets and specified the aggregation rules for a Query item by setting the regular aggregate property
Developed and Published the Packages and Cube into Cognos Connection
Developed List, Cross tab, Chart, Repeaters and complex reports which involved Multiple Prompts, Filters, multi-page, multi-query reports against multiple databases
Created repots with Condition Layout, Condition Formatting, Condition Text source variable and Condition Rendering
Developed Master-Detail reports and Drill-Through reports to provide Summary-Detail information using with pass data item value, pass parameter value and book mark
Created reports using value prompt and selected & searched prompts to filter the data in Cognos Report Studio
Created name spaces for avoiding duplicates
Prepared security at package level, object level and data level
Created packages from model and published it to the content store
Involved in deploying the packages to different environments
Developed reports using Cognos 8 according to business user requirements
Created filters and calculations according to business requirements
Created the master-detail relations, drill through and ranking reports
Involved in bursting and scheduling the reports
Project No. 8 GAIL
Duration
Client
Technology Used
Team Size
Role
Responsibility Jan’ 08 – Aug’ 08
GAIL
Informatica, Oracle, Cognos
7
ETL and Reporting Developer
Req. Gathering, HLD & LLD Preparation, Development, Testing, Deployment, User Trainings
Summary Involved in calls along with onsite team for getting clear requirements on ETL and reporting
Created various transformations like Aggregate, Expression, Filter etc.
Used Workflow Manager for creating and maintaining the sessions
Used Workflow Monitor to monitor edits and scheduled the sessions
Performance tuning
Created prototype reports based on requirements
Maintained framework manager model
Created functional, technical and report specification documents
Designed & developed multiple reports using various templates like List reports, Cross-tab, Charts reports using Report Studio, different condition variables and conditional block
Involved in creating Dash Board Reports
Created prompts in reports to add interactivity for users
Prepared test cases and perform unit testing on reports
Implemented dynamic column functionality in reports
Scheduled the reports through schedule management
Project No. 9 Spring Global
Duration
Client
Technology Used
Team Size
Role
Responsibility Feb’ 07 – Dec’ 07
Spring Global
DB2, Oracle and Informatica
5
ETL Developer
Req. Gathering, HLD & LLD Preparation, Development, Testing, Deployment, User Trainings
Summary Involved in requirement analysis to understand the business needs
Involved in preparation of Low level Design Document (LLD) for this project
Created mappings according to Business Requirements with the help of transformations like Source Qualifier, Lookup (Connected and Unconnected) Aggregator, Expression, Sequences and router during ETL development
Error handling using Debugger
Performance tuning of the Mappings
Involved in Preparation of Unit Test Plan (UTP) for all the components which were developed
Done unit testing and system testing for the components which we have developed.
Performed integration testing
WORK RESPONSIBILITY
Interfacing with Business users for understanding the Requirements
Creating model in Framework Manager and Publishing Packages
Report Creation, Formatting, Updating and Report Testing
Creating SSIS Packages for loading data into Data Mart & Data warehouse also Incremental Loads
Creating Informatica Mappings for loading data into Data Mart & Data warehouse also Incremental Loads
Conducting user trainings
Conducting trainings for IT teams
PERSONAL SKILLS
Self Motivated
Strong Eye for Quality
Able to work and stay focused under pressure
Ready to do things differently if it aids better results
A strong will power with desire to contribute and succeed
As an individual, I consider myself Conscientious, Honest and Frank
Excellent Problem solving abilities with Good verbal and written communication skills
PERSONAL INTEREST & HOBBIES
Learning & Teaching New technology
Music
PASSPORT DETAILS
Passport No. G2826354 Place of Issue Nagpur
Date of Issue 24-Mar-2007 Valid Till 23-Mar-2017
PERSONAL DETAILS
Name Kishor Satappa Khobre
Date Of Birth 25th February 1984 Gender Male
Nationality Indian Marital Status Married
Languages Known English, Hindi, Marathi Blood Group O+ve
Present Address 401, Shree Tirupati Darshan Tower, Near Kamal Motors, Rambaug – 2, Kalyan (W), Dist. Thane, Pin 421 301
Permanent Address Khobre Nivas, At post & Taluka Renapur, Dist. Latur 413 527
Contact this candidate