PROFESSIONAL SUMMARY:

• Over 6 years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2016/2014/2012/2008 R2/2008 databases.
• Designing, testing and implementation of high availability solutions for databases for large, medium and small customers.
• Experience in Banking, retail and telecom domain.
• Experience in SQL Replication models, Stored Procedures, Triggers, Indexes, Views, Locks, Data Transformation Services, and Analysis services.
• Coding of Database objects like Triggers, Procedures, Functions and Views.
• Expert in MS SQL Server suite of products like SSAS, SSIS and SSRS of MS SQL Server.
• Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
• Exposure to T - SQL programming and Architecture, and translated complex legacy process with T-SQL procedure, functions and package.
• Extensively worked on developing and deploying applications using: SQL Server, Microsoft office, VBA and macros.
• Experience in developing and monitoring SSIS and DTS Packages.
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS.
• Extensively worked with SSIS for extracting data from legacy systems to stage and then to Cleanse, Process and Loading into Data Marts and Data Warehouse.
• Experience in designing logical and physical data models using ERWIN and ER/Studio tools.
• Hands on experience in creating ETL packages using SQL Server Integration Services (SSIS).
• Worked with OLAP and Data warehouse application and worked with star schema, type1/type2/type3 dimensions and worked with implementing SSAS, and SSRS to support large Reporting needs.
• Performed Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning.
• Hands on experience in creating OLAP cubes using SQL Server 2008 analysis services (SSAS).
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• A Team-Player with motivation and ability to work independently, worked closely with the Case Teams, Business Analysts and Data Analysts and Functional Design Teams.
• Worked with performance tune the complex queries using the Microsoft Query analyzer and used to support batch process
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard, and Windows Performance Monitor.
• Have worked in fast paced AGILE environment & attended daily scrum meeting.

TECHNICAL SKILLS:

RDBMS/DBMS: Microsoft -SQL Server Azure/PDW/ 2016/2014/2012/2008 R2/2008

BI /Data model Tools: MS SharePoint, Microsoft SQL Server Reporting Services 2008/2005/2000, ETL, Crystal Reports, DTS, SSIS, Erwin and Visio

Programming Languages: T-SQL, C/C++, C#, VB 6.0, VB Script, SQL*Plus, VB.NET, ASP .NET

Database Tools: SQL Server Management Studio, SQL Server Profiler, SQL Server Business

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

Lead ETL Microsoft SSIS developer/ SSRS / SSAS / Tableau developer

Responsibilities:

• Gathering business requirement from users and design the database schema base on the business needs
• Analysing data coming from different source such as Salesforce application, SAP database and other legacy system, merging the existing data warehouse with new data source and requirement given by business user.
• 24/7 Production support for existing ETL package and cube package that currently running in production server
• Troubleshooting the failure reason of SSIS package and Cube and provide instant solution to ensure data is always up to date in data warehouse.
• 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 to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Coordinate with SSAS developer and create required back end data and view to support cube creation.
• Assisting power user to create business report using reporting tool such as tabular
• Holding seminar to guide business user how to use SSAS cube in excel interface.
• Diagnosed and tuning the server optimal performance using SQL server 2005, Dynamic management views, Profiler and Index Tuning Wizards.
• Converting SSIS package and database object such as table, view, stored procedure, function from SQL server 2012 into Parallel Data Warehouse (PDW).
• Database administration, security setup such as creating different database roles to ensure different level of users have the right access to database object.

Environment: Microsoft SQL Server 2008, SQL Server 2012 Enterprise Edition, SQL server 2014/2016/PDW/Azure. T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MS Visio,MDX, Windows server 2012,MS SharePoint. Salesfore application. Avaya call system, Microsoft Parallel Data warehouse.

Confidential, Jacksonville, FL

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing constraints and triggers for data integrity.
• 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 to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created interface stored procedures used in SSIS to load/transform data to PRMS
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Created OLAP Cubes and was responsible for OLAP processing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube
• Performed partitioning of cubes as well as cube optimization in order to increase the performance of cubes
• Migrated SSIS Packages from 2005 to SSIS 2012.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Excellent report creation skills using Microsoft SQL Server 2012/2008 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder and MS SharePoint.
• Worked on content management and document management using MS SharePoint.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2008/2005(SSAS)
• Created Parameterized reports and linked reports using Bookmark links and Hyperlinks.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website, and in the Intranet web application.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.

Environment: Microsoft SQL Server 2005/2008, SQL Server 2012, Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, MS Visio,MDX, Windows server 2003 and IIS 5.0, MS SharePoint.