We provide IT Staff Augmentation Services!

Data Warehouse Business Analyst Lead Resume

4.00/5 (Submit Your Rating)

North Miami, FL

Professional Skills:

  • Operating Systems: Android, iOS, OS X, Microsoft Windows, UNIX
  • Business Applications and Media Development: Microsoft Office (Word, Excel, Project, PowerPoint, Publisher), iWork (Pages, Numbers, Keynote), Adobe Creative Suite (InDesign, Photoshop, Illustrator, Premiere), After Effects, Dreamweaver, Flash Professional, Fireworks, QuarXpress
  • Enterprise Architecture and Business Modeling Software: COBIT, Enterprise Architecture - IBM Rational System Architect, Sparx Systems Enterprise Architect, Zachman Framework for Enterprise Architecture, Oracle BPM, Aurea/Savvion Plus; ER/Studio, Visio, Axure RP, SmartDraw, iGrafx Process
  • Enterprise Software: Legistar/ConTrack (Legislative Workflow Management Suite), InForum Gold (ERP), Infor Lawson (ERP), TRIM Context (ECM), WebCT, Blackboard, Moodle, eLeap, Adobe Captivate, Articulate Rapid eLearning, Lectora (LMS), Oracle CRM
  • Enterprise Infrastructure Software: Access, Blackbaud, Oracle 8.x-11g, Tableau Desktop 8, Business Objects/SAP (BI), Avid DDMS-DDME, ArcGIS, ArcInfo, ArcIMS, ArcSDE, ERDAS IMAGINE (Geospatial Data Authoring System) Crystal Xcelsius, Visual Studio

Professional Experience:

Confidential, North Miami, FL

Data Warehouse Business Analyst Lead

Key Responsibilities:

  • Liaison between the lines of business and the Development team
  • Analyzes business requirements to understand the business needs and to determine how their applications can best functionally fulfill those needs.
  • Combine knowledge of what the business wants with knowledge of how the systems are built and used, in order to create functional designs across applications.
  • Assist in UAT preparation and execution.
  • Design appropriate controls to ensure strong data quality.
  • Understanding of Agile Methodologies.
  • Experience/understanding of business process re-engineering and business modeling concepts.
  • Experience working in a large scale Data Warehouse.
  • Experience with implementing process improvements across multiple teams.
  • Awareness of the business and IT strategy.
  • Experience setting up testing scenarios.
  • Responsible for coaching and mentoring less experienced team members.

Confidential, Florida

Senior Enterprise Systems Analyst/Business & Data Analyst

Responsibilities:

  • Provided full life cycle analysis for implementation of integration of various bioenergy and GIS systems.
  • Project Manager/Business-Data Analyst for product development of third party interfaces.
  • Team leader of 3 Business Analysts, 1 Developer, 1 Technical Writer, 2 Data Analysts.
  • Developed business, user requirement and functional specification documents (software needs analysis) including design of database tables that feed the development process.
  • Able to elicit, capture and translate business requirements into system & functional requirements.
  • Inventory, understand and document all the characteristics of process flows, data flow and data mapping for and in-between various biorefinery and GIS systems.
  • Assisted JAD sessions for data lineage, mapping and analysis.
  • Researched issues via databases using Oracle PL/SQL.
  • Managed all outside vendor relationships as well as support outsourced programming.
  • Analyzed vendor/client requirements, including meeting with vendors to identify needs as well as facilitate internal/external meetings to confirm requirements.
  • Analyzed business processes and procedures to identify changes required as a result of new regulations, developments or enhancements.
  • Conducted testing, research and documentation of resolutions for issues that arise or new development related to interfaces.
  • Communicated with department managers, vendors, clients and development to ensure design accuracy and appropriately set expectations.
  • Developed test plans, including documented test cases, test data requirements, and expected results for user acceptance testing.
  • Executed test plans, document results, and work with development staff to correct issues.
  • Supported development of client documentation and release notes.
  • Provided application and product subject matter expertise to staff members and clients.
  • Managed tasks and priorities, and document project status and issues.
  • Assisted all other Business Analysts with technical questions, research and design.
  • Helped technical teams provide business projects a fast and direct bridge to the cutting edge of relevant external information technologies and expertise; provides best practice advice, guidance and recommendations in their area of expertise.
  • Provided expertise in location-based GIS/RS to manage infrastructure and assets - water, wastewater, and storm water distribution tracking, collection and drainage networks for algae cultivation in advanced biofuel production and biorefinery management.
  • Engaged in a variety of special projects, including assisting in the design and implementation of new innovation processes.
  • Collaborated with researchers, research support services personnel and IT providers to deliver complete research automation and blended/integrated learning solutions.
  • Participated in the identification, development and implementation of research laboratory work process improvements.

Confidential 

Project Coordinator/Business Analyst

Responsibilities:

  • Conducted meetings and discussions sessions with stakeholders of different health sciences disciplines in CNHS to elaborate on the business drivers, vision and mission, high level requirements and project objectives.
  • Developed and executed project work plans and revised as appropriate to meet changing needs and requirements.
  • Created the as-is business process flow of the Lead Research Management of individual health sciences discipline and the to-be business process flow for the Lead Research Advisory application reading out of consolidated DW as a consolidated Lead Research Management system.
  • Committee involvement: coordinated activities of the Deans, Chairs and Directors (DCD) committee, presented reports at DCD meetings and participated in activities of the Associate Deans committee.
  • Coordinated VIP access and high-level tours and events of the Simulation Teaching and Research (STAR) Center and the Human Performance Lab for patient care experience and research through advanced technology.
  • Led BI and dashboards development and trained core executive users.
  • Involved in defining the scope and defining business rules of the project. Also involved in gathering business requirements, doing gap analysis and documented them textually or within models.
  • Identified and validated high potential business opportunities for stakeholders and developed customized business strategies that are aligned with corporate strategic objectives.
  • Prepared annual events budget and provided the Budget Director projections for future needs and expenditures.
  • Acted as liaison between end users and technical team to address issues and recommend solutions.
  • Assigned work and designated responsibilities; evaluated discharge of such duties and recommended to the Dean changes in administrative procedures.
  • Provided analysis, understanding and business perspectives on many operational issues.
  • Coordinated international partnership in healthcare academic programs and research, i.e., with Oman, Saudi Arabia, Puerto Rico, Jamaica, Mexico, Haiti, to name a few.
  • Prepared detailed data analysis report for existing system and performed data validation for as is and to be system (Beta product) and Performed root-cause analysis for data issues.
  • Documented data flow diagram and work flow for each of the batch process feeding to the master database.
  • Prepared comprehensive test strategy, testing plan, test cases, execution plan and migration plan for each of the component.
  • Involved in UI, requirement and data modeling sessions and developed data flow diagrams.
  • Assisted with data analysis and migration planning of large scale SharePoint roll-out.
  • Interfaced with clients and conducted presentations around project kickoffs, requirements, governance and other related tasks.
  • Performed the reviews for all the test deliverables.
  • Worked closely with top University officials in all matters within area of assigned duties.

Confidential, Miami, FL

Project Manager/Business Analyst

Responsibilities:

  • Liaison officer for GESF, SMECE and USAID FTF Program. Familiarity with USG regulations and international programs.
  • Responsible for the implementation of enhancements for the Knight Ridder Center for Excellence in Management Data Warehouse - KRCEM project (Oracle/PeopleSoft).
  • Gathered key business information conducting interviews and workshops and created business, functional and data requirements documents.
  • Participated in Joint Application Development (JAD) sessions to design Data Flow Diagrams (DFD’s) for the different phases of requirements.
  • Responsible for the KRCEM dashboard to track all funds that were given out as well as what they were used for.
  • Led two teams on different projects: 4 Business Analysts, 2 developers, 2 technical writers, and 4 data analysts.
  • Validated quality of existing data and performed gap analysis by comparing current state data with future business requirements and enhancements.
  • Developed UAT test plan, test cases for specific business requirements, PL/SQL test scripts to test business/functional requirements, executed test scripts, documented test results and escalated issues/defects found during testing to project team.
  • Analyzed ETL jobs and mappings to document the existing business rules and transformation logics.
  • Performed continuous software “demos” with end users to capture additional changes and feedback before final deployment of BI software applications.
  • Helped to create operations document and knowledge transfer to operations team.
  • Assisted with other conferences and projects including leading the coordination at FIU for the Florida Network for Global Studies (FNGS) and its collaborating institutions at the University of South Florida, University of Florida, University of North Florida, and University of Central Florida. A U.S. Department of Education-sponsored project in the Business and International Education Program researching the potential for small businesses in Florida to export alternative energy products and services in the Dominican Republic and Panama.

Confidential , Doral, FL

Teacher

Responsibilities:

  • Prepared Math study material for the classroom including interactive learning, textbooks, workbooks and group exercises.
  • Organizing coursework for multiple courses at a time.
  • Involved in organizing and be in charge of examinations.
  • Engaging pupils in the class in stimulating discussions.
  • Carrying out assessments of students work.
  • Monitoring the performance of pupils in my class and providing encouragement to those who need additional help.
  • Assisted in organizing school events like trips, sports events, graduation, etc.
  • Organizing and participating in staff meetings.
  • Responsible for lesson planning, delivering, marking of work.
  • Preparing classes and delivering engaging, coherent lectures.
  • Planning, setting and assessing homework.
  • Utilized reading strategies to aid pupils learning of math and differentiated learning techniques to prepare pupils for FCAT assessment.
  • Instructed six periods of 165 pupils and proctored FCAT testing.
  • Enforcing the schools behavior policy.
  • Promoted interest in mathematics and facilitated pupils learning as a mathematics teacher.
  • Assisting pupils to develop their social, emotional and behavioral skills.
  • School scored A in Performance for 2007-2008 Academic Year.

Confidential, Miami, FL 

Senior Business Analyst/Project Manager

Responsibilities:

  • Responsible for Overall Implementation of the Project starting from Requirement gathering to final deployment of the ASP Applications in Production and giving ERP/CRM/GIS/ECM and LMS Demo to the CIOs, CFOs and other Senior Management officials of local government in Miami-Dade County and partnering universities.
  • Improved business processes and supported critical business strategies by directing the development/integration, implementation, and maintenance of business applications systems (ERP, CRM, SQL, Oracle, Access), Geographical Information Systems (GIS) and Learning Management Systems (LMS/LCMS, eLearning Software).
  • Formulated information technology enterprise architecture plans, estimated costs, and ensured projects met strategic needs.
  • Supervised teams with a mission to create and deploy enterprise applications automating enterprise financials (InForum Gold/Lawson Software), legislative workflow, records management, integrated digital audio/video recording and business intelligence/analytics needs of key business units of a consortium of local governments in ASP environment.
  • Provided leadership based on methodologies, techniques and tools for business process life cycle management (business modeling to data modeling to data from various sources to ETL process to target to business intelligence), systems development and SDLC.
  • Led IS development with an overall responsibility for building business processes, structuring projects, performing the detailed planning, and managing project execution and completion of moderate to large projects.
  • Facilitated training and workshops on IS development approaches such as prototyping, Joint Application Design (JAD), Rapid Application Development (RAD), Agile methodologies, Disaster Recovery Planning (DRP) and Business Continuity Planning (BCP) integrating regulatory compliance and enterprise-wide change management best practices.
  • Used CASE tools for the procurement, design, development, implementation, and ongoing production support of enterprise applications, web applications, messaging, calendaring, and workflow applications and related infrastructure.
  • Prepared and documented Business Process Modeling, Data Flow Diagrams, E-R Diagrams, Use Case Diagrams, Sequence Diagrams, Activity Diagrams, Class Diagrams and Deployment Diagrams.
  • Work closely with teams of BAs, developers and testers throughout the entire development life cycle to elicit and manage requirements using Rational Requisite Pro.
  • Entered the functional and non-functional requirements into the Rational Tools and administered the tool to provide accessibility and Change Request Management.
  • Defined System Functionalities including User Interface, Wireframes, Graphics, and System Content.
  • Perform Data Modeling, Data Mapping and Data Analysis to support and Improve Business Processes.
  • Created attributes for each requirement like priority, status, cost and difficulty and provided one-to-one, one-to-many parent child relationships between requirements of the same type
  • Created traceability relationship between requirements in the same module and also between different modules.
  • Technical lead for the design and development of GIS to manage spatial data in public works, elections, parks and recreation, 911, police and other local government divisions resulting in introduction of Environmental Data Management System (EDMS) for regulatory compliance and more efficient ways to provide GIS-based services citywide and to the public.
  • Identified and recruited software vendors, sponsors and attendees for Technology Training involving the Florida Institute of Government, local governments and the University Of Miami School Of Business.
  • Project Manager: Technical Trainer for Legistar, TRIM Context, regulatory compliance
  • Technical Contributor to National Science Foundation (NSF) Grant writing: A $600,000 management and technology partnership in innovation between the University Of Miami School Of Business, Business Objects and a Local Government.
  • Technical Lead for the design and development of innovative instructional approaches to integrate e-learning and instructor-led methods into a seamless program in partnership with the University of Miami School of Business and local government agencies.
  • Risk Analysis Senior Project Manager: Business Impact Analysis (BIA), Disaster Recovery Planning/Business Continuity Planning (DRP/BCP) development, testing, maintenance and auditing, which resulted in best practice and best combination of technology solution as to price and functionality.
  • Prepared Project Evaluation Report, Manuals for UAT, Lead Meetings and Sessions for maintaining flow of Project.

We'd love your feedback!