Project Sales
Resume:
[pic]
Neha Hamdapurkar
Email: ****.***********@*****.***
Cell: +44-792*******,+44-790*******
Experience Summary
Having 7 + years of IT experience
Skill Set Summary
BI Tools : Microstrategy 9, (MSBI) Microsoft Business Intelligence
(SSAS,SSRS),BIRT
Languages: C,C++,C#,MDX(multidimensional Extension),DMX(Data Mining
Extension)
Database: SQL Server 2005,Teradata, Microsoft Access
Other Tools: C#.net
Professional Experience
Analyst Programmer
Worked with Infforay Pvt Ltd from Jan 2012 to Till Date
Working with Persistent Systems from Jan 2013 to November 2013
Worked with Wipro Technologies from May 2012 to Jan 2013
Worked with Infforay Pvt Ltd from Nov 2011 to May 2012
Working with Teradata corporation, Pune from 24 May 2010 to 23 Sep
2011
Worked with Syntel Limited, Pune from 29-Nov- 2007 to 14-may-2010
Industrial Trainee
Worked as a full time Trainee in KarRox Ltd, Pune From January 06 to
June 06
Education
Bachelor of Computer Engineering (B.E.)
M.I.T (Marathwada Institute of technology) College Aurangabad (MS),
India
Passed with 61.04% in June 2007
Higher Secondary School Certificate (H.S.C)
Nutan Mahavidyalaya,Parbhani,Maharashtra,India
Passed with 63.33% in June 2002
Secondary School Certificate (S.S.C),,India
Gandhi Vidyalaya,Parbhani,Maharashtra
Passed with 80.80% in June 2000
Certification and Achievements
Microsoft
70-300 : Analyzing Requirement and Defining Solution Architectures for
Microsoft.net
70-445 : Microsoft SQL Server 2005 Business Intelligence - Development
and Maintenance
Teradata 12 Basics Certification
University Rank during 7th and 8th semester of graduation.
Project Experience
Project Yahoo
Client Yahoo
Team Size 4
Tools and Microstrtegy 9
Technologies
Description The project is related to Yahoo's advertiser, publisher
and customer revenue data. The end users of the
Statslite Products were Sales Manager, Business
analysts and Marketing Account managers. The product
was helping them dive in to Revenue data towards their
advertisements published to Yahoo's proprietary O&O
websites as well as Partner
Responsibiliti Consulted, analyzed and evaluated the needs of the
es System program,
Provided guidance and expertise in developing proposals
and strategies for software design activities, in
MICROSTRATEGY environment.
Identified the limitations and deficiencies in existing
systems and associated processes, procedures and
methods and suggested solution for them.
Corrected the errors and defects by debugging the SQL
(Sequential Query Language) and closed defects
successfully,
Performed individual tests, integration tests and link
testing of the developed solutions in various
environment of the Clients' system,
Prepared the documentations for all functionalities and
for the end users of Clients' system,
Provided training to the End Users in lucid ways so
that they can easily operate the business processes,
Created Multi layout, Multi-panel interactive flash
dashboards and documents
Showed demo to end users and collect the UAT feedback
for enhancements and change requests
Followed end to end Agile methodologies as a part of
project SDLC implementation
Involved in the requirement gathering process, creating
Mock-up documents
Project Experience
Project Charles & Keith International
Client Charles & Keith
Team Size 4
Tools and Microstrtegy 9
Technologies
Description Charles& Keith is the One of the largest retailer brand
in Fashion industries with respective to Bags, Shoes,
and respective Accessories across the world based
through more than 56 Countries. Company has four
primary brands.
The scope of this project is to develop a fully fledged
BI Reporting system with dashboard and Testing it using
Microstrategy 9.x Reporting Suite as the front-end and
SQL server as the backend, for measuring their
worldwide Sales Performance.
Responsibiliti
es Consulted, analyzed and evaluated the needs of the
System program,
Provided guidance and expertise in developing proposals
and strategies for software design activities, in
MICROSTRATEGY environment.
Identified the limitations and deficiencies in existing
systems and associated processes, procedures and
methods and suggested solution for them.
Corrected the errors and defects by debugging the SQL
(Sequential Query Language) and closed defects
successfully,
Performed individual tests, integration tests and link
testing of the developed solutions in various
environment of the Clients' system,
Prepared the documentations for all functionalities and
for the end users of Clients' system,
Participated in the Tasks such as creation of
attributes, Fact Metric, Prompts and Filters, etc..
Done the Dashboard/reports Testing
Responsible for Creating the application layer objects
in Micro strategy and Creating Reports and
Dashboards/Report Service Documents on top of these
objects
Tuning the reports and dashboards created, at the MSTR
Level for getting optimal performance
Project Terreal
Client Terreal
Team Size 4
Tools and Microstrtegy 9
Technologies
Description Terreal Group with centenary roots, TERREAL blends the
industrial tradition of terra cotta with the mastery of
high technology process to develop constructive,
innovative, aesthetic and high-performance solutions.
The scope of this project is to develop a fully fledged
BI Reporting system with dashboard and Testing it using
Microstrategy 9.x Reporting Suite as the front-end and
SQL server as the backend, for measuring their
worldwide Sales Performance.
Responsibiliti Consulted, analyzed and evaluated the needs of the
es System program,
Provided guidance and expertise in developing proposals
and strategies for software design activities, in
MICROSTRATEGY environment.
Identified the limitations and deficiencies in existing
systems and associated processes, procedures and
methods and suggested solution for them.
Corrected the errors and defects by debugging the SQL
(Sequential Query Language) and closed defects
successfully,
Performed individual tests, integration tests and link
testing of the developed solutions in various
environment of the Clients' system,
Prepared the documentations for all functionalities and
for the end users of Clients' system,
Provided training to the End Users in lucid ways so
that they can easily operate the business processes,
Implementation Involved in the requirement gathering
process, creating Mock-up documents.
Responsible for developing Public Objects like Metrics,
Filters, Prompts. Custom Groups etc.
Created various Schema elements like Attributes, Facts,
Logical Tables, Hierarchies, Transformations etc.
Mainly involved in developing dashboards
Created required datasets for developing dashboards
Involved in creating various objects like panel stacks,
panels, selectors, widgets, hyperlinks, derived metrics
and thresholds
Project GAP
Client GAP
Team Size 12
Tools and Microstrategy 9
Technologies
Description The GAP is the One of the largest retailer of Clothes
and respective Accessories across the world based in
San Francisco, California. The company has five primary
brands: the namesake Gap banner, Banana Republic, Old
Navy, Piper lime and Athleta
The scope of this project is to develop a fully fledged
BI Reporting system and Testing it using Microstrategy
9.x Reporting Suite as the front-end and Teradata V12
as the backend, for measuring their worldwide Sales
Performance.
Responsibiliti Participated in the Tasks such as creation of Metric,
es Prompts and Filters, attributes etc..
Done the Dashboard/reports Testing
Responsible for Creating the application layer objects
in Micro strategy and Creating Reports and
Dashboards/Report Service Documents on top of these
objects
Tuning the reports and dashboards created, at the MSTR
Level for getting optimal performance
Project Mc-Cain
Client Mc-Cain
Team Size 8
Tools and Microstrategy 9
Technologies
Description The client is the world's largest producer of French
fries and other oven-ready frozen food products and is
the second largest private company in Canada.
The scope of this project is to create a full fledged
BI Reporting system using Microstrategy 9.x Reporting
Suite as the front-end and Teradata V12 as the backend,
for measuring their worldwide Sales Performance. The
responsibilities were designing the BI Semantic Layer
in the dimensional format on top of the Teradata PDM
implemented in the 3-NF format and then implementing a
complete reporting and dash boarding solution using
Microstrategy, on top of the BI Semantic Layer
Responsibiliti Consulted, analyzed and evaluated the needs of the
es System program,
Provided guidance and expertise in developing proposals
and strategies for software design activities, in
MICROSTRATEGY environment.
Identified the limitations and deficiencies in existing
systems and associated processes, procedures and
methods and suggested solution for them.
Corrected the errors and defects by debugging the SQL
(Sequential Query Language) and closed defects
successfully,
Performed individual tests, integration tests and link
testing of the developed solutions in various
environment of the Clients' system,
Prepared the documentations for all functionalities and
for the end users of Clients' system,
Provided training to the End Users in lucid ways so
that they can easily operate the business processes,
Implementation Involved in the requirement gathering
process, creating Mock-up documents.
Responsible for developing Public Objects like Metrics,
Filters, Prompts. Custom Groups etc.
Created various Schema elements like Attributes, Facts,
Logical Tables, Hierarchies, Transformations etc
Mainly involved in developing dashboards
Created required datasets for developing dashboards
Involved in creating various objects like panel stacks,
panels, selectors, widgets, hyperlinks, derived metrics
and thresholds
Developed Static Reports
Project NCR EDB
Client NCR
Team Size 2
Tools and SSAS,SSIS
Technologies
Description The purpose of EDB to help Business user to find any
cross sell/up sell opportunities for getting revenue
and their growth in various regions. It also helps
higher management to make strategic decisions.
Responsibiliti Consulted, analyzed and evaluated the needs of the
es System program,
Provided guidance and expertise in developing proposals
and strategies for software design activities, in
MICROSTRATEGY environment.
Identified the limitations and deficiencies in existing
systems and associated processes, procedures and
methods and suggested solution for them.
Corrected the errors and defects by debugging the SQL
(Sequential Query Language) and closed defects
successfully,
Performed individual tests, integration tests and link
testing of the developed solutions in various
environment of the Clients' system,
Prepared the documentations for all functionalities and
for the end users of Clients' system,
Provided training to the End Users in lucid ways so
that they can easily operate the business processes,
Implementation Involved in the requirement gathering
process, creating Mock-up documents.
Importing Source/Target tables from the respective
databases and created reusable transformations and
mappings using SSIS.
Error handling and debugging using C# script embedded
in SSIS 08.
Modification of existing Dashboard.
Prepared various POC document required by Client.
Prepared Unit Test Specification Requirements.
Explored and Developed Dashboard POC in PPS(Performance
Point Server)
Developed the Script to automate the Cube.
Project SynRC(BO to SSRS Conversion Tool)
Client Syntel Ltd
Team Size 10
Tools and C#.net, SQL server 2005
Technologies
Description
Microsoft is one of the leading vendors to provide
Business Intelligence solution. BO is also one of the
tools for Business Intelligence but now that was
acquired by SAP. Due to increasing in cost BO Clients
are seeking cost effective solution from other BI
vendors.
SynRc is Syntel tool which come up with this solution.
Responsibiliti Responsible for Design The GUI in the C#.net
es Responsible for developing the charting module of the
Project.
Responsible for migration of all the types of charting
reports from BO to SSRS Like column chart, pie chart,
bar chart, dotted chart, column chart, Line chart,Area chart, bubble chart, Stock chart.
Participated in the Defect Solving using
Responsible for testing the SynRc application.
Project MOSS- BI Integration
Client Syntel Limited
Team Size 6
Tools and SSAS,SSRS,MDX,DMX,MOSS,BIDS
Technologies
ReResponsibili Developed different types of cube in SSAS
ties Responsible for building KPIs, partition, Actions,
Calculated Members, Levels and hierarchies
Responsible for building different data mining models
on database like Clustering, Association rule, decision
Tree etc.
Responsible for writing DMX (Data-mining Extensions)
expression to manipulate the data mining models
Responsible for writing MDX (Multidimensional
Extensions) expression to manipulate the cubes
Responsible for Integration of MOSS and SSAS through
Excel Services
Developed tabular Reports, Matrix report, and different
types Charting reports like pie, bar, Column chart etc.
Successfully Integrated SSRS with MOSS
Project Geneva
Client Carillion
Team Size 35
Tools and C# .Net,VB 6.0, Instance C#, VSS 6.0,Clear Quest
Technologies
Responsibiliti
es Consulted, analyzed and evaluated the needs of the
System program,
Provided guidance and expertise in developing proposals
and strategies for software design activities, in
MICROSTRATEGY environment.
Identified the limitations and deficiencies in existing
systems and associated processes, procedures and
methods and suggested solution for them.
Corrected the errors and defects by debugging the SQL
(Sequential Query Language) and closed defects
successfully,
Performed individual tests, integration tests and link
testing of the developed solutions in various
environment of the Clients' system,
Prepared the documentations for all functionalities and
for the end users of Clients' system,
Provided training to the End Users in lucid ways so
that they can easily operate the business processes,
Implementation Involved in the requirement gathering
process, creating Mock-up documents.
UI Migrating from VB to C#.net
Code migration of forms from VB to C#.net in different
modules.
Explored and Worked on Instance C# Tool.
Involved in Defects fixing and Resolving it
Explored and worked IBM's Clear Quest for defects
tracking.
Involved in Manual Testing using tool Clear Quest
Personal Details
Name Neha Hamdapurkar
Gender Female
Date of Birth 15/06/1984
Nationality Indian
Mailing Address Flat no 5, Siddhartha vihar, Right bhusari colony,
kothrud, and pune.
Personal E-mail ****.***********@**********.***
Mobile +44-792*******,91-942*******,992-***-****
Contact this candidate