SUMMARY

• Global BI Project Manager with 10+ years of experience in Project Management, Enterprise Data Management, System Integration and BI Consulting across Banking, Financial, Insurance and Healthcare Industries.
• Experienced IT professional with Project Delivery Management and Technical Leadership focused on DW and BI technologies, architecture of complex data integration initiatives, business intelligence/analytics, data warehousing, data governance, strategic planning and execution to exceed corporate performance and growth objectives.
• Experience in handling multiple BI projects, managing large ($2 to $5 M) budget efforts and leading a team of 50+ team members across global delivery locations.Proven ability to develop, build and lead teams in the implementation and execution of global strategic initiatives from conception to implementation.
• Certified Scrum Master: Excellent in Agile SCRUM implementation, expert at driving the adoption & enforcement of Scrum rules, removing impediments and fostering self - management. Coaching agile teams to enhance scrum.
• Expert knowledge and experience of IT & Business transformation projects, engaging and managing stakeholders at all levels, leading large teams across onshore, offshore and nearshore delivery centres. Hold direct budget responsibility for annual operations and deployment of new functionality in BI space.
• Broad experience as a Project Manager / BI Delivery Manager with key responsibilities as follows: Initiation: (charter, requirements gathering, (WBS), client and vendor negotiations). Planning: (work estimation, schedule / timeline and budget, project design, iterations, milestones, facilitating meetings, release planning). Execution: (directing and motivating team, daily standup meetings, removing roadblocks, managing to the schedule, resolving issues). Controlling: (ensuring project is on time, budget, quality, reporting, stages and gates, documentation). Testing: (unit, system, and UAT). Delivery (infrastructure, security),Project Closeout and Handover.
• Program Lead of Business Intelligence and Performance Management (BIPM) Practice with strong business acumen and deep expertise in Business Intelligence, Data Management and Master Data Management solutions and technologies.
• Repeatedly expanded profits with innovative strategies founded on thoughtful metrics analysis and deep understanding of market drivers. Drive millions of dollars in revenue by managing products, building cross-functional customer relationships, maximizing internal resources, and innovating leading-edge business processes.
• Good experience in issues/risk, configuration, communication, resource and escalation management, requirements management, change management and metrics. Experienced in SDLC for managing development, maintenance, enhancement, support and testing projects. Proficient in both fixed bid and T&M model.
• Experience in RDBMS & Data warehousing concepts and expertise in leading/executing all phases of a DW projectlife cycle which includes Scope Study, Requirements Gathering, Architecting, Design, Development, Implementation, Quality Assurance, Application Support for end-to-end IT solution offerings in BI space.
• Functional as a Scrum Master with comprehensive knowledge of Scrum Methodology. Capable of bringing overwhelming enthusiasm and awareness to projects, applying expert judgment to the removal of impediments, keeping teams focused and delivering success in rapidly evolving and dynamic environments.
• Excellent in project proposals and SOW management with experience in client management, people management and process management. Experience in complete demand cycle management; demand creation and fulfilment, includes Sales & Delivery with focus on Rapid BI.
• Managed projects to ensure that deliverables are met within schedule, budget, & quality. Delivered multiple projects in Data management andBIspace, which helped business in making more informed decisions. Focus areas include Consumer data enrichment, Member Analytics, Member Financial Security, Credit Card Analytics, Campaign Management, Bank Collections Analytics, Credit Card Campaign Effectiveness.
• Possess extensive experience in Banking Industry in LoBs like Cards & Payments, Collections and Credit Card Campaigns. Served as subject matter expert for Bank Data Analytics and counseling clients on key BI applications.
• Functional as a Senior BI Consultant / SAS Programmer with extensive expertise in Base and Advanced SAS for developing SAS applications, proficiency in data science, data analytics, data mining, campaign analytics, market research and forecasting with expertise in consumer segmentation and customer profiling.
• Functional as a Lead ETL Developer and has strong Data Warehousing experience using Informatica Power Center with client tools like Designer, Repository Manager, Workflow Manager and Workflow Monitor.

AREAS OF EXPERTISE

• Project & Program Management
• Requirement Management
• Strategic Analysis and Program Delivery
• Client Relationship & Vendor Management
• Strategic Planning & Decision Making
• Agile and Waterfall Project Management
• Budgeting, Forecasting & Fiscal Reporting
• Technology Planning
• Staff Management and Procurement
• Global Delivery - P&L Management
• Risk Management
• Business & IT Planning
• Process Consulting
• Leading Transformation Journeys
• Setting up offshore operations
• Delivery Ownership
• Scrum Master
• Agile Methodology
• Business Relationship and Customer Management
• Enterprise Data Warehouse Design
• Data Mining, Analysis & Management
• ETL Automation
• Data Modeling
• Certified SAS Programmer
• Business Systems Analysis & Improvement
• Campaign Analyst
• BI Development
• Team Building & Leadership
• Opportunity Identification

TECHNICAL SKILLS

Operating System: Windows 98/XP/7, Windows Server 2003, Unix

Database: Oracle 9i,DB2,Netezza, MS SQL Server, BIGSQL.

Programming Languages: SAS,SQL, PL/SQL, Unix Shell Script

Tools: R,SAS Enterprise Guide, Datameer, Informatica PowerCenter Designer, Informatica PowerCenter Workflow Manager, Informatica Power Center Workflow Monitor, Tableau, Business Objects, Squirrel, SQL Developer, Datastage, Hadoop, Control-M Desktop, Control-M Enterprise, Aginity, Starteam, Jira, Confluence.

PROFESSIONAL EXPERIENCE

BI & Data Analytics Project Manager

Confidential - Houston, TX

Responsibilities:

• Responsible to lead and manage BI projects for Data Operations & Application Development portfolio from inception through completion. Ensure delivery to business partners, while adhering to project scope, schedule, quality and budget.
• Develop and manage project budgets with end-to-end financial accountability for delivery of all solutions.
• Responsible for Client Liaison Management and meetings with project stakeholders, customer executives to finalize project objective and operational parameters.
• Interact with the project stakeholders to discuss on the various project cost, quarterly budgets, effort timelines and issue escalation.
• Perform risk identification and mitigation activities, escalating unresolved issues to the Executives or Steering Committee to secure their timely decisions and approvals.
• Lead and facilitate the Business Requirements Gathering and Analysis. Perform as Business Analyst, collaborate with business partners to analyse and understand business problem or need.
• Perform as a BI consultant and project technical lead to analyse business requirements and outline the proposed solution. Partner with business stakeholders to define acceptance criteria and success metrics for proposed solution. Collaborate with project teams to design BI solution based on business and system requirements.
• Leverage thorough understanding of the business process and related information systems to create current business process models (“as-is” process map) and future business process models (“to-be” process map).
• Elicit requirements from stakeholders, business users as the foundation for developing solutions to the project goals and objectives.
• Facilitating the Agile ceremonies: Sprint Planning, Daily Scrum, Sprint Review and Retrospective.
• Responsible for managing the product backlog, iteration backlog, user stories, capacity planning, release planning, burn down charts, co-ordinating task assignment and planning poker estimation.
• Removing impediments to the Development Team’s progress and helping the Development Team to create high-value products. Manage project scrum teams and coach team to implement agile methodologies.
• Administered Project activities including: developing and maintaining project schedules, maintaining project issues lists, maintaining project spending forecasts, planning and creating team meeting agendas and meeting minutes, and creating project status reports.
• Prepares detailed specifications, requirements, scope documents and logic flowcharts for the development and implementation of BI projects. Provide project leadership and functional support, and maintain procedural documentation to related responsibilities.
• Providing planning, direction, coordination and daily supervision to the project team to ensure the objectives and goal of the project are accomplished on time, on budget, and to the quality expected from the stakeholders.
• Responsible for leading agile project coordination to support various upstream and downstream teams. Lead scrum ceremonies for project teams. Responsible for Jira Project Management, Backlog Management, Application Production Support & Intake Management in Atlassian Jira.

BI Project Manager

Confidential

Responsibilities:

• Managing the roadmap of projects and lead BI transformational journeys to enhance the capabilities of Bank Business Intelligence and Data analytics with focus on Data Warehouse, BI tools, and reporting capabilities.
• Responsible for partnering with the project stakeholders to create and implement appropriate cost efficient solutions based on business objectives.
• Perform a governing role for ensuring that the proposal, execution, control, deployment, training, hand off, warranty support, and project closure meet promised schedules.
• Schedule staff per the approved staffing pattern, using the most cost effective approach, balancing cost with quality and need for consistent staff.
• Responsible for the design, leadership and implementation of the strategic plans for the Bank Data Analytics Program. Leads the day-to-day operations, financials, marketing and success of this Program.
• Responsible for implementation of program governance improvements and best practices to ensure optimal performance. Interviewing, training, mentoring, assigning task, monitoring and appraising resources.
• Responsible for project delivery within time, cost, scope and quality defined boundaries, in accordance with the company's life cycle methodologies and disciplines.
• Compile project status reports, statements of work, coordinates project schedules and manage project meetings. Identify and analyse system requirements and define project scope, acceptance criteria, and solution design.
• Managing virtual and co-located teams across onsite, offshore and nearshore to complete the project deliverables.
• Manages the acquisition and deployment of resources, including budget, by working with various IT Managers to secure the resources required for the project.
• Responsible for Leadership meeting with offshore management to discuss program operations such as employee hiring plan, employee skill development plan, delivery quality improvement initiatives, PI implementations, etc.
• Executed the engagement with offshore-heavy resourcing model resulting in a 4% improvement in operating margins. Mentor team members in agile software development principles, patterns, processes and practices.
• Maximized ongoing performance and efficiency of cross-functional agile engineering teams to ensure product is produced rapidly and with high quality.
• Assisted to ensure technology aligns with business needs, making sure technology investments fit strategically and tactically.
• Elicit, analyse business requirements and define data requirements from end users. Translate requirements into technical specifications, data models, data mapping and transform rules.
• Lead a team of analysts that focuses on supporting the technical teams to bridge the gap between technology, design and product management. Drive business and systems functional requirements activities.
• Responsible for requirements elicitation, requirements analysis, requirements management and communication, solution assessment and validation.
• Perform critical analysis on information consolidated from multiple sources, identify and resolve conflicts, and break down high-level information into detailed workable requirements.
• Make recommendations and propose technical solutions to solve business problem and meet business requirements. Perform Data Analysis - Interpret data, analyse results using SAS / SQL and provide insights.
• Lead teams in implementing scrum to maximize velocity. Work with Product Owner to ensure highest value features are delivered at agreed time.

Project Technical Lead

Confidential

Responsibilities:

• As a BI consultant and project technical lead, involved in project planning with client partners, business analysts and team members to analyse business requirements and outline the proposed solution.
• Requirement Gathering, Preparation of Detail Design, run Proof of Concept to validate the design.
• Understanding of the existing SAS framework, as-is business and design documents of the application and measure the feasibility of migration to the new ETL framework. (Informatica)
• Attending design document walkthroughs with customer and document business logic, mapping strategies, transformations involved in the ETL process.
• Translate requirements and high-level design into detailed functional design specifications. Responsible for source data analysis and involved in Data Modelling.
• Extensive SAS code analysis, development of the design documents and build the solution in Informatica.
• Development of SAS code to generate Financial Index score for 15 models across each Line of Business.
• Extensive development of SAS code for data extraction from multiple systems and build the input data for the FSI models. Extensive usage of SQL, SUMMARY, REPORT, FORMAT, FREQ, RANK, TRANSPOSE procedures.
• Set up automated process to publish FSI scores to multiple applications like UNICA, EDW (Enterprise Data Warehouse) and MSAE (Marketing & Sales Analytics Environment).
• Generate SAS reports as per business requirements and the client standards for the change analysis application.
• Used Informatica PowerCenter for extraction, transformation and loading data from multiple source systems.
• Used UNIX shell scripts to automate repetitive database processes, file transfers and job scheduling.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters, FTP Session Parameters and Source-Target Application Connection parameters.
• Perform as Onsite Lead - Managed the team both at onsite and offshore, delegating assignment to offshore team, analysing and proposing solution to the offshore team.
• Estimate plan and track projects for SAS solutions and mentor/guide team on technical areas pertaining to SAS.
• Acquire data from internal or external data sources and maintain mapping documents of the files, databases/data systems. Interpret data, analyse results using statistical techniques and provide ongoing reports and feedback to the Business team.
• Create design documents, models, specifications, flow diagrams, charts to provide direction to business and other IT teams. Manage the creation, review, and approval process for BRD (Business Requirements Document).
• Maintain training documents and keep them updated based on System/Process changes.
• Responsible for automation by building Control-M cycle to schedulethe SAS jobs and Informatica workflows.
• Implemented SQL PASSTHRU facility to read data from other sources. Extensive use of SAS macros, SAS Data Steps, SAS Procedures for data analysis.
• Import raw data files, transform and derive data, merge SAS data sets, perform statistical analysis, generate reports as per business requirements.
• Responsible for creating SAS reports in HTML, PDF, MS Excel formats using ODS & Macros.
• Perform Impact Analysis by analysing the existing system for new enhancements or any defects identified
• Peer code review of offshore deliveries and verify the generated product counts for marketing new/continues/loss before final delivery to TCOE team.
• Worked with QA team to create test cases for QA testing in ALM (Application Lifecycle Management).
• Experience with troubleshooting, tuning SAS server performance and automation of SAS jobs.
• Deployed codes into production environment and provide production support

BI Project Lead

Confidential

Responsibilities:

• Development of SAS model for determining optimal interchange rate with parameterised Interchange Rules.
• Interaction with client on a regular level for understanding the Mainframe system and set up the corresponding functionalities on SAS.
• Responsible as Onsite Lead and co-ordination with offshore for daily activities, deliveries and proposing solutions to the offshore team.
• Design and Development of SAS programs to import the complex VISA and MasterCard data of US, UK and Japan from flat files.
• Application of the Interchange rules through SAS programs to calculate the interchange rate and Fee Type description.
• Generation of summary report based on Interchange rules
• Comparison and analysis with interchange reports from Confidential, Visa and MasterCard on a summary and transaction level.
• Report of variances between optimal and actual interchange rates
• Suggestions for the business to implement respective changes in the system for application of the correct interchange rate.
• Root cause analysis of significant variation.
• Performance tuning and optimization of various queries for improvement of the SAS system to effectively handle large volume of data.