SUMMARY:

• Over 6 years of IT experience in the Analysis, Design, Development, Implementing and Testing, Administrating Client/server applications.
• Expertise in Microsoft Business Intelligence Services like SQL Server Integration Services, SQL Server Analysis Services and designing reports using SQL Server Reporting Services.
• Working knowledge of Extraction, Transformation and Loading (ETL) between homogenous and heterogeneous sources using SSIS packages.
• Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.
• Working experience with OLTP and OLAP databases in MS SQL Server ( 2016/2014/2012/2008 R2/2008/2005).
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Proficient in creating dynamic packages for Incremental Loads and Data Cleaning in Data Warehouse using SSIS.
• Expertise increasing Databases, Tables, Cluster/Non - Cluster Index, Unique/Check Constraints, Functions, Views, Stored Procedures, Triggers.
• Expert in developing and modifying multidimensional Cubes in SQL Server Analysis Services.
• Hands on experience in Data Migration and Transformation from different file formats like Flat file, MS Excel and Oracle to SQL Server 2016/2014/2012/2008 R2/2005
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 (SSRS)
• Expertise in creating drill down reports, parameterized reports and Ad-Hoc reports using SSRS (2012/2008R2/2008/2005).
• Excellent knowledge in creating custom specific and schedule reports using SSRS
• Working knowledge in Creating tables, Stored Procedures, Triggers, User-Defined Functions, Views, Indexes, User Profiles using Transact SQL.
• Experience in installing, configuring, managing, monitoring and troubleshooting SQL Server (2016/2012/2008 R2/2008/2005).
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Excellent experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Strong programming and excellent analytical skills besides competent experience in handling critical situations.

TECHNICAL SKILLS:

BI Tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SQL Server Reporting Services(SSRS)

Databases: MS SQL Server 2016/2014/2012/2008 R2/2008/2005, Oracle 8i,9i/10g,11g, MS Access 97/2000/2010

T: SQL, PL/SQL, HTML, C#, ASP.NET

Operating Systems: Windows NT/98/2000/XP/2003 Server, Unix, Linux, Sun Solaris

Other Tools: Snowflake, ELT Maestro for AWS, Data Transformation Studio (DTS), Team Foundation Server (TFS), Business Intelligence Development Studio(BIDS), Enterprise Manager, SQL Profiler, SQL* Loader, MS Visio. Erwin r7/r4/r3.5, Swift Application Lifecycle Management Tool

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

MS SQL Server Developer SSIS/SSRS Snowflake Developer

Responsibilities:

• Working with end users, Business owners, Operations team, technical staff, and project team members to plan, design, develop, implement, and enhance business analytics capabilities using Tableau’s Business Intelligence tools for requirement gathering, designing and creating Tableau Dashboard/SSRS reports.
• Requirement Gathering from Business users, design and implement ETL process, manage and maintain databases, create table, stored procedures, database development and data analysis on existing Stored procedures, Triggers, Functions, SSIS solutions, perform Data analysis, monitor existing jobs in SQL Agent.
• Extensively worked with SSIS tool suite/Data tools, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Wrote stored procedures and User Define Scalar Functions (UDFs) to be used in the SSIS packages, SQL scripts, T-SQL Programming techniques in query optimization and performance tuning.
• Reviewing current operational data structures and data flows and recommend optimizations and opportunities for automation.
• Participating in client engagement meetings for developing plans and strategies of data management processes and IT programs for the clients, providing hands on assistance in data modeling, technical implementation and best practices.
• Debugging, monitoring and troubleshooting BI solutions.
• Extracted data from sources and transformed the data using different transformations like data conversion, derived column, look up, Conditional Split, Aggregate, Union all, Row Count and merge join transformations.
• Created Event Handlers for the Packages Using Event Handler Tab for Error Handling and Logging purpose.
• Evaluate and recommending new tools and methodologies to assist in meeting business requirements through data integration and reporting.
• Created Transactions in SSIS packages to roll back the whole process in case of failure and also implemented Event Handlers for the SSIS using Event Handler for Error Handling and Logging purpose.
• Designed Different Types of reports like Drill Down, Drill Through, Sub Reports, and Parameterized Reports, Sort prompts, Cascading parameters reports and Multi Value Parameters.
• Migrated Data from SQL Server 2016 to Snowflake using ELTMaestro.
• Converted the SQL Server Stored procedures and views to work with Snowflake.
• Was available for on call support on rotation basis to troubleshoot production issues on timely manner.

Environment: SQL Server 2016, SSRS, SSIS, T-SQL, Snowflake, ELTMaestro, Oracle 11g, SQL * Loader, Visual Studio 2015, XML, Excel.

Confidential, Farmington Hills, MI

MS SQL Server Developer SSIS/SSRS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems
• Assisted in the design of star schema and snow flake schema
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012 and Flat files
• Modified existing SSIS packages to meet current business needs.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data marts.
• Created SSIS packages for Data Conversion using data conversion transformation
• Wrote stored procedures to be used in the SSIS packages.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Deployed SSIS package involving complex Transformations like Slowly Changing Dimension, Fuzzy Grouping, Merge, Merge joining, Pivot, Unpivot.
• Worked on Data Flow transformations like for each Loop Container, Execute process task, Transfer SQL Server Objects task, Transfer Jobs task, Transfer Logins task.
• Research on upgrading the SQL Server from
• Worked with SSIS packages involved FTP tasks, Fuzzy Grouping, Merge, and Merge joining, Pivot and Unpivot Control Flow Transformations.
• Used SQL Server Package Configuration technique to make Dynamic configurations.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Developed SSAS Cubes by creating Measure Groups, Dimensions, Aggregations, Hierarchies, Partitions and Perspective using SSAS2008R2.
• Setup and monitored jobs for loading and processing SSAS Cubes. Developed MDX queries for SSRS reports from SSAS Cubes.
• Created On demand (Pull) and Event Based delivery (Push) of reports according to the requirement.
• Deployed and configured the reports in the Report Server.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012
• Configured SQL mail agent for sending automatic emails when SSIS packages fails or succeeds.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers.
• Schedule the packages to keep extracting the data from OLTP at specific time intervals.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Written and executed complex T-SQL queries using SQL Server Management Studio for back end data validation testing
• Optimized queries using SQL Profiler and Database engine tuning advisor
• Used SQL Server Agent for scheduling jobs and alerts.
• Responsible for regression testing ETL jobs before test to production migration.
• Configuration and Deployment of all reports across various SDLC environments.
• Working within the testing team to develop customized macros and test suites to automate tasks in dBase IV running over several networks and platforms, accessing information for different RDMS Systems.
• Using Application Life Cycle Management Software(QC) to manage test cases, defects,QTP scripts for regression testing.

Environment: SQL Server 2012/2008R2, SSRS, SSIS, T-SQL, Oracle 9i/10g, SQL * Profiler, SQL * Loader, Visual Studio 2005, XML, XSLT, MS Office and Visual source safe, UNIX, Swift Application Life Cycle tool.

Confidential

SQL Developer

Responsibilities:

• Collecting Business requirements from users and translated them as technical specs and designed documents for development.
• Designed and developed SSIS (ETL) packages to validate, extract, transform and load data from OLTP system to the Data warehouse.
• Created SSIS package to load data from Excel File to Data warehouse using Lookup, Derived Columns, Sort, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used various SSIS tasks such as Conditional Split, Multicast, Fuzzy Lookup including data validation checks during Staging, before loading the data into the Data warehouse.
• Configured files to deploy the SSIS packages across all environments.
• Created Stored Procedures involving multiple tables to apply different logics to the data as per business requirements and get the required outputs.
• Defined report layouts including report parameters and wrote queries for drill down reports, Conditional, Drill Through report, Sub report, Parameterized report using SSRS 2012.
• Generated Reports using Global Variables, Expressions and Functions.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Created database objects like table, Views, Store Procedure, Triggers, Functions using T-SQL.
• Responsible for 24/7 Production support and fixing data issues raised by Business on timely Manner.

Environment: MS SQL Server 2012/2008R2, SQL server integration services (SSIS) 2012, SQL server reporting services (SSRS) 2012, and TSQL, MS Office, Notepad++