Name: Anvesh Perugu

Background: India, Worked as a data analyst, Currently Working as a BI analyst. Worked as a volunteer for smith family and did some paid volunteer work for salvation army.

Data/BI Analyst

Project Details:

VIC Roads

Environment: MS SQL Server 2019(SSIS, SSAS, SSRS), Power BI

Project involves the analysis of the operational data store and development of reports for VIC Roads project executives and operational users.

Responsibilities:

Involved in complete Software Development Life Cycle (SDLC) process by analysing business requirements

and understanding the functional workflow of

information from source systems to destination

Systems.

Analysing the SIS ODS Data source systems

Developing mappings to populate data from various systems to the single data warehouse

Designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL

Server

writing and structuring T-SQL in the creation of tables, views, functions, and stored procedures within SQL

Management Studio and SQL Query Analyse

Preparing data mapping, technical guide and deployment guide documents.

Data Analyst

Projects: Site Start up (MS SQL Server), External Access Project Dashboard (Cognos)
Client: Quintiles Transnational Corp, North Carolina
Environment: COGNOS 8.4/ MS SQL Server 2008 R2, ODI, OBIEE, Oracle 10g, Agile Methodology, HP Open View.

Description:
Project involved the design and development of Data Warehouse for Quintiles. Quintiles helps drug and medical device companies develop and sell their products. The firm provides a comprehensive range of clinical trials management services, including patient recruitment, data analysis, laboratory testing, and regulatory filing. Its consulting unit offers strategic advice at every stage of drug discovery and development, and its Innovex subsidiary is a contract sales organization providing sales personnel to promote approved products.

Responsibilities:

Analyze the Source Systems and specifications provided by the clients and develop specification documents for reports as per client requirements

Created ETL jobs using SSIS, ODI

Used SSAS / Framework Manager to build models and packages

Developed Standard Templates, Dashboard Reports, Standard Reports, Charts, and Drill through Reports, Master-detail & conditional formatting reports using OBIEE, SSRS, Report Studio and Query Studio

Developed filters, calculations, prompts, conditions, and created various reports for users using COGNOS

Trainee Program as a Data Analyst

Project: Retail sales analysis
Client: Sertec Corporation, Atlanta
Environment: Series-7, Power Play, Transformer, COGNOS Report Net, Oracle 9i

Description:
This project was for their retail business covering the consumer products. Data warehouse was designed to enable sales analysis in order to help the decision makers analyse the sales patterns using the following business angles or dimensions i.e., Product, Branch, promotions, customer, supplier, time and tegions.

Responsibilities:

Involved in analysis of report requirements

Created reports in cognos report net using Report Studio and Query Studio with
functionalities like cross tab, master detail and formulae etc

Involved in creating charts using Report Studio

Update status to onsite coordinator on regular basis

Skills in Languages and Databases

MS Office Tools: Outlook, Word, Excel, PowerPoint

Operating Systems: Windows

Browsers: Internet Explorer, Mozilla Firefox, Google Chrome, Safari

Software Development Life Cycle

PowerBI and Tableau

Languages: T-SQL, PL/SQL, Stored Procedures, VB, DAX, MDX.

Databases: SQL Server 2012/2014, IBM DB2

BI Tools: Microsoft BI stack, Cognos.

Python and r programming