SUMMARY

• An experienced professional with over fifteen years experience specializing in the financial services industry, with a dual emphasis on business management and information technology.
• Strong SQL experience in SSAS and SSIS.
• Diverse experience includes project successes in the areas of project management, vendor software implementation, business technology, quality assurance associated with ERP systems.
• Results oriented personable, effective, technical, well - rounded individual who can identify business requirements and processes, provide leadership and fill technical roles on both small and large projects.

PROFESSIONAL EXPERIENCE

Confidential

Project Manager/Business Analyst

Responsibilities:

• Used the five V’s of Big Data to insure data integrity: Velocity, volume, value, variety, and veracity.
• Documented business and functional requirements in a clear and concise manner.
• Performed data aping and transformation of data between business systems.
• Insured data was accurate between systems by creating and generating reports for the line of business to review.
• Used Agile process to implement projects.

Confidential

Senior Systems Analyst

Responsibilities:

• Conducted user interviews to collect business and functional requirements.
• Analyzed business and user needs and translated them into proper system requirement specifications.
• Documented business, functional and system requirements in a clear and concise manner that provided clear definition of application functionality.
• Formulated and defined system scope and objectives based on: user needs, how the request impacts other systems and business processes, industry requirements, business goals, objectives and risk factor the organization is facing (current and projected).
• Performed data mapping and transformation specifications.
• QA testing - wrote and executed thorough test plans.
• Provided end user training and created training materials.
• Created release notes when applicable.
• Coordinated UA Testing - Documented test user scripts to ensure requirements effectively developed and signed off prior to deployment.
• Created stored procedures in MS SQL Server and Dell Toad for regulation reports.
• ETL (Extract, Transform, and Load) - used Toad to import the loan data in different file formats from Excel to HTML files. Created the stored procedures to import the massaged data into our data systems.
• Used Jira software to track project issues and Agile process.

Confidential

Senior Business Analyst

Responsibilities:

• Review and analyze the effectiveness and efficiency of existing systems. Develop strategies for improving or further leveraging systems.
• Prepare and deliver reports, recommendations, and/or alternatives that address existing and potential problem areas.
• Communicate ideas to both technical and user-friendly language to both developers and to the business.
• Coordinate and prepare in-depth tests, including end-user reviews, for modified and new systems.
• Collaborates in the planning, design, development, and deployment of new applications and enhancements to existing applications.

Confidential

Senior Business Analyst

Responsibilities:

• Work with Confidential experience in SQL Server Reporting Services (SSRS) and Integration services (SSIS) (Server Reporting Services and SSIS (Integration services)
• Perform advanced report development utilizing SQL Server Reporting Services Create advanced report development utilizing SSRS (SQL Server Reporting Services). responsible for the collection, analysis and communication of data and associated functional requirements and producing the reporting needs of the client. Responsible for the collection, analysis and communication of data and associated functional requirements and producing the reporting needs for the REO department.
• Work with Business Objects to create new reports and manage any existing reports.
• Work with SQL Server 2000, SQL Server 2005, and SQL Server 2008. Proficient in SQL query writing.
• Advanced user with MS Excel. Use pivot tables and charts when creating reports for the user groups.
• Managed a software upgrade from REO Trans to Equator in 2008. Worked with the vendor to provide a smooth transition from the REO Trans to Equator.
• Supply the vendor with project requirements for any new and existing project requests. Work with the vendor on creating accurate test cases.
• Maintain data accuracy and integrity for the data warehouse.
• Query and analyze the data to recognize and isolate data trends, issues, opportunities and concepts.
• Meet with the stakeholders to collect requirements, objectives for data analysis, business rules for data transformation, and report definitions.
• Use Microsoft Excel 2010 to import and export data.
• Maintain over 200 daily, weekly, and monthly reports. Distribute the reports the user groups.
• Create and maintain the daily data and monthly data.
• Ensure all processes are documented and up to date.
• Ability to translate business requirements into technical requirements.
• Create and maintain reports in Microsoft Visual Studio in both 2005 and 2008 versions.
• Experience writing complex reports such as scorecards and dashboards.

Confidential

Senior Business Analyst

Responsibilities:

• Create advanced report development utilizing SSRS.
• Responsible for the collection and documentation of the business requirements, and adherence to the requirements throughout the SDLC.
• Work with project manager and other IT professionals to prioritize work to meet milestones and complete deliverables in a timely manner.
• Work with clients and other IT professionals to identify and specify business requirements and processes.
• Prepare documentation for scope, business justification and business requirements including use cases and business rules.
• Prepare presentations, charts, tables and diagrams to assist in analyzing business problems and defining solutions.
• Review design documentation and facilitates user interface and prototyping sessions.
• Review test plans and scenarios to ensure an accurate and effective product. Participate in functional and system testing.
• Coordinated Change Management tickets to implement changes from the SDLC.
• Respond to problems escalated by the help desk.
• Perform analysis, provide guidance and consult with vendors and other systems support personnel to identify and resolve problems.
• Performed data analysis between the existing platforms to the new platform.

Confidential

Business Systems Analyst

Responsibilities:

• Provided dual responsibilities as a Business Systems Analyst and as a Project Manager on each project.
• Develop detailed functional requirement documentation based on business unit requirements.
• Followed project methodologies using the SDLC.
• Provide guidance to stakeholders on devising effective and efficient approaches to achieve the project objectives.
• Review the business and functional requirements with developers, business leaders, and IT management.
• Prepare detailed release documentation related to application enhancements.
• Develop detailed test plans and scenarios based on application functional requirements.
• Execute test cases and track issues accordingly as part of standard QA process.
• Coordinate user acceptance testing efforts with users and business leaders.
• Provide ongoing user support for all implemented projects.
• Comply with Confidential procedures related to software development and application maintenance.
• Coordinated a new Change Management process to implement project changes.
• Performed data analysis for each project to insure data integrity.