Data Sql Server

SUMMARY

Over **+ years’ solid experience in enterprise data warehousing and building analytics platforms creating value out of both big and small data

Solid Expertise in D3M, Design, Develop, Deploy and Maintenance EDW BI analytics platform implementation for fortune 500 customers using various tool like SSIS, SSAS, SSRS, Power BI, AWS Data Pipeline, AWS Lambda, S3, QlikView and QlikSense

Strong focus on value driven delivery, efficiency, innovation & technology leadership

Good working knowledge of Analysis & Design methodologies, Agile/Scrum Development.

Expertise in designing of OLAP, OLTP, Star Schema, Snow Flake Schema, Fact Table, Dimension Table, Logical Data Modeling and Physical Modeling using Erwin

Hands-on experience in Data Analysis, Data Masking, Data profiling and data cleansing using Complex SQL scripting

No SQL using Cosmos and Scope scripting

Developed dashboard/score card reports using Power Views, Excel based reports, Reporting Services, QlikView, Report Model and ad-hoc reporting using Report Builder and QlikSense

Handled multi-terabyte database design and maintenance

End to End implementation of BI Platforms

CERTIFICATIONS

Microsoft certified professional (MCP) with certification in SQL SERVER

EDUCATION

B.C.A. Bachelor of Computer Applications (MCRP Vishwavidhyalaya, University-Bhopal).

M.Sc Master of Computer Science (Maharshi Dayanand, University- Rohtak )

LANGUAGES AND TOOLS

SQL, Postgres, Scope, C#, VB

Cosmos, SharePoint, Agile/SCRUM, Power BI, SSIS, SSRS, SSAS, Cloud computing, AWS Redshift, AWS Lambda, S3, AWS Data Pipeline, QlikView and QlikSense.

PROFESSIONAL EXPERIENCE

Covant Solutions

Client: Expedia, Bellevue, BI Engineer Mar 15 - Present

Legacy system maintenance of SEM (Search Engine Marking) DB’s, designing new/modifying existing SSRS reports and QlikView reporting.

Over 14 TB data, constantly monitoring the DB performance and keeping up to the mark for better performance.

Initiated several work items to improve current system run faster and smother with best practices.

Design and implementation has done for new SEM system in AWS Redshift

Data transfer for daily files from S3 and AWS Lambda event based Web Service

AWS Data Pipeline used for transforming data from LZ (Landing Zones) to Staging and Reporting.

Continuous integration and Continuous deploying using git and Jenkins process.

Client: Microsoft, Redmond, Lead Data Analyst Feb 13 - Mar 15

Design and build DataMart’s using Bing Search Data, Windows 10 and Different MSN Apps on search data traffic and provided value out of target metrics for tacking growth and user sessions.

Designed multi-dimensional cube by pulling the data from COSMOS using Scope.

Build SSAS Cubes out of database and build SSRS reports on top of it using MDX queries.

Designed data models for Power View’s in Power Pivot and deployed to SharePoint.

Develop tools to track report (SSRS and Power view) traffic deployed to SharePoint for User trend analysis.

Developed Bing CSI Reports using SQL Reporting Services (SSRS) and Power Views.

Cognizant

Client: Microsoft, Redmond, Lead Developer Dec 10 – Feb 13

Designing and implemented a Dimensional Model.

Designed orchestration engine for end to end data process with logging and tracking data process.

Initiated and developed tools for internal dev team to cut down manual process with fully automated way which as bring down 5 days’ work to less than 5 mins

Client: Microsoft, Redmond, Technical Lead May 10 – Dec 10

Handled multiple project implementation (SLPI, EMR) and delivered successfully to clients.

Worked with SSIS packages to transfer data from multiple sources to SLIP EDW using best industry practices.

Build SSAS Cubes out of database and build SSRS reports on top of it using MDX queries.

Designed Dashboard, Scorecards and KPIs in PPS referring SSAS CUBE as source.

Designed Advance charting for SSRS using Dundas Chart and same has been referred in PPS Dashboard.

IT America Inc.

Client: WA State Govt (DSHS), Olympia, Architect Dec 08 – May 10

Analyzed business and functional requirements for CARE Reporting project

Designed Data warehouse platform for storing CARE data coming from different data source

Developed Dashboard and Canned Reports using SQL Reporting Services (SSRS)

Developed ASP.Net Web Application to display Reports to users using C# as code behind

Client: Microsoft, Redmond, Architect May 08 – Dec 08

Designed Enterprise Data Warehouse for Microsoft Roadmap project for his analytics platform

Worked with SSIS packages to transfer data from multiple sources to Roadmap EDW using best industry practices.

Build SSAS Cubes out of EDW and build SSRS reports on top of it using MDX queries.

Wipro Technologies Ltd.

Client: Microsoft, Redmond, Senior/Lead Developer Oct 03 –Mar 08

Developed Dash Boards and Canned Reports using SQL Reporting Services (SSRS), ad-hoc reporting using Report Builder and Excel reporting.

Involved in development of Integration Services (SSIS) packages to pull the data from heterogeneous data source from different providers (Siebel, oracle, DB2, SQL Server) to destination systems and extensively used parallel processing for better performance.

Expert in designing and building SSAS Cubes and writing MDX queries for various projects using best practices.

Build DataMart’s for different subject areas of a business and integrated business related marts into Data warehouse using Bus Architecture.

Expert in designing data modeling using Erwin Tools with different design models Star Schema and Snow flake Schema.

Expert in writing Low level design, High level design and deployment documents.

Trained users on Ad-hoc reporting and help them understand how to build reports from scratch.

Developed CLR & T-SQL Stored Procedures for one of the project at Microsoft.

Developed XML Web Service and Windows Services for matter management to communicate with external web services

Contact this candidate