msbi developer

Rishav Soni

Cell no: +1-317-***-****

Email: **********@*****.***

Professional Summary

Overall ~6 Years’ experience in IT Industry.

Currently working at client location, in a business analytics project where my responsibilities include dealing with the customer, understanding their requirements, leading the offshore development team and ensuring the high quality and on time delivery etc.

Have developed multiple business analytics and reporting applications, using MSBI (SSIS, SSRS), Informatica, UNIX and SQL.

Have done sales reporting within B2B Contract Management, B2B Medicaid, and Supply Chain systems. Supporting various applications to cater the needs of sales and marketing team of the Client company (US Pharma Company)

Validated and tested reports, then published the reports to the report server.

Designed and developed specific databases for collection, tracking and reporting of data.

Designed, coded, tested and debugged custom queries using Microsoft SQL and SQL Reporting Services

Have used tools like SSRS, Roambi, Power Pivot to do reporting on top of the SSAS Cubes, managed their sharing and auto refresh on SharePoint sites.

Have written various UNIX shell scripts to automate the existing process within supported applications.

A team player with exceptionally good organizational, analytical, training, troubleshooting, and interpersonal communication skills.

Performed and reviewed the testing in Quality Center of the Code Components to ensure high quality of the deliverables.

Seeking to manage, provide and design top-quality product, services, and support to ensure a competitive advantage in the global marketplace.

Have expertise in problem solving, possessing high analytical and technical skills. Mentorship and leadership abilities to help develop the teammates or co-workers in order to create better solutions for client needs

Along with project work I have been actively involved in account level activities and TCS events. This has helped me develop my overall performance as an individual.

Experience Summary:

Organization

Designation

Duration

Tata Consultancy Services

IT Analyst

(03/2011) – (Till Date)

Technical Skills:

Primary Skill

MSBI(SSRS,SSIS),SQL, Informatica,UNIX, Roambi

Secondary Skill

Oracle, Netezza

Project Acquired skills

MSBI(SSRS,SSIS),UNIX, Informatica, Netezza

Domain Skills

Life Sciences and Health care Insurance

Tools and Utilities

Microsoft BIDS, Power BI, Power Pivot SQL Server Management 2008, Toad, Quality Center, Power Center (Informatica), WA, SSH (UNIX), MDS, Roambi Analytics.

Project Profile:

1.

MSBI Developer Global Business Reporting

Client

A US based pharmacy Company

Role

Onsite lead

Organization

Tata Consultancy Services

Duration

March 2015 to Current

Team Size

7 members

Location

Indianapolis, Indiana, USA

Project Description:

Global Reporting application which facilitates strategic decision making by company and sales operations by providing standardized reports on aggregated sales and activity metrics such as sales, share of market, activity trends etc. for the geography or business area.

Pantazia Reports provide aggregate territory activity and sales trends enabling the user to evaluate performance and plan for the future. Mobilized standardized reports on iPad using Roambi. Roambi is a mobile business intelligence solution that transforms data from major BI Systems into dashboard-style mobile analytics for iPhone or iPad.

Contribution:

As an onsite lead, had made a major contribution for my team:

Dealing with the customer, attending meetings with customers to understand various business needs.

Explaining the same to the offshore development team, and leading their development work.

Design and review of the data model and system architecture.

Review the deliverables for meeting the requirements, high quality, optimum performance and 0 defects.

Helping development team with their development work in case of any challenges or any complex requirements.

Presenting the deliverables to the customer and also suggest value additions in the system.

Resolution of the issues occurred during failure of any job/scripts/packages/workflows.

Performance tuning and process optimization.

2.

SQL Developer Global Activity Analytics

Client

A US based pharmacy Company

Role

Module Lead

Organization

Tata Consultancy Services

Duration

Nov 2013 to Dec 2015

Team Size

6 members

Location

Noida, INDIA

Project Description:

Provides detailed data and allowed flexibility for managing business processes. It contains many reports which describe the prescription of Rx, sample, details, hcp details which helps in business decision making. Data feeds come from another source data warehouse, and multiple other sources that feed the Drug Distribution Data (DDD), Rx, Activity, Programs data

Contribution:

As a Module Lead, had made a major contribution for my team:

Involvement with the client in the requirements meeting on call.

Grooming and Mentoring new team members.

Involved in managing team, Designing, and successfully delivery of project.

Reviewing code and design of the project.

Created several UNIX scripts for the data validation/formatting and processing of Informatica maps and other business needs.

Done thorough testing of the cubes/Informatica maps in Quality Center 10.0.

Resolution of the issues occurred during failure of any job/scripts/packages/workflows.

3.

B2B COE

Client

A US based pharmacy Company

Role

Team member - Developer

Organization

Tata Consultancy Services

Duration

Jun 2011 to Oct 2013

Team Size

9 members

Location

Noida, INDIA

Project Description:

B2B CoE is a development and maintenance project. I handled the LTF (Leverage the Foundation) module. Our module catered to the requirements of the sales and marketing personals of the client company, by providing those applications to analyze/manage/monitor Supply Chain Management, Profitability and Rebates, sales etc. I used to have interaction with the client on call for requirements meetings and need to discuss the business needs for new reports/enhancements in existing application. The project had three to four modules which catered to different segments of the Client Company.

Contribution:

As a team member, had made a major contribution for my team:

Developed new reports as per the Business requirements.

Developed Multi dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). Included multiple dimensions and measure groups, complex data related calculated fields, KPIs, and conditional formatting.

Extensively used proClarity tool for analyzing the cube’s data.

Used MDX to create calculated members in the cube. Defined appropriate measure groups and deployed cubes.

Tested the SSRS reports in QA in HP Quality Center 10.0.

Need to do some changes/enhancements in the existing reports/cubes as per the business needs.

Contact this candidate