Subbalakshmy Dooraiswamy

ac73pl@r.postjobfree.com

PROFESSIONAL SUMMARY

Highly successful IT Professional with a total of 8+ years of professional experience.

Tableau Desktop Qualified Associate.

Microsoft certified data analyst

2+ Years of experience as a Business Intelligence Analyst in developing Data Visualization Dashboards using Tableau & Microsoft Excel, SQL.

2+ years of experience in Business Analysis in the area of analytics and database marketing research.

5+ years of experience in the design, development, testing, and support of Microsoft SQL Server database

Experience as a team lead

Exceptional T-SQL scripting for creating various database objects like Stored Procedures, Functions, Triggers, and Views.

Knowledge of Siebel Marketing and Siebel Analytics.

3+ years of experience in JD Edwards EnterpriseOne as Techno functional Consultant with expertise in designing Interactive, Batch Applications, Business Functions & Table Conversions using JD Edwards EnterpriseOne Toolset. Worked across various modules including Financials, Sales, Distribution and Contract Billing.

Worked directly with the client in the US

Excellent verbal and written communication skills with an ability to explain complex numbers and data to business partners.

Proficient in Microsoft Office Word and Excel.

Ability to communicate effectively both orally and in writing with team members and supervisors, presenting to project team and clients.

Proven ability to work efficiently both as independent, and as a team player and be highly motivated.

TECHNICAL SKILLS

Toolset

Tableau Desktop, SQL Server Management Studio, Microsoft Office (Excel, Word, Access, PowerPoint, publisher, Visio), Microsoft Power BI, Siebel Analytics, JD Edwards - Event rules, FDA, RDA, NERs and C BSFNs, ER Debugger, VC++ Debugger.

Languages

C, C++, AS400 RPG

Databases

SQL Server, Oracle 10g (SQL & PL/SQL)

ERP Package

JD Edwards EnterpriseOne Xe, 8.11 and 8.12

EDUCATION, TRAINING, CERTIFICATIONS & ACCOMPLISHMENTS

Bachelor’s of Technology in Electrical and Electronics Engineering

Tableau Desktop Qualified associate.

Microsoft certified Program for Data science

Oracle Certified Associate (Part I)

Udemy certificate: Tableau A-Z

XII std, Indian school Muscat, secured 83.2%

X std, Indian school Al Wadi Al Kabir, secured 84.2%

4 Months Training in Turbo Plus(C, C++, Data Structure, Oracle, Java)

PROFESSIONAL EXPERIENCE

Haiti – Now (Nonprofit Organization)

Role: Data visualization Analyst

Location: Remote

Duration: Dec 2018- Present

Haiti-Now is an NGO dedicated to empowering Haitian girls living in domestic servitude to overcome poverty and exploitation to achieve economic security. This position deals with analysis, conversion, mapping and visualizing data based on Haiti and the Restavek children using Tableau

Role : Marketing analyst

Client: A top travel industry cruise line in the US

Project Duration: March ’11 till Dec ‘13

Description:

Part of the direct marketing team of Princess Cruises.

Responsibilities:

Design and development of database objects (tables, indexes, stored procedures, functions, triggers) which are used by different consumer applications of client data.

Demonstrate project progress to the Business and receive feedback.

Help QA in answering questions and supporting performance testing.

Preparation and execution of mailing lists for Direct Marketing, including developing target

audiences and executing campaigns in Siebel Marketing and Analytics.

Building, publishing customized interactive reports and dashboard based on Business needs.

Expertise in advanced Tableau features including calculated fields, parameters, table calculations, row-level security, R integration, joins, data blending, and dashboard actions.

Developed Tableau workbooks to perform year over year, quarter over quarter, YTD, QTD and standard monthly reports

Analysis of every mailing and recommendations for future

improvements.

Adhoc analysis involving many different data sources. Preparation of clear,

concise and actionable reports on each analysis.

Custom and routine reports on marketing campaigns and

business trends.

Creation of Structured Query Language (SQL) scripts to create summary data tables to

provide quick reporting, report automation and report accuracy. Development of specifications and requirements for data extraction from several data sources.

Resolution of identified errors and issues related to campaigns and data. Development of a

work-around plan until error is resolved.

Investigate and address customer issues related to campaigns.

Automation of reports to allow users to run reports without analyst's involvement.

Software Used:

Tableau 8, Siebel Marketing and Analytics, SQL Server 2008

Client: Covidien

Client Location: Mansfield, MA

Project Duration: March ’10-Dec ‘10

Project Description:

Covidien is migrating from SAP to JD Edwards. This project deals with loading SAP tables into the JD Edwards tables using batch applications. Also, the current programs assume that every transaction is in the primary Unit of Measure. Few enhancements which included alterations of the existing applications to convert all transaction quantities into the primary Unit of Measure were also taken care.

Responsibilities:

Planning & execution

Business Requirement Gathering

Preparing Technical specification

Coding batch applications

Extensive Code Review

Unit Testing

Software Used:

JD Edwards EnterpriseOne 8.11

Client: Sony Pictures Entertainment

Location: Los Angeles, CA

Project Duration: September ’09- March ‘10

Client Description:

Sony Pictures Entertainment (SPE) is a subsidiary of Sony Corporation of America (SCA), a subsidiary of Tokyo-based Sony Corporation.

SPE's global operations encompass motion picture production and distribution; television production and distribution; digital content creation and distribution; worldwide channel investments; home entertainment acquisition and distribution, operation of studio facilities; development of new entertainment products, services and technologies; and distribution of filmed entertainment in more than 130 countries.

Project Description:

Sony Digital Media is a division of Sony Pictures Home Entertainment. The Sony JD Edwards system has a coexistence environment with JD Edwards One World and World. This project deals with the following:

Digital Contract Management: To implement a combination of Customized Contract Maintenance process and advanced pricing rules through the sales systems.

Enhancements to their existing Discrepancy Management System

Enhancements to the existing Shrink Functionality where shrink can be reasonably analyzed and calculated for a retailer.

Multicurrency: Sony plans to switch on the multi currency. This project requires checking if multi currency logic is already implemented in the existing applications. Else, this needs to be implemented.

Responsibilities:

Planning & execution

Business Requirement Gathering

Preparing Technical specification

Coding interactive and batch applications

Extensive Code Review

Unit Testing

Configuration control

On Call Production support for the P1 issues in AS400 for JDE World Soft & OneWorld

Software Used:

JD Edwards EnterpriseOne 8.0

UST GLOBAL SM (UST), Chennai, India – Software Engineer Sept ‘05 – Sept ‘09

Client: Mainetti

Location: Kwun Tong, Kowloon, Hong Kong

Project Duration: Mar ’09- September ‘09

Project Description:

The client does not have inventory set up. They use JDE for their financial operations. They have 3 rd party systems for pay roll and for sales order processing. All these are brought in to JDE systems using EDI. They have a lot of custom reports in A/P and A/R. The scope of the project is bug fixing and also creation of new reports and application

Responsibilities:

Planning & execution

Preparing Technical specification

Coding batch applications

Extensive Code Review

Unit Testing

Software Used:

JD Edwards EnterpriseOne 8.12

JDE 8.12 Upgrade & BPI

Project Duration: June ’08- Mar ‘09

Project Description:

UST Global has taken the challenge of upgrading Mainetti’s system from JD Edwards 8.0 to 8.12. This involves upgrading their custom code (written in 8.0) to 8.12. Also, our team has been meeting with Mainetti in discussing the Business Process Improvements (BPI) and has come out with 10 enhancements to be implemented in 8.12. Adding to this is the implementation of Oracle XML Publisher as Mainetti's Output Management solution.

Responsibilities:

Upgrade planning & execution

Effort Estimation & Resource planning

Business Requirement Gathering

Configuration control

Reengineering of custom Reports and applications in 8.12

Extensive Code Review

Perform both Unit Testing & Black Box Testing.

Preparing Technical spec for the new enhancements.

Mentoring rookies in the team.

Software Used:

JD Edwards EnterpriseOne 8.0/8.12

JDE Reporting

Client: Covidien

Location: Mansfield, MA

Project Duration: June ’07-May ‘08

Project Description:

This is an enhancement project where we developed Reports like Inventory Adjustment Summary for Period, Inventory Transaction Report, Invoice Register, Credit Memo Register, AR TB Detail with Aging by COT etc.

Responsibilities:

Create new UBE/ Applications using JDE Tool Set by taking Functional inputs from Functional Consultants.

Complete design of the UBE/Application.

Unit Testing of new UBE’s

Peer review

Configuration control

Prepare documentation and Training Manuals for new objects

Software Used:

JD Edwards EnterpriseOne 8.11

Hamilton eSilk

Client: Hamliton Sundstrand

Location: Massachusetts, USA

Project Duration: Jan ’07- May ‘07

Project Description:

The eSilk system is used by Hamilton Sundstrand to record quality data on shipments and to flow down quality requirements to suppliers. The new system will be used to flow quality requirements down to Designated Quality Representative at Hamilton suppliers. The system will also record all the quality data in a database and allow for easy access to this data through reports and database queries. The system will also perform limited enforcement of quality rules flowed down through Hamilton.

Responsibilities:

Analysis of the Oracle procedures, which were required at the backend of this project

Coding Oracle procedures as RPG procedures using RPGLE, Native RPG and SQLRPGLE.

Requirements analysis

Communicating with offshore and onsite

Software Used:

AS 400 RPG

Multi Discount Pricing

Client: Hamilton Sundstrand

Location: Massachusetts, USA

Project Duration: July ’06-Dec ‘06

Project Description:

This project aimed at arriving at a Unit Price in Sales Order entry process by including the Application/Product Line discount. For this process a custom Batch application was created to obtain the application code which gives the Optimum discount for the customer. The system would also populate this application code into the Sales Order Detail fields which will further drive the Advanced Pricing logic.

Responsibilities:

Create new UBE/ Applications using JDE Tool Set by taking Functional inputs from Functional Consultants.

Complete design of the UBE/Application.

Unit Testing of new UBE and applications

Prepare documentation for new objects.

Software Used:

JD Edwards EnterpriseOne Xe

Order Processing

Client: Hamliton Sundstrand

Location: Massachusetts, USA

Project Duration: Jan ’06- July ‘06

Project Description:

To build a Purchase Order application from the information provided by the Purchasing department which will allow users to find, select, add and delete purchase orders. For this, we analyzed the design specifications and formulated a plan to build an integrated application and made the application more productive by the use of system function and Event Rules. Developed the Claims Maintenance application, used to enter, update and track employee insurance claims. Several modifications to this existing application were made based upon user requests.

Responsibilities:

Create new UBE/ Applications using JDE Tool Set by taking Functional inputs from Functional Consultants.

Complete design of the UBE/Application.

Unit Testing of new UBE/Applications

Prepare documentation for new objects.

Software Used:

JD Edwards EnterpriseOne Xe

GP (General Procurement)

Hamilton Sundstrand

Project Duration: Mar ’05-Dec ‘05

Project Description:

GP is a web based tool for nonproduction procurements which is used by both internal and external users.

Responsibilities:

Worked as a SQL developer.

Design and development of Tables, Stored Procedures, Functions, Triggers.

Deployment of the data base scripts (DML and DDL) in different environments.

.

PERSONAL DETAILS

Date of Birth : 22- Jul-1983

Marital Status : Married

Contact this candidate