Project Management,Data Analytics

Khushboo Jashnani Mobile: 424-***-**** Email: *****.*@*****.***

CAREER CONSPECTUS

●Extensive work experience in Data Warehousing, Business Analyst, Project Management,Data Modeling, Development and Testing of Business Applications, System Integration, Maintenance and Quality Assurance (CMMi 3).

●Expertise in Data Warehouse architecture, with specialization in

•Business Analysis.

•Project Management (Waterfall and Agile)

•Requirement gathering.

•Data Modeling.

•Performance optimization.

•BI Modeling in Framework Manager, Report Writing in Report Studio, Analysis Studio.

•Cognos Installation, Configuration,Upgradation, Administration and Security.

●Prepared 'inventory' documentation and created Assets of the existing Cognos 10 environment systems, Change Management Process and other data elements to be used within the IBM data warehouse project team for future requirements.

●Identifying business processes, gathering requirements, suggesting areas for improvement, identifying potential risks and issues and developing and implementing solutions.

●Perform, evaluate, and communicate thorough quality assurance at every stage of systems development.

●Develop and maintain the Requirements Traceability Matrices for each software change requests

●Participate in project planning and other interdependent project activities..

●Worked with the IBM Software Group to recommended best practices on implementation of Cognos 10.1 and suggested the product enhancements for the subsequent release of the Products.

●Worked in various projects across different Business domains like Telecom, Media, Manufacturing,Insurance,Sales Forecasting,Human Resource etc.

●Worked at various global locations (US/CANADA/DUBAI/INDIA) with diverse clients, professionals & team members.

●Participated in the CMMi 3 related activities which included preparation of various Quality related documents for Process Areas such as TS and VAL

●Currently undergoing Confluence,BIG Data & Hadoop online trainings.

SKILL SET

OLAP Tools

Cognos 7/8/10.1,10.2 BI, Business Objects 6.5,Web Intelligence 6.0

ETL Tools

IBM Datastage 7.5x2, IBM Datastage 7.1

Operating Systems

Windows 200x, Windows XP, UNIX

Tools/ Software

ER-Win, Toad,Smart Draw

Databases

SQL-Server 200x, Oracle 9i, Teradata

CERTIFICATIONS

●IBM Certified Solution Expert - Cognos BI

●IBM Certified Designer - Cognos 10 BI Reports

●IBM Certified Developer - Cognos 10 BI OLAP Models

●IBM Cognos BI Professional –Key concepts on Cognos BI Products

●IBM Certified Administrator - Cognos 10 BI

●IBM Certified Developer - Cognos 10 BI Metadata Models

●IBM Elevate Programme (Women Leadership Program).

PROGRAMS

●IBM ELEVATE Program ( A Women Leadership Program conceptualized and designed to develop high potential Women Leaders within and across IBM)

TRAININGS

●JIRA and Agile Training.

●IBM Cognos TM1 9.5.2. ( Planning and Financial Reporting Tool)

●IBM Cognos 10.1 performance tuning

●Designing Datawarehousing Models using IBM Infosphere (Data Modelling Tool)

●Consulting Business Strategy - Foundation to Experienced

●Consulting Business Strategy – Basic to Foundation

●Business Objects 6.5 and Web Intelligence.

●Microsoft Proclarity, SSAS and SSRS.

ACADEMIA

●Bachelor of Electronics & Communication Engineering, Nagpur University.

Project Experience

Employer – Peoplecube (peoplecube.in) Jan 2018 –Jan 2019

Title- Sr.Business Analyst/ Project Coordinator

PeopleCube is a People Analytics company dealing in predictive and prescriptive analytics to impact business outcomes by proactively identifying and addressing the issues arising out of business-people interface.

Responsibilities

●Drive product definition, design and implementation based on the Sales, Marketing and Operation team’s understanding, technology and market competition.

●Worked closely with product design team and enterprise architect to develop & define cross application team functions and close gaps.

●Collaborate with multiple teams to guide projects through development with quality and reliability.

●Serve as a lead point of contact between product development teams, Sales & marketing team, operations team, Legal & compliance team, external vendor’s analysts & development team and testing team.

Conduct discovery sessions for product requirements, data metrics and delivered business requirement document (BRD) for product development.

●Followed Scrum (Agile) Methodology for the project.

●Organized wish list and updated the team on user stories, Coordinated with various stakeholders to understand the requirements for the new system and prioritized the User stories within the business framework

●Responsible for driving road map, messaging and positioning, go-to-market strategy, and field enablement.

●Acted as a Liaison between the technical team and business users.

●Participated in team meetings and discussions on new product development. Involved in converting business requirements into technical specs using Use-case models.

●Created Dashboards to list the User Stories. Working with cross functionality team and had sprint planning and scrum of scrum meeting to ensure that the team were on the same page.

●Participation in Daily scrum, Sprint Planning and Sprint Retrospective meetings and update the team on new User Stories.

●Represented ideas from the Product Owner utilizing a Story Board and create Mockups/Screenshots for users and other project members to react on

●Facilitated in preparing the product backlog, sprint backlog and burn down chart.

●Responsible for tracking the project status by preparing the burn down charts.

●Managed Change Request by following Change Request Management process for the project in the next Sprint cycle.

● Reviewed and created test cases to perform Functional Testing, Security Access Testing, End-to-End Testing, and Regression testing (BAT).

● Coordinated and facilitated work sessions with business users and assisted them in defining business processes, requirements and possible risks, Cost benefit analysis and analyzed possible solutions with team members.

Employer – IBM India Pvt Ltd

Title: DHL New Global Forwarding From June 2014 –Jan 2015 Client: DHL Role: Business Analyst /Coordinator

Responsibilities:

●Analyzed multiple data sources and converted business requirements into technical design

●Help define project scope, goals and deliverables.

●Created data models (conceptual and logical) to merge data into single reporting data source and created Mappings accordingly.

●Created Work lists utilizing reporting tools for various groups of the company that ensured more efficient work flow internally and track deliverables

●Responsible for Analyzing complex reporting issues and providing solution accordingly.

●Created and maintained Audit reporting utilized internally by senior management.

●Lead Quality Assurance and Reported defects to the development team and performed testing once fixed

●Implement and manage change when necessary to meet project output.

Employer – IBM India Pvt Ltd

Title: Actuarial Financial Reporting From March 2013 –March 2014 Client: XL Capital, India Role: Business Analyst / Team Coordinator

Responsibilities:

●Collaborate with business management group to develop and articulate business requirements that can be addressed with new and enhanced IT systems and solutions.

●Review existing data design for use in reporting and analysis.

●Help project team with the design and development tasks

●Lead process of issue identification and resolution

●Implemented and revised designs in development, test and production environments through change management process.

●Created Technical Specifications of the new requirements and prepared Mockup's accordingly.

●Planning work allocation to team member, monitoring and status reporting

●Responsible for the deliverables of various modules.

Employer – IBM India Pvt Ltd

Title: MI Strategy and Financial Reporting From Jan 2012 –February 2013

Client: Vodafone Essar, India Role: BI Application Solution Consultant /Project Coordinator

Responsibilities:

●Collaborate with business management group to develop and articulate business requirements that can be addressed with new and enhanced IT systems and solutions.

●Designed Data models that support their current tactical and strategic reporting needs and also have the flexibility to scale and adapt to future business requirements

●Monitoring and Reporting Progress.

●Identify required assets and resources and Estimate Timelines.

●Recommended best practices to build and maintain Framework Manager models, metadata packages, and Transformer models.

●Review existing data design for use in reporting and analysis. Recommend alternatives as needed to improve performance of Cognos reports, data cube refreshes, drill-through reports, etc.

●Leverage technical expertise of peers as needed to ensure high-quality, effective solutions are delivered.

●Designed a Cognos security profile to fit the business needs for accessing the reports and provided specifications to the Cognos technical team for implementation.

●Created functional specifications, user guide, process flows, generated various reports, and conducted training for end users

●The IBM MIS / BI project has been Ranked #2 in “BI – Masterminds 2012 – India’s Top BI Projects”. My contribution towards the project implementation was considered and awarded

Employer – IBM India Pvt Ltd

Title: Multiple BI Infovision and Transformation From Dec 2010 –Dec 2011

Client: Vodafone Essar, India Role: Coordinator/ Business Analyst

Responsibilities:

●Evaluated existing BI systems, identified areas of improvement, and suggested data model and reporting solution that involved integration of their systems.

●Meet with business management contacts to gather requirements for all metrics to be included on the new dashboard reports. Prepare mock-ups and share with end user management and development resources.

●To Provide End-to-End solution for the projects such 3G Dashboard, 3G KPI, 3G Data Reporting and IGH

●Prepare BI objects for use with Cognos Go Mobile software. Deliver presentations for appropriate end users with mobile devices and provide support.

●Design and Developed Framework Model, interactive Dashboards, KPI’s along with multidimensional cubes.

●Installed Cognos 10 on AIX, configured Active Directory, Web Server and implemented security accordingly.

●Coached other developers on report design and development methods; monitored progress to ensure completion of deliverables within established deadlines.

●The IBM BI Infovision project has won iCMG Architecture Excellence Award for BI and Analytics.

Employer – Systime Global Solutions Pvt Ltd

Title: Cognos BI - HR Solutions & Manpower Services From April 2010 – Nov 2010

Client: Dulsco, UAE Role: Onsite Coordinator / BI Architect

Responsibilities:

●Study business applications to understand the client’s existing systems and gather requirements accordingly.

●Developed logical and physical data models to support the development of their various modules such as HR, Finance, Payroll, WMS, Marketing and HRS.

●Manage various projects as assigned by BI Management. Contribute to creation of project plans. Provide periodic updates on status of deliverables.

●Transferred knowledge of business and technical requirements to other team members as needed.

●Take over the primary responsibility of the Cognos programming changes to be done by off-shore resources.

●Participated In the development of FM Model, Reports, Cubes, Dashboards and Events.

●Participated in the CMMi related activities which included preparation of various Quality related documents for Process Areas such as TS and VAL.

Employer – Larsen & Toubro Infotech Ltd

Title: Production & Distribution Planning From July 2008 – March 2010

Client: Lafarge, Canada Role: Onsite Coordinator/ Analyst

Responsibilities:

●Met with end users to review enhancement requests. Gathered and documented business requirements, translated into technical specifications, worked with developers to program and deploy to internal and external end users.

●Creating conceptual Logical model by Reverse engineering process using Erwin as the modeling tool.

●Provided inputs on end-to-end design, acquisition, development and implementation of the corporate data warehouse.

●Created Canned reports using Report Studio and Cubes using Powerplay Transformer

●Provide best practices for day to day operations, performance analysis, tuning and capacity planning and documenting the same.

●Maintained a Cognos Project status report of all work in progress and shared with IT and End User Management.

●Documenting the requirements and the datamodel designs accordingly.

●User acceptance testing, QA, and deployment to user community.

Employer – Larsen & Toubro Infotech Ltd

Title: Sales Affiliate Reporting From Feb 2007 – July 2008

Client: Viacom, NY, USA Role: ETL Developer /Analyst

Responsibilities:

●Responsible for documenting user requirements and translated requirements into technical solutions

●Identified the Facts and Dimensions using Erwin Data modeling tool to represent the Star Schema Data Marts.

●Develop processes for cleansing, transforming, extracting, integrating and loading data with use of Datastage.

●Written complex queries to facilitate the supply of data to other teams.

●Responsible for using different types of Stages such as Change Capture, Hashed File, Sequential File, Sort Aggregator, Transformer and ODBC to develop different jobs.

●Day-to-day enhancements and maintenance jobs in Affiliate and other Data Marts

Employer – Larsen & Toubro Infotech Ltd

Title: Programming Analytics Jan 2006 - Jan 2007

Client: Viacom, NY, USA Role: Cognos Developer / Analyst

Responsibilities

●Involved in Logical and Physical design of relational and dimensional modeling for the Data Mart.

●Actively involved in designing and developing the OLAP Cubes using Power play Transformer

●Created complex and sophisticated Reports using SQL queries, prompts, functions, calculated formulae, drill options, slice and dice features of Report Studio.

●Designed Categories, Dimensions, Details, and Measures and in Cognos Power play Transformer with business logic

●Migrated Power Play cubes and Power Play reports from Cognos 7.3 to 8.4. Created new Cognos Connection portal pages/dashboards

●Setting up user access permissions & rights using Access Manager.

Contact this candidate