SUMMARY

• Over 6 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2008/2008R 2/ 2012/2014/2016 /2017.
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Excellent knowledge in data modelling in Power BI with advanced knowledge of DAX.
• Experience of developing and creating stored procedure in SQL to feed Power BI.
• Extensive experience in using Microsoft BI studio products like SSIS,SSAS,SSRS for implementation of ETL methodology in data extraction, transformation and loading .
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Expertise in writing complex DAX in Power BI.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Migrated SSAS cubes with compatibility level 1200 to AAS cubes with compatibility level 1400.
• Good knowledge of Data Marts, Operational Data Store (ODS), MDM, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations using multi-dimensional expression (MDX), Perspectives and Roles.
• Performed Data Mining activities like Predictive Analysis, Forecasting on central repository for various application and dashboard functionalities
• Writing MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Excellent Power BI skills , Experience in creating solutions for mid-large sized companies with Advanced SQL server relational database.
• Developed power BI reports and dashboards from multiple data sources.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports.
• Experience with Azure SQL.
• Experience in utilizing the navigation features in Power BI (e.g. bookmarks, drill-through) to gude readers through a complex data-driven story.
• With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions
• Created Scorecard/Dashboard pages in Performance point server (PPS)
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, JSON,DHTML, HTTP, Shell Scripting

Databases: MS SQL Server 2017,2016,2014,2012

DWH / BI Tools: SQL Server Integration Services ( SSIS ), SQL Server Reporting Services ( SSRS ), SQL Server Analysis Services ( SSAS ), SQL Server management Studio (SSMS), Power BI, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2016, Microsoft Performance Point Server 2015

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, SQL Server Management Studio (SSMS), Power BI, Crystal Reports, Power Pivot, ProClarity, Microsoft Office (MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows Vista/XP, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Power BI/SSAS/SSIS/SSRS

Responsibilities:

• Developed Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing DAX queries.
• Handled complex DAX expressions to solve various business problems.
• Developed OLAP Cubes by using SQL Server Analysis Services (SSAS), and defined data sources, data source views, Dimensions, Measures, Hierarchies, Attributes, Calculations, Perspectives and Roles .
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Involves in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS).
• Automated the SSIS jobs in SQL scheduler as SQL server agent job for daily, weekly and monthly loads.
• Import data from different data source to create Power BI reports and dashboards. Involved in creating dynamic well-organized, accurate and insightful Power BI reports/dashboards to support strategic decisions.
• Created different reports in Power BI Desktop and publish to Power BI online.
• Created star schema and snowflake dimensional schema in MS analysis services (SSAS).
• Developed ETL using SSIS (SSDT-2017), created a security model using SSAS Tabular Model (DAX), using VSTS as source control. Generated hierarchy based - role based reports in Power BI for the management.
• Produced different reports that show KPI’s, Dashboards, Exceptions, Benchmarking reports and automating the reports in Power BI using SSAS tabular cube.
• Developed and Extended SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing DAX queries.
• Implemented role based security and dynamic row level security in Power BI and SSAS tabular cubes.
• Proficient in usage of SSIS Control Flow items (For Loop, Execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Having hands on experience in DR Processes including Log Shipping and Database Mirroring.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports with drill down, drill through and dropdown menu option using SSRS.
• Delivered the reports using ‘pulled’ and ‘pushed’ methodologies and formatted the reports using the Global variables and expressions in SSRS.
• Designed and developed SSIS packages, stored procedures, configuration files, tables, views, and functions, implemented best practices to maintain optimal performance.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed power BI reports and dashboards from multiple data sources and published them on service.
• Created different Power Pivot reports as per the client requirement.
• Developed user interactive Power BI reports utilizing charts, maps, matrices, slicers, tile, gauges, and funnel.
• Published Power BI reports to the Power BI self-service and troubleshoot deployment issues.
• Created hierarchies in Power BI reports using Data visualizations like Bar chart, Line chart, pie charts, forecast charts.
• Worked on creating DAX expressions, date to yearly columns and reporting update to date measures for Power BI.

Environment: MS SQL Server 2012/2014/2016 , SSIS, SQL Server Management Studio (SSMS), SSAS, SSRS, Jira, Visio.

Confidential, Houston, TX

SQL BI Developer /SSAS/Power BI/SSIS/SSIS

Responsibilities:

• Interact with the system analyst & business users to gather business requirements, system specification and enhancement.
• Setting up Power BI Environment, creating app workspaces, publishing apps and setting up Power BI Gateway.
• Utilized Power Query in Power BI to Pivot & Un-pivot the data model for data cleansing and data massaging.
• Created drill down and drill through report to go to details and child report within power bi based on hierarchy.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Converted SQL Server databases to Azure .
• Created SSIS packages to pull data from text files, XML files, SQL server and excel and exported to excel spreadsheets, flat files and vice versa.
• Published migrated data using SSIS, DTS Wizard (data transformation services) tool through data flow tasks, look up transformations and script tasks.
• Extensively worked on mappings, incremental data loading, and SSIS transformations that include: lookup, filters, aggregators, scripts, multicasts, derived (not limited).
• Intensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Scheduled the created SSIS /DTS packages using SQL server agent.
• Worked on error handling using try and catch blocks and performance tuning using counters in SSIS.
• Created complex stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Created complex SSIS Package using Script Task, For Each Loop, Derived Columns, Fuzzy Lookup, Condition Split, Sort, Union All, Execute SQL Task, Data Flow Task and File System Task.
• Used various data transformations like Conditional Split, Script Component, Derived Column, Sort, Merge Join and Data Conversion etc.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Worked on the Audit Logs that capture the audit details before and after the package execution using Variables and Parameters.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Created SQL server reports using SSRS for manager, customer support and that can deliver at client’s station.
• Designed different type of SSRS reports: Tabular, matrix (cross tab), conditional, list items, charts and sub reports.
• Creating Power BI dashboards and deploying them to SharePoint.
• Worked on Power BI and created reports and dashboards and published them on service.
• Created cascading (collapsed) parameters to a report and added report parameters that can be used in user-defined function.
• Responsible for ongoing maintenance and change management to existing reports and optimize report performance.
• Used Git and GitHub for integration and source control.
• Used Git and Git flow extension extensively to rebase, merge branches to the development and created tags.
• Expertise in Developing and Extending SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed printable, interacted reports (drill-down and sorting functionality).
• Created and designed reports based on query parameters and report parameters.
• Involved in creating cubes and dimensions for the new data warehouse using SQL server analysis services (SSAS).
• Took part in creation of star schema and snowflake dimensional schema in MS analysis services (SSAS).
• Supported in creating KPI, calculation members and measure groups, and MDX queries.
• Worked with preparing the documentation for analysis, Technical Specification documents, Functional Specification documents, mapping documents etc., for various migrations and up gradation projects.

Environment: MS SQL Server 2012/2014/2016 , SSIS, SQL Server Management Studio (SSMS), SSAS, SSRS, Crystal, Team Foundation Server (TFS), ASP.Net, .Net Framework MS - Visio, IIS.

Confidential, Pennsylvania, PA

SQL BI Developer

Responsibilities:

• Involved/Created initial package, keeping in view implementing appropriate SSIS controls.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc., to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Used different Transformation in SSIS as per design specifications.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Created stored procedures, triggers, functions, indexes, tables, views and other T-SQL code for experience.
• Developed different kinds of reports and created Drill Down and Drill-through Reports for summary and detail data.
• Configured Internet Information Services (IIS) and Deployed Reports and Analysis Project in to server.
• Created T-SQL queries using Joints and Create indexes on the database tables.
• Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
• Used SQL Profiler for monitoring performance issues in T-SQL code and stored procedures.
• Created Stored procedure, Views, Cursors and functions to support application
• Created Stored Procedures for package Initialization and end package information to update the package log table.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Actively supported Business Functionality for change requests and provide support to team Members.
• Provided support by troubleshooting and solving the issues.
• Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake Schema.
• Aided with optimization and performance tuning of stored procedures.
• Communicated with BA to understand the requirements and converted it into SQL stored procedures for database specific projects.
• Created Stored Procedures applying to complex business scenarios.
• Responsible for working with co-developers in designing packages in SSIS

Environment: MS SQL Server 2012/2008R2, Visual Studio 2013, SSIS, SSRS, T-SQL, Windows server 2012