SUMMARY

• Over 15+ years of professional experience in IT and expert as Solutions Architect and Technical Project Manager.
• Expertise in performing project management related to BI implementations, upgrades and conversion.
• Experience in Developing and revising project materials and maintains project documentation.
• Expertise in defining the scope and impact of projects and TEMPeffectively communicates the impact on the organization. Experience in Establishing project tasks, timelines and budgets and TEMPeffectively manages them.
• Performed various roles in Project Management, Enterprise Data Management, Business Intelligence and Enterprise Resource planning solutions.
• Expertise in Tableau, Oracle, Oracle Business Intelligence, Informatica, Microstrategy, SAP Business Object, Sybase IQ, Autosys, Teradata, Mobile BI, Tibco Spotfire 5.0, OBIEE, UNIX, FSLDM (CSLDM), Power builder and ant framework
• Contributed in implementing various Enterprise Data Management, Business Intelligence, Analytics and visualization solution like Master Data Management, Enterprise Data Warehouse, Data Marts, Operational Data Warehouse/Sources and BI solutions such as Management Information Desk and self - service BI, Analytical dashboards and Canned Reports solutions in various technologies.
• Contributed in Enterprise Data and analytics Strategy planning. Prepared delivery roadmap of large scale programs, Managed program level estimation, budgeting and costing during discovery phase.
• Excellent hands-on and strong understanding of Business Intelligence, ETL, data architecture, relational data modeling, dimensional data modeling, Analytics and visualization preparation,
• Working in banking and financial services domain for more than 10 years and possess good noledge of investment banking, private banking and mortgage banking products and operations.
• Delivered BI/EDW solution for customer relation management, portfolio management, trade execution, risk and compliance, trade monitoring and surveillance, product management.
• Good understanding of Client Reporting, Trade Lifecycle, Investment Banking Products.
• Deliver key Business Intelligence Solution on CRM data for investment banking, private banking and telecom domain.
• Performed various delivery manager and technology lead roles like Program Manager, Project Manager, Product Manager, Delivery Manager, Data Architect, and Tech Lead.
• Worked on deliveries for clients such as Confidential, Confidential, Confidential Bank, Confidential ’s Investors Services.
• Possesses experience of Agile and Waterfall delivery model.
• Has been awarded by clients for outstanding contribution in project success with awards like “Thank you” award from Confidential Bank and “Pat on the Back” award from Tech-Mahindra.

TECHNICAL SKILLS

Scripting Languages: PL- SQL, UNIX - Shell, VBA, and JavaScript

Database: Oracle, Sybase, Teradata.

BI and Analytics Tools: Business Objects XI R4, Tableau 8.0, Tibco Spotfire 5.0, OBIEE.

ETL Tools: Informatica, AB-Initio.

Data Modeling Tool: Power Designer V-15, ER Win V-7.

Job Scheduler: Control-M, AUTOSYS.

Technology: VB.Net, ASP.Net, Java.

PROFESSIONAL EXPERIENCE

Confidential

Technical Project Manager & BI Solutions Architect

Responsibilities:

• Working as Tableau BI Solution Architect and Data Analytics Technical Project Manager.
• Confidential solution provide an integrated data warehouse which pulls financial data like Account receivable, Revenue periodically from multiple source systems, clean, integrate and store it in dimensional model. A dashboard is developed for business users to access integrated financial reports. Users are able to perform ad-hoc analysis, slice dice, and merge the data to create their own analytics.
• Responsible for driving the management and meeting of all team deadlines and assures all tracking and day-to-day project management responsibility for each job request from its initiation to its final destination.
• Reviews & understands all tasks prior to communication to Team. This includes ensuring that direction is complete. Partners with the client and Project Planners to flag any concerns on directive, and to resolve logistics.
• Ensuring that project directive & documentation has taken place to appropriate team members.
• Project responsibilities include capturing data and Reporting requirement.
• Responsible for Tableau architecture and Designing ETL layer and Business intelligence solution.
• Responsible for Design logical and physical data model, Design integration with source systems and Manage project delivery.
• Organizing and delivering services on a cross-section of complex projects for Tableau and actively participating in the development of business and relationships.
• Participating and leading aspects of the Tableau proposal development process and Responsible for project financials including development of financial plans.
• Managing day-to-day interactions with clients and internal team and displaying breadth and depth of noledge regarding functional and technical issues.
• Responsible for Cloud architecture design, Tableau architecture and data architecture design.

Confidential

BI (Microstrategy) and Analytics Architect & Project Manager

Responsibilities:

• As BI (Microstrategy) and Analytics Architect & Project Manager was responsible to analyze current state of reporting and analytics solutions and ensure GDW 2.0 efficiently support future state of solutions.
• Closely worked with technology and business team and performed following activities, analyzed current state of reporting BI (Microstrategy) solutions.
• Impacted analysis on reporting and BI (Microstrategy) solutions.
• Collected Functional and non-functional requirements for key canned reports.
• Ensured all reporting attributes are covered in data model in appropriate area (Core V/S Data Mart).
• Automated metadata creation in Microstrategy and Led development in Microstrategy.
• Built, maintained, and leveraged logical and physical data models to ensure integration of enterprise data and applications.
• Defined and maintained data architectures, standards, and guidelines and provided technical advice and guidance to technical resources in the creation and implementation of data standards and architecture.
• Conducted data profiling, metadata modeling, interactive / dynamic dashboards development, and leveraging all visualization and functionality options available in tool.
• Demonstrated use of MicroStrategy development tools including Architect, Desktop, Web, Mobile, Object Manager, Enterprise Manager and Command Manager.
• Conducted data analysis, metadata modeling and evaluation of new Business Intelligence technologies, features and products to synthesize innovative production solutions.

Confidential

BI / Data Architect and Program Manager

Responsibilities:

• Confidential ’s is executing a multiyear transformation program of enterprise application harmonization, Objective is to consolidate and improve Rating, analytical and data management applications to next generation.
• As part of data discovery planning, Enterprise data management services is envisioned to cater enterprise level data need which will be supported by standard framework and solutions like Master Data Management, Enterprise Data Warehouse, Enterprise content management, Enterprise Report Framework and Data Intake framework. As a consultant Program Manager my responsibility to plan and manage discovery phase deliverable, co-ordinate and execute it with EDM stake holders and other application harmonization programs owners.
• Defined, finalized and socialized discovery phase deliverables and planned discovery phase activities.
• Provided thought leadership in the contents of the deliverables and Prepared conceptual architectural of future state.
• Identify projects and prepare roadmap and prepared T-size to final level estimation.
• Prepared resource plan and forecasted for 2015 projects and Initiated and supported infrastructure, Hardware, software and vendor acquisition.
• Managed EDM level budget and forecasted for all projects in scope.
• Led team of BI developers, DBA’S and data analysts responsible for enterprise data warehouse and data marts.
• Built, maintained, and leveraged logical and physical data models to ensure integration of enterprise data and applications.
• Reviewed current frameworks and designs for architectural issues or concerns such as integrity, scalability, security and to provided recommendations to address reporting and application performance and availability by providing database or new technologies.

Confidential

Project Manager

Responsibilities:

• Engagement scope was to support technology projects in Trade surveillance- compliance department of Confidential Bank. One of the key deliveries is migrate compliance data warehouse from Sybase 15.2 to 15.4 and implement efficient batch monitoring functionality in ETL layer. Program also includes minor deliveries in Brio report development.
• As a Project Manager my key role was to plan, execute and track technology projects of CDW (Compliance data warehouse) and also manage the program from client relationship and revenue perspective for Polaris.
• Prepared project plan. Define milestones and deliverables.
• Provided thought leadership and direction to the technical team for the success of the project.
• Projected progress tracking, issue and risk monitoring and Prepared, managed and executed Communication plan and Interaction with application manager of impacted systems.

Confidential

Enterprise BI Solution Architect and Program Manager

Responsibilities:

• Engagement scope is to provide BI deliveries and support services to Confidential . This program started in 2012 to cater various BI needs across all line of business in the enterprise. Along with deliveries, I was also involved in many innovation programs.
• Responsible for SAP BO XI R3.1 to SAP BI 4.0 Migrations and SAP BI 4.0 environment setup.
• Responsible for BI Solution delivery in MIS department of Retail, Card, Information security and Analytics and Visualization development in Tableau 7.0 and Mobile BI solution using SAP Business Objects BI 4.0.
• Worked on Information security data mart and BI solution as BI Solution Architect and responsible for Solution Architecture and Dimensional data modeling for analytics layer.
• Designed aggregation and KPI calculation engine on need basis, Designed BO semantic layer, and report and dashboard solution, Performance tuning of reports and data load scripts by configuration setup and implementing best practices.
• In addition as part of Program Manager role responsibilities were, Tracking of various project delivery and service SLAs identified as part of engagement agreement, Consulting in BI roadmap implementation and consulting in integrated BI portal solution as part of BI roadmap strategy.
• Led BI innovation. Introducing, evaluating and publishing new BI solution approaches and best practices.

Confidential

Project Manager / Senior Data Modeler

Responsibilities:

• Confidential TEMPhas partnered with Teradata for Enterprise data warehouse solution model. CS TEMPhas 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.
• Understood business need of the project and defining project charter and prepared budget, distributed and tracked cost allocation.
• Prepared return on investment, Participated in project proposal and getting approval from steering committee and Prepared project plan, resource plan and managing operations.
• Reviewed and analyzed requirements and evaluated CSLDM models.
• Prepared business object model and logical data model, Performed Data profiling, Designed staging layer and defining strategy.
• Evaluated data dependency and designing control-M jobs and Compiled DDL, DML and ETL component and prepare deployment packages in java “ant” framework in UNIX.
• Issued and risk tracked and ensured timely resolution and Supported / mentored technical team member as and when required and status reporting to sounding board and steering committee.

Confidential

BI Solution Architect / Project Manager

Responsibilities:

• Responsible to manage MIS reporting desk of Private Banking. He TEMPhas 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.
• Played critical role in many business program level initiatives by providing analytic data.
• Managed business intelligence environment and providing support to business users of CS PB.
• Designed and developed reporting component in IT projects, Data modeling for analytics layer and Supported Business Intelligence reporting need for Private Banking business.
• Managed Book of work, Project planning and estimation, Task allocation, risk / issue tracking and status reporting.
• Some major achievements as Consultant Business Intelligence,
• Application migration from Business Object version 6.5 to Business Object XI R3 and Practice Management analytics dashboard delivery and support and Operation excellence Dashboard delivery and support.
• Trade Cancel and Correction dashboard, Object level Security Module implementation and MIS International support for PBUSA data.

Confidential

BI Solution Architect

Responsibilities:

• Confidential was a Technology Performance Dashboard of Confidential application. Dashboard provides performance and availability matrices of various applications running in different business units.
• All systems are having different frequency of generating matrix data. Dashboard displays monthly metrics of all systems categorized by business units. User can drill down till each systems granulated frequency and at leaf level a detail report
• Responsible for Requirement analysis and design of system and Interaction with Global Architect group, Infrastructure team.
• Prepared detail design, Tracked development activity, mentored developers and Supported quality gate clearance.

Confidential

Offshore Project Manager

Responsibilities:

• STeP is end to end solution for Confidential ’s home loan system. PRONTO was the legacy loan origination system for different home loan channels like Wholesale, Consumer Direct and Retail, which is being replaced by palisades. Project scope was to create data marts for all channels and building BI reports, dashboards and ad-hoc reporting capabilities.
• Responsible for Interaction with Client and onsite team, provided project status and received any change, Analyzed Impact due to change, Analyzed any change in deliverable, design, Task allocation and tracking.
• Reviewed reports and other deliverables, ensured quality compliance, faced quality audits and receiving signoffs and faced review session with client and receiving signoffs.

Confidential

Offshore Project Leader

Responsibilities:

• SPODW is a Confidential ’s sales data warehouse. Shering Plough’s sales management team requirement was to establish state of the art Business Intelligence environment which enables sales managers to review and analysis their business using canned and adhoc reporting systems.
• Responsible for Interaction with onsite project team and client on daily status of the project, Analysis of dependency / issues for the deliverable, Task Planning, prioritizing, delegation and controlling.
• Mentored team members on technical issues and tracked task progress and reporting status to client by end of the day.
• Managed Issues / risk tracking and resolution and ensured quality delivery by reviewing and testing of the deliverables (Documents or code).

Confidential

EDW Team Leader

Responsibilities:

• Merlin is a data warehouse for performance measurement of customer call center's executives of BT Retail. Data moves from various transaction systems to Merlin data warehouse through some modules.
• Involved in development of Merlin module of Timesheet and Schedule capture and production support of Merlin.
• Responsible for Interaction with on-site team and customer, Analysis of requirement, Creating high level design documents, Task distribution and monitoring, Delivery management
• Received Pat on the back award for outstanding performance.
• Scheduling release of fixes and enhancements.