Tableau, Data analysis, SQL, Python
Resume:
Subbalakshmy Dooraiswamy
***********@*****.***
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