Susmitha Chandha

Business / Data Analyst

Phone : 940-***-****, Email : acyw4y@r.postjobfree.com

EXPERIENCE SUMMARY:

Over 4 years of work experience which includes working as a Application Consultant/Data Analyst/ Cognos Developer /Tableau Developer/BI Developer/Business Intelligence/Business Analyst/Project Management.

Worked as liaison between Stakeholders, Different IT groups and IT developers

Worked as BA as well as PM/Financial PM to coordinate Project activities, track and report the progress of project.

Experienced in working closely with business users to gather the requirements, analyze them provide different options as solutions, obtaining requirement sign offs.

Experienced in solving incidents, change requests on time.

Experienced in Designing and Developing Dashboards using Cognos/Tableau for various organizational metrics and indicators, creating new reports and modifying existing reports using industry standards and best practices.

Experienced in creating business requirements documents, test plans, requirements traceability matrix, technical mapping,data mapping, user training materials and other related documentations.

Experience in running ETL jobs using CAWA and fixing the failed batch jobs.

Strong SQL Queries writing skills (DDL- data definition language and DML- data manipulation language).

Good understanding of Normalization /De-normalization, Normal Form and database design methodology.

Good Knowledge in Supply Chain Business.

Knowledge in full System Development Life Cycle (Analysis, Design, Development, Testing, Deployment and Support.)

Experienced in relational databases eg: Oracle.

Experienced in resolving tickets through ITIL process.

Experience with data analysis and reporting tools like Access, Cognos, Tableau and Excel.

Self-motivated and a good team player with excellent communication and interpersonal skills.

Capable of working independently even under high pressure.

Strong in problem solving and understanding new technical concepts quickly.

Technical Expertise

Database : Oracle, PL/SQL, IBM Maximo

Reporting Tools : Cognos, Tableau, SQL reporting

languages : Core JAVA

Development Tools : Eclipse 3.2, TOAD, PUTY.

Operating Systems : UNIX, Windows XP/Vista/7

Financial models : X+Y forecast model

Tools : MS-Excel, Power-point, MS-Project, Remedy, CA-PPM, CAWA,

Maximo, MS Visio, MS Project Plan, MS Access,Sharepoint

Domain : Supply Chain Management

RELEVANT EXPERIENCE:

Employer: Capgemini

Business Analyst/ Project Manager (July 2016 – Sept 2016)

Worked as a Project manager for Capgemini North America sales pursuit team which involves creating a business case for opening a low-cost Capgemini Development Center

Responsibilities:

Documented the business case for creating a low-cost development center and presented in to the leadership team.

Tracked all the tasks, subtasks and Timeline of the project.

Conducted weekly Status calls to know the status of the project.

Analyzed the Real Estate, Workforce management and compensation data with the business case creation team to create a compiled version of the Business case.

Resolved all the roadblocks which was preventing tasks to its completion.

Reached out to individuals to know if they were facing any issues or any concerns related to any information they required.

Employer: Capgemini

Client: Energy Future Holdings

Project/Program Financial Manager /PMO (Dec 2015-July 2016)

Worked as a Program financial manager for 20-million-dollar project which has a very high visibility across EFH IT.

Responsibilities:

The finances are tracked using X+Y financial model (which includes total of 5 projects and data from 15 vendors, tracks actuals, forecast for every month).the model was created using excel VB script.

Gather the resource plan from different vendors each month and update the forecast.

Provide Access to enter timesheet for all the project resources in CA-PPM.

Making sure only project resources are billing for the project, verifying the actuals from Finance team and update the actuals to the model monthly.

Create weekly reports from CA- PPM to analyze the Actuals vs Forecast across all the vendors and proactively monitoring risks associated with it.

Make sure the invoice report from the finance team matches with the hours billed by the project resources.

Present the monthly project financial forecast to the leadership team.

Conduct and drive all the leadership meetings to discuss the monthly program forecast.

Participate in leadership meetings and bring up any concerns or suggestions which

Work with the benefit team in understanding the benefits with the project.

Involve in meetings with the benefits team, restructuring project and all other meetings which could affect the project financials.

Taking care of all the project Change requests.

Modify the Financial model based on new requirement.

Tracking the utilization of the resource monthly.

Tracking the percentage of the project team capacity.

Conduct meetings with all the tower leads and update the staffing plan monthly for demand forecast.

Employer: Capgemini

Client: Energy Future Holdings

Migration of Cognos reports to Tableau – Business Analyst/Tableau Developer

(May 2014-Dec 2015)

The purpose of this Project is to migrate all the existing Supply Chain reports from Cognos to Tableau. Worked as a Business Analyst for the Tableau team to understand the existing Cognos reports.

Responsibilities:

Created business requirements documents, test plans, requirements traceability matrix, user training materials and other related documentations.

Participate in change control planning for production deployments of various Tableau Reports.

Support the tableau team as the subject matter expert through troubleshooting, problem solving and identifying opportunities to solve business problems through BI.

Seek signoff on the requirement document (eg SRD) in coordination with different stakeholders (Development Team Lead, Business Sponsors, and Technology lead, Project Manager, BA, and Requirement Analyst).

Worked closely with the Business team to help them use and understand the new reports in Tableau.

Employer: Capgemini

Client: Energy Future Holdings

Application Maintenance/Development – Data Analyst/ Business Analyst / Cognos Developer and Administrator

(Aug 2013-May 2014)

The purpose of this Project is to provide the Supply Chain group with a BI Reporting solution, leveraging Cognos, which will not only give them the reporting functionality that they have today, but give them a significant improvement in their reporting. This solution will collect and report data for deregulated business units within Energy Future Holdings (EFH).

Responsibilities:

Designing and Developing Dashboards using Cognos for various organizational metrics and indicators, creating new reports and modifying existing reports using industry standards and best practices.

Create business requirements, technical specification documents, test plans, requirements traceability matrix, user training materials.

Worked with the Supply chain business team to make them understand the data mapping from the MAXIMO application to the tables present in the data mart for helping them create their own Ad-hoc reports.

Participate in change control planning for production deployments of various Cognos Reports.

Support all teams as the subject matter expert through troubleshooting, problem solving and identifying opportunities to solve business problems through BI

Resolve Cognos reporting defects and work on enhancements.

Provide adhoc reports as per the Business needs by utilizing Cognos and by writing SQL queries.

Seek signoff on the requirement document (eg SRD) in coordination with different stakeholders (Development Team Lead, Business Sponsors, and Technology lead, Project Manager, BA, and Requirement Analyst).

Provide application support for users and maintain application availability based on Service Level Agreements.

Support the Cognos reporting application and participate in a global work team.

Assist in planning and execution of daily application management processes and activities.

Provide customer support on Cognos and database questions.

Extract, transform and load (ETL) data and investigate and mitigate data-related issues via data validation and data mapping processes.

Working with the Infrastructure team for server migrations, server patching.

Documented Minutes of meeting and communicated to the team.

Provide different Cognos licenses to the Business Users and train the users to navigate the Cognos Application and help them in creating adhoc reports using Cognos presentation layer.

Conducted training to teach the business users to learn the tool and develop ad-hoc reports.

Migrating the Cognos reports from lower environment to the production server

Schedule Cognos reports to be directly delivered to the Business user email or to the SharePoint.

Employer: Gallop Solutions

Client: United Airlines

Business Analyst (Jan 2013-Aug 2013)

This is the core booking engine of the United Airlines. This application gives the privilege to book a flight ticket using the existing miles or Money or a combination of both that are earned by travelling with united airlines

Responsibilities:

Understand the business requirements by engaging with client through meetings and workshops.

Collaborate with diverse groups, Client Stakeholders and Product owners and subject matter experts from teams to analyze business requirements and needs.

Proactively organize meetings with the stakeholders to clarify doubts or discuss new findings.

Document and present the Business Requirements to the customer and get sign-off from the customer.

Coordinate efforts between multiple IT teams and manage customer communication on the progress of Change requests

PRIOR EXPERIENCE

Employer: IDEA Labs (India) (Jun 2010 –Jan 2011)

Java Developer

Automated Solution for a Retail Chain

Developed a Prototype for a Retail Chain, which is a complete ERP solution getting all the modules integrated to a single system that directly connects all the modules, like Retail outlet, Central Repository, Procurement Department to a single System.

Responsibilities:

Responsible for application design, development and testing.

Responsible for the preparations of Low Level Design (LLD).

Responsible for unit testing and implementation.

Involved in the Development and Implementation.

Environment: Eclipse, J2EE, Tomcat 4.18, UML.

TRAINING:

Capgemini Collaborating With Clients Workshop

Enhanced presentation and storyboarding skills

Familiarized with collaborative meeting management tools to run successful meetings

CERTIFICATIONS:

Information Technology Infrastructure Library (ITIL) Certified

HIGHER EDUCATION:

Masters in Computer Science GPA: 3.85/4

University of North Texas May, 2013

Bachelors in Electronics and Instrumentation GPA: 3.7/4

Sridevi Women’s Engineering College May, 2010

Contact this candidate