SUMMARY

• Over 7+ years of extensive experience as a SQL Server BI Developer (SSIS/SSRS/SSAS). Specialize in creating Store Procedures/T - SQL Coding, Performance and Tuning, User Defined Functions and Physical and Logical Database Design.
• Expert in MS SQL Server Suite of Products i.e. SSIS (Integration Services), SSRS (Reporting Services), SSAS (Analysis Services) on various business domains like Federal, Health Care and Pharmacy. Excel under pressure in deadline driven environment with superior interpersonal communication and technical documentation skills.
• Experienced in all phases of Software Development Life Cycle(SDLC), starting from business requirement gathering and analysis to testing and deployment.
• Good experience in Information Technology field as a SQL server Developer with strong expertise in SQL server development, designing Stored Procedures/Transact-SQL coding.
• Hands on Experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2016/2014/2012 /2008/2005.
• Expert in creating complex Stored Procedures, User Defined Functions, and effective Triggers to facilitate efficient data manipulation and data integrity.
• Experienced in strategically implementing the indexes such as Clustered index, Non-clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Experience in Migrating from SQL Server 2005 to SQL Server 2008 and SQL Server 2008 to SQL Server 2014.
• Good knowledge on Revenue Management and Billing(RMS) application
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues.
• Very well understood Epic Systems software and generated reports to display data on patient care, registration, scheduling, and billing systems.
• Extensive experience in creating complex SSIS packages.
• Extensive experience in using various tasks, containers, sources, transformations and destination in SSIS tool while transferring the data from various sources systems into the destination.
• Transformed data from various data sources to SQL Server using BCP, DTS and SSIS.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Involved in Performance Tuning & Deployment of SSIS packages.
• Proficient in creating different Package Configurations such as SQL Server, XML configuration and Parent package variable.
• Implemented different Logging in SSIS packages to log events during the run time.
• Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schema, Fact and Dimensional tables, one to many relationships, many to many relationships and DW concepts.
• Performed different types of loads Incremental Load, Optimized Load & Binary Load.
• Experience in implementing various levels of File/Document and Data level Security for SSRS.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2008.
• Experience with adhoc reporting, Parameterized, Custom Reporting using SSRS for daily reports and SSAS projects.
• Experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Highly experienced with whole cycle of DTS/SQL server integration services (SSIS 2008/2012) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience on Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Expertise in generating reports using SQL Server Reporting Services and MSExcel spreadsheets and Power Pivot.
• Expert on designing Enterprise reports using SQL Server Reporting Services generated drill down reports, parameterized reports, linked reports, sub reports, ad-hoc reports, matrix dynamics and filters, charts in SSRS.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using Power BI.
• Created Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Good knowledge of Data Marts, Operational Data Store (ODS), OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for FACT and Dimensions Tables using Analysis Services.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports.
• Used Team Foundation Server (TFS) for assigning & integration of tasks, defect management and source & version control.
• Used Team Foundation Server for sprint planning, tracking bugs and work items and as a version control.
• 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.
• Expertise with Agile & waterfall methodology.
• Involved in performing Unit Test, Regression Test, Functional Test, integration Test, Stored Procedure Performance Test, on Test server and preparing combined Developer Training document along with waterfall, Spiral and Agile methods with full SDLC (Software Development Life Cycle).

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Dynamic SQL, MDX, C#, ASP (.NET), XML, HTML, Shell Scripting

Databases: MS SQL Server 2016/2014/2012 , 2008R2, 2008 Oracle.

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio, Power BI.

Database Design Tools and Data Modeling: MS Visio, ERWIN, 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).

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, DTS, Business Intelligence Development Studio (BIDS), Tableau, Power Pivot, Microsoft Office, Excel Power Pivot, Power BI.

Operating Systems: Windows 8/7/Vista/XP, UNIX.

PROFESSIONAL EXPERIENCE

Confidential - Louisville, KY

Sr. SQL /BI Developer

Responsibilities:

• Participated in Business Processes with the Business Analyst/Client delivery to understand the requirement and Reviewed High Level Design Documents, Functional Specifications documents with the Technical Manager.
• Optimized Stored Procedures and long running queries using query-optimization techniques.
• Participated in Design/Discussions of ETL flow from different source systems into Datawarehouse (DWH) model (Start Schema).
• Created Source to Target (STT) mapping document for DWH ETL process.
• Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules.
• Migrated SSIS packages from SQL Server 2008 R2 to SQL Server 2012 as SSIS packages.
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Provided At-The-Elbow support for Providers, Nurses and Clinical Staff for Epic implementation in Ambulatory Medicine Clinics.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created complex stored procedures to perform Index maintenance, data profiling, metadata search, critical staging procedures for loading data marts and reporting database.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Created SSIS packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Immense knowledge of Coding, Care Management, Utilization Management, Readmissions, Post-Acute Placement, population and Revenue Management cycle.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB command, conditional split, lookup, aggregator, multicast and derived column.
• Experience in Designing Data Mart and Data Warehouse using Star Schema and Snowflake Schema and OLAP Technology Analysis Services and Cognos using SQL Server 2008.
• Experience in integrating different database environments like Sybase SQL Server, Oracle SQL Server etc.
• Primary hands-on duties include MS Active Directory management, SQL DBA activities, Exchange management, GEMMS EMR management, Intertel telephone system management, Network Security management, application and report development and support.
• Deployed SSIS package into production and used package configuration to export various package properties to make package environment independent.
• Implemented event handlers and error handling in SSIS packages and notified process results to various user communities.
• Created the design documents for the entire project including table structures and design logic of stored procedures, packages and Reports.
• Created numerous efficient stored procedures to perform data cleansing and loading task when data is loaded into staging area.
• Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2008 for faster execution and developed database structures.
• Responsible for development of complex reports by using SSRS. Developed various Cross Tab Reports, Drill down, Sub Reports, and Parameter Reports
• Developed heavy formatted, complex formula reports, reports with advanced features like conditional formatting, and multiple grouping reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports Including current project status.
• Created perspectives in SSAS and configured security levels for the Cubes.

Environment: SQL Server 2012/2014, Power BI, Epic,SSIS/SSRS/SSAS 2010, Visual Studio, Team Foundation Server (TFS).

Confidential, Fort Worth, TX

Sr. BI Developer With SSIS/SSRS/SSAS

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications detailing new features and enhancements to existing business functionality.
• Created logical/physical models and conceptual models using ERwin and VISIO for Reporting.
• Participated in JAD sessions to resolve critical issues.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s and redesigning schemas.
• Experience in integrating different database environments like Sybase SQL Server, Oracle SQL Server etc.
• Involved in integration/system testing and backup/restore testing for all components.
• Daily routine Developer/DBA tasks like handling user’s permissions, monitoring Blocking, Deadlocks, Long running jobs, and space issues on Production and Semi-Production servers and handling maintenance jobs.
• Worked and involved on database pre-deployment and deployment DBA activities on production servers.
• Developed various operational Drill-through and Drill-down reports using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Successfully completed assigned courses for EPIC and PostgreSQL.
• Migrated old data from MS SQL Server 2008 to MS SQL Server 2012 using SSIS Packages in Business Intelligence Development Studio.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Implemented new features that came up in SQL 2012/2014 like Column Store Indexes, Pagination, OFFSET and SEQUENCE, setting up permissions and roles for users at both database and server level.
• Worked intensively in query execution plans, sql profilers and did query optimization.
• Integrated data from multiple sources and stored them in Operational Data Stores (ODS) to pass it further down to Warehouse for reporting purposes.
• Worked on both Normalization and De-normalization approach and implemented them appropriately for Warehouses and Marts.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Created various weekly and monthly reports showing detailed information in SSRS.

Environment: SQL Server 2012/2014/2016 , Power BI, ASP.Net, MS SQL Server 2008/2012, TSQL, Visual Studio, SharePoint 2010, Team Foundation Server (TFS), Tableau, SSIS, SSRS, Erwin.

Confidential, Eden Prairie, MN

Sr. BI Developer with SSIS/SSRS/SSAS

Responsibilities:

• Created databases and schema objects including tables, indexes and appliedconstraints,connected various applications to the database and writtenfunctions, stored procedures and triggers.
• Analyzed and designed software and database solutions.
• Performed daily tasks including backup and restore by using SQL Server tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS).
• Developed a High-level dashboard using SSRS.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Involved in creating report models and applying row level security filters for report model.
• Built SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files, legacy systems and loading into SQL server.
• Created Jobs, Alerts, SQL Server Mail Agent, and schedule using DTS/SSIS Packages.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Configured Reporting Services in SQL Server 2008.
• Participated Databases Architecture and data modeling design.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Interacting with the users and troubleshooting the problems involved with the development of stored Procedures, triggers and problems related to the privileges.
• Used VS Team Foundation Server (TFS) for version control and actively involved in developing Project Plans.

Environment: SQL Server 2008/2012, Reporting Services (SSRS), PL/SQL, SQL Plus, Integration Services (SSIS), Analysis Services (SSAS), Team Foundation Server (TFS, T-SQL, MDX, Windows, XML, MS Excel.

Confidential

SQL BI Developer

Responsibilities:

• Helped conduct meetings with the end users and performed interviews to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
• Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
• Worked with the developers to understand the ERD (Entity Relationship Diagram) and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Developed various operational, drill-through and drill-down reports using SSRS.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
• Experienced in writing Parameterized Queries for generating Tabular reports, formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS.
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
• Performing Replication (snapshot and transactional).
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Created calculated measures and dimension members.

Environment: MS SQL Server 2005/2008/2012 , TSQL, ASP.Net, Visual Studio 2008, SSRS, SSIS, Erwin.