Sql Server Data

SHANKER KAROLA

Mobile : +1-425-***-****

E-mail : ********.**@*****.***

Location: Redmond, USA

SUMMARY

16+ Years of experience with SQL Server, SSIS, SSAS, SSRS, PowerBI, COSMOS

Specialty expertise with BigData, Hadoop, Hive, Sqoop, Pig Script

Specialty expertise with BI Architecture, Data Architecture, BigData Architecture, Technical Lead

Experience in Retail and Marketing Domain

PROFESSIONAL EXPERIENCE

Over 16 years of IT experience in Data Warehouse Architecture, SQL Server BI Developer, and experience in managing a team as a Technical Lead.

Extensively worked through the phases of Software Development Life Cycle: analysis, design, development, unit testing, implementation, enhancement and Maintenance.

Worked in USA for 6 years and have experience in leading, mentoring, coordinating with teams in an Onsite-Offshore model.

I have been working for Microsoft (India and Redmond) for the past eleven years in Microsoft Technologies like SQL Server, SSIS, SSAS Multidimensional and Tabular Model, SSRS, POWERBI, COSMOS, BigData, Hadoop, HIVE, SQOOP, SHAREPOINT, POWERShell and C#.

Captured data from existing SQL SERVER databases that provide SQL interfaces using Sqoop.

Imported and exported data into HDFS and Hive using Sqoop

Experienced on working with Big Data and Hadoop File System (HDFS).

Designed and Implemented Analysis Services Multi-Dimensional Cubes and Tabular Models.

Experienced in designing Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema using SSAS Multidimensional and Tabular Model.

Overall more than 1 year of experience in Cosmos. Proficient in writing Cosmos Scope scripts. Created automated tools to load data from Cosmos to SQL Server databases.

Used SCOPE.EXE command in Cosmos to submit the scope script job, to upload text data to Cosmos, download text data from Cosmos.

Strong expertise in SQL Server Performance Tuning on large databases. Proficient in handling large scale Data Warehouse with Terabytes of data.

Designed and developed ETL packages using Microsoft® SQL Server™ Integration Service (SSIS). Handled complicated business transformation to extract and load data.

Developed dynamic SSIS packages for Incremental Loads and Data Cleaning in Data Warehouse.

Experience in SQL Server Reporting Services to design, develop, deployment, administration on various kinds of reports. Efficient in generating parameterized reports, drill down, drill through, cascading parameterized, and matrix reports using SSRS

Designed and developed Reports in PowerBI Desktop tool. Generated reports using different data Sources like SQL SERVER, SQL Server Analysis Server, EXCEL and Sharepoint.

Designed and Developed Reports in Power View, Power BI, Power Query, Power MAP through EXCEL.

Designed and Developed Forecasting and Prediction of the Resource/Project Performance solutions. Generated Vendor Performance Scorecard, KPIs, Use cases reports.

Excellent working experience in .Net Technologies like C#, VB.NET

Automated one click deployment using PowerShell to install and deploy Cube Processing, Always ON Setup and update network settings.

Excellent analytical abilities, co-ordination, interpersonal skills and an outstanding team player with an attitude to learn.

Good intercommunication skills to work with all levels of management.

EDUCATION

Master of Computer Applications - Osmania University, Telangana, INDIA.

Bachelor’s Degree in Electronics - Osmania University, Telangana, INDIA.

TECHNICAL SKILLS SET

RDBMS/Data Access

MS SQL Server 2012/2008/2005/2000 (13+ years), MS Access

DataWarehouse Tools

End to End ETL with SSIS (8 years), SSAS Multi-Dimensional(5+ years), SSAS Tabular Model (2+ Years)

Programming Languages

T-SQL, XML, Powershell (2+ year)

Reporting Tools

SSRS (2 Years), POWERBI (3 Years)

Tools / Technologies

Visual Studio, Source Control, VSTS, Eclipse

.NET Technologies

C#(2 years), VB.NET, ASP.NET

Big Data

Cosmos (1+ year), Hadoop (2 Years), MapReduce, HDFS, HBase, Zookeeper, Hive (2 Years), Pig (2 Years), Sqoop (2 Years)

PROJECT PROFILES

Clients: Microsoft Duration: 11 years

Project 1 – DeviceCare – Supply Chain Management

Client: Microsoft Corp

Duration: 3 Months

Team Size: 12

Project Environment: SQL server 2012, SSAS Tabular Model, SSIS, Power BI Desktop, EXCEL, DAX

Description:

The Project Involves the Development of a Supply Chain Analytics. System process Microsoft product manufacturing, Returns, Planning, Customers, Retailers, Care, Finance, Quality, Product Compliance, Supply Chain information in Bigdata. Supply Chain Analytics process and generates Facts and Dimensions in Bigdata and pulls into the SQL Server using ETL. Data Marts are developed for Reporting purposes using PowerBI Desktop.

Business Intelligence within the supply chain improved internal efficiency and accountability while saving time and eliminating costs with metrics-decision-making and change management. System allows user to enable more predictable business performance by putting actionable information into the hands of key decision makers.

Project 2 – Windows Store Insights

Client: Microsoft Corp

Duration: 13 Months

Team Size: 29

Project Environment: SQL server 2012, C#, ASP.Net, COSMOS, SCOPE, SSAS, SSIS

Description:

The Windows Store Insights (WSI) aspires to be the cockpit for all Windows Phone & Client Store user and app metrics. It relentlessly user-focused, fulfilling & automating data needs for Windows Phone and Client Store stakeholders across the globe. WSI is central point for Apps-related reporting/analytics and store tooling work; focus on data analytics around Application Marketplace for the data produced through App development and certification, usage pattern, in app purchases, popularity, review and ratings. It builds upon SAGE and the Windows Phone Store Commerce Services System to create the Windows Phone Apps cockpit of instrumentation and controls. It aspires to enable members of the team, as well as other stakeholders, to monitor key store performance KPIs, generate self-serve and ad hoc pull and automated push reports for Microsoft – wide stakeholders, make faster data-based decisions, and enhance automation of common business operation tasks and processes.

Project 3 – MSIT-ECIT-ENG-NST

Client: Microsoft Corp

Duration: 3 Months

Team Size: 10

Project Environment: SQL server 2012, SSAS, SSIS, Excel Power Bi, DAX

Description:

Wipro resources will provide application development engineering services in Enterprise Commerce IT (ECIT) platform. The Navy Seal Team (NST) consists of set of developers, where in the scope of the work involves providing development services to the customer on any of applications in the ECIT group working on either a monthly or a quarterly release. The Development tasks are assigned by the customer to the team directly, where in the scope involves analysis (as needed) and Development. This team also consists of Product Launch/Compliance Factory team (PBF) who are responsible for analysis (as needed), Development and testing for a release where in the changes are mostly involving compliance changes (country name, sales location changes and similar activities) or repair (state/province changes, Legal entity changes and others).

Project 4 – MS ECO DES BIN

Client: Microsoft Corp

Duration: 5 Months

Team Size: 20

Project Environment: SQL Server 2012, SSAS, SSRS, Excel, Visual Studio 2015

Description:

This project gathers complaints and feedback data from customer related to a Microsoft product i.e. Xbox, Surface, Windows Phone etc. Customer can connect with Microsoft using different Channels either online (Chat, Internet Online request submission via ASD) Or offline via Phone. Incidents are supported by two different platforms in this project i.e. CAP (Customer Assisted Platform), ASD (Assisted Support Desktop). Dimensions and Facts are generated after merging data from different sources. SSRS and Excel reports are generated using cubes and database tables.

Project 5 – PKS BI Anti Piracy System (APS)

Client: Microsoft Corp

Duration: 20 Months

Team Size: 10

Project Environment: SQL Server 2012, SSAS, SSIS, SSRS, VSTS, Sharepoint 2010

Description:

PKSBI is to find the organization/people who is involved in the piracy of Microsoft products. The system helps the product developers to take the required steps to block the Microsoft product keys or to take the necessary actions on the defaulters.

Project 6 – PA Intel - BizPark

Client: Microsoft Corp

Duration: 22 Months

Team Size: 15

Project Environment: SQL Server 2012, SSAS, SSIS, SSRS, VSTS, Sharepoint 2010

Description:

PA Intelligence is the Business Intelligence platform and service for BGE-Product Activation. PA Intelligence uncovers business value from PA business systems and processes by identifying, understanding and prioritizing the analytical needs of our business customers. This is accomplished through data feeds from source OLTP systems into a centralized data repository, from which dimensional models, and cube processing steps are performed to optimize reporting.

Project 7 – MS-SUPPORT-POLICY2.0

Client: Microsoft Corp

Duration: 2 Months

Team Size: 4

Project Environment: Excel Addin, VSO

Description:

Report Usage provides additional reporting functionality, ideally supporting adhoc reporting of usage/inventory data about the SharePoint farms. MS Support Policy Report Usage is a reporting solution that meets BI scorecard requirements for all the customers reporting metrics on a month by month basis. System preserve reporting data in the event of a fail-over between environments

Project 8 – Business Intelligence Online Service

Client: Microsoft Corp

Duration: 22 Months

Team Size: 6

Project Environment: SQL Server, SSIS, SSAS, Microsoft Office PerformancePoint Server, Sharepoint

Description:

Microsoft Provides a low cost, scalable & secure Business Intelligence infrastructure solution that reduces complexity to Energizer. Microsoft provides BI Online services to Energizer. The different services which microsoft provides are PPS Planning Service, ETL Service, PPS M&A with SharePoint Online. Multiple environments for design and implementation Provide Self-service features to allow customers to focus on their BI business

Project 9 – Geneva

Client: Microsoft Corp

Duration: 15 Months

Team Size: 15

Project Environment: SQL Server 2005, SSIS, C#, Visual Studio, TFS

Description:

Geneva stores data from the existing source systems necessary to support GMP applications. The core objectives of Geneva are to insulate against source system data changes, rationalize the existing ETLs, and improve performance/up-time of today’s GMP applications.

Project 10 – Platform Consolidation 2.0

Client: Microsoft Corp

Duration: 10 Months

Team Size: 25

Project Environment: SQL Server 2005, SSIS, C#, Visual Studio, TFS

Description:

Integrated Reporting Platform (IRP) project replaces existing Enterprise Reporting System application to provide rich functionality to the users, rich Business Intelligence (BI) - Decreasing IT maintenance costs. IRP integrates all the existing sources and provides a single data store to meet the reporting needs of the users. IRP replaces existing data warehouse tool Informatica with SQL Server Integration Services catering to the global business needs of Enterprise Sales and Call Center users of Microsoft. Application provides data mining, data interpretation, data analysis capabilities and rich functionalities to create ad-hoc reports, standard reports, and dashboard reports. To generate reports IRP uses SQL Analysis Services, SQL Reporting Services, Siebel Analytics tool. The application supports 4000 real time users carried out by team of 25 members in 10 months. Implementing UI, Data warehouse and Data mart features in this version

Responsibilities:

Managed a team of software developers and responsible for work allocation, monitoring, code reviews and ensure quality of work is delivered to customers.

Collaborated with business analysts and offshore developers toward the implementation of changes, and worked with Quality Assurance (QA), and change management teams for IT releases to the data warehouse.

Architected enterprise data warehouse from requirements gathering to conceptualization to creation of data marts.

Created the Multi-Dimensional data model (STAR Schema) and implemented facts, dimensions, measures, calculations and OLAP cubes using dimensional data modeling standards.

Created aggregations, partitions, KPI’s and perspectives for a cube as per business requirements and created roles using SSAS to restrict cube properties.

Provided technical design overviews for the DW setup, and participated in technical reviews for IT related implementations.

Experience in query optimization by tuning Queries, fine-tune indexes, build efficient stored procedures, Views, Indexes, Analyze and understand execution plans.

Created the ETL architecture to extract and load Terabytes of data and provided strategy related to data cleansing, data quality and data consolidation.

Translated business requirements into design and technical specifications for implementation.

Developed Tabular, Matrix, Chart, Linked, Drill-down, and Drill-through Reports with drop down list of parameterized options in SSRS.

Created and deployed Dashboards, Scoreboards, Charts visualization and KPI’s using PowerBI Desktop

Designed and developed the Business components, Data components and GUI interface using .NET and C#

Clients: Direct Energy Duration: 6 Months

Projects: NorthStar 2.0

Technologies and Tools : SQL Server (2005, 2008, 2012), SSIS, VSTS, Visual Studio.NET, C#, .NET Framework 1.0

Responsibilities:

Design and Develop databases for NorthStar 2.0 Project.

Calculated the energy consumption using different metrics like State, Temperature, current Energy consumption

Designed tables using Star Schema and implemented facts, dimensions, measure groups, measures, calculations, relationship between facts and dimensions, and OLAP cubes using dimensional data modeling standards.

Created SSIS packages to load data for NorthStar.

Clients : I-Vantage, ADP Duration: 21 Months

Projects : Data Guard Systems, Fulfillment Service Tool

Technologies and Tools: SQL Server 2000, Visual Studio.NET, ASP.NET, Microsoft Transaction Server, C#, .NET Framework, ASP.NET, C#, VB.NET, Visual Basic 6.0

Responsibilities:

Present in the Software development life cycle (SDLC) from analysis, design, and implementation.

Involved in Preparation of Functional Design/Specification.

Understanding the business requirements of the customer.

Designed, developed, and testing the Business components, Data components and GUI interface.

Validations using java script and validation controls

Developed Components in Visual Basic 6.0 for Call center application

Clients : CSSI USA Duration: 9 Months

Projects : PIMS COM+

Technologies and Tools: SQL Server 2000, Visual Basic 6.0, ASP, Microsoft Transaction Server, COM+

Responsibilities:

Involved in designing, coding, testing and implementation.

Developed the applications using 3-tier COM+ architecture Object Model

Understanding business requirements of the customer.

Impact Analysis of Code Modification and Review.

Prepare Project Functionality documents and Specifications.

Code, Bug Fixings as per client request.

Clients : Owaisi Hospital, Darussalam Co-Operative Bank Duration: 39 Months

Projects : Hospital Management, Bank Management System, Bar Code Application Software

Technologies and Tools: VB 6.0, Oracle 8i, DB Access, Crystal Reports, COM, ADO

Responsibilities:

Developed full project life cycle of various Banking and Hospital systems including Account creation, Daily Transactions, Cheque book issue, Check Balances, Financial Tracking, Accounts Payable and Receivable, front desk etc

Involved in designing, coding, testing and implementation.

Understanding business requirements of the customer.

Impact Analysis of Code Modification and Review.

Prepare Project Functionality documents and Specifications.

Contact this candidate