SUMMARY:

• Senior level IT technical BA and Scrum Master with extensive experience in data migration, integration, functional design, BI dashboards, and requirement gathering and eliciting. The ability to lead entire SDLC cycle. Detailed oriented without losing sight of a large picture. Strong leadership with focus on the solution delivery. Proven success in project deliverables coupled with exceptional communication and organization skills. Areas of skills include:

TECHNICAL SKILLS:

TECHNICAL: OBIEEEDW Salesforce Oracle ERP SQL Query MDM Tableau Database BPMGL/AP/AR FDD/FRDVisio

PROFESSIONAL EXPERIENCE:

Confidential, Durham, NC

Sr. Application System Analyst

Responsibilities:

• Provided FDD for new Vitals Smart Shopper Incentive Program financial Impact analysis and solutions
• Developed FRD, FDD for JCAPS remediation Relationship Extracts, ALIS Control, Credit Memo
• Participates architect solution design sessions and lead discussions on solution delivery
• Lead the Clear Stone BBrX program commissions extract including source to target mapping for income
• Manage Commissions rewrite project using AWS Cloud technology solutions scoping and migration analysis
• Developed FDD for Prime RX and Dental Blue vendor claims eligibility using Abinitio ETL tool to Facets

Confidential, RTP Raleigh, NC

Sr. Technical BA (CMDB, HPAM, DataOne, SSRS, Odyssey, ALM)

Responsibilities:

• Successfully designed and implemented IPTV and IMS logical and physical data models for CMDB POC
• Developed a JIRA process for CMDB project and manage the requirements solicitation and documentation
• Lead Migration analysis and planning for source data, interface, integration and functionalities from HPAM to D1.
• Manage stakeholders for across domains configuration and develop end state CMDB GUI design mock up specs
• Lead BA team to create new JIRA process and FRD template for the team.

Confidential, Raleigh, NC

Sr. IT Business Analyst

Responsibilities:

• Key driving force for rolling out over 500 project dashboards to over 2000 enterprise global users. The enterprise dashboards are used by PMs, DPDs across the globe daily. The BI dashboards provided a crucial bird eye view of project status summary with drill downs covering project life cycle from contract milestones to study startup, site recruitment, subject enrollment, subjects visit, SDV CRF forms to site close out.
• Performed source systems and data analysis for visual design and data requirement mapping. Delivered enterprise Project Management Dashboards cover multiple functions such as Projects, Milestones, Metrics, Clinical Opts, Risk, EPRR, Project Financials, Biometrics, and RBM. It is the key tool for bi weekly executive project reviews.
• Weekly presentations and demos to stakeholders for BI dashboards design approval and provide technical consultation and solutions. Developed detailed technical and functional visualization mock ups specs
• Support production remedy tickets with initial validations and identify the issues and provide solutions
• Prepare detailed UAT test scripts, and lead and coordinate UAT activities for all releases.
• Manage Agile thru TFS application for Epics, Business Requirements, Stories and Bugs during UAT
• Manage Bi Weekly User Focus meetings to elicit new features, and managed requirements throughout the life of the project, and OBIEE Dashboards and manage user expectations

Confidential, Durham, RTP NC

Project Manager & Sr. System Analyst

Responsibilities:

• Provided requirements, design and technical specs for Project Dashboard, FAM Dashboard, Maintenance and Previews
• Successfully rolled out Phase I &2 Project and FAM Dashboards; automated manual CIO Dashboard including user interactive maintenance functions and preview before monthly publish of project financials and status compliance
• Lead Architecture, QA and Production Support area deliverables, rollout Service Manager Report Dashboard, Sonar integrated data views and Defect Density Rate
• Manage daily scrum meetings, prepare bi - weekly PPMC status, and manage user expectations and milestones
• Prepare test scripts, lead SIT and UAT testing and sign off and manage defects and provided long term solutions
• Managed project scope, quality and schedule health, presented demos to CIO for Project Milestones
• Lead the ERC CR Review with user council, prepared 17 change requests BRDs and greatly speed up the process
• Successfully led the requirements review sessions during development with offshore developers from India and China

Confidential

Sr. BA

Responsibilities:

• Developed BAM Dashboard views and wrote BRD and FRD for BAM dashboard technical design and reports
• Created data model for Historical data mart to support client onboarding, account open audit and reporting
• Conducted detailed process flow review sessions with product stakeholders, and identified process gaps
• Enhanced process and sub process flows for triggering auto notifications, tracking operations task SLAs
• Led UAT testing for BAM Dashboard views and prepared test scripts and scenarios for end to end testing of multiple source system interface and identified and resolved several key data quality and reporting issues
• Provided solution and solved issues with KYC integration with Account Open and enabled successful launch

Confidential, NYC NY

IB Technical Sr. Business Analyst

Responsibilities:

• Managed SDLC cycle, reviewed and improved test scripts, conducted SIT testing and managed UAT sign off Developed SQL ad hoc queries for compliance and SLE license reporting by client and by exchange and SLEs
• Provided detailed design and data process flow for Morcom portal web pages and interface with multiple systems
• Wrote BRD and FRD for Clover integration with CSP for across LOB IB revenue coverage systems
• Successfully led 14 LOB Morcom SDLC implementation with complex process structure and data flow. Provided application support for post releases. Instrumental in providing quick and effective solutions for end users.
• Led IB Contact and Coverage Strategy sessions for end state architect across IB client life cycle
• Managed IBCRM major releases for CSP UAS and MORCOM impact including post test cases with participants from India, US and UK. Enabled successfully integration with no negative impacts
• Responsible for OTC Clearing FX Prime Brokerage conversion. Developed BRD,FRD and use cases for trader operating setup on ECN, Bloomberg, Reuters, MORCOM eXtraTrade, FIX, GLNET TT and OMS
• Managed UAS and UMT out of sync project, developed an exception handling process to remediate the data discrepancy issue between UMT and UAS critical for compliance data reporting
• Managed offshore developers for change requests, conducted development review sessions with Users, and QA teams
• SCOT and UAS integration analysis, server migration analysis, web tools and UAS synch up analysis
• Provided solutions for Safex exchange onboarding key issues prevented trading delays and reporting gaps Documented NCM Trader Key, XTLM Limit manager request workflow projects. Designed UI pages and data flow
• Led SLE migration for Euronext launch to support existing and new traders setup during the resource crisis, minimized the loss of revenue. Standardized migration process to avoid future delays for Exchange merger situation

Confidential -Hopewell NJ

Project Manager/System analyst

Responsibilities:

• Lead BA for Compliance project of commercial clients AML KYC data consolidation sourcing from multiple systems
• Built out Integration data model for online features of client hub, set up data acquisition rules and overlapping rules
• Led overlap analysis for 6 rounds of extracts. Instrumental in sourcing strategy and design for complex relational mapping. Provided solutions for data issues such as null tax ids, null address, duplicate profiles.
• Prepared SRS, source to target for ML CCDB feeds to enterprise CCDB, enhancements, automated exception tracking, error handling and corrections process to Client Onboarding Portal tool.
• Provided guidance for Client On-boarding for handling foreign address, third party account roles solutions.
• Managed SFDC Auto Merge project involving HUB/PATH/SFDC integration. Developed HLD/LLD successfully managed development cycles for branch rollout to keep Client HUB and SFDC client data in sync. Instrumental in solving numerous issues during UI testing.
• Lead role in SRS development for full client migration for BAC investment clients, provided source to target mapping
• Developed Merrill plus card conversion HLD, impact analysis, developed internal account conversion strategy
• Prepared SRS for HUB to GDPP data extracts approach for IDL and delta both from master profile and channel level
• Developed SRS for identification of third party clients and accounts in Client HUB and filter strategy

Confidential, New York City, NY

VP-Technology, Project Manager& BA

Responsibilities:

• Data Steward for Enterprise Data Library (EDL) project; worked with CEO and other stakeholders to develop EDL/MDM architecture, process flow charts, and synchronization methods. Re-engineered business processes
• Gathered requirements from stakeholders and collected meta data from 5 major client payment transaction systems
• Led Cisco Data Mart development cycle used for Agent Dashboard and Daily Performance Reports. Created requirement document, data models, source to target mapping and test scripts
• Performed DW conceptual designs and modeling to conform meta data to EDL for integration from client files to NexGen System, provided complex source to target mappings
• Conducted vendor evaluations for MDM and BI reporting tools (Microsoft, SAP, Oracle, D&B, Informatica)
• Provided data mapping and modeling for payment transaction capture by client, Account and transaction type

Confidential, Jersey City, New Jersey

Project Manager/Sr. BA

Responsibilities:

• Led AML/KYC system conversions project and provided FRD and source to target mapping
• Mantas: Solved a critical issue for generating account relationship alerts during ingestion, by developing a correct and complex data mapping for trading transaction and clearing between transaction types and parties for wire transfers, EFTS, ACH, securities, checks and cash etc.
• Key BA for data warehouse conversion, and Clearing Conversion between TD Waterhouse and Ameritrade. Managed source to target mappings, process flow documentation and ETL refresh
• CRM integration with SalesForce for 120 branches, and provided source to target mapping, data mining, TD branch scorecard portal conversion, lead efforts for integration strategy and problem solving Provided complex mapping for Combined Analytics data mart, developed conceptual design for Master Universe in Business Object for daily financial and month-end performance reports
• Led EDW build for data, provided conceptual design and data modeling for security master, and holdings Documented data dictionaries, relationship diagrams, data process flows for both TDW and Ameritrade DW for SEC audit, such as security master, holdings, trade, account/client, bookkeeping, margin, account transfers
• Successfully mapped Enron trades regulatory feeds for 7 years of trading records between trades and accounts relationships, provided detailed ETL rules for compliance to support legal dispute
• Developed user case diagram for Web Broker Prime Services and documented ETL and delta file process and test scripts
• Project Manager role for several successful data integration projects during Clearing Conversion including: MMDA, MMF, Total Assets, Short Interest Revenue, Advisor Profitability, Calendar Month, Gap Analysis.
• Prepared test scripts, performed UAT test and data validations for data feeds, and EDW maintenance.
• Lead BA role in combined data warehouse for end state analysis, provided comparative analysis for two DW subject areas, hardware and software scalability and capabilities analysis, which led to the strategy for building new EDW

Confidential, Newark, NJ

Sr. Business Analyst

Responsibilities:

• Supported GL conversion (Smart Stream - Oracle) of all sets of books, account hierarchy, structures for GAAP and Stat
• Well versed in managing financial operations change control process version upgrades and database conversion
• Implemented Oracle Discoverer reports for International Life Insurance, Investments, created ad hoc and standard GL Account Inquiry, AP Distribution, T&E reports, and converted reporting structure from SM to Essbase cubes
• Responsible for STAT reporting strategy, and design. Developed functional specs for financial statements using Essbase. Prepared QA testing scripts, and performed QA testing during conversion.
• Created inherited hierarchies for STAT reporting structure, and managed charts of accounts for all color books using both Smart Stream mainframe, and Oracle tools.
• Managed development cycles for both BAU and projects, conversion phases, go live testing processes. Received three Vice President s for excellent performance and leadership skills.

Confidential, Murray Hill, NJ (Chemical) -Providence NJ

IT Project Manager

Responsibilities:

• Developed GMS database design and data modeling. Successfully launched the first GMS application that allows business development/global marketing teams to search, input and attach primary and secondary market data by location, by process and by company name; resulted in increasing project win-ratio by 45%.
• Served as technical advisor on capturing and articulating end user functionality query requirements
• Developed and documented functional specifications for three market sectors database design. Provided complex data mapping and process flows charts, and ad hoc query page design and navigations
• Led SDLC phases for the GMS database developments, managed stakeholder expectations and provided solutions for common attributes across 3 market sectors without losing sights of individual market sector data elements