Dhanalakshmi Vijayakumar

Mobile: 248-***-****

adhpz0@r.postjobfree.com https://www.linkedin.com/in/dhanalakshmi-vijayakumar-73054a1a0

Summary of Skills

10+ years of IT experience working in the field of Data Warehousing as a Data Analyst and Data Modeler.

Extensively worked with clients for all phases of the project from requirements gathering phase to architecting, designing, development cycles and deploying successfully.

Over 8 years of experience with data driven ETL operations & Business Intelligence projects across applications.

Over 3 years of experience with designing and developing Tableau dashboards based on the requirements.

Around 8 years of experience in writing PL/SQL procedures and create new procedures based on business needs.

Responsible for gathering business requirements, developing data models & designing ETL design solutions.

Also, participated in project estimation and Quality audits.

Worked on several projects for clients like Centrica (UK) and Ally Financial Inc. (USA).

Highly skilled with data analysis/analytics and presentation using varieties of reporting tools including SAP BODS, Tableau, Erwin Data Modeler, Access and Excel.

Writes complex SQL scripts to customize data patterns in the application and develop new configurations using Metadata-driven development approach.

Capable of handling any situations within the project with her knowledge and experience.

Technical Skills

Data Analysis & BI Tools

SAP-BI (BODS), CA Erwin Data Modeler, Tableau, SQL Server 2012, SQL Server 2008, SQL Server 2005, SSRS, SSIS, Microsoft Visio, Tortoise SVN, TIDAL, Control-M, Quality Center, VersionOne, ServiceNow

Coding Languages

Java, C, C++, JavaScript, XML

Operating System

Window 7/8/10, UNIX, LINUX, MS-DOS

Database

PL/SQL (Oracle), Netezza, Teradata, MYSQL, MSSQL and MS Access

Professional Experience

Ally Financial Inc, Detroit, United States – Data Analyst March. 2016 – Present

Involved in understanding and translating business needs into data models supporting long term solutions.

Review existing system configurations and operating methodologies. Understand evolving business needs and develop Dimensional data model to support reporting and faster time to market with required customization.

Responsible for designing ETL jobs by capturing transformation logics for each data elements required in the feed.

Coordinates with key stake holders, SME, Application owners and other analysts for business requirement gathering and analysis.

Involved in performance tuning at data base level and ETL job level. Created user-defined SQL queries to fulfill the client requirements.

Performance tuning by analyzing and comparing between SQL and Tableau.

Ally Financial Inc, Detroit, United States – Data Modeler Oct. 2013 – Feb 2016

Understand and analyze the business requirement; propose design solutions and co-ordinate development activities on daily basis.

Involved in designing ETL (Extract, Transform and Load) solutions & mappings for application interfaces according to the business requirements that details transformation logics to be performed on the database using SAP Business objects Data Services tool.

Analyze data related system integration challenges and proposes appropriate data solutions to application development team.

Involved in developing Universe and Reports using SAP Business objects tool for business reporting needs. Developed encryption scripts to load production data to test environments for testing data needs.

Develop SQL codes for customization needs like data suppression, conversion etc. Involved in source file validation script’s coding and performed end to end testing. Involved in preparation of operation manual and Unit Test case documents.

Centrica, Chennai, India – ETL Designer, Team Lead June. 2012 – Sep 2013

Led the team of 15 members in offshore location in India.

Created DDL and DML scripts for Teradata platform. Redesigned and developed SAP BODS ETL (Extract, Transform & Load) jobs to point to Teradata database instead of Netezza database.

Identified bottlenecks in SQL queries and performance tuned long running BODS ETL jobs.

Updated universes and BO Reports to point to Teradata DB. Involved in Process and Delivery audits. Coordinated team activities and project deliverables.

Centrica, Chennai, India – ETL Designer, Team Lead Oct. 2011 – May 2012

Led the team of 7 members in offshore location in India.

Identified data elements required to generate measures related to Engineer as well as dispatcher efficiency.

Developed SAP BODS ETL (Extract, Transform & Load) jobs that extract data from Taskforce Warehouse tables in Netezza database.

Responsible for deciding and maintaining Refresh or history tables (TYPE 1 or TYPE 2 SCD) in Netezza DB based on the client requirements.

Identified bottlenecks in SQL queries and performance tuned long running BODS ETL jobs.

Created universes and BO Reports to support tracking of Engineer and Dispatcher efficiency. Involved in Process and Delivery audits. Coordinated team activities and project deliverables.

Centrica, Chennai, India – ETL Developer Sep. 2009 – Sep 2011

Involved in identifying finance data elements required for generating daily and monthly Revenue reports.

Senior developer in a team of 20 members. Developed SAP BODS ETL (Extract, Transform & Load) jobs that involve complex business and transformation logics to extract data from Work force management and Revenue Warehouse tables in Netezza database.

Created reports to generate opening and closing balance for customers monthly. Involved in Process and Delivery audits. Coordinated team activities and project deliverables.

Education

Master of Science, Software Engineering July. 2013

Birla Institute of Technology and Science, Pilani, India

Bachelor of Engineering, Electronics and Communication Apr. 2008

Anna University, Chennai, India

Contact this candidate