PROFESSIONAL SUMMARY:

• Over 8 years of IT Experience in Database Design, Development and business intelligence of Microsoft SQL Server 2000/2005/2008/2012/2014/2016
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS) .
• Experience in Creating and writing complex SQL and T - SQL queries, Views, Indexes, Stores Procedures, DDL/DML Triggers and User-Defined Functions to implement Business Logic and Data Protection.
• Proficient in OLTP, OLAP, Relational Database Systems (RDBMS), Data Modelling, Normalization, Multi-Dimensional (Star) and Snowflake logical and Data Warehousing Design concepts.
• Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
• Worked in AGILE/SCRUM methodology in development of Database Objects in SQL Server 2005/2008/2012.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Look Up, Conditional Split, Bulk Insert , Aggregate, Merge and union all .
• Experience in Crystal Reports, MS Access and report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports .
• Experience in creating OLAP cubes, OLTP, identifying dimensions, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services (SSAS).
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS.
• Experience in creating and managing SSAS Tabular models, creating Dimension and Fact Tables.
• Hands-on Experience in MDX Expressions, DAX Expressions, Power BI Power Pivot, Power Query integrated with Share Point and in creating dashboards in Power BI and Tableau visualization tools.
• Worked on PowerBI in creating dashboards and reports and visualizing data.
• Experience in creating reports from scratch using Power BI from Excel workbook that contains Power View sheets.
• Excellent analytical, communication and interpersonal skills and able to work independently. Proficient in technical writing and presentations and a good team player.

TECHNICAL SKILLS:

Data Warehousing & BI: SQL Server Business Intelligence Studio (SSIS, SSRS, SSAS, DTS), OLAP, OLTP, T-SQL.

Reporting Tools: SSRS 2012/2008/2005/2000, Crystal Reports XI/X/9/8, Excel, Tableau, Power BI.

Database: MS SQL Server 2014/2008/2005/2000, Oracle 10g/9i/8i, MYSQL, MS-ACCESS.

Programming: C, C++, Visual C++ 6.0, C#.Net, VB.Net, PL/SQL, TSQL.

IT Processes: Software Development Life Cycle (SDLC), Project Management

Productivity Applications: MS Word, MS Excel, MS Access, MS Project, Visio

Operating System: Windows Vista/NT/XP/98/95, Windows 2003/2000 Server, UNIX.

Application Servers: Microsoft IIS 6.0/5.0/4.0, Apache.

PROFESSIONAL EXPERIENCE:

Confidential, Farmville, OH

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS packages.
• Worked on the creating Adhoc reports, Database Imports and Exports using SSIS
• Created report using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Worked in creating ETL packages for loading complete Data warehouse. Also created the Extraction packages to extract data from the Warehouse and send it to vendors through FTP.
• Created cubes and dimensions (SSAS) for the analysis of sales in specific areas.
• Good understanding of SSRS with Report authoring, created weekly and monthly reports as per requirement using SSRS.
• Used the SSIS Import/Export, migrated the Database such as Oracle and Access database, flat files to SQL server 2008
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Major responsibility is to take care of the tickets and responding to Production Issues immediately. This involves Modifying Stored Proc or running Insert/Update scripts in Production. Some tickets will involve a bit more research than writing complex code.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Created complex reports which involve more number of groupings and multi-value parameters.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Calculated the revenue in a sales database according to one set of business rules but be subject to an entirely different set of business rules in a general ledger database.
• Worked very closely with Business Customers, End Users and resolved any business process related issues

Environment: MS SQL Server 2008 Enterprise Edition, Visual studio 2008 R2, SSIS, SSRS, BIDS, MS Excel, Element Tool

Confidential, Texas

SSRS/SSAS Developer

Responsibilities:

• Worked in AGILE methodology in development of Database Objects in T-SQL, SQL Server 2005/2008/ 2008 R2/2012.
• Involved in analysis of Report design requirements and generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Added subscription and snapshot option to deployed reports for end users.
• Expertise in Creating SSRS reports using Report Designer as well as Report Builder.
• Developed Data Driven Subscription Reports and Ad-Hoc Reports using Report Builder in SSRS.
• Designed Subscriptions and Security for Reports.
• Created reports on both cascading and standard parameters.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Worked on Tableau to create extensive eye-catching reports according to the client requirement.
• Involved in development &Deployment of SSAS Cubes and Monitor Full and Incremental loads and support any issues.
• Implementing Dashboards and Score Cards using Microsoft Performance Point Server and integrated with share point.
• Provide Operational Support to modify existing Tabular SSAS models to satisfy new business requirements
• Advanced knowledge of Excel for using Pivot tables, Power Pivot, Complex formulas..
• Developed Aggregations, partitions and calculated members for cube as per business requirements.
• Designed Dimensional Modeling using SSAS packages for End-User. Created Hierarchies in Dimensional Modeling.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ OLTP/Analysis Server (SSAS).
• Developed normalized Logical and Physical database models to design OLTP.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Experience in creating reports from scratch using Power BI from Excel workbook that contains Power View sheets.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Experience in creating OLAP cubes, identifying dimensions, KPI’s, attributes, hierarchies and calculating measures and dimensions using SQL Server Analysis Services. Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2012/2008(SSAS).
• Designed, Build the Dimensions, cubes with star schema and snowflake schema using SQL Server Analysis Services (SSAS).

Environment: SQL Server 2012/2008R2/2008, SQL BI Suite (SSAS, SSIS, SSRS), Power BI, MS Excel, SQL Profiler, MDX, MS Office, Visual Studio, Tableau, OLAP, OLTP.

Confidential, MD

SQL Server/SSIS/SSRS/SSAS Developer

Responsibilities:

• Extensive experience in developing T-SQL Stored Procedures, Views, Cursors, Triggers, Scripts and Complex Queries in MS SQL Server.
• Performed Data Modeling in ER Studio 9.0 in the initial stages of the project.
• Developed T-SQL Queries to fetch complex data using Inner/Outer joins, sub-queries, CTE, Tally tables accommodating complex filters and database links.
• Developed Packages using most of the Tasks, Containers and Transformations in SSIS.
• Created SSIS packages to do incremental data load and logging.
• Met SLA’s fine tuning the SSRS and long running ETL queries.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Worked on dimensional data modeling, dimensions and facts for OLAP cubes configured report server environment and deployed reports to the database.
• Worked on creating cubes, calculations, KPI's, deploy of cubes using SSAS.

Environment: SQL Server /2012/2008 R2/2008, T-SQL, Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, Query Analyzer, SQL Server Profiler 2008.

Confidential, Texas

MSBI Developer

Responsibilities:

• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2008.
• Developed, monitored and deployed SSIS packages.
• Developed normalized Logical and Physical database models to design OLTP.
• Created indexes both non clustered and clustered indexes in order to maximize the query performance.
• Modified queries and stored procedures to improve the performance.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Data management and data processing solutions using SSIS, this includes Error Handling and Slowly Changing Dimensions
• Generated multiple enterprise reports like SSRS and Crystal reports.
• Created various types of reports such as sub reports, parameterized, Tablix and Matrix using SQL Server Reporting Services.
• Involved in creating Cubes and Tabular models using SQL Analysis Services (SSAS).
• Experienced in Data Marts, Data warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimensions Tables using MS Analysis Services.

Environment: MS SQL Server 2008, T-SQL, Visual Studio, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Excel, Windows 7, Crystal Reports, Data Migration, Toad.

Confidential, Louisville, KY

SQL MSBI Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Provided Full Reporting Life Cycle support using SQL Server Reporting Service 2008.
• Worked with T-SQL to create Tables, Views, Triggers and Stored Procedures.
• Created complex joins and implemented Constraints on tables for maintaining Data Integrity.
• Frequently used to connect to the health care data marts at different locations using C#.Net and ADO.Net for scheduling jobs.
• Designed and developed custom .NET components and user controls using ASP.NET
• Wrote VB Scripts to create custom SSIS transformations, in addition to using built-in SSIS transformations.
• Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQL
• Server 2005, 2008 Integration services.
• Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Worked on retrieving data from Legacy sources, retrieve files on daily, weekly and monthly basis, file-transfers from one location to other.
• Created complex SSIS packages using appropriate control and data flow elements with SSIS Standards like error handling, logging and working with package config files.
• Exporting the database from Local server to the remote server and importing the current running database from remote server to the local DB Server using SSIS.
• Created Tablix reports, Tabular/Matrix reports based on requirements.
• Created Dashboards using SSRS.
• Reduced the overall ETL time by SQL Query performance Tuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.
• Created databases, tables, and fields for data entry, performing database capacity planning.
• Enhanced and deployed the SSIS packages from development server to production server and scheduled jobs.
• Supported the production team when issues rose in the packages.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSISBCP, T-SQL

Confidential

SQL Developer

Responsibilities:

• Created business requirements, designed Functional Specifications and Flowcharts.
• Modified existing database to fit new business requirement by adding tables and relationships to support customer information system.
• Written SQL queries for back- end data validation database testing and reports verification.
• 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.
• Working experience writing SQL Scripts using Joins, stored procedures, Views, Indexes, functions, triggers.
• Provided back end support for functional testing and performance testing.
• Worked on reconciliations of balances from different systems.
• Analyzed requirements with developers, business analysts and provided my inputs.
• Wrote and executed the test cases to perform System, Functional and Regression testing.
• Worked on Team Foundation Server (TFS) for code review to check in and check out the codes.
• Actively ensuring the production implementation of the new enhancements with smooth transition of the project by adding value to the team in filling the gap where required as an analyst, programmer and QA tester.

Environment: SQL Server 2008, 2005, SQL Server Management Studio, SSIS, Visual Studio, MS-Office, MS Excel, MS Access.