Sales Sql Server

MANOJ KUMAR VARATHARAJAN

Present Address: * **** ******, **** ****, NY - 11729

Email: ablxl7@r.postjobfree.com / Mobile: 520-***-****

SUMMARY OF QUALIFICATIONS

Manoj Kumar is an MIS Graduate with 3.5 years of experience in requirements

analysis, data analysis, quantitative analysis, BI reporting & web

analytics and Software Application Development. Proven experience of

providing out of box solutions to the client's business needs and

delivering projects within given time and budget. Energetic self-starter

and venture in multi-oriented tasks for mutual growth.

EDUCATION

Master of Science in Management Information Systems, December 2009

GPA - 3.583 / 4.0

The University of Arizona, Eller College of Management, Tucson, AZ

Bachelor of Science in Electrical Engineering, May 2006

GPA - 3.51 / 4.0

Anna University, Chennai, Tamil Nadu, India

EXPERIENCE

Datavibes Inc, Pittsburgh, PA

March 2010 to Till Date

BI Consultant

Client: Forest Laboratories, Commack, NY

. Created and reviewed Business Requirement Document (BRD) and

Functional Specification Document (FSD)

. Developed Use Cases and UML models using Rational and Sequence

Diagrams, OOD using UML

. Coordinated with ETL and BI Developers to prepare System Design

Documents for the functional requirements

. Assisted in managing project schedules, documentation and test plans

. Designed and Developed dashboards for the C-level executives and Sales

Representatives to track the Forest products prescribed by the

Physician's across United States

. Providing Analytical support & training to the Customer Analytics team

for the user acceptance.

Client: McKesson Corporation, Pittsburgh, PA

. Interviewed BI team and identified the technical intricacies of using

OBIEE to generate static and ad-hoc reports

. Analyzed BI practices, infrastructure, resources and available BI tool

licenses

. Evaluated McKesson environment using Datavibes' Insight Index tool and

identified McKesson's BI stand-point

. Researched on Oracle BI publisher and Microsoft SSRS to meet with

McKesson's reporting needs

. Saved 58% of the cost by recommending OBIEE and provided a road-map

to effectively use OBIEE

Client: YWCA, Pittsburgh, PA

. Involved in analysis, Business Requirements gathering in Joint

Application Development (JAD) sessions following CMM standard

methodologies

. Reproduced 4 existing paper-based reports in the SSRS to demonstrate

the BI capabilities to the Business users.

. Developed Business scenarios for the Directors to analyze their

Programs and Projects using SSAS Analysis cubes.

Tucson Unified School District (TUSD), Tucson, AZ

March 2009 to December 2009

Business Intelligence Consultant (Academic Project)

. Identified Microsoft BI suite for BI initiative and coordinated the

environment setup for BI initiative.

. Interviewed Finance, Accounting & IS team and identified 3 key changes

from the new system - manage funds, visibility over School's operation

and ability to track Students records.

. Interviewed CFO, Assistant Director of Financial Services, Financial

Analyst, and Accounting Department Head and identified the KPI: Grant

spent per school for every fiscal year to track the federal & state

funds.

. Researched on BI practices and adapted Kimball's approach of building

data marts.

. Designed Finance data mart using Star Schema approach to support the

financial metrics.

. Coordinated with ETL developers to clean the data using SSIS packages

and populated the data mart.

. Coordinated with BI Developers to develop Project Fund Report to track

the money spent for the TUSD initiatives.

. Recreated TUSD's traditional reports in SSRS and showcased the

Reporting capabilities to C-level executives.

. Implemented Table partitioning methodology and improved the ETL

performance by 91%.

. Built and Demonstrated OLAP capabilities to CFO with a "Dashboard-

prototype" developed using SSAS.

. Submitted a detailed Solution document with the roadmap for the future

implementation.

Lands' End, Dodgeville, WI

June 2009 to August 2009

Business Analyst - Intern

. Designed Sales Dashboard using QlikView (BI tool), to give 360 degree

for Lands' End Business in U.S. and International operations.

. Measured KPI - Sales / Customer for every promotion and designed

QlikView Reports for the Marketing and Finance divisions to identify

the best promotion that attracted customers and generated revenue

. Collaborated Business Intelligence team and Functional groups by

building online BI community in SharePoint and embedded Dashboards &

Team discussion board for seamless communication.

Intuit Incorporation, Tucson, AZ

January 2009 to May 2009

Business Intelligence Consultant (Academic Project)

. Interviewed Marketing and Finance teams and identified the

inconsistent data refresh issues in the BI reports.

. Gathered Requirements and the changes expected by the users in the

existing Reports.

. Analyzed the Infrastructure, ETL processes including staging areas,

log tables, job schedule time and Reports.

. Researched on various approaches and BI practices to finalize on

Kimball's star-schema approach for data mart.

. Designed the Star-Schema with the Report, Process and Time dimensions

to track the Status of the ETL logs.

. Designed and developed a prototype with SQL Server (DW), SSRS (for

Reporting) and MS-Excel (for Analysis) and demonstrated the solution

to the Business users.

. Recommended Business Intelligence team with the directions to

implement the solution in Intuit's environment.

Arizona Respiratory Center, University of Arizona, Tucson, AZ

December 2008 to May 2009

IT-Analyst (Student)

. Gathered Requirements by interacting with lab technicians and hospital

resources to manage Patient lab records.

. Implemented Knowledge Tree solution by coordinating with the IT team

member.

Tata Consultancy Services Ltd., India

March

2007 to July 2008

Assistant System Engineer

Client: British Airways, U.K.

. Analyzed the Business Requirements and finalized the technical

specifications with the team members

. Developed Proof of Concept and demonstrated to users to ensure the

understanding of requirements

. Developed Functional Requirements & Design documents to guide the

Developers through the Development.

. Introduced Java Server Faces (JSF) to ease webpage design by reusing

the existing objects.

. Interfaced Database with Java application using Hibernate to improve

system performance.

. Developed web based Planning & Forecasting tool (BI Application) for

Cabin Crew resource management issues using Java interfaced with

Business Object Reports.

. Designed Test framework to automate 8000 Regression test cases &

improved productivity by 21%.

Cognizant Technology Solutions, India

June

2006 to March 2007

Software Quality Analyst

Client: PEMCO Insurance

Company, U.S.A.

. Framed test strategy & plan to execute the test cases in strict time-

lines for every Test cycle.

. Faced several Quality Audits and ensured the alignment of process with

organizational standards.

. Built "Online-Knowledge Repository" for Test Cases and integrated

Insurance domain.

. Developed "Environment tracker" to automate Server failure reports for

clients.

TECHNICAL SKILLS

. Enterprise Tools: MS Word, Excel, PowerPoint, Outlook, SharePoint and

Project 2007

. Design Tools: Adobe Dreamweaver (prototype & screen design), MS Visio

(DFD, E/R, Use-case design)

. Business Intelligence Tools: MS - SQL Server Reporting / Analysis

Services 2008, QlikView Enterprise v 8.5 & 9.0

. Databases: Oracle (9i & 10g), MS-Access, SQL Server, MySQL

Contact this candidate