Experience

• 

  Freddie Mac

  • Mclean,VA

  • Senior Systems Analyst

    • Oct 2018 - Present
    • Mclean,VA

    Senior Systems AnalystAs the conversion from legacy Mortgage Loan application (Sybase/XML) is developed, I am responsible for creating Service Request data mappings from MongoDB storing JSON format documents. Data mapping documents are then used by the development team to build requests to various services/applications including Credit Risk Assessment Service.Working closely with Business and Legacy system teams.Methodoly being used for Project development is Agile/Scrum using Version1.

• 

  Leidos

  • Baltimore MD

  • Sr.Systems Analyst

    • Jul 2017 - Mar 2018
    • Baltimore MD

    Leidos is a US government contractor company offering data warehouse reporting services for Call centers across the country. As a Senior Systems Analyst in a high performing Enterprise Data & Analytics team in a Data Warehouse environment in a high performing Reporting Data & Analytics team. After performing comprehensive systems analysis I converted Business requirements to System Design Specifications(SDS) and presented to the development team. I laisoned with development and QA testing teams through out the SDLC. The technology employed were;Oracle database QueriesETL ProcessMicrostrategy Reporting

• 

  Allegis Group

  • Business Systems Analyst

    • Nov 2015 - Jun 2017

    As a Business Systems Analyst in a high performing Enterprise Data & Analytics team in a Data Warehouse environment using Agile Scrum/Kanban techniquesI worked with the above mentioned OPCOs as a system liaison gathering and formulating their business requirements and providing with the optimized system solutions helping them achieve their strategic business goals. Provided solutions streamlined & automated daily/monthly manual processes. My responsibilities were;• Discussing and finalizing business requirements with the OPCOs.• Feasibility study and formulation of the business requirements into written ‘User Stories’ for the offshore development team and provided business requirements explanations to offshore development team.• Coordinated any required Data structure changes with onshore Oracle DBA and Database Modeling team • Worked with Informatica/ETL team for data transformation and mapping rules.• Worked with CIS , Data Analytics and Visualization team for data presentation layer.• Worked with onshore QA testing team• Worked with the business partners thru out UAT process to obtain signoffs.Worked as a Business Systems Analyst in an Agile environment. Data Warehouse data integration project to produce Service Desk Performance Metrics after consolidating Phone Call Interactions, Email, Problem Tickets resolution data from multiple platforms. Writing Requirement document (user Stories) and Use cases to develop and implement one platform Oracle Data Warehouse application. Establishing data transformation rules and designing data structures to support Service Desk Performance Measurements.

• 

  JPMorgan Chase

  • Tampa,FL

  • Business Systems Analyst

    • Jul 2013 - Jan 2014
    • Tampa,FL

    Business Systems Analyst responsible for;• Financial data analysis for Data warehousing. • Gap Analysis between legacy and new applications.• Writing Use case driven FRDs from high level BRDs for Prepaid Debit Card Processing covering legal aspects.• Reviewing Technical Design Documents with offshore development teams and QA Testing team. • Presenting and getting approvals from business stakeholders within the organization. Technology - Multi platform applications, Web Services,IVR,GUI, MQ, Oracle db, Tandem.

• 

  AON Hewitt

  • Orlando,Florida

  • Sr.Systems Analyst

    • Jun 2008 - Aug 2012
    • Orlando,Florida

    Sr. Systems Analyst for Defined Contributions System (401k). Worked on 12 implementations of the Defined Contributions (401k) system for various clients. Responsibilities included;• Client requirements Analysis• System entities Configuration• Functional Testing• QA Test Plans preparation & presentations• QA Test Plan execution using Echo tool (Automatic and manual)• Troubleshooting and resolving technology implementations/integrations issues as needed• Coaching other associates with DB2 SQL Queries

• 

  JP Morgan Chase

  • Tampa,Florida

  • Project Manager

    • Feb 2007 - Feb 2008
    • Tampa,Florida

    Contract PositionDevelopment and full implementation of a multi-tier IVR Payment Clearing system which would provide JPMC with Telephone payment clearance and PIN activation functionality for bank’s domestic and international customers. It will centralize and replace the current manual handling of customer calls by agents at multiple sites in the country.My responsibilities thru SDLC on this project were;• To interact and manage multiple cross-functional teams of applications and infrastructure• Managing the development of business (BRD)and technical requirements (FRD), system design, system development, testing, deployment, and support transition.• Preparing Project Plan(MS Project)• Coordinating Middleware infrastructure setup• Gap Analysis & Conflict Management• Problem Resolution• Tracking and managing 3rd party vendor’s development effort • Prepare QA Test Plans• QA/UAT testing• To manage full implementation of Citrix environments with all Solution Center business applications deployed and accessible from remote site• Coordinate Agents training in Tampa using centralised Citrix environment• PMO status reporting to higher management• The middleware tiers being built were;Integrated Voice Response (IVR)Genesys – Call routing intelligenceDesktop applicationsWeb Services interface (WSDL)SQL Server to store call dataMQ Series interface with core mainframe systemDaily Reports

• 

  Prudential Financial

  • Woodbridge,NJ

  • Business/Systems Analyst

    • Apr 2001 - Feb 2007
    • Woodbridge,NJ

    Contract PositionWorked as a Business/Systems Analyst on a major data conversion project to convert variable annuities contract data from acquired company Skandia’s Oracle database to Prudential’s Progress database. • Defining Conversion Methodology• Data requirement specifications• Develop Data Mapping document• Data analysis• Data conversion rules• Data Cleansing & quality checks• Planning and execution of full implementation• QA & UAT Testing• Post implementation data verification Compliance SystemsReport Analyst to evaluate business data requests from business community. Preparing data extract specifications from multiple platforms including Mainframe systems . Reports developed in Actuate E-Spreadsheet, MS Access, Rapid SQL, Lotus Notes database, and Excel to support a centralized unit to perform the supervisory reviews of the captive sales force. Designed and developed MS Access database warehouse for reporting purposes. Used Actuate 7 E-Spreadsheet for producing Daily, Weekly and Monthly reports for business unit.System enhancements included;• Automation of workload/workflow management within centralized unit team members. • Reduction of false positives to lower transaction volume handled by centralized unit.• Use of Business Intelligence to provide a summarized view of captive agents characteristicsData ConversionsWorked as a Lead Business /Systems Analyst to Integrate and re-engineer AS/400 Annuities system to Prudential’s Client Server/Web based system my responsibilities included;• Detailed data Analysis on legacy systems • Data Filtering & Cleaning (MS Access)• Data Transformation• System Integration & Re-engineering Process design• Gap Analysis• Producing technical specifications for conversion logic• Establishing data mapping rules• Developing reconciliation procedures and reports• UAT & QA Testing• Conversion Implementation• Verifying conversion results on the new platform using SQL queries.

• 

  Pinkerton Computer Consultants

  • New York,NY

  • Project manager

    • Jan 2000 - Jul 2001
    • New York,NY

    Contract PositionManaged 3 in-house projects for CITIGROUP and JOHN HANCOCKActivities involved:• Project Scoping & Planning• Project Management• Client liaison• System analysis & Design• Technical support • Reports development using Crystal Reports• Onsite implementation & support

• 

  Fidelity Investments

  • New York,NY

  • Project Manager

    • Apr 1997 - Jun 1999
    • New York,NY

    Contract PositionWorked with a team of 25 programmers on a Y2K project. This effort involved 10 to 15 core Securities Processing applications on the mainframe using COBOL, COBOL II, DB2, CICS and IMS. Various phases of this project involved:• Project Planning (MS-Project) • Securities Purchase & Sales, Trade settlement (DTC’s CNS reports) and Dividend systems remediation for Y2K compliance.• Unit and system integration testing• Regression testing • Implementation in production.• Change Control Management• Testing of the remediated applications • Lotus Notes• Assisted higher management with project planning and staffing issues.

• 

  Bankers Trust Of New York

  • Vice President

    • Jun 1995 - Apr 1997

    As the mainframe System Development Manager of a team of 15 programmer analysts, re-engineered legacy systems and developed and successfully implemented a major client-server 401K Plan Processing system. This three-tier system replaced a legacy system that had an IBM mainframe as the back-end server, a DEC alpha front-end server, and PC workstation with VRS clients. The mainframe part of the system involved DB2, CICS and COBOL II using a table driven architecture based on a product called SNAPPI. The middle tier used a Sybase SQL Server database. The client workstation application was written in C++. The new system provides Pension Plan processing services both on-line and via telephone. Services included Employer and Employee Contributions, Fund Transfers, Loan and Loan Repayments, Payouts (Cash Distributions), and Dividends.• System Design and presentations• DB2 Database Design• Responsible for project management, analysis, design, testing and implementation of internal projects• Maintain project plans • Developed release documentation• Work with Senior Management to determine levels of effort and project tasks

  • Programmer/Analyst

    • Jul 1992 - Jun 1995

    Contract PositionWorked on the Financial Data Conversion Project. This system was developed to compare and convert financial data from a mainframe trade dated system running at a subsidiary of BTNY in Scotland, to newly developed Multi-Currency Accounting and Reporting system (MARS) in New York. The following were the salient features of this system: • Converted data files from ICL to IBM acceptable formats. • Developed an automated Reconciliation process between two old systems, one being a settlement date based system and the other being a trade date based system. The data processed at month end for each account was Trade Dated Stock positions, Trade Dated Currency amounts, Cash/Stock Dividend amounts, Fixed Income accruals, and Tax Reclaim amounts. • Generated necessary accounting transactions to establish each account’s day one positions and releasing any subsequent activity to bring the positions up-to-date in the new system, MARS. • The system was developed using DB2, COBOL II, MF-COBOL, CICS, XDB.MS Access

• 

  Citibank

  • New York,NY

  • Programmer/Analyst

    • Oct 1988 - Jun 1992
    • New York,NY

    Contract PositionFunctioned as technical support and programmer analyst for the development of a major Securities Global Custody system. Responsibilities included the design, Training, development, implementation and documentation of a major portion of the system, namely Corporate Actions Processing system (Dividends Processing). This system was developed using FSA, a COBOL/CICS and data dictionary based development tool. Provided technical support throughout the SDLC of project and supervised the work of project team ranging from five to eight programmer analysts. Wrote JCL procedures at the implementation time. Worked on various enhancements to the same system.• COBOL Program development• Unit testing• Writing JCL procedures• System Integration Testing• Providing technical support to the team• Developed release documentation• System implementation

• 

  Pershing DLJ

  • New York,NY

  • Programmer/Analyst

    • Apr 1986 - Oct 1988
    • New York,NY

    Contract PositionWorked as programmer/Analyst on development of an on-line Mutual Funds Information Processing system allowing for fractional shares trading . This system replaced existing on-line Mutual Funds Processing system. Also worked on Securities Purchase & Sales and Settlement systems involving DTC and Clearing Houses interfaces. Environment: IBM 3083, COBOL, CICS, VSAM, ADABAS.• COBOL Program development• Unit testing• Writing JCL procedures• System Integration Testing• Developed release documentation• System Implementation

• 

  Rank Xerox UK

  • England UK

  • Programmer/Analyst

    • 1974 - 1986
    • England UK

    Prior to 1986 I worked in Europe on various assignments.