SUMMARY:

• Data Analyst/Project Manager with 10+ years of experience in oil and gas, banking and utility domains.
• Worked in various capacities including Reporting Analyst, Project Manager, FP&A Analyst, Research Analyst, Operations Analyst, and Scrum Master.
• Deep knowledge in developing Dashboards using Tableau Desktop as well as server implementation.
• Strong understanding of Tableau administration as well as performance tuning.
• Strong documentation skills in generating Project Charter, Scope Document, Milestones, RFP, Budgeting, Change Management Form, BRD, FSD, Non - functional Requirements Document, Use Case Document, and User Manual.
• Well acquainted with Workflows and Unified Modeling Language (UML) diagrams such as, Use case diagrams, Activity Diagrams and Sequence Diagrams.
• Strong experience in working through key phases of the Software Development Life Cycle (SDLC) such as the Planning, Design, Analysis, Development and Testing for the software/system development process.
• Proficient in writing test cases and test scripts and executing tests.
• Experience in project planning, business analysis, process management, contingency planning, change control, gap analysis and root cause analysis.
• Very hands on with Microsoft Excel (Macros, VLOOKUPS, and Pivot Tables). Proficient in Microsoft Word, PowerPoint, Access, Visio, Project Plan and Lotus Notes.
• Expertise in Requirement Management, workshops, JAD sessions and requirement elicitation sessions.
• Hands on experience in writing user stories as well as breaking down stories to fit a sprint cycle.
• Experience in developing strategies for Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouse and Data Marts while ensuring data quality and integrity.
• Experience in Business Intelligence, Data analysis, Data mapping, and Data Migration.
• Skilled at conducting what-if scenario analysis based data as well as quantitative analysis.
• Liaison with all Stakeholders to formulate Functional models and prototypes to meet stakeholder expectations, and Workflow optimization
• Excellent Communication and interpersonal skills, capable of acting as the arbiter between client and developer with respect to project implementation.
• Extensive experience working with end users to answer their questions and gather feedback for requirements during certain phases of project. Expertise in handling workload for multiple projects under pressure environments.
• Very detail oriented and organized in thought process as well as documentation.
• Accustomed to working in matrix organizations with geographically dispersed teams.
• Self-motivated, adaptive and able to work in a team or independently in a deadline-driven environment
• Strong understanding of GAAP and IFRC accounting principles as well as SOX compliance.
• Well versed in NERC CIP v5 regulation governing utility industry.
• Extensive knowledge of networks and various security systems.
• Thorough knowledge of system and application level integration.

TECHNICAL SKILLS:

Methodologies: Scrum, RUP, Waterfall, Agile

Management Tools: Quality Center (ALM), Rational Requisite Pro, SharePoint, SMC, PPmC, JIRA

Operating System: Windows XP/Vista/7/8, Unix

Databases: MS SQL Server, MS Access, Oracle, PI SQL Commander

Applications: SAP, PeopleSoft, JDE, COGNOS, Opexbay, Salesforce.com, Tableau

Knowledge: BABOK, Agile Extension to BABOK, PMI

WORK EXPERIENCE:

Confidential, San Francisco, CA

BI Reporting Analyst

Responsibilities:

• Build Tableau dashboard in Tableau Desktop and publish on Tableau Server.
• Support Tableau admin activities users, groups, folder setup and authentication.
• Provide sophisticated designs supported by complex formula calculations based on parameters and level of detail expression.
• Created processes to organize and manage workbooks and data sources.
• Socialized best practices in Tableau dashboard design, implementation and underlying data management.
• Supported Tableau security scheme in concert with corporate security policies and platforms.
• Automate data extraction and upload processes.
• Optimize dashboard performance through log investigation that led to combination strategy of indexing, materialized views, and data extracts.
• Support ad hoc request for data extraction from Oracle SQL, PI and Teradata systems.
• Document the process and key assumptions for data extraction and dashboard creation.
• Created detailed process flows to aid design documents as well as assist users in building better understanding.
• Provided walkthroughs to users explaining the new features of the dashboard.
• Data validation for migration of PI ATS Historian to RT system.
• Created user stories and updated JIRA on regular basis to track progress of user stories.
• Experience leading, documenting, and facilitating the review process and obtaining formal approval from various stakeholders on business requirements.

Confidential, Santa Clara, CA

Project Manager/ Scrum Master

Responsibilities:

• Lead a team of 4 members responsible for upgrading revenue and billing system for the Asset Management Group.
• Conduct daily Scrums.
• Assist Product Managers in prioritizing user stories.
• Facilitate retrospectives, sprint reviews, and sprint planning sessions.
• Liaison between business groups as well as other technical teams and project team.
• Assisted the team with maintaining the burn down charts.
• Actively gathered and documented business, functional and non-functional requirements.
• Managed design, construction, testing and implementation phases of the project.
• Assisted in Data Quality, Consistency, and Validation check process during ETL.
• Created a mapping document using excel for the QA team for data validation between the input file and the output file.
• Created a process flow diagram using MS-Visio to give a high level concept of the project.
• Revamped the architecture of virtual machined by allocating redundant memory and compute to meet vendor requirements in order to achieve system performance.
• Worked with the development and the QA team during end to end dry run of the project.
• Worked with the QA team during unit, and regression testing.
• Worked with the Line of Business (LOB) during the User Acceptance Testing (UAT).
• Actively managed budget and timeline of the project.
• Delivered documentation as required by the company’s SDLC process.
• Consistently interfaced with Vendor to get product delivery and bug fixes in a timely manner.

Confidential, San Jose, CA

Operations Analyst

Responsibilities:

• Designed processes to capture performance metrics for the service delivery department around contracts, delivery, time-writing, invoicing and backlog.
• Administer service contract and service delivery objects in Salesforce to record and monitor contracts.
• Created an excel based quote tool for the sales team.

Confidential

Credit Project Manager & Senior Assessment Analyst

Responsibilities:

• Embed the organizational changes resulting from restructuring and outsourcing through actively communicating the change and enabling the adoption at all levels
• Credit Assessment & monitoring of over 3,000 customers. Update strategy for customer credit limit on quarterly basis.
• Advice business and leadership on risk/reward ratio associated with exposure.

Confidential

IT Project Manager

Responsibilities:

• Lead the effort of deploying SAP to replace JDE ERP.
• Supported all phases of the SDLC from design to implementation with a special focus on requirements gathering and user acceptance testing.
• Planning and execution of cutover strategy (for master data & transaction data from legacy to SAP for Finance & Procurement function)
• Reconciliation of conversion accounts during test cycle & cutover.
• Reconciliation of Faster & Garance (group reporting tools) with Legacy during test cycle & cutover.
• Support the technical analyst during data loads for test cycle & cutover.
• Act as mediator between business, streamline & deployment teams on key issue identification & resolution during test cycle impacting cut over.

Confidential

Business Planning & Financial Analyst

Responsibilities:

• Responsible for Faster (business level profitability) reporting to the group on a quarterly basis.
• Responsible for monthly variance analysis and reporting of Latest Estimate.
• Supervised reporting of Opex bay & OPSM (Group reporting tools) used for reporting operating expenditure & customer level profitability respectively.
• Reporting financial highlights to Country Leadership Team on a monthly basis.
• Responsible for yearly planning of expenditure for controller’s area including treasury & tax.
• Prepare, update and maintenance of Manual of Authorities.
• Preparation and reporting of financial accounts of Confidential Livewire Trust.
• Coordinated confirmation of controls for functions area including credit, HR, Legal & External Affairs.
• Responsible for overall accounting, auditing & holding trustee meeting of the Livewire Trust Fund sponsored by Confidential .

Confidential

Research Analyst

Responsibilities:

• Write research reports on the industry as well as individual companies giving investment recommendations.
• Analyze business models based on fundamental analysis from a top-down and bottom-up approach.
• Build excel based financial models with sensitivity and scenario analysis.
• Write periodical publications covering economic issues & their impacts on various industries.
• Provide financial analysis for clients’ specific requests.
• Create and deliver research presentations to fund managers & high net worth clients.