PROFESSIONAL SUMMARY:

• Over 7 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

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in gathering business requirement and technical specifications and design documents for developing the data warehouse.
• Experienced on writing complex queries, performance tuning and optimized SQL queries using D-SQL T-SQL, SQL Profiler in SQL Server 2012/2014/2016.
• 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
• Did SQL performance monitoring and tuning of reporting data by optimizing indexes and stored procedures.
• Created and Implemented triggers in T-SQL to facilitate consistent data entry into the database.
• Created Alerts, Notifications and emails for system errors, insufficient resources, fatal database errors, hardware errors and security violation.
• Designed SSIS packages to Extract, Transfer and Load (ETL) existing data into SQL Server from different environment.
• Implemented Data Cleansing, Incremental Data Loading, Logging, Event Handling and Error Handling.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Loading multi format data from various sources like flat-file, Excel, MS Access, Oracle etc. using SSIS and performing file system operation.
• Created various types of reports such as sub reports, Tablix and Matrix using SQL Server Reporting Services and also created Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Designed and architected Report Layout including both simple and complex report using SSRS 2005.
• Created reports on both cascading and standard parameters.
• Designed reports on account information, research reports using ad-hoc reporting to be used by clients and advisors.
• Created calculated measures using MDX implementing business requirement
• Experienced working on Star and Snowflake Schemas and used the fact and dimension tables to build the cubes, perform processing and deployed them to SSAS database.
• Expertise in OLAP and OLTP and Datawarehouse Concepts.
• Worked on PowerBI in creating dashboards and reports and visualizing data.
• Creating Gateway and publishing reports to users according to the client requirement.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel and created SSIS packages to load excel sheets from PC to database.
• Implemented Row level Security to restrict the access to users.
• Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

Environment: Windows server 2007, MS SQL Server-2012/14/16 Enterprise Edition, SSIS, SSAS, SSRS, T-SQL, DTS, SQL Profiler, OLAP, OLTP, Office-2007, MS Excel, PowerBI.

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, Richardson, TX

SQL Developer

Responsibilities:

• Actively involved as part of a team for gathering and analyzing the needs of end User Requirements
• Used TSQL to create various stored procedures.
• Created Triggers, Check Constraint and Primary/Foreign Key to enforce data and referential integrity.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Involved in ETL to extract load and transform data using Automation Framework Tool.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.
• Involved in resolving Production Issues and Monthly Releases.
• Designed and developed data model in ER Studio.
• Developing database objects like tables, views, indexed views, synonyms, stored procedures, user defined functions and writing dynamic SQL, T-SQL.
• Creating Clustered and Non-Clustered indexes on tables for faster query retrieval.
• Using sqlcmd, dtutil, dtexec utility.
• Traced long running queries, Time out issues and deadlocks using SQL Profiler
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files, CSVs).
• Developed Tabular Reports, Sub Reports, Matrix Reports, drill down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created package configuration files to make packages dynamic across multiple environments.

Environment: Windows XP, T-SQL, MS Access, SQLServer2012, SQL Server2016, VSS 2013, VSS 2016, TFS, GitHub