SUMMARY:

• Around 7 years of IT experience which includes Analysis, development, design, support, and implementation of applications, Reports, and Databases of Microsoft SQL Server 2014, 2012, 2008R2, 2005 in Production ENVIRONMENT.
• Experience in Software Development Life Cycle (SDLC), Software Test Life Cycle (STLC) and Defect Management Life Cycle.
• Expert in writing T - SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing Data Migration and Power BI.
• Proficient in designing highly flexible Database Architectures and Data Modeling, Data Mapping, Table Normalization, Optimization, and Tuning.
• Extensive experience in writing and debugging complex stored procedures, cursors, triggers, Inner Joins & Outer Joins, views and user-defined functions.
• Expertise with continuous integration and nightly deployments using TFS with a Test Driven Design approach
• Good understanding and designing of Star and Snow Flake data models Schema used in relational, dimensional and multidimensional data modeling.
• Involved in designing, developing and testing of the ETL (Extract, Transformation, and Load) strategy to populate the insurance data from various source systems
• Excellent understand of data mining algorithms, high performance, and optimal algorithms.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources
• Migrated data in various formats like text based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints
• Having Good knowledge on Tableau reports.
• Proficient in MS Office suite, Visual Basic, MS Access.
• Using Power Pivot connect to databases, Excel, Access, text files data from the web.
• Administered MySQL database installation, upgrades, performance monitor, tuning, backup and recovery.
• Very good experience in developing reports using SQL Server 2008 Reporting Services (SSRS).
• Hands on experience in creating Parameterized reports and Linked reports with a thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Proven ability in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2012.

TECHNICAL SKILLS:

RDBMS/OLTP: MS SQL Server 2008/2008R2/2012/2014/2016, MySQL, Oracle 10g/11g, MS Access

ETL: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), SQL Server Data Tools (SSDT), Business Intelligence Development Studio (BIDS), Data Quality Services (DQS), Data Profile Viewer

Data Warehouse/OLAP: SQL Server Analysis Services (SSAS)

Tools: Citrix, FortiClient, Visual Studio 2008/2010/2012, SharePoint 2010, SPSS

Version Control System: Team Foundation Server (TFS) 2008/2010/2012, GitHub

Language: Transact-SQL (T-SQL), MySQL, JAVA, C#

Reporting: SQL Server Reporting Services (SSRS), Microsoft Report Builder 3.0, Excel 2003/2007/2013/office365, Tableau 8, Oracle PeopleSoft HCM 9.0/9.2, IBM Cognos BI 8/10, Power BI

Testing: User Acceptance Testing

.NET Technologies: ASP.NET, AJAX, JavaScript, CSS, HTML5, XML

PROFESSIONAL EXPERIENCE:

Confidential, Bluebell, PA

Sr. SQL server/ SSIS/SSRS Developer

Responsibilities:

• Involve in Complete Software Development Life Cycle (SDLC).Execute and coordinate requirements management and change management processes.
• Apply extensive knowledge of the client’s business and industry to develop requirements specifications.
• Document requirements, and translate into proper system requirements specifications using high- maturity methods, process and tools.
• Write and test high-quality, maintainable code using T-SQL and Microsoft BI Tools(SSIS/SSRS/SSAS)
• Responsible for performance tuning of T-SQL Stored procedures and SSIS packages.
• Responsible for creating Data warehouse and loading data from Microsoft Azure.
• Migrated DTS packages to SSIS and modified using DTS editor wizard.
• Successfully used Import and export wizard to move data from excel sheet to table in SQL Server Management Studio. Update and load data in the tables, remove duplicates in the excel sheets before moving data into the table.
• Developed dashboard reports using Reporting Services.
• Developed various Charts and Graphs like bar charts, line charts, pie charts by using chart experts for Business Intelligence needs in SQL Server Reporting Services.
• Designed Usage summary and Detail reports in SSRS and responsible for the deployment of the reports on the reporting services website
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files.
• Optimize the query performance by using Query optimizer, execution plan, SQL Server Profiler and optimizing techniques.
• Involved in the performance tuning and optimization of T-SQL queries.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Troubleshoot data integration and data quality issues and bugs, analyze reasons for failure, implement optimal solutions, and revise procedures and documents as needed

ENVIRONMENT: SQL Server 2015, Microsoft Azure, T-SQL, SQL,, SSRS, SSIS, Windows Enterprise Server 2007, Power BI,SQL squirrel, MS-Access, Excel, VBA, JIRA,SQL Server 2012

Confidential, NY

Sr. MSBI Intelligence Developer

Responsibilities:

• Actively collaborate with users, Team leads, and technical managers to fully understand the requirements of the system.
• Analyze the business requirements and involved in the design and implementation of Design Documents
• Expertise in business Process Health Care Sector with Membership, claims, Payments, provider, eligibility and prior authorization for Medicaid and Medicare programs.
• Create new Tables, Stored Procedures and Functions, user defined data types as per the technical document Modified existing Stored Procedures as per new business requirements
• Create joins and sub-queries for queries involving multiple tables.
• Generate Reports required by the users, which includes table, matrix, chart, Document Maps.SQL Server Migration and upgrade from SQL Server 2005 to 2008R2, SQL server 2008R2 to SQL Server 2012, SQL server 2012 to SQL Server 2014.
• Developed interactive reports using SQL Server Reporting Services.
• Preparing Dashboards using calculations, parameters in Tableau.
• Used Profiler, Index Wizard and Performance Monitor for performance tuning on SQL Server.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes
• Wrote SSAS cube with MDX and DAX.
• Developed SSIS packages for migrating data from staging area of SQL Server 2005 to SQL Server 2008R2 and SQL Server 2008 R2 to SSIS 2012.
• Installed and administered Microsoft SQL Server Integration Services, SQL Server Reporting Services, and TFS.
• Design and Developed new SSAS Tabular Models, which uses xVelocity (formerly Veritpaq) in-memory engine.
• Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, and Charts.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Design and development of SSAS Tabular cubes to satisfy the end user reports by creating various types of reports and dashboards in Power BI.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS various features like multitasking, conditional split, union, union all, merge, lookup, fuzzy lookup, data conversion etc.
• Generate Reports using Global Variables, Expressions, and Functions for the reports.
• Responsible for scheduling the subscription reports with the subscription report wizard.
• Design and develop the highly complex BI solutions on the Microsoft Business Intelligence stack (SSRS, SQL Server Database, SSIS)
• Design and developed ETL( Extract, Transformation and Load ) processes, programs and scripts to migrate data from different sources (SQL Server, Flat Files, Excel source files, XML files etc.) into destination tables using the transformations
• Extract complex data from multiple data sources into usable reports and analyses by implementing stored procedures and SQL queries
• Involved in the performance monitoring and tuning and production support related to SQL, ETL and BI Reporting environment.

ENVIRONMENT: SQL Server 2012, TOAD, T-SQL, SQL,, SSRS, SSIS, Windows Enterprise Server 2007, Power BI,SQL squirrel, MS-Access, Excel, VBA, JIRA,SQL Server 2012

Confidential, Greenwood Village, CO

Sr. MSBI Intelligence Developer

Responsibilities:

• Created various databases like SQL queries, views, Custom functions and stored procedures for application
• Development & reports distribution using SQL Server 2016.
• Interacted with SMEs to understand system and implement the solution for restricting users from accessing data.
• Created various stored procedures using Dynamic SQL for implementing client specific validations.
• As part of ETL package development, created packages to process claims transactions from various clients in various file formats.
• Developed tabular queries for efficient analysis of report using Pivot/Un pivot in T-SQL.
• Tested and validated HIPPA compliance and HI-7 messages requirements in the application.
• Experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, Relational Database Models and Data Integrity, SQL joins.
• Used SQL Server Profiler to tune the performance of existing SQL objects like stored procedures, complex
• Built a Tabular model cube from scratch data and by multi-dimensional expression (MDX) queries fetched data to SSRS and Power BI reports.
• Involved in creating MDX,DAX, Cubes and Tabular models using SQL Analysis Services (SSAS).
• Sql scripts etc. Created indexes to improve the performance of sql scripts.
• Created various database objects like SQL queries, views, custom functions and stored procedures for application development & ETL using SQL Server 2008R2 and later.
• Created SSIS packages for Uploading of different formats of files (Excel, Access, dbf) and databases (SQL server, Flat files) into the SQL Server data warehouse using SQL Server Integration Services (SSIS).
• Migrated SQL Server 2008 database to Windows Azure SQL Database.
• Created Azure SQL database, performed monitoring and restoring of Azure SQL database.
• Performed migration of Microsoft SQL server to Azure SQL database.
• Used slicer and dicer in excel to filter and grouping data.
• Writing multi-dimensional expression (MDX) queries to get the data from a tabular model.
• Hands on experience in creating OLAP cubes using SQL Server 2012 analysis services (SSAS).
• Involved in design and implementation of entire EDI system and System Design documentation
• Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors on databases SQL and MySQL
• Experience in Aginity Netezza workbench and Google analytics report
• Worked on generating the monthly and yearly financial reports. Expert in using advance Excel functions including the lookup, pivot tables and formulas. Created tables in access database for data analysis and report generation.
• Design visually and interactive reports using power view.
• Create powerfully and customized data visualization reports/dashboards using PowerBI
• Developed Power Shell Scripts to automate daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and in indexing updates.
• Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database.
• Performing daily tasks including backup and restore by using SQL Server 2014/2012 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

ENVIRONMENT: SQL Server 2014/2012, MySQL, TOAD, T-SQL, SQL, SAS, Toad, SSRS, SSIS, Windows Enterprise Server 2007, Power BI, Linux, Hadoop, SQL squirrel, MS-Access, Excel, VBA, JIRA,SQL Server 2012 R2/2008 R2, and Azure SQL Data Warehouse.

Confidential

SQL Server BI Developer

Responsibilities:

• Extract, Transform and Load source data into respective target tables to build the required data marts.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL join for applications following SQL code standards.
• Implemented different types of constraints on tables.
• Designed and applied entity and attributes description and definition for the models.
• Managed indexes, statistics, and tuned queries by using execution plan for optimizing the performance of the databases.
• Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
• Created ETL process using SSIS to transfer data from heterogeneous data sources.
• Created logging for ETL load at the package level and task level to log the number of records processed by each package and each task in a package using SSIS.
• Migrated DTS objects to SQL Server Integrated Services (SSIS) environment.
• Designed ETL packages for different data sources (SQL Server, Flat Files, and XMLs etc).
• Managed the entire ETL process: involved in access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers
• Created SSIS Packages to import and export data from Excel, Access and Text files.
• Developed new mappings using Look Up/Aggregation transformations to match the needs of the business case.
• Designed slowly changing dimension transformations (SCD) and customized the existing mappings.
• Built SSIS Packages to transfer data in and out of the Extract, Stage and Production Servers.
• Responsible for maintaining of system monitoring tools and integrations, which includes the analysis of SCOM, systems center orchestrator and third party integration failures, performance.
• Developed PowerShell Scripts to automate daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and in indexing updates.

ENVIRONMENT: MS SQL Server 2012/2008R2, 2008/2005 SSIS, SSRS, SSAS, Visual Studio 2010/2008, T- SQL, Windows Server 2008 R2, Visual Source Safe 2005 (VSS), XML, ADO.NET, ERWIN, PL/SQL, MS-Access, MS-Excel

Confidential

SQL Developer

Responsibilities:

• Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation Languages (DML/DDL) implementing constraints and triggers for data integrity in development database for the personal banking system.
• Installed SQL Server 2005 with latest Service Pack and established connectivity with the database created, configured and maintained database maintenance plans and also database backup and recovery.
• After installing the SQL server 2005, migrated the existing DTS packages into SSIS packages using SSIS services provided by SQL Server 2005 Manager studio.
• Worked on other packages of the SQL server 2005 Edition SSRS (SLQ Server Reporting Services),
• Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created and maintained Database Maintenance plans and also created logins and assigned roles and granted permissions to users and groups.
• Designed new dynamic DTS Packages to transfer data between servers, load data into the database and tuned the existing packages.
• Worked in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications. Developed complex TSQL code for the application.
• Migrated the data from an existing MS Access database into an enterprise edition of SQL Server 2005.

ENVIRONMENT: DB2, SQL Server 20005 Enterprise, Windows Enterprise Server 2003, IIS 6.0, .NET framework, Erwin, Microsoft Visio 2003, SFTP, Microsoft Reporting Service (SSRS).