PROFESSIONAL SUMMARY:

• 6 years of IT Experience in Database Design, Development and business intelligence of Confidential SQL Server 2016/2014/2012/2008 R2/2005 in Development, Test and Production Environments with various business domains.
• Worked on Big Data analytic with peta byte data volumes on Confidential Big Data platform (COSMOS) & SCOPE scripting.
• Worked on fetching data from various platforms including Facebook, LinkedIn, Google.
• Experience in complete MSBI Stack including data analysis, database design, data mapping and conversion and data load with SSIS, SSAS and SSRS.
• Hands on experience in dealing with Relational Database Management Systems, including Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors, Normalization.
• Good knowledge on Database Administration operations like Backup, Restore and excellent knowledge in Transact - SQL (DDL, DML, DCL) .
• Created data base on Confidential Azure, setting up connection strings and connecting SQL server AZURE databases from locally installed SQL Server Management Studio(SSMS) for developers
• Hands on experience in implementing complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Strong experience in SQL Development , ETL development using Confidential SQL Server Integration Services (SSIS) , Business Intelligence delivery using Confidential SQL Server Analysis Services (SSAS) and Reporting solutions using Confidential SQL Server Reporting Services (SSRS) .
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform Drill through and drill down operations in SSRS.
• Hands-on experience in development of strategic and complex reports using most of the features and tools included within the report builder (list, matrix, graphs, sub-reports, tablix).
• Created and scheduled subscriptions for the reports using SSRS 2008/2012 .
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access , Excel , CSV , flat files using connectors , tasks and transformations provided by SSIS .
• Experienced creating and scheduling SQL Server Agent jobs for running ETL processes and performing data massaging.
• Data analytics and engineering experience in multiple Azure platforms such as Azure SQL, Azure SQL Data warehouse.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Hands on experience on Power BI DAX queries for creating measures and columns dynamically.
• Hands on experience on creating and deploying SSAS cubes using Star Schemas and Snow Flake Schema.
• Experienced in providing 24X7 production support for critical ETL processes and strategic financial reports.
• Excellent problem solving, analytical, technical, interpersonal and communication skills and an extremely diligent strong team player with an ability to take new roles.

TECHNICAL SKILLS:

OLAP/Reporting Tools: SSAS, (SSRS), MDX, Power BI

Relational Databases: SQL Server 2016/2014/2012/2008 R2/2005, MS Access, SQL Server Azure

ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS.

Other Tools: Confidential Office 2003/2007/2010 and 2013, Power pivot.

Data Modeling Tools: Confidential Visio 2003/2007/2010 , Erwin and Power Builder.

SQL Server Tools: SQL server Management Studio, Confidential Visual Studio 2010/2013/2015

Programming languages: SQL, T-SQL, .NET, C#

Data Modeling: Physical and Logical Data Modeling

Data Warehousing: Star Schema, Snowflake schema, Facts and Dimensions tables

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, Washington

DATA ENGINEER / TECHNICAL ANALYST

Responsibilities:

• Strong work experience in writing COSMOS scope scripts to perform various data analysis based on client campaigns.
• Good knowledge of performance improvement on SCOPE scripts.
• Strong experience in using ISCOPE for quick data analysis and data fetching.
• Strong working experience on Facebook API Developer tools, Graph Explorer for pulling marketing data specific to Campaign performance.
• Involved in data ingestion to/from Cosmos ( Confidential big data platform) using SCOPE scripts.
• Reading unstructured data from various sources and converting to structured streams using scope script and power shell.
• Run scope scripts using Windows PowerShell and scheduling jobs daily, weekly basis.
• Good knowledge of using C# in SCOPE scripts for various method/function calls to have data conversion or complex extractions.
• Experience in fetching data from various platform Facebook, LinkedIn and perform data analysis for various campaigns.
• Experience in using User Mapping Service (UMS) to connect Confidential data with other platform data like LinkedIn.

Environment: COSMOS SCOPE scripting, Facebook Graph API Explorer, UMS, C# and .NET, Confidential SQL Server.

Confidential, Redmond, Washington

DATA ENGINEER / DATA ANALYST

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Performed Database Administration of all database objects including Tables, Clusters, Indexes, Views, Sequences Packages and Procedures.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports.
• Development of COMSOS/SCOPE script to fetch relevant data from BIG DATA web log files.
• Worked closely with different business teams to gather requirements, prepare functional and technical documents and UAT Process for Creating Data quality rules in cosmos & Cosmos Streams.
• Converted unstructured streams in Cosmos (Raw Data which are in Binary form) to structured stream (readable stream) and performing required aggregation on that Data using scope studio by writing scope scripts.
• Converted unstructured stream to structured stream by Writing Scope Scripts, scheduling jobs in time ranges as Daily/weekly/Monthly, writing merge scripts to merge years of data to represent in trend graphs and publishing the data to cosmos/Kusto’s/sql according to requirements.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Publishing Power BI reports on to the Power BI Service and managing the permissions across the domain.
• Creating Gateways for automatic refresh of Power BI Reports, handling various clusters and managing data sources across the Service.
• Expertise in creating reports from importing, Direct query and Live data from several data sources.
• Expertise in data transformations such as adding calculated columns, manage relationships, create different measures, remove rows, replace values, split columns, date and time column etc.
• Expertise in creating DAX queries.
• Create different reports in Power BI Desktop and publish to Power BI online/service.
• Expertise in scheduling Power BI reports and troubleshooting refresh issues.
• Expertise in installing, maintaining and handling personal and on-premise gateways.
• Expertise in maintaining and handling different data sources.
• Expertise in creating dashboards and reports.
• Created reports such as Parameterized, Cascading, and Drill through/Drill down Reports, Charts and specialized in producing Sub Reports using Relational data warehouse.
• Created daily, weekly, monthly reports for various categories and Hierarchies based on business needs.
• Import data from different data sources to create various Power BI reports and dashboards on desktop and on service.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Worked on developing web page quickly and effectively using jQuery, HTML5, CSS3, Responsive Web Design, Bootstrap.
• Extensive experience on modern front-end template frameworks for JavaScript including Bootstrap, JQuery, AngularJS etc.
• Created a Dashboard (Website) for the business users using Angularjs v1 Kendo UI framework. The User Interface involves AngularJS, .Net.
• Experience on working with CSS Background, CSS Layouts, CSS positioning, CSS text, CSS border, CSS margin, CSS padding, CSS table, classes, Pseudo elements and CSS behaviors in CSS.
• Embedded SQL server data on to the website and managing the daily data without any congestion.
• Integrated Power BI Reports on to the User Interface with the help of Power BI Service.
• Moving the UI code to production servers and providing a 24/7 support for the business users and maintaining the Dashboard.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSAS, SSRS, Management Studio, Visual Studio, Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2, Visio 2010/2013, Power BI Desktop, Power BI Service, AngularJS 1, .NET, HTML/HTML5, CSS/CSS3.

Confidential, Redmond, Washington

MSBI DEVELOPER

Responsibilities:

• Developed SSIS packages for extract/load/transformation of source data into data warehouse/OLAP cubes as per the functional/technical design and conforming to the data mapping/transforming rules.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.
• Developed parameterized reports, drill down, drill through reports, sub reports as per the report specifications and functionality.
• Implemented complex business logic through T-SQL stored procedures, Functions, Views and advance query concepts.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Directly involved into requirement gathering and understanding business functions with the end users.
• Provided valuable suggestions to users in terms of database design and new application implementation to overcome existing performance and reliability issues.
• Created report schedules and subscriptions. Created data driven subscriptions, reports that run on demand, cached the Reports, Snapshot of the Reports. Deployed reports both to the SharePoint server, IIS Server, Integrated SharePoint server with Report Server.
• Performance tuned long running lengthy SSRS reports and optimized rendering time by 10 times of the actual time.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports.
• Developed complex calculated measures using Data Analysis Expression language (DAX).
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Successfully redesigned and migrated complex applications from Access to SharePoint and SQL Server 2008 by evaluating database structures and data movements.
• Provided 24X7 production support to ensure timely and error free delivery of reports.
• Performed performance tuning and optimization of SQL queries to improve query performance and to reduce runtime.
• Extensively worked on enhancements and performance issues of the existing data import processes.
• Developed Multi-dimensional, OLAP cubes as per the specifications using SQL Server Data Tools. Participated in the design, development of hierarchies, dimensions, attributes, properties, calculation and allocation routines for delivering the desired KPI’s in the Cubes.
• Independently worked on different stages of SDLC by gathering requirements, managing development, providing support and documentation processes thereby ensuring timely deliverables and uninterrupted continuity of business.
• Developed meta-data structure and configuration for storing/preserving database connection and security parameters using SQL Server configurations, XML configurations.

Environment: MS SQL Server 2008R2/2012/2014, SSIS, SSRS, Management Studio, Visual Studio, DTS, Windows 7, MS Office 2010/2013, Windows Server 2008 and Windows Server 2008 R2, Visio 2010/2013, Power BI Desktop, Power BI Service.