SUMMARY

• IT professional and Data analysis with over 16 years of experience working for Industries like Software Developing, Manufacturing, Pharmaceutical, Health Care, and Financial Institutions.
• My most recent role is Business System Consultant/Technical Analyst/Data Analytics, leading a team to gather Business Requirements (BRD), creating High Level Design and Functional specification design (FSD/FRD/FRS/SDD) to create Test Scripts for User Acceptance Testing (TDD), System Integration Testing, Software Quality Assurance Testing, and Unit Testing.
• Involved in pre and post production support also. In my most recent role I was with working with SQL databases and related tools (including data extraction, insert, update and delete functions), for data mapping, data validation, and creating functional specification designs.
• I also drove the SDLC of the enterprise - level SAP Financial conversion project. I am a US Citizen, local to Charlotte, and can interview and begin work immediately.

TECHNICAL SKILLS

Tools: Sequel Server Management Studios (SSMS), SQL Developer, TOAD, Hyperion Essbase, HP ALM/QC, EZREC (Data Governance), JIRA, IRIS, Essbase, LEO(Legal Entity Onboarding), ECDDC(Enhance Customer Due Diligence)

Reporting Tools: Tableau, Voyager/Yardi (Real Estate, Oil & Gas, Loan),Crystal Reports 9.0, SQR, Voyager Reports, Frx (Financial), FDW (Financial Data Warehouse), LEO Reporting Module

RDBMS: Sequel Server Management Studios, Hadoop (HBase) iHub, TERADATA, Oracle Toad and SQL Developer, DB2, MS Access

Methodology: Agile, Waterfall, V-model

ERP Tools: Voyager/Yardi, SAP eLedger/BI/FIG/GUI, Non-SAP (Multiple Testing Environments, MDM, eVDM, IXP-Autosys), Oracle 10.7/11i, 11i.5.1/11i.5.3, 12 (A/P, A/R. G/L, FA, iProcurement), PeopleSoft 6.0/7.0/7.5 8. x (Financial) and 9.2 (Recruiting Solution), MFG Pro 8.5 (Manufacturing), PFM (A/P, G/L), Portal J 9.x (Labor Entry, Contracts, A/P), FINMAN, Quartz

Operating Systems: Windows 95/98/2000/XP, Windows NT, Vista

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Business System Consultant/Data Analytics

Responsibilities:

• Voyager/Yardi system stabilization
• Data analysis and Reconciliation of financial data for Real Estate, Oil and Gas, and Loan
• Writing SQLs to extract data from Sequel Server Management Studios(SSMS)
• Gather data dictionary for data mapping and creating BRD and FSD for Business Requirements for stakeholders
• Using Visio and Excel to create workflows
• Training and Coordinate UAT testing
• Interfacing with Developers and QAs to assist in business requirements
• Using Power Point to managing and presenting the project to Stakeholders
• Writing change requests

Confidential, Charlotte, NC

Business System Analyst, Technical Analyst

Responsibilities:

• For AML(Anti Money Laundering), create and design High Level Design Documents based on BRD (Business Requirement Document) for applications LEO(Legal Entity Onboarding), ECDDC (Enhanced Customer Due Diligence Control), and multiple Downstream SORs(System of Records). Also, designed new report format for ECDDC to populate Ad-Hoc Reports for end users.
• Data analysis and reporting, Data lineage, mapping.
• Assessment and impact of integration(s) to Downstream Applications and Regulatory Reporting for GFCC (Global Financial Crimes Control), Regulatory Documents for Global Regions/Jurisdictions, including US, ASIA, APAC, EMEA, and Canada
• Q&A sessions with Business Partners and Development before HLD(High Level Design
• Validations and update of Regulatory Rules for Stakeholder’s partial and full exemptions and send to business for approval
• Executing SQL scripts in Toad to validate the data for High Risk Client Types, including TPPP(Third Party Payment Processing), MSB(Money Service Bank), Casino, and Charity to capture the data based on Rules and Entitlements established by GFCC
• Validation of Unique GCIs(Global Customer Identifier) vs. Account services for cross references (PAX Database - Party to Account Cross Reference) and reports from LYNX for any Breaks
• Interfacing with Business Partners and Development Teams to facilitate the process in deploying the updates/changes/modifications for monthly releases
• Testing in Dev, UAT, SIT, SQA(Software Quality Assurance) and support post release for Production
• Methodology was Agile
• Efficiently manage time for timely project deadlines as well as ad hoc requests for Tableau
• For Tableau, work on all aspects of the engineering of the service, including such topics as performance, testing, HA, dashboard design & tuning
• Quickly and effectively diagnose and respond to service desk requests regarding data integrity and functional or interactive issues in existing and future dashboards of Tableau
• Develop Tableau dashboards and visualizations that empower decision makers
• Perform peer review of code and testing in order to detect and minimize application problems

Confidential, Charlotte, NC

Senior Business/Data Analyst

Responsibilities:

• Executed SQL scripts for OLMD Mapping SOR data vs. iHub, according to Business and Customer Due Diligence Requirements for the lower environments’ based on Industry Standards (FSDF) functional specification designs financial
• Interacted with Clients, Business users, and SME’s to prepare Business and Customer Due Diligence Requirements
• Involved to drive work efforts with Risk and Compliance business and technology partners to identify specific data elements used by Risk and Compliance processes and to implement Enterprise Data Governance
• Acquired data dictionaries for multiple SOR (System of Records) to create sourcing templates for SOR data in Hadoop lake and perform the validation for the project information HUB (iHub) for lower environments
• Apache Hive experience for SQL on Hadoop against MapR Database or HBase
• Utilized Apache Drill and HUE for SQL
• SQL Developer and SQL Assistant for Teradata were utilized for Data gathering and validation for data mapping
• Processed notes for joins and filter conditions to facilitate the Developers
• Traceability Matrix was created to trace the timely progress of the project
• Created test and defects in JIRA
• Data analysis and reporting, Data lineage, mapping.

Confidential, Charlotte, NC

Product Manager

Responsibilities:

• Supported the full project lifecycle to build a common platform for intercompany loans (Quartz) for Merrill Lynch FINMAN ledger and Confidential Corporate Data Warehouse (CIDW), Oracle, and SAP eLedger
• Gathered business requirements from business partners across three regions (U.S., Australia, Europe) and created BRDs and Functional Specification Design (FSD)
• Performed UAT and provided training/support across above regions
• Involved to drive work efforts with Risk and Compliance business and technology partners to identify specific data elements used by Risk and Compliance processes and to implement Enterprise Data Governance
• Hands-on in data mapping, data migration, pre and post data analysis of Merrill Lynch FINMAN ledger to SAP eLedger and Oracle
• Performed validation of data from Quartz (Intercompany Loan System) to FINMAN, Oracle, CIDW, and SAP eLedger
• Prepared standard operation procedures
• Used FDW, TOAD, and SAP (Standard and EPM) reports for data validation, sign-off books, and monthly reconciliation of multiple books
• Created, uploaded, and posted Journals in Oracle for US based Legal Entities
• Data analysis and reporting, Data lineage, mapping.

Confidential, Charlotte, NC

Business System Analyst, Technical Analyst

Responsibilities:

• PeopleSoft (HCM) Recruiting Solution: Acted as a liaison between client area and technical organization by planning, conducting, and directing the analysis of complex business problems to be solved with automated systems
• Gathered requirements from business users
• Created BRD, Business Planning Document, Functional Specification Design (FSD)
• Provided technical assistance in identifying, evaluating, and developing systems and procedures that were cost effective and met business requirements
• Wrote SQL to validate the data from Mainframe, data extraction, validation, and data management
• Prepared Test Scenarios and Test Scripts for QA testing
• Performed System Integration and UAT testing, and issued defects in ALM
• Worked with user groups to provide training, resolve questions, assess user needs, and recommend changes
• Data analysis and reporting, Data lineage, mapping.

Confidential, Charlotte, NC

PM, IT Business Analyst, QA Testing

Responsibilities:

• Member of the Global Finance System Roadmap Team (Agile methodology)
• As a Business Analyst, drove the SDLC of the enterprise-level SAP Financial conversion from legacy General Ledger (GL) Systems in 3 Phases (Canada/Mexico, Merrill Lynch, and all of the U.S.), including Non-SAP environments MDM, and eVDM
• Gathered requirements and elicited business elements from business partners, created BRD, and worked with the development team to determine technical specifications, including complex logic and data flows
• Performed data management (analysis, lineage, quality), data mapping and conversion of disparate legacy GL Systems including Oracle 11i to SAP (eLedger)
• Wrote SQL queries to extract large volumes of data, and performed reconciliation between source GL and targeted SAP ledger
• Performed System Integration and UAT Testing of Functional Test Design, wrote and executed Test Scripts, and raised defects between two General Ledger systems using HP Quality Center
• Coordinated Test Planning meetings to execute WBS for Testing Cycles and System Integration, interfacing with Development, Triage for problems/issues and reporting to Executives
• As a Project Manager, managed the enhancement and maintenance of the new SAP system
• Facilitated status meetings, created project plans, prioritized and tracked deliverables through completion, mitigated risk issues, and reported project status to senior management and c-level executives
• Monitored and resolve testing issues and validated production issues
• Documented detailed results and reported to management
• Analyzed actual variances in data through SAP utilizing tools including Business Intelligence (BI) and Financial Interface Gateway (FIG) in a test and production environment
• Identified root-cause for variances and post Journal Entries
• Ran trial balances in Oracle to determine correct values for SAP BI comparison
• Data analysis and reporting, Data lineage, mapping.