JAYANTHI MURUGAN
Stallings,NC
Summary
Over 8+ years of MS SQL Server/MSBI Suite design and development experience in various domains MS SQL Server 2012/2008 and Microsoft’s BI suite of products like SSIS, SSAS, SSRS and Power Bi desktop. Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, views, indexes, user profiles, Relational Database models, Data integrity, query writing and SQL joins. Strong experience in Stored Procedure, Formulated Stored Procedure/TSQL coding, Performance Tuning and Query Optimization. Extensive experience in Data Massaging, Data Cleansing, and Data Scrubbing using different SSIS Transformations e.g. Fuzzy Lookup, Lookup, Derived Columns, Conditional Splits, and Execute SQL Task. Expertise in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008 and MS SQL Server 2005 respectively. Extensive Knowledge in creating complex SSIS and DTS packages for ETL purposes. Implemented complicated transformations to be used in SSIS packages. Expert in Data Conversion, Normalization and Data Modeling, Multi-Dimensional Modeling and involved in creation of Fact Tables, Dimension Tables, Star Schema and Snowflake dimensional schema using Erwin Tool. Proficient in creating On-demand and Scheduled reports, handling sub reports and defining query for generating drill down reports using MS SQL Server Reporting Services 2005/2008 (SSRS). Highly skilled in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2008/2005. Expert in using tools such as Bulk Copy (BCP) and Data Transformation Services (DTS). Extensive knowledge in developing and implementing Disaster Recovery Model, and Replication Models. Expert in using tools like MS SQL Profiler, Index Tuning Wizard, Windows Performance for monitoring and tuning SQL Server performance. Strong experience in developing Power BI reports and dashboards. Created dashboards for the financial reports in MS Excel. Used Excel to create pivot table for management to do more analysis. Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies. Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
Overview
11
11
years of professional experience
Work History
SQL Server/Power Bi Report Developer
TRUIST
06.2021 - 01.2024
- Created databases and tables for Data Conversion Projects
- Wrote Complex Store procedures to run dynamically
- Loading the data from flat files to staging area using SQL Loader
- Mapping data between Target tables and Source Database tables
- Developed the Auto Test Script to do validations to eliminate the unrequited data
- Developed reports to explore data and create an interactive report in SSRS
- Developed Power BI reports and dashboards from multiple data sources and published them on Power BI Service
- Built Measures and Calculated columns using DAX
- Utilized, and optimized the use of, multiple large data sets
- Integrated different data sources and created data sets within Power BI
- Understood the ETL involved in creating data sets for reports
- Implemented several built in excel functions and formulas
- Implemented pivot tables and charts in excel for summarizing data
- Developed data queries for existing or proposed databases or data repositories
- Developed and managed strong relationships with Business Team members to help prioritize work effectively to meet strict delivery timelines
- Developed Macros and formulas in Excel
- Data Validation in MS Excel created forms for data entry while using data validation
- Used Azure DevOps for development services to create the Test Plans for a team to support and build the task.
Data Analyst/MS SQL Server/Oracle/SAP HANA
Duke Energy
07.2020 - 06.2021
- Optimized a lot of SQL statements and PL/SQL blocks by analyzing the execute the plans of SQL statement and created and modified triggers, SQL queries, stored procedures for performance improvement
- Worked on SQL Loader to load data from flat files obtained from various facilities every day
- Importing data from different varieties of sources like a flat file, excel file or Oracle dump file into oracle database source schema tables using SQL Loader
- Documenting business rules, functional and technical designs, test cases, and user guides in the system requirement specifications
- Performed unit testing and path testing for application
- Built and maintained SQL scripts, indexes, and complex queries for data analysis and extraction for varies projects
- Used SSRS to create versatile reports and presentations for business groups
- Used query editor in Power BI to fetch data from different file
- Used various sources to pull data into Power BI such as SQL Server, Oracle
- Created dashboard by using various bar and pie charts
- Imported data into excel from flat files
- Used Power BI desktop to connect various data sources
- Wrote and executed SQL queries using Query Analyzer to provide custom reports to marketing and sales Experience in HANA Technical Consulting Skills as team member and analyzed the data to provide clean data
- Overall experience in business and technical roles, ideally in analytics Defined the process for doing weekly/monthly/quarterly maintenance reports
- Data deliverables were of high quality and delivered on time
- Report development using Oracle SQL and MS SQL.
Report Developer/MS SQL Developer
Coastal Federal Credit Union
04.2017 - 07.2020
- Responsible for the development and implementation of the organization's reporting strategy
- Report packages and the minimization of manual preparation by automation to promote efficiency, accuracy and timely delivery
- Performed data validation reports in SQL Server Reporting Service (SSRS)
- Reported all events and requirements through established reporting mechanisms in SSRS
- Wrote store procedures for some job automations
- Developed various operational Drill-through and Drill-down reports using SSRS
- Developed different kinds of reports such as Sub Reports and Charts, Matrix reports
- Created queries with Inner Join, Outer Join, and correlated sub-query with String function, Mathematical function, Aggregate function, Date and Time function
- Created Stored Procedures, User-defined Functions to take care of back-end validations when transferring data to Production Server
- Generated reports using SSRS and Excel (Pivot) that could be used to send information to diverse groups of users, clients, and manages.
Data Analyst/MS SQL Developer
Measurement Inc
09.2015 - 01.2017
- Working on several projects for the Canadian Agency Education Quality and Accountability Office (EQAO) to measure students’ achievements in all subjects
- For each Assessment: Complete a database Request form for initial setup of database, create new tables, Indexes, Stored Procedures, Triggers, Roles, and User Access
- Tables are populated with data from several sources such as (Excel, Access, and SQL Server Tables) using DTS, SSIS, and SSMS Database Tasks Import/Export from and to Database and non-database objects
- Automated the process of creating the tables that the customer requests using the list of columns the customer provides in an Excel Spread Sheet by using Dynamic SQL Code
- Create a Frequency Distribution Report for the questions answered and have data vs
- The total number of questions, this report will help us identify any missing data before delivering to customer
- Created several new views with SCHEMABINDING option, for Publication and Replication for our client (EQAO) to access the data after it has been replicated
- Troubleshoot and resolve problems, designs and develops MS SQL complex SQL queries, Maintains and troubleshoots an SQL Server production environment
- Write/Create new or modify existing SQL code, Stored Procedures, Functions, Triggers, Views, Indexes, and Tables
MSBI Developer/SSRS
Anthem Inc
11.2014 - 07.2015
- Designing Data Model and implementing changes in the earlier phase of the project to accommodate business logic and dynamic nature of the front end application
- Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost
- Performed T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2008
- Developed interface and reporting stored procedures, views, UDF for efficient data storage and manipulation
- Creating Stored Procedures for Reporting in SSRS
- Created Drill Down, drill through, sub and linked reports using the SQL Server Reporting Services SSRS as well as managed the subscription and authentication of these reports
- Maintained scheduling of subscription reports with the subscription report wizard
- Handling the errors during data moving and sequencing the task as per requirements
- De-normalizing database using Stored Procedures for a single row feed to legacy system.
SQL Server Developer/SSIS/SSRS
Valley National Bank
11.2012 - 10.2014
- Worked with project lead and business users to understand business processes, gather and document project requirements and translate them into functional and non-functional specifications for BI reports and applications
- Actively participated in interaction with users, team lead
- Highly Involved in Profit and Loss financial reporting system process including packages, debugging & data analysis, report balancing and verification
- Transmitted data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012
- Responsible for creating database objects like Views, Store Procedure, Triggers, Functions etc
- Using T-SQL 2008/2012 to store data and to maintain database efficiently
- Planned, Designed and Implemented Store Procedures
- Tuned the SQL queries using SQL profiler
- Involved in tuning more than seven times
- Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
- Used ETL to implement the SCD transformation, to maintain historical data in data warehouse
- Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS
- Developed and deployed data transfers packages using SSIS 2008/2012, also maintained the jobs running on Servers
- Wrote SSIS Packages to migrate user’s logins, stored procedures, and functions
- Responsible for implementation of data viewers, SSIS Logging, error configurations for error handling the packages
- Was part of the UAT group that implemented ADP Upgrades & Report Smith Version upgrades
- Was responsible for creating Ad-Hoc reports using Report Smith
- Analyzed the Business Requirement and developed a Test plan from Use Cases which consisted of the scope and objective of the testing process
- Developed Test cases and Test scripts based on business requirements
- Performed both Manual Testing and Automated Testing Responsible for developing test scripts in cross checking with Business Requirements
- Used Reporting Services to consume data from SharePoint sites and display reports and dashboards on SharePoint sites
- Highly involved in automating reports generated weekly and monthly basis for the client and business sales teams
- Gathering details for the requirement, creating documentation and specification and updating to the wiki link
- All reports were scheduled as per the delivery requirements
- Thereby reducing the number of resources involved
- Deploying, Testing and Scheduling SSIS packages using SQL Agent
- Worked as Build Manager, to schedule and deploy tickets using tools like TEST TRACK, TFS, VSS and Jira.
Education
BBA - Accounting
University of Madras
Tamil Nadu IndiaSkills
- Advanced analytics
- Dashboard creation expertise
- Project Management Capabilities
- Data Collection
- Report automation
- Reporting efficiency and accuracy
- Data Analysis
- ETL processes understanding
- SQL Server Integration Services (SSIS)
- Data Extracting
- SQL Reporting
- Extraction Transformation and Loading (ETL)
Certification
Microsoft SQL Server 2012
Brain SQL Server Programming
Advanced Microsoft SQL Programming Certified in NC State.
AWS Partner: Accreditation (Technical)
Timeline
SQL Server/Power Bi Report Developer
TRUIST
06.2021 - 01.2024
Data Analyst/MS SQL Server/Oracle/SAP HANA
Duke Energy
07.2020 - 06.2021
Report Developer/MS SQL Developer
Coastal Federal Credit Union
04.2017 - 07.2020
Data Analyst/MS SQL Developer
Measurement Inc
09.2015 - 01.2017
MSBI Developer/SSRS
Anthem Inc
11.2014 - 07.2015
SQL Server Developer/SSIS/SSRS
Valley National Bank
11.2012 - 10.2014
BBA - Accounting
University of Madras