SUMMARY

• Over 8 years of IT experience in the use and development, design, support and migrate of Microsoft SQL Server database using SQL server BI suite of products SSIS, SSRS, and SSAS in various domains like Health Care and Insurance, Logistics as SQL Developer and MSBI Developer.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration and Metadata Management Services.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server.
• Expert in generating on - demand and scheduled reports for business analysis or management decision using SQL Servers Reporting Services (SSRS), and Tableau, Power BI.
• Experience in SDLC methodologies & Agile methodologies in Analysis, Design, Development, Testing and Implementation of client - server based applications.
• Experience with SQL Server and T-SQL in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, Relational Database Models and Data Integrity in observing Business Rules.
• Extensive experience in BI Solutions (ETL & Reporting) using SSIS, SSAS, SSRS, Power Pivot and Tabular Model, DAX, MDX queries and T-SQL Programming using DDL, DML, DCL commands for various business applications.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Experienced in Creating DAX Expressions, create Date to yearly columns and implement partitions in Tabular Models for power BI.
• Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.
• Good experience in writing complex DAX functions in Power BI and Power Pivot.
• Experienced in data visualization by using Tableau to create graphs, charts and dashboards
• Extensive experiences in using Python to connect data warehouse with Tableau to design and develop reports by using visualizations and dashboards.
• Expert in data warehouse techniques and practices, experience including ETL processes, dimensional data modeling Star Schema, Snowflake Schema, FACT Dimension Tables, OLTP and OLAP.
• Good Knowledge in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Experience in providing Logging, Error handling by using Event Handlers, and Custom Logging for SSIS Packages and proficient in designing and scheduling complex SSIS Packages for transferring data from multiple data sources to SQL server.
• Extracted, transformed and loaded data from various heterogeneous data sources like SQL server, MySQL, Oracle, Teradata, MongoDB and destinations like Access, Excel, CSV, Oracle and flat files using connectors, tasks and transformations provided by SSIS.
• Good knowledge at developing ETL interfaces using SSIS, Data marts/cubes using SSAS and enterprise reports using SSRS utilizing latest versions & features.
• Experience in Developing and Extending SSAS Cubes, Dimensions and data source views, SSAS-Data Mining Models and Deploying and Processing SSAS objects.
• Hands on experience in creating Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
• Expertise in creating OLAP cubed and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Experience in Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema and Operational Data Store (ODS).
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.
• Good knowledge in Database Normalization, Optimization and Tuning, Backup/Restore, Update security, Data Import/Export, Trouble shooting and Database Objects authorization.
• Worked with cross-functional teams such as QA, DBA and Environment teams to deploy code from development to QA and Production server.
• Proficiency in writing UNIX Shell scripts, SQL Scripts for development, automation of ETL process, error handling, and auditing purposes.
• Excellent analytical and problem-solving skills and ability to work on own besides being a valuable and contributing team player.
• Ability to communicate effectively and good interpersonal skills.

TECHNICAL SKILLS

Databases: MS SQL Server, Oracle, NoSQL (Mongo DB) Teradata, Sybase, MS Access

SQL Server Tools: SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio (BIDS), SSDT, Report Builder

ETL Tool: SSIS, Talend, DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

OLAP Tool: SSAS, OLAP Cubes, MDX, DAX

Reporting Tool: SQL Server Reporting Services (SSRS), Tableau, Power BI

Scripting: ASP.Net MVC, Shell Scripting, PowerShell Scripting, Pearl Scripting XML, Python.

Languages: C#, SQL, T-SQL, MDX, DAX, Python

Operating Systems: Windows, Linux.

Tools: TFS, SVN, GitHub

PROFESSIONAL EXPERIENCE

Confidential

SQL /Power BI Developer

Responsibilities:

• 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.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in Development and Production environments.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system, PSD (Staging Database) to Parallel data warehouse (PDW).
• Developed and deployed SSIS packages for ETL from OLTP and various sources to staging and staging to Data warehouse using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term, Slowly Changing Dimension and more. Performed ETL mappings using MS SQL Server Integration Services.
• Involved in creating VB.Net Script for Data Flow and Error Handling using Script component in SSIS.
• Scheduled the packages to keep extracting the data from OLTP at specific time intervals.
• Managing various existing process to in corporate within the new development and create SSIS packages to feed the Datamart and data cubes.
• Configured Connection Manager files for SSIS packages to dynamically execute on QA and Production servers.
• Designed and created SSRS reports from SSAS cubes using SSAS cubes and connections and MDX to query the data. Involved in Data Analysis, Data Validation, Data Cleansing, Data Verification, and Data Mismatch Identification.
• Implemented DAX (Data Analysis Expressions) functions for SSAS tabular models and Excel pivot tables.
• Developed parameterized dashboards and reports with SQL Server Reporting Services (SSRS) using Visual Studio.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Worked on data migration (using tools like DTS, Bulk Insert, BCP and Replication) between different homogeneous and heterogeneous systems and SQL Server.
• Created hierarchies in Power BI reports using visualizations like Bar chart, Line chart, etc.
• Worked with both live and import data into Power BI for creating reports.
• Worked on all types of transformations that are available in Power BI query editor.
• Responsible for identifying, designing and implementing processes related to predictive / analytical modeling, data mining and complex data sets using statistical and text mining using python scripts.
• Managed relationship between tables in Power BI using star schema.
• Built metric reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• Created new calculations, KPI’s in Tabular cubes utilizing Data Analysis Expressions (DAX).
• Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.
• Used different type of slicers available in Power BI for creating reports.
• Established Power BI Premium and Embedding Environment and maintained its daily-to daily activities and troubleshooting it.
• Performed Database tuning, monitoring, query optimization, and System testing.
• Identified, track and managed program schedule, milestone, risks / issues, decisions and actions.
• Coordinated with users in gathering source data files, define data elements, business rules, data and process flow documentation, prepare High level and Low-level design documents.

Environment: MS SQL Server, T-SQL, Visual Studio, Teradata, MongoDB, Sybase, SSMS, SSIS, Excel, Power BI, DAX, MDX, SharePoint and Python scripts.

Confidential

MSBI/Power BI Developer

Responsibilities:

• Involved in daily batch loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS).
• Gathered business requirement, developed Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Involved in Source Data Analysis and Designing Mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Used different transformations like Conditional Split, Lookup, Merge Join, Aggregate, and Fuzzy grouping etc. for creating many SSIS packages.
• Used Fuzzy grouping transformation to consolidate data and submitted data cleansing reports to the client.
• Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Developed calculated members and MDX expressions for specific OLAP reporting requirements.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent in SSAS. Created star and snowflake schemas in SSAS
• Designed Incremental Load Packages which were used to load the updated and new data into the Enterprise Data Warehouse without removing the existing data.
• Created reports by dragging data from cube and wrote MDX scripts in SSRS.
• Designed and implemented a variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report Designer and Report Builder based on the requirements.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.
• Generating reports though power BI application.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Involved in Power BI 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.
• Integrated Custom Visuals based on business requirements using Power BI desktop.
• Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: T SQL, C#, SQL Server 2016, Visual Studio, SSIS, SSAS, SSRS, Python, Power BI, DAX, MDX, JIRA, SQL Server Management Studio, SQL Profiler

Confidential, Brentwood, TN

MSBI/Power BI Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of agile model system.
• 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.
• Wrote new Stored Procedures for new system and optimized old Store Procedures and Functions on Production Server.
• Involved in Framework development for ETL Implementation and support for the Analytics and Reporting needs for various customers.
• Performed Data Profiling, Data pipelining, and Data Mining, validating and analyzing data (Exploratory analysis / Statistical analysis) and generate reports.
• Performed data cleansing, enrichment, mapping tasks and automated data validation processes to ensure meaningful and accurate data was reported efficiently.
• Used SSIS and T-SQL stored procedures to transfer data from OLAP and OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Performed data migration from Excel, Sybase, Oracle to MS SQL Server using SSIS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server Analysis Services
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• Worked on Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports
• Conducted and automated the ETL operations to Extract data from multiple data sources, transform inconsistent and missing data to consistent and reliable data, and finally load it into the Multi-dimensional data warehouse.
• Extensively used filters, prompts, consolidations and custom groups to generate canned reports and ad hoc reports.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases and process SSAS cubes to store data to OLAP databases.
• Designed and Developed matrix, tabular and parametric Reports in the SQL Server Reporting Services.
• Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.
• 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.
• Published Power BI Reports in the required originations and Made Power BI Dashboards available in Web clients and mobile apps.
• Created Dashboard and the Content Pack for the originations to get the updated Power BI Reports. And added the refresh time for each tile in the dashboard.
• Built Ad - Hoc reports in Power BI depending on business requirements was one of the major responsibilities.
• Wrote DAX Queries to build Power BI calculated measures and Calculated columns.
• Create reports in Power BI preview portal utilizing the SSAS Tabular Model via Analysis connector.
• Implemented Error Logging using Event Handlers and implemented logging in SSIS Packages
• Developed free-form reports using SSRS for consolidating multiple reports into single report delivered in .pdf format to the power users.

Environment: T SQL, C#, SQL Server 2016, MSBI Tools (SSIS, SSAS, SSRS), SQL Server Management Studio, SQL Profiler, Python, DAX, MDX, and Power BI