• Seasoned professional in implementing solutions that improve enterprise effectiveness. Possess current and legacy experience in business systems analysis, requirements definition and specification, system design, process modeling, and software development. Cross-functional, enterprise-wide workflow experience with broad experience in business applications.
• Extensive success in translating requirements and user expectations int concise directions and detailed functional and technical system specifications.
• Effective in liaison among developers, project managers, subject matter experts, vendors and business users.
• Solutions-oriented approach with diverse experience in developing critical design requirements and functional specifications for a broad range of business applications and IT solutions throughout all phases of the project life cycle SDLC .

Technical Skills

Business Proficiencies

Experience

Senior Business Systems Analyst Consultant

• Produced the high level design functional and non functional requirements, assumptions and collaborated with the functional teams development, architects, database, QA, service delivery, PM's in helping them implement the solution based on the high level design, use cases, and test plans.
• Lead requirements meetings with offshore and BAC in-house participants including some wh were remote and participated via teleconference advised project team on project scope and system impact.
• Collaborated in the gathering of business requirements BRD with the Stakeholders, SME's from inception t document approvals, collaborated in with key business users t analyze and scope out the business need.
• Participated as a lead analyst in the conversion and implementation from Documentum t I.B.M. FileNet Document Management System a Portal application this project entailed the scanning of documents at BAC for all supported divisions, routing the documents for indexing t the external vendors and ingestion of documents int Filenet database repository.
• I.B.M. FileNet Document Management Portal Conversion project
• Produced detailed functional design specifications, proof of concept POC and business requirements using UML flow, activity, sequence diagrams, process flows and workflow analysis. Developed prototype mockup screens for presentations t end-users, stakeholders and SME's for the functional design.
• Developed the current state as is and proposed solution t be as part of the functional design.
• Streamline business processes across impacted systems for the solution design.
• Primary liaison with architects, application developers and stakeholders.
• Developed use cases as part of the HLD's Functional Requirements , Traceability Matrix.
• Provided Architecture and technology framework for implementation and end t end solution for the stakeholders reporting requirements. Analyzed current reporting inventory, produced data mapping and gap analysis for the reporting schema database tables.
• Responsible for the review and feedback t management of the low level design document, business requirement, traceability matrix, test plans, test scripts and test results documents.
• Ability t meet timeliness and deliver quality design requirements documentation under very tight schedules.
• Produced XML/XSD schemas specifications t the development team as part of the high level design document.
• Supported QAT and UAT efforts, collaborated in reviewing and approving test plans and test objectives and testing activities t resolve any anomalies.

Data Analyst/Business Analyst Mortgage Services, Confidential

• The 1099 A/C Project entailed automation of manual processes based on current business rules flexibility t accommodate future rule changes for loans that are in Foreclosure, Short Sales and Deeds in Lieu for regulatory changes requiring 1099 A/C issued t the borrowers.
• The Payoff and Reinstatement PRS project entailed streamline manual processes, replacing the Legacy Reporting application DaVinci MS Access database and Special Reinstatement Database SRD enabling PRS Analysts t reconcile Payoff and Reinstatement loans more efficiently.
• Participated as a lead business systems analyst in projects t comply with the Department of Justice DOJ , Real Estate Settlement Procedures Act RESPA and the Internal Revenue Service IRS obligations for loans that are on bankruptcy status.
• Collaborated in JAD workshops with functional solution architects and subject matter experts t establish the technical vision, blue print design, analyze the reporting requirements that will be generated by the COGNOS UI portal as per KPI, define security access roles.
• Participated in JAD sessions with the technical teams, stakeholders, end users from the Finance, Accounting, Reporting and Mortgage teams, SME's t produce the High Level Design, Gap Analysis, Database Data Modeling and Data Dictionary.
• Produced data mining and data analysis comparison from EXCEL files for data comparison, data cleansing and integration.
• Suggested recommendations t senior level executives for the solutions design.
• Developed use cases, traceability matrix as part of the HLD High Level Design .
• Developed SQL database Queries t validate Data Dictionary, data mining and enhancements t the SSIS ETL process for data transformation and integrity.
• Coordinated functional QA tasks among several QA Analysts and supported UAT efforts.
• Assisted in the project planning, project scoping prioritize project tasks with PMO, Stakeholders and End users.

Environment: I.B.M. FileNet, Oracle DW, MS SQL Server, Web Logic, MS SQL Server database. ASP/.NET, JAVA, MS ACCESS, AS/400 iSeries , I.B.M. COGNOS, Microsoft BI tools, AGILE/SCRUM Methodology, Use Cases/UML, HP Quality Center QC , MS Office products, Clarity.

MGM Studios, Beverly Hills, CA, Jan/12/Mar/12

Entertainment Company

Lead Business Systems/Data Analyst Consultant

• Provided technical leadership in the conversion of the HP TRIM enterprise document and records management ORACLE database t GRM document management solution architecture t meet the needs of the business and the project scope.
• Liaison with end users from the Finance and Accounting groups, third party vendor for the requirements specifications.
• Produced technical requirements and blue print design that adheres t the Systems Development Life Cycle SDLC standards and procedures including: requirements, data mapping, business rules, data transformation.
• Documented data sources, data types, dependencies and process flows.
• Perform detailed data profiling and validated trends or patterns in complex data sets.
• Identified and managed the resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency and completeness.
• Lead the engineering of infrastructure software design for document-centric business processes that include document management version control, lifecycle management, and archival disposition , collaboration, business process management workflow and data archiving in collaboration with the technical team and the DBA.
• .Ensured project quality and on-time deliverables.
• Developed SQL Queries for data mining, resolve outstanding data issues.

Environment: ORACLE 9i, ORACLE ETL ODI tools, AGILE Methodology,TOAD.

Deutsche Telekom AG T-Mobile, Bellevue, WA, Apr/11-Dec/11

Telecommunications Industry

Senior Business Systems Analyst Consultant .

• Lead the business enterprise solution and design t implement the e-Commerce B2B Commissions Compensation Rate Plans for the Retail Channels t mitigate customer's churn, simplified crediting rules , improve the process of calculations for the commissions payouts and reduce issues with SOX Compliance.
• Partner and collaborated with leaders in Marketing, Sales Compensation, Accounting and Finance groups t gather and elicit business requirements, prioritized project tasks and deliverables, provided LOE's for the projects tasks throughout the SDLC phases.
• Collaborated in JAD workshops with functional solution architects and subject matter experts t establish the technical vision, functional requirements, blue print design and analyze tradeoffs between sustainable requirements, automation of manual processes, keeping the customer needs in mind.
• Proactively communicated and collaborated with stakeholders t analyze and document information needs and functional requirements delivering accurate and detailed artifacts such as Functional Specification Design, High Level System Design Documents, GAP analysis, database data mapping and Test Plans.
• Process data transformation, formatting and data cleansing using ETL SQL Server Integration Services from upstream SAMSON system activations, deactivations and reactivations transactions t feed int the Commission's system.
• Enhancements t the B2B Website Reporting dashboard and scorecards, incorporated screen mockups as part of the solution design and proof of concept POC for the Monthly and Quarterly commission's statements.
• Developed use cases as part of the Functional requirements, UML diagrams.
• Design and execute test scripts/test scenarios in partnership with the QA and UAT teams. Developed and executed SQL queries for data analysis and test results.

Environment: Web logic B2B/B2C , Web services: JAVA, ASP, J2EE, SQL Server .NET Framework,

MS SQL, C , AGILE Methodology, Microsoft SQL Server Data Tools SSDT /BI reporting tools.

Confidential

Mortgage Technology Services,

Senior Business Systems/Data Analyst Consultant .

• Lead the implementation and design of the WEB UI t the Treasury Portal for auto-decisioning of delinquent mortgage loans under the Treasury guidelines that qualify for the Home Affordable Modification Program HAMP and Principal Reduction Alternative PRA Program.
• This entailed a new Portal Treasury Dashboard t provide real-time snapshots of the loans level details Net Present Value NPV , the program types associated for each loan and loans with the NPV eligibility status.
• Designed Ad-Hoc reports t be generated from the Dashboard for the stakeholders t perform data analytics.
• .Systems analysis of the loan modification database and Portal application t produce the data mapping, gap analysis, business rules engine, architectural design for the Treasury UI as per Treasury guidelines.
• Produced detailed functional design specifications, proof of concept POC and business requirements using UML flow diagrams, process workflow analysis. Developed prototype mockup screens for presentations t end-users, stakeholders and SME's for the functional design.
• Developed the current state as is and proposed solution t be as part of the functional design.
• Primary liaison with architects, application developers and stakeholders.
• Developed test plans and test objectives for Quality assurance QA group.

Environment: iSeries AS/400, SOA-Portal: Web logic B2B , Web services: JAVA, ASP, J2EE, SQL

Server .NET Framework, AGILE Methodology, COGNOS BI tools, Clarity.

Confidential

Confidential

Business Systems Analyst Consultant .

• Elicited and documented business and system requirements from Sales, Marketing, Underwriting, Finance stakeholders t support systems enhancements for Monthly rollouts on a .NET/JAVA Web software platform.
• Supported the CRM application .NET framework for the marketing campaigns for the Sales and marketing groups.
• Streamline business process across impacted systems, defined Function Design Documents FDDS based on the UML Methodology and detailed walkthroughs of the Technical Design Document TDDS t ensure all requirements have been met.
• Developed Use Cases data flow diagrams DFD , decomposition diagrams and context diagrams t capture the functional requirements for Production enhancements Monthly roll-outs. This entailed documentation of the current and future state of the business process.
• Conducted UAT with stakeholders and business users, produced and review test plans and objectives with Quality Assurance team members.

Environment: Web logic B2C , Web services: JAVA, ASP, J2EE, XML, HTML, MS SQL, .NET JIRA

Confidential

Confidential

Senior Business Systems Analyst Consultant .

• Conversion and implementation from Legacy Systems t a Web Portal e-Agent application for multi line of insurance line of products.
• Process data transformation, formatting and data cleansing using ETL SQL Server Integration Services.
• Gathered business and functional requirements t redesign the Agent GUI/Web Portal Consumer Servicing Application B2C JAVA/ASP application t provide better agents experience for servicing new and existing multi-line of business Auto, Home, Earthquake, Life, Financial policies, insured's policy payments cash, credit card, check transactions and streamline business functionality for the agent's Quote/Buy, Fair Isaac FIC scores screens and processes.
• This entailed the re-skin of the agent's application screens for Aut and Home t improve navigation for core screens with page optimization.
• Designed screen mockups, Wire Frames for Management and PM approvals.

Environment: SOA Architecture-Portal: Web logic, Web services B2C : JAVA, ASP, XML, HTML, J2EE, and SQL Server. I.B.M. Rational tools Use Cases, RequesitePro, I.B.M. FileNet Content Management , Remedy

Confidential

International SAP HR, FI and Benefits Lead Senior Conversion Business Analyst Consultant

• Lead the International business enterprise solutions for the MedImmune Netherlands and U.K. sites from Legacy Systems conversion and implementation int SAP R/3 HR, Benefits modules with Payroll data. This entailed gathering business requirements, scope analysis, streamline business process and departments workflows. Designed the architecture for the SAP outbound interfaces for their third vendor providers systems t achieve system integration.
• Systems analysis of the International sites HRMS and Payroll software applications t produce the data mapping, gap analysis, architectural design for data migration t SAP HR and outbound interfaces t other third party vendors systems. Executed ETL tools for data transformation, formatting and data cleansing using ETL SQL Server Integration Services.
• .Implemented the solution blueprint for the employee's lifecycles changes On-Boarding, paid and unpaid leave of absence data in conjunction with the user requirements, business rules and turning it int a detailed scope design.
• Attended business, security workshops in Netherlands and U.K. t define legal compliance for data sharing among European and U.S. sites and requirements' approval.

Environment: SAP R/3 XI, MS SQL Server, JAVA, ASP, HTML, XML.

Confidential