SUMMARY:

• Working as Senior SQL Server Developer/MSBI Consultant, I've been working with various facets of Software Development over 14+ years of diverse experience .Highly motivated SQL server Architect, Technical lead and Senior Developer experience in Database and Business Intelligence Technologies (MS BIDS) with expertise on ETL process and Reporting using SQL Server 2014/2012/2008, SSIS, SSRS and knowledge in SSAS.
• Technical Expertise in troubleshooting SQL issues. Architect in Database design and Database modelling, OOAD, Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager/ Management Studio/SQL Server Data Tools. Experience in Performance Tuning and Query Optimization. Experience in writing complex T SQL queries involving multiple tables inner and outer joins. Experience in Creating Tables, Views, Triggers, Stored Procedures, User Defined Functions and other T SQL statements for various applications. Worked Extensively on ETL process using SSIS package.
• Excellent in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, DB2,ORACLE, Sybase, Access, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, C# script /VB.net script, merge and union all. Expert in designing complex reports like reports using Cascading parameters, Drill - Through and Drill down Reports, Parameterized Reports and Report Models and Adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement. Worked extensively on deploying the reports in various Server tools like SharePoint Server 2010/2013, SQL Server Native Mode and Control M etc., Proficient in data warehouse concept, fact and dimension tables. Experience working with ORACLE, DB2 and Sybase. Played multiple roles performing functional, development, testing activities. Exert in Database design, modelling, installing, upgrading SQL server and Server Configuration, Extensively worked on Database Backup, Recovery & Replication,
• Knowledge of Agile/Scrum working methodology, SQL Server Master Data Services (MDS), Data Quality Services (DQS), High Availability (HA), Disaster Recovery (DR), Always On and BI Semantic Model (BISM), Multidimensional, Tabular. Knowledge of Microsoft Power BI tool (Power View, Power Pivot, Power Query, Power Map), Working knowledge Web Services in SSIS data flow component using URL, Working knowledge of BMC Remedy ticketing system and E Support IT Service Management Tool (ITSM), support for internal incident/ change management system.

TECHNICAL SKILLS:

Operating Systems: Windows XP / 2008 R2, Windows Server 2012 R2, Windows 7/ 10

GUI: VB6, .Net

ETL: SSIS

Reporting: SSRS, Crystal Reports XI

Script Languages: C#,VB.NET Scripts, MDX & T SQL, Shell Script

Database: SQL server 2008 R2/2012/2014, MS Access, DB2, Sybase, Oracle

Tools: & Utilities: COM, MS Visual SourceSafe (VSS), SharePoint Server 2010/2013, Citrix, Team Foundation Server (TFS), VBA, Control M, BMC Remedy, E Support, ITSM. Visual Studio 2013/2015, REDGATE 3.0, SQL Server Data Tools (SSDT)/ BIDS/SSDT, Power BI, COUPA, SFTP, Multiple Hash, FileZilla, ServiceNow.

Domain Knowledge: HealthCare, Health Insurance, Hospitals, Consumer Finance, Superannuation, Oil and Gas & Cards

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr MSBI Developer

Environment: SQL Server 2014, COUPA, COZYROC SFTP, Multiple Hash, FileZilla, SSIS, SSRS, T SQL, MS Visual Studio 2013, C#/VB.net, SQL Server Data Tools/BIDS (SSDT), Power BI, Power Builder, REDGATE SQL Source Control, TFS, Excel, Remote Desktop Connection (RDC), Windows Server 2012 R2, SharePoint Server and Windows 10 Enterprise, ServiceNow.

Responsibilities:

• Understanding the Business team requirements for loading the data from different source system ((CGC, BDMS, SAP, Master Builders & Kingsport’s Viewpoint)
• Participated in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Created Schemas, Tables, Stored Procedures, Triggers, Functions, Indexes, Views, Synonyms and other T-SQL code and SQL joins for applications.
• Migrating/Rewriting the SSIS & SSRS reports to newly created SQL DW Server 2014
• Created a DTSX\SSIS ETL solution to feed an OLAP database from different ERPs (CGC, BDMS, SAP, MB & Viewpoint).
• Created SSIS Packages to Extract and load data from and to different sources and targets like SQL Server, Text Files, Excel and CSV feed them to COUPA cloud server.
• Assisted in Implementing the COUPA Cloud application system with ERPs (CGC, BDMS, SAP, MB & Viewpoint) through the middleware using SSIS/SSDT VS 2013
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup, Sort, Union All, Data Conversion, Script component to load data into Data Warehouse.
• Worked on different SSIS Tasks like FTP & SFTP (COZYROC tools), Multiple Hash(MD5) Execute SQL, Execute Process, Script Task, File System, Send Mail Task also worked on Sequence & For Each Loop Containers
• Design and development of SSRS. Drill Down, Drill Through, Sub Reports, and Matrix Reports
• Created scripts to assign values to variables at runtime.
• Worked with Integration services Event Handlers, Log Providers.
• Reviewing/Validating Data across all the Source and Target databases as the ETL Packages Execute.
• Working on regular maintenance activities, regular support for internal incident/ Tasks

Confidential, Pittsburgh, PA

Sr MSBI Developer

Environment: SQL Server 2012, ORACLE, MS Access, SSIS, SSRS, Crystal Reports, T SQL, MS Visual Studio 2012, C#/VB.net, SQL Server Data Tools/BIDS (SSDT), Power BI, REDGATE SQL Source Control, TFS, Excel, Remote Desktop Connection (RDC), MS Dynamics, Windows Server 2008 R2, SharePoint and Windows 7 Enterprise

Responsibilities:

• Understanding the Business team requirements for loading the data from different source system to HealthPlanet Database
• Created Schemas, Tables, Stored Procedures, Triggers, Functions, Indexes, Views, Synonyms and other T-SQL code and SQL joins for applications.
• Integrating the Database projects with TFS and Red gate Source Control from SSMS.
• Created a DTSX\SSIS ETL solution to feed an OLAP database from different environments.
• Created SSIS Packages to Extract and load data from and to different sources and targets like Oracle, SQL Server, Text Files, Excel and CSV.
• Data migration from SQL Server 2008 to 2012 using DTS/Import & Export tools
• Migrating/Rewriting the SSIS & SSRS reports to SQL Server 2012
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup, Sort, Union All, Data Conversion, Script component to load data into Data Warehouse.
• Worked on different SSIS Tasks like Execute SQL, Execute Process, Execute Package, Script Task, Bulk Insert, File System, FTP Task and Send Mail Task also worked on Sequence & For Each Loop Containers
• Design and development of SSRS/Crystal reports. Drill Down, Drill Through, Sub Reports, and Matrix Reports
• Worked with Integration services Event Handlers, Log Providers.
• Consuming the Web Services in SSIS/ETL script component as source data through the URLs
• Logging the DTSX\SSIS ETL packages to maintain consistency between source and target.
• Working on regular maintenance activities, creating/maintaining PBIs (Production Backlog Items) and Tasks, regular support for internal incident/ change management system/ ISD team -Information Services Division.
• Deployed the SSIS ETL Packages in various environments like DEV and Test through the SQL Agent and configured them on Nightly job process
• SQL Server installation, configurations, backup/restore, Maintenance Plans and handled databases Monitoring SQL Server agent jobs and troubleshooting the failed job

Confidential

Team Lead MSBI

Responsibilities:

• Installing and Configuring SQL Server on Windows systems.
• Participated in Architectural designing for creating Databases and data base objects
• Created Schemas, Tables, Stored Procedures, Triggers, Functions, Indexes, Views, Synonyms and other T-SQL code and SQL joins for applications.
• Implementing the Business team requirements for loading the data from different source system to Target database using ETL/SSIS packages
• Created SQL Server Integration Service (SSIS) ETL packages to export and import data from various source systems to SQL Server included getting the inputs from structural design converting into documents and architect planning.
• Customize and configure ETL jobs to Schedule the SSIS Package Using SQL Server Agent.
• Created Parameterised reports and Linked reports using SQL Reporting Services (SSRS)
• Design and development of SSRS reports connecting to SQL Server database.
• Creation of Stored Procedures required by the various ETL/ Reports to retrieve data from the database.
• Extensively worked on Database/schema design and Database modelling
• On Call DBA support
• Worked on the ADHOC -Query Requests based on the requirement by using Joins, Sub Queries

Environment: SQL Server 2012, MS Access, SSIS,SSRS, T SQL, MS Visual Studio 2010, SQL Server Data Tools/BI (SSDT), Remote Desktop Connection (RDC), SharePoint, Secure Access SSL VPN, TFS, Microsoft Dynamics, Windows Server 2008 R2, and Windows 7 Enterprise

Confidential

Sr Developer BI

Responsibilities:

• Participated in Data base/schema design and database modelling
• Installing and Configuring SQL Server on Windows systems.
• Stored Procedures, User Defined Functions, Views, T SQL Scripting for complex business logic.
• Created Parameterised reports and Linked reports using SQL Reporting Services (SSRS).
• Design and development of SSRS reports connecting to SQL Server database.
• Creation of Stored Procedures required by the various reports to retrieve data from the database.
• Creation of Data driven Report subscriptions on a scheduled basis.
• Deployed the reports at Client place in various environments like DEV and Test on SharePoint Server

Environment: SQL Server 2008 R2, T SQL, SSRS, MS Visual Studio 2008, SQL Server BIDS, Remote Desktop Connection (RDC), SharePoint, Secure Access SSL VPN, TFS, Windows Server 2008 R2, and Windows 7 Enterprise

Confidential

DBA/BI Developer (SSRS/SSAS/SSIS)

Responsibilities:

• Installing and Configuring SQL Server on Windows systems.
• Design and development of SSRS reports connecting to Cube database.
• Created and managed OLAP Cubes using SSAS
• Identified the Dimension, Fact tables and designed the Data warehouse using Star Schema
• Creation of Tabular and Chart types of reports as per requirements.
• Creation of Excel/Power BI Reports as and when needed.
• Expertise in Database schema design and Database modelling, well versed with database design concepts.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL /MDX parameters.
• Developed dashboard reports using Reporting Services, Report Model/Power BI and ad-hoc reporting using Report Builder.
• Deployment of the reports in the Target Reporting Server folder/URL on SharePoint Server 2010

Environment: SQL Server 2012, SSRS, SSAS, MDX, Power BI, T SQL, MS Visual Studio 2010, SQL Server Data Tools/BI (SSDT), SharePoint Server 2010, TFS, Remote Desktop Connection (RDC), Windows Server 2008 R2, and Windows 7

Confidential

Lead SQL BI Developer

Responsibilities:

• Created SQL Server Integration Service (SSIS) packages to export and import data from various source systems to SQL Server.
• Importing Source/Target tables from the respective data base by using Execute Package Task using Control flow tasks in SQL Server 2008 Integration Services.
• Used transformations like Derive Column, Conditional Split, Aggregate, Row Count, Lookup, Sort, Data Conversion and Script Task to load data into Data Warehouse.
• Used different destinations like OLE DB Destination, Flat file, Excel destinations and different sources like OLE DB Source.
• Scheduled the ETL Package Using SQL Server Agent.
• Design and development of SSRS reports. Participated in developing the reports like Drill Down, Sub Reports, and Matrix Reports using SSRS.
• Creation of Tabular, Matrix, and Chart types of reports as per end user requirements.
• Creation of Report subscriptions on a scheduled basis. Creating users and assign roles for the deployed reports using report manager.
• Creation of Views and Stored Procedures required by the GUI components to retrieve data from the database.
• Extracting the data from Span table into Access database, Oracle and SQL Server based on the requirement using ODBC Connections.
• Working on regular maintenance of UNIX application tracked through MRF (maintenance request form).
• Migrating the data from SPAN database into SQL Server.

Environment: SQL SERVER 2008, MS Access, ORACLE, T SQL, SSIS, SSRS (MS BI), MS Visual Studio, Secure CRT/SUPERB, ISM, VB6, Windows 2003/XP and Windows 7

Confidential

BI Implementation Consultant

Responsibilities:

• Requirement Analysis design and development
• Test case design and Testing
• Provide Training for the Team
• Creating the technical design
• Developed Complex SSIS package and support for existing projects.
• Developed complex Reports to meet the customer criteria connecting to SQL Server database 2005/2008 and ORACLE
• Developed complex SQL queries, stored procedures,

Environment: SQL Server 2005/2008, ORACLE SSIS, T SQL, MS Visual Studio, SSRS, TFS, Windows 2003/XP

Confidential

Lead MS BI Sr Developer

Responsibilities:

• Analysis of Business requirements
• Creating the technical design
• Developed Complex SSIS package and support for existing projects.
• Developed complex Crystal Reports to meet the customer criteria connecting to ORACLE,DB2,Sybase and SQL Server database 2005
• Developed complex SQL queries, stored procedures,
• Worked on optimization and tuning of SQL queries and indexes
• Reviewed VB applications, SSIS packages and database design for compliance with best practices standards
• Supported business functions through use of internally-developed and third-party software solutions
• Weekly calls with onsite team for status update on the deliverables

Environment: SQL Server 2005, ORACLE, DB2, Sybase, SSIS, T SQL, MS Visual Studio, VB6, Crystal Reports XI, TFS, MS Visual Source Safe, Windows 2003/XP and Control M

Confidential

SQL Server DBA/BI Developer

Responsibilities:

• Analysis of Business logic implementing same in technical specifications.
• Developed Complex SSIS packages for development of OLAP database from OLTP source.
• Developing Batch data flow process using Incremental extraction methodology
• Performed database design by analysing business requirements
• Developed complex SQL queries, stored procedures, and Job scheduling using server agent
• Worked on optimization and tuning of SQL queries and indexes
• Assisted in the application development, debugging, configuration, and optimization from database perspective
• Reviewed applications and database design for compliance with best practices standards
• Assisted in troubleshooting and resolution of database issues
• Supported business functions through use of internally-developed and third-party software solutions

Environment: SQL Server 2005, SSIS, T SQL,MS Visual Studio, Crystal Reports XI, TFS, MS Visual Source Safe, Citrix, IBM Clear case, Windows 2003/XP

Confidential

Team Member

Responsibilities:

• Analysis of Business logic implementing same in technical specifications.
• Performed database design by analysing business requirements
• Developed complex SQL queries, stored procedures
• Development support for the Parts project,
• Developed Proof of concept for the newly designed project, which manage turbines history

Environment: SQL Server 2005, SSIS, MS Access, VBA, MS Visual Studio, Crystal Reports XI, TFS, MS Visual Source Safe, Citrix, IBM Clear case, Windows 2003/XP

Confidential

Team Member

Responsibilities:

• Understanding the business requirement
• Developed & Performed Data transformation in MS SQL Server by using DTS tool
• Testing DTS packages over the networks using FTP
• Maintenance support for the existing tools based on the requirement

Environment: SQL Server 2000/2005, DTS, Windows 2003/XP

Confidential

Team Member/Database Developer

Responsibilities:

• Analysis of Business requirements
• Developed SQL queries, stored procedures,
• Development support for the Leaps Module, Testing and Development Support for the DTS Packages
• Performance tuning the Stored procedures and SQL statements which are used in DTS
• Maintenance support for the DTS Packages tools

Environment: SQL Server 2000, DTS, Omnis Studio, Citrix, Vb.net, VB6, Version Control System, Windows 2000/XP

Confidential

Team Member/Developer

Responsibilities:

• Developed database applications Programming Using T-SQL in MS SQL (stored procedures, triggers, data integrity constraints, etc.)
• Performed Database Backup, Recovery
• Performed Data transformation from Heterogeneous data sources to SQL Server by using DTS Wizard
• Performed all Replications based on requirement
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Performance tuning the Stored procedures and SQL statements which are used in DTS
• Maintenance support for the DTS Packages tools
• Analysis of the specifications provided by the clients
• Design and Development
• Coding using VB6, COM and SQL programming
• Database management and ODBC connectivity
• Testing - unit testing & integration testing
• Responsible for overseeing the Quality procedures related to the project.
• Client site for implementation.
• Product development for the Billing related modules like Inpatient Billing, Front Office, Administration, ADT and Account receivables.
• Development support for the existing version 1.0 and version 2.
• SME Healthcare & Hospitals

Environment: SQL Server 2000, DTS, VB6, Source Safe, Windows 2000/XP/NT