We provide IT Staff Augmentation Services!

Sr. Design Engineer Resume

New, JerseY

SUMMARY

  • Over 25 years of experience in delivering Large scale IT initiatives
  • Extensive experience in Business Analysis, Data Modeling, Project Management and SDLC
  • Expertize in eliciting and analyzing business/data requirements and translating them into specifications
  • Liaise with cross - functional teams (business groups, IT and PMO organizations) to determine their needs and translate them into data models. Develop Master Data Management systems for Product, Partner, Customer, and Vendor information. Ensure that modeled solutions continue to address current and future business needs
  • Experience in various workflows within Financial Services and Banking industry around Capital Markets, Credit Risk, Operational & Technology Risk analysis, Compliance, Legal/Audit, Credit Rating/ Credit Exposure Data Warehouse, Data Governance Strategy & Framework Documentation, 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
  • Significant cross-industry experience in enterprise software & solutions for Financial Services, Retail Banking, Power generation & Pool Billing, Energy Trading, and customized Process Improvement/Data Warehouse/Data Hub based technology solution
  • Hands-on experience in development and maintenance of data models, data architectures, MDM, data repositories, and data management procedures and standards. TEMPHas 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
  • Strong hands-on modeling knowledge and experience with Erwin, ER Studio, and PowerDesigner tools
  • Proficient in data analysis using SQL and Excel
  • Have a conceptual background in Big Data, Hadoop, ETL, etc.
  • Have traveled internationally to assist on-site for project presentations, business requirement gathering, data analysis, feasibility study, UAT, and project implementations
  • Excellent interpersonal, written and verbal communication skills

TECHNICAL SKILLS/TOOLS:

  • CORE COMPETENCIES: Business Analysis and Requirements Gathering; Functional/Use Case Analysis; Work Flow Analysis / Gap Analysis; Business Process Modeling/Engineering; JAD Facilitation; Data and Business Analysis; Master Data Management (MDM) Processes; Data Governance Strategy and Framework Development; Data Warehouse & Data Mart Design; Conceptual and Logical Data Modeling; Structured and Dimensional Data Modeling; Data Flow Diagramming; QA/UAT Testing; Preparation of Test Plan/Test Scripts/Test Cases; Test Management & Defect Tracking; and Project Management
  • DATA ANALYSIS, DATA MODELING, VERSION CONTROL UML, SQL, ERWin, ER Studio, Cayenne / Bachman, Oracle Designer, PowerDesigner, Rational Suite (Rose, RequisitePro, ClearCase), VCI, PVCS, Q+E Database Editor, HP Application Lifecycle Management (ALM/QC), Brio
  • BIG DATA & PREDICTIVE ANALYTICS R programming, R Packages, Statistical Analysis, Reproducible Research, Shiny, Practical Machine Learning, Natural language processing (NLP), Big Data, Hadoop
  • RDBMS DB2, Oracle, Sybase, Informix, MS SQL Server, MS Access
  • PROJECT & PROCESS MS Office (Word, Excel, PowerPoint), Visio, MS Project
  • METHODOLOGIES & STANDARDS CRoss-Industry Standard Process for Data Mining (CRISP-DM), Object-Oriented Application Design (OOAD), Rational Unified Process (RUP), Agile software development, Waterfall, SDLC, Unified Modeling Language (UML), Capability Maturity Model (CMM), Six Sigma, Fishbone Analysis (aka, Cause & Effect diagram / Ishikawa diagram), SWOT (Strength Weakness Opportunity Threat) Analysis

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Sr. Design Engineer

Responsibilities:

  • Understanding and analyzing the Business capabilities of existing Group Insurance benefit offers and integration of Company Paid Leaves and State mandated Paid Leaves coverages to the current capabilities
  • Interacted with cross-functional Architecture team, Development team, Business Analysis team, QA team, and Project management team
  • Developed and designed functional and non-functional technical specifications for complex integration of new benefit - Paid Leaves Coverage and its claim management into the existing Disability Claims Management Systems (DCMS)

Confidential, New York

Sr. Business Analyst / Data Analyst

Responsibilities:

  • Provided business analysis support for ‘Service End to End’ (SE2) on strategic initiative of revamping their existing correspondence landscape and building a next generation Enterprise Output Management Platform. Analyzed current & proposed new process/data flows and developed the high level business requirements document
  • Assumed the role of Business Requirement analyst (SME) for web-based Pega application “New Business Initiative Approval (NBIA) process” implemented Firmwide by Control Systems Technology - Oversight & Control Programs group at JPMC) and liaise between Client and development team to clarify any requirements understanding while controlling any scope changes. Also, supervised the Systems Integration Testing (SIT) and Quality Assurance (QA) testing of the application
  • Advised and supported Commercial Investment Banking (CIB) group at JPMC on their strategic CRM initiatives and tactical upgrade efforts to Investment Banking Intelligent Engine (IBIE) data warehouse. Performed the role of Subject Matter Expert on Client, Deal and Account related data, inbound/outbound services, and business requirements. Developed process and artifacts around ongoing business/data analysis efforts and established standard deliverables for all SMEs / Business Analysts / Data Analysts working for this group. Mentored other SMEs / Business Analysts / Data Analysts on the team
  • Provided advice and oversight in building Sales & Marketing teams for online retailers
  • Led engagements addressing business issues, such as channel partnerships, business performance & operations excellence, and eBusiness
  • Implemented web presence for US market, addressing consumer and commercial audiences
  • Track record of effectively marketing to multiple audiences (such as consumer and B-to-B for single/ multiple product or service)

Confidential, Atlanta, GA

Sr. Business Analyst / Data Architect

Responsibilities:

  • Developed Data Governance Strategy and Framework Documentation and led the Data Governance Policies Documentation and Data Standards Documentation efforts
  • Led team of professionals across various disciplines/ business units to assess current state of all billing applications in F&CS domain to 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’
  • Worked with systems engineers, IT, business units, management, clients driving requirement, to fully expand the UDM with attributes, relationships, and reference values as applicable. Developed Logical and Physical data models using ER Studio and implemented Hourly Unit Generation process (a Pilot project)
  • Identified current data source and system of records for all entity/data objects in the Unified data model. Developed documents such as, Standardized (Canonical) Document of Data Definitions, Business Process Definitions for gaps Documentation, and Data Object Matrix Documentation
  • Developed a 5-year Roadmap (UDM Implementation Plan) for F&CS (includes integration with all current billing and analytic applications in F&CS domain) based on risk analysis and identified tactical and strategic project initiatives
  • viewed 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 Documents, data model(s) and performed data gap analysis
  • Created/enhance data model to support the new requirement/feature
  • Profiled source data based on data extracts & system documents, and created Data Mapping for ETL
  • Reviewed initial data mapping with SMEs and validated, identified & closed any gaps

Confidential, New Jersey

Business Consultant

Responsibilities:

  • Led and co-led team of professionals across various disciplines to elicit requirements and prepare business requirement documents, analysis and design using in-house or suggested SDLC/PDLC process model like, Waterfall, AGILE - Scrum
  • Work with systems engineers, IT, business units, management, clients driving requirement, business analysis to bring simple solutions
  • Led Data Gap Analysis effort for Tokyo driven Credit Rating/Credit Exposure data warehouse project
  • Co-led the team for analysis and documentation of Detailed System Design document for the Credit Rating/Credit Exposure data warehouse project
  • Analyzed and identified enterprise level entities in order to implement MDM solutions for migrating master data from south American branches in to current data warehouse
  • 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 and 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

Confidential, New Jersey

Sr. Business Analyst / Data Analyst

Responsibilities:

  • As business requirement analyst, supported Dunn & Bradstreet in their effort to conduct user acceptance testing of their eComm Platform Release 1.0 and Release 2.0
  • Developed complete data dictionary of the “Asset Portfolio Management” effort under “Software Asset Management Consolidation” initiative for a major US bank (Wachovia Bank)
  • 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 (Merrill Lynch)
  • 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 (MetLife)
  • 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. (Citizen Bank) 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
  • 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 TEMPhas 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.
  • Defined business data elements and developed logical data model required to support business requirements & business rule for “Mass Affluent Platform”, a managed IRA application at a major US based multinational financial company (Citibank)
  • 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 (Merrill Lynch)
  • 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 for a new Data Excellence Service model to support a US-based multinational pharmaceutical company’s (J&J)

Confidential, New Jersey

Sr. Business Analyst/Project Manager

Responsibilities:

  • 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)
  • 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

Confidential, New Jersey

Sr. Business Analyst / Data Architect

Responsibilities:

  • 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
  • As a Data Modeler/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
  • 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
  • As a Sr. BA for Merrill Lynch, conducted business requirement gathering sessions, performed business analysis, facilitated JAD sessions among cross-functional groups, performed process modeling, 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)”

Confidential, New Jersey

Sr. Business Analyst / Project Manager

Responsibilities:

  • 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
  • Facilitated business user sessions on requirement analysis, data analysis, and data modeling sessions for the system development and wrote test plan, test scripts, and test specifications for the system testing
  • Developed several offline accounting reports and created online management reports
  • Conducted quality assurance testing of the “Lottery Application System” and certified several functionalities of the system
  • 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)”
  • Wrote business requirements documents, 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 Confidential of Technology, India

Hire Now