Data Engineer

Ramaswamy Guntu

Technical Lead Consultant

e-mail: adi514@r.postjobfree.com

Phone: 425-***-****

Summary of Experience:

Senior Consultant with 12+ years of professional IT experience in Data-warehouse, SQL Server Development and BI tools (SSIS, SSRS & SSAS).

Expert level skill in Extraction, Transformation and Loading (ETL) in SQL SERVER.

Working with Reporting Services to generate reports in different formats.

Working with Analysis Services both multi-dimensional and tabular to generate cubes.

Having Experience on writing DAX & MDX queries for SSRS reports and PowerBI.

Having knowledge on Data Warehousing concepts.

Having Experience on Azure SQL, Azure SSAS, Azure Data Factory, Azure Data Lake, Azure Databricks, Spark SQL, Azure Synapse.

Tools & Technology Expertise:

Coding Languages SQL Server 2005/2008R2/2012/2014/2016, SSIS, SSRS, SSAS Multidimensional/Tabular, T-SQL, MDX, DAX, PowerBI,, Azure SQL, Azure Data Factory, Azure SSAS Azure Data Factory, Azure Data Lake, Azure Databricks, Spark SQL, Azure Synapse

Operating Systems Windows

Version Control Visual Studio, SQL Server Data Tools, SVN

Professional Experience

Harman Connected Services Technologies PVT LTD

April 2016 to current date

Summitworks Tecchnologies

September 2015 – April 2016

Motifworks Technology Solutions

September 2011 – September 2015

Invensis Technologies

June 2008 – August 2011

Project Experience:

Client: Microsoft Duration: May 2016 – Till Date

Role: Technical Lead;

Project Name: SMSGR;

Tools: SQL Server 2012/2016, SSIS, SSRS, SSAS, MDX, DAX, PowerBI, Azure SQL, Azure Data Factory, Azure SSAS, Azure Data Factory, Azure Data Lake, Azure Databricks, Spark SQL, Azure Synapse

Project Abstract: Microsoft’s Project ‘SMSGR’. SMSG is one of the core groups at Microsoft and it stands for “Sales, Marketing, Services, IT & Operations Group”. The R on the end is the Readiness team – SMSGR – the team is part of the Operations division. The team provides training to the Microsoft field as a whole – helping the company get ready. SMSG Readiness (SMSGR) uses a tool called the Readiness Management System (RMS) to manage content development (builds), final publication of the content, curriculum planning and delivery management. This tool allows SMSGR to effectively manage field requirements around readiness and what the field should be consuming each year.

Responsibilities:

Gathering, understanding and implementing requirements.

Creating mapping documents, functional and technical specifications

Designing and development of the ETL framework – data quality and auditing.

Design and development of cubes, Reports, Power BI dashboards.

Design and development of complex SQL queries and SQL Server Databases.

Performance tuning of SQL queries and SSAS cubes.

Client: IMSHealth

Role: Technical Lead; Duration: September 2015 – April 2016

Project name: SPS (Store Level Pharmacy Services);

Platform: Windows;Tools: SQL Server 2008 R2, SSRS, SSAS, MDX.

Project Summary: SPS is a product, which has developed based on the feedback of different Pharmacy Services data. The ‘next generation’ pharmacy services will encompass all aspects of a pharmacy business and also establish new types of relationships between pharmacists and their stake holders. Create interdependency by developing a strategic business relationship where pharmacies need to send IMS their data. Build a strong negotiating position for IMS data negotiations and reduce the cash IMS must pay to access Pharmacy data. Developed this product for one country and made changes to it w.r.t the multiple countries, which results in gaining huge profit to the company

Responsibilities:

Understanding the pharmacy data and analyzing the impact on the growth w.r.t Manufacturer, Customer, Pharmacies and Doctors.

Have developed different dashboards based on the own analysis and showcase with Proof of concept showing different levels of growth in Market and made the customer for better decision making, which created interest to the customer to develop entire product.

Have developed new features in Dashboards like Search, dropdown, role-based security through reports, dynamic language change option based on the user logged in, and help pop up option in each and every part of the dashboard to make it more elaborated.

Have increased the performance by tuning mdx quires and creating partitions in cube

Client: WELTMAN, WEINBERG & REIS

Role: Technical Lead; Duration: November 2013 – August 2015

Project Name: EDI;

Platform: Windows; Tools: SQL Server 2008 R2, SSIS, SSRS

Project Summary: WWR is the largest creditor’s rights firm in the country according to collections & credits risk magazine. Using revenue as a measurement service banks & financial institution, real estate mortgage & lending companies, commercial creditors, government entities, insurance companies, credit unions, medical and utility companies, student lenders, servicers and business/service organizations. Represent clients on retail, real estate default, commercial and collection matters involving bankruptcy, foreclosure, evictions.

The EDI Send project is for extracting the data from Data Warehouse views and loads the data into staging tables using SQL Server integration services to generate the output files for monthly, weekly and daily basis.

The EDI load project is a key component of a larger enterprise wide process of making data available to other WWR systems. The goal of the new EDI process is to convert the current EDI processing in a technology and architecture that promotes easy turn-around time in new builds as well as modifications to existing load processes.

Client: Microsoft

Role: Senior Software Engineer; Duration: May 2013 – October 2013

Project name: Premier Sales Tool;

Platform: Windows; Tools: SQL Server 2012, SSIS, SSRS

Project Summary: The Premier Sales Tool (PST) is a field-facing tool designed to support account targeting and the right-sizing of support services selling. It forms one of three pillars in the Premier vNext Program being developed and rolled-out in FY13-FY14.

‘Right-sizing’ is defined as the identification of the appropriate quantum and types of services for an account. The recommendations are made at a TPID-level. ‘Peer group comparison’ is used as the analytical basis for making recommendations. Accounts with the largest gaps to predicted sales outcomes are prioritized as high-potential targets.

Responsibilities:

Extracted data from source like SQL Server Databases, SQL Server Analysis Services Cube, Excel and loaded into the target MS SQL Server database.

Creating SSIS Packages by using different data Transformations like Derived Column, Data Conversion, Sort, Merge join, Lookup, Conditional Split, Script Component, Union All and OLEDB Command.

Creating SSIS Packages by using different Control Flow Tasks like Data Flow Task, Execute SQL Task, Sequence Container, For Each Loop Container, Send Mail Task, Analysis Service Process task.

Client: Microsoft

Role: Senior Software Engineer; Duration: September 2011 – April 2013

Project name: ODI;

Platform: Windows; Tools: SQL Server 2008 R2, SSIS, SSRS, SSAS

Project Summary: The Office Managed team is responsible for the Office Deployment metric across Enterprise accounts (including EPG and SMS&P segments). The team uses an established Enterprise reporting dashboard to run the business and has access to summary deployment status through the EAF and ROB scorecards. However, the ability to access more granular deployment information is limited, e.g.

The process is limited by lag, limited analytical flexibility for business management support, and a cumbersome process for data management

History and audit tracking are also inadequate – it doesn’t support scenario analysis & planning. There is limited capability for systematic forecasting.

Responsibilities:

Extracted data from source like MS SQL and loaded into the target MS SQL Server database.

Creating SSIS Packages by using different data Transformations like Derived Column, Aggregate and Multicast.

Creating SSIS Packages by using different Control Flow Tasks like Data Flow Task, Execute SQL Task, Send Mail Task, Analysis Service Process task.

Worked on writing and modifying stored procedures as per business requirements and implementation.

Developing and formatting the reports as per specification.

Developed Standard Reports, Charts, Drill Down Reports, Tabular Detail Reports.

Worked on writing and modifying MDX queries for SSRS Reports and Excel Reports.

Role: Software Engineer; Duration: August 2010 – August 2011

Project Name: ROCKIT;

Platform: Windows; Tools: SQL Server 2008 R2, SSIS, SSRS

Project Summary: ROCKIT is a data migration project of BTGS. BT Global Service, having customers all over the world are in the process of migrating different systems in a single system. For example, Orion and RTO are two different systems used by BT customers in different part of the world. Though these two systems are having same business functions, but these are maintained separately, and the databases are totally isolated. This increases the cost of maintenance as there are number of isolated BTGS systems exist all over the world. So, BT decided to merge these systems in a single system. Data Migration is required to migrate data of any Source System to a Target System. After migration of data, all the source systems are replaced by the Target System and the client applications access the same data from the Central Repository of the Target System.

Responsibilities:

Creating SSIS Packages by using different data Transformations like Derived Column, Lookup, DataConversion, ConditionalSplit, Merge, MergeJoin, Union all and Execute SQL Task to load data into Database.

Worked on witting and modifying stored procedures as per business requirements and implementation.

Developing and formatting the reports as per specification

Extensively used SSRS to create weekly, monthly, Quarterly, and Annual Reports and Charts.

Developed Standard Reports, Charts, Drill Down Reports, Tabular Detail Reports.

Involved in Creating the Cubes by using Sql Server Analysis Services

Role: Software Engineer; Duration: September 2008 – April 2010

Project name: HORIZON OVERPAYMENTS;

Platform: Windows

Tools: SQL Server 2005, SSIS, SSRS

Project Summary: Horizon is a health insurance company, which provides insurance facilities for people, vehicles and third parties; it is having 3.5 million customers. Horizon will provide the data through CSV, the data will be like claim data, eligibility data, IDC,NDC &RX data according to this, data will be spitted into different tables and the data will be validated, for the validating of data SSIS packages are developed and from this packages reports for the duplicate claims, overpayments, outdated claims are identified.

Responsibilities:

Creation of SSIS packages using Sql Server Integration Service to load data into Data warehouse from OLTP Systems.

Cleansing OLTP Data by applying transformations like Derived Column, Conditional Split, Data Conversion, Merge Join, Lookup, Union all and OLEDB command……

Implementing slowly changing dimensions to maintaining Historical data in Required Dimension Tables.

Creation and scheduling of ETL Packages Using SQL Server 2005 Management Studio.

Involved in writing the stored Procedures and Functions.

Education:

B.Tech, Computer Science & Engineering, ANU, AP, India.

Contact this candidate