SUMMARY

• Around 11 years of IT experience in Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite.
• Experienced SQL developer with Microsoft in SQL Server 2008.
• Strong technical knowledge in MS SQL Server development and experience Microsoft BI Tools.
• Strong working experience on SQL Server 2017/2019 including Reporting, designing logical/physical databases and Troubleshooting.
• Experienced in SQL Server 2017/2019 RDBMS database development including T - SQL programming.
• Very Good Understanding and Experience in SQL Server Integration Services (SSIS),SQL Server Reporting Services (SSRS).
• Experience in developing reports on SSRS. Sound Experience and understanding of SSIS & DWH Architecture.
• Experience in ETL implementation using SQL Server Integration Services (SSIS) in OLTP and Data Warehouse Environment.
• Experience in implementing complex DTS Packages in SSIS for Data Migration from Excel Sheets/CSV files/SQL server to SQL Server and Transformation.
• Experience in Designing Dimensions, Facts with DWH concepts.
• Experience in creating ad-hoc reports using Report Model and Report Builder 2.0.
• Expert in performing ETL operations using various tools such as SQL Server Integration Services (SSIS).
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle, Sybase to MS SQL Server by using SSIS services.
• Experience working on Data modeling, creating star and snowflake schemas.
• Expert in designing complex reports like reports using Cascading parameters, Parameterized Reports, Cross-tab reports, Report Models and ad-hoc reports using SSRS.
• Experienced in creating Sub-reports with Bookmarking in SSRS.
• Experience in defining Queries for generating drill down and drill through reports in SSRS.
• Experience in Installing, Configuring, Managing and troubleshooting SQL Server 2017/2019.
• Experience in version controlling tools JIRA, Remedy.
• Expert in creating multiple Standard Operating Procedures for business enhancement.
• Excellent communication and analytical skills, understands business requirements in various domains.
• Expert in client interaction along with conduction of regular business sessions.

TECHNICAL SKILLS

SQL Server Tools: SSMS,BIDS, Enterprise Manager

ETL & Reporting Tools: SSIS, SSRS, BIDS, SSDT

Databases: SQL Server 2017/2019

Programming Languages: SQL,T-SQL,PL/SQL,C/C++, C#

Operating System: Windows Server 2000/2003, 2008, 2008 R2, Windows XP/7, Windows 10

Tools: Visual Studio 2017, SQL Server Data Tools 2017 and Report Builder 2.0/ 3.0, JIRA

PROFESSIONAL EXPERIENCE

Confidential

Database Consultant

Responsibilities:

• Responsible for developing and managing technical database requirements.
• Solely managing Confidential Takeback incentive SQL database which involves creating database objects used in displaying the data to Confidential partners through Tableau reports.
• Working with stakeholders in planning business requirements and effort estimation using Agile methodology.
• Responsible for developing Functional Requirement Document for program database.
• Acting as a Database expert within the process.

Environment: Microsoft SQL Server 2019/2017 Enterprise Edition, Tableau, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Windows Server 2010/2012/2016

Confidential

Senior Software Engineer

Responsibilities:

• Responsible for developing and managing technical requirements in ETL and SQL.
• Majorly handling the Data Integration from multiple source systems.
• Working with stakeholders in planning business requirements and effort estimation using Agile methodology.
• Broadly involved in Service Now migration from Remedy system.
• Working as an expert in Business intelligence and Data architecture thereby leading the team as an Assistant Vice President.

Environment: Microsoft Azure, SSDT 2017, SQL Server 2019/2017 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Windows Server 2010/2012/2016

Confidential

Sr. MSBI/SQL Developer

Responsibilities:

• Manage the migration of on-premise applications to Azure cloud.
• Responsible for coordinating with stakeholders on applications deep dive investigations.
• Understanding the client requirements and co-relate the same to plan the cloud migration strategy.
• Responsible for creating the database migration cutover steps and implementing the same in Azure.
• Broadly involved in the Azure migration of on-premise applications based on SQL server, data warehousing architecture and applications involving ETL solutions.
• Acting as a SQL and SSIS subject matter expert along with providing solutions for the underlying applications.

Environment: Microsoft Azure, SSDT 2017, SQL Server 2019/2017 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Windows Server 2010/2012/2016 .

Confidential

Sr. MSBI/SQL Developer

Responsibilities:

• Manage the end-to-end Middleware functionality and data load in salesforce data loader for Veeva CRM application.
• Design/Maintain LEO database using ETL techniques and concepts.
• Responsible for data load from multiple data sources to Veeva CRM application.
• Responsible for creating SQL jobs to automate the scheduled run of ETL packages.
• Manage the call data load for all the LEO countries and respective doctors and hospitals.
• Broadly involved in extracting data from different sources i.e. SQL server, Oracle, File system and transforming data as per client’s requirements using ETL techniques.
• Vast knowledge of version controlling tools i.e. Team Foundation Server (TFS), JIRA, Remedy.
• Acting as a critical resource for SSIS/SSRS and SQL development and maintenance.

Environment: SSDT 2017, SQL Server 2012/2014 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Windows Server 2003/2008.

Confidential

Sr. MSBI/SQL Developer

Responsibilities:

• Design/Maintain HESI (Health Systems Incorporated) data warehouse using ETL techniques and concepts.
• HESI data warehouse designing and maintenance to enhance/create exam samples for Nursing (Nclex).
• Responsible for creating SQL jobs to automate the scheduled run of ETL packages.
• Migrated SSIS version thereby using the project deployment model with environment creation for different servers.
• Broadly involved in extracting data from different sources i.e. SQL server, Oracle, File system and transforming data as per client’s requirements using ETL techniques.
• Design/Maintain HESI reports using SSRS and Report builder.
• Vast knowledge of version controlling tools i.e. Team Foundation Server (TFS), JIRA, Remedy.
• Acting as a critical resource for SSIS development and maintenance.

Environment: SSDT 2017, SQL Server 2012 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Windows Server 2003/2008.

Confidential

Sr. MSBI Developer

Responsibilities:

• Design/ Maintain Confidential Compliance data warehouse using the ETL techniques and concepts.
• Extensively involved in designing the SSRS reports and SSIS packages to export data of flat file source to SQL Server database.
• Involved in creating SSIS jobs to automate the Compliance reports generation.
• Designed multiple data flow and control flow tasks as per client requirements along with multiple table mapping tasks.
• Analyzed and enhanced major production job under Compliance to deliver the underlying SSRS reports on/before business approved time.
• Enhanced an underlying ETL package of a production job to remove the encoding issues in source files thus preventing recurring job failures and issues.
• Worked on major changes and incidents using Change management process to implement and deploy production modifications including configuration file changes, job schedules, source files modifications and so on.
• Provide support for managing Compliance DW reports designed using SSRS.
• Ensure timely delivery of reports to Confidential compliance officers and related source systems.
• Enhancement of existing ETL packages to increase performance and prevent issues and exceptions.
• Responsible for handling the ad-hoc requests from related source systems that are part of Confidential client process.
• Acting as a critical resource thus leading the major responsibilities including regular client interaction.

Environment: SQL Server 2012/2008/2005 Enterprise Edition, SQL BI Suite (SSAS, SSIS, SSRS), Enterprise manager, Windows Server 2003/2008.

Confidential

SQL/BI Developer

Responsibilities:

• Design/ Maintain data warehouse using the ETL techniques and data staging concepts.
• Designed multiple data flow and control flow tasks as per client requirements along with multiple table mapping tasks using SSIS.
• Involved in migration of SQL Server /2012.
• Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
• Good understanding of Data Marts, Data warehousing, OLAP, Star Schema Modeling, Snow-Flake Modeling.
• Responsible for identifying and translate business requirements for the Enterprise Data Warehouse into logical and physical data models thus generating SSRS reports.
• Developed tablix and crosstab reports as per client requirements. Worked on Budget analysis, Profit & Loss reports.
• Developed a parameterized report with multi value parameters to display the revenue information generated.
• Worked on an In-house .Net application (iEnable) of Confidential which helps in auditing the geographic sites/locations to verify that the sites are up to the set standards.
• Develop/Enhance multiple SSRS reports of iEnable.
• Worked on Self- service reporting developed using the Report builder tool.
• Responsible for resolving data warehouse issues, resolving SSIS package issues.
• Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
• Acted as an individual SSRS developer within the project.

Environment: SQL Server 2005/2008 R2/2012, T-SQL, PL/SQL, Report Builder, SSIS, SSRS, ASP.NET, C#, Visual Studio 2005/2008, MS Visio.

Confidential

SQL/BI Developer

Responsibilities:

• Designinglogical and physical databasestructure to facilitate analysis of data from both operational and customer perspectives.
• Developed SSRS reports for an in-house application of BP i.e. “ChemMate” utilizingSSIS,T/SQL,stored procedure,cursor, Enterprise Manager, Query Analyzer.
• Developed and maintained the database designed for IT service management thereby generating multiple SSRS reports.
• Investigated various platform, languages, and database designing tools and suggested the best solution to upper management considering reusability, scalability and maintainability.
• Created a parameterized audit report for changes lifecycle with dates and companies as the data filtering parameters. The major data source used was Confidential IT service management tool which populates Global Business intelligence (GBI) database. The report was generated using a data source which gets updated through an SQL update job from GBI database every 4 hours.
• DesignedSSISpackages to extract, transform and load data to SQL tables from txt and csv file receivedfromvarious clients.
• Created SQL objects like Tables, Stored Procedures, Functions, and User Defined Data-Types.
• Created standard tables andmapped columnsfrom various client tables.
• Gathered variousbusiness logicsand developed numerous reusable stored procedures compatible for all clients.
• Generated Tabular reports, Cross Tabs, Drill down, Drill Through, Cascading and Parameterized Cascading Reports, Sub Reports, Summary Reports, Charts, Functions and Maps using SSRS.
• Worked on SSRS subscriptions to automate report delivery to various clients as required.
• Designed a masterSSISto execute all synchronized stored procedures, otherSSIS.
• Effectively hosted several web meetings to present the implementations and deployment in production environment.
• Trained team members for future enhancement and maintenance of the system.

Environment: SQL Server 2005/2008 R2/2012, Query Analyzer, T-SQL, PL/SQL, Report Builder, SSIS, SSRS, ASP.NET, C#.NET, Visual Studio 2005/2008, Excel, MS Visio 2008.

Confidential

SQL Server Developer/ SSRS Developer

Responsibilities:

• Developed a matrix report for UK Power networks which displays the memory consumed on each of the UKPN servers. Monthly data-driven subscription was applied to the report.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Worked on UKPN web application “Field Force Enablement” to enhance existing SSRS reports.
• Developed the report requirements specified by the lead users on the application.
• Designed stored procedures to retrieve data from and display in various SSRS reports.
• Worked on Report manager to manage user roles and securities.
• Thorough experience is installing and configuring report server along with report viewer controller.

Environment: SQL Server 2000/2005/2008 , T-SQL, .NET Framework, MS Visio, Windows 2003 Server, Visual source safe(VSS).

Confidential

SQL Server Developer/ SSRS Developer

Responsibilities:

• Developed a tabular report for Confidential which displays the erroneous work orders within the application thereby reducing the manual intervention required for the task.
• Parameterized report was created with start and end dates as the major report parameters to get the work order information as and when required as per the current and past dates.
• Providing clients with regular reports detailing the developments and Changes brought on the server
• Developed weekly reports and exported it into Excel from Report manager as required by clients.
• Created multiple sub-reports with bookmarking techniques in one master report using SSRS.

Environment: SQL Server 2000/2005/2008 , T-SQL, .NET Framework, MS Visio, Windows 2003 Server.