SUMMARY:

• 12+ years’ experience of collaborating with business stakeholders and technical staff to meticulously architect information system or process for business users within the stated budget and scope.
• Capable of partnering with cross functional stakeholders for understanding business problems/opportunities to design a process or an information system.
• Capable of delivering system to achieve desired software functionality using Agile, Waterfall etc. SDLC methodologies.
• Advanced written, verbal and presentation skills to present findings, recommendation, challenges, define scope, justify budget, escalate problem, project plan, project schedule, resourcing needs to stakeholders using MS Project plan, MS Visio, MS Word, MS Excel, MS PowerPoint.
• Plan, design, present and execute proof of concept projects in the limited duration. Request quotes and evaluation software edition/license from vendors to test its usability to business. Perform the cost benefit analysis by considering acquisition/maintenance cost and recommend appropriate course of action
• Expert in studying system to be converted/ upgraded/ migrated/ decommissioned to document the operations, process, functionalities in “As - Is” state; Partner with stake holders to document “To-Be” state of new system.
• Evaluate solution alternatives, system improvements, and process improvements including build vs. buy options and provide recommendations.
• Vast experience in negotiating/defining/gathering requirements, creating use cases, Creating activity diagram, documenting system design, creating mockups, documenting Workflow, creating flow chart, creating UML diagrams, reviewing technical design document, creating test cases, facilitating UAT, pursuing sign offs.
• Expert in capturing detailed work activities, justifying work/project, defining scope, defining project output, preparing detailed project plan, managing project backlog, creating milestones to track progress
• Expert in leading projects, enforcing standards, creating scorecard, generating management reports, pursuing data governance, escalating time-slip or scope creep
• Extensive experience in executing projects through requirements, design, development, QA, maintenance, audit and support phases.
• Expert in establishing complex-DWBI solutions by driving dimension modeling, ETL and reporting initiatives. Development experience on Reporting tools (Business Objects Enterprise Suite), ETL (BODS, Data Stage), Dashboards (SAP Dashboard, QlikView, Tableau).
• Ability to contribute to evaluation of processes, operations, systems to suggest changes needed to keep progressing towards the strategic and operational goals.
• Expert in creating documentation template, requirements checklist, test plans, project planning check list, Knowledge base documents, FRD, Audit document, Quality reports, Gantt Chart, project resource template, project activity cost, issue tracker
• Expert in defining SLA, proactive support guidelines, reactive support procedure, reporting and escalation methods

TECHNICAL SKILLS:

Microsoft Project Plan(10 Years), Business Intelligence (10+ years), Business Analysis (10+ years), Use Cases (10+ years), Test Cases(10+), Erwin(10+), Mockups(10+), Data Analysis (10+ years), Business Objects (10+ years), Reporting framework Architect (8 Years), Business Objects Administrator (10+ years), SQL (10 years- Teradata, Oracle, SQL Server), Project Management (8 years), Quality Center(8 Years), MS Visio (8 Years), Excel (10 Years), Word(10 Years), PowerPoint(10 Years), JIRA (5 Years), WIKI (5 Years), Service Now(6 Years), PPM (6 Years), Remedy (7 Years), ETL (10 Years- BODS), Reporting (10 Years- BOE), Dashboards (10 Years- SAP Dashboard, Tableau, QlikView), Data Governance (10 Years), KPI implementations (10 Years)

WORK EXPERIENCE:

Confidential, Los Angeles

SaaS Implementation Analyst

Responsibilities:

• Plan milestones, develop project plan and publish weekly progress reports
• Create AS-IS workflows detailing existing processes and Create TO-BE system workflow of the new processes
• Document LR Tracker, Credit Tracker, Claims Tracker, Grievance Trackers built in FMpro 11, 12 and create detailed requirements to convert those to FMPro 16.
• Analyze and document existing eBilling processes, Compliance reporting, Union/non-Union WB employee compensations, LawManager RFI/RFP to payment stages workflow
• Participate in SaaS vendor RFI/RFP and vendor selection process by mapping the product feature to the WB users Business function and process and vendor reference check, Convert existing invoices and matters to the CouncelLink SaaS System.
• Facilitate Requirements gathering, requirements sign off, testing, UAT, Deliverable signoff from Labor Relations, Antipiracy, Trademark group users, Human Resources
• Create FAT, SIT, UAT test cases and create test plan, arrange test data set & test roles
• Track and Manage SaaS application deployment, Win10 Upgrade, Office 2016 Upgrade and Testing, UAT etc.
• Create auto populating testing tracker, defect tracker and publish weekly project progress
• Create excel templates to track Test cases, Testing status, Error-Remediation status with Built in Formulae for status reporting.
• Direct and drive reports and dashboard development
• Query database for analyzing duplicates and UAT errors

Tools: Excel, Outlook, Sharepoint, Power Point, Visio, OneNote, OneDrive, MS Project, SAP BAPI, FileMakerPro 11, 12, 16, LawManager, CounselLink, Osprey RiskManager, Office 2016, Outlook 2016

Confidential, Los Angeles

Business System Analyst/Delivery Lead

Responsibilities:

• Meet Sales, Marketing, Dealer Relations, Finance department and create the BRD, FRD, Requirements document. Perform the Cost benefit and requirement Prioritization
• Develop a new process for pull ahead program, dealer performance analysis and negotiating requirements for the new system to map to computerized system
• Study Legacy Actuate/Kana ETL and reporting system and mapped those to current business needs
• Analyze usage reports to determine Must have, Nice to have vs Phased out content from Gateway & InfoCenter
• Consolidate the existing ETL & Reports to create control the volume of the content required in the new system
• Create Mockup of the new system, System workflow and business function workflow
• Create specification, requirements documents, coordinate testing, UAT etc
• Coordinate with technical team, backend vs frontend and with source systems
• Coordinate old system decommission, architecture review, user access
• Release business process reporting framework to decommission excel & macro reports

Tools: Excel, Outlook, Sharepoint, Power Point, Visio, OneNote, OneDrive, MS Project

Confidential, Los Angeles

Business System Analyst/Lead

Responsibilities:

• Lead, manage and co-ordinate with Results Analysis team, Portfolio manager, investment manager to understand their requirements
• Lead, manage BSAs, Product owner, Developer, QA team to make sure deliverable scope is appropriate and Sprint cycles are delivering the work defined in Agile stories
• Create Epic, Stories, Defects, Data reconciliation report, Outbound file contracts
• Study Vendor tool B-One to see its usability to deliver the Investment KPI like standard deviation, R2, Sharpe Ratio, correlation factor, cumulative/annualized returns for various periods
• Evaluate buy vs build analysis and deliver a cost benefit analysis, presentation supporting documentation to plan its disintegration into Investment Management & Results analysis, separate & define the scope
• Study the legacy system MARS to create a blue print of how many parts to divide it into to simplify the Fund and manager Results calculation and make sure the maintenance is low
• Learn the needs of downstream systems to understand their challenges with MARS and their expectation out of new system
• Create documentation on Word, Confluence, Wiki, Jira, Mindmanager, Visio etc.
• Design UI, logical data model, data or table columns mapping and present it to stakeholders like users, Dev team, BSA, QA
• Review test cases, defects, knowledgebase, problem solution, design review, code review, sprint retrospective

Tools: SharePoint, B-one, JIRA, WIKI, SSIS, Excel, Microsoft Office Project Plan

Confidential, Los Angeles

Business Systems Analyst

Responsibilities:

• Co - ordinate with directors, architects, project managers, SME for status reporting, project activities planning and expectations management
• Facilitate daily and weekly Stand up meetings, status meetings
• Create, maintain and publish project health report, project progress card, defect status to provide clear picture of project progress and work done vs work remaining
• Work closely with business SME and SAP developers to configure SAP ECC, SAP CRM
• Own creation of POC, mockups, use cases, system flow chart, test cases per requirements demonstrated by users. Create functional and design documentation and facilitate its review. Get a sign off on requirements
• Analyze risk, create mitigation plan, create communication plan, document detailed work activities and find alternative solutions.
• Own through system implementation and ensuring final system is correct.
• Thorough review of all contract documents, FRD, plans, specifications, reports, takeoffs, technical design documents and functional design documents
• Lead developers for delivery of information system providing the details about rental units, pending agreements, equipment use, facility use, maintenance requests, and truck load success rate
• Lead developers to implement failure alerts for scheduled ETL jobs, scheduled Reports, server hardware failure, server operations failure etc.
• Drive and participate in UAT, solutions designing, application testing, functionality testing, code validation, logic validation, data corrections, data analysis, and requirements analysis, create ETL/Reporting logic, debug data errors, and debug business rule calculation errors, write data validation queries using Microsoft SQL Server
• Manage recurring issues, break fixes, fixes that failed

Tools: Kanban, JIRA, Wiki, Excel, Word, MS Visio, UML, PowerPoint, Java, Microsoft project plan, Business Objects Enterprise, Crystal Reports, BODS, Tableau, SQL Server 2012, SQL Server studio, SSRS, SSIS

Confidential, Los Angeles

Business System Analyst/Lead

Responsibilities:

• Function under minimum guidance in the agile software development environment to integrate functionality supported by legacy Macro, VB system, and interview portfolio manager, pricing analyst for understanding business rules and study their data needs.
• Help scrum master to manage backlogs, epics, stories for agile development and create project status report
• Work with architects, SME, PMO, team members for defining business rules, defining aggregating rules, requirements prioritization, access setup, gap analysis, information transformation, data usage rules, validating data consistency
• Estimated hours for projects activities and client requests within vs outside of SOW
• Create and manage project backlog with the detailed activities from inception to completion, define pre - requisites, dependencies and dependents for tasks
• Co-ordinate with Team members, SME for requirements gathering, status reporting, helping PMO maintain project plan, set milestones, maintain progress Gantt chart
• Work with cross functional team to ensure requirements were properly captured and converted to design document and test cases. Ensured project scope is captured correctly.
• Ensure all team issues were timely resolved so that quality and accuracy of all projects were maintained
• Led daily Hot sheet meetings and weekly Status meetings
• Study functions and operations of the legacy macro/VB system to create As-Is system documents, To-Be design documents, FRD, flow chart, use cases, communication diagram, business rules, data calculations, data masking rules, mockups and blueprint of new system
• Lead developers for the design implementation, enhancements, testing, QA, UAT
• Identify sensitive information for data masking and perform root cause analysis for data inconsistency, convoluted data, recommend corrective solutions
• Create data model, test cases, validation queries; Perform data validation, data analysis
• Facilitate requirement sign off, application testing, QA, UAT, code validation, code migration, production rollout

Tools: PPMC, SharePoint, MS Visio, Excel, Word, PowerPoint, Beyond Compare, UML, Microsoft project plan, JAVA, Macro, VB, Business Objects Enterprise, Crystal Reports, Oracle, Toad, SQL, Tableau

Confidential, Los Angeles

Business Operations Analyst

Responsibilities:

• Communicated project status to all stakeholders, including team members, finance, justified budget and immediately escalated any timeline or scope issues
• Worked with account managers & resource managers to ensure project scope was understood and signed off so that projects were appropriately staffed
• Ensured all team issues were resolved so that quality and accuracy of all projects were maintained and project timeline was controlled
• Coordinated and assisted in QA process to ensure that projects launched per company and client standards
• Arrange, own interviewing and meeting Finance, Business development, Marketing teams, data stewards, CIO to understand their application requirements.
• Create project plan, manage goals/milestone, maintain project score card, provide status updates, create performance reports in WIKI, JIRA, MS Visio, Word, Excel
• Facilitate gathering requirements, designing application, creating mockups, designing test cases, create requirements document and design document
• Facilitate defining telecom KPI like quote to sale, expense per user, revenue per user, connects by day/time of the week, usage by venue, service up time, service outage, sales per lead, Budget vs Forecast vs actual, voluntary/involuntary churn etc
• Act as a liaison between business and technical team to communicate challenges
• Identify/find/create bug fixes or alternative approach for problems encountered during design implementation and testing
• Create data dictionary, define data elements, documentation KPI, create KPI calculation rules and present those to business users
• Facilitate demo, training, User access setup, application testing, performance testing, QA, UAT, code review, production release Participate in and lead data modeling to implementation the newly defined KPI, create data loading logic, create reporting logic, create data validation queries, validate data correctness, implement KPI formula in the analytical system
• Lead design of reports and dashboard for different departments with the newly defined KPI
• Drive application design to project newly defined KPI s and integrate dashboards and reports in the Java front end

Tools: JIRA, Wiki, Confluence, MS Visio, Excel, Word, PowerPoint, Beyond Compare, Erwin, Oracle, Toad, Java, Microsoft project plan, BODS, Live Office, Tableau

Confidential, Los Angeles

Business System Analyst/Lead

Responsibilities:

• Manage all aspects of the project to re - design and re-launch the FAMIS User Interface for clients
• Create detailed programs and project plans with definition of the tasks and resourcing needed to bring projects to completion.
• Manage the scope, schedule, cost, risk and issues of the project and track the progress.
• Weekly status reporting and presentations to senior management, clients and other stakeholders.
• Own study of SONI, FIFI, STAR systems to document functionality, eliciting requirements, analyzing business rules, identifying data transformation, gathering operational particulars
• Design blue print of FAMIS system, create use cases, create data model, create data mapping, create test cases, create requirements documents, FRD and communicate details with the implementation team
• Own and facilitate data merging from different system, find pattern, perform root cause analysis for data inconsistency and data issues, enforce data governance practices, ensure data correctness
• Analyze and lead document data problems, research solutions for data problems and help in implementation, maintain record of the challenges faced
• Facilitate data corrections, data analysis, and requirements analysis, create ETL/Reporting logic, debug data errors, and debug business rule calculation errors using Oracle database, Rapid SQL, beyond compare
• Coordinate with Architect, Business users, DBA, ETL developer, Java Developer, Manager for creating project plan, manage goals, maintain project score card, status reporting
• Lead Design, Development of new application, data model, ETL jobs, BO universe, Crystal Reports, Webi reports, Tableau Dashboards per project requirements
• Manage and Facilitate code validation, code migration, QA, UAT, testing defects, production release
• Demo and Training functional and operational staff on new system

Tools: Microsoft project plan, QC, Remedy, Sharepoint, Beyond Compare, UML, MS Visio, Excel, Word, PowerPoint, BOBJ, Crystal reports, Webi reports, SSIS, SSRS, Java, Business Objects Enterprise, Oracle, Rapid SQL, SAP Marketplace, Tableau

Confidential, Los Angeles

Project Manager

Responsibilities:

• Work with Senior Account Executive to determine project scope based on allotted budget
• Work with Senior Management to maintain Budget/Scope Tracker
• Estimate costs for BIDW, Reporting projects and proactively escalated all changes in scope and budget to Senior Account Executive
• Create project plans, milestones, estimates, management reports, SLA reports
• Establish and lead BI center of Excellence (BI CoE) define the function, scope, processes
• Manage 8 developers and Run multiple EDWBI development projects under BI CoE
• Involve in multiple EDWBI projects from requirements gathering, data modeling, implementing ETL jobs, facilitate testing, production roll out, support implemented projects, maintain the released projects for further enhancement, phases, implementing job schedules, create reporting system to deliver data to users
• Process different kinds of data example - Master Data (Movies, SKU, Walkers, Titles, DVDs etc); Transaction Data (distribution, home entertainment etc); Competitor Reference Data from AC Nielsen; Metadata (metrics, calculation formulas, units and definitions of a data entity etc); Analytical Data stored in data warehouse/data marts; Documents and Content in the form of copyrights, royalty claim from, digital assets, video files, images etc
• Architect BOE reporting platform based on usage and required functionality, Architect AC Neilson reporting system, Name & likeness reporting system, Architect CFO & finance reporting Dashboard
• Define BI roadmap, Create reporting framework blueprint, Proof of concept projects
• Establish BI Server administration and Support team and defined issue reporting and resolution processes
• Manage BI Support team of 4 and manage SLA, issues queue, proactive and reactive support, Write white papers for Center Of Excellence
• Perform and manage BOE administration tasks like server maintenance, support, upgrade, user access setup, implement break fixes for server problems, implement fonts, customize server to SPE specific platform, implement SSO, LDAP/AD authentication, tweak server parameters to achieve desired functionality and performance, troubleshoot problems
• Create fault tolerant clustered server, Establish backup processes, Establish server audit reporting system to provide proactive server support, Implement failure alert, Analyze logs
• Support & maintain 3000 reports for 5000 users, 52 different applications
• Facilitate Disaster recovery activities, change request management, outage & documentation, IT Knowledge documents, FRD, Showcase project in Monthly insider magazine
• Establish documentation format and documentation practice
• Create data inventory, Define data usage, Define data collection techniques, Data cleaning rules and establish data security
• Consult in defining process and improving existing process
• Promote data usability and governance practices developing strategic plans and execution those to exceed stated corporate performance and growth objectives
• Finding best suited BOE software/patches, Tomcat version for servers by testing and evaluating known issues published by Vendor, perform manual application deployment replacing Tomcat packaged with the BOE software
• Acquire and maintain BOE, crystal, SSL Licenses
• Quantify and Analyze reporting usage, Sizing BOE server, Creating hardware specifications based on SAP guidelines to fit SONY's usage
• Facilitate, Plan and manage BOE servers, Reporting applications, reporting system decommissioning.
• Engage with SAP vendor support for reporting problems and finding fixes
• Identify/find/create bug fixes or alternatives for problems encountered during migration and upgrade projects
• Create clustered BOE system for high availability and fault tolerance
• Implement SSO using Windows and AD authentication
• Identify solutions to user's reporting problems, software failure, and system failure
• Implement Disaster Recovery solution, Create backups, and facilitate DR system tests
• Create System/Audit DB Backup system, Create Server Backups, Create Backups
• Install and configure sandbox for upgrade, migration, QA, DEV, Production system
• Create and configure Dev, QA systems and implement code promotion system.
• Configure Users access to reports, Universes, connections and different BOE modules (Webi, Import Wizard, Deski)
• Design, Develop, Maintain, Support BO universe & Crystal Reports/Webi reports, BODS, DataStage jobs, SAP Dashboard, QlikView, Tableau Dashboard
• Create batch script, Shell Script for automating processes like schedules, sequential installations, Disaster Recovery systems, BO services failure notifications, LDAP Refresh, Data Refresh, Print to printer
• Facilitate maintenance outage, data center move, network upgrade, DB upgrade

Tools: MS Visio, Excel, Word, PowerPoint, Beyond Compare, Erwin, BOBJ, BOE (Business Objects Enterprise), BOE Server Administration, BODS, Java, QC, Remedy, Share Point, Live Office, SAP Dashboard, Tableau, QlikView, Teradata, SQL Server, DB2, Sybase, Oracle, Unix, Windows, Microsoft project plan