SUMMARY:

• Over 6 years IT experience with extensive expertise in implementing end - to-end Business intelligence solutions using the Microsoft BI Stack (SSAS, SSIS and SSRS).
• Experience with software development lifecycle (SDLC) and project management methodologies.
• Very well versed in writing T-SQL and MDX for querying tables and Cubes
• Hands on experience working on IBM Informix database systems, RazorSQL and 4gl programs
• Experience working on Cross platform technologies including MS SQL, IBM Informix and Oracle Database applications
• Extensively created and debugged large SQL database scripts and batches
• Hands on experience in Installing, Configuring, Managing, Monitoring and Troubleshooting SQL Server 2008/2012/2014/2016.
• Experience in Database Development and Release Management Concepts, Practices and Procedures along with Performance Tuning Database Code in OLTP and OLAP environments.
• Experience in data Extraction, Transformation and Loading (ETL) processes using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Worked on OLTP Relational Schema with Normalization and OLAP Dimensional Modeling using Star and Snowflake schema.
• Knowledgeable about Multi-dimensional cube and tabular Models
• Proficient in T-SQL programming in creating stored procedures, triggers, views and user defined functions on SQL 2008/2008 R 2/ 2012/2014/2016 Servers.
• Optimized T-SQL Scripts by analyzing Execution Plans as well as using Microsoft Tools like SQL Profiler and Database Tuning Advisor.
• Experience in Importing/Exporting Data from data sources like Excel, and Flat file & SSIS package.
• Experience in creating Parameterized Reports, Drill down, sub cascading Reports and Reports using SQL server Reporting Services and customized reporting applications

TECHNICAL SKILLS

Database Tools: MS SQL Management Studio, MS Visual Studio 2013/2015/2017

RDBMS: MS SQL server 2008/2008 R 2/2012/2014/2016/2017

Business Intelligence: BIDS/SSDT, SSIS, SSAS, SSRS

Operating Systems: Windows Server 2003/2008/R2, 7/8/windows 10

Programming Languages: - T-SQL/MDX/IBM Informix 4gl/C#/C++/Visual Basics/.NET framework

Environment: MS SQL Server 2008/2012/2014/2016 SSIS, SSAS, SSRS, Excel, Windows server, Visual Studio

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

SQL Developer (Contractor)

Roles and Responsibilities

• Participated in the development of detailed data migration plans and designs from IBM Informix Databases into Microsoft SQL Server
• Conducted detailed analysis of the legacy Informix data model to migrate to a new MS SQL based platform
• Analyzed the requirements and framed the business logic for the ETL process. Identified and designed process flows to transform data and populate the target databases
• Created complex ETL/SSIS solutions to extract data from multiple source systems (around 70 courts) to a central data repository staging tables with a foreach loop iteration functionalities.
• Developed parameterized connection strings at run time using environmental variables to be able to run SSIS solutions in multiple environments (DEV,TEST and PROD)
• Analyzed Legacy Informix 4gl programs for conversion to T-sql store procedures for data mapping and transformation from staging to base tables
• Developed store procedures based on data mapping business rules for a daily data loading from staging to base tables
• Created environmental variables and configured with SSIS project parameters
• Created and scheduled SQL agent jobs and proxy to automate daily SSIS packages run
• Deployed and tested SSIS solutions on multiple SQL servers and environments
• Involved on creating a data model by reverse engineering using ER/Studio Data Architect for the data migration from legacy system IBM Informix to MS SQL based system.

Confidential, Phoenix, AZ

SQL /Reporting Developer

Roles and Responsibilities

• Involved in the analysis, design, Implementation and integration of data warehouse solutions
• Developed T-sql scripts to create dimension and fact tables for data warehouse building
• Created database objects tables, indexes, views, store procedures, and functions for data extraction from staging tables to dimension tables and fact tables
• Created store procedures for data mapping, data cleaning, data transformation and validation from source systems to staging and dimension tables.
• Developed ETL/SSIS solutions for data extraction, transformation and loading.
• Deployed SSIS packages into SQL server integration services catalogs(ICS)
• Created database table partitions, functions and schemes to enhance performance and troubleshooting locking and blocking issues on large tables
• Involved in SQL database base tables compressions (page and row compressions) to boost data base performance
• Involved in the building of cubes from the data warehouse dimension and fact tables for reporting
• Debugging very complex SQL scripts and store procedures for SSRS reporting
• Developed bulk data copy scripts using Microsoft command-line utility bcp for large volume of data backup and migration between multiple sql servers

Confidential, Tempe, AZ

Software Developer

Roles and Responsibilities:

• Designed SQL queries for business logic, based on the business requirement.
• Involved on the development of very complex store procedures that use complex aggregation functions, pivot and unpivot transformation, CTE, Temporary tables, derived tables.
• Created SQL Server Reports using SSRS.
• Used MDX Queries to fetch cube data into reports
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse and Report-Data mart.
• Developed scripts to migrate data from multiple sources.
• Responsible for all documentation(design document, test plan, User Manuals, etc.) related to projects
• Reporting using parameters, Sub reports, Drill Down Reports, expressions and report development using MDX
• Development and deployment of SSIS using various sources like Oracle/SQL Server/Flat Files/SAP systems,