SUMMARY:

• BI/DW Project and Product Manager with progressive experience in fostering and nurturing project team accomplishing project goals and personal development. Leveraging technical insight in risk and scope management while controlling cost. Excellent in relationship development, project scope, budget, schedule and risk management. Swift communicator with all levels of project stakeholders building trust and ensuring successful project completion.
• Over 17 years of global experience in software design, development, deployment and support of Insurance, Hospitality, Revenue, Customer, Retail Sales, Finance and Marketing functional domains.
• Successfully manages project and development/support teams for complex programs in a matrix environment. Effectively partners with business sponsors to drive projects, and collaborates with users to seek opportunities for improving data management while exploring new business areas. Demonstrates excellent leadership and management skills, influencing and communicating well with both cross - functional and virtual teams. Strengths include:
• BI/DW Design
• Application Architecture
• Agile BI
• Data Architecture
• BI/DW Solution Architecture
• Database Architecture Project Management
• Contractor/Vendor Management
• Global/Cross-functional Teams
• Process Modeling
• Production Support
• Disaster Recovery
• Platform Architecture

TECHNICAL SKILLS:

Databases and utilities: Oracle Exadata, Oracle 11gR2, SQL Server 2008/2012, Greenplum 4.x, PL/SQL, Oracle Utilities, TOAD, Erwin

ETL Tools: Oracle PL-SQL, Oracle Golden Gate, Informatica PowerCenter 9, UNIX Shell Scripts

Version Control: Rational Team Concert (RTC)

Reporting Tools: MicroStrategy v9.2.x, Excel pivot tables

SOFTWARE: Autosys, Legato, Unix Shell, Enterprise manager, Visio, Microsoft Project, Clarity, Remedy, Sharepoint

OPERATING SYSTEMS: Windows, UNIX (HP, SUN, IBM)

PROFESSIONAL EXPERIENCE:

EDW Project/Program Manager

Confidential

Responsibilities:

• Leading EDW program in building source code management with Informatica, Teradata and Unix scripts with IBM Rational Team Concert(RTC).
• Managing team of 6 developers in building customized solution using RTC and Jenkins framework.
• Collaborating with Portfolio and Project Managers in socialization and adoption of tool being developed.
• Managing risk and project scope while integrating with new technologies.

BI/DW Consultant

Confidential, Stamford, CT

Responsibilities:

• Enhancing Revenue Management BI experience by streamlining, prioritizing requests based on business priorities and available resources.
• Engaging production and development teams, minimizing problem ticket resolution window.
• Leading effort in advocating and socializing Agile BI with MicroStrategy Visual Insight.
• Establishing process change to accommodate Agile BI roadmap.
• Setting up the foundation to bring enterprise into the next level of information delivery including MAPS visualizations, mobile and advanced analytics.
• Finalize scope & schedule, provided time & cost estimates, status reporting & monitoring of onsite/offshore resources, coordinated UATs, managed deliverables & milestones for BI solutions delivery.
• Engagement with Business Analyst in collecting functional requirements. Design review of proposed BI solution with onsite/offshore leads.
• Managing onsite/offshore resources to meet Business priorities and enhancing BI experiences.
• Collaborating with Business and QA team ensuring test case represents business expectations in functional and performance scripts.
• Introducing advanced data quality with standard deviation integrated with MicroStrategy Analytics. Setting a data quality framework leveraging Visual Insight user experience capabilities to efficiently identify data gaps.
• Engagement with BI support vendor to utilize hardware and software in best interest of Business by keeping cost low and performance optimal.
• Collaborating with Network and Database internal team addressing performance issues.
• Reviewing data and database structure on Oracle’s Exadata balancing processing between Warehouse and BI.

Confidential, Rye, NY

DW/BI Project Manager

Responsibilities:

• Responsible for demand estimation, resource requirement, prioritization, design documents and system test scenarios of Avon’s Business Intelligence (BI) & Data Warehousing (DW) applications.
• Managed team of 12 onsite/offshore resources in building Data Warehouse, design data, database, ETL and external interfaces (Salesforce).
• Led Business Intelligence project plan, activities, duration, sequencing, status reports,, turnover plans and resource leveling with team of 25 resources (onsite/offshore) distributed across many geographical area including Europe, South East Asia and Latin America with project budget of 1.2 million.
• Aligned DW/BI infrastructure upgrade projects with other key initiatives reducing risk and resource conflict by proactively working with functional and project managers.
• Leveraged data and database background in refining and streamlining activities, identifying risk and plan contingencies.
• Successfully managed and completed Oracle/MicroStrategy version and server upgrade project in 6 months involving 15 resources and 1800+ stakeholders across many verticals (Marketing, Sales, Finance, and Supply Chain) in BI. Seamless cutover with parallel run of environment ensuring data quality and performance. Leveraged existing technology to reduce testing effort in migration.
• Contingency planned and leveraged during software upgrade while applying most recent patch to address a critical software bug.
• Conducted user s, created artifacts to promote user self-service for information.
• Monitored and measured BI solution delivery KPIs (SLAs, usage) to drive global adoption of BI solutions at operational and strategic decision making.
• Collaborated with internal PMO group and other project managers in sharing best practices, resource and capacity planning and posting regular updates to Clarity on project status and progress.
• Led project teams in implementing new BI reports and custom BI/DW solutions based on local systems and interfaces to deliver critical business KPIs and metrics.
• Worked closely with data architects and provided inputs for aggregates and facts data modeling.
• Provided necessary data for marketing ad-hoc data mining analytics.
• Ensured data quality in Country Data Warehouse(CDW) (10 TB) following the principles of data availability, data accuracy and data correction.
• Supported 2 MicroStrategy environments (US/Europe) on Linux supporting 1800+ users across 60 markets and corporate users.
• Developed Operational BI reporting in MicroStrategy to track SLA and incidents performance and measure report development expense against ongoing issues and usage statistics

DW/BI Platform Architect/Production Support Manager

Confidential

Responsibilities:

• Upgraded MicroStrategy from V9.0 to V9.2 and V9.3 supporting 1800+ users with team of 4 at offshore and one onsite.
• Established database and BI security policy and ensured the security is adhered to Legal guidelines. Supported various audits and process controls as needed by the organization.
• Partnership with MicroStrategy consultant on environment review and prioritize recommendations.
• Escalated BI application MicroStrategy issues with account manager for quick resolution. Prioritized support tickets based on criticality and resource available.
• Supported CA-Clarity reporting component hosted in Business Objects.
• Conducted proof of concepts and liaison with vendors to identify the MPP platform (Greenplum) for Enterprise Information Delivery (EID) group.
• Managed offshore vendor team (in India) and ensured that deliverables are meeting the required quality and timelines.
• Provided timely status reports to senior management and escalated issues appropriately.

Environment: MicroStrategy v9.4, NarrowCast 9.4, Business Objects XI, Oracle 11g, Greenplum 4.x Toad, Pl/SQL, Remedy, Enterprise Manager, SQL Server 2008/2012, SQL Server Integration Services, MS office, Visio, Share point, Linux.

Confidential, Rye, NY

Oracle and SQL Server Database Administrator

Responsibilities:

• Efficiently and effectively managed database projects working with management and business solutions team on project planning, requirement engineering, and system impact assessment.
• Coordinated between the onsite and offshore resources in the US, Europe, and India, from the Data Architect, Application Development, and System Admin groups etc.
• Provided day-to-day production support and manage the database growth for various Oracle and SQLServer Databases, which includes US data warehouse, Global data warehouse, Global Internet, Call Center databases etc.
• Ensured that the databases adhere to the disaster recovery standards and the databases are being monitored by the data center and reacting to all the critical alerts in time.
• Provided support to the development teams in developing high performing applications, ETL processes and in tuning the sqls etc.
• Migrated Oracle databases from Sun OS to AIX OS and at the same time upgrade to Oracle 10g, using Transportable Tablespaces (8 TB).
• Migrated existing active-active clustered SQL Server consolidated database server to a latest server and OS and to the latest service pack level.
• Audited databases with external/internal auditors ensuring data security and privacy.

Environment: Oracle 10G, 11G, Toad, UNIX shell scripts, RMAN, SQL Server 2005/2008

Confidential, Middlesex, NJ

Oracle Developer

Responsibilities:

• Gathered application requirement and provided design recommendations.
• Coded, tested, documented Oracle packages, procedures.