PROFESSIONAL SUMMARY:

• Business and technical experience in implementing solutions that improve enterprise effectiveness, streamline business processes and process workflows.
• Solution oriented approach with diverse experience in business systems analysis, requirements definition and specification, system design, process modeling, and software development.
• Collaborated with Stakeholders, End users, SME, Third Party vendors to analyze and document information needs and functional requirements delivering accurate and detailed artifacts such as Business Requirements BRD , Functional Specification Design, Process Workflows, High Level System Design Documents, Proof of Concept POC , Blue Print Design, GAP analysis, Database Data mapping and Test Plans for a broad range of business applications and IT solutions throughout all phases of the project life cycle SDLC .
• Cross-functional, enterprise-wide workflow experience with broad experience in business applications.
• Experienced with multiple project approaches including Waterfall, Agile-Scrum, JAD, RAD, Spiral methodologies.
• SDLC Methodologies: UML diagrams Activity, Sequence, Context, Sequence, Class, Use Cases, Swim lanes , Rational tools RUP- Use Cases, Clear Quest, Clear Case .
• Experienced with e-Commerce B2C/B2B Portals, SAP HR/FI, CRM-Siebel, DMS IBM Filenet Web Portal, .NET Framework, ERP DayBreak , and COGEN Property and Casualty Insurance .
• Experienced developing prototype mockup screens for presentations to end-users, stakeholders and SME's for the functional design.
• Business and technical experience in conversions and implementation from legacy systems to client server software applications.
• Experienced in the Software Development Life Cycle process SDLC , from Gap Analysis, to Requirements Gathering, Design, Testing, Implementation, and Maintenance.
• Primary liaison with end user, stakeholders, third party vendors, software architects, SME's, Quality Assurance and development teams on site and offshore on .Net, Web B2C/B2B , ERP, and CRM platforms.
• Participated in Black and White Box testing as part of the Quality Assurance team, performed UT, UAT, Regression, and Integration testing. Developed test cases and test objectives.

• Prior experience as a Software developer in Client Server applications RDBMS Oracle, T-SQL, DB2, MS ACCESS .

PROFESSIONAL EXPERIENCE:

Confidential

Business Analyst

• Confidential
• Liaised with end users from Credit Risk Management and IT DayBreak, TIBCO and BLAZE groups to document the consumer credit application current state as is from the Loan origination System LOS to the funding process for the retail, lease and balloon contracts.
• Identified and documented the current state process map and opportunities for improved efficiency of through automation or reduction of repetitive data entry, business rules and validation processes.
• Performed Impact analysis on the schema xml files produced by the outsourced vendor and transmitted to TIBCO Daybreak Staging database tables for data quality and system integration.
• Provided technical leadership to document a solution proposal for Optical Character Recognition OCR and Enterprise Content Management from the outsource service vendor provider that scans documents and then transmits them as individual loan packages to begin the classification and validation process for the contract application documents.
• Developed process flows, swim lanes and context diagrams to capture the business processes and workflow of impacted applications..

Environment: DealerTrack,DayBreak, TIBCO, BLAZE, VISIO

Senior Business Systems /SCRUM Master

• Participated as a Lead Systems Analyst in the conversion and implementation from Documentum to IBM FileNet Document Management System a Web portal application this project entailed scanning of documents at BAC for all supported divisions, routing documents for indexing to external vendors and ingestion of documents into FileNet database repository.
• Collaborated in gathering of business requirements BRD with stakeholders, SME's from inception to document approvals, collaborated in with key business users to analyze and scope out business need.
• Led requirements meetings with offshore and BAC in-house participants including some who were offshore and participated via teleconference.
• Participated in Scrum meetings with the Product Owners, Development Team as the Scrum Master. Ensured the user stories comply with the requirements criteria, have sufficient business value and selling points. Each story should show value to the Users, Customers, and Stakeholders.
• Collaborated in SCRUM workshops with the SCRUM teams to validate that the requirements are defined through an iterative process of planning, defining acceptance criteria, prioritizing, assigned LOE for each project task developing and then reviewing of results.
• Facilitated scrum ceremonies grooming, sprint planning, retrospectives, daily stand-ups, review sprint backlog, updated burndown chart at the end of each iteration .
• Instructed and modeled core Agile principles of collaboration, prioritization, team accountability and visibility ensured consistent application of scrum methodologies across the enterprise.
• Designed a Web UI for the stakeholders to manually route the loan batches for processing to BAC or external vendors allocating batch priorities as per BAC Taxonomy.
• Produced high level design functional and non-functional requirements, assumptions and collaborated with functional teams development, Architects, database, QA, service delivery and PM's in helping them implement solution based on high level design, use cases and test plans.
• Produced detailed functional design specifications, Proof of Concept POC and business requirements developed UML flow, activity, sequence diagrams, class, use case, process flows and workflow diagrams using VISIO.
• Developed prototype mockup screens for presentations to end-users, stakeholders and SME's for functional design.
• Elicited new reporting requirements, incorporated reports design as part of the Functional requirements, Use cases, developed test plans and objectives.
• Produced data dictionary mappings for the inventory of reports to be generated via COGNOS. Extensive Excel work using pivot tables and complex formulas to manipulate large data structures
• Developed current state as is process map and proposed solution to be process models as part of the functional design.
• Worked as a primary liaison with Architects, Application Developers and stakeholders.
• Developed use cases as part of HLD's functional requirements and Traceability Matrix.
• Incorporated XML/XSD schemas specifications 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 to resolve any anomalies.

Confidential

• Participated as a Lead Business Systems Analyst in projects to comply with Department of Justice DOJ , Real Estate Settlement Procedures Act RESPA and Internal Revenue Service IRS obligations for loans that are on bankruptcy status.
• Collaborated in JAD workshops with Functional Solution Architects and Subject Matter Experts to establish technical vision, blue print design, analyzed reporting requirements that will be generated by the COGNOS UI portal as per KPI, define security access roles.
• Participated in JAD sessions with technical teams, stakeholders and end users from Finance, Accounting, Reporting and Mortgage teams, SME's to produce high level design, gap analysis, database data modeling and data dictionary.
• Performed data cleansing and analysis, using pivot tables, formulas v-lookup and others , data validation, conditional formatting, and graph and chart manipulation.
• Wrote and executed SQL Queries to extract database data and created ad-hoc MS Excel including Pivot tables, Vlookup and Macros for data analysis.
• Authored SQL queries and VBA macros to perform rate calculations for data validation.
• Developed use cases and traceability matrix as part of HLD High Level Design .
• Developed SQL database Queries to validate Data Dictionary, data mining and enhancements to SSIS ETL process for data transformation and integrity.
• Coordinated functional QA tasks among several QA Analysts and supported UAT efforts.
• Assisted in project planning and project scoping.
• Prioritized project tasks with PMO, stakeholders and end users.

Environment: IBM FileNet, Oracle DW, MS SQL Server, MS SQL Server, ASP/.NET, Java, MS Access, AS/400 iSeries , IBM Cognos, Microsoft BI Tools, Agile/Scrum User Stories Methodology, Use Cases/UML, HP Quality Center QC , MS Office Products and Clarity.

Business Systems/Data Analyst

• Provided technical leadership in the conversion of HP TRIM enterprise document and records management Oracle database to GRM document management solution architecture to meet needs of business and project scope.
• Liaised with end users from Finance and Accounting groups, third party vendor for requirements specifications.
• Produced technical requirements and blue print design that adheres to Systems Development Life Cycle SDLC standards and procedures including: requirements, data mapping, and business rules and data transformation.
• Performed detailed data profiling and validated trends or patterns in complex data sets, reports using Excel including Pivot tables, Vlookup, VBA macros .
• Identified and managed resolution of data quality issues, such as uniqueness, integrity, accuracy, consistency and completeness.
• Led 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 technical team and DBA.
• Ensured project quality and on-time deliverables.
• Developed SQL Queries for data mining and resolved outstanding data issues.

Environment: Oracle 9i, Oracle ETL ODI tools, Agile Methodology and Toad, VISIO, SNAGIT

Senior Business Systems/Data Analyst

• Led business enterprise solution and design to implement e-Commerce B2B Commissions Compensation Rate Plans for Retail Channels to mitigate customer's churn, simplified crediting rules, improve process of calculations for commission's payouts and reduce issues with SOX Compliance.
• Partnered and collaborated with leaders in marketing, sales compensation, accounting and finance groups to gather and elicit business requirements, prioritized project tasks and deliverables and provided LOE's for projects tasks throughout SDLC phases.
• Collaborated in SCRUM workshops with the SCRUM teams to validate that the requirements are defined through an iterative process of planning, defining acceptance criteria, prioritizing, developing and then reviewing of results.
• Communicated and collaborated with stakeholders to 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.
• Processed data transformation, formatting and data cleansing using ETL SQL Server Integration Services from upstream SAMSON system activations, deactivations and reactivations transactions to feed into Commission's System.
• Enhanced the B2B website reporting dashboard and scorecards, incorporated screen mockups as part of solution design and Proof of Concept POC for monthly and quarterly commission's statements.
• Liaised with in-house and offshore development teams to review solution and technical design.
• Designed and executed test scripts/test scenarios in partnership with QA and UAT teams.
• Developed and executed SQL Queries for data analysis and test results.
• Executed SQL Queries from Access DB and exported results to spreadsheets for data analysis.

Environment: WebLogic B2B/B2C , Web Services: Java, ASP, J2EE, SQL Server .NET Framework, MS SQL and Agile Methodology, ACCESS DB

Senior Business Systems/Data Analyst

• Led implementation and design of Web UI to Treasury Portal for auto-decisioning of delinquent mortgage loans under Treasury guidelines that qualify for Home Affordable Modification Program HAMP and Principal Reduction Alternative PRA Program. This entailed a new Portal Treasury Dashboard to provide real-time snapshots of the loans level details Net Present Value NPV , the program types associated for each loan and loans with NPV eligibility status.
• Developed exception reports using Excel VBA macros from Daily database extracts for data analysis.
• Designed adhoc reports to be generated from dashboard for stakeholders to perform data analytics.
• Involved in systems analysis of loan modification database and portal application to produce data mapping, gap analysis, business rules engine and architectural design for Treasury UI as per Treasury guidelines.
• Developed prototype mockup screens for presentations to end-users, stakeholders and SME's for functional design.
• Developed current state as is and proposed solution to be as part of functional design.
• Worked as a primary liaison with Architects, Application Developers and stakeholders.
• Developed SQL Queries to analyze data. Imported and exported data to Access DB to generate reports.
• Developed test plans and test objectives for Quality assurance QA group.
• Liaised with in-house and offshore technical teams to review functional design.

Environment: ACCESS DB, ISeries AS/400, SOA-Portal: WebLogic B2B , Web Services: Java, ASP, J2EE, SQL Server .NET Framework, Agile Methodology, Cognos BI Tools and Clarity

Senior Business Systems Analyst

• stakeholders to support systems enhancements for monthly rollouts on a .NET/Java Web software platform.
• Streamlined business process across impacted systems, defined Function Design Documents FDDS based on UML diagrams using VISIO and detailed walkthroughs of Technical Design Document TDDS to ensure all requirements have been met.
• Developed use cases Data Flow Diagrams DFD , decomposition diagrams and context diagrams to capture functional requirements for production enhancements monthly roll-outs. This entailed documentation of current and future state of business process.
• Created sales reports using pivot tables/charts, Excel VBA calculations for sales data analysis.
• Conducted UAT with stakeholders and business users, produced and reviewed test plans and objectives with Quality Assurance team members.

Environment: WebLogic B2C , Web Services: Java, ASP, J2EE, XML, HTML, MS SQL, .NET and JIRA

Business Systems Analyst

• Converted and implemented from Legacy Systems to a Web Portal e-Agent application for multiline of insurance products.
• Processed data transformation, formatting and data cleansing using ETL SQL Server Integration Services.
• Gathered business and functional requirements to redesign Agent GUI/Web Portal Consumer Servicing Application B2C Java/ASP application to 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 and check transactions and streamline business functionality for the agent's Quote/Buy, Fair Isaac FICO scores screens.
• Worked as a primary liaison with LOB, SME's and stakeholders for underwriting, product lines of business. This entailed re-skin of agent's application screens for auto and home to improve navigation for core screens with page optimization.

Environment: SOA Architecture-Portal: WebLogic, Web Services B2C : Java, ASP, XML, HTML, J2EE, SQL Server, IBM Rational Tools - Use Cases, RequisitePro, IBM FileNet Content Management and Remedy

Lead Senior Business Analyst

• Led international business enterprise solutions for MedImmune Netherlands and UK sites from legacy systems conversion and implementation into SAP R/3 HR and Benefits modules with Payroll data. This entailed gathering business requirements, scope analysis, streamline business process and departments workflows.
• Involved in systems analysis of international sites HRMS and Payroll software applications to produce data mapping, gap analysis and architectural design for data migration to SAP HR and outbound interfaces to other third party vendors systems.
• Implemented solution blueprint for employee's lifecycles changes on-boarding, paid and unpaid leave of absence data in conjunction with the user requirements, business rules and turning it into a detailed scope design.
• Attended business and security workshops in Netherlands and UK to define legal compliance for data sharing among European and US sites and requirements' approval.

Environment: SAP R/3 XI, MS SQL Server, Java, ASP

Business Systems Analyst

• Gathered and documented business and functional requirements from Payroll, Benefits, HR, Accounting, Sales, Marketing, Tax, Pension, Residuals end-users to streamline the printing of payroll and residual checks, non-negotiable check copies and invoices. Rendered and printed Crystal report PDF files on the new separate print server application. This .NET WEB/GUI printing solution, improved server performance and database I/O processing. The project entailed reviewing and documenting current workflow processes and future enhancements as well as database-stored procedures for data mapping with Crystal report files.
• Worked closely with the department managers and technical teams to ensure that the business and functional requirements were well defined and that the technical solutions met the business requirements.
• Developed UAT and regression test objectives using Use Case methodology for QA and Production Support groups. Participated in the Unit Testing and UAT in coordination with the Quality Assurance QA group.

Environment: MS SQL Server, .NET, Java, ASP

Business Systems Analyst

• Re-design of Secondary Marketing Systems by automating manual processes. This entailed analysis of current and envision workflow from loan origination to sell of package of loans to Investors throughout Capital Market.
• Developed Business Requirements Documents BRD and incorporated Use-Cases using Rational tools.
• Produced functional, business and technical requirements to report sale of pool of loans to Freddie Mac.
• Developed business, functional, technical requirements to calculate refunds from mortgage insurers MGIC/Radian for Investor Operations group for pool of loans, repurchases, payoffs, delinquent loans.

Environment: MS SQL Server, .NET, Java, ASP

Software Developer/Systems Analyst

• Business system analysis, design, gathered requirements from business users to write SRS systems requirement specification , functional detail design documents JAD sessions and do a detailed walkthrough of system detailed specifications with software developers and business users for the contractual development of database and COGEN Insurance Multi-line of business software customization.
• Researched, created database data models and assessed customer's COGEN Insurance FIRE, Client, Claims, Policy and AUTO Customer databases for Federal and State regulatory requirements encompassing end-users from multiple states.
• Conducted data validation, quality control procedures as part of a business process re-engineering, data mapping in an effort designed to convert and implement large volumes of data transformation into DB2 databases. Served as a project liaison among business users and software developers to ensure that the project met all functional specifications and proposed business requirements

Environment: DB2, COBOL

Software Developer/Systems Analyst Consultant

• Implementation of a Credit Financial Software package DayBreak under Oracle 8i/ WebSphere AIX UNIX server platform and with interface through the Firewall to Fax Servers to outside vendors Credit Bureaus, AT T , modified interfaces to the Legacy system environment DB2, Cobol. CICS , Performed primary support for the Dealer Database System Oracle 8i , supported and maintained Web/Fax/Server credit applications, installation of any vendor patches, primary liaison among IS departments to gather additional functional requirements business rules from Business Users to load/transform data into the multiple Oracle database instances, and performed 24/7 application support.
• Involved in the Oracle database Schema analysis, configuration of entities, attributes, key relationships to develop Crystal reporting repository system Oracle Materialized View for the Credit Risk and Marketing groups, developed all PL/SQL queries, customization of Crystal Ad-Hoc enterprise reporting solutions.
• Worked on Siebel CRM Client Server implementation/upgrading from Siebel 7.0 to 7.5 and Call-Center Collection , Dialer CTI, Avaya system conversion writing Unix /Oracle scripts, initial functional requirement analysis from different groups and Cobol downstream Cobol Legacy System interfaces to extract from Shaw Loans /Lease master databases.

Environment: MS SQL Server, .Oracle Pl/SQL/ Unix Shell Scripting, JAVA, COBOL, CICS.

Software Developer/Systems Analyst

• Lead a conversion and upgrade of the FIG Financial billing balancing subsystem to allow an interface with G/L for Homeowners Fire, Client, Policy and Earthquake Policies , Auto, Cash, Billing, Claims, and Accounts Payable/Receivable subsystems for the Accounting department. The data was extracted from COGEN Insurance Multi-line of business Software Package, DB2 base tables and fed into the new subsystem. This project entailed design of several new Online/Batch interfaces to the legacy Billing subsystems. I performed extensive User, Vendor, GAP analysis of major system enhancements and gathered requirements to do detailed design documents and technical specifications with business users and technical team.
• Designed and supported database Ad-Hoc SQL queries for end users for balancing reporting procedures, UAT, functional and regression testing plans in coordination with QA group.

Environment: DB2, COBOL

TECHNICAL SKILLS: