Sql Server Business Intelligence

Name: Hemapriyadharshini

Mail: ******************.**@*****.***

Phone: 470-***-****

Professional Summary:

Over 12+ years of IT experience in designing, developing, implementing, and administrating database systems using MS-SQL Servers for OLTP and data Warehousing Systems applications with various business domains like Retail, Healthcare, and Banking.

Results-oriented professional experience in the IT industry, specializing in database programming using MS SQL Server, SSIS, and SSRS.

Highly proficient in writing efficient and optimized T-SQL queries, stored procedures, triggers, functions, views, and cursors.

Experienced in analyzing complex data requirements, designing scalable database solutions, and developing robust applications.

Skilled in installing, configuring, and deploying the MS SQL Server suite of products, with a strong focus on Business Intelligence using SQL Server Integration Services (SSIS).

Expertise handling diverse data sources, including flat files, Excel spreadsheets, and OLEDB connections.

Demonstrated ability to create advanced SSIS packages for data extraction, transformation, and loading processes.

Proven track record of generating insightful and visually appealing reports using SSRS, enabling data-driven decision-making.

Designed and developed interactive, drill-through, and parameterized SSRS reports for operational and analytical reporting.

Skillful in designing, developing, and implementing ETL packages using SSIS for integrating data between heterogeneous sources (SQL Server, Excel, CSV, Oracle, flat file, Text file, Teradata) by using multiple transformations available in SSIS toolbox such as Lookup, Data Conversion, Conditional Split, Bulk Insert, Merge, fuzzy Lookup and Union all.

Experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor, and Index Tuning Wizard.

Experienced in maintaining Batch Logging, Error Logging with Event Handlers, and Configuring Connection Managers using SSIS.

Provided operational support by handling SSRS report requests, troubleshooting issues, and ensuring seamless report functionality.

Managed and resolved support tickets related to SSRS report failures, incorrect data, and performance issues.

Building and publishing Microsoft BI reports utilizing complex calculated fields, table calculations, filters, and parameters.

Experienced in sorting the data, and defining data sources and subtotals for the reports while setting up Microsoft BI environment through gateways, apps, and apps workspace.

Experience in creating Report Models, Parameterized Reports, Drill Down, Drill Through, and Graph Reports in SSRS and Microsoft BI.

Involved in SQL Server Package Configuration to make Dynamic configurations for SSIS packages and Project deployment model in SQL Server 2014,2017,2019.

Utilized Tableau Desktop to create multiple rich dashboards that appropriately told stories of business status and success, strengths and weaknesses, and potentials;

Technical Skills :

Reporting & BI Tools: SSIS, SSRS (SQL Server Reporting Services), RDLs.

Databases: SQL Server, T-SQL, Stored Procedures, Views, Functions, CTE.

Development Tools: Visual Studio, SQL Server Management Studio (SSMS).

Data Modeling: Star Schema, Data Extraction Reports.

Operational Support: Report Deployment, Production Support, Debugging & Fixes.

Education:

Bachelor of Technology (Information Technology), Anna University, India - 2006

Master of Engineering (Computer Science and Engineering), Karpagam University, India - 2011

Professional Experience:

Client: Wells Fargo July 2021 - Present

SQL Database Developer \ ETL Developer

Roles & Responsibilities:

Processed Data Transformation and Cleansing and inserted new data into the Database using SSIS.

Created table per ERW in model and applied proper key and column store index for performance.

Created and modified existing ETL Packages for Interface Development and Data Migration.

Filtered bad data from legacy systems using complex T-SQL statements and implemented various types of Constraints and Triggers for Data Consistency.

Worked with SSIS to load data files to SQL Server and the other way. Set up SSIS package automation to get vendor files and load them to MS SQL Server Tables.

Created Reports from SQL Server and DB2 Databases using SSMS and IBM Data Studio.

Designed, developed, and deployed SSRS RDL reports based on business requirements, ensuring accurate data representation.

Migrated RDL files across environments (Dev Test Production), ensuring seamless report transitions and minimal downtime.

Configured and managed SSRS report parameters, filters, and expressions to enhance report functionality and user experience.

Designed parameterized and drill-through reports to provide flexible data analysis and detailed reporting.

Use Different types of Data Sources for Report Generation like SQL Server and DB2, SSAS Cube

Documented the Stored Procedures and User Defined Functions (UDF) for future references and maintenance.

Analyzed the tuned Database Growth and Space Requirement as data were growing daily.

Set up the Report Server by installing SQL Server Business Intelligence Tools.

Basic experience with KAFKA for streaming of data, HQL. Optimize SQL query for Report using, a SQL Profiler, Temporary Table and Common Table Expression (CTE).

Create Jobs using SQL Agent and Control M to run the SSIS Package from the Server. Reporting every week to the project manager.

Generated Tableau dashboard reports, creating business intelligence reports and visualizations, and working with developers

Developed and reviewed simultaneous SQL queries in Tableau Desktop to validate both static and dynamic data for data validation.

Create documentation for BRS (Business Requirement), System requirement Spec) SRS, TDD (Technical Design Document).

Environment: MS SQL Server 2022, SSIS, SSRS.

Client: Toshiba, Durham, NC Mar 2019 To June 2021

SQL Database Developer \ETL- Developer

Roles & Responsibilities:

Responsible for handling real-time transactional operations, such as processing online orders, capturing customer interactions, and updating inventory in real-time.

Managed the entire order processing lifecycle, including order validation, payment processing, and order fulfillment.

Monitored and managed inventory levels across the e-commerce platform.

Handled the management and organization of product catalogs, including product information, categories, and attributes.

Worked with SSIS to load data files to SQL Server and the other way. Migrate Data warehouse DB2 Database to SQL Server for Analysis Cube. Set up automation to get vendor files and load them to MS SQL Server Tables.

Create and Execute the Stored Procedures, Views, Trigger User Define Functions, and Complex Queries for SSIS and Data Migration and SSRS Reports.

Developed custom data extraction reports using SSRS and T-SQL, allowing business users to retrieve meaningful insights.

Designed parameterized and drill-through reports to provide flexible data analysis and detailed reporting.

Built and optimized SQL queries for data extraction, ensuring efficient and accurate report generation.

Managed customer data, including profiles, preferences, and order history.

Performed data analysis and generated reports on sales, customer behavior, and product performance.

Provided personalized product recommendations to customers based on their browsing and purchase history.

Handled product search functionality, allowing customers to find products based on keywords and filters.

Managed user authentication, access control, and data security across the e-commerce platform.

Handled payment transactions securely and interfaced with payment gateways.

Created Jobs using SQL Agent to run the SSIS Package from the Server. Reporting every week to the project manager.

Designed and built dashboards for use in monitoring performance metrics while maintaining existing dashboards for accuracy and efficiency and incorporating changes using Tableau.

Environment: SQL Server 2014/2016/2019, SSIS, SSRS.

Client: Terra InfoTech, NJ Jan 2018 – Feb 2019

SQL Developer/ETL- Developer

Project Description: Terra InfoTech is a leading provider of Information Technology Services, Solutions, and Staffing. Our clientele includes most of the Fortune 500 companies spanning the Telecom, Finance, Insurance, Manufacturing, Pharma/Life Sciences, Retail and Hospitality industries. Terra InfoTech specializes in offering cutting-edge solutions that vary from business and systems analysis, web technologies, ERP, e-commerce, and Portal frameworks for Database development and administration. The key to our success has been our capability to identify the right resources, deploy them on time, and be able to offer them sustainable career growth.

Roles & Responsibilities:

Involved in the complete life cycle including design, development, and testing.

Involved in Data Mapping Process, Created Store Procedure for data Migration.

Migrated Databases from SQL Server 2005 to SQL Server 2008 R2 SQL using Server SQL Server Business

Intelligence (BI) Tools SSIS.

Applied various types of Control Flow tasks and Data Flow tasks like Container, execute task, Script task, Transfer for Loop Container, Aggregate, Derived column and Transfer Database Task according to the need for Data Transform and Data Cleansing and inserting new data into the Database using SSIS 2008 R2.

Defined check constraints, rules, indexes and views based on business requirements.

Create a Batch File, checkpoint file and Logging file for Data Integrity.

Create and Execute the Stored Procedures, Views, Trigger User Define Functions, and Complex Queries for SSIS and Data Migration and SSRS Reports.

Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created clustered/non-clustered indexes wherever necessary.

Passed through Testing of Queries along with T-SQL Commands, Stored Proc, Views, Joins and Triggers and modified them as far as they needed on the Database on the Server Side.

Create Standard Tabular and List Reports, Chart Reports and Report Models for Management Purposes.

Scheduled Reports from the Report Manager.

Create Temporary Table and Common Table Expression (CTE) for query Optimization in the SSRS Report Procedure.

Created complex T-SQL queries, stored procedures, views, and functions to support SSRS reporting needs.

Worked with star schema and dimensional modeling, improving data retrieval efficiency for SSRS reports.

Create Jobs using SQL Agent to run SSIS Package from the Server.

Worked with SSIS to load data files to SQL Server from various source file formats like .csv,txt.

Backing up master & system databases and restoring them when necessary. Supported production environment.

Resolved Bugs in the production Environment created by Quality Assurance.

Reporting every week to the project manager.

Environment: MS SQL Server 2012/2014, Windows 2000/XP.

Evry India, Bangalore - India

Client: Pharmpix, India Mar 2016 – Dec 2016

SQL Database Developer \ ETL Developer

Project Description: The Healthcare Common Procedure Coding System (HCPCS) coding system is used primarily to bill Medicare Part-B for supplies, materials, injections, various services, and procedures that may or may not be defined in the current Procedural Terminology.

About HCPCS Processor Integration: PharmPix is currently processing a few Medicare Part-B claims using manual crosswalk of HCPCS-NDC code. PharmPix wanted to automate this process of mapping HCPCS/J-codes and NDC-UPC-HRI codes for processing its drug claims to its Medicare Part-B beneficiaries. Health plans such as MCS and CareMoreRx, send claims using NDC-UPC-HRI codes to PharmPix which should be mapped to appropriate HCPCS/ J-code through this automated mapping process using the SSIS package.

Key Challenges:

Understanding about Entire database architecture and entity relationships and learning about

Adapting to the newer version of DTSX Packages and implementing the same.

Roles & Responsibilities:

Writing SQL queries and stored procedures to retrieve and manipulate data efficiently.

Creating SSIS packages to extract, transfer, and load data into the data warehouse daily.

Developing robust processes to extract, cleanse, transform, and integrate source data into the data warehouse

Identifying areas for improvement and implementing process enhancements to optimize performance and prevent defects.

Engaging in regular communication with clients, providing updates on assigned tasks, and actively participating in meetings.

Conducting thorough root cause analysis to investigate and resolve production issues, ensuring system stability and reliability.

Created claims processing and financial reports in SSRS to support business operations in the healthcare/insurance sector.

Assisted with HIPAA-compliant data reporting in healthcare environments, ensuring data security and confidentiality.

Environment: MS SQL Server 2012/2014, SSIS

Primary Contribution:

Implementation and testing of DTSX packages.

SSIS packages deployment and automated jobs

IBM, Bangalore – India.

Client: Applied Materials, India May 2015 – Feb 2016

SQL/ETL Developer

Project Description:

Applied Materials is a strategic partner and an enabler of the semiconductor and solar manufacturing ecosystem in India and works with various stakeholders towards enabling a robust semiconductor and solar manufacturing ecosystem. The reports are the final output that is generated from AMAT Application systems (AMCBMS, AMCWFP) used to get the reports from its applications and transfer them to some other shared locations of the AMAT engineers to review their business logic.

Key Challenges:

Gaining a comprehensive understanding of the existing DTS Packages, analyzing their functionality, and redesigning packages as needed.

Acquiring knowledge of the entire database architecture, including entity relationships, and adapting to the newer version of DTSX Packages for seamless implementation.

Roles & Responsibilities:

Proficient in writing SQL queries and developing stored procedures to ensure efficient data retrieval and manipulation.

Utilized T-SQL to create Tables, Views, and Stored Procedures, ensuring optimal database performance.

Created and configured SSIS packages to extract, transfer, and load data into the data warehouse daily.

Developed robust processes for extracting source data, performing data cleansing, transformations, and integration before loading it into the data warehouse.

Extensively involved in designing SSIS packages to handle diverse data sources (e.g., Excel, CSV, Flat file) and efficiently transfer data to staging tables in the SQL Server Database.

Developed custom data extraction reports using SSRS and T-SQL, allowing business users to retrieve meaningful insights.

Designed parameterized and drill-through reports to provide flexible data analysis and detailed reporting.s

Proactively identified opportunities for process improvement and implemented preventive measures to minimize defects and enhance overall efficiency.

Conducted thorough Root Cause Analysis for Production issues, identifying underlying causes and implementing appropriate solutions to prevent recurrence.

Environment: MS SQL Server 2012/2014, SSIS 2012, MS SQL Server 2012, SSIS, T-SQL, DTS, DTSX

Primary Contribution:

Implementation and testing of DTSX Packages and jobs

Handling production support issues of the DTSX packages and automated jobs

SQL/ETL Developer May 2011 – Jan 2012

Client: Nielsen Call Center, India

Project Description: SPSS is a third-party tool used by Nielsen call center for surveys on TV/Radio, Hollywood Movies, and Sports. The surveys generate extracts for another application to retrieve related data. Reports from SPSS provide survey ratios for end customers. Our application automates data extraction and report delivery by directly pulling data from SPSS and SQL Server, ensuring accuracy and efficiency. Job failure notifications help us quickly identify and resolve any issues during scheduled runs.

Key Challenges:

Understanding and analyzing requirements of creating new DTSX Packages

Learning & using various SSIS transformations, expressions and variables according to project requirements.

Roles & Responsibilities:

Clarify and Grasp the Business Requirements specified by the clients

Based on the Business Requirements, perform a System Analysis to identify the System Impact and Scope of development.

Established joins and created clustered/non-clustered indexes wherever necessary.

Passed through Testing of Queries along with T-SQL Commands, Stored Proc, Views, Joins and Triggers and modified them as far as they needed on the Database on the Server Side.

Extensively involved in designing the SSIS packages to export data of heterogeneous data (like Excel, CSV, Flat file) source to tables in SQL Server Database.

Code Walkthroughs, Code Reviews, Technical Design Reviews and Test Case Reviews and Defect Causal Analysis for Testing Defects

Involved in communication with the client directly daily on the task assigned and also in the meetings

Involved in the development of SSIS Jobs and Scheduling jobs of the SSIS Package

Environment: MS SQL Server 2012/2014, SSIS

Primary Contribution:

Implementation and testing of SSIS Packages with required SSIS dataflow and control flow data transformations.

Handling production support issues of the DTSX packages and automated jobs

Aximsoft, Coimbatore – India.

Client: PS Print, India Feb 2010 – May 2011

SQL Database Developer

Project Description: PS Print is a famous and reputed online store that prints postcards, business cards and many more. They even offer several other online printing services. PS Print prints amazing brochures, calendars and business cards just for their valued customers. The design tool available online makes it possible to create and innovate Customer’s designs in not more than some minutes. The PS Print code is attached to all their products. Customizable templates are also available on the website.

Key Challenges:

Understanding and analyzing the requirement of creating new stored procedures and functions.

Roles & Responsibilities:

Involved in requirements gathering, analysis, design and development.

Written various stored procedures for application development.

Designed and implemented data access stored procedures and triggers for automating tasks.

Creating reports and hosting them on the web for the users.

Created reports for the senior management.

Successfully tested all the stored procedures on the SQL 2008 server.

Primary Contribution:

Implementation and testing of MS SQL Stored procedures and functions.

Writing of queries to provide various test case scenarios.

Written various stored procedures for application development.

Tuned Stored Procedures.

Created many complex Stored Procedures and used them in Table Report

Macs It.com, Erode - India

Client: Word of Christ, India Sep 2008 – Apr 2009

SQL Database Developer

Project Description: The Project has been designed for the Trust “Word of Christ”, Chennai. The trust Word of Christ decided to take up the “WOC (Word of Christ) Project” to sell Christian Books, and DVDs across India through Online Shopping. “WOC” is categorized into two types of web pages. The first one is the Static Page. It is used to make an online book Selling Process across Indian Customers. The other one is the WOC” Application Page is designed to make Transactions (Sales and Purchase of Books) between the Main Branch and Various sub-branches involved under the trust across India.

Key Challenges:

Understanding and analyzing requirements of creating new stored procedures and functions.

Roles & Responsibilities:

Writing SQL queries and Stored procedures

Primary Contribution:

Implementation and testing of MS SQL Stored procedures and functions.

Writing of queries to provide various test case scenarios.

Macs Info Solution, Erode – India.

Client: TVS Motors, India June 2007 – Aug 2008

SQL Database Developer

Project Description: TVS undertook the "DMS (Dealer Management System) Project" to benefit dealers nationwide. DMS facilitates business growth through improved inquiry conversion, sales promotion, inventory management, and customer insights. It enhances productivity by eliminating time wastage, report inconsistencies, and data duplication. DMS provides a competitive edge by detecting customer leakage and analyzing financial schemes, while also enabling customer database management for loyalty programs and attracting new customers.

Key Challenges:

Understanding and analyzing requirements of creating new stored procedures and functions.

Understanding the entire database architecture of various dealership databases.

Roles & Responsibilities:

Involved in requirements gathering, analysis and development.

Written various stored procedures for application development.

Passed through Testing of Queries along with T-SQL Commands, Stored Proc, Views, Joins and Triggers and modified them.

Tuned Stored Procedures.

Created many complex Stored Procedures used them in Table Reports.

Contact this candidate