SUMMARY

• Over 8 years of Experience in Data Warehousing and Business Intelligence applications design, development, Maintenance of Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analytical Services (SSAS) and Data Transformation Services (DTS).
• Expertise in developing application using .NET, C#, SQL Server.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Involved in Database Design, Data modeling, Development, Implementation, ETL and Reporting.
• Experience on performing Data loads to Dimension, Fact tables, Data warehouse, Data marts, and OLAP cubes.
• Expertise in MDX to create Named Sets, Named Members, Calculated Members and other calculations.
• Experience In developing financial models, BI reports, defined built key metrics, KPIs, scorecards chart rich reports using complex excel functions, advanced Macro, Microsoft Power BI stack - Power Pivot, DAX, Power View, power query, power Map, OLAP cubes, MDX and Tableau Visualization Tool.
• Worked on Facets on Membership module to validate the member eligibility and member enrollment for different plans.
• Performed the forward and backward data mapping between the fields in mainframe andFACETS.
• Tested the Inbound / Outbound Interfaces to Facets and populated XML files.
• Experience in managing Alerts, Operators and Scheduled Jobs through SQL Server Agent.
• Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services.
• Expertise in Merging data from various Heterogeneous Data sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in Extraction, Transformation, loading data from Oracle, DB2, AS400, Teradata, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS.
• Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages and Project Configuration wizard to configure SSIS Projects.
• Extensively Utilized Power BI - Power Pivot to develop data analysis prototype, and used Power View and Power Map to visualize reports and created reports and dashboards using Power BI.
• Worked on Data Analysis Expressions (DAX) for accessing data directly from tabular SSAS database.
• Expertise in designs and process flow on to how standardize Power BI Dashboards to meet the requirements of the business.
• Created many calculated columns and measures using DAX in Power BI based on report requirements.
• Developed reports and dashboards using Microsoft Power BI stack - Power Pivot, Power View, power query.
• Expertise in Creating reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI.
• Extensively used several types of visualization Like (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.
• Primarily worked on producing Monthly and Daily reports in Power BI.
• Created performance tuning methods on measures (DAX) for the reporting team using DAX Studio and SQL Profiler.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Expertise in creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down reports.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Expertise in upgrading or migrating Analysis Services.
• Proficient in building Star schema and Snow Flake schema depending on business requirements.
• Proficient in working with Multidimensional Expressions (MDX).
• Expertise in UDM and Data Mining objects.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Expertise in creating Cell Level Security, Perspectives, Partitions and Design Aggregations in cubes using SSAS.

TECHNICAL SKILLS

Operating Systems: Windows (All Versions)Unix, Linux, Mac

Databases: MS SQL Server 2014/2012/2008 R 2/2008/2005/2000 , MS Access, Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007 , MYSQL.

Database Design Tools and Data Modeling: Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools: Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools: SQL, SQL Server Integration Services (SSIS 2005/2008/2012 ), SQL Server Reporting Services (SSRS 2005/2008/2012 ) SQL Server Analytical Services (SSAS 2005/2008/2012 ), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI, Tableau.

Tools: /Database Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Languages: C, C++, HTML, XML/XSLT/.Net/C#,Core Java, Python,VB.NET

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

Sr. SQL/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Designed high level ETL/SSIS architecture for overall data transfer from the OLTP to Data warehouse with SSIS and prepared ETL/SSIS mapping processes and maintained the mapping documents.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Created SSIS packages for Dynamic ETL/SSIS flow to validate, extract, transform and load data into database using Lookup, Fuzzy Lookup, Derived Column, Conditional Split, Slowly Changing Dimension (SCD) to perform Data Scrubbing, including data validation checks during Staging, before loading the data into the Data warehouse.
• Involved in Data Extraction, Transforming and Loading (ETL) using SSIS, BCP, Bulk Insert, DTS, and XML between Oracle, DB2, and Access to MS SQL server database.
• Developed SSIS packages for File Transfer from one location to the other using FTP task.
• Involved in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Involved in creating jobs Alerts, Alerts, SQL Mail Agent, and Scheduling SSIS Packages using SQL Server Agent job.
• Worked on complete SSIS life cycle in creating SSIS packages, building, and executing the packages in both the environments
• Used VB.Net and C# script task to download the flat files from FTP to Shared Folder and Tracked Different Error scenarios and logging for SSIS.
• Used SSRS to Create Tabular, Matrix, and Drill down, Drill through reports, Summary Reports, and Parameterized Reports, Charts and graphs as per customer requirements.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Build regular ad-hoc reports using SSRS SQL Server Reporting Services with help of various tools such as Group by, Drill-down, Cascading, Summarized, Matrix, Map and Cross-join
• Created Advanced Reporting Services Programming Using the Reporting Services Web Service.
• Created Ad-Hoc Reporting with Report Builder and Programming Reporting Services.
• Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Conducted extensive analysis on migration and conversion of Provider and Member data, Group configurations, plan codes, benefit set-ups, fee schedules, provider pricing, capitation set-ups, etc from Legacy system (Amysis) to FACETS (Client Server based system).
• Performed the forward and backward data mapping between the fields in mainframe andFACETS.
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also, created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• Embedded Power BI reports on portal page and also managed access of reports and data for individual users using Roles.
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Utilized Power BI desktop to design real time dashboards and scorecards for analytical decision.
• Deployed reports and Power BI dashboards on the reports/SharePoint server; scheduled deployments with subscriptions.
• Migrated existing self-service reports and adhoc reports to Power BI.
• Managed coordination of reporting activities on development, business requirements gathering and migration of reporting files across different environments.
• Managed Power BI Portal - Data refreshes / User management and set up gateway data refresh.
• Published reports and dashboards designed in Power BI utilizing Power BIservices and shared it across through Microsoft Office 365.
• Implemented dashboards and scorecards with Power BI for executive management for data insights as per business requirements.
• Maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• To analyze performance, used: Calculation, KPI, Derived column and hierarchy. Also, created MDX Multidimensional Expressions scripts and built reports on top of cubes.
• The created cubes were analyzed using MDX and DAX. I also analyzed and modified data using Power Pivot, created pivot tables and charts for presentation and decision making purposes.
• Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service.

Environment: SQL Server 2014, Microsoft Visual Studio 2012, Windows 7, MS Office, Windows Server, Dax, SQL Server Integrated Services SSIS, SQL Server Analysis Services SSAS, SQL Server Reporting Services SSRS, SharePoint, Oracle 8, Tableau, Power pivot, Power view, Power BI, Python.

Confidential, Dover, NH

SQL Server /SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Extensively involved in high level design of OLTP and OLAP based Databases.
• Analyzed and designed an ETL Architecture to create aSSIS Package to replace the Dot Net application using Microsoft Visio.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created Complex ETL Packages using SSIS which upserts data from staging table to database tables.
• Used VB.Net and C# script task to download the flat files from FTP to Shared Folder.
• Designed, Created and Tested SSISpackages for data transformation, cleansing, caching, aggregation, staging, backup, update and transfer in support for the main Project.
• Worked with SSISVariables, Scripting, event-handlers, Package configurations and deploymentto production.
• DevelopedSSIS Packages to Consolidate date from various data Sources and Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs) and converted to SQL reporting.
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups
• Implemented Custom Logging, Auditing and custom Email notifications using SSIS.
• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, User Defined Functions, Triggers and Rules.
• Created sophisticated SQL Server database to responsively handle complex queries (T-SQL, DTS, triggers, stored procedures, functions, and optimization) and .NET data access components.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Wrote T-SQL Stored Procedures, Inline Queries for SSRS Reports Shared Dataset and Embedded Dataset with Query Parameters. Deployed and Managed SSRS Reports.
• Designed and developed the reports according to the requirements using Tableau and Power Map.
• Extensively worked on reports using SQL Server Reporting Services (SSRS 2008, 2012) and creating various types of reports like drill down, Parameterized, Cascading, Table, Matrix, Chart Sub Reports and Dashboards using Sparkline, Gauge and Bars etc.
• Scheduled the reports to run on daily, weekly basis in the report manager.Create reports in Power BIpreview portal utilizing the SSAS Tabular via Analysis connector.
• Provided production support on the existing Power BI Dashboards and other ETL processes to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users to look at them.
• Involved in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).

Environment: MS Visio 2008, SQL Server 2012, Microsoft Visual Studio 2010, Windows 7, SQL Server Integrated Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Oracle 8, Tableau, Power pivot, Power view, Power BI.

Confidential, Grand Haven MI

SQL BI DEVELOPER

Responsibilities:

• Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP with the help of SSIS Business Intelligence Development Studio.
• Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Script Task, File System Task, send mail task, For loop container, For each loop container and Sequence container etc. to generate underlying data for the reports and to export cleaned data heterogeneous source to data warehouse
• Worked on VB.Net and C# script task to manipulate server side data and Tracked Different Error scenarios and logging for SSIS.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Create SSIS packages for data transformation, cleansing, caching, aggregation, staging, and transfer.
• Scheduled SSIS packages by creating the corresponding job tasks.
• Created complex ETL Strategies to populate the data warehouse/data-mart facts and dimensions.
• Created Ad-Hoc reports as per client requirement using stored procedure.
• Assisted in writing and optimizing complex SQL queries using SQL Stored Procedures and Triggers also involved in writing T-SQL programming to implement Stored Procedures, Views and Functions for different tasks.
• Created weekly and monthly reports as per requirement using SSRS and Scheduled Reports to be delivered to User on demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
• Involved in handling parameterized reports and drilldown reports in SSRS 2005/2008
• Expertise in using the Facets DM Reader to access the Facets data tables and loaded the fields into them
• Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2008 with .NET applications.
• Developed Report Models for building Ad hoc reports using Crystal Reports. Developed optimal stored procedures and queries to create data sets for reports.
• Designed and implemented stylish report layouts. Generated Reports using Global Variables, Expressions and Functions for the reports.

Environment: T-SQL, MS SQL Server2012, SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Visual Source Safe (VSS 8.0), Microsoft visual studio 2010 Shell.

Confidential, Cypress CA

SQL SERVER/SSIS/SSRS DEVELOPER

Responsibilities:

• Gathered business requirements, defined and designed the data sources, data flows, data quality analysis, worked in conjunction with the data warehouse architect on the development of logical data models.
• Created various Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
• Involved in designing the physical databases model on SQL Server RDBMS using different Data Definition and Data Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity in development database for Warehouse system.
• Performance tuning of Queries and Stored Procedures.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Created SSIS process design architecting the flow of data from various sources to target.
• Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, For-Each loop container, Merge Join and Union all.
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS.
• Extensively imported data from various sources such as MS Excel and MS Access using Import Export Wizard and using SSIS.
• Created ETL packages using SSIS to move data from various heterogeneous data sources.
• Created logs for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Implemented error handling and roll back process in ETL load.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• 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.
• Used XML and environmental variables in the package configuration for Deploying SSIS packages.
• Created Cross-Tabs, Drill-down and Sub-Reports using SSRS. Deployed RDLs to Report Server.
• Created Jobs Performance report that queries system tables to track the duration of each job and weekly-average duration using SSRS.
• Created reports in SSRS using different types of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.

Environment: Windows Server 2007/2003, MS SQL Server 2005/2008 R2/2012, ASP .NET, XML,SSIS, SSRS, SSAS, Business Intelligence Studio, Visual Studio 2008/2005.

Confidential

Jr. SQL SERVER/SSIS Developer

Responsibilities:

• Extensive participation in logical and physical database design and normalizing the database to accommodate possible changes in OLTP & created data flow diagrams and enforced all referential integrity constraints.
• Created Stored Procedures and functions.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the databases.
• Created new database objects like tables, synonyms, Packages, Triggers, Indexes and Views using T-SQL in Development, Test and Production environment for SQL Server.
• Created complex stored procedures and functions to support efficient data storage and manipulation as well as database Replication.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Designed and implemented data access stored procedures and Triggers for automating tasks.
• Implemented constraints on tables and performed database tuning and performance planning.
• Involved in performance tuning using indexing (Clustered Index, Non Clustered index) tables.
• Transforming and validating data using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for unstructured and redundant data.
• Created SSIS packages for transferring the data from different systems such as SQL/Oracle server, Flat Files, CSV Files and xml files.
• Involved in Job scheduling and alerts.

Environment: Microsoft SQL Server 2005/2008, Business Intelligence Development Studio (BIDS) 2008, SSIS, SSRS, Windows Server 2008/2003, SQL Profiler, Tuning Advisor, DTS, Query Analyzer, Enterprise Manager.