SUMMARY:

• Over 8 Years of IT experience which includes System Analysis and Design, Development and Support of MS SQL Servers 2017/2016/2014/2012/2008 R2/2008/2005 in various development, test and production environments with various business domains like Financial, healthcare.
• Expertise in Business Intelligence Development Studio (BIDS), which includes SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Implemented complete BI solutions using conventional SDLC and Agile methodologies.
• Proficient in writing and tuning SQL queries and improving the query performance, working on DTS, Data Cleansing and Data Migration.
• Skilled in BI tools of Tableau, Power BI, SSRS including report, query writing using SQL and building front end BI applications as per specifications.
• Experience in Designing Data mart and Data Warehouse using Star Schema and Snowflake Schema for implementing Decision Support Systems.
• T - SQL development to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience in managing and automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.
• Involved in Huge data migrations, transfers using utilities like Data Transformation Services (DTS) and SSIS, Bulk Copy Program (BCP) and Bulk Insert.
• Experience in developing the applications using T- SQL Programming (DDL, DML, and DCL).
• Experience in T- SQL programming skills like creating Stored Procedures, Functions, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, and Cursors.
• Expertise in creating Configurations to make package portable and Event handlers for handling package error.
• Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension (SCD), Merge Join and Union.
• Prototyped Data visualizations using Charts, Drill-down, Parameterized controls using Tableau to highlight the value of analytics
• Expertise in using Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security and has an ability to define and develop Report Structure with data definition, report layout and report definition language.
• Developed BI data mapping and BI objects (dashboards, reports, analyses, visualizations, metrics, security) design documents using Power BI.
• Expert in calculating measures, mathematical formulas and user-defined functions (DAX) in Power pivot reports.
• Expertise in creating InfoPath solutions and publish into SharePoint form Libraries for sharing information, implementation of Out-of-box workflows designed using SharePoint designer 2013.
• Worked with SharePoint designer workflow for updating teamwork progress on project day to day development.
• Experienced in organizing and customizing SharePoint Sites, Web Parts, Connectable Web Parts and deployment of Web Parts with SharePoint Server.
• Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, and ROLAP), dimensional modeling, star schema and snowflake schema.
• SQL Server OLAP Database Development including KPIs, Data mining, working with changing dimensions.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Sr. BI/ MS SQL/SSIS/ SSRS Developer

Responsibilities:

• Developed, tested and deployed over 50 ETL (Extract, Transform and Load) data systems utilizing various versions of SSIS.
• Involved in heavy data migration/ETL activities using BCP, Data Transformation Services and SQL Server Integration Services (SSIS) ( 2016/2012/2008 R2/2008/).
• Migration of SSRS reports from SQL 2012 to SQL 2016.
• Updated and standardized preexisting automation processes by utilizing effective methods to bulletproof ETL processes against failures that can leave data in an unusable state.
• Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Teradata, Excel and Oracle to SQL Server using Business Intelligence Development Studio (BIDS).
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments. Worked with different database and different server with the use of linked server.
• Responsible for writing parameterized queries for generating tabular report, Sub reports, using global variables expressions and functions, sorting the data, defining the data, defining the data sources and subtotal for the reports using SSRS 2016/2012/2008 R2.
• Involved in writing T- SQL programming to implement Stored Procedures and Functions for different tasks and created Triggers to enforce data and referential integrity. Worked in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using SSIS 2012.
• Successfully upgraded SQL Server 2000 SQL Server 2005 SQL Server 2008/2008 R2 SQL Server 2012/2
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Contributed in writing complex T-SQL's for meeting the OLAP requirements.
• Worked with EDI transactions like 270, 271, 276, 277, 835 and 837I/P/D.
• Created Power BI Dashboards (Power View, Power Query, Power Pivot, Power Maps) and integrated them to share point.
• Back end Experience in MS SQL Server development, writing T-SQL stored procedures, views, triggers, cursors using 2012 SSMS Versions.
• DAX operations were used to create custom calculations in Power Pivot for Microsoft Excel workbooks and Analysis Services Tabular data warehousing.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Involved in Tabular Data warehouse and DAX operations for SSAS 2012 and 2008 OLAP databases.
• Used DTS/SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data marts and performed action in XML.
• Involved in deployment of SSRS reports on the SharePoint Portal.
• Created bottom count, top count, cross join, non-ascendants and log MDX queries for creating Calculations and KPI's on a cube.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Developed Multi-Dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS).
• Supported development of Access applications for product management group, involving analysis, design, coding, and testing of components.
• Migrated old data from MS Access and Excel into SQL Server 2014 using SSIS Packages in Business Intelligence Development Studio.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Lookup.
• Designed several extracts using SSIS 2017 which will gather sales information generated from the individual stores for analytical data processing needs.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Created SQL Server Reports and developed query for generating drill down and drill through reports using SSRS.
• Created multiple dashboards with calculations and KPIs using Tableau 9.3/10 and deployed them in tableau server. Identified and worked with Parameters for parameterized reports in SSRS 2012.
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.

Confidential, Atlanta, Georgia

Sr. BI/MS SQL / SSRS Developer

Responsibilities:

• Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc. using T- SQL to store data and to maintain database efficiently.
• Designed high level SSIS architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, Staging DB to Data warehouse and Data marts.
• Data Transformation Activities using SSIS Import/ Export for transferring data between different databases like oracle and Teradata.
• Designing, installing, upgrading, administrating, securing and monitoring SQL 2017/2 / databases in the cloud on Cluster and non-cluster environments.
• Implemented, Configured and maintained Always ON, Clustering (Active/Passive), Replication (snapshot, Merge and Transactional), Log Shipping as HA & DR plans for SQL Server 2005/2008/ 2012/2
• Worked on the Reports module of the project as a developer on MS SQL Server 2005 (using SSRS, T-SQL, scripts, stored procedures and views).
• Used ETL to implement the SCD transformation, to maintain historical data in data warehouse.
• Developed Custom Functions, Manual Running Totals and Complex Formulas for reports used calculations, sorts, filters and sections to enhance data presentation in reports.
• Created many Cascaded parameters in the reports using SQL SSRS. Developed many Tabular Reports, Matrix Reports, KPI Reports and Charts using SQL Server Reporting Services.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Migrated databases, logins, users, roles, permissions, jobs, stored procedures and other DB objects from SQL Server /2014/2016 on Development, Testing Production Environments for various mission critical applications as part of end of life project.
• Worked with production control team to deploy code and for schedule run in both staging while testing and production. Responsible for providing 24/7 on-call production support for daily job and ETL loads.
• Designed T- SQL scripts to identify long running queries and blocking sessions.
• Created SSRS reports using Report, Drop-Down, Multi-Valued Parameters and Debugging Parameter Issues in Matrix Reports and Charts.
• Permitted access to the reports based on designation of the viewer like store manager or district manager or associate extra.
• Modified data on Azure SQL database through SQL Server Management studio.
• Migrated data from on premises databases to SQL database on Azure cloud.
• Created reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.
• Designed rich dashboards with Power BI and prepared user stories to create compelling dashboards to deliver actionable insights.
• Involved in creating report models and applying row level security filters for report model.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server Analysis Services (SSAS) and Reporting service (SSRS).
• Performed ETL mappings using MS SQL Server Integration Services 2008/ 2012/2014/2016.
• Created reports from cubes by writing MDX queries.
• Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports.
• Designed different kinds of reports like Linked, cascaded and parameterized reports.
• Responsible for creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports, Linked Reports, and Reports using stored procedures using SQL Server Reporting Services 2012.
• Developed various analytical reports from multiple data sources by blending data on a single worksheet in Tableau.
• Developed dashboard reports on the Tableau Server so that the end users having access to the server can view the data.
• Experienced in Teradata utilities like BTEQ, Fast Load, Multi Load, Tpump, Fast Export and Teradata SQL.

Confidential, Jacksonville, FL

MSBI/ SSRS Developer

Responsibilities:

• Worked with business stakeholders, application developers, production teams and across functional units to identify business needs and discuss solution options.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
• Designed Change data capture to capture insert, update, and delete activity applied to SQL Server tables, and to make the details of the changes available in an easily consumed relational format.
• Developed and deployed SSIS packages for ETL from Oracle Materialized Views to fetch HP-PPM timesheet data load into staging and staging to Data warehouse using Master package to call all child package, Execute SQL Task to run store proc for soft delete /Update and Insert flag, Sent Mail task on error even handler, handle late coming dimensions logic, Performed ETL mappings using MS SQL Server Integration Services.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and created stored Procedures for the business logic using T-SQL.
• Used indexes to enhance the performance of individual queries and enhance the Stored Procedures.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau. Developed database triggers and stored procedures using T-SQL cursors and tables.
• Enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded into the audit table.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Created C# Script for Control Flow and Check File existence using Script task in SSIS.
• Highly Involved in EMR (Emergency Management Release) break fix and create latent change after resolution.
• Supported Production Environment with schedule the packages and make the package dynamic with SQL Server Package Configuration.
• Involved in Production support with Deployment of the SSIS Packages and schedule SSIS packages using SQL Server Agent Job.
• Updated the Existing SSIS packages with proper error handling and logging by using even Handler, error constrain, OLEDB Destination with limiting row per batch and send mail task with exact error to SQL Developer group and DBA.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports, cascading parameterized Reports with KPI using SSRS.
• Create a data driven subscription and schedule snapshot to generate an executive summary report and send to company director AD groups.
• Created cluster-column store index on Fact tables in Data warehouse.
• Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.

Confidential, Horsham, PA

MSBI/SSIS/ SSRS Developer

Responsibility:

• Generated parameterized queries in SSRS 2005/ 2008/2008 R2 using data from SSAS Cubes and various heterogeneous data sources.
• Inserted into the tables from the power shell by calling stored procedures.
• Created complex expressions using the MDX scripting to solve complex designs.
• Implemented the Queue logic by starting SQL Agent jobs(which pointed to deployed SSIS packages on the integration server .
• Involved in writing heavy T-SQL stored procedures, complex joins, new SQL2008 T-SQL features like Merge, Except commands
• Designed SSIS packages to implement the file processing logic depending on the source of the file.
• Maintained different branches in TFS as development for release 2 and testing for release 1 were together.
• Involved in transferring old data from various sources like flat files, MS Access, and Excel into MS SQL Server 2012 database using SSIS Packages
• Expertise with Agile & waterfall methodology
• Deployed different database instances for development, QA, UAT and production from TFS.
• Deployed SSRS on to the report server with an easy way of deployment.
• Called those subscriptions using a stored procedure (which fired the report subscription and saved the reports on the file server).
• Implemented the SQL agent jobs creation while deploying the database instance itself by adding them on to the post deployment scripts.
• Formatted Reports and created interactive dashboards using Micro strategy platform.
• Created the SQL server users and file server users with required permissions by including them in the scripts.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports.
• BI reporting using Excel with Power Pivot.
• Implemented matrix tabular and charts while creating the reports using SSRS.
• Used expressions extensively for hiding textboxes, display labels and hiding charts, matrix and tabular depending on certain conditions.
• Used parameters, images to retrieve appropriate data from the common data source added globally.
• Used T-SQL queries and views based on business reporting requirements, performance tuning and various complex SQL queries optimization.
• Implemented Derived column, file system task, conditional split, lookup transformation, OLE DB Command, Data conversion, Data flow, Execute SQL task, Bulk task, Script task, for each loop, Ftp task and other tasks in SSIS.
• Optimized the loads by adding Indexes wherever needed, dropped and recreated indexes while doing the full loads.
• Performed transactional-level process using MicroStrategy's relational OLAP (ROLAP) architecture.
• Maintained the SQL Server Agent jobs to run depending on the requirement.
• Used IBM OLE DB connection manager to connect to IBM DB2 data base and get some input data to the look up loads.
• Imported data from Oracle based data source into tabular model for excel reporting.

Confidential

MS SQL Developer

Responsibility:

• 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 2005 to SQL Server 2008.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
• Wrote T-SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and random data requests.
• Created SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Worked on formatting SSRS reports using the Global variables and expressions.
• Created parameterized reports, drill down and Drill through reports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Published reports on to Share-Point and created Web Parts in Share-Point to show various reports generated from Excel and SSRS in one Page.

Confidential

MS SQL Developer

Responsibility:

• Developed Functional Specification and Requirement analysis Document.
• Used SQL Profiler & Query Analyzer to optimize T- SQL queries and stored procedures.
• Created several Complex Views in T- SQL according to the Client Requirements whenever needed.
• Worked on SSIS for transferring data from Heterogeneous Database (Access database, Oracle, Excel, and Flat Files) to SQL Server.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Retrieved data from OLAP cubes through MDX Script for Reporting Services.
• Used SSRS to create Standard Reports, Matrix Reports, Ad-hoc reports and Parameterized Reports. Involved in analyzing multi-dimensional reports in SSRS.
• Migrated SQL Server 2000 database to test server running on Windows 2000 Server.
• Involved in Query Optimizations & Performance Tuning for the T- SQL Stored Procedures & Functions.