Business Analyst Resume

SUMMARY:

Expertise in Requirements Analysis - in interacting with stakeholders from a variety of functional areas to gather, analyze, and define business and functional requirements
Effective liaison between business and technical groups to document and translate customer requirements into technical specifications
Extensive experience in software development life cycle, feasibility analysis, business analysis, data modeling, data warehousing, web-development, reporting, testing, documentation and staff
Great interpersonal skills in connecting and coordinating with different teams to accomplish tasks
Managed development of new software systems and production support - prepared WBS, estimated work effort, prioritized tasks, established regular communication with stakeholders to get feedback on newly released features, understand user issues, and ensure best practices

TECHNICAL SKILLS:

Technologies: Oracle database, SQL Server, SQL, PL/SQL, Cognos BI, HTML, CSS, JavaScript, SQL Server Management Studio, Java

Database Methodologies: Relational Modeling, Dimensional Modeling

Other: Microsoft Office (Word, Excel, PowerPoint) MS ProjectMS Visio, TOAD, PL/SQL Developer

WORK EXPERIENCE:

Confidential

Responsibilities:

IT Consultant for Data Warehouse projects to support Accounting, Compliance, and Management reporting requirements for Finance and Claims users.
Implemented a system to automate the interface of financial data from source systems into Oracle Financial Applications. Provided operational and analytical reports for Claims managers. Organized data by business functions to enable adhoc access to meet various reporting needs.
Elicited requirements from business users and analyzed business functions. Used data and process flows, and mock-ups in documenting business requirements.
Worked with technical teams to brainstorm design and development solutions, and establish data models and processes to meet business objectives.
Documented technical specifications maintaining traceability from business requirements to user acceptance testing.
Prepared test plans and scripts to validate business requirements.
Performed data profiling of multiple source systems to map source and target attributes, document metadata and alterations to the data for conformance to database methodology.
Performed gap analysis of source system conversion to ensure correct mapping of key data elements.
Investigated data issues and anomalies; implemented controls to ensure data quality and integrity.
Mentored team members on business functionality and issue resolution.

Confidential

Responsibilities:

Worked with loan center managers to gather and analyze requirements for providing metrics on volume, timeliness, and quality of services at various levels of the organization.
Facilitated meetings between business and technical teams to understand workflow and dataflow in source systems impacting the BI Reporting system.
Prepared business and functional requirements documents and presentation slides for new features and system enhancements.
Worked with development team to implement system functionality as per business requirements. Assisted in building and refining the data model for adhoc reporting.
Prepared test plans and test cases to test and validate report functionality and metrics.
Provided production support for issue resolution and enhancements.