SUMMARY

• 8+ years of experience in Data modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database Systems using MS SQL Server.
• Experience in Development, Implementation, ETL and Reporting in SQL Server 2012/2008.
• Extensive experience in Database development for both OLTP (Batch Processing, Online Processing) & OLAP Systems (SSRS, SSIS, SSAS) using MSSQL Server 2000/2005/2008
• Expert in providing Enterprise Reporting solutions using SSRS 2000/2005/2008 , Crystal Reports Suite (9/10)
• Extensive ETL experience using DTS/SSIS for Data Extractions, transformations and Loads
• Utilized Integration Services (SSIS) to produce a Data Mapping and Data Mart for reporting.
• Developed & supported various mission critical Client Server applications by handling database requests for various application development teams involving complex business logic, functionality.
• Involved in Designing numerous DB Objects like Tables, Constraints (Primary Key, Foreign Key, Unique), Indexes, Defaults, rules.
• Extensive usage of Database diagrams and data modeling tools like Erwin in creating Logical and Physical models, establishing Entity Relations and forward/Reverse engineer to database systems
• Thorough knowledge of addressing Performance Issues and Involved in query tuning, Index tuning, Data Profiling and other database related activities
• Expertise in Enterprise Reporting in generating reports using linked reports, sub reports and filters, charts in SQL server reporting services.
• Experience in Integrating SQL Server Reporting Services with Microsoft Office Share Point Server (MOSS).
• Extensive knowledge in ETL Process & Progressive knowledge in using DTS/SSIS utilities
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Proficient in using SQL Server Integration Services (SSIS) to build Data Integration and Workflow Solutions, Extract, Transform and Load (ETL) solutions for Data warehousing applications.
• Hands on developing Dimensions, KPI’s, Calculated Columns, Hierarches and processing Cubes using SSAS.
• Having experience in development of Tableau dashboards, and user reports.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and strong analytical skills.
• Self-motivated, the ability of critical thinking, good at analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

TECHNICAL SKILLS

ETL: MS Visual Studio 2010, Business Intelligence Studio 2008/2010, SQL Server Integration Services (SSIS) 2008/2012/2016 , SSRS/ SSAS, Power BI and Power Pivot, ADF, ADLA.

RDBMS: SQL Server R2/2012,2015 SSIS, SSRS;

Programming Languages: C#, Python, T-SQL, SAS, DAX, MDX;

Tools: Power BI, Visual Studio 2008/2010/2012 , SSMS, Visio, Tableau, SQL Server Agent, TFS, Excel (Power pivot in Excel), MS Access, MATLAB/Simulink;

OS: Windows 2003/XP and Windows 7,8,10, Mac, Linux;

PROFESSIONAL EXPERIENCE

Confidential - Auburn Hills, MI

MSBI Developer/ Production Support

Responsibilities:

• Optimizing the performance of queries with modifications in T-SQL queries, removing-necessary columns, and eliminate redundant and inconsistent data.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view.
• Built cubes for production application, Partitioned Cubes to decrease the processing time and increase the performance of the queries running on front end application using SSAS.
• Created/Updated database objects like tables, views, stored procedures, function, packages. Designed MS SSIS Packages to extract data from various OLTP sources to MS SQL Server.
• Implemented different Slowly Changing Dimension methodologies to maintain and update historical data corresponding to Dimension tables in the Data warehouse. Used SQL Server Profiler to trace the slow running queries and the server activity.
• Improved the performance of SSRS reports by tuning the Stored Procedures and T-SQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS.
• Extensively worked with SQL Server Integration services (SSIS) tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Managing and enhancing internal and external website for the company with .net technology. Working with Marketing department to improve external and internal website and posting latest updates.
• Managing company's video conference system and arranging video and GoTo meeting setups for HR department. Helping finance and accounting department with crystal report's enhancement and resolving issue with reports.
• Working with other departments to support different needs and help them resolve day to day issues with software and reports.

Environment: MS SQL Server, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Visual Studio, MATLAB/Simulink, T-SQL, MS Excel, TFS.

Confidential, St. Louis, MO

SSRS/SSIS Developer

Responsibilities:

• Responsible for leading the team and client interaction and requirement gathering.
• Working with multiple Health plan analytics team to identify process improvement areas/automation.
• Successfully handling Corporate Data Analyst role by supporting multiple Health plans.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports using SSRS.
• Created Clustered index and Non-clustered for increasing performance.
• Created Views and Indexed Views for the Performance Tuning
• Used various transformations in SSIS like Lookup, Fuzzy grouping and Row Count Transformations.
• Developing and maintain MS SQL SSIS packages and schedule those from SQL Server Agent.
• Developing reports on SSRS on SQL Server (2012/2014). Broad Experience and understanding of SSAS, OLAP cube and Architecture.
• Performance tuning on ETL workflows, database objects like procedures, complex queries.
• In depth analysis on data issues to address user queries.
• Expertise in writing complex DAX functions in Power BI and Power Pivot.
• Created live Dashboards and reports using Power BI and published.

Environment: MS SQL 2012/2015, SSRS, SSIS 2012/2015, DAX, SSAS, SSRS, Visual Studio, SQL Server Management Studio, TFS, Excel (Power Pivot and Pivot Tables), SQL Server Agent, T-SQL.

Confidential, Westborough, MA

SSRS/SSIS Developer

Responsibilities:

• Loaded legacy source data from MSSQL, MySQL, Oracle, Access, and SQL Server DB’s into SQL Server 2008 R2 staging DB’s using SSIS Import & Export Wizard and VB scripts, SQL Server Migration Assistant (SSMA) and SSIS packages.
• Worked on Health Data Conversions for NFL (National Football Leagues) and SeaWorld. Generating on demand reports using eBO reporting using SSRS and adhoc reporting using report builder feature in SSRS.
• Maintaining and supporting the existing reports as per the requirements in the customer support portal. Worked on Maintaining, Generating Reports and Data Migration for various Hospital Database systems using SQL Server 2008, SSRS, SSIS, MySQL and vb.
• Improved the performance of SSRS reports by tuning the Stored Procedures and TSQL queries using various join conditions. Generate experience in converting Actuate reports into SSRS. Created XML, PDF, EXCEL files using SSRS.
• Deployment of SSIS packages to the conversion server and create and schedule SQL Server Agent jobs to automate the run of SSIS packages on a weekly basis. Experience in creating master and child packages, using package configurations (XML, SQL Server) and SSIS logging.
• Performed SQL Server DBA tasks like Conversion DB backups using compression, restore and disk space management on the conversion server, disabling and enabling constraints and triggers, applying DB Change requests, lookup data changes incorporation, logins & permissions.
• Involved in the entire conversion lifecycle stages of Requirement Analysis, Data Profiling, Logical and Physical Data Mapping, Strategy, design, development, Unit testing, conducting conversion mock runs to provide data for the Development DB, SIT, UAT, Data Reconciliation and validation.
• Documentation of Business Rules, Data Mapping Spreadsheet, Meeting Minutes, Key decisions from the client, SSIS and SSRS introduction material to the client. Worked with Managers to prepare requirements gathering documents and quality documents.

Environment: SSIS 2008/2012, SQL Server 2008R2, T-SQL, Visual Basic .Net, Vb6, XML, eManager, eBO reporting, Microsoft Project, Microsoft Access, SSRS, Microsoft Excel, QAS.

Confidential - Chicago, IL

SQL Developer

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications. Gathered User Requirements and System Specifications.
• Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.
• Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS. Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS). Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart. Design, deployment, and maintenance of various SSRS Reports in SQL Server. Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups. Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Environment: MS SQL Server 2016, DTS, SSIS, SSRS, SSAS, T-SQL, Excel, Visual Studio, OLAP.

Confidential - Wayne, NJ

BI Developer

Responsibilities:

• Created views to facilitate easy user interface implementation and triggers on them to facilitate consistent data entry into the database.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• 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.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• 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. Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS. Created different Power Pivot reports as per the client requirement.
• Document new SSIS packages and Train Senior Analyst on basic SSIS concepts.
• Verified business requirements and functional specifications. Database Design, Optimization of queries and Database, Performance Tuning using Index Wizard, SQL Profiler and Query Analyzer. Installed SQL Server Desktop Database and Standard Database.
• Created Stored Procedures, User Defined Functions, and Triggers to work consistently with the dynamic databases

Environment: SQL Server 2008/2005 Enterprise Edition, SSMS, SSIS, SSRS, SSAS Cubes and Dimensions, Power Pivot.

Confidential

SQL Server BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing data based on business requirements and provided documentation.
• Enterprise reports using SQL Server Reporting Services (SSRS) and Excel pivot tables which make use of multiple value section in parameters pick list, cascading prompts, matrix dynamic reports and other features of Reporting services. Built Drill Down, Drill through, linked and sub reports using SSRS
• Created Stored Procedures, User Defined Functions for databases.
• Developed complex T-SQL code for the application conversions. Created packages using SSIS for data extraction from Flat Files, Excel Files OLEDB to SQL Server. Worked with SSIS to import, export and transform the data between the linked servers.
• Used the Report Manager to create folder structures, modify data sources, controlling access to Report Services resources. Develop and deliver dynamic reporting solutions using SQL Server 2005 Reporting Services (SSRS)
• Extensively used Report Wizard, Report Builder and Report Manager for developing reports and deploying reports in SSRS. Developed Various Reports like Charts, Matrix, Tabular, and Cross Tab using SSRS.
• Developed reports involved in Passing parameters and cascading parameters using SSRS. Built and Deployed reports on the server using SSRS Report Manager.
• Developed fact tables, dimensional tables, cubes for OLAP warehouse using Analysis Services. Used Oracle, SQL PL/SQL in test environment.

Environment: SQL Server, Management Studio, Integration Services, Reporting Services, Analysis Services, OLAP, T-SQL, Windows, ETL, SQL Server Agent, Data warehousing.