SUMMARY

• Highly Skilled Professional with around7 yearsof experience in Software Design, Development, Analysis, Testing, Data Warehouse and Business Intelligence tools.
• Proficient in ETL (Extract - Transform - Load) using DTS (Data Transformation Services), SQL Server Integration Services 2008 (SSIS), SQL Server Integration Services 2012 (SSIS).
• Exceptional background in analysis, design, development, customization, and implementation and testing of software applications and products
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP
• Constructed cubes based on data volumes mostly adhering to Star Schema
• Experienced in various RDMS concepts such as Normalization, Managing RDB’s, Performance tuning, T-SQL programming.
• Analyzing, writing, developing and coding software applications for Disease Management Identification System in conjure with APS’s Healthcare Specialists.
• Played a critical part in implementing the QNXT processes at Hill Physicians.
• Experience in High Level Design of ETL Packages for integrating large scale data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations.
• Defined attribute properties in Parent Child Analytic Dimensions.
• Adept at SSIS (Integration Service) and Object Oriented Development(C#) for design, constructing, and deployment.
• Proficient in Data migration between homogeneous/heterogeneous systems and SQL Server using Integration Service (SSIS), BULK INSERT, DTS Import/Export utility, and Bulk Copy Program (BCP).
• Specialized in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, Matrix Reports, Charts using SQL Server Reporting Services.
• Created email subscriptions for data driven reports by using Report Manager and implemented a background process to manage and track the subscriptions.
• Used Report Manager to assign roles, permissions and to create report schedules.
• Experience with Ad-Hoc reporting using Report Builder in SSRS for daily reports.
• Experience in using variables, expressions and functions for the reports.
• Experienced in managing Alerts, Operators and Jobs using Active Batch Enterprise Scheduler with Shell Scripting.
• Experience in writing complex SQL queries involving multiple table inner and outer joins, temporary tables, table variables.
• Defined Indexes on Tables to boost the performance for DML tasks.
• Strong technical knowledge in Troubleshooting and Performance tuning.
• Experience in creating complex stored procedures, useful functions to facilitate efficient data manipulation and consistent data storage in UNIX environments.
• Using Power Pivot and Performance Point, have created our own data models and dashboards from various data sources, modeled and structured precisely to fit client needs.
• Have worked with Power BI to create many structured reports, charts and data mining models using features included in the latest Oct 2016 update.
• Experience with formatting and filtering data, creating calculated fields, defining key performance indicators (KPIs) to use in PivotTables and creating user-defined hierarchies to use throughout a workbook using Power BI Microsoft and Power View Visualization tools.
• Experience with writing calculations by creating advanced formulas that use the Data Analysis Expressions (DAX) expression language using Microsoft Visualization tools.
• Experience of working with huge databases (size>5 M rows).
• Assisted in testing and validating SQL queries and SSIS packages in development and QA environment for several ETL design teams.
• Handled high level escalates of issues and assessed the risks.
• Excellent communication and analytical skills, good knowledge of business requirements in various domains.
• Experience working with remote teams and conducting web-meetings.

TECHNICAL SKILLS

Hardware: Dell Servers, HP Servers

Database: SQL Server 2000/2005/2008/2012/2016 , MS Access 2003/2007, Oracle 9i

Operating Systems: Windows XP/2000/2003/Win 7

Programming Languages: T-SQL, HTML, C#, VB.Net, MDX, DMX

BI Suite: SSRS, Report Builder 3.0

ETL TOOLS: SSIS, DTS, Visual Studio Shell

Analytic Tools: SSAS, Tableau, Power BI, Performance Point

Database Tools: SSMS, MS Visual Studio, Toad for SQL Server 4.6

Modeling Tools: Erwin (4x, 7x)

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Agile BI Scrum Master / Developer

Responsibilities:

• Planning out the Bi-weekly sprints andrequirement gathering sessions for the team.
• Workflow design and resource assignments for the backlog items.
• Worked with implementing package framework and monitoring capability using BI xpress.
• Worked on Press Ganey patient experience ratings to design a payment process.
• Involved in understanding the functional requirements, translation of technical documents, data dictionary mapping and business understanding from the business analysts.
• Designed some complex charts and patient summary reports using Performance Point, Power View and the latest updates in Power BI.
• Designed & developed ETL procedures and Data dumps involving data analysis, data validations and data migrations
• Responsible for managing and processing all the cubes in PROD and keeping them in sync with their backups.
• Developed Complex Packages to load data into Stage, ODS and DataWare Housesystems
• Have built and maintained numerous cubes using SSAS and have created reports based off them using complex MDX queries.
• Built cubes with calculated measures using MDX.
• Created a logging process to monitor the SSRS report subscriptions.
• Involved in automating SSIS Packages using SQL Server Agent Jobs, Window Scheduleretc.
• Involved inMonitoring andtroubleshooting complex packages by using Data Viewers Grids
• Have configured several reports to run and process the parameters dynamically with report path.
• Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters
• Developed and designed workflows using TSQL queries, User Defined Functions, store procedures and Views, triggers.
• Written custom Javascript code to pass parameters overs to drill-through reports within the URL.
• Designed web pages and libraries using Sharepoint 2013 to house the Dashboards in the integrated mode.
• Created Large Number of Report Models for users to choose their own design.
• Involved in code reviews, source control and auditing procedures.

Environment: SQL Server 2012/2016, Sharepoint 2013, MS BIDS, SSRS, SSIS, SSAS, Report Builder 3.0, BI xpress, Tableau, Power BI, Performance Point, Power view, MDS.

Confidential, Tumwater, WA

SQL Server / SSIS BI Developer

Responsibilities:

• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Developed Dynamic packages using SSIS (dynamic Package Configuration of type SQL Server table) and Implemented Incremental Data Loading.
• Worked on the process info retrieval for ACH bank electronic payments and transfers.
• Uploaded Element classes for the company Rochade - Dictionary.
• Responsible for updating Team Foundation Server source control.
• Setting up aliases with SQL Configuration Manager for team members and managing Production server permissions accordingly.
• Worked with User Interface (UI) Java developers for data sorting, row counting and data view layouts.
• Developed Query for generating Drill Down and Drill Through Reports in SSRS 2008(R2).
• Involved in Optimization and performance reviewing of queries and stored procedures using SQL execution plan.
• Proactively monitoring the performance of SQL Server databases, troubleshooting system issues and monitored scheduled jobs.
• Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages
• Collaborated with Business, gathered requirements and built reporting solutions such as relational database reports, dashboards, and scorecards.
• Constructed T-SQL Queries, Stored Procedures, Indexes, Functions and, Views to support efficient data storage and manipulation.
• Created appropriate Triggers to assist efficient data manipulation and data consistency
• Migrated DTS Packages of SQL Server 2008 to SQL Server 2012 as per business requirement
• Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.

Environment: SQL Server 2012/2008 R2, Microsoft Visual Studio, MS BIDS, SSRS, SSIS, Management Studio 2005/2008, Active Directory and Windows XP platform, DOT NET 2.0/3.5 Framework, MS Office 2007.

Confidential, Brookfield, WI

SQL Server BI Consultant

Responsibilities:

• Create complex technical solutions and design utilizing Visual Studio ETL tool and other technologies(MS-DTS,VB,C#)
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Provide technical guidance and direction for each ETL(Extract, Transform, and Load) project design and development team and ensure documentation is produced using defined methodologies.
• Created technical solutions and designs utilizing ETL tool (SSIS, Informatica) and other technologies.
• Worked on ETL (Extract, Transform, and Load) project design and development of DMID and TGA automations.
• Prepared documentation as per APS Health Care standards.
• Involved in creating calculated members, named set, advanced KPI’S for theSSAScubes.
• Developed/Monitored ETL packages with different data sources (SQL Server, Flat Files, Excel files, etc) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Worked with implementing ICD-9 standards to all the data processing and tasks handled.
• Developed Scheduled Jobs to automate the Disease Management Identification (DMID) and Treatment Gap Analysis (TGA) Process using SSIS Packages.
• Implemented Event Handlers and Error Handling in SSIS packages to notify process results to various user communities.
• Defined an Error handling system in the SSIS package to identify data issues with member claims.
• Expertise in building SSRS reports from various heterogeneous sources like SQL Server, Oracle.
• Experience in creating Tablix Reports, Parameterized Reports, Drill down, Sub-reports using SQL Server Reporting Services 2008.
• Experience in creating Ad hoc reports Using Report Builder
• Created temporary tables and table variables while creating complex queries in SQL Server 2005/2008.
• Defined Indexes, Views, Constraints and Triggers to implement business rules.
• Wrote complex SQL queries using table joins (inner and outer), temporary tables, and table variables.
• Using Power Pivot, we created our own data model from various data sources, modeled and structured precisely to fit client needs.
• Experience with formatting and filtering data, creating calculated fields, defining key performance indicators (KPIs) to use in PivotTables and creating user-defined hierarchies to use throughout a workbook.
• Experience with writing calculations by creating advanced formulas that use the Data Analysis Expressions (DAX) expression language..
• Monitoring execution plans to enhance the performance of the queries.
• Developed indexed views, complex stored procedures to facilitate efficient data manipulation and consistent data storage.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, BIDS,SSMS,SSIS,SSRS, T-SQL, Active Batch V7.0, Windows Server 2003, C#, Power View, Apache HIVE.

Confidential, New York, NY

SQL Server / Data Warehouse Developer

Responsibilities:

• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers and created documentation for the same.
• Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX querying.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from XML Files and SQL Server 2005 to SQL Server 2008 by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
• Generated Sub-Reports, Cross-tab, Conditional, Crystal reports, Drill down reports, Drill through reports and Parameterized reports using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard.
• Responsible for Monitoring, Tuning Report performance and Building tools in Legacy Mainframes.
• Created various database objects like stored procedures, functions, tables, views.
• Configured the report viewing security for various users at various levels using Report Manager.

Environment: MS SQL Server 2012, T-SQL, SSIS 2008, MySQL, T-SQL, SSRS 2008, Core Java, T-SQL Advanced Server, SSMS, SSAS Data Mining, ERwin v7.2, ASP.Net, C#, SharePoint

Confidential

SQL ETL Programmer

Responsibilities:

• Worked on various domains such as electronic security, communications, healthcare, networking and e-governance with database size exceeding 1 million rows.
• Interacted with business analysts to understand the business requirements.
• Designed and developed ETL Packages for integrating large scale data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations using SSIS(SQL Server Integration Services)
• Created logical and physical database design using Erwin.
• Wrote complex T-SQL queries for data extraction.
• Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Wrote DTS packages to move data between production, staging and QA environment.
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
• Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.
• Involved in the SQL Query Performance Tuning.

Environment: SQL Server 2000/2005, Windows NT, Excel 2000, Access 2000, Query Analyzer, Oracle, Enterprise Manager, Legacy Mainframe Software, Erwin, Data Transformation Services (DTS).