SUMMARY

• 6 years of professional experience on Design, Development, and Maintenance of Database using tools of MS SQL Server 2008 to 2017 for both OLTP and OLAP Systems.
• Experienced with Software Development Life Cycle in all phases.
• Expertise and experience in designing and developing, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Database objects such as Tables, Schema, Indexed Views and User Defined Functions for data definition, manipulation and access.
• Experienced in Creating and Updating Clustered and Non - Clustered Indexes to keep up the SQL Server Performance.
• Expert in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard, and Database Engine Tuning Advisor.
• Excellent at working with Business Intelligence tools such as SSIS, SSRS, SSAS, and Power BI
• Experienced in data Extraction, Transformation, and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, and Bulk Insert.
• Experience in Data Conversion and Data Migration using SSIS across different databases like Oracle, DB2, and Flat Files.
• Expert in developing and deploying Cubes using Fact, dimension tables, identifying KPI’s and measures using MS SQL Server 2005 and MS SQL Server 2008 Analysis Services (SSAS).
• Used MDX to interact with the back end OLAP Services.
• Experience in creating reports using Grouping and Sorting and creating Sub Reports, Cascading parameters Report, Report Snapshot, Drill-Through Reports, Parameterized Reports, and ad hoc reports using SQL Server Reporting Services 2008/2012/2014 /2017 (SSRS).
• Design and Developed in production environments.
• Highly motivated, committed and a natural team player with good communication skills and Interpersonal skills coupled with right ability to get things done.
• Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
• Experience in MS Power BI to create various reports and analysical dashboards that depicts critical KPI’s

TECHNICAL SKILLS

Databases: MS SQL SERVER 2008/2008R 2/2012/2014/2016/207 , Oracle 10g/11g/13g, MySQL, Sybase, Teradata, MS Access, IBM DB2, Hadoop, Normalization and De-Normalization Schema.

Technologies: MS SQL Server Management Studio 2005/2008/2008 R2/2012/2014/2017, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS) SQL Server Reporting Services (SSRS), MS Power BI, Business Intelligence Development Studio (BIDS), Data Tools (DT), Data transformation Services (DTS), Liquibase, DB Visualizer, Visual Studio, MVC, TortoiseSVN, IBM Optim, Team Foundation Server (TFS), Toad, LINQ, WCF, Report Builder 2.0, MS VISIO, Erwin, Dia, Notepad++, XML Notepad, Salesforce, SharePoint, Jira, Quality Center.

Languages: T-SQL, SQL, PL/SQL, C#, .NET, ASP.NET, XML, jQuery, HTML5, CSS, VBScript, JavaScript

Platforms: Windows XP, Windows 7, Window 8, Window 10, IOS, Linux, Ubuntu, Android

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, Georgia

MS SQL BI Developer

Responsibilities:

• Attended and participated in information and Requirements Gathering sessions.
• Ensure that Business Requirements can be translated into Data Requirements.
• Developed the Logical and physical data model and designed the data flow from source systems to SQL Server 2016
• Design and Developed the ER Diagram on Visio before creating the new tables.
• Design and Developed SSIS ETL packages to bring in data from source to new environment.
• Extracted data from different flat files, MS excel, XML files and transformed the data based on user requirement and loaded data into target.
• Utilized large sets of data (10 Million +) using BCP utility in SSIS to move data from source to destination.
• Worked on various kind of transformations like Aggregate, Conditional Split, Data Conversion, Derived Column, Lookup, and Merge.
• Prepared test Scenarios and Test cases in Mantis and involved in unit testing of mappings, system testing and user acceptance testing.
• Responsible for deploying SSIS Packages, Views, Stored Procedures, Triggers, Indexes from Development Environment to Sand, and Pre- Prod.
• Responsible for rebuilding the indexes and tables as part of performance tuning.
• Used SQL Server Agent for scheduling jobs and alerts.
• Performed Query optimization and Performance Tuning.
• Optimized queries using SQL Profiler and Database engine tuning advisor.
• Designed and Developed SSIS package to purge data from Prod environment.
• Developed user defined financial reports to provide on demand financial data analysis
• Developed Ad-hoc reports for a day to day financial requirement.

Environment: MS SQL Server 2012/2017, MS SQL Integration Services (SSIS) 2008/2014, BIDS (Business Intelligence Development Studio), DT (Data Tool), MS SQL Reporting Services (SSRS) 2012/2016, SQL Profiler, T-SQL, Excel, Oracle 11g, Jira

Confidential, Providence, Rhode Island

MS SQL BI Developer

Responsibilities:

• Involved in business requirements and understanding the functional workflow of information from source systems to destination systems.
• Developed complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and created clustered and non-clustered indexes.
• Involved in upgrading from SQL Server 2008 to SQL Server 2014.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2014, Flat files and XML Files.
• Utilized Bulk Insert scripts to extract large Flat and XML files from a SFTP location.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2014.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Created analysical reports and dashboards using Power BI for critical KPIs
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Provided Production support to Tableau users and Wrote custom SQL Syntax to support business requirements.
• Utilized Tableau server to publish and share the reports with the business users.

Environment: MS SQL Server 2008/2014, MS SQL Integration Services (SSIS) 2008/2014, MS Power BI, BIDS (Business Intelligence Development Studio), DT (Data Tool), MS SQL Reporting Services (SSRS) 2008/2014, SQL Profiler, T-SQL, Tableau 9.3, Excel, Oracle 11g, Jira

Confidential, Charlotte, North Carolina

MS SQL SSIS/SSRS Developer

Responsibilities:

• Developed Logical and physical data model using Visio and mapped the data into database objects.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and Triggers.
• Creating and maintaining various databases on Production and development environments using SQL Server.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Utilized BCP utility in SSIS to move data from source to destination.
• Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports which take longer time in execution with SQL Server.
• Creating Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Designed and Developed the Architecture of the Business process and how SSIS is going to be the main involvement of the Business Flow.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in the Migration of Databases from SQL Server 2008 to SQL Server 2014.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files into Main Databases.
• Developed, deployed, and monitored SSIS Packages.
• Developed parameterized reports, Drill down and Drill through reports using SSRS.
• Created critical analysical reports and dashboards using Power BI for KPIs with the use of Power Pivot and Power Veiw

Environment: MS SQL Server 2008/2012/2014 , MS SQL Integration Services (SSIS) 2008/2012/2015 , MS Power BI, BIDS (Business Intelligence Development Studio), DT (Data Tool), MS SQL Reporting Services (SSRS) 2008/2012/2015 , SQL Profiler, TortoiseSVN, Liquibase, T-SQL, XML, Excel, Pivot Tables, Jira

Confidential, Lincoln, Rhode Island

MS SQL Server Developer

Responsibilities:

• Designed and Developed logical and physical data model using Visio and mapped the data into database objects.
• Involved in gathering requirements from business users and business analyst.
• Create and Update Stored Procedure, User Defined Functions, Vies, T-SQL Scripting for complex business logic
• Created multiple SSIS Package to extract data from multi Formatted Flat Files, Excel, XML files into SQL Server Database.
• Created Complex ETL Packages using SSIS to extract data from staging tables to normalized tables with incremental load.
• Extensively used Joins sub-queries for complex queries involving multiple tables form different databases.
• Optimized the database by creating various clustered, non-clustered indexes.
• Increased the performance necessary for statistical reporting after performance monitoring, tuning and optimizing indexes.
• Defined Stored Procedure for module integrity and applications.
• Designed and Developed triggers in T-SQL to check the referential integrity of the database.
• Designed and implemental several complex reports and administration modules.
• Prepare detail statistical reports in Excel to track progress of weekly, monthly and quarterly.
• Reviewed existing business procedure and recommended to implemented changes.
• Developed automating jobs in SQL Agents Jobs.
• Designed and Developed High Level and Low-Level Documents, also created Test Plans for all testing purposes as needed.
• Reviewed existing business procedures and recommended and implemented changes.
• Generated Drilldown, Drill through, Cross-tab & Summary reports by using SSRS.
• Used Report Builder to generate Ad Hoc Reports.

Environment: MS SQL Server 2008/2012, MS SQL Integration Services (SSIS), SQL Profiler, T-SQL, XML, VBA, MS Access, Excel, Pivot Tables, SharePoint

Confidential, Birmingham, Alabama

MS SQL SSRS/SSIS Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirement and understanding the functional workflow of information from the source systems to destination systems
• Responsible for creating Indexes, created and updated Stored Procedures, and created appropriate triggers to assist efficient data manipulation and data consistency.
• Prepared High Level (HLD) and Detail Level Documents (DLD)
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Joins, Constraints, DDL, DML, and implement the business logic and created clustered and non-clustered indexes
• Designed and developed SSIS packages to import and export data from Excel, Flat file, and Oracle
• Involved in completing SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in various environments such as Development, UAT, and Production
• Created configuration files in xml format to ensure the packages worked in various environment
• Involved in ETL architecture enhancements to Increase the performance using query optimizer
• Implement Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages form Data Conversion using data conversion transformation
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval
• Developed various types of complex reports like Drill Down and Drill through.
• Created Ad hoc reports using SSRS And also Created Subscriptions and scheduled reports using subscriptions.

Environment: MS SQL Server 2008/2012, Oracle 11g, MS SQL Integration Services (SSIS), BIDS, Data Tools, MS SQL Reporting Services (SSRS), SQL Server Analysis Services (SSAS), XML, C#, DB Visualizer, Excel, IBM DB2, Visual Studio 2008/2012, TFS, Visio, SharePoint.