Khushbu Dimri

**** ******* ***, ******, ** -*****

704-***-**** acaj76@r.postjobfree.com

Seeking leadership challenges in Business Analysis / Delivery function/

Customer facing roles in organizations looking to enhance their IT

value by better business mapping

Business Analyst / Data Analyst/Solution Engineer

Professional Profile

A qualified MBA graduate and certified IT Project Manager from UNC

Charlotte, with 4 years of insightful experience, including a year of

International tenure; Involved in Management of Production support,

Business requirements mapping, Support Service Delivery of ETL Systems

& Applications. Currently working as a Business/Data Analyst with

strong skills in people and communication, translating underlying

business requirements and driving IT to deliver solutions on them.

[pic]

. Currently working as Business/Data Analyst with RIA Database,

working directly with the CEO and translating business requirements

to expose data trends and data extraction.

. Core Strength includes IT Project Management skills, from

interaction with business to understand the core needs, planning &

scheduling, to end-to-end project execution, release management,

implementation and post-deployment support

. Extensive experience of Project Coordination involving Stake Holder

Interaction; Project Planning, Estimation, Monitoring & Progress

Reporting; Project Level Issues Resolution Conflict Resolution;

Expectation & Risk Management; Cross-functional Process/Team

communication

. Proficient in Excel/ SQL/ Oracle / Sharepoint. Experience in

business process management, system engineering and business

solution development.

. Deft in Data Extraction and Governance Troubleshooting and Resolving

of issues including execution of SQL scripts and loading of

production database Oracle tables

. Strong Technical Knowledge of DB technologies like SQL Server

2005/2008, Sharepoint 2007, Office 2010, Informatica Power Center

7x, PVCS Tracker, PVCS Version Manager, PL/SQL, CMM, CMM, SDLC, OOA,

Veloci-Q..

. Cohesive Team Player with Fast Learning Curve along with strong

analytical, problem solving, innovation, planning, organizational,

communication & interpersonal skills

Trainings & Community Service

. Completed technical trainings in Informatica, Oracle, Cognos

. Community Volunteer for Red Cross 2003-2005

Career Profile

RIA Database, Charlotte, NC (Aug 2013 onwards)

Reporting to the CEO, working as Business/Data Analyst

Responsibilities:

. Accountable to work with the core management team in diverse roles

of Business Analysis, Data Extraction, Scripting and automating

solutions.

. Currently working on extracting business usable data from disparate

systems and online resources.

. Performing team functional as well as people management activities

by working with both the Business and IT departments.

. Responsible for creating Business Requirement Document, and elicited

requirements for Functional Specification Document.

Achievements:

. Quickly integrated with the core team to deliver immediate

actionable data

. Optimized solutions and made automated scripts to manipulate data

that would take days before to be done in minutes.

. Created Reports as per the requirements for better data analysis.

. Performed Data Quality clean-ups, Data enrichment and automation.

CoMag (Hearst Co.), Hearst Tower, Charlotte, NC (Feb'05 - Dec'07)

Reporting to Business Head, working as Data warehousing Analyst

Responsibilities:

. Design and deploying work chain and maintaining production.

Performed Database Administration and was actively involved in

maintaining/tweaking and upgrading production databases for the

organization

. Manage communications between business heads, IT Developers, testers

to coordinate and create deployment schedules.

. Troubleshooting and Resolving of issues including execution of SQL

scripts and loading of production database Oracle tables.

. Managed and Administered Oracle 11i and SQL 2005/2008 databases.

. Controlling and administering the Production Database Environments

using Appworx Scheduler.

Achievements:

. Upgraded Informatica Repositories to v7x and carried out all

Informatica Administration task.

. Informatica Migrations and performance monitoring. Also

Designed/developed Informatica mappings to load the data into

various dimensions & facts. Used E/R Studio to reverse engineer the

databases, providing essential inputs to Oracle tables and building

XML Schemas with the help of logical and physical models.

. Built Informatica Workflows for Business Requirements. Built and

Deployed Data Marts for Data Warehouse.

Previous Engagements

Organization Duration Designation

Wipro Technologies, Bangalore, India July 2001 to Oct Sr. Systems Analyst

2002

GE Capital, India May 2001 to July Process Associate

2001

Indian Market Research Bureau May 2000 to July Management Trainee

2000

EM Technology Pvt Ltd June 1999 to Oct Associate

1999

Education

IT Project Management, Certification from UNC Charlotte Nagpur (Aug 05

- May '07)

MBA, from IIT-Roorkee, India (Oct 1999 - May 2001)

B.E. (Electronics Engineering), from MIET, Nagpur University (1999)

Project Details

Project: Informatica workflow development

Hearst Comag

Description: The business lead leverages ETL tools like Informatica to

extract and manipulate data from their various sources into a single

enterprise wide DB systems. There was a need to create a series ETL

workflows that would map data collected from external sources and map

them to existing enterprise Databases. The project required working

closely with the Business users to understand requirements, development

team and testing team and deliver results in a short turn around.

Role: Functioned as both as a Business Analyst and ETL Developer.

Interacted with business users to gather requirements. Converted them

into enterprise developer workflows in Informatica. Worked with test

teams to test and deploy the chain to production.

Project: Informatica/ Oracle upgrade

Hearst Comag

Description: CoMag is IT division of largest publication magazine

distribution system in the world. The business gets multiple sources of

data from a variety of vendors, partners and global systems. The DB

relies heavily on ETL tools like Informatica to extract and manipulate

data from their various sources into a single enterprise wide DB

systems. The version of ETL tool was outdated and creating support

risks, limiting developers and stalling business projects. Goal of this

project was to modernize the ETL solution system with minimal

disruption in service.

Role: Functioned as Project Manager and handled all communication and

delivery plans. Held scheduled meetings with Business, IT Developers

and Management to create a schedule for upgrade. Performed test upgrade

environment to check for regressions, closely collaborated with

multiple teams to verify builds and existing solutions. Worked with ETL

Product support to resolve issues encountered. And performed the

upgrade on time and schedule while ensuring communication to various

teams. Was part of the Oracle upgrade team from 10g to 11i.

Project: NT & T MIS

Wipro Technologies

Description: A Gas exporter in UK was responsible for the distribution

of Gas for industrial, commercial and household usage. The whole area

under the Client's network was divided into shippers and customers,

each with a dedicated pipeline. The project involved

Planning of different subsequent phases and delivering the solutions

for the same,

Building of Requirement Definitions, Source - Target Mapping with the

help of different Data Models built by the team.

Role: Handled responsibilities of the Datawarehousing analyst. Created

data mappings, data models and SQL scripts. Successfully met deadlines

also worked as coordinator with the onsite Team, the development team &

business users.

Project: CRN Management Reporting

Wipro Technologies

Description: Customer Restoration Network is claims management

application developed in Siebel & Filenet that uses Oracle as a back-

end. Management reporting application was developed to fulfill the

reporting requirements of the business.

Role: Worked as Application developer using various Cognos tools.

Provided features such as generating quotations, logging the ongoing

transactions with prospective clients and complete query and report

functions. Security was key issue in this project. Testing included

validation of ETL process, End-To-End testing of Reports/Cubes & basic

testing of the reports. End-To-End testing involved validating business

requirements, developing business scenarios and performing data

validation of the system

I am a Permanent Resident of United States and therefore authorized to

work for any employer.

Khushbu Dimri

Contact this candidate