SUMMARY:

Business Analyst with over 15 years of experience specializing in project planning and management, researching and recommending solutions, training stakeholders, data architect, modeling, analyze, conversions, integration and implementations. Aiming to utilize my cross functional skills and analytical ability to achieve the goals of your company.

KEY SKILLS AND COMPETENCIES:

• Good track record of managing complex multi - functional projects in various environments
• Experience of working with sponsors, stakeholders, and solution providers
• Successful and demonstrable delivery of results from a client site
• Superb customer facing skills
• Knowledge in developing and administering resource plans and budgets
• Agile/SCRUM software development; JIRA/user stories
• Full systems development life cycle experience from requirements gathering through, fit-gap analysis, functional analysis, architect, data conversions/extraction, interfaces, migrations, integration, and batch applications development, dimensional modeling, star schema, snowflake schema and OLAP concepts
• New functionality review, customization review, upgrade testing, post production support, training, re-configurations, testing and deployment

FUNCTIONAL SKILLS:

Functional Module BI: Tableau, Cognos, Birst, Spago BI, Qlikview

Industry Domain: Sales & Marketing, Retail, Healthcare, Finance & Investment, Software

Application: People Soft FSCM/HCM/CRM, Sales force, Netsuite

TECHNICAL SKILLS:

Reporting Tools: Tableau 10.0, Birst 5.1, Business Objects, Spago BI, PeopeTools 9.x

SQL Tools: SQL*Plus, SQL, PL/SQL, PS/Query, TOAD, SQL Developer, My SQL

Database: Oracle 10.x PL/SQL and MS SQL SERVER 7.0, Teradata 14

Languages: JAVA, VISUAL BASIC 6.0, HTML, PL/SQL, PERL, JSP, PYTHON

Microsoft: Word, Excel, Access, and PowerPoint, Project, Share Point Server, SSIS, SSRS, SSAS

Data Modeling Tools: Embarcadero, Erwin

Big Data: Hadoop, Map Reduce, HDFS, Hive, Pig

Data warehouse/ETL: People Soft EPM, Informatica 9.x, Birst 8.x, Talend, Pentaho, Ascential Data stage 7.5

PROFESSIONAL EXPERIENCE:

Confidential, CA

Business Analyst Consultant

Responsibilities:

• Plan, design and recommend business processes to improve and support business activities.
• Translate stakeholder requirements into various documentation deliverables such as functional specifications, use cases, user stories, workflow/process diagrams, data flow/data model diagrams.
• Develop business architecture using requirements such as scope, processes, alternatives, and risks.
• Analyze client’s business requirements and processes through document analysis, interviews, workshops, and workflow analysis.
• Conduct testing including functional, regression, user acceptance, integration and performance to verify the client’s needs are met.
• Regularly contributed efforts to release management, Agile sprint planning sessions, and sprint lessons learning
• Liaise between business and technical personnel to ensure a mutual understanding of processes and applications.

Confidential, CA

Business Analyst Consultant

Responsibilities:

• Provided ongoing project coordination and process development support to implementation teams and Project Managers
• Collaborated with client to identify key requirements, defined project scope, developed project plan and schedule, provided leadership to internal teams on projects and daily production issues.
• Developed project plans and ensured milestones were met according to schedule. Tracked issues, facilitated resolution and provided weekly status reports to senior management.
• Provided solution architect in reviewing existing data models. Designed and modeled data-warehouse data marts for Sales, Marketing and Finance. Managed development and delivery of BI tools including coordination of the configuration, enhancements and development of business processes associated with information delivery.
• Facilitated workshops with customers to gather, document and prioritize business intelligence requirements.
• Designed ETL and BI test strategy.
• Reviewed source data mappings, design and development ETL code/logic.
• Assessed the impact of new requirements on an existing suite of complex applications.
• Supervised testing efforts for the deployment of Dashboards and KPIs, created business test plan and process and worked with sales representatives on implementation issues.

Environment: Birst 5.21, Tableau 9.2, Informatica, My SQL, MS SQL Server 2012, Javascript, Java, Python, HTML

Confidential, CA

Business Analyst Consultant

Responsibilities:

• Coordinated with customer to gather requirements and manage expectations.
• Responsible for working with in-house and external development teams in a fast moving environment to deliver projects on time and to budget.
• Managed project dependencies, prepared project briefs, compiled reports and maintained records.
• Developed sophisticated ETL mappings with Informatica Power Center for data integration, data modeling.
• Lead requirement elicitation efforts on enterprise analysis projects including the elicitation and mapping of the AS-IS and TO-BE processes.
• Developed rich Interactive reports and dashboards integrating various reporting components from multiple sources. Created drill through reports in dashboard.
• Provided input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Facilitate meetings with clients to gather and document requirements and explore potential solutions.

Environment: Tableau 8.1, Informatica, SQL, MS SQL Server 2012 Javascript, HTML

Confidential, CA

Business Analyst Consultant

Responsibilities:

• Managed projects from conception through completion.
• Consulted with client to identify key requirements, defined project scope, developed project plan and schedule, provided leadership to internal teams on projects and daily production issues. Facilitated issues resolution. Prepared and presented timely status reports to client and internal Senior Management.
• Provided Business Intelligence solutions for customers in leasing sector. Provided Solution Architecture, Data-marts design, development, and implementation of KPI model, BI Business Concepting, Business Analysis, and Reports.
• Proactively identified and nurtured opportunities, ideas and innovations.
• Collaborated with data modelers, ETL developers in creating the Data Functional design documents.
• Analyze and document client's business requirements and processes and communicate these requirements by constructing conceptual data and process models, including data dictionaries and volume estimates from organization.
• Directed strategies for prototyping, research, and development of BI Dashboards and Reports.
• Designed and published visually rich and intuitively interactive Tableau workbooks and dashboards for executive decision making.
• Analyzed and provided recommendations for business processes and business goals.

Environment: Tableau 8.1, Informatica, SQL, Oracle 11, Java, Javascript, HTML

Confidential

Business Analyst Consultant

Responsibilities:

• Performed project management tasks, including creating schedules, managing resources, and creating deliverable template.
• Performed analysis, design, and implementation of major financial business reporting functions across People Soft Finance and Supply Chain.
• Involved in all phases of the data warehouse project life cycle, which includes assessment, business requirements gathering, data modeling and database design, Reporting Model and report Development, performance tuning, and data delivery mechanisms.
• Involved in the design and implementation of the balanced scorecard and online analytical processing solutions.
• Participated in the design, development, deployment and support of Reporting solutions in the areas of Finance & Supply Chain Performance.
• Collaborated with business to develop high-level designs including logical models and functional specification documents.
• Prepared training materials, developed business models and trained users in Query Studio according to their specific needs and requirements.
• Wrote SQL scripts for analysis/validations.
• Assist in coordinating business analyst tasks on information technology projects and provide support to other team members
• Actively worked with the BI team and Business to transition the application into Production Environment by providing support and training through the release cycle.
• Managed resource and capacity planning for projects.
• Developed status reports, cost estimates, and resource plans.
• Draft and maintain business requirements and align them with functional and technical requirements.
• Plan and execute research and development on People Soft Finance and HCM projects.
• Identify and reconcile errors in client data to ensure accurate business requirements.
• Provide input into developing and modifying systems to meet client needs and develop business specifications to support these modifications.
• Producing and delivering project documentation, e.g. user manuals and support.
• Managing and supporting the testing and implementation of business initiatives.
• Facilitate weekly/monthly meetings with clients to document requirements and explore potential solutions.
• Support various existing applications in production environment.

Environment: Cognos, People Soft Financials 8.x, HRMS 8.x, SQR, SQL, Oracle