SUMMARY:

• A Business Analyst / Data Modeler with more than 20 years of experience in Business and Information Technology, working with cross-functional teams in deadline driven and project-oriented environment. Hands-on participant in all phases of a system development lifecycle SDLC , and have placed particular emphasis on business process modeling and improvement, project management, structured systems analysis and design, facilitation of JAD sessions functional meetings, Cross-functional meetings, and design review sessions , business requirement management, data architecture, data modeling, data mapping, solutions integration, and systems administration. He possesses extensive experience in development and maintenance of data models, data architectures, data repositories, and data management procedures and standards.
• Over 15 years of experience within Financial Services and Banking industry around Capital Markets, Credit Risk, Compliance, Legal/Audit, Credit Rating / Credit Exposure Data Warehouse, Master Data Management MDM solutions, Account Opening Maintenance, Online Internet Banking, Electronic Bill Payment and Presentment EBPP system, Cross-Border Trade Confirmation Processing, Logical Provisioning System, and Online Energy Trading Platform. Used Free Market banking concepts and Islamic banking practices while implementing various Consumer Banking Applications Retail Banking for Citibank in multiple countries India, Pakistan, and Indonesia .
• Has performed business requirements gathering, conceptual data model, logical data modeling, Entity-Relation diagrams, system requirement analysis, solution architecture, process modeling, workflow analysis, fit-gap analysis, data-flow analysis, data mapping, and structured data modeling, etc. for numerous strategic clients such as Southern Company Alabama Powers , Ellucian aka., SunGard Higher Education , Bank of Tokyo Mitsubishi UFJ, Dunn Bradstreet D B , Wachovia Bank, Bank of America - Merrill Lynch, Met-Life, Citizen Bank, AIG, Citibank, Verizon, Johnson Johnson, General Electric GE Corporate, Rapattoni Corporation, Lipper a Reuter's company , Lincoln Financial Advisors LFA , California Fringe Benefits CFB , NBC-Universal, Fedway Associates Inc., eBay Inc., and American Express Travel Services, Armstrong World Industries, HoustonStreet Exchange HoustonStreet.com , National Exchange Carrier Association Inc. NECA , Banknorth Group Inc., and United Parcel Service UPS .
• Have traveled internationally to assist on-site for project presentations, business requirement gathering, data analysis, feasibility study, UAT, and project implementations Jakarta, Karachi, Germany, UK, Mexico, etc. .

CORE COMPETENCIES:

SKILLS SUMMARY:

FUNCTIONAL EXPERTISE

• Facilitation of JAD sessions, functional meetings, Cross-functional meetings, and design review sessions
• Business Process Engineering/Re-engineering, Team Building, Project Lifecycle SDLC , SWOT Strength Weakness Opportunity Threat Analysis
• Business analysis, Business Area Analysis, Business System Analysis, Requirement/Use Case Gathering, Functional/Use Case Analysis, traceability matrices
• Process Modeling, Swim Lane Diagrams, Functional Decomposition, Functional Definitions, Data flow diagrams, Work Flow Analysis/Gap Analysis, Writing Process Specifications
• Interaction Models, Context level diagram, External agent definitions, Process verses data matrix CRUD
• Structured Data Modeling, Conceptual data models, Logical data models, Building large scale data models, OLTP, OLAP, and Reference/Master Data MDM modeling techniques/principles, Logical ER diagram, Entity definitions, Business rules, Entity life cycle analysis, Event analysis, Physical data model, Logical to physical entity attributes mappings, Schema database generation, Volumetric Analysis
• Dimensional Data Modeling, Data Warehousing, Data Repository, Data Marts, Data Analysis, Data Administration, Business Information and Reporting tools, Decision Support Systems DSS , Executive Information Systems EIS , Enterprise-wide reporting and personalized Cockpit/Dashboards
• Object Oriented Analysis and Design, Use Cases, Unified Modeling Language, Rational Unified Process, Sequence Diagram, Class Diagram, Activity Diagram, Object Diagram
• Preparation of test plan/test scripts/test cases, Test Management Defect Tracking, User Training

WORK EXPERIENCE:

Confidential

Business Consultant

• Working as home-based franchise business advisor for small businesses
• Provide expert consulting advice in building Sales Marketing teams for online retailers
• Organize and present Sales Marketing plan to prospective retailers and distributors
• Maintain relationships with new and existing clients/distributors, understand their business needs, and collaborate to elicit, identify, and document their business expansion and implementation plans/requirements
• Facilitate discussions and gathered business objectives and goals with business domain users
• Set priorities and took appropriate decisions within established policies and procedures
• Provide business support and training during the implementation

Confidential

Sr. Business Analyst / Data Architect

• Worked with Confidential on their Data Governance Strategic Planning initiatives and developed a Unified Data Model .
• Developed Data Governance Strategy and Framework Documentation
• Led Data Governance Policies Documentation and Data Standards Documentation efforts
• Analyzed and developed new processes and dataflow through business process re-engineering
• Assessed current state of all billing applications in F CS domain and identify bottlenecks in the current database processes and develop a Unified Conceptual Model UDM for future state of all billing and analytic processes including 'Pool Billing', 'Contract Billing', 'Transmission Billing', 'Reserve Sharing', and 'Energy Analysis'
• Conducted business user interviews and reviewed existing documentation to identify and define the additional business processes within these business areas and define data inputs / outputs and the associated data objects not currently included in the existing model
• Fully expanded the UDM with attributes, relationships, and reference values as applicable
• Developed common definitions for data objects and facilitate consensus building sessions between stakeholders
• Identified current data source and System of records for all entity/data objects in the Unified data model
• Developed Standardized Canonical Document of Data Definitions
• Developed Business Process Definitions for gaps Documentation
• Developed Data Object Matrix Documentation
• Developed a fully expanded Logical and Physical data model in order to implement Hourly Unit Generation process a Pilot project
• Reviewed, analyzed and documented existing business processes
• Identified, documented, and prioritized major Operational and Technology risks and their mitigation requirement under several risk areas, such as: data centric, process centric, application centric, technology consolidation, new process/tool centric, and compliance centric
• Developed a 5-year UDM Implementation Plan for F CS includes integration with all current billing and analytic applications in F CS domain based on above risk analysis and identified tactical and strategic project initiatives

Confidential

Data Warehouse Architect

• Worked for SunGard Higher Education with Banner Performance Reporting and Analytics Group on Advance Performance Data Warehouse solutions, designed to manage prospects and campaigns, drive fundraising, and engage constituents
• Reviewed new business requirements / features related to maintenance and/ or enhancement of existing Advance Performance Management product
• Collaborated with Business Analysts on new Data warehouse solutions, initiatives for the implementation of new systems and problem resolution
• Reviewed existing Source System Documentation, data model s , and data dictionaries
• Performed data gap analysis
• Created/enhance data model to support the new requirement/feature
• Profiled source data based on data extracts and system documentation
• Created Data Mapping documentation for ETL process
• Conducted Data Mapping Session with SMEs, validated initial data mapping, identified closed any gaps

Confidential

Business Consultant

• Worked as home-based franchise business advisor for small businesses
• Provided expert consulting advice in building Sales Marketing teams for online retailers
• Organized and presented Sales Marketing plan to prospective retailers and distributors
• Maintained relationship with new and existing clients/distributors, understand their business needs, and collaborate to elicit, identify, and document their business expansion and implementation plans/requirements
• Facilitated discussions and gathered business objectives and goals with business domain users
• Set priorities and took appropriate decisions within established policies and procedures
• Provided business support and training during the implementation

Confidential

Sr. Business Analyst / Data Architect

• Worked with Information Technology Division at Bank of Tokyo Mitsubishi UFJ BTMU and assisted business areas in the promotion of their system development requests these requests are related to maintenance and/ or modifications of existing systems, initiatives for the implementation of new systems and problem resolution.
• Participated in the preparation of the annual and long-term plans for ITD
• Assisted ITD with project and problem analysis, effectively communications with management, and adherence to the bank's policies and procedures
• Provided direction to Data Warehouse team members in adopting new technologies and developing new business solutions
• Performed Data Gap Analysis in current data warehouse with respect to the product level data requirements for Tokyo driven Credit Rating/Credit Exposure data warehouse project
• Analyzed and identified enterprise level non-transactional entities and related attributes such as customer, employee, vendor, products, ratings, GLs/GL mappings, accounts and custodians in order to implement MDM solutions for migrating master data from south American branches in to current data warehouse
• Coordinated the analysis and documentation of Detailed System Design document for the Credit Rating/Credit Exposure data warehouse project
• Developed System Integration Test SIT schedules and wrote the SIT Plan document
• Conducted a workshop at the BTMU Loan Syndication Group Group to review the current processes, discuss the desired future direction for these processes
• Delivered a roadmap feedback of a short term solution to the Group's Agency and Administrative processes to make them more efficient and scalable to support the business growth
• Provided a working document of the Group's high-level business requirements for submission to the BTMU SOA Team to support the long term needs of the Group in 5-year system upgrade projects

Confidential

Sr. Business Analyst

• Supported a company that licenses information on businesses and corporations for use in credit decisions, B2B marketing and supply chain management in their effort to conduct user acceptance testing of their eComm Platform Release 1.0 and Release 2.0
• Ensured compliance with appropriate regulatory, business, technical, and user community requirements
• Provided support for the criterion, independent review, approval of deliverables, and completion of test / validation status
• Assisted the UAT QA Manager in developing the UAT Plan and associated UAT report documents
• Executed the UAT Scripts and documented any exceptional conditions / deviations found during script execution
• Maintained all UAT Scripts under Quality Center and supervised the execution of the UAT Report scripts
• Used Quality Center in tracking test execution status and defects encountered during the UAT cycle

Data Architect

Developed complete data dictionary of the Asset Portfolio Management effort under Software Asset Management Consolidation initiative for a major US bank.

Senior Business Analyst / UAT Lead

• Developed standard template documentation and execution of UAT test scripts for a web-based Account Opening and Maintenance process. Supported UAT efforts for testing Money Manager Service MMS portal for Cash Management and Retirement accounts at a major US based multinational financial company.
• Reviewed Business Requirements and analyzed existing mainframe based applications related to CMA and Retirement account opening processes Client On-boarding Process
• Created UAT test scripts for all account opening scenarios, executed test scripts and performed incremental regression testing
• Managed defect tracking and retesting process for the project
• Managed client expectation around number of test scenario/test cases to be developed and tested for testing the complete functionality of the application during UAT testing

Senior Data Analyst

Performed competitive analysis of Life Insurance Account Opening Form for six competitors of a US based major global Insurance Company with respect to data and content. Developed a detailed data dictionary of data elements required for of Life Insurance Account Opening process.

Senior Business Analyst / Data Analyst

• Supported an effort to enhance the credit risk and operational risk management capabilities of a multi-national bank to meet their Basel II requirements in support of US-based regulatory capital compliance and support for economic capital credit reporting.
• Reviewed Source System Documentation, data model s , and data dictionaries for several loan origination systems
• Profiled source data based on data extracts and system documentation
• Created Data Mapping against identified Basel II data requirements
• Performed data gap analysis
• Conducted Data Mapping Session with SMEs, validated initial data mapping, identified closed any gaps, and obtained client sign-off

Data Architect

• Supported an Investment Management Data Warehousing environment of Global Investment Group for a leading US based multi-national Financial company AIG . The Eagle Data Hub/Data warehouse environment supports their Global Reporting needs. The centralized data hub stores data from different vendors like Bloomberg, Fitch, S P, Moody's, Lehman, D B, CUSIP and ISIN Plus feeds. The data hub also stores their site Located globally SMF and Holdings data. Each site has own Trading System and Account System. Reference/Master Data like SMF, Accounts and Custodians are stored in the centralized hub. The Data Hub is the authoritative source for the reference/master data.
• Reviewed current Eagle Pace data model and provided recommendation s for future state data architecture.
• Enhanced Eagle Pace Data Model to support their future state requirements using ER Studio data modeling tool
• Reviewed Data Governance policies around MDM
• Performed analysis of master data and SMF data blocks such as Security Master Static Record, Ratings, Issuer, Industry Classifications, Schedules, Variable Rates and Issuer
• Provided solution and recommendations around As Of/ As At process related to SMF and Holdings
• Analyzed their current state process and created current state process flows and provided recommendations for improvement of MDM processes

Data Analyst

Defined business data elements and developed logical data model required to support business requirements business rule for a managed IRA application at a major US based multinational financial company.

Business Analyst Wealth Management Workstation

• Gathered, analyzed, and defined a clear set of business requirements and business rules to optimize the Wealth Management Workstation WMW branch advisory users provisioning processes through business process re-engineering and data automation.
• Facilitated requirement definition and review sessions with branch administrators, central administration, Logical Provisioning Division LPD , and business stakeholders involved in the logical user provisioning process
• Defined future state processes, sub-processes, business requirements, associated business rules, logical data model, and requirement traceability matrix for the future state logical user provisioning tool and the logical user provisioning system

Senior Business Analyst / Data Architect / Process Modeler

• Reviewed client's Data Governance policies, standards, and procedures requirements along with future data management needs and developed the best practices for data management services.
• Developed the data management requirements for a new Data Excellence Service model to support a US-based multinational pharmaceutical company's J J Order-to-Cash for Medical Device Diagnostics MD D and Contract Excellence initiatives as well as ongoing operations of contracting and Order-to-Cash for both Pharmaceutical and MD D sectors collectively Contract-to-Cash and Client's own Gateway environment
• Developed business process flow diagrams and supporting presentation materials for a Best Practices Data Management Services organization

Confidential

Sr. Business Analyst/Project Manager

• Managed and performed business requirements gathering, business modeling, system requirement analysis, designed solution architecture, workflow analysis, process modeling, fit-gap analysis, process re-engineering, operational / technology risk analysis, and structured data modeling, etc., for several strategic clients, primarily in the financial services / wealth management arena.
• Successfully documented business/technical requirements, analyzed, and designed process, workflow, and solutions across several business industries for applications such as Real Estate Association Management System, Investor profile management eMAXX Renewal , Sales Reporting Tool Web-based , News Rundown Scripts Repository, Public Warehouse system Web based , Futures Options Tracking System Web based , Compensation Management Tool Web based , and Online travel customer registration process Web based
• Extensively used RUP methodology Rational Unified Process , Object Oriented Application Design concepts OOAD and rational tools for documenting/analyzing business requirements and designing the solution
• Mentored, coached, trained other team/client member in business analyst/data modeler role techniques, and helped them in personal, professional and technical growth
• Developed standards for data definitions, data element naming conventions and logical/physical data designs. Developed logical physical data model/data architecture for eBay's Compensation Management Tool, LFA/CFB's Sales Reporting Tool, and AMEX's Travel Customer Registration Process
• Maintained business model changes Entity Relationship Diagram and related database changes scripts and initial data using ER/Studio and Erwin data modeling case tools
• Developed maintained repository of Test plans, Test Scripts, Test Cases, and Defects using home grown test management and defect tracking system moving towards Mercury TestDirector to add to the library/repository and created the framework to pull together these automated scripts to create an easily maintained asset
• Conducted user acceptance testing UAT and ensured that the test results are properly documented
• Executed software quality assurance SQA test including functional testing, regression testing, combined systems testing and end-to-end manual testing

Confidential

Sr. Business Analyst/Data Modeler/Data Architect

• Functioned as a Senior Strategic Business Analyst, and executed several projects for clients such as Armstrong World Industries, HoustonStreet Exchange HoustonStreet.com , National Exchange Carrier Association Inc. NECA , Banknorth Group Inc., United Parcel Service UPS , and Merrill Lynch.
• Successfully analyzed, designed, and implemented SAP and Legacy Systems Decommissioning Concept, Online Energy Trading Platform, Online Internet Banking, Electronic Bill Payment and Presentment EBPP system, Functional Release Management, Relationship Marketing Campaign Management, and Cross-Border Trade Confirmation Processing
• Used CASE tools to perform strategic business analysis, requirement analysis, functional analysis, workflow analysis, process modeling, and structured data modeling
• Wrote process specifications, developed test plans, wrote test scripts, and documented test cases
• Handled multiple project activities were simultaneously
• Facilitated JAD sessions and use case analysis sessions with business and technical user communities during business analysis and system design phase
• Performed database design, converted logical data model to physical data model, wrote scripts to create databases, table business rules to/ from databases
• Developed and maintained data architectures, data repositories, and data management procedures and standards
• Wrote data element naming conventions and developed standards for data-definitions

Served as a Senior Data Modeler and Data Architect at United Parcel Services UPS

• Analyzed, designed, and developed a data mart TERM Technology Enabled Relationship Marketing with the volume, revenue and customer centric information that exists in the UPS Data Warehouse, which provided integration between new Campaign Management Software PRIME VANTAGE and Modeling information
• Developed logical dimensional data model using STAR schema methodology
• Performed business area analysis of Campaign Management and Lead Management processes analyzed and identified Reference/Master Data MDM and designed ETL logic for creation of Intelligent Warehouse to assist with the creation of shared Meta data between the Data Warehouse and TERM Data Mart
• Analyzed and designed business information reporting including management dashboard requirements using BRIO reporting tool for easy extract, integrate, analyze and report information
• Researched and defined new business data elements for data warehouse and intelligent warehouse
• Served as a Senior Business Analyst and Data Modeler for Merrill Lynch
• Conducted business requirement gathering sessions, performed business analysis, facilitated JAD sessions among cross-functional groups, performed process modeling Functional Decomposition, Functional Definitions, Data flow diagrams Work flow analysis , and developed logical/physical data models for Cross-border Trade Confirmation System , Training Recording and Delivery System Wisdom.net , and business process reengineering/ re-development of Training Proposal, Planning and Budget Monitoring System Registrar
• Developed and implemented the data architecture and Data Models Logical ER diagram, Entity definitions, Business rules, Entity life cycle analysis, Event analysis, Physical data model, Logical to physical entity attributes mappings, Schema database generation for above-mention systems
• Developed, analyzed, and reviewed multiple logical solution logical data model/data architecture to a given business situation
• Mentored, coached, and trained other team/client member in business analyst/data modeler role techniques

Confidential

Sr. Business Analyst/Project Manager

• Worked at the firm that offers IT consulting and staffing services and develops, custom business application, eLearning and enterprise applications.
• Headed corporation's business accounts, lead teams of application/database designer in the feasibility study of packaged software, and executed various projects for clients such as NYNEX, Group Health Incorporated GHI , and First Data Resources.
• Conducted requirement gathering sessions and performed functionality gap analysis, process specifications, data modeling, process modeling, etc. for a Credit Card Application Processing and an Insurance Plan Rating system.

Confidential

Assistant Systems Manager/Project Manager

• Led the Quality Assurance team for Video Lottery System at Automated Wagering International, New Jersey
• Facilitated business user sessions on requirement analysis, data analysis, and data modeling sessions for the system development
• Wrote test plan, test scripts, and test specifications for the system testing
• Conducted quality assurance testing of the Lottery Application System and certified several functionalities of the system
• Developed several offline accounting reports and created online management reports
• Created and maintained the entity relationship diagrams, data flow diagrams, and context analysis diagrams
• Served as a Project Manager and executed several projects for international clients such as Government of Hong Kong , Kleinwort Benson Limited United Kingdom , and British Gas United Kingdom
• Gathered and wrote business requirements for software development projects
• Wrote trans-migration standards data conversion and application migration standards , benchmarked software, and trained the Conversion team
• Led a team of 23 people, performing QA testing of converted source programs and data

Confidential

Assistant Systems Manager/Project Manager

• Using Free Market banking concepts and Islamic banking practices implemented various Consumer Banking Applications Retail Banking for a global bank in several countries India, Pakistan, and Indonesia .
• Developed many consumer applications e.g., Consumer Oriented Retail Environment System , Consolidated Modular System , Corporate Employee Loan Program , Unfixed Deposit , Time Deposit System , and Current and Savings Accounts
• Gathered and analyzed business requirements of various divisions of the bank in these major cities: Jakarta, Karachi and New Delhi and designed and developed the required information systems
• Gathered business requirements, and wrote functional specifications for above systems
• Performed database design, converted logical data model to physical data model, wrote scripts to create databases, table business rules to/from databases
• Developed and maintained data architectures, data repositories, data management procedures
• Provided system support and conducted classroom trainings for end-users