SUMMARY

• Over all 9 years of IT work experience in MSBI including designing, implementing databases, data warehousing and data integration processes, extensively worked in Healthcare and Banking domain.
• Pro - actively involved in requirement gathering and converting them into technical solutions. Regularly conducting meetings to track project progress and discuss any risks/restrictions.
• Proficient in identifying risks and providing solutions to handle them while implementing data integration projects with huge amounts of data.
• Experienced in designing database schema using Microsoft SQL Server 2008/2008 R 2/2012/2014. Performed database normalization to create RDBMS databases.
• Excellent ability to write complex SQL queries, stored procedures and views to achieve business requirements. Skilled in analyzing data to provide recommendations on data transfer/migration projects.
• Worked on Data Cleansing, Transformation and Integration using Microsoft BI technologies. Expert knowledge of data extraction, transforming and loading (ETL) using SQL Server integration services (SSIS). Expert knowledge in debugging the SSIS packages and fixing the errors.
• Skilled in designing and modifying analysis services projects using SSAS. Created different types of reports using SSRS. Involved in testing and deploying the SSIS packages on development and production servers. Created dashboards with different types of visualizations using Tableau.
• Worked on different version control systems like TortoiseSVN and TFS. Skilled in performing research activities to find solutions to unseen or unexpected problems. Basic skills to use Java and Python to develop and/or maintain software products.
• Skilled in training business users as part of support activities of on-going and implemented projects. Experienced in implementing Change management related processes by following the checklist and guidelines created.
• Experienced in working with Agile methodology and SCRUM teams. An excellent team player and technically strong person capable to work with any team size. I always work to gain expertise in my skill set and learn new technologies as per project requirements.

Core Competencies

• SQL Server Reporting Tools (SSRS)
• SQL Server Integration Services (SSIS)
• SQL Server databases
• SQL Server Management Studio
• SSIS Packages
• Database tables
• Business requirements
• Microsoft Visual Studio
• JavaScript
• SDLC
• SQL Analytics
• Tableau
• Data modeling
• C#, ASP.Net
• Reporting and Analysis
• Software Development
• Excellent communication
• Industry and Domain.
• FRD/BRD

TECHNICAL SKILLS

Database Skills: Data modeling, Database Normalization, SQL, Oracle

Development Tools: Microsoft Visual Studio, SQL Server Management Studio

SQL Server Tools: SSIS, SSRS, SSAS, SQL Server Management Studio, DTS, MSCS, SQL Server Business Intelligence Studio.

Business Intelligence: Power BI, SSRS (SQL Server Reporting Services), Tableau, Crystal Reports.

ETL Tools: SSIS (SQL Server Integration Services)

Operating System: Windows 8.1/ 8/7/Vista/XP/ NT/2000, DOS, Unix, Windows Server 2003/2007

Data Management Tools: Tortoise SVN, TFS

Programming Languages: C#, ASP.Net, Python, Java, JavaScript

PROFESSIONAL EXPERIENCE

Confidential, Somerset, NJ

SQL BI Developer

Responsibilities:

• Proficient in buildingMicrosoft (MSBI) Business Intelligenceand Corporate Performance Management solutions includingDashboards, Score Cards, Query & Analysis reports, KPIusingMS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), MS SQL Server Reporting Services (SSRS),
• Design and development of data integration packages using Microsoft SQL Server Integration Services (SSIS).
• Create SSIS Packages to extract data from different data sources like OLE DB, CSV, Excel, XML files etc., into different destinations like SQL Server databases, Flat files, Excel files.
• Extensively used various tasks like ‘Execute Package’, ‘Execute Process’ ‘File System’, ‘FTP’, ‘Script’ and ‘Send Mail’ covering most of the major task types available in Visual Studio tool.
• Created SSAS cubes with multiple fact measure groups and hierarchies based on the OLAP Reporting needs.
• Extensive experience in data warehouse processes including, data mapping, data conversion and Extraction/Transformation/Loading usingPentahoand MS SSIS.
• ImplementedSSIS, SSRS, and SSASfordatawarehouse&datamart solutions.
• Used T-SQL in SQL Server 2012 to develop Stored Procedures, User-Defined Functions (UDFs), Indexed Views and DML Triggers to support ETL packages. Preparing Dashboards using calculations, parameters in Tableau.
• Responsible for building Power BI Dashboards using Tabular and Multi-Dimensional Models. Design and model data sets withPower BIdesktop based on measure and dimension requested by customer and dashboard needs.
• Used Socrates’ open data portal to publish various data sets to the public.
• Used Data Sync tool to automate the data sets update functionality on a scheduled basis.
• Work in conjunction with project managers to assign project level tasks to the development team.
• Scheduled Jobs for executing the deployedSSISpackages to update the database on Daily/Weekly/Monthly basis using SQL Server Agent.

Environment: MS SQL Server 2012/2014, SQL Integration Services 2014, MS SQL reporting Services 2014, MS Visual Studio 2017, C#, Data Sync, Business Intelligence Development Studio (BIDS), SSAS, Agile & Scrum, UNIX/Linux Windows 2012 Server, OLAP.

Confidential, Houston, TX

SQL BI Developer

Responsibilities:

• Expertise inSQL Server Integration Services(SSIS) andSQL Server Reporting Services (SSRS) with good knowledge onSQL Server Analysis Services(SSAS).
• DevelopingSSRSreports onSQL Server, Good understanding ofSSAS, OLAPcube and Architecture.
• Translated the existing Reports from Translational to Dimensional inSQL ServerManagement Studio.
• Wrote complex stored procedures to process requirement and generating records between front End and back end.
• Developed variousT-SQLstored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Experience working with Medicare Advantage Organizational Health Plan and also strong inSQL/SSIS.
• Created aSQL Server Reporting Services (SSRS) and SSIS Infrastructure that pulls data from different sources and provides a simple to use reporting environment.
• Developed and maintained multiplePowerBIdashboards/reports and content packs.
• Good knowledge in using transformations like ‘Data Conversion’, ‘Aggregate’, ‘Conditional Split’, ‘Lookup’, ‘Derived Column’, ‘Merge Join’, ‘Sort’, ‘OLE DB Command’, ‘Union All’ and ‘Script Component’.
• Worked on Scheduling and distributing the reports in multiple formats such as Excel, PDF, XML, HTML and CSV using SSRS.
• Implement referential and transactional integrities on database tables.
• Created dashboards using Tableau to provide required information to different business users in the organization
• Responsible for buildingPowerBIDashboards using Tabular and Multi-Dimensional Models. Design and model data sets withPowerBIdesktop based on measure and dimension requested by customer and dashboard needs.
• Monitor database performance and analyze issues, primarily withMicrosoftSQL Server 2012/2014.
• Designed Cubes with Star Schema usingSQL Server Analysis Services(SSAS).
• Involved in Installation, Configuration and Deployment of Reports usingSSRS.

Environment: MS SQL Server 2012/2014, SQL Integration Services 2012/2014, Power BI, MS SQL reporting Services 2012/2014, MS Visual Studio 2013/2015, C#, ASP.Net, Tableau 9.1.

Confidential

SQL Developer

Responsibilities:

• Create SSIS packages to extract and transform data provided by client and load into project database.
• Experienced in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, to MS SQL Server by using DTS and SSIS services.
• Created tables, views, indexes, stored procedures, functions, and triggers by T-SQL codein MS SQL Server Management Studio (SSMS) to make data transformation services (DTS) TEMPeffective.
• Responsible for creating connections to the Oracle Database for the Source and target tables in Informatica to create the sessions. Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Good knowledge of Datasets, Data Marts, Data Warehousing, FACT and DimensionsData Modeling, Star Schema Modeling, and Snow-Flake Modeling. Familiarity of SSAS, OLAP Cube, Dimensions andData WarehouseArchitecture.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Created linked reports, sub-reports, drilldown and other advanced reports.
• Worked on fixing the errors in existing reports.
• Responsible for deploying and managing reports on Report Server.
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, SQLCMD and SMO.
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS).
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV.
• Generate reports with parameters, sub reports, cross tabs, charts using Crystal Reports.

Environment: SQL Server 2008 R2, SSIS, SSRS, SSAS, OLAP, OLTP Performance Point Server, SQL Server Business Intelligence Development Studio (BIDS), T-SQL, C#, MS Excel, Tabular, Python code, Windows 2000 Server, T-SQL.

Confidential, Los Angeles, CA

SQL Developer

Responsibilities:

• Actively participated in gathering of user requirement and system specification.
• DevelopETL/BIprocesses using standard SSIS template (version 2 & 3) in Business Intelligence Development Studio .
• Created and implemented a Data Warehouse system converting Excel, MS Access database, and Text file into SQL database (SSIS Packages) to generate reports.
• Expertise in creating cubes with dimensions and facts tables in MOLAP Warehouse usingSQL Server Analysis Services (SSAS)
• Implemented Custom Logging, Auditing and Custom Email Notifications using SSIS 2008.
• Created and implemented a new Data Warehouse system converting Oracle, Excel and Text file into SQL database in Los Angeles site.
• Generated multi-parameterized reports in SSRS allowing users the ability to make selections before executing reports.
• Designed SSIS Packages to transfer data from flat files, Oracle databases and Excel files to SQL Server using Business Intelligence Development Studio.
• Experience in writing VB scripts for user define functions in SSRS.
• Design database tables and perform normalization.
• Created documents including the description and screenshots explaining the purpose of the SSIS packages.
• Extensively used SSIS transformations and Tasks such as Foreach Loop, FTP Task, Lookup, Derived Column, Data conversion, Aggregate, Conditional Split,SQL Task, Script Task, Send Mail Task, etc.
• Created SSIS Packages for extracting, cleaning, transforming and loading data fromUNIX toSQLServer.
• Tuned theSQLqueries usingSQLprofiler. Involved in tuning the database. Created necessary indexes to make data retrieval process faster.
• Filtered incorrect data from legacy system using complex T-SQLstatements, and implemented various constraint and triggers for data consistency.
• Generated various Drill-through reports, parameterized reports, sub-reports and linked reports using SSRS.

Environment: SSIS Packages, Sql Server, MOLAP Warehouse, SSAS, SSRS, T-SQL, UNIX, VB Scripts, MS Access, Oracle, Business Intelligence