SUMMARY

• Over 12 years IT Implementation experience, creating vision, roadmap, and implementation strategy, as Enterprise Business Intelligence (BI) /Data Warehouse Application development Manager/Architect. Lead multimillion $ projects, directing 2 - 10 member teams, of analyst, architects, developers, QA, support
• Experienced Program/Engagement manager, I have been a key liaison, building relationship between business and IT, responsible for conceptualizing, road map creation, educating and winning buy in from executive and non-executive stakeholders. Successfully applied SDLC, Agile, RUP, PMBOK, waterfall principles to projects and programs. Lead application change and release management processes
• Architected enterprise solutions for executive dashboards and reporting platform. This provided management critical data insight into KPIs for marketing, sales, finance, and operational view of lead generation, pipeline projection, AP/AR, inventory management, professional services, customer support etc. Supported ecommerce teams reduce time between order creation, and fulfillment
• Used advanced analytics to develop pricing strategies to improve product penetration, monitor channel partner marketing, customer lifecycle management, improving customer retention. Thought leader for improving cross-sell capabilities using predictive customer analytics
• Business Intelligence architect expertise designing and leading implementation of BI environment using tools like Cognos Suite, SAP BO, OBIEE, Essbase, Hyperion, Tableau, Qlikview, SSRS, Microstrategy, Spotfire etc
• Strong knowledge in SQL/ No SQL Data warehouse and Data Mart Architecture, OLTP/OLAP using Snow Flake and Star Schema normalization. Experience using IBM Hadoop big data insights, hive, mpp technology
• Expertise in directing resources, designs, budgets to deliver effective BI visualizations and data architecture
• Recruited and lead technical onshore and offshore tech/non-tech resources, allocate responsibilities as needed, working with cross-functional teams such as finance, marketing, operations, ecommerce, CS, HR,etc
• Extensive consulting experience in financial sector, retail, manufacturing, digital marketing industries

TECHNICAL SKILLS

Database Platforms: Oracle9i/10g, SQL2008 R2, DB2, Netezza, Teradata, SAP-HANA, Hadoop, Hive

Programming Languages: HTML || Tools Visio, Erwin, Informatica Power Center, MS Office

Reporting Technologies: Cognos, OBIEE, Micro strategy, BOBJ, SSRS, Omniture Site Catalyst, Planning tools

Software Management Technologies: Rational Clear Case, Clear Quest, RUP, ScrumDo, MS Project, Jira

PROFESSIONAL EXPERIENCE

Confidential

Project Lead System Analyst

Responsibilities:

• Leading process, technical and training work streams for enterprise business intelligence and reporting enhancements. Successfully trained more than 300 users’ onsite and 400 virtual users on the new platforms.
• Managed data governance standards for reporting and data lineage across functional teams and systems.
• Work closely with finance, and pricing teams, to develop value based pricing models, to improve customer confidence, improving retention and resulting in improved revenue for both customer and our firm.
• Managed software solutions scope, development, delivery, managed project schedule, cost and resources, release management, mitigating risk, following agile methodology, using TFS.
• Lead visualization dashboard creation, to show revenue and cost trends, helped FPNA teams monitor KPIs, using Business intelligence tools like SAP Business Objects suite, HFM, Tableau, on oracle/ SQL databases.

Confidential

Program Analyst Business Intelligence/DWH

Responsibilities:

• For BCBS239 regulatory project, worked with program manager and owner of charter, organization and architecture, aligned with executive management to establish standards based on federal mandate.
• Established procedures for adoption and implementation of the same. Led reporting enhancements for BASEL III, CCST, CCR, KYC programs. Lead vendor relations reducing $200K recurring costs
• Managed data governance standards for reporting and data lineage across cross functional teams and systems. Lead design discussion for automated process workflows, UI development using IBM BPM platform.
• Worked with Confidential, enterprise performance systems cross-functional teams, to establish critical data, and to create workflows to source data from enterprise repository to create data lineage visualizations in spotfire, using a customized ragged hierarchy model.
• Managed software solutions scope, development, delivery, managed project schedule, cost and resources, mitigating risk, following agile methodology, using JIRA and RTC.

Confidential

Sr Analyst Business Intelligence/DWH

Responsibilities:

• Managed information strategy of BI/DWH projects, using Netezza, IBM Cognos, hive, hadoop clusters to monitor performance of digital marketing, mobile api, financial/ operational reporting and analytics.
• Provided thought leadership to develop creative pricing strategy for Customer Support teams, reducing customer attrition by 0.9 %. Improved dealer and customer retention models, better upsell and cross-sell using market basket analysis. Designed A/B tests for emails, direct mails and digital campaigns using APRIMO
• Created predictive intelligence models using SAS, to support marketing teams with Customer Life Cycle management process, partner management. Provided self-service Cognos reports reducing turnaround time.
• Scrum master in agile environment, used Scrum Do and Jira to manage project schedule, cost and resources, bug tracking, actively mitigating project risks.

Confidential

Enterprise Application Manager Business Intelligence/DWH

Responsibilities:

• Enterprise DWH/BI manager, responsible for operational effectiveness of BI/DWH and master data teams
• Role promoted to report directly to CIO and EVP finance. Effectively communicated program delivery and risk mitigation strategy to executive leadership and cross functional stakeholders.
• Architected solutions for dashboards and reporting, giving management view into marketing, sales, FP&A, finance and operational view of lead generation, pipeline, AP/AR, inventory management, CS etc.
• Partnered with cross functional teams, to move away from premium or economy pricing to subscription models. Implemented processes to support order management, ecommerce and marketing efforts to improve and sustain GAAP realized, revenue recognition models.
• Lead implementation of BI environment using SAP - FICO/SD/MM, Sales Force, omniture web analytics, Eloqua workday etc with packages and reports built in IBM Cognos Framework manager and, Cognos BI suite
• Effectively simplified the architecture for BI using BODS, SQL server database, SSRS reports, etc.
• Migrated 200 reports from legacy systems to enterprise reporting, providing better actionable visualizations.
• Lead routine maintenance and support of DWH/ BI environment. Achieved, companywide adoption of BI tools through planned training for over 400 users Created prototype using SAP HANA, using big data approach.

Confidential

Sr. Consultant

Responsibilities:

• Sr. Consultant for TJX, designing BI project road map to migrate from legacy environment. Lead ecommerce integration with reporting applications such as Essbase, Qlikview on Oracle database.
• Conducted business case evaluations, stakeholder interviews for project feasibility and resource planning.
• Led application development for cash compliance fixed Income and trading group, to mitigate risk of indemnified Repurchase agreements, directed at saving the bank about $1billion per annum, reducing portfolio manager time and risk engagement.
• Solution architect for reporting standards of Basel II Compliance for Confidential bank’s federal requirements, Lead Cognos reporting requirements, design architecture within the Business Intelligence Data Warehouse team. Active member of center of excellence council.
• Lead implementation of business intelligence application development. Managed application Integration, conducted shareholder updates, responsible for scope definitions, requirements, risk analysis, system documentation and user training, release management. Designed solution to achieve business strategic goals, used RUP / Agile methodologies. Administered application security using LDAP.
• Articulated requirements, analyzed scope feasibility, implemented best practices, Created documentation -technical design, standards documents.
• Reviewed data warehouse model with Data Architect and DBA’s. Led Integration of TM1 planning with BI tools like Oracle OBIEE and IBM Cognos for reporting. Reviewed test strategies.
• Managed Releases using Rational Clear Case/Clear Quest for configuration Management during deployments.