SUMMARY

• Over 8+ Years of IT experience which includes System Analysis and Design, Development & Support of MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 in Production, QA and Development Environments.
• Experience in creating SSRS reports and developing SSIS packages
• Experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design and ETL.
• Developed complex Stored Procedures, Triggers, Views, Functions, Indexes, Normalization, Data types using MS SQL Server 2005/2008/2008 R 2/2012/2014/2016 and MS Access databases.
• Involved in installing and configuring gateway services for PowerBi Desktop.
• Proficient in Extract, Transform and Load process using SQL Server Integration Services (SSIS).
• Experience in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in Database Development, modeling, Data Warehousing, Design and Technical Management.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.
• Used MDX to interact with the back end OLAP Services
• Developed complex SSIS packages for processing type 1, type 2 and type 3 data with multiple transformations like Slowly Changing Dimension, Merge, Lookup, Derived Column and Conditional Split.
• Created reports using SQL Reporting Services (SSRS) for customized and ad - hoc Queries.
• Experience of Relational Database Management systems (RDBMS) and Database design issues like normalization and de-normalization.
• Experienced in debugging and troubleshooting SSIS packages using Breakpoints, Checkpoints, Error Handlers, Event Handlers, etc.
• Experience in writing complex T-SQL (DDL, DML and DCL) scripts in all MS SQL server environments.
• Worked on crystal reports with many complex stored procedures.
• Created multi-format reports using Crystal Report.
• Expert in designing SSRS and Power Pivot reports.
• Experience in creating jobs, alerts and scheduling DTS/SSIS packages in SQL Server Agent on daily/weekly/monthly basis.
• Work Experience on ticketing tools TFS and Jira.
• Extensive working experience with different methodologies like Agile (Scrum), Test-driven development (TDD) and Waterfall methodologies.
• Experience in building, deploying and managing applications on Microsoft Azure Cloud computing platform.
• Flexible, enthusiastic and project-oriented team player with excellent written, verbal communication to develop creative solutions for challenging client needs. Worked on creating complex reports using Report Designer in SSRS.

TECHNICAL SKILLS

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS)

Reporting Tools: SSRS 2012/2008/2005, Crystal Reports XI/X/9/8, Excel, COSMOS, Tableau, Power BI

Database: MS SQL Server 2012/2008/2005, Oracle 10g/9i/8i, MYSQL, MS-ACCESS, MDS

Programming: C, C++, Visual C++ 6.0, VB6.0, C#.Net, VB.Net, PL/SQL, TSQL, Java, EE, Shell Scripting.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio, SSMS

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

Web Technologies: HTML, XML, JSON, JavaScript, PHP, jQuery.

PROFESSIONAL EXPERIENCE

Confidential, HOUSTON, TEXAS

MSBI DEVELOPER/SSIS/SSRS

Responsibilities:

• Working in Agile team as SQL Server/SSIS Developer.
• Create, modify and optimize database schemas, stored procedures and SQL queries.
• Analyze, troubleshoot, and resolving complex data issues. Write code for complex stored procedures to implement the business rules.
• Work closely with business stakeholders to conduct complex SQL data analysis.
• Prepare the mapping documents for existing stored procedures. Perform SQL profiling. Analyze the performance issues of existing stored procedures and fine tune performance of the system.
• Created multiple dashboards to tack material supply and production dashboard for each facility location.
• Integrated Custom Visuals based to account for unique business requirements using Power BI desktop
• Build Models in ThoughtSpot as part of BI tool comparison and POC process.
• Built data model in Power BI having star schema and used Power Query to extract data from external sources and cleaned, transformed, modified the data using DAX to ingest it into Power BI for reporting.
• Worked on Gateway creation, RLS to constrain the user access to the row level data. Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements
• Developed complex calculated measures, columns using Data Analysis Expression (DAX) language.
• Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS) in Tabular Model.
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities
• Primarily involved in Data Migration using SQL, SQL Azure, Azure storage, and Azure Data Factory
• Developed complex SQL queries using stored procedure, common Table Expression (CTE) to support BI reports
• Working with business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications.
• Used Power BI Embedded for embedding report to internal SharePoint application using Power BI REST API
• Built data model in Power BI having star schema and used Power Query to extract data from external sources and cleaned, transformed, modified the data using DAX to ingest it into Power BI for reporting.
• Worked on Gateway creation, RLS to constrain the user access to the row level data. Created various visualizations such as Stacked Charts, Pie Charts, Donut Chart cards according to business requirements.
• Created MDX, DAX, Cubes and Tabular models using Azure Analysis Services (SSAS).
• Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes
• Develop and improve solutions spanning data processing activities from the data lake (stage) to star schemas and reporting view’s / tables and finally into SSAS.
• Develop and improve Microsoft Analysis Services cubes (tabular and dimensional)
• Embedded Power BI reports on intranet portal and managed access of reports and data for individual users using roles
• Used various sources to pull data into Power BI such as SQL Server, Athena, Cerner, SQL Azure etc.

Environment: Power BI’s Components, Power BI Reporting/Dashboard, Business Objects 4.2/4.1, SQL Server, Microsoft Azure, Oracle, Azure Data Factory, Databricks, SSMS, SSRS, SSIS, SSAS, T-SQL, DevOps, Microsoft Office 365, Microsoft Dynamic 365 CRM, Business Intelligence Client Tools xi4.2/4.1, Web Intelligence, Tableau, EMR System, Power App, Powe Automation, ServiceNow, Business Intelligence Launch Pad, Data Warehouse Bus Architecture, Teradata, Windows 10, Microsoft Excel

Confidential, PITTSBURGH, PA

MSBI Developer /SSIS/SSRS Developer

Responsibilities:

• Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
• Created various Jobs, Alerts and Events, Created Backups for databases and automated the process.
• Created tables, views, indexes, stored procedures, triggers and provide constraints and user defined rules and defaults.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS Packages and using various features like Excel source, Flat file source, transformation etc.
• Created derived columns from the present columns for the given requirements.
• Hands on experience working with SSIS for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• 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.
• Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Have the excellent woring experience in building the .Net core Web Apis or Rest Apis, .Net Web Services, .Net core console applications, .Net core windows or win forms applications.
• Hands on experience with JSON and XML.
• Created multiple sequential and parallel jobs and scheduled (Daily, weekly) as per requirements.
• Used Agile methodology for the development.
• Maintained JitBit for tracking and updating project defects and tasks.
• Created Views, Materialized Views to get the values dynamically using joins and other SQL queries from the multiple tables.

Environment: SQL Server 2016/2014/ 2012/2008/2005, SSRS, SSIS, SQL Mail, SQL Server Management Studio, T-SQL, XML, MS Excel and MS Access, Crystal Reports, visual studio 2005/2008/ 2012, Jira.

Confidential, DES MOINES, IA

MSBI Developer /SSIS/SSRS Developer

Responsibilities:

• Upgraded SQL Server 2014 to SQL Server 2016 and migrated data from old systems to new systems.
• Worked with Business requirements analyst to identify and understand source data systems and Developed Mappings between source systems and warehouse components.
• Extensively used SSIS transformations such as Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task and Send Mail task.
• Actively monitored performances of queries on SQL server 2016 using SQL Profiler and optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Involved in SQL Server Configuration, Administration, Implementation and Trouble-shooting for Business work.
• Worked on crystal reports with many complex stored procedures.
• Used different formulas to create Crystal Reports such as IF-Else, String, Grouping.
• Had good experience in Customizing cross-tab appearance.
• Created multi-format reports using Crystal Report.
• Migrated existing self-service reports and Ad-hoc reports to Power BI.
• Developed custom calculated measures using DAX in Power BI to satisfy business requirements.
• Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All and Copy Column, Derived Column using SSIS.
• Worked on Development and implementation of SSRS reports and ran them as per the requirement.
• Responsible for the issues raised from the production and debugging and deploying the updates.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Created Reports with latest features provided by SSRS like dynamic navigation, hyperlinks, different set of graphs in tabular format etc.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2016.
• Configure Power BI dashboard and reports.
• Configured the report viewing security for various users at various levels using Report Manager.
• Involved in the creation of Data Mart by taking into various business process by identifying different dimensions and facts.
• Created and managed Database(s) on SQL AZURE. Setting up Connection Strings and connecting SQL Server Azure Databases from locally Installed SQL Server Management Studio.
• Developed existing ETL Packages which are multiple steps from source to ODS, integrated to Data Warehouse as per structure.
• Involved in the design of Logical and Physical design models of various relational databases using Erwin Data Modeling.
• Involved in Data Profiling to create table and column naming as per business terminology based on source data.
• Created multiple sequential and parallel jobs and scheduled (Daily, weekly) as per requirements.
• Used Agile methodology for the development.
• Maintained JIRA for tracking and updating project defects and tasks.
• Created Views, Materialized Views to get the values dynamically using joins and other SQL queries from the multiple tables.

Environment: SQL Server 2016/2014/ 2012/2008/2005, SSRS, SSIS, SSAS, BCP, DTS,, SQL Mail, SQL Server Management Studio, T-SQL, XML, MS Excel and MS Access, Visual Team Foundation Server, DTS, Crystal Reports, visual studio 2005/2008/ 2012, TFS 2008/2010.

Confidential, DOVER, NH

SQL BI developer

Responsibilities:

• Worked as a developer in creating complex stored procedures, triggers, functions, indexes, tables, views and other T-SQL code and SQL joins for applications.
• Involved in gathering business requirement from business users and prepared BI technical specifications.
• Experienced in installation, upgrade and configuration of Microsoft SQL Server and databases
• Developed, executed, documented, and maintained appropriate BI procedures.
• Collaborated with network operations, application developers and DBAs to enhance end user experience.
• Made changes to the existing Power BI Dashboard on a regular basis as per requests from Business.
• Published Power BI Desktop reports created in Report view to the Power BI service.
• Responsible for Scheduling jobs for weekly, daily data refresh on different Power BI reports.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Power BI.
• Responsible for managing BI environment, which includes Data Model, Data Sources, ETL tools, target Data warehouse, Data marts, OLAP analysis of data marts, data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modelling, Snow-Flake Modelling, fact, and dimensions tables using MS Analysis Services.
• Develop standardized reports using SQL Server Reporting Services (SSRS)
• Scheduling Jobs and Alerting using SQL Server Agent.
• Used Performance Monitor and SQL Profiler to optimize queries.

Environment: Business Intelligence Client Tools xi4.1/4.0, Business Intelligence Launch Pad and Information Design tool, Salesforce, Tableau, Dashboard 4.1 SP5, SQL Server, SSMS, SSIS, Oracle, T-SQL, Teradata, Windows 10. Microsoft Live Office. Data Warehouse.