Priya Dhanasekaran

ad353n@r.postjobfree.com

Contact : 203-***-****

No Sponsorship Required

● Around 7 years of experience as Senior Reporting Data Analyst/ SQL Application developer in reporting, analysis, design, development, implementation, testing, maintenance, and documentation of Database and Client Server applications.

● Extensively worked on large set of telecommunication data,financial data, involved in server migration,data loading, cleaning, normalizing and automation.

● Extensively involved in user story elaboration, technical interface discussions, created design documents.

● Extensively worked on generating various reports like KPI,Score card by Extracting large volume of data from various server using ETL tools like SSIS, python. Creating dash board for Bussiness by creating metric with complex sql queries, using data visualization tools like Power BI,Tableau and micro strategy(BI).

● Knowledge in Report Generation,Data Extraction, Transforming and Loading (ETL) using various tools such as micro strategy,Excel,MS Sql,Oracle,Tera data,Sql server,Data Transformation Service

(DTS), SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication, data visualization tools like tableau and power BI,Python.

● Highly motivated team player with immense ability to grasp new domain knowledge, analytical thinking and strong communication skills.

● Strong analytical and Problem-Solving skills, multi-tasking with proven experience in utilizing team and process knowledge to assist enterprises in making critical decisions. EDUCATION

University of Bridgeport, Bridgeport, CT -USA Graduation Date: Dec 2017 Master of Engineering, Electrical and Computer Engineering Related Coursework: Analysis of Algorithm, Advance Database, Data and computer Engineering, Sustainable Energy, Electric Machines, power Electronics, VLSI Testing, Digital VLSI, RF VLSI. Awarded scholarship

Vellore institute of technology, Vellore, India Graduation Date : Jul 2013 Bachelor of Engineering, Electrical and Electronics Engineering Related Coursework: C++, Data structures and Algorithm WORKING EXPERIENCE

CHARTER COMMUNICATIONS:

Senior reporting and data analyst - Full time

March 2021– March 2022

Promoted to Senior data analyst in Charter communication my main responsibility was to provide deep analysis on large volume data set using complex SQL queries and reporting tools .Reports generated help business make valuable decision on organizational growth, forecast companies performance and future business development.Simultaneously guided the team in automating existing reports and also evaluating the impact of sever migration on existing reports as charter communication was in the process of merging the legacy companies data I.e Time Warner cable and Bright house network.Also was involved in various projects like KPI report,PAC scorecard, Offline scorecard,PAC SLA . Roles and Responsibility:

● Guiding the team in generating the report and automation .

● Analyzing the report and and providing useful insight for business decision making.

● Spontaneously working on adhoc report for business user in quick span of time and help business in analyzing.

● Spontaneously working on metric changes requested by users, as each metric involves complex logical calculation which is used to measure the performance of the business which requires necessary SQL code change .

● Understanding the impact on report during server migration and instantly make necessary changes to SQL code, so reports will be delivered in accurate manner with out impacting the business .

● Working with various other team during server migration . Environment: Oracle 11g, SQL Developer, MS sql, Tera data,Advanced Excel(pivot table,lookup, functions and formulas), Micro strategy,Tableau. CHARTER COMMUNICATIONS:

Data analyst - Full time

November 2019 – March 2021

Worked as a data analyst in Charter communication where the main responsibility was to gather the requirements from the user for report generation, also analyze data using SQL queries,Excel, Micro strategy . Responsible for maintaining the data integrity for daily reporting needs and loading large volume of data from various servers to generate the report. Key member in automating the reporting using micro strategy. Also was involved in various projects like RTCSR,Apple TV return,Offline monthly report,self install. Roles and Responsibility:

● To gather requirement from business to generate the report and involve in multiple discussion to understand logic behind each metric to generate report in an accurate manner.

● Gather data from various server to generate report based upon business needs.

● Involved in writing the complex queries to analyze the data, query tuning and generating stored procedures for automation of reports.

● Responsible for maintaining the data integrity of daily data loads to generate the reports.

● Responsible for maintaining,analyzing daily weekly and monthly report for budget forecast. Environment: Oracle 11g, SQL Developer, MS sql, Tera data,Excel, Micro strategy. BATTEA CLASS ACTION SERVICE:

Data Analyst/SQL Developer - Consultant

March 2019 – Nov 2019

Worked as Data analyst in Battea is a class action suit company which helps law firm in filing to recover losses for the investors. Where the main responsibility was to handle large financial trade data set and to analyze the data, automate the repetitive task, was involved in processing large volume trade data according to the client requirement and to ensure data integrity. Also was involved in various other projects like tracking the client data, checking for date gap and account mapping. Roles and Responsibility:

● We receive large volume of trade data from the clients through different means, my responsibility was to validate the data integrity, map and load it in to structured database and analyze the data.

● Involved in normalizing the data according to the client requirement and do holding analysis to check if the given data is accurate.

● Involved in writing the complex queries to analyze the data and tune the queries to improve the performance.

● Extensively worked on automation process by writing complex stored procedures to analyze repetitive task like finding out date gaps, duplicates.

● Responsible in designing, building and executing Visual Cron jobs for the projects like Client data tracking, finding date gaps, account mapping.

Environment: Oracle 11g, TOAD, SQL Developer, Excel, Visual Cron,Python. SYNAPSE GROUP INC:

SQL Developer - Consultant

January 2016 -March 2019

Worked as a SQL Developer in clubs conversion project for Synapse Group Inc, where the main responsibility was to create DB Scripts and manage data loads. Synapse is a magazine marketing company who then expanded its wings to managing clubs’ platforms which has added great value to the business. Clubs Conversion project involved creating data load tables, data mapping, building database scripts for conversion and writing complex queries for data validation, also involved in writing complex queries for reporting user information.

Roles and Responsibility:

● Extensively worked on DDL, DML, T-SQL, views, stored procedure and packages

● Creating Complex Business Stored Procedures, Tables, CTE’s, Cursors, Views, Indexes, Triggers and Functions

● Extensive knowledge of partitioning of tables creating materialized views and performance tuning.

● Knowledge SSIS, SSRS, Bulk Insert, BCP, Mirroring and Replication.

● Managing of database objects like Tables, views, indexes etc.

● Developed T-SQL queries create data sets for reports.

● Managing users including creation/alteration, grant of system DB roles and permission on various database objects.

● Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.

● Developed Dynamic and Static Stored Procedures and Queries to maintain and store details of customers.

● Optimized SQL queries for improving performance and availability.

● Participated in Performance Tuning of SQL queries using Explain Plan to improve the performance of the application

● Designed, analyzed the databases.

● Coordinated with the reporting teams to generate reports. Environment: Oracle 11g, MS SQL, SQL * Plus, TOAD, SQL Developer, UNIX, Windows XP. SUBWAY

Junior SQL Developer - Consultant

August 2014 - December 2015

Worked as a SQL Developer for Subway, where the main responsibility was to manage of database objects like Tables, views, indexes etc. I was involved in writing complex queries for reporting store information. Roles and Responsibility:

● Performed debugging of the PL/SQL codes using the DBMS_OUTPUT.

● Participated in application planning, design activities by interacting and collecting requirements from the product owner.

● Create indexes on some columns of tables to increase the applications performance.

● Created Cursors and Ref cursors as a part of the procedure to retrieve the selected data.

● Providing the Support to Production Team, Testing Team (SAT). Environment: Oracle 11g, SQL Developer, MS sql.

IGATE GLOBAL SOLUTIONS:

Junior SQL Developer - Consultant

May 2013 - June 2014

Workflow application is a “Deal Approval process” between GE and its Customer. A key contributor in analyzing the requirements and created design to cover all the use case. Worked along with business team to create reporting queries.

Roles and Responsibility:

● Very strong SQL Development Skills which includes creating Complex Business Stored Procedures, Tables, CTE’s, Cursors, Views, Indexes, Triggers and Functions.

● Strong experience of DDL, DML, T-SQL, views, stored procedure.

● Identifying long running queries, packages etc., implementing appropriate tuning methods.

● Created permanent tables, temporary tables and table variables.

● Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.

● Used Joins to write queries that retrieve data from more than one table. Environment: Oracle 10g, My SQL, SQL * Plus, TOAD, SQL Developer, Windows XP. TECHNICAL SKILLS

Programming: T-SQL, PL-SQL, C.

Database tools: Oracle 11g,SQL Server Management studio, MY SQL Work bench,SQL developer, Tera data. Reporting tools: Advanced EXCEL( creating pivot table,lookup, functions, formulas), Micro strategy, SSRS, tableau,Power BI.

ETL tool : SSIS,python.

Contact this candidate