SUMMARY:

• Over 18 years of professional experience in IT as a successful Technology Manager. Performed various lead roles like Program Manager, Project Manager, Product Manager, Delivery Manager, Data Architect in Enterprise Data Management, Business Intelligence and Enterprise Resource planning solutions.
• Expertise in performing Program Management/ Project Management activities for medium to large scale data management & Governanace, BI and Analytics implementation.
• Managed medium to large scale project and programs with budge range from 2 Mn to 15 mn.
• Working in banking and financial services domain for more than 12 years and possess business knowledge of investment banking, private banking and mortgage banking, products and operations management, Risk and compliance management
• Delivered Analytics solution for Private banking client portfolio management, Risk assessment dashboard, Government Compliance reporting etc.
• Recently worked in life science domain to deliver enterrpise data warehouse and Analytics solution. Acquired good understanding on life science domain.
• Successfully managed and delivered solutions like Enterprise Data Warehouses, Business Intelligence, Big Data Analytics and visualization, Master Data Management, and Operational Data stores for clients such as Washington Mutual, Confidential, Confidential, Confidential, Moody’s Investors Services.
• Perform leadership role in multi million,multi - year, large scale programs and contributed in Enterprise Data and analytics Strategy planning. Prepared delivery roadmap of large scale programs, program level estimation, budgeting and costing during discovery and planning phase.
• Integration and Design solutions for EDW and MDM interfaces including batch, messaging queue and SOA based architecture.
• Excellent hands-on and strong understanding of tools and technologies of Big Data Solutions, Analytics and advance visualization, Business Intelligence, ETL, data architecture, data modeling.
• An excellent team player, an inspiring leader with futuristic vision, having excellent communication and inter-personal skills. A quick learner with the ability to make solutions-oriented, creative and innovative contributions in highly demanding situations.

TECHNICAL SKILLS:

PL SQL, Unix: Shell, VBA, Java Script

Database: Oracle, Sybase, Tera Data

BI and Analytics Tools: Business Objects XI R4, Tableau 10, Microstrategy 9.0, OBIEE

Informatica, ab: initio

Power Designer V: 15, ER Win V-7

Control: M, Autosys

Programming Languages: VB.Net, ASP.Net, Java, Python

Big Data Technologies: Cloudera Hadoop, Confidential, Cassandra, Spark

PROFESSIONAL EXPERIENCE:

Confidential

Solution Architect and Delivery Lead

• As part of Data Services team. My responsibility is to manage and deliver Data acquistion for all data need across organization. Citi-Insight data acquisition project provide data required from multiple LOB to Citi Insigt team for Management Reporting. As per Citi standard, data should be routed through EAP (Enterprise Analytics Platform) by using inhouse data transformation tools called Data Bridge. I performed Delivery lead role for BCBS 239 data delivery project to Citi Insight.

Confidential

Project Manager

• Project proposal and setup.
• Project scheduling and resource onboarding.
• Requirement elicitation and Delivery milestone definition
• Source data analysis; Identifying source data structure, entity and attribute list, data quality rules.
• Participated in ELT architecture design.
• Data model design of Spark and Cassandra layers.

Confidential

Solution Architect & Project Manager

• Initiate project; capture high level expectation and prepare delivery roadmap.
• Finalize and prioritize subject area implementation in the EDW and BI solution.
• Capture data and Reporting requirements.
• Co-ordinate with data owners, define data collection strategy.
• Perform Data analysis, Data profiling and data quality assessment.
• Defining business rule, getting signoff from business team.
• Design ETL layer and Business intelligence solution
• Design logical and physical data model
• Design integration with source systems
• Manage and track project delivery

Confidential

BI and Analytics lead

• Analyze current state of reporting solutions.
• Impact analysis on reporting and BI solutions.
• Collect Functional and non-functional requirements for key reports.
• Prepare master list of entity and attribute
• Ensure all reporting attributes are covered in data model in appropriate area (Core V/S Data Mart).
• Automate metadata creation in Microstrategy.
• Lead development in Microstrategy.

Confidential

Consultant Program Manager

• Defining, finalize and socialize discovery phase deliverables.
• Plan discovery phase activities.
• Provide thought leadership in the contents of the deliverables.
• Prepare conceptual architectural of future state
• Identify projects and prepare roadmap.
• Prepare T-size to final level estimation.
• Prepare resource plan and forecast for 2015 projects.
• Initiate and support infrastructure, Hardware, software, vendor acquisition.
• Managing EDM level budget and forecast for all projects in scope.
• Established Design principle for SOA based architecture for MDM interfaces.

Confidential

Project Manager

• Prepare project plan. Define milestones and deliverables.
• Provide thought leadership and direction to the technical team for the success of the project.
• Project progress tracking, issue and risk monitoring.
• Prepare, manage and execute Communication plan.
• Interaction with application manager of impacted systems.

Confidential

BI Engagement Manager

• Tracking of various project delivery and service SLAs identified as part of engagement agreement.
• Providing thought leadership in the organization and promoting BI excellence across the board.
• Consulting in BI roadmap implementation.
• Consulting in integrated BI portal solution as part of BI roadmap strategy.
• Leading BI innovation. Introducing, evaluating and publishing new BI solution approaches and best practices.

Confidential

Project Manager

• Confidential has partnered with Tera data for Enterprise data warehouse solution model. CS has referred FSLDM ( Financial Services Logical Data Model) and prepared its CSLDM for SMA. This project scope was to load Derivative trades of investment banking division for legal and compliance applications on the new Enterprise Data Warehouse platform.
• My initial responsibilities wereUnderstanding business need of the project and defining project charter.
• Preparing budget, distribute and tracking cost allocation. Preparing return on investment.
• Participate in project proposal and getting approval from steering committee.
• Preparing project plan, resource plan and managing operations.
• Reviewing and analyzing requirements.
• Evaluating CSLDM models. Preparing business object model and logical data model. Perform Data profiling.
• Designing staging layer and defining historization strategy.
• Evaluating data dependency and designing control-M jobs.
• Compiling DDL, DML and ETL component and prepare deployment packages in java “ant” framework in Unix.
• Issue and risk tracking and ensuring timely resolution.
• Supporting/mentoring technical team member as and when required.
• Status reporting to sounding board and steering committee.

Confidential

Product Manager Secondary Role: BI Solution Architect

• I was responsible to manage Confidential of Private Banking. He has successfully managed and delivered many critical reports and dashboards to business users of Trade Execution, monitoring and surveillance, Product management, Customer relationship management, Portfolio management. I also played critical role in many business program level initiatives by providing analytic data. Confidential was supporting following operationsManaging business intelligence environment and providing support to business users of CS PB.
• Designing and Developing reporting component in IT projects.
• Data modeling for analytics layer.
• Supporting Business Intelligence reporting need for Private Banking business.
• Managing Book of work, Project planning and estimation.
• Task allocation, risk/issue tracking and status reporting.