Satish Parvathaneni

Email: aczcpw@r.postjobfree.com

Consultant

Mobile: 972-***-****

Professional Experience:

. Highly Committed, Self-motivated and goal-oriented BI/DW/SAPBOBJ

Consultant having around 10 Years of work experience in Analysis,

Design, Development and Testing of Data Warehousing Applications.

. Implementation, Testing, migration and support for Data Warehouse

applications.

. Extensive Experience in Business Objects Enterprise XIR2, XI 3.1,4.0,4.1,Crystal Reports

. Extensive Experience in SAP dashboard design & Tableau 8.0,8.1&Tableau

Administrator

. Creating Universe especially for Ad-hoc reports

. Involved in identification of Facts, Measures, Dimensions and

Hierarchies for OLAP models.

. Designed and Create WebI reports for User and presentations.

. Excellent knowledge of Star Schema and Snow Flake Schema.

. Worked extensively with Advance analysis Actions, Calculations,

Parameters, Background images, Maps, Trend Lines, Statistics, and Log

Axes. Groups, hierarchies, Sets to create detail level summary report and

supported the Reports developed and given Production support.

. Worked in writing SQL Queries (Sub queries and Join conditions,

correlated sub queries).

. Experience in building & retrieving data using Universes and used

functionalities like Combined Queries, Slice and Dice, Drill, Crosstab

and Master Detail Reports.

. Worked on BO Designer Functionalities like Derived Tables, Linked

Universes, Index aware, Contexts, Aliases, complex joins, Customized

LOV's, Cascading Prompts and Aggregate Awareness for the Optimization

and Performance tuning of Database.

. Created universes, classes and objects by retrieving the data from

various data sources and defining the necessary connections.

. Experience in managing Security in Business Objects Product Line and

Crystal Reports using CMC. Primary responsibilities included giving

access privileges to users to use different universes.

. Good experience in creating Sub Reports, On Demand Reports, Linked

Reports, Mailing Labels, Cross Tab Reports and Graphical Reports.

Expert in using shared and global variables across the Crystal

reports.

. Involved in SAP BI components like Info Cubes, Multi Providers, Data

Sources etc.

. Created Tableau scorecards, dashboards using stack bars, bar graphs,

scattered plots, geographical maps.

. Worked on motion chart, Bubble chart, Drill down analysis using tableau

desktop.

. Efficient in Optimizing, Debugging and testing SQL queries and stored

procedures written in SQL.

. Interacted with the users to analyze the changes for improvement they

needed in existing reports, and developed the reports to satisfy their

needs and requirements.

Work Experience:

Worked as a Consultant in Virtusa Consulting India Pvt Ltd from July 2008

to February 2015. http://www.virtusa.com. Worked in USA from 2011 to 2014.

Worked as a Software Engineer in Shiga Info Technologies PVT LTD from

August 2005 to June 2008.

SKILL SET:

SAP Business Objects:

Business Objects 6.5,XI R2,XI R3.1,4.0,4.1,Crystal Reports XI, Crystal

Reports server 2008,2012, Xcelsius 4.5, 2008, SAP Crystal Dashboard

Design, SAP BI 7, SAP BW 3.0, SAP Lumira 14

Microsoft Technologies:

SQL Server 2005, 2008, SQL Server Analysis services 2008, Microsoft

Performance Point Services,

Microsoft Office Sharepoint Server 2007, Microsoft Visio.

Databases:

MS SQL Server 2005, 2008, 2011. Oracle 9I, 10G, Access

Software's:

Toad, WinSql, SAS Enterprise Miner, Clarity 14.0.13, Tableau 8.0, Tableau

8.1, Tableau 9.0

PROFESSIONAL EXPERIENCE:

Project Name (7): CIG Reporting

Client: JPMC

(Jan'13 to Feb'15)

Role: Tech Lead

Environment: Business Objects XI 3.1 R2,X4.0,Crystal Reports 2011,SQL

Server Analysis, SQL Server 2005, 2008, SAP Crystal Reports 2011, Microsoft

Share Point Server 2010,Clarity 14.0,Tableau 8.1

Description:CIG Group Supports Public Internet Sites for all lines of

Business with JPMorgan Chase .CIG Comprises Over 700 Professional Located

in Delaware, New York, Ohio, Florida, California and Illinois. The group

consists of senior business strategists, developers, infrastructure and

Architecture specialists, information architects, usability professionals,

interactive designers, editors and other project support and operations

staff. CIG works closely with all lines of business Including: Auto

Lending, Business Banking, Card Services, Commercial Banking, Education

Finance, Home Lending, Investing, Private Bank, Private Client Services,

Retail and Treasury CIG's goal is to provide consistent, integrated

internet applications that are intuitive, dependable and easy to use for

all the Users.

Project Roles & Responsibilities:

. Understanding the Existing BRD and Design Specification Documents

. Gathered requirements, sourced and stored data, planned, carried out

prototyping, UAT, implementation, enhancements and assisted with long

term automation

. Involved in Analysis,Design and Testing phases of the Project

. Analyzed existing business requirements in Tableau.

. Created Tableau scorecards, dashboards using stack bars, bar graphs,

scattered plots, geographical maps.

. Worked on motion chart, Bubble chart, Drill down analysis using tableau

desktop.

. Worked extensively with Advance analysis Actions, Calculations,

Parameters, Background images, Maps, Trend Lines, Statistics, and Log

Axes. Groups, hierarchies, Sets to create detail level summary report and

supported the Reports developed and given Production support

. Worked on motion chart, Bubble chart, Drill down analysis using tableau

desktop.

. Designed the dashboard to achieve 100% data accuracy, extreme precision

. Designed and implemented end-to-end Dashboard for Finance LOB using

Tableau.

. Created Database and Database Objects like Tables, Stored Procedures,

Views

. Implemented numerous components as a part of end to end Implementation of

Business intelligence Solutions Including Datamart Design, ETL,Designing and Load OLAP Cubes, MDX and SQL Queries,reports using

SharePoint and Excel Pivot Charts

. Created and Configured Data Source & Data Source Views, Dimensions,

Cubes, Measures, Partitions, KPI's & MDX Queries using SQL Server 2008

Analysis Services

. Created Perspective of Cube to Simplify the Process of browsing for end

users

. Actively involved in processing of Cubes,Designing Aggregations and

Calculated Members

. Created Windows Logins and Privileges to User Accounts/Groups and Objects

. Restricting Dimensions to specific users based on User Groups

. Created dashboards using the Cube Created and automated to process to

Cube to refresh data on daily basics using SSIS Package

. Hands on in creating jobs, SQL Mail, Alerts and schedule SSIS Packages

using SQL Server Agent

. Created Score Cards with executive summary dashboards using MS Office

Performance Point Server 2010 Dashboard Designer to display Performance

Monitoring Measures for Actuals Vs Budget Information.

. Developed Detailed and Summary Reports as well as Pie Charts, Line Charts

trend analysis reports.

. Involved in testing phase of the Historical Cube and Project Metrics Cube

. Migrated Crystal Reports from Crystal Reports XI to Crystal Reports

Server 2011 Enterprise

. Created Crystal Reports upon user request with rich content look and

Parameters

. Created Crystal Reports Which Involves Dynamic Prompts on Dates,Years

and Quarters

. Created formulas and Inserted new Columns Whenever Requested

. Updated Crystal Reports whenever user's requested

. Created .ODC Files for each Request from the Users there By Creating

Excel Service Report

. Created Excel Service Reports Upon Request for Different LOB and

Different Project's

Project Name (6): Actuarial Data mart and Actuarial Reporting

Client: Guardian Life Insurance, NYC, NY

(Jul'12 to Jan'13)

Role: ETL/BO/QA Lead

Project Role:

. Responsible for development and execution of detailed test plans and

fixing defects

. Audited Business & functional necessity documents and recognized test

scenarios

. Participated in implementing test-plans and test-cases built on high-

leveled and detailed design

. Spearheaded a team of 04 QA analysts in the development of SQL Queries.

. Demonstrated proficiency in leading and mentoring individuals to maximize

levels of productivity, while forming cohesive team environment.

. Created scripts for testing using Oracle and WinSQl.

. Validated the data loaded into the target (Oracle) against the source

(Mainframes).

. Given training in the mainframes screens to view and seed the data.

. Responsible for preparing the test strategy document.

. Broadly done manual testing, constraints verification testings, and the

functional testing.

. Involved in the Test Case walkthroughs, assessment meeting

. Cooperated and performed with development group to resolve the

difficulties came across in a test execution.

. Involved in audit meetings and got an initiative to reach QA testing

goals

. Contributed in regular status meetings to state any bugs, problems and

risks

. Fixed tracking bugs using Clear Quest and maintain reports on resolved

bugs

. Responsible for coordinating and executing the testing of entire system

in accordance with the test plan.

. Analyzed system requirements and document entire testing process

accordingly

. Responsible for testing the star schema for building the data mart

. Created and tested the BO reports by writing complex SQL queries against

the data mart

. And generated ad hoc reports from the Actuarial Reporting universe

. Worked as both SIT and UAT Tester

. Coordinated with developers and system engineers to fix application

defects.

. Analyzed test specifications and perform manual testing.

. Prepared and maintained Requirement Traceability Matrix(RTM) to attain

full functionality.

. Focused on Data Quality issues / problems that include completeness,

conformity, consistency, accuracy, duplicates and integrity.

Project Name (5): Veritext-Vision Application - Replatforming

Client: Veritext Corp

(Feb '12 -Jul'12)

Role: Tech Lead

The project aims at provide its users, i.e. lawyers, the ability to

manage deposition assignments on the move. Lawyers will able to confirm

or reschedule the deposition assignments schedule for next 24 hours and

also have ability to reschedule or cancel upcoming depositions. They will

also be able to download transcripts in PDF format on their Mobile

devices. Create Unified Database of all locations using SSIS and Design

and maintain reports in Crystal Reports, SSRS, deploy them to Business

Objects environment and MSBI environment and integrate with .net

application. Hence reports are designed to create weekly Revenue decks,

summary reports, Invoice reports etc. for easier tracking and reviewing

of business.

Environment: Crystal reports 2011, Crystal server 2011(BO 4.0 platform),

SQL Server,MSBI (SSRS)

Project Role:

. Understanding the business requirements and report specifications

. Created Reports using Query Prompts (parameters), Calculations, and

selection filters in the Reports.

. Created Crystal Reports/SSRS by using SQL views, Stored procedures

. Created daily, weekly, monthly and quarterly reports for the management

team and Regional Managers

. Involved in deploying the crystal reports in crystal server 2011 CMC

. Create open document URL and call it from .net Application

. Publications Creation for the users

. Created of security model in BO 4.0 and in SSRS

. Implemented SSO (Single Sign On) using active directory.

. Created Subscriptions for Crystal reports and SSRS reports.

. Disaster Recovery, Weekly Backups and server maintenance.

. Involved in testing the reports data and performance testing.

. Migrated Crystal reports From previous versions 8.5,2008

. Worked on Lifecycle manager for moving reports from Development to QA to

Prod

. Created Overview documentation on Crystal reports

. Involved in giving the Knowledge Transformation to team members and

client.

. Worked along with .net Resource for integrating Crystal Reports to

Application (Crystal reports for visual studio).

Project Name (4): CISCO-OTA (OFFICE TOOLS AUTOMATION)

Client: CISCO

(Sep'11 - Feb'12)

Role: Dashboard Developer

Assignment: ITT Calculator Dashboard

Business Problem: ITT (Interconnect Technology Team) is a part of CQT

(Component Quality and Technology) group in TnQ (Technology and Quality)

organization in CVCM. Main purpose is to assess the reliability and

qualify components for all Cisco products. A majority of the qualification

cases involve review of supplier data and perform an assessment based on

Cisco internal reliability criteria. Currently most of the qualifications

are managed and performed by Cisco contractor Foxconn in China. Their main

duty is to process the "paper" portion, as well as engagement with

suppliers. Reliability calculations (prediction of the life of a component

assembled on a Cisco product before failure) are based on proprietary

internal data and simulations and are considered Cisco IP. Therefore the

calculations have to be secure, even though FOC is the main user of these

calculations. The calculations are in the form of excel spreadsheets and

are not secure. In addition to the reliability calculations, ITT currently

maintains a PNR tracking database which keeps track of qualification

status of each Cisco part number.

Solution: A Dashboarding Solution was developed convert the reliability

calculations (Calculated life time) to web based tool where the user

enters the relevant data and receives the results and graphs. To establish

permissions so that contractors have only input/output access to the tool.

Environment: Xcelsius 2008 Sp2, Microsoft Excel 2007.

Integrating Platforms: .Net 3.5, SQL Server 2005

Project Role:

. Designed the logical model for the dashboard in Microsoft excel.

. Dashboard has been designed according to Cisco standard colors.

. Used various Chart components like Combo-boxes, Input Boxes, and labels.

. Dynamic visibility has been extensively used across the dashboard

development

. Table view is provided across all the metrics.

. Reset, Save Results, Generate Graph, Calculate, Email notification,

options for end user experience has be incorporated on the dashboard

which are completely functional.

. Save results saves the Targeted lifetime and calculated lifetime back to

the database

. Generate graph will give show a graph based on your Tin-lead/Lead free

selections.

. Email notification will send mail to the user saying that a particular

package is ready for review.

Project Name (3): CISCO-OTA (OFFICE TOOLS AUTOMATION)

Client:CISCO

(May'10 -Sep'11)

Role: Dashboard Developer

Assignment: APAC Renewals opportunity dashboard

Business Problem:

APAC Dashboard captures contracts by status, Contracts by service mix,

Contracts by market segment, Top 10 contracts by expiry with respect to

Region, Country, Top 20 contracts, and Top 20 partners based on users.

Solution: A dashboard solution was developed without the use of xml's, Asp

scripts were used in such a way that xml's were generated inside the

script itself which reduced weekly support for the pre-existing dash

boarding solution.

Environnent: Xcelsius 2008 Sp2, Microsoft Excel 2007, Integrating

Platforms: .Net 3.5, SQL Server 2005

Project Role:

. Designed the logical model for the dashboard in Microsoft excel

. Used various lookup,Aggregrate functions e.g. vlookup,hlookup

. Dashboard has been designed according to Cisco standard colors

. Used various Chart components like Bar chart, Column Chart,Pie chart

. Used Heat map, Table view to see top 10 or top n Partners

. Individual .Aspx scripts were used to link each of the metrics in the

dashboard

. Overall 13 .Aspx scripts were used to handle the entire Apac Dashboard

which helped us to avoid xml generation and Quick retrieval of latest

data from the database to the dashboard

. Dynamic visibility has been extensively used across the dashboard

development

. Download, Help,By, Print,Feedback,#2032 Error options for end user

experience has be incorporated on the dashboard which are completely

functional

. A web page has been designed for the Apac Dashboard which will be

scalable for future changes and all the changes will be completely

dynamic

Project Name (2): NCS STABLITY/STANDARD CHARTERED

Client: Standard Chartered

(Jul'08 -Apr'10)

Role: Report Developer

Business Problem: The objective of NCS Stability Reports Project is to

replicate transaction database, develop and convert the existing MS Access

based query to Crystal Reports and provide user-friendly screens to view &

generate Reports. The project would establish a dedicated infrastructure

to do the real time replication of reporting data from NCS system into a

data repository. By separating the transactional and reporting data,

system performance and response time should be improved. All the reports

which are currently getting generated using MS Access queries will be

migrated to crystal reports (Business Objects) to run against the

replicated report data repository, keeping the primary data source lean

and efficient in processing the time critical transactional activities.

Hence there would be a single sign -on to access all type of NCS reports.

Environment: Sybase 12.0, Crystal Reports X1, Business Objects XI R2,

UNIX.

Project Role:

. Created master/detail, cross tab reports based on user requirements.

. Used drill mode and slice and dice mode in reports.

. Created different Adhoc reports using Web Intelligence

. Interacting with end user to understand the report issues.

. Created parameterized Crystal reports

. Created parameterized Crystal Reports using Charts, Cross-Tab, Sub-

reports, and Running Totals.

. Create Reports and Dashboard Reports for entire court and separate

divisions.

. Create parameterized reports (these reports show information from highest

level by company and can be drill-down to single product using

hyperlinks), cross-tab, conditional, Top N, Summary and Sub reports.

. Frequently Scripts are used to start and stop the Server( running on

UNIX)

. Different set of files have been created on UNIX for Environment set up.

. Created Stored Procedures in Sybase.

. Created Xml for the Stored Procedures that has Parameters.

. Generated DDL script for the Developed Crystal Report.

. Generated Output for Corresponding Stored Procedures In Access for

Testing.

. Maintained a Smooth Flow of the Project by Creating No of Dsn's For Each

Country.

. Developed & Maintained Reports Tracker.

. Lead a team of 5 Developers.

Project Name (1): HARRODS PRODUCT STOCK INFORMATION (PSI)/Harrods Sales

Inc, US

Role: Report Developer

(Aug'05 -Jul'08)

Business Problem: The data warehouse solution was developed for Harrods

Sales a leading super market. The main objective of the project is to help

the senior and middle level management of the organization to improve the

sales and get the knowledge of the new business opportunities. Various

reports were generated to provide complete solution for the organization

to prepare the reports for managers so that they can analyze the reports,

which would provide them with the data such as which item was sold best in

a location, by which employee, who was the best distributor, who was the

best customer, what was the sale price and quantity and selling price and

customer purchase price with respective to a customer, distributor,

employee, order, order line.

Environment: Business objects XI R2, Oracle9i, Crystal Reports X1, windows

2000

Project Role:

. Designed and developed Universes

. Select and joining tables, indicating cardinalities, creating aliases to

resolve the loops, subdividing into contexts and creating the objects

which are grouped into classes.

. Developed Hierarchies to support drill down reports.

. Created master/detail, cross tab reports based on user requirements.

. Used drill mode and slice and dice mode in reports.

. Created different Adhoc reports using Web Intelligence

. Interacting with end user to understand the report issues.

. Created parameterized Crystal reports

. Created parameterized Crystal Reports using Charts, Cross-Tab, Sub-

reports, and Running Totals.

. Create Reports and Dashboard Reports for entire court and separate

divisions.

. Create parameterized reports (these reports show information from highest

level by company and can be drill-down to single product using

hyperlinks), cross-tab, conditional, Top N, Summary and Sub reports.

Trainings undergone at Virtusa

. Oracle Business Intelligence.

. SAP Crystal dashboard Design (aka)Crystal Xcelsius Engage.

. Cognos 8.4

Contact this candidate