Lead Business Analyst

Sejal Patel

all*sej@HOTMAILcom

[Austin, Texas OR Telecommuting]

Systems, Business, Data Analyst – Project Management

Business Intelligence & Data Analytics Data Warehousing Customer Relations Infrastructure Process Improvement

Over 10 years of experience with:

Data Analysis & Management across all departments (Accounting & Finance, Sales, Marketing, Security, Claims & Payments, Contracts & Licensing) in varied industries such as Medical, Lottery, Utilities, IT, Federal, State.

Various Business Intelligence products (Business Objects, Cognos, Tableau) wearing multiple hats simultaneously in varied roles of management, development, implementation and maintenance.

Leading customer facing Requirements Gathering sessions pioneering cost saving processes with customers.

Extensive knowledge in all aspects of software development life cycle [SDLC], from initial design and analysis, gathering requirements through client interfacing, implementation, testing, reporting, support, enhancements, infrastructure and Vendor Management.

Expert presenter, negotiator, and teammate able to forge solid relationships with staff, peers, management and vendors and build consensus across multiple organizational levels.

Core Competencies

Leadership

Creative Thinking, Problem Analysis & Resolution with strategic win/win solutions

High visibility Issue Resolution

Process Improvement

Customer Relations Management

Mentoring & Training

Niche-Intangible skill set

Project Planning / Management

Business Requirements Gathering & Delivery

Functional Needs Analysis

Vendor Management

Change Control

Agile with Scrum for Projects

Infrastructure Design, Planning & Analysis

Implementations of technical solutions

Development in BI & ETL

Technical Systems Analysis using SQL & PL/SQL

Technical Architecture

Professional Training

oCertificate of Medical Laboratory Technology

oCertificate in Database Management

oThe Data Warehouse Institute Courses

oTableau Software Certification

oCognos Admin & Report Writer

oBusiness Objects Admin & Report Writer

Software Skills

oEnterprise Architect (EA), Visio, Erwin

oCognos, Business Objects

oIBM Rational DOORS

oJIRA

oSharePoint Portal

oQuality Center (Test Director)

oMS Office Products: Project, Access, Word, Excel, PowerPoint, Outlook

oDB2 UDB for Windows NT, Visual Warehouse (DB2 Warehouse Manager)

oTransportation Industry software: M4 by CSI and Fleet Anywhere by Peregrine/Maximus

Professional Experience

IGT Global Solutions – Austin, TX (2012—Present)

Sr. Lead Business Intelligence Business Systems Analyst

oSpearheaded a BI requirement gathering process that was adopted by the company as part of the Business Process Model and has been successfully implemented for last 5+ years

oCut Costs and Achieved over 85% efficiency in report delivery process for 15 states

oLed 17 sites for BI conversions (working with 15 different states and 4 different countries) with on-time and successful deliveries

oLed 6 sites at one time with varied phases in SDLC for each of those sites

oTrained, mentored and led teams of 4-5 multi-national analysts for each project

oWon multiple spot and project awards

Consulting: – Richmond, VA (2008 – 2012)

Client – McKesson Corp. via Analysts International, Inc. as BI Technical Analyst

oAligned Enterprise Data Warehouse technology strategies through Cross functional and collaborative efforts

oBuilt and maintained a rolling plan to achieve the target architecture and maintain a current view of AS-IS and migrate it to the TO-BE architecture documentation

oWorked with Cloud computing projects

Client – Estes Express via Actum Inc. as BI Technical Analyst

oLed data extraction from legacy systems through source to target data mapping

oDesigned Operational Data Storage and implemented for different departments collaboratively bringing it all together for one corporate warehouse

oPrimary Liaison between executives and senior business stakeholders cross functionally and provided Process Improvement to create win/win solutions

Client - Department of Motor Vehicles (DMV) via Morton Consulting – SAIC as BI & Data Conversion Specialist

oCompiled all User authentication requirements for DMV as a baseline going forward

oProposed technologies for specific business needs

oRecommended technical options for varied business solutions. (Address verification, BPMS, Business Rules Engine, ETL, BI, User Authentication)

oWorked to deliver System Wide Data Conversion Project Plan

Client - Dominion Resources via Core Staff as Systems Analyst

oLed support of mission critical applications for Energy Trading Analysts

oProvided front and back end support to clients (using SQL, TOAD, data/database debugging)

oProvided vendor recommended planned and emergency maintenance per change management policies (using SQL, Test Director/Quality Center)

oGathered, implemented and managed client requirements (Created technical specifications for developers) ‘Post it’ idea to successful solution for clients

Alstom Power – Richmond, VA

Data Warehouse Manager – for US region (2007)

oSuccessfully Managed vendor relations for all platform software and hardware and Saved the company more than $150k by renegotiating contracts

oSuccessfully Budgeted ($2.5M) for the data warehouse and Service Catalog

oLed successful development, support and maintenance of Data Warehouse infrastructure for the US region

oDeveloped an effective relationship with the Business teams providing vision and strategy for Data Warehousing needs

Dominion Resources – Richmond, VA

Systems Analyst Specialist (2004-2006)

oLed successful customization, implementation, integration and support of newly purchased process and issue management solution to track Dominion Nuclear Power Plants’ Corrective Action Program

oMentored three Business Analysts, three Programmers and 6 vendor consultants to complete the final phase of business requirements, developing test plans and integrating requirements into application development through entire SDLC

oDeveloped project plans at a detailed level of tasks with delegation of resources and estimation of efforts

oDeveloped data extraction and conversion maps. Worked with the application physical data model for implementation scripts and interface development (using SQL)

oDeveloped reporting strategy and provided and reports using COGNOS Impromptu, Report Net and Framework. Worked with developers and Data Architects to provide a seamless ETL process using Decision Stream

oStreamlined business processes for Enterprise Wide Web Team. Matched technology to business needs by surveying the right tool sets and making recommendations

FLORIDA POWER & LIGHT – Juno Beach, FL (2000-2004)

Information Systems Manager/Supervisor (PM)/Technical Architect – Fleet Services

oDepartmental Gold Coin Award Winner

oReduced departmental budget by $150k by renegotiating contractual agreement with vendor

oDesigned and implemented strategic data conversion, integration and training strategies to ensure successful implementation of system across 30 locations throughout the United States

oSuccessfully maintained efficient hardware/software environment with skillful Vendor Management

oDirected successful customization and implementation of Automotive Information System, on-time and under budget

oPlanned and coordinated full project life cycle design, development and implementation of interfaces to 9 business systems, to ensure optimal integration and information access through centralized reporting

oDesigned training strategy for new systems

oDefined and implemented data conversion and testing strategies, following SDLC methodologies

oDeveloped and implemented application level Disaster Recovery Plan

oIntroduced change management procedures into the organization

oMember of Steering Committee for establishing project scope, resources and ROI on high-value projects

Education

oMaster of Science in Computer Science[*]

oMaster of Science in Environmental Science

oBachelor of Science in Microbiology

[*] (Thesis Pending)

Contact this candidate