SKILLS:

Data Analysis, Data Migration, Data Transformation database, Database Modeling, Database Design, Database Systems db2

DDL, Microsoft Access, MS Access, MS SQL Server, Microsoft SQL Server

MS SQL Server 2008, SQL Server, SQL Server 2005, SQL Server 2008, SQL Server 2008 R2, SQL Server 2012

ODBC, OLE DB, OLTP, Oracle, PL/SQL, Relational Database, SQL, SQL Queries

Stored Procedure, Stored Procedures, Microsoft Project, MS Project, Microsoft SQL Server Reporting Services, MS SQL Server Reporting Services, SQL Server Reporting Services, Microsoft SSRS, SSRS

Microstrategy, OLAP, Pentaho, Tableau Software, Tableau, T - SQL, .Net, Visual Studio, Analysis Services, C#, Client/Server, Coding, HTML, PHP, Python

Reporting Tools, System Development, VB.NET, Visio, XML, Data Feed, Data Sources

ETL, Microsoft SQL Server Analysis Services, SQL Server Analysis Services, Online Analytical Processing, Power Bi

EXPERIENCE:

Confidential, St. Louis, MO

Power BI/SQL/SSIS/SSRS/Azure Developer

Responsibilities:

• Gathered requirement and designed technical document to implement the application.
• Written complex queries, created Stored Procedures and user defined functions for reports.
• Redesigned and tuned stored procedures, triggers, tables, UDFs, views, recursive CTEs, indexes and was successfully able to increase the performance of the queries.
• Created Test script for Prod fix, UAT and Production and developed Unit Test Plans Documentation.
• Executed SQL conversion pre - validation and post-validation scripts to avoid data loss.
• Created business reports by joining multiple tables from multiples database using complex SQL queries.
• Assisted the team in building a brand-new data warehouse for de-identifying data project for all PHI and HIPAA regulated data.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
• Used various Control Flow tasks in SSIS like For Each Loop Containers, Sequence container etc. and data flow tasks like derived column, lookup, Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user groups.
• Creating and managing Event Handlers, Package Configurations, Logging, Checkpoints and User Defined Variables for SSIS Packages.
• Deployed SSIS packages with minimal changes using XML configuration file. Actively involved in creating SSIS packages to transform data from OLTP database to a data warehouse.
• Responsible for debugging, troubleshooting, and tuning PL/SQL stored procedures and functions and complex SQL.
• Identified the fact and dimension tables from the SQL server based on the requirements.
• Designed and written the queries in the query builder for retrieving the data. Implemented Data blending with multiple data sources on a single worksheet for data analysis.
• Extensively used merge command as alternative to small SSIS packages in dimension and fact load.
• Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export data, bulk insert and BCP utilities.
• Understanding and transformation of various existing SSRS reports from ICD 9 to ICD 10 codes
• Preparing, reviewing, and submitting health claims to state Medicaid agencies.
• Developed several reports using Sub reports, Cross Tab, Drill down and Drill through, Matrix, tabular reports and Gauge reports using KPI's.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Integrated custom visuals based on business requirements using Power BI desktop
• Created actions to navigate to various pages as per the user wish.

Confidential

SQL/Power BI/MSBI Developer

Responsibilities:

• Interacting with users to gather Business requirements and Analyzing, Designing and Developing the Data feed and Reporting systems.
• Developed complex programs in T - SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
• Extensively worked on Views, cursors, CTE's, schemas, permissions, and performance issues with client/server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE's for complex queries involving multiple tables from different databases.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using SSIS 2012/2008.
• Deployed SSIS packages and Scheduled Jobs.
• Involved in Analyzing and integrating the data.
• Created views to restrict access to data in a table for security.
• Expert in extracting data using SSIS from OLTP to OLAP. Performed Bulk data migration using DTS and SSIS from flat files.
• Worked with integration services for transferring and reviewing data from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data).
• Developed Incremental Load using Lookup in SSDT visual studio.
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SSIS packages to Export data from text file to SQL Server Database.
• Worked on transformations such as Checksum in SSIS where all the rows in table need to compare for an update.
• Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing. Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis OBIEE. Designed and deployed reports with Drill Down, Drill Through and Drop-Down menu option and parameterized and Linked reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly, and quarterly reports including status.
• Delivered BI reporting tools in Power BI, Reporting services (SSRS), Tableau and MicroStrategy Developed custom calculated measures using Data Analysis Expression (DAX) language in Power BI.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Mapped data between external databases and Crystal Reports.
• Developed various operational, drill-through and drill-down reports using SSRS 2012/2008. Generated Tableau Dashboards by using filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Created Developer's Documentation and User's Manual.

Environment: Windows 2003 Server, SSIS, SSRS, SSAS, Pentaho SQL Server 2008R2, MS Access, T-SQL, Crystal

Confidential

T-SQL /SSIS/SSRS/Tableau Developer

Responsibilities:

• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming, and loading data into Data Warehouse. Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008 R2.
• Experience in creating Jobs, Alerts, SQL Server Mail Agent, and schedule SSIS Packages. Used Event Handlers for Exception Handling in SSIS packages.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using ad hoc reporting to be used by the clients and advisors. Identified and worked with multi - value parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time.
• Created many complex Stored Procedures and used them in SSRS Reports directly to generate reports on the fly. Created parameterized reports, Drill down and Drill through reports using SSRS.
• Generated ad-hoc reports using MS Reporting services and Crystal reports.
• Worked on formatting SSRS Reports using the Global variables and expressions.
• Scheduled, maintained, and supported the distribution and access to reports at Server.
• Developed story telling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Granted and revoked privileges to users.
• Created various views in Tableau (Bar charts, Line charts, scatter plot, Heat Maps).

Environment: MS SQL Server 2008/2005, SQL Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), T-SQL, Visual Studio 2008, Windows 2007 Enterprise, MS Office 2007.

Confidential

MSBI Developer

Responsibilities:

• Participated in the installation of SQL Server. Installed SQL Server Enterprise manger tools using SQL Server Setup Program.
• Converted the User Requirements into Business Requirements, Functional Requirements and Technical Requirement.
• Also, created Business Process Models from the requirement specifications.
• Created various complex SQL Queries, Stored Procedures, CLR Procedures, Views, Cursors and User defined Functions to implement the business logic.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Created Temp tables in stored procedure for different applications.
• Created SQL functions.
• Created tables, indexes and constraints.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Developed and maintained relational databases.
• Developed Reports to generate daily, monthly, quarterly, yearly reports using Crystal Reports.
• Generating ad - hoc reports using MS-Excel and Crystal Reports.
• Created index to increase performance of stored procedures.
• Designed and developed various complex reports.
• Created views to restrict access to data in a table for security.
• Collaborated with end users and other related departments to meet the client's expectations and business requirements.
• Resolved end user reporting problems through collaboration with IT.

Environment: SQL Server 2012/2008R2 Enterprise Edition, MSBI Suite (SSAS, SSIS, SSRS), XML, MS PowerPoint, MS Project, MS Access 2008, Erwin, OLAP, OLTP, Windows Server 2008, Oracle