We provide IT Staff Augmentation Services!

Datawarehousing Architect Resume Profile

4.00/5 (Submit Your Rating)

Summary:

  • Results-driven Program/Project Manager leads with over 14 years of experience implementing programs/project and innovating business solutions for both Midsize and Fortune 1000 clients.
  • Exemplary leader, who can effectively communicate and manage organizational change, control budgets, mitigate risk, infuse new ideas, deploy and deliver solid business results on time.
  • Hands-on Senior Project Management expertise delivering MM portfolios of projects serving IT needs of various industries Banking, Manufacturing, Services and Insurance.
  • Extensive experience with hands-on technical experience in managing BI/Datawarehousing Projects with varying levels of expertise in Data Model Design and Datawarehouse Architecture and Advanced analytics around OLAP and multi-dimensional reporting.
  • Directly accountable for project management deliverables in excess of 7MM in budgets.
  • Outstanding relationship team builder, adept at working with high-performing teams consultants, off/on shore vendors to implement projects on-time and within budget despite aggressive timelines and challenges.
  • Proactive problem solver, consistently successful in delivering strong cost reductions, improved efficiencies and overall customer satisfaction.
  • Possess significant and sustained project management experience that includes interacting with and presenting to senior-level executives and company policy leaders.
  • Proven situational leadership skills and the ability to motivate and generate enthusiasm with individuals across all levels of the organization.
  • Advanced Microsoft Office skills such as PowerPoint, Visio, Excel, and Word.
  • Experienced in using project management tools such as SharePoint, Clarity PPM Program Project Portfolio Management System , MS Project.
  • Experienced in areas of SDLC Software Development Lifecycle and waterfall and Agile Methodologies.
  • Proven ability to coordinate with business and system owners, application designers and developers to realize the application blueprint on projects and effectively resolving conflicts within team that come up during the course of the project.
  • Technical Domain Experience Technologies
  • Project Mgmt Tools: Clarity PPM, MS Project and Visio
  • Data Modeling Tool: ERwin, Oracle 9 and 10g , SQL Server, Sybase, Hyperion
  • Essbase and Planning, Hyperion Web Analysis, ODI, Hyperion Smartview, Hyperion Visual Explorer, Business Objects,
  • Development Platforms: Windows NT/2000, AIX5.1, Sun Solaris 5.x, Linux
  • Programming Languages: C, C , PL/SQL, UNIX Shell Scripting, Perl
  • Scheduling Tools: Autosys, Crontab, SQL Sentry and Windows Scheduler
  • Change Management: JIRA, Manage Now.
  • Agile: IBM Rational Team Concert and Rational Requirements Composer.
  • DOMAIN SKILLS
  • CRR: Credit Risk Reporting
  • CRM: Customer Relationship Management
  • CPR: Customer Profitability Reporting
  • EFR: Enterprise Financial Reporting related to General Ledger MIS reporting, P L statement and Income-Balance Sheets

PROFESSIONAL EXPERIENCE:

Confidential

Sr. Project Manager /Lead Agile.

Responsibilities:

  • Responsible for capacity Planning, cost planning budget , timeline/schedule management, Release Planning and for leading an onsite-offshore team of 25 people in a dynamic and fast-paced agile/scrum environment -- to identify opportunities and build proposals for existing and new clients.
  • Additionally, responsible for managing Scrum Master Activities driving daily stand-up scrum, sprint Planning, Sprint Grooming sessions, Sprint Review meetings and retrospective meetings, removing any impediments/blockers for the project and ensuring adherence to the agile philosophy.
  • End-to-end projects included customer migration and integration after merger and acquisitions, portal designs. Other projects included deployment, business operations, compliance operations, data center operations, call center operations, technology operations, security operations, financial systems design, gap analysis, technology interfaces
  • Extensive conflict management with the ability to confront conflict and difficult issues in a professional, assertive and proactive manner.
  • Managed, mentored and provided input based on past experiences and expertise relating to project/program technology initiatives that impacted single functions or systems within a department. Responsible for final budget approvals, program review, vendor review, premises planning, and strategic alliances by product line before dollars we distributed from senior management.
  • Liaison to ensure that the technology teams were addressing the business requirements of all projects, establishing the communications plans and executing the communications.
  • Acted as liaison between technology and business units to manage projects.
  • Collaborated with clients, staff members, and IT colleagues to define detailed customer requirements and system interfaces, compliance objectives, evaluate available technologies, and determine technical solutions.
  • Managed facility process re-engineering to help maintain IT budgets as well improve enterprise level efficiencies, including but not limited to managing IT-driven business process initiatives to improve efficiency and business best practices at an enterprise level.

Confidential

Project Manager/Datawarehousing Architect

  • Responsible for designing and managing a critical IT Financial Expense Datawarehousing application.
  • Strategically manages a wide variety of Enterprise Projects and Projects' sensitive tasks and activities with full accountability for implementing Project Management methodologies
  • Responsible for leading a small onsite-offshore team for ensuring key support deliverables Root cause Analysis, Datawarehousing systems availability, operations and performance.
  • Managing the project plan of the client and all the external entities for solution design, development and implementation
  • Defining the channels for system interfaces and the implementation plan for system interfaces
  • Applied exceptional project management skills in having maintained time management and organizational skills in overseeing several accounts
  • Also responsible for Change Management, interacting with Business, coordinating Project status Meetings, and managing customer issues and escalations. Subject Matter Expert for Datawarehousing Architecture and Hyperion Essbase, Planning, Web Analysis and Smartview.
  • Responsible for Application portfolio rationalization.
  • Responsible for business requirement gathering from all partners, change managers and SMEs
  • Exhibited expertise in issue resolution, technology solution in consultation with multiple business groups, change managers, and partners.
  • Led complex project/program JAD sessions, conducted interviews, scheduled and facilitated work sessions to complete all enterprise technology initiatives.

Confidential

  • Managing multiple IT Datawarehousing projects for large clients. Responsible for managing the BPC Data Analysis project at MeadWestVaco and for supervising the IT Financial Reporting Production Support for the CFSD Department at Xerox.
  • Ensuring alignment of the Service Strategy, Portfolio and Service Level Agreements to the Customer /Business Needs and Requirements. Towards this, continuously liaisoning with business and IT customers to understand the dynamic and growing business needs.
  • Project planning and resource Management for Development and Support activities.
  • Defining and ensuring adherence to delivery and quality processes for the project.
  • Change Management, coordinating Project status Meetings, managing customer expectations and escalations.
  • Budgeting and Tracking Revenue and Project expenses.
  • Leading and mentoring the Development and Support team on both technical Datawarehousing as well as non-technical aspects of the project.
  • Subject Matter Expert on Oracle Hyperion Essbase. v9.x
  • Additional responsibilities include managing the Operational Metrics for the DWBI Team for the Manufacturing and Logistics vertical.

Confidential

  • Responsible for Project Management, Business Analysis, architecture design and support of the Fleet Analysis Reporting FDT datawarehousing solution for Waste Management.
  • Responsibilities include Project Tracking and monitoring, Project Reporting, interacting with Business users and IT infrastructure Team for understanding requirements/analyzing issues and designing the Data Model and the processes for the OLAP Implementation.
  • Managed development and implementation projects, developed project effort estimates, assigned resources, identified time lines and critical path events, managed projects to timelines and deadlines, coordinated projects with corporate PMO.
  • Prioritized and managed support efforts and new development projects based on severity, business need, bottom line, and impact on internal and external customers.
  • Designed, documented and implemented an end to end Unified Process for project creation, development and implementation in concert with Project Management team. Incorporated Agile methodologies where applicable.
  • Responsible for Change Management Processes for the Application.
  • Designing the Cubes and Reporting Interface in Oracle Hyperion Essbase. v6.x and v7.x

Key Accomplishments

  • Delivery of Project within Budget and key milestones.
  • Successfully completed various Enhancements/phases for the Fleet Dashboard and Toolkit Application.
  • Technical Architect for the Datawarehousing processes and Reporting Analysis done through Hyperion Essbase.

Confidential

  • Responsible for the design, enhancement and overall support of two data-warehousing life cycles for Lehman Brothers. Allocations Reporting and Business Performance Management
  • Responsible for analyzing and organizing user requirements for new development/enhancements and delivering solutions within timeframes
  • Working with business, management, IT development and support teams to ensure on time, on budget, quality delivery of technical solutions. Initiation, planning, execution, control, tracking/reporting and closure of project from an overall and day to day perspective. Develop program plans and estimations.
  • Manage expectations with both business and IT stakeholders regarding functionality, scope and deliverables. Develop working relationships with business and IT team to ensure overall product satisfaction. Identify, assessing, prioritizing, managing project risks and issues.
  • Facilitating the executive meetings and reporting projects status to stakeholders. Analysis of project metrics and corrective actions if needed. Review and checkpoints for all deliverables including requirements, wireframes, design and final product.
  • Managing customer expectations and issues pertaining to data accuracy and data availability.

Confidential

  • Responsible for the lead and overall management of Onsite and offshore resources, for OLAP Analysis for the GE Consumer Finance GECF Data Warehousing Project.
  • Managed the customer requirements analysis, specification documentation and design of User requested Reports.
  • Responsible for interfacing with the client, handling customer expectations and issues and delivering status reports and metrics.
  • Found appropriate technologies for new ventures and existing projects.
  • Managed development, integrated system test, user acceptance test and production call-center teams.
  • Facilitated the completion of project activities, identify barriers, assess and monitor progress of project activities, and support the problem resolution process by providing input to, or recommending solutions, as necessary.
  • Identified gaps in the business processes and develop specifications to address gaps and resolve cross-functional issues.
  • Worked with the project and process teams to resolve production and integrity issues as well as coordinated effective efforts.
  • Evaluated and advised on project performance, and assessed progress against strategic and tactical project plans.
  • Managed offshore and onshore management of technical resources.

Key Accomplishments

  • Led a team of 4 people based out of Accenture, India office to turnaround a key application GECF Operations , bringing the number of issues down from 50 to 0 in a span of 2 months.
  • Assisted the Accenture team as a subject matter expert on Hyperion Essbase for the Collections and the Consumer applications of the client.

Confidential

  • Responsible for customer requirements analysis and documentation, data modeling, coding data transformation procedures, end to end testing, system documentation and metadata driven functional analysis for the user

Key Accomplishments

  • Successfully designed the datawarehouse and reporting aspects of the Enterprise Financial Reporting and the Funds Transfer Pricing project for the United Bank of Africa, Nigeria.
  • Developed the Credit Risk Analytics Datawarehouse and the Reporting for HDFC Bank, Mumbai in a constrained time of only 3 months.
  • Developed and Implemented the General Ledger Analytics for Shinsei Bank, Japan

We'd love your feedback!