Business Intelligence Project Manager/data Architect Resume
SUMMARY:
An experienced project manager and information architect with over 25 years in promoting business processes, application development, and database development thought strategy, design, and architecture. Innovative professional with proven ability to identify, analyze, and solve problems to increase customer satisfaction and control cost.
EXPERTISE IN:
Program Development and Management
Client Training and Management
Business Systems Analysis
Cross Functional Team Leadership
Database Strategy and Architecture
Database Modeling/Programming
PROFESSIONAL EXPERIENCE:
Confidential
Business Intelligence Project Manager/Data Architect
Responsibilities:
- Responsible for Project Management Institute’s (PMI) five process groups: Initiating, Planning, Executing, Monitoring and Controlling, and Closing.
- Establish scope, communicated business scope creep, and provided risk assessment to the business.
- Leading analysis, design, development, and installation systems. This includes the consolidation of the managed reports, and migration to enterprise data warehouse.
- Leading business change.
- Working with Third Party Vendors.
- Provide support for reporting tools such as Microsoft SQL Server, IBM Cognos and iDashboards.
- Provide technical assistance to support SJFC’s Office Information and Technology needs.
Confidential
Project Manager
Responsibilities:
- Responsible for managing the PMI five process groups.
- Establish scope, communicated business scope creep, and provided risk assessment to the business.
- Responsible for direct communication to relevant senior stakeholders.
- Coordination and completion of project tasks between various geographical disbursed business groups.
- Created project plans, assigning responsibilities, monitoring and summarizing.
- Handle multiple assignments with effective resolutions when there are conflicting priorities.
- Worked with Senior Project/Portfolio Manager to change the project plan from delivering based on major milestone (Phases) to minor milestones (Releases).
- Managing three data analysts, three ETL developers, and four Cognos developers.
- Navigated the Confidential software delivery process from Project Management Office, IT Security, and IT Infrastructure Teams.
- Created Microsoft Project facsimile using Excel workbook.
- Established daily developer touch base meetings that were similar to both Agile SCRUM/Status meetings using both Webex, Microsoft One, and project plans.
- Promoted business involvement by bringing early into the testing process.
- Developed strategies for data acquisitions, and implementation of a Operational Data Store (ODS) Oracle database.
- Established Microsoft SharePoint, and document template to organize data and understanding around the software delivery lifecycle (SDLC).
- Data mapping between data source to target tables.
- Assisted with data modeling efforts using Erwin, and Microsoft Visio
Confidential
Senior Application Analyst
Responsibilities:
- Responsible for managing the PMI five process groups: Initiating, Planning, Executing, Monitoring and Controlling, and Closing.
- Establish scope, communicated business scope creep, cost overruns, and provided risk assessment to the business.
- Coordination and completion of project tasks between various business groups.
- Created project plans, assigning responsibilities, monitoring and summarizing progress
- Collaborative gathering Business Requirements.
- Handle multiple assignments with effective resolution when conflicting priorities existed.
- Developed strategies for data acquisitions and implementation of a database using enterprise integration tool Business Objects’ Data Services, and Microsoft T - SQL.
- Worked with Marketing to developed Customer portal using C#asp.net.
- Developed a higher level of security to combat SQL Injection (white listing/black listing techniques), Cross-site scripting, cryptographic storage, URL access, transport layer protection, and invalidated redirects, and forwards following OWASP best practices.
- Assisted with re-architecture of voice recording system.
Confidential
Data Warehouse Project Lead
Responsibilities:
- Involved in changing project management from Waterfall/SDLC to Agile/Scrum SDLC
- Involved in maintaining product backlog.
- Responsible for interviewing, facilitation, problem resolution, consensus building and negotiation skills
- Responsible for managing 4 person development team.
- Helped in setting deadlines, assigning responsibilities, monitoring and summarizing progress.
- Collaborative gathering Business Requirements.
- Handle multiple assignments with effective resolutions when conflicting priorities existed.
- Assisted management with in the PMI five process groups: Initiating, Planning, Executing, Monitoring and Controlling, and Closing.
- Driven third party deliverables.
- Developed strategies for data acquisitions, and implementation of a database using enterprise integration tool Oracle Warehouse Builder, and Oracle PL/SQL.
- Data mapping between data source to target tables.
- Assisted with data modeling efforts.
Confidential
Principle Consultant
Responsibilities:
- Involved in the Startup of BI professional services practice and grew business to over $1.5M in revenue the first year, 100% growth in 2nd year, building business intelligence competency with best practices, delivery methodology, and templates, leveraging partner technologies (Cognos, Oracle, Infor)
- Involved in the PMI five process groups: Initiating, Planning, Executing, Monitoring and Controlling, and Closing.
- Risk Management and Mitigation.
- Managing team up to 4 individuals at a time.
- Defined packaged service offerings for BI solution implementation services, and consulting services.
- Perform needs analysis and statement of work (SOW) responses detailing scope, time, cost, quality, resource, communication, risk, and procurement.
- Met with stakeholder’ s weekly to provide status, communicate progress, and assess scope changes.
- Responsible for onsite Account Management duties.
- Served in a key leadership and mentor role for delivery teams.
- Perform advanced or complex prototyping for Cognos suite
- Gained deep technical knowledge of in creating and managing data warehouse in their integration with ERP & CRM systems to, such as Oracle Financials, Infor Mapics, and Sunguard HE.
- Directly responsible for code reviews and performance tuning.
- Customized the appearance of Business Intelligence and App Integration using C#, and Java.
- Created courses, and workshop to training Clients on dimensional modeling, business intelligence tools, and ETL tools.