SUMMARY

• Highly skilled IT professional with 10+ years of demonstrated expertise spearheading mission - critical data and application management projects for leading services companies.
• Expertise in building MS Business Intelligence and Analytics solutions for insurance, financial, educational, and administrative data.
• Expertise in building and administering relational database systems and it’s ETL, SQL Codes for large transactional and non-transactional data.
• Expertise in designing and developing Database/Datawarehouse/Datamart/SSAS Cubes.
• Expertise in data conversion, such as from SQL Server/Oracle/DB2/XML/CSV/duck creek to SQL Server.
• Expertise in data/ Business Intelligence and Analytics solutions migration, such as from SQL Server 2008R2 to SQL Server 2012/2014/2016
• Expertise in physical/logical data modeling using Erwin
• Expertise in implementing, configuring, installing and maintaining Servers/SQL Server instances such as SQL Server 2008 R2 on Windows Server 2008 R2, SQL Server 2014 on Windows Server 2012
• Expertise in database/ETL performance improvements using SQL Server profiler, SQL Server tuning adviser, and Windows Performance Monitor.
• Extensive experience in Analytics report creation with thorough knowledge of report server architecture using SSRS, Yellow-fin, Power-BI.
• Extensive experience with AWA and Azure: Configuring and maintaining SQL Server Databases and its stand alone and named Instances over cloud.
• Expertise in programming languages T-SQL, PL-SQL, My-SQL, Batch Programming, C#, .Net, Python.
• Expertise in SQL Server administration: Security, Installation, Maintenance
• Expertise in using tools: Visual studio 2008/2012/2013 , SSIS 2005/2008/2012/2014 (DTS), SSMS, SQL Server Profiler, SQL Server Tuning advisor, SSRS, SSAS, Erwin, SQL Developer, TOAD, Winnows event logs, windows performance monitor, Yellow-fin, Power-BI, Jupyter notebook,TFS, SVN, JIRA, Visio, Hyper-V
• Highly professional to implement latest and best practices to build high performance MS Business Intelligence/Analytics solutions, relational /Datawarehouse/Datamart databases.
• Excellent at Verbal and written skills.
• Experience handling Off-shore resources.
• Expertise in Database server, Databases and ETL Tuning for large transactional and non-Transactional databases.
• Expertise in Private/Commercial/General P&C Insurance business intelligence products.

TECHNICAL SKILLS

Programming Languages: T-SQL, MDX, PL/SQL, C, C#, JAVA, HTML, XML, Batch Programming & CSS, MySQL, Python(Panda), Batch programming

Databases: SQL Server 2016/2014/2012/2008 R2/2005/2000, Oracle 10g/8i & MS Access,db2

Database Tools: SSMS, SQL Query Analyzer, SQL Server Profiler, SQL Server Tuning Adviser, SQL compare and SQL Developer, Jupiter notebook.

ETL Tools: SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Import Export Wizard & Bulk Copy Program (BCP).

OLAP Tools: SQL SERVER Analysis Services(SSAS) 2005/2008/2014

Reporting Tools: SQL Server Reporting Service (SSRS) 2005/2008 & Crystal Reports, Share-Point, Power-BI.

Modeling Tools: Erwin 7.3.6, MS Visio & Rational Rose.

Other Tools: MS Visual Studio 2005/2008,2012,2013, TFS, Visual Source Safe & Eclipse, Hyper-V

Operating Systems: Windows 98/2000/2003/ XP/Vista/7/NT,, Windows 8, Windows 10, Windows Server 2008, Windows Server 2012,Mac OS, Ubuntu.

Web Technologies: ASP.NET & Servlets, Azure, AWS.

PROFESSIONAL EXPERIENCE

Confidential

Sr. SQL Server BI Developer/Database Analyst

Responsibilities:

• Gathering business requirements and working in conjunction with the data warehouse architect in the development of logical and Physical data models of Staging, Data warehouse, DataMart, GRD Database using Erwin. This included Reverse/Forward engineering, complete comparisons, Schema Reports of databases using Erwin.
• Involved in product development lifecycle management and development for NexGen BI Products Cover-all BI, EDW/MBA product .
• Involved for moving current Business Intelligence Solutions over azure and AWS.
• Responsible for in designing and developing ETL architecture using SSIS/SSDT for Cover-all BI, and Cover-all Confidential EDW/MBA product .
• Responsible for designing and developing Batch Processes (Run Engine) for Cover-all BI, EDW/MBA product .
• Design and development of Reconciliation Engine and automated validation Process. This effort included writing Multidimensional Expressions (MDX) to reconcile Cube data and creating various financial and validation repots using MS SQL Server Reporting Services 2008 R2.
• Responsible for writing complex Store Procedures, Functions, CTEs, Merge Statements, pivot, un-pivot functions (Operators) and Rank Functions.
• Responsible for maintaining databases and its objects on development, build and production servers.
• Responsible for configuring and monitoring Servers and SQL Server instances on them.
• Solid experience in resolving QA/UAT technical and data issues.
• Responsible for communicating with clients, gathering requirements, design and develop ETL, delivering releases.
• Responsible for creating user guides for installing IAF/EDW/MBA product.
• Responsible for setting environment for company BI products, testing, debugging and fixing issues.
• Responsible for migration of BI analytics solution from SQL Server 2008 to 2012/2014/2016 : Database, ETL, C# code on .net framework (respective .net framework).
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Expertise on migration and Data conversion projects: db2 to SQL Server, Oracle to SQL Server, SQL Server 2008 to SQL Server 2012/2014/2016 .
• Configured and Installed Database servers: Installing OS/ visual studio / SQL Server Engine and other features/ BIDS-SSDT/support and maintenance.
• Responsible for migration of Cover-all product from Microsoft SQL Server 2008 platform to 2012 and 2014.
• Responsible for designing and creating Analytics Dashboard reports from EDW and MBA using Power-BI and Yellow-fin.
• Responsible to review and confirm products: Analytics solution (Databases designed and developed, ETL developed, and data sanity check.)
• Responsible for Production support for Clients.
• Expertise in Performance tuning for large databases.
• Experience in querying Hadoop database.
• Assisted developers with complex query tuning and schema refinement.
• Managed offshore resources.
• Responsible for requirement gathering, development, testing and deployment to production and support.

Environment: SQL Server 2005/ 2008 R2/ 2012/2014/2016 , MS Visual Studio 2005/ 2008/2012/2013 , Windows 98/XP/Vista/7/Windows 10, Windows Server 2008 R2, Windows Server 2012, C#, SQL Server Reporting Services 2005/2008/2014 , SSIS/BIDS 2005/2008, SSDT 2012/2014, SSAS 2008R2/2014,Erwin 7.3.6, Team Foundation Server 2008, Microsoft Office 2005/2008/2010 /2013 , SQL Server Tuning Advisor, SQL Server Profiler, SQL Compare, Oracle 10g, .Net Framework 2.0-4.5, ADO.net, IIS 7.0, HTML, CSS, JIRA, SVN,C#,.Net, Hyper-V, SSMS, batch programming, Python(Panda), Jupyter notebook, AWS, Azure, Yellow-fin, Power-BI

Confidential, Manhattan, NY

Database Administrator/Database Developer

Responsibilities:

• Responsible for writing complex TSQL code using Parameterized and non Parameterized Store Procedures, Functions, Common table expressions, Derived tables, pivot, un-pivot functions, Rank Functions, Temporary Tables, Cursors, Triggers, Merge statements for front end java development.
• Responsible for data mapping, Data profiling and database design and development to load data from db2, Access and SQL server databases.
• Responsible for Database replication for Ticket finder project.
• Responsible for database partitioning for high volume tables for front end application.
• Responsible for designing and developing SSIS packages to pull data from ATAS, DB2, Access, SQL Server, Excel Sources into Relational databases
• Responsible for creating and maintaining indexes to increase data load performance, store procedure performance as well maintaining Server Performance and SQL Objects Performance.
• Created and Maintained databases and its objects on development, UAT, Production Servers to support front end development.
• Responsible for giving access, permissions to users on SQL Servers, backup restore of databases, creating and maintaining linked servers.
• Responsible for monitoring and maintaining Taxi Production database and its frond end transactions.
• Responsible for scheduling and delivering releases and patches for QA, UAT, Production.
• Responsible for Creating and monitoring SQL server agent jobs to run SSIS packages and store Procedures.
• Responsible for Unit Testing, creating Test Cases and documenting them with results for QA, UAT, Production.
• Responsible for creating release documents.
• Responsible for developing of matrix, tabular, drill though, drill down, parameterized, non parameterized reports with features like KPI for users to analyze monthly and yearly data.
• Responsible to mentor junior developer.
• Responsible for supporting production databases for taxi, health and ticket finder projects.
• Responsible for Data Migration from IBM DB2/Access to SQL Server Database.
• Worked on migration projects from SQL Server 2008 to SQL Server 2012/2014/2016 .

Environment: SQL Server 2008 R2, MS Visual Studio 2008, Windows XP/7, SQL Server Reporting Services 2008, BIDS 2008, SQL Data Compare, Microsoft Office 2008/2010, SQL Server Tuning Advisor, SQL Server Profiler, Tomcat, Hibernate, DB2, Access, IBM Data Studio, Unix.

Confidential, Columbia, MD

BI Developer/ MS SQL Server Developer

Responsibilities:

• Involved in designing ETL architecture with project manager to load dimensional and normalized Databases.
• Responsible for developing SSIS packages to pull data from SQL server databases, Oracle databases, other data sources to Staging, Data warehouse and Data mart.
• Responsible for writing complex TSQL, code using Parameterized Store Procedures, Functions, Common table expressions, Derived tables, SQL Server Merge Statements, pivot, un-pivot functions and Rank Functions.
• Responsible for writing PL/SQL code to pull data from Oracle Data Source.
• Responsible for creating and maintaining indexes to increase Data Load Performance.
• Created and Maintained databases and its objects on development, QA Servers.
• Responsible for developing matrix, drill down, and drill through reports.
• Responsible for scheduling and delivering releases and patches for QA.
• Responsible for Re-architecting and Developing SSIS packages and rewriting TSQL Code to increase performance.
• Responsible for pulling data from different sources to excel in different format for data analysis.
• Responsible for monitoring SQL server jobs and SQL servers running SSIS packages.
• Responsible for creating SQL Server Agent Jobs to install Releases on Dev, QA, and Production Servers.
• Responsible for Unit Testing, creating Test Cases and documenting them with results for QA, UAT, Follow up meetings.
• Responsible for creating release documents.
• Responsible for creating test cases and maintaining them in Excel Workbooks.

Environment: SQL Server 2005/ 2008 R2, MS Visual Studio 2005/2008, Windows XP/7, VB.net, SQL Server Reporting Services 2005/2008, BIDS 2005/2008, SQL Data Compare, SSCM, Microsoft Office 2005/2008/2010 , SQL Server Tuning Advisor, SQL Server Profiler, Oracle 10g.

Confidential

SQL Server BI Developer/Database Engineer

Responsibilities:

• Gathering business requirements and working in conjunction with the data warehouse architect in the development of logical and Physical data models of Staging, Data warehouse, GRD Database using Erwin. This included Reverse/Forward engineering, complete comparisons, Schema Reports of databases using Erwin.
• Involved in product development lifecycle management and development for NexGen BI Product .
• Involved in designing ETL architecture using SSIS and other Batch Processes with Tech lead and project manager to load dimensional and normalized Databases.
• Design and development of Reconciliation Engine and automated validation Process in Excel Workbook and in SQL Server Databases. This effort included writing Multidimensional Expressions (MDX) to reconcile Cube data and creating various financial and validation repots using MS SQL Server Reporting Services 2008 R2.
• Responsible for writing complex Store Procedures, Functions, CTEs, Merge Statements, pivot, un-pivot functions (Operators) and Rank Functions.
• Maintained databases and its objects on development and build servers.
• Solid experience in resolving QA/UAT technical and data issues.
• Involved in scheduling and delivering releases and patches.
• Extensively involved in creating user guides for installing IAF product.
• Highly responsible for setting environment for company BI products, testing, debugging and fixing issues.
• Act as a single point of contact for the offshore developers.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.
• Responsible for creating excel workbooks for automated validation to compare data from different sources with Excel features like pivot method.
• Worked as a lead developer on Cover-all’s 24/7 production support team for some of its major clients, extensively using SQL Server profiler, SQL Server Tuning Advisor to solve dead locks/long running queries in Database and SSIS Packages.

Environment: SQL Server 2005/ 2008 R2, MS Visual Studio 2005/2008, Windows XP/7, C#, SQL Server Reporting Services 2005/2008, BIDS 2005/2008, Erwin 7.3.6, Team Foundation Server 2008, Microsoft Office 2005/2008/2010 , SQL Server Tuning Advisor, SQL Server Profiler, SQL Compare, Oracle 10g, .Net Framework 2.0, ADO.net, IIS 7.0, HTML, CSS

Confidential, NY

SQL Server BI Developer /DBA

Responsibilities:

• Creating mapping document to map Source data to Staging Repository and also participating in database design and ETL Architecture for loading Staging, DW and Data Mart databases.
• Creation and maintenance of DDL scripts for Database objects. I was also responsible for generating utility using Batch Scripting and BCP processes for deploying all scripts and associated files into Production.
• Troubleshooting DB Performance Issues and implementing necessary DB changes and implemented processes to ensure Optimal Query Performance.
• Responsible for setting SQL Server Agent Jobs to execute SSIS Packages.
• Unit, UAT, QA Testing, with the added responsibility of designing and developing and automated processes to do these tasks with few resources and less time.
• Tracking of new requirements, change requests and bugs with MS Team Foundation Studio (TFS) and also generating Test Reports using the SQL tool in TFS.
• Created and maintained Validation Excel Workbooks for data integrity, and involved in data profiling using SSIS.
• Designed reports Excel Pivot table based on OLAP Cube.
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension.
• Involved in creating C# scripts using script task in SSIS.
• Responsible for loading data from access to sql server and validating it against source to target.
• Performed weekly database checkup, shrink database according to instructions, and documented weekly database activities.
• Designed SSRS Report Model Projects in BI studio and created, modified and managed various SSRS report to present summarized data to end user to take effective business Decisions.
• Documented the developed work and production release for future reference.
• Scheduled and demonstrated periodic sessions of new key BI features.
• Responsible for designing replication strategy.
• Designed and populated Static Dimensions: Date Table, Geography Tables.
• Responsible for writing T-SQL using SQL server Dynamic Management Views (DMVs).

Environment: SQL Server 2005/2008 R2, MS Visual Studio 2005/2008, BIDS 2005/2008, Windows XP Professional, MS Access Database, Erwin 7.3.6, TFS 2008, Microsoft Office 2005/2008, .Net Framework.