Sr. Lead Business Intelligence Business Systems Analyst Resume
2.00/5 (Submit Your Rating)
Austin, TX
SUMMARY
- 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.
AREAS OF EXPERTISE
- Leadership
- Creative Out of the Box 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
TECHNICAL SKILLS
- Enterprise Architect (EA), Visio, Erwin
- Cognos, Business Objects
- IBM Rational DOORS
- JIRA
- SharePoint Portal
- Quality Center (Test Director)
- MS Office Products: Project, Access, Word, Excel, PowerPoint, Outlook
- DB2 UDB for Windows NT, Visual Warehouse (DB2 Warehouse Manager)
- Transportation Industry software: M4 by CSI and Fleet Anywhere by Peregrine/Maximus
PROFESSIONAL EXPERIENCE
Confidential - Austin, TX
Sr. Lead Business Intelligence Business Systems Analyst
Responsibilities:
- Spearheaded 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
- Cut Costs and Achieved over 85% efficiency in report delivery process for 15 states
- Led 17 sites for BI conversions (working with 15 different states and 4 different countries) with on-time and successful deliveries
- Led 6 sites at one time with varied phases in SDLC for each of those sites
- Trained, mentored and led teams of 4-5 multi-national analysts for each project
- Won multiple spot and project awards
Confidential - Richmond, VA
BI Technical Analyst
Responsibilities:
- Aligned Enterprise Data Warehouse technology strategies through Cross functional and collaborative efforts
- Built 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
- Worked with Cloud computing projects
Confidential
BI Technical Analyst
Responsibilities:
- Led data extraction from legacy systems through source to target data mapping
- Designed Operational Data Storage and implemented for different departments collaboratively bringing it all together for one corporate warehouse
- Primary Liaison between executives and senior business stakeholders cross functionally and provided Process Improvement to create win/win solutions
- Compiled all User authentication requirements for DMV as a baseline going forward
- Proposed technologies for specific business needs
- Recommended technical options for varied business solutions. (Address verification, BPMS, Business Rules Engine, ETL, BI, User Authentication)
- Worked to deliver System Wide Data Conversion Project Plan
Confidential
Systems Analyst
Responsibilities:
- Led support of mission critical applications for Energy Trading Analysts
- Provided front and back end support to clients (using SQL, TOAD, data/database debugging)
- Provided vendor recommended planned and emergency maintenance per change management policies (using SQL, Test Director/Quality Center)
- Gathered, implemented and managed client requirements (Created technical specifications for developers) ‘Post it’ idea to successful solution for clients
Confidential - Richmond, VA
Data Warehouse Manager - for US region
Responsibilities:
- Successfully Managed vendor relations for all platform software and hardware and Saved the company more than $150k by renegotiating contracts
- Successfully Budgeted ($2.5M) for the data warehouse and Service Catalog
- Led successful development, support and maintenance of Data Warehouse infrastructure for the US region
- Developed an effective relationship with the Business teams providing vision and strategy for Data Warehousing needs
Confidential - Richmond, VA
Systems Analyst Specialist
Responsibilities:
- Led successful customization, implementation, integration and support of newly purchased process and issue management solution to track Dominion Nuclear Power Plants’ Corrective Action Program
- Mentored 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
- Developed project plans at a detailed level of tasks with delegation of resources and estimation of efforts
- Developed data extraction and conversion maps. Worked with the application physical data model for implementation scripts and interface development (using SQL)
- Developed 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
- Streamlined business processes for Enterprise Wide Web Team. Matched technology to business needs by surveying the right tool sets and making recommendations
Confidential - Juno Beach, FL
Information Systems Manager/Supervisor (PM)/Technical Architect - Fleet Services
Responsibilities:
- Departmental Gold Coin Award Winner
- Reduced departmental budget by $150k by renegotiating contractual agreement with vendor
- Designed and implemented strategic data conversion, integration and training strategies to ensure successful implementation of system across 30 locations throughout the United States
- Successfully maintained efficient hardware/software environment with skillful Vendor Management
- Directed successful customization and implementation of Automotive Information System, on-time and under budget
- Planned 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
- Designed training strategy for new systems
- Defined and implemented data conversion and testing strategies, following SDLC methodologies
- Developed and implemented application level Disaster Recovery Plan
- Introduced change management procedures into the organization
- Member of Steering Committee for establishing project scope, resources and ROI on high-value projects