SUMMARY

• Over 7+ years of experience in MS SQL Server Business Intelligence with demonstrated success in Database Design, Development and Deployment of large - scale enterprise applications in various IT domains.
• Highly proficient in SQL Server 2005/2008/2008 R 2/2012/2014/ 2016/2017/2019 , Business Intelligence tools - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) and Power BI
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server (2008R 2/2012/2014/ 2016/2017/2019 ).
• Experienced in creating and using Stored Procedures, Views, User Defined Functions, Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Proficient in performing database activities like Data Modeling, Data Staging, Data cleansing etc.
• Experienced in designing Dashboards with various data Visualizations tools like Microsoft Power BI.
• Experience in Power BI Designer with Power Pivot for Excel, Power View for data visualization and used DAX for use in calculated columns for reports and analysis purpose.
• Experience in Extracting, loading data to from sources like OLEDB, Excel, Flat files etc. using SSIS.
• Created SSIS packages with Error handling, notifications and Package configurations.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in generating Drill Down and Drill through reports with Drop down menu option, Sorting the data, defining Subtotals in SSRS.
• Experienced in Designing, Maintaining and Building Cubes, Dimensions, and Data source views, Data mining Models, Deployment and Processing using SSAS. Proficient in writing MDX queries and use Client tools like Excel to provide visualizations on Multidimensional or Tabular model Cube data.
• Created and scheduled Various SQL Jobs, using SQL Server Agent to perform various Administrative tasks.
• Experience in MS SQL Server Configuration, Performance tuning, Query optimization, Back-up/recovery, running Database Consistency Checks using DBCC. Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Executed several Emergency change requests, by following up with multiple teams, which was critical for Business, implemented in Production within stipulated timelines
• Excellent analytical, communication and interpersonal skills.
• Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS

Databases: SQL Server 2008/2012/2014/ 2016/2017/2019 , Oracle, No SQL (Mongo DB), Teradata, DB2, MS Access

Operating Systems: Win XP/Vista/7/10/Linux

Microsoft Tools: Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Enterprise Manager, Query Analyzer, Profiler, Performance Monitor, Tableau, Database Tuning Wizard.

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

Programming Skills: Python, T-SQL, Java, C#, VB.net HTML

Performance Tuning: DAX Studio

ETL Tools: MS Data Transformation services (DTS), SQL Server Integration Services (SSIS), Azure Data Factory

Reporting: Microsoft SQL Server Reporting Services (SSRS), Power BI (Power Pivot, Power View, Power Query), Tabular SSAS, Performance point

Data Modeling: Star Schema Modeling, FACT, Dimensions Tables, Physical, Logical and Conceptual Data Modeling, Erwin.

Scheduling Tools: Windows scheduler, SQL Server Agent, Maestro etc.

PROFESSIONAL EXPERIENCE

Confidential, Mechanicsburg, PA

Power BI Developer

Responsibilities:

• Analyze business requirements/processes and system integration points to determine appropriate technology solutions.
• Designed, developed and deployed the OLAP database project
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Designed enterprise reports using SQL server reporting services (SSRS) and excel pivot tables based on OLAP cubes which make use of multiple value section in parameters pick list, cascading and dynamics reports.
• Working extensively in Power BI report creating tabular cube, creating data model for Power BI Report, Validating data quality of the report.
• Developeddynamic row level security with SSAS Tabular modelto restrict data access for various users.
• UsedPower BI Power Pivotto develop data analysis prototype and usedPower ViewandPower Mapto visualize reports.
• Responsible for Extraction, Transformation and Loading (ETL) of data from multiple up-stream sources to Database. Up-stream sources are OLTP, excel, SharePoint lists & Azure SQL Database
• Involved in ETL processes and develop source-to-target data mappings, integration workflows, and load processes.
• Worked with ETL team to build data transformations with SSIS including importing data from files, moving data from one database platform to another; helps build star schema data marts.
• Experience in Advance performance tuning, optimizing SQL queries and building indexes
• Responsible for Maintaining, Monitoring Datasets, Performance tuning for reports/dashboards and control capacities in Power BI Service Experience on publishing Power BI reports on dashboards in Power BI server.
• Experienced in Data Modeling used to define and analyze data requirements needed to support the business processes within the scope of corresponding information systems in organizations.
• Participated to create Star Schema, Snow Flake Schema using the concept of data modeling with Team.
• Experienced in Dimensional Data Modeling and some of the terms commonly used are Dimension Table, Attributes, Hierarchy, Fact Table, Lookup Table
• Transformed complex business logic into Database design and maintaining it by using SQL Performed extensive data extraction from web and other sources and handled data preparation - missing values, formatting, transformations using SSIS.
• Experience in designing and building complete ETL/SSIS processes moving and transforming data for ODS, Staging, and Data Warehousing.
• Worked closely with Power BI Admin to in corporate Deployment pipelines for various environments for dev / QA / Prod on Power BI Premium capacity.
• Participated in the Agile methodology daily scrum and other sprint meetings. Utilized the Agile Scrum methodology to analyze the requirements to create stories
• Worked on data analytics using SSAS Tabular Model and Excel (Pivot table analysis)
• Developed various visualization charts like Line charts, Pie charts, Maps, Tiles, Cards, Images, Tables, Bubble & Scatter Plots, Key Performance Indicators using Power BI.
• Identified data quality issues and supported the data governance initiative by participating in necessary activities including data profiling.
• Connecting to various sources like mongo DB and SQL server to load the data in to Power BI and build relationships between different source tables.
• Conducted investigative projects utilizing Python for data analysis and machine learning.
• Used Machine learning using “Python-Programming Language” for converting different language text to English for analysis.
• Created data marts and multi-dimensional models like Star schema and Snowflake schema.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).

Environment: MS SQL Server 2016/2017/2019 , SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), T-SQL, OLAP, ETL, Agile Methodology, No SQL (Mongo DB), Python

Confidential, Irving, TX

Power BI Developer / Azure

Responsibilities:

• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Experience in publishing 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.
• Trained Power BI to all business units and users.
• Incorporated filters to narrow down data presented and slicers for appropriate user interaction, conditional formatting to spotlight alarming or profitable numbers
• Created notifications and alerts, subscriptions to reports in the Power BI service.
• Involved in Created Complex ad-hoc Reports, Sub Reports, Linked Reports, Charts, Drill through Report Models and Drill down Report.
• Involved in Creating User Security and Roles in Power BI.
• Responsible for building reports in Power BI from the Scratch.
• Responsible for creating and changing the visualizations in Power BI reports and Dashboards on client requests.
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Experience on publishing Power BI reports on dashboards in Power BI server.
• Experience in Integrating Power BI App with Azure Active Directory Groups and Office 365 group to implement Row level Security.
• Experience in Integrating Power BI App with Share Point.
• Assigning different access permissions and security levels for the reports in Power for various levels of users in the company. Designed, Developed and Deployed Dashboards in Power BI.
• Extensive experience in Design and Develop ETL Processes data from external sources like Azure blob Storage, Azure Data lake Gen2 and ORC/Parquet/Text Files into Azure SQL Data Warehouse.
• Design and Develop ETL Processes in ADF Glue to migrate Campaign data from external sources like Azure blob Storage, Azure Data Lake and Using ORC/Parquet/Text Files into Azure Data warehouse.
• Design, Develop, test, and deploy ELT/ETL pipelines using Azure Data Factory.
• Implemented Copy activity, Data flow, triggers in Azure Data Factory Pipeline Activities.
• Developed multiple complex ETL pipelines and activities stores for full and incremental data loads into a Azure SQL DW.
• Designed and Developed ETL pipelines that will read data from various sources like CRM, ADP (HR and Pay role) and JDE(Operational) and loaded into Azure SQL Data warehouse.
• Designed Developed various objects like External Tables (HDFS format on any Azure cloud storage), Relational Tables, Views, Stored Procedures, Triggers and Other Database Objects.
• Designed and Developed ETL Frame that extract, transform, Audit and load data in Azure SQL Data warehouse and Used Various leveraged Architecture like Polybasic.
• Developed Azure SQL Data warehouse by Analyzing Analytical, Functional and Non-Functional Requirements and selecting appropriate MPP Methodology (Round Robin, Hash Distributed tables).
• Experienced working on larger datasets.
• Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services (SSRS).
• Developed single value and multi valued parameterized reports for Business Users using Microsoft SQL Server Reporting Services (SSRS).
• Generated several drill down and drill through reports using SSRS.

Environment: MS SQL Server 2016/2017/2019 , Business Intelligence Development Studio (BIDS), T-SQL, SQL Server Agent, Azure Cloud, SSIS, Azure SQL Database, Azure Data lake, Power BI.

Confidential, Lincolnshire, IL.

Power BI Developer / MS SQL

Responsibilities:

• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources using Power BI Service Desktop tool.
• Involved in database development using stored procedures, triggers, views and cursors.
• Created Cluster/Non - Cluster Index, Unique/Check Constraints, Views, functions.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Developed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management team for analysis.
• Involved in database development using stored procedures, triggers, views and cursors
• Involved in creating MDX, DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Wrote efficient Stored Procedures for the Optimal Performance of the system.
• Implemented projects using Agile Methodology.
• Embedded Power BI reports on SharePoint portal page and managed access of reports and data for individual users using Roles.
• Implemented advanced SQL queries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQL and Teradata SQL Assistant
• Used various sources to pull data into Power BI such as Sql Server, SAP BW, Oracle, SQL Azure etc.
• Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features.
• Used QlikView to extract, transform and load (ETL) source data from transaction systems
• Designed and developed new ETL/SSIS package that load data from OLTP into our existing Data Warehouse based on technical specifications and business requirements.
• Designed dimensional data model of the OLAP database using Erwin.
• Automated Power Query refresh using power shell script and windows task scheduler.
• Responsible for Creating and Modifying T-SQL stored procedures/triggers for validating the integrity of the data.
• Used Power BI Desktop to develop data analysis multiple data sources to visualize the reports.
• Deployed Dashboards, Reports and Data sources in the Power BI Service

Environment: MS SQL Server 2012/2014/2016 , SQL Server reporting services, SQL Server Integration Services (SSIS), T-SQL, DAX, Power BI Desktop, DAX, MDX, JIRA, Tableau, Microsoft Visual Studio 2014, Excel, Azure.

Confidential, Tracy, CA

SQL Server Reports Developer (SSIS/SSRS)

Responsibilities:

• Designed and Developed Database Objects likeTables, Stored Procedures, Triggers,Rules, Defaults, user defined data types andfunctionsfor this project.
• Developed, tested and implementedReferential Integrityrules and regulations through constraints, triggers and views, partitioned views.
• Developed multiple processes for Daily Reports using SSIS and SSRS.
• Developed multiple processes for Daily Reports to business users on shared Network and email attachments with email notification using SSIS and SSRS.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report service (SSRS).
• Designed and Implemented various reports using Crystal Reports and responsible for the migration to SSRS
• CreatedViewsfor specific columns on a table to maintain privacy of a customer data.
• CreatedIndexesto get the high level performance.
• Performing theETLoperations to support the incremental, historical data loads and transformations usingSSIS.
• DesignedSSISpackages for synchronizing the data between two different servers.
• Maintained databases, performed software installations and upgrades, monitoredDatabase Performance.
• Responsible for gatheringBusiness RequirementsandSystem Specificationfrom users.
• Designed numerous ad-hoc and custom reports usingSQL Reporting Services (SSRS).
• Created various Tabular and Matrix Reports usingSSRS.
• Created various drill down reports using SSRS.
• Experience in the design, development and maintenance of different cubes usingSSAS.
• Involved in the post deployment maintenance of reports and cubes.
• Developing ETL Frame work to extract and load the data from multiple databases fromSQL Server 2008toFile Server and File Server to work flow Job System SQL databases.
• Createdandscheduled jobsfor various tasks.

Environment: Microsoft SQL Server 2008/2008R2/2012/2014, SQL Server Reporting Services (SSRS), Management studio, SQL Server Analysis Services(SSAS), SQL Server Integration Services (SSIS), Business intelligence Development Studio(BIDS), T-SQL, Oracle 10g,11g, PL/SQL, TOAD v9.5, MS Excel.

Confidential, Bentonville, AR.

ETL / BI Developer

Responsibilities:

• Interact with business analyst, Development Team and Managers to analyze business needs and developed technical specifications.
• Gather business requirement by understanding business Processes and didRequirement and Feasibility analysis (RF analysis) andwork breakdown structure(WBS) during minor and major tasks and made excel recording for requirements and reality checks.
• Provided technical leadership and expertise indata mapping,database design, andimplementationand maintenance phases.
• Attended meetings with different stakeholders and client:Insurance Carriers, Employers, Self-insured Employers, and Healthcare Services.
• Created staging environment in SQL server 2008 for thedata migrationfrom different heterogeneous sources(legacy data, CSV, Excel files).
• Designed, implemented and configuredETLprocedures by creating Control flow and dataflow using SQL Server Integration Services.
• Designed data flow diagrams after RF analysis usingMS VISIObefore creating SSIS package.
• Created SSIS Package template - indirect xml configuration, logging, package level and data level error handling using event handler (on error, pre execute and post execute event handler).
• Developed complex ETL Procedures to migrate huge amount of legacy data instaging tablesfromSybase, Access platformto application (OLTP) tables in enterprise data warehouse (BIDW).
• Performed data decoupling, orchestration of jobs and measure data quality and checked data dependencies using stored procedures and business rules like expected data and actual data in execute SQL task in BIDS.
• Created weekly different types of reports like Tabular, Drill-Down, Parameterized and sub-reports using SQL server reporting services, Weekly Conversion Data Quality Issues Reports.
• Employed error handling techniques and then trouble shooting them byError Logging,Checkpoint,Event handling, precedence constraints andPackage configuration.
• Automated file transfer processes and mail notifications by using Send Mail task in packages.
• Implemented Slowly Changing Dimensions to maintain historical data in Data Warehouse.
• Performedunit testing(UT) and Integration testing to ensure that the system is functioning as per user requirement.
• Maintained all the reporting, data quality, system integration and deployment test scripts.
• Created, Deployed and scheduled packages using SSIS, SQL Server job agent as per client’s requirement to generate on daily, weekly, monthly and quarterly Reports.
• Responsible to perform and monitor variousConversion Mock Runactivities. Back up, Restore of Databases and refreshed new scrubbed and cleansed database to Application Team for testing.

Environment: MS SQL Server 2008/2008R2/2012/2014, Windows Server 2008/XP 64-bit Edition, T-SQL, SSIS, SSRS, SQL Server Agent, ER\STUDIO, MS Access, MS Visio, CIMS Application, Dimensional Modeling, MS Access, Top-Team, TFS.

Confidential, Hammonton, NJ

SQL Server Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Converted Data Transformation Services(DTS)application to SQL Server Integrated Services(SSIS)as assigned.
• Creating reports usingSQL Reporting Services (SSRS)for customized and ad-hoc Queries.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services(SSIS).
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
• Designed dynamicSSISPackages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting usingReport Builder.
• Involved in migration from SQL Server 2005to SQL Server 2008.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for theSSAScubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services(SSRS).
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• UsedSSISto unite data from existing system and performed transformations on MS SQL 2008.
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Generated several drill down and drill through reports usingSSRS.
• Expert in creating Star schema cubes usingSSAS.
• Extensively worked on OLAP cubes using SSAS.
• Created and Managed OLAP Cubes using SSAS.
• Used Performance Point Server to create reports, scorecards and dashboards.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Designed and created the table schema andstored proceduresthat will be used in Data QC.
• Designed and developed theData QC Maintenancewebsite that will be used to maintain the application tables, execution of main Data QC store procedures, and report generation that will be exported to Microsoft Excel file.
• Used Joins and sub-queries for complex queries involving multiple tables from different databases
• Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
• Responsible for documentation of system related activities.
• Provides technical documentation of the system
• Experienced in integrating different Microsoft BackOffice Components such as Share Point and IIS with MS SQL Server
• Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
• Actively participated in interacted with users,team lead, DBAs and technical manager to fully understand the requirements of the system

Environment: MS SQL Server 2008/2008R2/2012/2014, SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS),SQL Server Analysis Services(SSAS),MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server