SUMMARY

• 13+ years ofIT experience in Database design, administration, development and support of Microsoft SQL Server 2005/2008/12/14/16/17 in various business domains like Financial, Investment Banking and Pharma/Healthcare.
• Extensive experience in developing BI applications utilizing SQL server, MSBI stack (SSIS, SSRS, SSAS) and Power BI.
• Expertise in writing T - SQL queries, dynamic queries, sub-queries and complex joins for generating complex stored procedures, triggers, user-defined functions, views and cursors.
• Expertise in SQL Server optimization by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.
• Implemented complex business logic into database design and maintained the referential integrity via triggers and constraints.
• Responsible for the development of SSIS packages to automate intra-day, EOD jobs and expertise in enhancing, debugging and deploying of SSIS packages from developmentto productionserver using SSIS catalog.
• Proficient knowledge of Data warehouse methodologies and concepts including star and snowflakes schemas, dimensional modeling, maintenance and optimization of OLAP cubes and data sets in SSAS.
• Generated ad-hoc reports in Excel Power Pivot using Power BI and shared them to the decision makers for the strategic planning and utilized Power BI (Power View, Power Query) to create various analytical dash boards.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) and scheduling them on weekly and monthly basis as per the client requirement.
• Performed SQL DBA tasks like database logical and physical design, maintenance, tuning, archiving, backups and optimization for SQL Server database.
• Efficient in Migration projects like upgrade from SQL Server 2008R2 to SQL Server 2012/2014.
• Working knowledge of UNIX, Autosys, Active Batch and Shell scripting.
• Expertise in designing and developing applications using ASP.NET, ADO.NET,C#.NET, Web services, SOAP, HTML 4/5, XML, CSS,Java Script, Web Forms.
• Excellent networking and communication with all levels of stakeholders as appropriate, including executives, application developers, business users, and customers
• Extensive experience in software development Agile, Scrum and Waterfall methodologies.
• Good problem-solving skills, quick learner, effective individual, team player, team handling, excellent communication and presentation skills, the ability to integrate information from multiple sources to execute effectively and efficiently in a dynamic environment and pursue a proactive approach to problem solving.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP/Professional, Unix/Linux, DOS

.Net Technologies: .Net Framework 2.0/3.5/4.0/4.5 , C#, WCF

Web: ASP.NET, HTML, AJAX, Web-Services

Scripting: XML, CSS, Java Script, VBScript, jQuery, Shell scripting

Databases: SQL Server 2008R 2/2012/2014/2016/2017 , MS-Access, Oracle 8i

ETL & Reporting Tools: SSIS, MS Reporting Services 2008/2012 and Tableau

Scheduling tools: Autosys, Active Batch and SQL Server Agent

Version Control: Visual Source Safe (VSS), Team Foundation Server (TFS), GitHub

PROFESSIONAL EXPERIENCE

Confidential, NY

Senior SQL/MSBI Developer

Responsibilities:

• Involved in the database development of different modules using database objects like T-SQL stored procedures, views, triggers, sub-queries, joins etc.
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Created SSIS packages which involved a variety of transformations such as look up, Aggregate, Derived Column.etc before loading the data into Data Warehouse.
• Development of custom scripts and stored procedures for data import and manipulation.
• Implemented custom logging, auditing and custom email notifications using SSIS 2014; performing unit testing of SSIS packages with respect to its flow and performance issues and using C# .net code.
• Fine-tuned DML, DDL scripts with lock hints for performance boost.
• Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.
• Scheduled the jobs in Active Batch and monitoring/supporting and fixing the issues related to AB job failures.
• Developed and deployed different Power BI dashboards, visualizations and autonomous and dynamic reporting interfaces to be distributed to stakeholders via the BI reporting platform and email.
• Involved in deploying the changes to QA, Staging and Prod environments

Environment: MS SQL Server 2017, SSIS 2016, Reporting Services 2014, T-SQL, MS Excel, C#.NET, SQL profiler, SQL configuration Tools and Active Batch 12.0,Power BI.

Confidential, Somerset, NJ

MSSQL/MSBI Developer

Responsibilities:

• Responsible for stored procedures optimization, performance tuning and index tuning.
• Created T-SQL stored procedures, views, triggers, sub-queries, joins, scheduling jobs and alerting using SQL Server agent.
• Involved in Code Review, Unit testing, logging and Custom Logging in SSIS Packages, Query verification in SSIS and Stored Procedures.
• Provided back-end support for functional testing and performance testing. Developed scripts to migrate data from multiple sources to desired destination using ETL tools.
• Created SSIS packages, staged data from different data sources into a SQL Server Database using Integration services.
• Implemented Custom scripting in SSIS packages using C#.Net.
• Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports, and drill down reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Work with various Team Members, internal departments and third-party agencies on report business requirements, documentation, timelines, testing, and technical delivery.
• Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.

Environment: MS SQL Server 2014, SSIS 2012, Reporting Services 2012, MS Excel, C#.NET, SQL profiler, SQL configuration Tools.

Confidential, Warren, NJ

Senior SQL/MSBI Developer

Responsibilities:

• Design/develop complex queries efficiently as per the given business requirements.
• Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables and also optimized the procedures and triggers to be used in production.
• Designed SSIS packages, enhanced existing packages by using Pivot Transformation, Lookup, and Derived columns, Conditional Split, Aggregate, Execute SQL and Dataflow Task etc. to extract data from different heterogeneous sources.
• Scheduling and monitoring ETL processes using DTS exec utilities and batch files.
• Implemented custom logging, auditing and custom email notifications using SSIS 2012, performing Unit Testing the SSIS packages with respect to its flow and performance issues and using C# .net code.
• Developed C#, VB.Net scripts as part of ETL coding
• Created audit tables, loggings, error handling to maintain data quality while loading into data warehouse using SSIS 2008/2012.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Worked with DBAs to schedule SSIS packages as jobs either daily, monthly, yearly or ad-hoc.

Environment: MS SQL Server 2014, SSIS 2012, Reporting Services 2012 OLTP, T-SQL, MS Excel, C#.NET, SQL profiler, SQL configuration Tools.

Confidential, New York, NY

MSSQL/MSBI Developer

Responsibilities:

• Responsible for the database migration of the legacy Confidential Soft application developed in MS Access 2003, SQL Server 2008 R2 to .NET 4.5, Prism and SQL Server 2014.
• Developed T-SQL query, stored procedures and functions to retrieve data for reporting.
• Loaded flat files (4GB) data into database using SQL Server Integration Services (SSIS) after applying various transformations like Lookup, Merge, Join, Aggregation, Derived column, Data Conversion, Script Task etc.
• Developed complex T-SQL queries for the ETL packages.
• Ftp’ing the Head Office files from the remote location and load the data in the database Using FTP task in SSIS.
• Design/develop complex queries efficiently as per the given business requirements.
• Developed reports in the form of Matrix, Table and Chart using MS SQL Server Reporting Services 2012 (SSRS).
• Analyzed various business requirements to provide estimates for all SDLC phases (Analysis, Design, Coding, Implementation, SIT, UAT, and Production Move).
• Planned complete Back-up of Database and Restored the Database from Disaster Recovery.

Environment: MS SQL Server 2008R2/2012/2014, SSIS 2008/2012, Reporting Services 2012 OLTP, T-SQL, MS Excel, C#.NET, SQL profiler, SQL Server Configuration Tools.

Confidential, Salt Lake City, UT

Production Support Engineer

Responsibilities:

• Lead the team of developers and assisted them in the analysis and debugging of application issues quickly and effectively. This includes the development of new applications or modifications to existing applications.
• Carry out regular proactive sanity checks on Production environment to ensure availability of system and data to users within the agreed Service level agreement.
• Analyzing data quality issues and address user queries/concerns.
• Involved in Incident Management and Problem management by working with teams as required to resolve the issues both tactically and strategically.
• Document all incidents and report the status to management and work with teams on implementing the fixes to take the issue to closure.
• Periodic updates/reports on status of projects & activities to management, ensuring deadlines are met for critical tasks.L1/L2 support of Production Batch, which includes monitoring batch on rotational basis, on-call support, job failure analysis and bug fixing, batch tuning, basic UNIX system and process management.
• Documentation of training plans to the new joiner, support run books, standard workflows, known issues etc. Liaise with client managers on the process flow design solution to reduce support costs and have strategies around quick turnaround during production issues, and drive for automation of repetitive manual work.
• Co-ordinate as an interface between onsite and offshore teams to resolve critical issues and provide proactive support to manage business without major service outage
• Manage a cross functional Mission Control team located across India (offshore) and Salt Lake City in United States as a regional team lead.
• Performed proactive sanity EOD checks for production environment to ensure availability of various systems and data within the agreed service level agreement.
• Responsible for L1/L2 support of EOD batch cycle such as monitoring batch jobs, providing on-call support, analyzing job failures, fixing bugs/job failures, and performing batch tuning.
• Responsible for incident management from job monitoring to root-cause analysis to issues resolution. Coordinated with the responsible parties identifying issues, logging and tracking issues, conducting team meetings for implementing fixes and communicating status to all tactical teams and management.

Environment: Autosys, Sybase, UNIX scripting, JIRA

Confidential

Software Developer

Responsibilities:

• Enhanced the performance of Data warehouse using execution plan and SQL Profiler to optimize queries.
• Created database tables, views, stored procedures, functions and triggers as required.
• Responsible for deploying reports to report manager and troubleshooting for any error occurs in execution.
• Used SQL Profiler for performance monitor to resolve dead locks and long running queries by checking appropriate changes to Transaction Isolation levels.
• Responsible for managing batch processing including setting up Autosys scheduler and maintaining/enhancing existing batch applications using shell scripts, Perl scripts in UNIX.
• Responsible for incident management from job monitoring to root-cause analysis to issues resolution. Coordinated with the responsible parties identifying issues, logging and tracking issues, conducting team meetings for implementing fixes and communicating status to all tactical teams and management.
• Performed proactive sanity EOD checks for production environment to ensure availability of various systems and data within the agreed service level agreement.
• Responsible for L1/L2 support of EOD batch cycle such as monitoring batch jobs, providing on-call support, analyzing job failures, fixing bugs/job failures, and performing batch tuning.

Environment: SQL Server 2008, Autosys, JIRA and UNIX

Confidential

.NET Developer

Responsibilities:

• Developed and implemented Web Forms using ASP.NET and coded the business logic in C#.
• Developed WCF services to be used by ASP.NET applications.
• Used JavaScript and .NET validation controls for performing client-side validations.
• Configured security features for the application using Form Based Authentication and Role Based Authorization using C# and ASP.NET.
• Developed the web application in ASP.Net3.5 using Master Page, Themes & skins to maintain the consistent look and feel throughout the application.
• Experience of handling queries using .NET 3.5 LINQ components and the Entity Framework.
• Used ADO.Net for database connectivity and retrieving data from SQL server.

Environment: .NET Framework 3.5, ASP.NET 3.5, IIS 7.0, ADO.Net, C#, HTML, WCF, Visual Studio 2008, Oracle.

Confidential

.NET Developer

Responsibilities:

• Involved in designing and development of Inbound and Outbound modules.
• Developed and consumed Web Services to extract information from the database and other services.
• Used various advanced Server Controls and developed Custom Controls.
• Provided database connectivity using ADO.Net and created procedures, Indexes and Triggers using MS SQL Server 2005.
• Used T-SQL to examine the database information.
• Developed applications in Test driven environment using Unit testing
• Worked with Web controls, User controls and Custom controls.

Environment: .NET Framework 3.0, Visual Studio 2005, ASP.Net, C#, Web services, ADO.Net, XML, HTML, JavaScript, SQL Server 2005, T-SQL, CSS, IIS, Visual Source Safe.