SUMMARY:

• 12+ years of relevant experience of total 18 years ofIT experiencein the area of end - to-end IT transformation, data related programs
• Successful project delivery for leading global Banks, Insurance and other financial institution in business critical areas
• Projects across domain for Enterprise Data Warehouse (EDW), Business Intelligence, Mining and Analytics, Legacy Application and Data Migration
• Good experience ofproduct development and implementation from conceptualization to the final product deployment
• Delivered assignment through various delivery models and methodology such Waterfall, Agile Scrum, onshore-offshore, multi-vendor
• Worked at the capacity of technical and functional member, lead, enterprise consultant, data architect, project and program manager
• Good experience of working with and for the Executives, Leads, Directors and Users Community to understand their needs model feasible solution

EXPERTISE AREA:

• Data Architecture, Analysis SDLC (Waterfall, Agile and Hybrid)
• Business Systems Analysis Project Management Professional (PMP)
• Requirements lifecycle Stakeholders management
• Cross functional environment Enterprise Architecture Framework (TOGF)

PROFESSIONAL EXPERIENCE:

Confidential, Satellite, NY

BI Data Architect and Analyst

Responsibilities:

• Data and business requirement analysis under data domain projects for marketing business intelligence
• Ownership from project conceptualization to the final delivery for campaign and customer relationship
• Develop conceptual solution design and proposals, logical data model, functional specifications documentation
• Manage stakeholders expectations for business, IT development and quality assistance throughout the solution delivery phases

Environment: Teradata Data Warehouse, SQL Queries, Visio, Erwin, Office

Confidential, DE

Business Data Analyst

Responsibilities:

• Work with stakeholder from multiple LOBs on regulatory and compliance data lineage analysis
• Scope finalization, solution roadmap and delivery
• Workshops with external vendors, internal IT team and business stakeholders
• Liaise with vendor product team for development, testing and implementation, SLA adherence
• Conduct post deployment Quality Assuranceand assist user community for UAT
• Implement Agile methodology and work with product owner to create stories for sprint and backlog

Environment: Abinitio Metadata, Oracle 11g Toad, ALM, Jira, Workflow, Erwin, Blueprint

Confidential, IN/SA

Data Architect

Responsibilities:

• Work for run and change RTB/CTB initiatives, respond to RFI and RFP
• Collaborate with subject matter experts (SME’s) for proof of concept and solution roadmap
• Analysis, planning and consulting on legacy application and data migration approach
• Work with team to prepare transition from old to new system migration
• Conduct workshops with internal IT team and business stakeholders
• Requirements gathering, scope finalization and presentation to project sponsors/executives

Environment: Abinitio, Erwin, Hadoop, Informatica,Microstrategy, SAS Grid

Confidential, OH

Integration Lead

Responsibilities:

• Implementation roadmap for scoring system with Finacle core banking in 9 countries estimated at $17.5 million
• Ensure enterprise architecture, data governance and SOA followed throughout then implementation
• Lead data mapping, reconciliation and set goals for credit bureau integration (TransUninon, Compuscan), operational data store (ODS), Data Warehouse and MIS
• Maintain data integrity and stream needs for extraction, processing, analysis and storage
• Guide team to document source to target data mapping for multiple systems (CRM and BPM) integration with the scoring system
• Engage with the technical team to design context diagram, data model and presentation to stakeholders for approval
• Ensure that the scoring data extracts from in-country ODS is loaded into headquarter data warehouse for executive reporting and analytics
• Provide guidance to business analyst for business cases and functional specifications, presentation to stakeholders for signoff from sponsors
• Provide inputs to corporate governance team and approve SLA and OLA defined for the product and peripheral systems
• Maintain relationship and coordinate with in-country credit teams for users training and user acceptance testing (UAT), parallel-run, downtime and decommission of old system

Environment: Oracle ESB, Erwin, Teradata, SAS,Informatica, Core banking solutions (Finacle, T24, Bankmaster), IBM BPM

Confidential, SA

Enterprise Consultant - IT Transformation

Responsibilities:

• Analysis and planning for legacy application and data migration sequence into the proposed IBM stack transition
• Document HLD, Functional Specifications and Workflow specifications
• Work with senior managers and external consultants for program roadmap
• Make complex legacy application and data spread simple for executives dashboard

Environment: Visio, Mindmap, IBM Stack

Confidential, SA

Enterprise Consultant - Portfolio alignment

Responsibilities:

• Participate in strategic planning and trailblazing for Guidewire Policy Centre implementation
• Work with and for Chief Technology Officer (CTO) to align parallel running programs to mitigate integration risk and cost escalation
• Ensure data movement and key module implementations are sequenced accurately in parallel running programs
• Scrum master from architecture group to participate in multiple program’s scrum of scrums
• Conduct scrums, create epics and user stories for architecture team

Environment: Rally, Visio, Guidewire Policy Centre, Erwin, MS CRM, SharePoint

Confidential

Data Architect/Analyst

Responsibilities:

• Reverse and re-engineering of 10+ years old legacy insurance systems and re-build as a product
• Design, develop, propose solution with the proof of concept
• End-to-end analysis of the source system, develop and propose solution with the proof of concept
• Lead and guide team of business and systems analysts for reverse engineering of the existing functionalities and workflow from the legacy system
• Conduct workshops for requirements gathering, gap analysis, key challenges, key success factors as per users
• Work on and review DFD/ ERD and Use Cases for functionality mapping matrix
• Prepare data migration strategy, ETL design, exception handling and data correction workshops
• Ensure that new data model is highly parameterized and configurable to cater to multi geography business needs
• Work with analyst to ensure that new architecture delivers business process improvement through effective workflow by reducing human intervention
• Define success criteria and ensure that those are met through regular review sessions
• Coordinate users training and acceptance testing (UAT), parallel-run, decommissioning

Environment: .NET (WCF, C#, AJAX), VBA, Delphi, SQL Server 2008, Crystal Report, SSIS, Erwin

Confidential, SA

Data Architect (Consultant)

Responsibilities:

• Create and analyze DFDs, ERD from the existing systems that consist of 4700+ tables
• Create LDM and Physical data model for optimized new data model that address scalability and future business needs in the new data model
• Engage with sponsors and other stakeholders to present them the new model
• Design conceptual, logical and physical data models (relational, normalized)
• Establish and control governance for development team
• Guide team to build proof of concept on new data mode

Environment: SQL Server, Visio, Erwin, Mindmap, MS PowerPoint, .NET

Confidential, SA

Data Architect

Responsibilities:

• Analyze, Design and Build single view customers using data warehouse from 17 countries
• Design and develop Logical Data Model (LDM), ER
• Design and develop dimensional data models in Cognos Framework Manager
• Develop and publish package for BI Reporting
• Design and develop Reports, peer review, UAT, end-user training

Environment: COGNOS 8 (Framework Manager, Cognos Connection, Report Studio, Access Manager), SQL Server

Confidential

Lead Data Analyst

Responsibilities:

• Maintain inventory of source systems to import data from into Target EDW for credit risk systems
• Lead and coach data analysis, data profiling, metadata repository, data cleansing and MDM
• Lead extract transformation and load (ETL) for source to staging and then target EDW
• Ensure that data governance is followed and reference & metadata are up-to date

Environment: SAS Enterprise Guide, SAS DI Studio, MS Project, EPM, DB2