SUMMARY:

• Over 8+ years of wide - ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Experience in integration of various data sources like SQL Server, Salesforce, Oracle, Access DB, DB2 and Flat File, Excel File.
• Import Data into Power BI using different ETL methods, SQL Azure, Direct Query, Restful API Generator, build relational model with in Power BI.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements
• Extensively worked on Control Flow Tasks such as Foreach Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2008/2012/2014/2016.
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Hands-on star schemas, snowflake schemas, dimensional modelling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
• Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, user functions, relational database models and data integrity, SQL joins and query writing.
• Extensively worked on Table Design creating Clustered Indexes, Non Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
• Excellent skills in designing Logical and Physical Modeling using ERWIN Tool.
• Experience in using Star Team and Team foundation server for source control.

TECHNICAL SKILLS:

Server Operating System: Windows 2003, 2008, 2012.

Languages: C, C#, Pl/SQL, T-SQL

Microsoft Technologies: C#.NET, ASP.NET, VB.NET, ADO.NET

Web Technologies: HTML, XML, SharePoint 2010.

Data bases: MS SQL Server 2005/2008/2012/2014/2016 , Oracle 10g

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

Development Tools: Visual Studio.NET 2008/2012/2013/2015/2017 Community Edition

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2015, SQL Profiler, DQS, Toad for SQL server

PROFESSIONAL EXPERIENCE:

Confidential, Covington, LA

Sr.SQL BI Developer

Responsibilities:

• Created SSIS packages to perform filtering operations and to import the data on daily basis from the legacy data sources to SQL Server 2016.
• Creating complex SQL scripts to transform legacy data in staging area using SSISpackages.
• Configuring SSIS packages for run time parameters and config files.
• Used SSIS for Extracting and Merging of data from different source to single source.

  Scheduling Jobs to run SSIS Packages in the night feed to DSS for fresh day data.

• Created SSIS packages to automate different FTP's files and emailing to different clients.
• Created SSIS packages included a variety of transformations, for example, Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Generated reports from SQL Server Database and OLAP data warehousing.
• Deployed Reports to Report Manager and Troubleshooting for any errors during in execution.
• Scheduled the Reports to run on the daily and weekly basis in Report Manager and email them to the directors and analyst to review in Excel sheet.
• Created Sub-Report, Matrix Report Tablix Report Drill down Report and Charts using SSRS.
• Deployed and subscribe Reports using SSRS to generate all daily, weekly and monthly reports.
• Build automated ETL processes in SQL Server Integration Services (SSIS) for the system.
• Designed a Power BI Data model with multiple Facts and Dimension Tables based on the requirement.
• Designed and Implemented analytics solutions using Power BI Dashboard and Reports.
• Utilized Power Query in Power BI to Pivot and Un-Pivot the data model for data cleansing.
• Created Page Level filters, Report level Filters, Visual level filters in Power BI according to the requirements.
• Participated in testing during the UAT (QA Testing). Mentored and monitored team development and status.
• Drop and recreate Index on the DSS System while migration data.
• Based on the business requirement written complex T-SQL queries to perform data and graph validation to make sure that the test results are matched.
• Designed Data flows, Workflows and jobs to load data from source to target.
• Created trace in SQL Profiler and used Data base engine tuning advisor for performance tuning on scripts and stores procedures.
• In-Depth knowledge of SDLC, understanding of various phases like Requirements, Analysis, Design, Development. And Testing. Reviewed many T-SQL issues using management studio for better performance.

Environment: SQL Server 2014/2016, SQL Server Integration Services, Power BI, MS Excel 2016, Management Studio, SQL Profiler and SSRS.

Confidential, Pittsburgh, PA

SQL BI Developer/SSIS/SSRS Developer

Responsibilities:

• Creation of Clustered and Non-Clustered Indexes for Query Performance and Generated various reports using complex stored procedures.
• Perform Code review of Stored Procedures and prepare for database build steps for weekly change cycle.
• Wrote complex T-SQL batches with Common Table Expressions (CTE's) for recursive operations.
• Designed SSIS Packages using transformations in Data Flow Task including Conditional Split, Data Conversion, Derived Column, Lookup, Fuzzy Lookup, Merge, Merge Join, Union All, Pivot, Sort, Multicast, OLE DB Command, and Row Count Transformations.
• Applied Slowly Changing Dimensions concepts using Lookup Transformation, and SCD Transformation for change identification process.
• Involved in daily loads (Full & Incremental) into Staging areas, OLTP databases, Fact and Dimension tables in Data warehouse, troubleshooting processes, issues and errors using tasks, transformations, and variables in SQL Server Integration Services (SSIS) 2012 and 2014.
• Created packages in SSIS with error handling using event handlers.
• Worked with different methods of logging in SSIS such as file and SQL logging.
• Exported or Imported data from other data sources like flat files using Import/Export through SSIS.
• Involved in complete SSIS life cycle in developing SSIS packages, configuring, deploying and executing the packages in different environments (Development, Testing and Production).
• Have deployed packages on different servers by configuring it using SQL Server and XML Configuration, and Project Parameters configuration.
• Troubleshoot and tune Reporting Stored Procedure (SSRS) performance issues. Troubleshoot blocking issues.
• Troubleshoot and resolve various database processes impacting production and provide root cause analysis to prevent and/or improve upon daily transactional throughput.
• Created reporting process (SSRS) for management to get timed reports on various database counters pertaining to resource consumption
• Automated Excel VBA applications involving spreadsheets, Excel charts.
• Automated KPI metrics reporting using Visual Studio Team Services/Power BI.
• Worked on Analysis services for three different approaches for creating a business intelligence semantic model such as tabular, multidimensional, and Power Pivot.
• Analysis the metric dashboard reports and identified the formulas and functionality of the dashboard reports and digitizing the metric dashboards with Power BI service.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Created Customized and interactive dashboards using multiple data sources.
• Created conditional filters and Action links to filter the data on dashboard with Power BI Desktop.

Environment: Microsoft SQL Server 2016/2014, Microsoft Excel, SSIS/SSAS/SSRS 2016/2012/2008 , Microsoft Office, Power BI, Microsoft TFS, C#.NET, ASP.NET, VB.NET, ADO.NET, Visual Studio 2017

Confidential, Stamford, CT

SQL Developer/SSIS/SSRS Developer

Responsibilities:

• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Performance Tuning of Stored Procedures and large T-SQL Queries using Clustered Indexes and Efficient Coding standards .
• Figured out the Business Logic and its requirements for the solution of application.
• Formed complex and long stored procedures for both Online and Batch requests handling business logic and Functionality of Various modules.
• Created SSIS packages with Flat file, Excel connections, SQL stored procedures implementing logic, used derived column transformation for converting data types.
• Looping through the files and archiving flat files after the data load to stage tables using SSIS.
• Created numerous SSIS (ETL) packages involving Control Flow, Containers and Data Flow Tasks, Email alerts.
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion.
• Automating the SSIS package execution, Debugging, Error Handling, SQL Stored Procedure and package performance tuning.
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, Cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and Proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
• Automated Excel VBA applications involving spreadsheets, Excel charts.
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Sending Email notifications in case of failed recon execution and success execution of each recon.
• Optimized the performance of SSIS package and SQL stored Procedures for better package execution. Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.

Environment: Microsoft SQL Server 2016/2014, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Microsoft TFS, C#.NET, VB.NET, Visual Studio 2015

Confidential, Des Moines, IA

MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement with MS Visio 2013.
• Involved in integrating different Database Applications using SSIS packages.
• Creating SSIS packages that involves migration from legacy systems to centralized Database.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
• Expert in using the work flow canvas for multiple transformations of data and the use of different features like variables, package configurations, event handlers, error logging and check points to facilitate various complex ETL logics and specifications
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Provide optimized views and queries for Business Objects reports
• Validate data before performing ETL transformations and load into SQL server database.
• Intensively worked on transformations like Derived column, Import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS 2012.
• Used task factory components and transformation like Upsert destination, Update batch transformation, Null Handler Transformation, Surrogate Key Transformation, Advanced Email and SMS Task in SSIS packages
• Worked with Web Service task where some of the binary files will be converted into XML element to place in Message Broker queue.
• Involved in creating SSRS and power view reports.
• Implemented transformation mapping through BizTalk server with the help of Visual Studio to achieve data transformation from one type to another.
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.
• Created stored procedures, Cursors, Joins in T-SQL.
• Manually documented each process and the flow of the package.
• Created Drill-down and Drill- through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.
• Designed VBA macros in Excel to automate data extraction and reporting.
• Created visualization reports and dashboards using Power BI desktop and published them to the Power BI Service.
• Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs. Also to trigger emails about the failure using Email task.
• Designed and created Report templates, bar graphs and pie charts based on the inspection data.

Environment: Microsoft SQL Server 2012, Microsoft Excel, SSIS/SSRS 2016/2012/2008 , Microsoft Office, MS VISO 2015, Profiler, Visual Source Safe, BIDS, C#.NET,VB, Visual Studio, MS BizTalk Server.

Confidential, Parsippany, NJ

Sr. MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Generated various type SSRS reports that could be used to send information to different vendors, clients and managers.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Closely worked with DBA teams in the maintaining the databases and trouble shoots experiencing from the users
• Worked on Data migration project by validating three source data row by row and field by filed
• Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
• Built reports in SSRS for errors generated by SSIS Packages; generated Reports using Data Source Views in Report Builder; created Drill Down, Drill through, linked and sub reports and dashboard reports using SSRS.
• Worked on development of SSIS package to generate excel reports individually and consolidated reports by dynamically passing the carrier ids from the SQL Table in Shared Folder to make available to the business users
• Used transformations like SCD, CDC, Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all etc., to convert raw data into required data meeting the business requirements
• Worked on the fixing the bad data in Legacy Tables in batches, Created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
• Explore data in a Variety of ways and across multiple visualizations using Power BI.
• Widely worked on Script Task and expressions such as to check file availability Confidential the run time and notify by the emails and also created a logic using Script Task to pick the certain date range of the files from the share folder and dynamically pass the file names to the Foreach loop container in SSIS
• Worked on re-design of the few SSIS Package which involved very complex logic and more than a hundred tables and tasks and developed simplified version of the Packages.
• Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results, Sets and Variables wherever they are needed in SSIS.
• Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on the row count transformation or row count expression and Record set Destination and event handlers control flow to populate the special Log tables with high level SSIS package execution.
• Extensively worked on Setting up the Send Mail task on Start, Complete, and Failure of .dtsx package that includes writing the logic to show up the results in the email to quickly verify the cause of the failure in SSIS
• Generated variety of business reports using SQL Server 2008 SSRS including matrix report, parameter report, and dashboard with charts and drill down function.
• Created package configuration in XML and used to deploy packages into SQL server, Identified the Issues that occur during the package execution by redirecting the rows from source component to error output.
• Responsible for the issues raised from the production and debugging and deploying the updates.
• Created Views, Materialized Views to get the values dynamically using joins and other sql queries from the multiple tables.
• Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, C#.NET,VB, BIDS, Visual Studio.

Confidential, Charlotte, NC

MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Developed Stored Procedures, Views, user defined functions, encrypting database tables with column encryption using DES algorithm, Temporary Tables, and table valued parameters and Common table expressions as per the requirement.
• Used XML datatype extensively and performed XML DML operations on the given XML data.
• Excellent command over XML, XSLT and XSD, XML is widely used in edifact, HIPPA.
• Migrated DTSX packages from SQL Server 2008 to SQL Server 2012.
• Experience in creating SSIS packages, deploying the packages to production server using BIDS package deployment wizard and SQL server data transformation services new deployment wizard available with SQL server 2012.
• Experience in developing SSIS packages for administering SQL server.
• Worked on different types of control tasks of SSIS like WMI data task, MSMQ task, Web service task, Script task, Ftp task to upload and download files, worked with different types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also used XML task to validate XML files and XSLT for generating html pages from XML.
• Worked on different kinds of transformations in SQL Server Integration Services (SSIS) like Term Lookup, Merge, Derived column, Cache transform, DQS cleansing, Term extraction, Aggregate, Character map, Pivot and Un Pivot.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
• Excellent report creation skills using Microsoft SQL Server 2005/2008/2012 using Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created different types of reports which involve more number of groupings and multi-value parameters.
• Deploying reports to reports server, proving features for reports to show in PDF format as per the requirement and printing all the reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Designed, Build the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005/2008/2012 (SSAS).
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centres
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time) to avoid and optimize by following the Normalization standards to maintain data consistency and by performing data validation.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environnent: MS SQL Server-2012/2008R2/2008, SSIS, SSAS, SSRS, SQL Profiler, MS Excel, C#.NET, ASP.Net

Confidential, Dublin, OH

MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
• Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
• Assisted in production of OLAP cubes, wrote queries to produce reports using SQL Server 2008R2 Analysis Services (SSAS) and Reporting service (SSRS).
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Performed business data analysis and report creation in support of both ad hoc requests from the customer and to support new development and system maintenance.
• Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
• Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, TFS.

Confidential

MSBI/SSIS/SSRS/ SQL Developer

Responsibilities:

• Communicated with the Business Users to understand the requirements.
• Created Drill reports for the Clean-up Activity followed in the company
• Created reports for calculating the number of hours scheduled and the calculations made for the payment.
• Generated periodic reports from the cube based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
• Wrote queries using MDX
• Deployed and configured the reports in the Report Server.
• Experienced in designing the OLAP systems for data mart applications using SQL Server Analysis Services 2008
• Used stored procedures and user-defined functions for different Reports.
• Wrote complex correlated sub queries to generate reports.
• Wrote User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.

Environment: SQL Server 2008, SSRS 2008, SSAS, Visual Studio 2008, XML, XSLT, MS Office and Visual Source Safe.