SUMMARY

• Over 7 years of total IT experience in Database design, modeling, programming, development, and implementation of Client - server applications & database systems using SQL Server 2005/2008/2008 R 2/2012/2014/2016/2018.
• Experience indata warehousingandBusiness IntelligenceTechnologies with expertise inSQL Server development,MSBI stack (TSQL, SSIS, SSAS, SSRS), Azure, Power BIfor building, deploying, and managing applications and services through a global network of Microsoft - managed data centers.
• Data Modeler with strong Conceptual, Logical and Physical DataModelingskills, DataProfilingskills, MaintainingDataQuality, experience withJADsessions for requirements gathering, creating data mapping documents, writing functional specifications, queries.
• Experience in Performing Data Mining features like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Extensive Experience with PL/SQL, T-SQL, primarily in writing SQL Queries, Functions, Triggers, Indexes, Stored Procedures and User-Defined Functions using SQL Server 2005/2008/2012/2014/2016 , Oracle 12c/11g/10g, MySQL, MS Access.
• Superior proficiency in developing various types of reports like Standard, Drill through, Sub reports, Linked, Cached, and Click through, Matrix, Charts using SQL Server Reporting Services (SSRS)/ SQL Server Integration Services(SSIS)/Crystal Reports.
• Developed slowly changing dimension (SCD) mappings of Type1, Type2 and Type3 (version, flag, and time stamp). implemented Change Data Capture (CDC) for extracting Delta data.
• Experienced in SSAS Tabular data modeling.
• Experience with Microsoft AzureETL to move the data from several source to destinations
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Hands on experience on creating and deploying SSAS cubes usingStar SchemasandSnowflake Schema.
• Experience in Microsoft Power BI Tools such as Power Pivot, Power Map and Dashboards. Comfortable using Tableau.
• Extensively used ASP.NETData Grid, Data List, Repeater controls and Telerik controls for displaying the data in a clear format.
• Develop solutions and tweak business processes as needed using SQL Stored Procedures, VB. NET, C#, and VBA.
• Excellent in learning and adapting to new technologies
• Good experience in creating PowerShell scripts for automating cluster creation and storage accounts in the production environment
• Good working experience in using Version Controlling tools such as Subversion (SVN) and Team Foundation Server (TFS) for creating workflows and tracking, updating, releasing, and reporting of code.
• Experience in working in 24X7 Support and used to meet deadlines, adaptable to ever changing priorities
• Proven ability to work independently and as well as in a team and motivated to face challenges and meet deadlines
• Determined, committed and hardworking individual with strong communication, interpersonal and organizational skills
• Proficient in Technical and Business writing, Business Process Flow, Business Process Modeling and Testing.
• Experience in the analysis, functional design, technical design, configuration, and data conversion from legacy system
• Hands on experience on Microservices, Web Services API, REST, RESTFUL services, SOAP, SOA, WSDL
• Strong experience in all phases of Software Development Lifecycle (SDLC) using Waterfall, Agile/Scrum, RUP (Rational Unified Process) and Software Testing Life Cycle (STLC)

TECHNICAL SKILLS

Languages: SQL, Transact SQL, Embedded SQL, C, C++ XML, PL/SQL.

Databases: SQL Server 2012/2008 R 2/2008/2005/2000 , SharePoint, Oracle 11g,12c.

Reporting Tools: SQL Server 2014/2012/2008 R2/2005 Reporting Service (SSRS), Crystal Reports XI/10/9,Power BI & Tableau.

ETL Tools: SSIS (SQL Server 2005/2008/2008 R2, 2012,2015 Integration Services),SQL Server 2000 DTS, Import Export Data, Bulk Copy Program (BCP), ODI 11g,12c

Operating Systems: Windows (updated to 2016), MAC OSX Tiger/Leopard, Unix, Linux (Ubuntu updated to 12.04)

Database Tools: SQL Query Analyzer, SQL Enterprise Manager, Management Studio,SQL Server 2008 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization,Data Modeling

PROFESSIONAL EXPERIENCE

Business Intelligence Consultant

Confidential, WI

Responsibilities:

• Support in the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Developed complex T-SQL stored procedures and views for customers' highly customized reporting demands.
• Use SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.
• Performed DBA duties including database backups, restores, performance tuning, and capacity analysis.
• Very Strong SQL Server (includes working with DML, DDL, Stored procedures,)
• Create and maintain Schemas, Indexes, Stored Procedures, Triggers and Views for data retrieval and storage using the SQL Server
• Created packages using Integration Services (SSIS) for extracting data from Flat Files, XML files, CSV files, Access, Excel files, OLE DB to SQL Server, and load data to the Data Warehouse.
• DevelopedStarandSnowflakeschemas based dimensional model to develop the data warehouse.
• Designed data models with GE-ERCstandards up to3rdNFOLTP/ODS and de normalized OLAP data marts with Star Snowflake schemas.
• Extensive knowledge of using data profiling tasks for cleansing data, slowly changing dimension, and optimizing long running SSIS packages.
• Creating pipelines using AzureData factory and Azureapps services to pull data from Webservices and APIs into Azure SQL.
• Developing complex queries to pull data according to business logics. Designed Web-based ASP.NETInternet applications linked to firm-wide SQLdatabases.
• Developed SQLQueries and Procedures for storage and retrieval of data using ADO.NETand LINQ to SQL Developed Web Services for user authentication and file transfer
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.
• CreatedPower BI reportsby using Joins in multiple tables from multiples database using complex SQL queries.
• Knowledge on the Azure DevOps and it process of creation of the tasks, pull requests, Git repositories.
• Worked with Azure BLOB andData Lakestorage and loading data intoAzure SQL Synapse analytics (DW).

Environment: Power BI, Power BI Server, Power BI Desktop, Power Pivot, Power View, Power Map, DAX, ETL, SSIS, SSAS, SSRA, Power Query, KPI, MS Azure, OLAP, OLTP, TFS, SQL Profiler, SQL, SQL Server, Oracle, MS Excel, Windows.

Data Warehousing and Reporting Consultant

Confidential, Topeka, KS

Responsibilities:

• Supported the design and development of the logical and physical data models, business rules and data mapping for the Enterprise Data Warehouse system.
• Involved in entire product life cycle development from the requirement gathering through implementing in production.
• Designed and developed a custom database (Tables, Views, Functions, Procedures, and Packages).
• Gathered data from various external sources (Oracle) into a data warehousing system (Enterprise Cube) with the help of ETL process.
• Wrote T-SQL (DDL and DML) queries, stored procedures and used them to build packages and handled slowly changing dimensions to maintain the history of the data.
• Prepared detail design documents which contain job designs and functionality of each job.
• Developed SSIS/ODI extract jobs from different databases/files and API’s and load the data into an On-Prem oracle database.
• Created Unix Shell scripts to automate the data load processes to the target Data Warehouse.
• Developed SQL Scripts to validate the data after the loading process. Modified and tested PL/SQL stored procedures.
• Created ODI ETL/ELTmappingsusing thedesigner, respectiveworkflowsandworkletsusing theWorkflow managertoextract, transformandloadsource data from various heterogeneous sources to the associatedFactsandDimensions.
• Involved in Unit testing, Functional testing, and Integration testing. Designed the Target Schema definition and Extraction, Transformation and Loading (ETL) using SSIS/ODI.
• Extracted, transformed, and loaded data from Sources Systems to Azure Data Storage services using a combination of Azure Data Factory, T-SQL, Spark SQL, and U-SQL Azure Data Lake Analytics. Data Ingestion to one or more Azure Services - (Azure Data Lake, Azure Storage, Azure SQL, Azure DW) and processing the data in In Azure Databricks.
• Specialized in transforming data into user-friendly visualization to give business users a complete view of their business usingPower BI.
• Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• CreatedPower BI reportsby using Joins in multiple tables from multiples database using complex SQL queries.

Environment: MS SQL Server 2012/2008, Visual Studio 2008, Oracle 19c, SQL Developer, MS SQL Server Management Studio SQL Server Integration Services (SSIS), Power BI Server), SQL Server Migration Assistant (SSMA), ODI ETL/ELT, T-SQL, Power Bi Desktop, Data Warehousing, Data Hub, Data Transformation Services (DTS). Azure Databricks, Azure SQL database, Azure SQL Datawarehouse

Senior SQL BI Developer

Confidential, St. Louis, MO

Responsibilities:

• Worked with IT Analytics team on the client side for gathering requirements from users for Data Analysis.
• Performed Data Analysis, Data Profiling, Data Cleansing & Quality, Data Migration, Data Integration using. SSIS.
• Architected & implemented medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks.
• Generated Complex Transact SQL (T- SQL) Queries, Sub queries, Co-related sub queries, Dynamic SQL queries etc. Programming in SQL Server - Using the Stored Procedures, User-defined Functions and Views.
• Created large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008R2/2012.
• Configured and maintained Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, Azure SQL Data warehouse, write-back tool and backwards.
• Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service.
• Published the Power BI Desktop models to Power Bi Service to create highly informative dashboards, collaborate using workspaces, apps, and to get quick insights about datasets

Environment: MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008 MS SQL Server Integration Services (SSIS) 2017/2015/2012 MS SQL Server Reporting Services (SSRS) 2017/2015/2012 , SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), T-SQL. Oracle 12c, SQL Developer. Azure Data bricks, Azure SQL database, Azure SQL Data warehouse.

SQL/SSIS/ETL/DW Developer

Confidential, New York, NY

Responsibilities:

• Working with IT Analytics team on the client side for gathering requirements from users for Data Analysis.
• Designed ODS and Data Warehouses environments to store data from various sources.
• Developed ETL packages using SSIS to extract & load from Source Azure SQL Server and SAP HANA.
• Developed Linked services, Data Sets, Pipelines to establish connections, collect required data and cleansing processing the data.
• Created pipelines using Azure Data factory and Azure apps services to pull data from Webservices and APIs in Azure SQL.
• Optimized and fine-tuned the existing SQL queries to enhance the performance of the applications by analyzing execution plans and Implementing Indexes.
• Created large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2005/2008R2/2012.
• Extracted, Transformed and Loaded data from Sources Systems to Azure Data Storage, Azure SQL databases using an Azure Data Factory (ADF).
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.

Environment: MS SQL Server 2017/2016/ 2014/2012/2008 R2/2008 MS SQL Server Integration Services (SSIS) 2017/2015/2012 MS SQL Server Reporting Services (SSRS) 2017/2015/2012 , SQL Server Management Studio (SSMS), SQL Server Business Intelligence Studio (BIDS), T-SQL, Oracle 12c, SQL Developer. Azure Data Lake, Data factory

Senior SQL BI Developer

Confidential, Boston, MA

Responsibilities:

• Created several extracts using SSIS. Responsible for data mapping from QNXT to other implementation documents.
• Performed data conversions from SQL server to flat file using SSIS.
• Created packages that implements tasks like Execute SQL Task, Data Flow Task.
• Created Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
• Generated reports using linked reports, sub reports and filters in SQL server reporting services.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationship, calculations.
• Expert on creating multiple kind of Power BI Reports and Dashboards.
• Built a Tabular Model cube from scratch data and by MDX queries fetched data to SSRS and Power BI reports.
• Troubleshoot and supported reports in Power BI workspaces whenever there are issues in production.

Environment: SQL Server Management Studio 2012, Integration Services, Analysis Services, Reporting Services, SQL Server Data Tools, MS Visio, Cisco Tidal Scheduler.

SQL BI Developer

Confidential, Milpitas, CA

Responsibilities:

• Developed, deployed, and monitored SSIS Packages for new ETL processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes. Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Implemented and delivered of BI platform solutions to develop and deploy ETL, analytical, reporting and scorecard\dash boarding on SQL Server 2012 using SSAS, SSIS, SSRS.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Designed and created report templates, bar graphs and pie charts based on the providers data.
• Involved in creating calculated members, named set, advanced KPI'S for the SSAS cubes.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Created Power pivots, Power views and SSRS reports using tabular model (DAX), Cubes (MDX) and SQL queries. Also implemented user based subject selection (Role based security) in Power Views, Power Pivots and SSRS using DAX, MDX and SQL queries.

Environment: SQL Server Management Studio 2012, Integration Services, Analysis Services, Reporting Services, SQL Server Data Tools, MS Visio, Cisco Tidal Scheduler. Oracle 11g, SQL Developer