SUMMARY

• Over Seven Plus years of extensive experience and hands on working knowledge in various domains of IT industry as SQL/MSBI/PowerBI Developer.
• Hands on experience in different versions of MS SQL Server with Business Intelligence in SQL Server Integration Services, SQL Server Analysis Services and SQL Server Reporting Services.
• Extensive experience with all phases of Software Development Life Cycle in different environments like Healthcare, Banking, Insurance, and Information Technology.
• Application knowledge in software development life cycle (SDLC), Agile, Scrum, UML, Waterfall and Project Management Methodologies.
• Experienced in Extraction, Transformation and Loading (ETL) process using MS - SSIS, DTS application tools.
• Experience in data migrating between different homogeneous/heterogeneous systems and SQL Server as a part of Data Migration and Data Maintenance.
• Strong experience in design, develop and deployment of the SSIS packages and SSRS reports using SQL Server Data Tools.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Well versed in Using MDX/DAX Queries to retrieve data from Analysis Services Cubes.
• Explored data in a variety of ways and across multiple visualizations using Power BI Desktop and Service.
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports.
• Expert on creating multiple kind ofPowerBIReports and Dashboards.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Experienced on creating multiple kind of Report inPowerBIand present it using Story Points.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI andSSAS.
• Migrate existing data into thePowerBI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using PowerBI, SQL Server Integration Services (SSIS), Analysis Services (SSAS), and Reporting Services (SSRS).
• Performed data cleaning, data validation, and data analysis using data analysis expressions (DAX)
• UsedDAX(Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models.
• Well versed in managing and administrating PowerBI Service app workspaces, user roles, publishing apps and setting data sources on enterprise gateways.
• In-depth understanding in client requirement Analysis, Logical design, development, Testing, Deployment, Support and Maintenance of business applications using SQL Server, DTS, SSIS, SSAS and SSRS.
• Hands on experience with SQL programming and Transact-SQL in creating tables, Stored Procedures, triggers, user-defined functions, views, indexes, user profiles, relational database models.
• Experience in developing Custom Reports, Parameterized reports, and different types of Tabular, Matrix, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS).
• Involved in Every stage of Report authoring, managing, developing, deploying.
• Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports.
• Experienced in using global variables, expressions, and functions for the reports.
• Involved in designing and developing enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in writing MDX queries and in developing OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS and Report Builder 3.0.
• Good Working experience in designing STAR, SNOWFLAKE Schemas, database modeling, logical and physical database design using Erwin and Knowledge of how the Kimball approach has been implemented in the Microsoft BI tool.
• Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages.
• Hands on experience in installing, configuring, managing, monitoring, and troubleshooting SQL Server.
• Experience in using Team Foundation Server (TFS) and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in coding Unix/Windows scripts for file transfers.
• Strong working knowledge on the data analysis using SQL Server.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor, and Index Tuning Wizard
• Involved in working with databases in C# and Microsoft Visual Studio .Net environment.
• Involved in writing C#.net code for SSIS packages.
• Experience in co-coordinating with offshore team.
• Ability to work independently and in a team, capable of handling time-sensitive issues in distributed environments.
• Excellent Communication and interpersonal skills.

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2 R 2/2008/2005/2000, MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97

Database Technologies/Tools: SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: PowerBI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel.

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7

Programming Languages: T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design Technologies/Tools: Erwin, MS Visio, Rational Rose

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell

PROFESSIONAL EXPERIENCE

Confidential, North Carolina

MSBI/Power BI Developer

Responsibilities:

• Participate in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Developed and Published dynamic and complex Financial and Sales Reports in PowerBI.
• Used DAX to create complex measure and calculated columns.
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Used bookmarks feature which enables the ease to jump to respective report tabs with one click.
• Imported custom themes and page backgrounds for rich visual effects.
• Performed end to end testing on the reports and packages developed to ensure data quality is met.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.
• Develop and deploy SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2, Salesforce and Intacct.
• Created many calculated columns and measures using DAX inPowerBIbased on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQLqueries, stored procedures and SSIS packages to load the data into warehouse.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created, Maintained & scheduled various reports inPowerBIlike Tabular Reports.
• Explore data in a variety of ways and across multiple visualizations using Power BI.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Designed and built-up high performance ETL packages to migrate and manipulate data from MS Excel and SQL Server by using SSIS.
• Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.
• Responsible for debug, performance checks and performed index tuning and query optimization.
• Used Indexing strategies and query optimization techniques to optimize Stored Procedures and long running queries.
• Designed and created OLAP cubes on data warehouse.
• Designed a partitioning strategy to refresh cubes effectively.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Environment: MS SQL Server 2016/2014, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intacct, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8.

Confidential, Southfield, MI

SQL BI Developer

Responsibilities:

• Studied design documents and understood the business needs and the requirements for the project. Involved in discussion, peer review sessions to come up with an optimal design plan.
• Participated in the team business requirements gathering and analyze, understand and convert them into database solutions with solid exposure to architecture, analysis, design, testing, development, deployment, documentation & implementation.
• Designed and implementedSSASTabular Cube as the reporting layer. And Used DAX scripting to access data from Tabular Model.
• Developed Data Source, Data Source View to create a logical view of the data to be placed in OLAP Cubes using SQL Server Analysis Services (SSAS) projects.
• Designed and implemented Row Level Security & Roles forSSASTabular Model. And deployed into SQL SERVER ANALYSIS SERVER 2016.
• Created KPI's, Partitions, Perspectives, and Calculated Measures, used DAX queries, Roles.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Tabular Models
• Setting up PowerBI Environment, creating app workspaces, publishing apps and setting up PowerBI Gateway.
• Created Page Level Filters, Report Level Filters, Visual Level Filters in Power BI according to the requirements.
• Created Dashboard and the App Workspace for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Published Power BI Reports in the required origination's and Made Power BI Dashboards available in Web clients and mobile apps.
• Used One Drive for storing different versions of Power BI report.
• Created different visualization (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer, Time Brush etc.) in Power BI according to the requirements.
• Responsible for deploying the application for the Integration, Functional and User Acceptance Testing.
• Extract and analyze data using Power Query, PivotTables, MS Excel, POWER BI andSSAS
• Created or modified Databases, tables, indexes, views as per the requirement and analysis of records that are integrated from call records, online filing records.
• Designed, implemented and tested SSIS packages to load the records from multiple sources like Flat file, xml files and SQL server
• Performance tuning of SSIS packages and debugging, error handling using breakpoints, checkpoints used send mail task to notify the appropriate department regarding the progress.
• Modified various views, stored procedures, indexes which were affecting the performanceCommunicated the insights gained verbally and through visualizations to management teams (through ad-hoc reporting).

Environment: MS SQL Server 2016/2014/2012, MS SQL Server Analysis Services (SSAS), EDW, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Confidential, Richmond, VA

SQL Server/ MS BI Developer

Responsibilities:

• Worked in a scrum team that hold a standing up meeting every day, and Retrospective & Sprint Planning every two weeks
• Organized JRD meetings to gather business requirements from business users and SMEs.
• Created complex views statements with joins, sub queries, and correlated sub queries.
• Created complex SQL queries, derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Wrote SQL queries and stored procedures to generate data for reports.
• Created packages with SSIS tasks, transformations, and containers.
• Optimized SSIS packages utilizing parallelisms, fast load options, buffer sizes, and checkpoints.
• Designed SSAS cubes on an existing data mart for slicing and dicing data from different perspectives as per the business requirements.
• Developed user interactivePowerBIreports utilizing charts, maps, matrices, slicers, tiles, gauges, and funnel.
• Designed and demonstrated JSON Theme for standard customized visualization in Seattle Children'sPowerBIteam like line chart, Card, Table, and KPIs.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data-to-data warehouse databases and deployed with minimal changes using XML configuration file.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Generated matrix reports, drill down, and drill through, sub reports.
• Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
• Extracted data using SSIS from OLTP to OLAP. Based on the required reports, identified various data sources, established the connections using SSIS, and constructed data source view.
• Designed and implemented data access stored procedures and triggers for automating tasks and job scheduling.
• Created cubes in SSAS and build MDX queries to query cubes and to access cube's data.
• Identified and defined Fact relationships. Maintained and deployed OLAP Cubes in SSAS.

Environment: MS SQL Server 2016/2014/2012, MS SQL Server Analysis Services (SSAS), EDW, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XML, MS Excel, Windows 8, DAX Studio, M Query.

Confidential

SQL BI Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Experienced in database design process and data modeling process.
• Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
• Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
• Extracted data from various sources like DB2, VSAM, SQL Server 2014/2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.
• Analyzed business requirements and implemented data mart solutions for data mining and reporting.
• Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
• Created a report model on SSAS cubes.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.
• Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
• Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
• Developed reports with consistent drill-down functionality including Drilldown report and Summary report.
• Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Deployed and Tested (UAT) Reports in Multiuser Environment. Created RS Config Files and Ensure Report Security with Keys.
• Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.
• Worked closely with QA team and helped them come up with test scenarios.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server,Power-BI Tool.

Confidential

SQL/SSIS Developer

Responsibilities:

• Responsible for creating and designing SSIS packages.
• Created Power-BI driven dashboards and reports
• Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations
• Creating pipelines using Azure Data factory and Azure apps services to pull data from Webservices and API's in Azure SQL
• Used different transformation controls like Look up, Conditional split, data conversion, Unpivot, Audit, Aggregation, Merge, Merge join, union all, Multicast, sort, OLE DB command etc.
• Created complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins and statements for applications by using T-SQL.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Processed the data mapping for all the migrated jobs using SSIS andPower-BI
• Set up SQL Profiler to trace various Database activities, Application Responses, and their Performance to tune them
• Responsible for creating SQL datasets forPowerBIand Ad-hoc Reports
• Developed Dashboards and Reports with Excel, SQL Server, SharePoint List and Report Server data sources usingPower-BIService Desktop tool.
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to supportPower-BIand SSRS reports.
• Created script to migrate SQL server object from one environment to another environment
• Used the SQL Server profiler to capture and store the execution plan.
• Designed and implemented an application using C#, ASP.NET and implemented client side and server-side validations using JavaScript and Validation Controls.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints
• Involved in Tabular Data warehouse and DAX operations for SSAS 2016/2012 and 2008 OLAP databases.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports, and Drill-through reports.

Environment: MS SQL 2008 R2/2012/2014, SSIS, SSRS XML, T-SQL, DAX, MS Access, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#, ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server,Power-BI Tool.

Confidential

MS SQL DBA/Developer

Responsibilities:

• Designed and tested (unit, integration and regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2005.
• Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task and Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command and Derived Column.
• Developed error handling routines for packages using both script tasks as well as in the error handling environment.
• Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created complex SSAS cubes with multiple fact measures groups and multiple dimension hierarchies based on the OLAP reporting needs.
• Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
• Implemented various notifications based upon the scheduling jobs, database monitoring, disaster recovery plans and wrote windows scripting scripts for automation of tasks.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
• Evaluated database performance and performed maintenance duties such as tuning, backup and restoration.
• Responsible for creating parameterized, cascading, configuration, drilldown, rollup reports using SSRS and deploying them into server using report builder.
• Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
• Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
• Worked on performance tuning of ETL transformations, data validations and stored Procedures.

Environment: MS SQL 2008 R2/2012, SSIS, SSRS XML, T-SQL, DAX, MS Access 2010, MS Word, MS Excel, MS CRM, VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server,Power-BI Tool.