PROFESSIONAL SUMMARY:

• Over 5 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 Handling Heterogeneous data sources, databases Oracle, IBM DB2 and XML files using SSIS.
• 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.
• Explore d data in a Variety of ways and across multiple visualizations using Power BI Desktop and Service.
• Responsible for creating SQL datasets for Power BI and Ad-hoc Reports.
• Created, Maintained & scheduled various reports in Power BI like Tabular Reports.
• Experienced on creating multiple kind of Report in Power BI and present it using Story Points.
• Extract and analyze data using Power Query, PivotTables, MS Excel, Power BI and SSAS.
• Migrate existing data into the Power BI.
• Extensive experience in designing, developing, and delivering business intelligence solutions using Power BI, 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)
• Used DAX (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.
• 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, SNOW FLAKE 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.
• Involved in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard
• 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/2014/2012/2008 R 2/2008/2005/2000 , MySQL, Oracle and MS Access

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: Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel.

Operating Systems: Windows

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

Data Warehouse / Business Intelligence Tools: SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SSAS, Business Intelligence Development Studio (BIDS)

PROFESSIONAL EXPERIENCE:

Confidential, Topeka, KS

MSBI/PowerBI 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 in Power BI based on report requirements.
• Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• Developing and maintaining/modifying complex T-SQL queries, 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 in Power BI like 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.

Confidential, Des Moines IA

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 implemented SSAS Tabular 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 for SSAS Tabular 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 and SSAS
• 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 performance

Confidential, Minneapolis, MN

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.
• Designed SSAS cubes on an existing data mart for slicing and dicing data from different perspectives as per the business requirements.
• Designed and demonstrated JSON Theme for standard customized visualization in Seattle Children's Power BI team 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.
• Generated matrix reports, drill down, and drill through, sub reports.
• 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.

Confidential

SQL BI Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• 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.
• Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.