SUMMARY

• A Business Analyst with 12 years’ experience with an understanding of BusinessRequirements, Case Tools andDataAnalysis.
• Expertise in conducting requirement gathering sessions, feasibility studies and Impact Analysis, Cost/Benefit analysis and Risk analysis, base lining acceptance criteria.
• Perform high - quality, accurate reporting/dataanalysesfor various stakeholders in all business lines.
• Strong subject matter expertise in Credit Card Industry, Mortgage Loan Origination, Servicing and Default, Defined-contribution plans, Retail/Investment Banking, Risk Analysis.
• Good understanding of Cash management, Capital market, STP and Credit risk fundamentals with hands on experience.
• Experience in data integration and data quality projects
• Extensive experience in the development, implementation, deployment and integration strategies within a team-oriented environment, utilizing quantitative and qualitative analytical skills.
• Excellent communication and presentation skills. Experience working with business users as well as IT professionals.
• Adept at creating, editing, and coordinating extensive communication networks (facilitation of joint application design (JAD) sessions and interviews, written correspondence, reports
• Implementation requirements, project status reports, oral presentations and email), to keep executive staff and team members apprised of goals, project status, and resolving issues and conflicts.
• Experience with working in Agile teams.

TECHNICAL SKILLS

Languages: C, C++, JavaScript, SQL, HTML

Databases: Oracle, MS SQL Server, DB2, MS Access

Tools: MS Office (Word, Excel, Project etc.), Visio, FileNet, Adobe Acrobat Suite, Crystal Reports, Informatica, SSIS, SAS, Business Objects, BMC Remedy, VersionOne, JIRA

Quality Management: Quality Center, WinRunner, LoadRunner

CRM: CDC Touchpoint, Salesforce

PROFESSIONAL EXPERIENCE

Confidential - Secaucus, NJ

Senior Business Analyst/Data Analyst

Responsibilities:

• Performed remediation between multiple systems and created mapping documents, functional requirements for SAP ECC to SAP/S4 upgrade and other enhancements.
• Responsible for ensuring that all interfaces to and from the Store Inventory, Retail Backorder, and Tools of the Trade applications were prepared for the SAP/S4 upgrade.
• Responsible for ensuring that reports out of sunsetted applications Focus and CDW would be covered by other systems.
• Researched functionality and reached out to multiple application owners and created current to future report mapping documents.
• Elicited, critically evaluated, documented, and identified missing business requirements.
• Conducted interviews with key business users and SMEs to collect requirement and business process information.
• Worked closely with the team to define acceptance criteria and assisted with testing.
• Reported defects and worked with the team to resolve them.
• Created and updated data models.

Environment: MS SQL Server, Oracle, SAP/S4, Business Objects, Data Warehouse, VBA, Rational ALM, JIRA, Egnyte, POS systems

Confidential - New York, NY

Senior Business Analyst/Data Analyst

Responsibilities:

• As part of the Scoring for Simplify project, assisted in merging multiple applications used for rating governments, banks, insurance companies, and corporations into a unified interface.
• Used SQL queries to compare data between multiple source systems which used SQL Server and Oracle databases.
• Created mapping documents for integration of Insurance Scoring Tool database into the Simplify application database.
• Created ER diagrams and data dictionaries for source and Target systems.
• Worked with different teams to ensure standardization of data formats and global mnemonics to be used by multiple rating models.
• Researched the model specifications and rating criteria documentation to ensure functionality will be maintained.
• Researchedand analyzedlegacy dataand performeddata quality checks ensure that data standards requirements are met.
• Documented upstream and downstream data sources to ensure preservation of functionality post-migration.
• Identifiedpotential duplicate recordsor missing fieldsby comparing record attributes andmodel specificationdocuments.
• Leveragedspreadsheets and internal data migration tools to provide reports.

Environment: MS SQL Server, DB2, Oracle, Javascript, VBA, HP Quality Center, VersionOne

Confidential - Owings Mills, MD

Senior Business Analyst/Data Analyst

Responsibilities:

• Supported Institutional website to add features and increase compatibility with mobile devices.
• Gathered requirements for migration of attribution data for Equities, Funds, Bonds, and Derivatives to MIDR data repository.
• Participated in project with Enterprise Publishing to extract and consolidate project metrics from five disparate workflow solutions.
• Provided support to Assets Under Management (AUM) data warehouse by handling data issue tickets.
• Used SQL, Informatica and Business Objects to support the data warehouse and CFO data mart by modifying reports, correcting bad source data and resolving user issues.
• Worked on migration of CRM software across multiple business units to Salesforce.
• Assisted in testing of process changes due to ERISA 408(b)(2) and 404(a) regulations.
• Communicated extensively with the clients and with different levels of management to identify requirements, use cases and to develop functional specifications.
• Played a key role in the planning, testing, and implementation of system enhancements and conversions.
• Assisted in presenting reports and analysis to help guide management.
• Analyzed operational procedures, methods, and recommend changes for improvement, with an emphasis on automation and efficiency.
• Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were met
• Worked with business teams and developers to document requirements, plan enhancements, test, and deploy code.
• Wrote specifications for custom sales dashboards, created wireframe prototypes.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER (Entity Relationship Diagrams) in MS Visio.
• Interacted with the Legal department to ensure FINRA approval for changes made within the web portal.
• Implemented advanced charting and iOS/Android compatibility for the Fund Data Portal.
• Migrated data source for the portal from Wilshire to the MIDR data repository.
• Worked on creation and testing of Brandworks Mobile website for featurephones and smartphones.

Environment: MS SQL Server, DB2, Oracle, Informatica, Business Objects, Data Warehouse, MS Access, SSIS, HTML, Javascript, Tableau, HP Quality Center, CDC Touchpoint CRM, Salesforce

Confidential - Columbus, OH

Business Analyst/Data Analyst

Responsibilities:

• Provided production support for daily and hourly batch processes used for data transfer to and from the loan servicing system and the data warehouse.
• Strategized project scoping and specifications documents, to clearly communicate the project roadmap
• Met with all developers and project stakeholders and mapped out timelines, milestones, communication processes.
• Wrote SQL queries to analyze data in database tables to triage and resolve defects in various levels of testing efforts
• Analyzed functional specifications and data from various data sources like mainframe, oracle database and flat files.
• Authored Functional Specifications and communicated them to development and testing teams.
• Conducted Joint Application Development (JAD) sessions to develop and agree upon a system that focuses on the business requirements and refined it through interviews, Story Board Sessions, Use Case Diagrams.
• Handled regular deployment issues across Dev, Prod and Test environments.
• Assisted the QA team in reviewing test cases, test plans and tested the final application for usability testing to verify whether all the user requirements were met.
• Assisted Test Lead, Testers understanding business process and help them successful completion of Unit Testing, Integration Testing and Requirements Testing.
• Helped develop use cases and project plans and to manage project scope.

Environment: Oracle 9i, Oracle 10g, PL/SQL, HP Quality Center 9.2, PVCS, MS Visio, MS Project