SUMMARY:

• Over ten years of progressive experience in Business and Data Analysis.
• Result oriented and solutions focused Lead Business Analyst with strong combination of technical and management talents and proven ability of data analysis.
• Organized and analytical problem solver with strong interpersonal and negotiation skills.
• Adept at overseeing multiple tasks, resources, and cross - functional team efforts while interfacing effectively with team members and senior management.
• Highlights of expertise include:
• SDLC, UML, Agile
• Banking/Investment
• Quality Assurance
• Six Sigma
• Financial Reporting
• Data Governance
• Business Process Analysis
• Use Cases
• IBM/BPM
• BI Reporting
• OLAP /SISS, DTS, Testing
• Process Development / Improvement

TECHNICAL SKILLS:

Content Management: SharePoint, ClearCase, ClearQuest.

Business Reqs: SDLC, Waterfall, UML.

Languages: VBA, ASP. NET, Java, UNIX

Databases: Oracle TOAD, Teradata, SQL Server, PL/SQL, DTS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)

Application Suites: MS Project, MS Office (VBA Access, Excel), Visio, XML, Erwin

Operating Systems: Windows 7, XP, 9x, 2000, NT, UNIX (Admin)

BI: Business Objects, Crystal Reports, Cognos, MicroStrategy

Testing: HP Quality Center

PROFESSIONAL EXPERIENCE:

Sr. Business Analyst

Confidential, Washington, DC

• Works with the Affordable Housing Data Project. Lead the creation of an enterprise data warehouse analyzes business and technical processes, participates in the business process reengineering of as is processes and to be processes by identifying steps that can enhance or optimize the data process flows.
• Meets with the DC Agencies conducts JAD sessions and group presentations participate in focus groups. Validates the processes with stakeholders as needed.
• Interviews and participates in JAD sessions with executive level management and stakeholders with DC Agencies to create the business requirements and business process flows diagrams, develops documentation specifications, Six Sigma and SIPOCS artifacts.
• Gathers and create business requirements from process flows related to affordable housing programs and grants processes in DC.

Technologies: Visio Diagrams, SDLC, BPMN, Use Cases, Business Requirements, SharePoint, Six Sigma, SIPOCs.

Sr. Business Analyst

Confidential,Somerset, NJ

• Provided reporting and analytical support to the QA and QC activities related to the mortgage home loans bankruptcies and foreclosures control functions.
• Gathered and organized the data and procedures in order to increase the effectiveness of key controls and tracking and report any risks and related issues.
• Investigated data attributes within various servicing and loss mitigation databases. Created complex SQL queries to extract sample data from SQL and Teradata Databases.
• Created logics to automated data extraction and validations QC testing that included OLAP cubes and Six Sigma Calculations.
• Worked within the policies and standards regarding sampling methodologies. Thoroughly documented the operating procedures for testing sampling execution.
• Documented the sampling and test results, researches root cause as needed, and coordinated with stakeholders and business owners as needed.

Technologies: SQL Server, Teradata, Visio, MS Office, Visio, Six Sigma, LPS

Sr. Data Analyst

Confidential,Somerset, NJ

• Lead the process and technology teams focused on code tables data warehouse implementation projects to design, develop, and deploy the standardized Master Data Management of the code tables to meet the defined goals and objectives of LOB partners.
• Designed the governance processes and templates for the project that included BPMN swim lanes, in particular, set up the communication model.
• Managed the Data Governance framework by creating compliance processes and data policies in accordance of industry standards.
• Performed a leadership role in designing the distribution layer that will supply updates in the code tables data warehouse, developed the business process flows diagrams and project plans to integrate the new insurance ISO that included ICD-9 and IDC-10 standards and updates that include the updates of the codes.
• Created and updated the project plans and project status reports, coordinated weekly meetings with the PMO team members to inform the milestones deliverables of the project, updated maintained RACI (Responsible, Accountable, Consulted, Inform) documents and addressed escalated any issues as needed that included risk management reports.

Technologies: MS Project, SQL, BPMN, Share-point, Web Based databases.

Business Analyst

Confidential

• Worked with the data profiling team, created and automated the data quality score reports in MS Excel for the HAFA, 1MP, SD906 programs, created complex queries and in Access to easy the reporting processes. Ran Boxi (Business Objects) reports as needed.
• Reviewed, maintained and updated the ongoing HAMP project plans, data requirement documents and RTMs matrixes to comply with SLDC corporate standards, for testing new quality profiling tools.
• Performed data quality testing and approval from before and after scheme modifications in a Toad environment, performed parallel runs of testing data, using SQL statements documented the results in the Quality Control HP testing software.

Sr. Business Analyst

Confidential,McLean,VA

• Provided support to the ETL and data warehouse teams by translating the business requirements into data requirements and test plans and scenarios.
• Created specifications BRDs for reporting concerning new developments and updates to the MHAC compliance data warehouse.
• Worked closely with business users and other development teams in all stages of the BI development lifecycle.
• Maintained the project plans and requirements, used cases, traceability matrixes (RTM) as needed.
• Translated business requirement into (BRSs) to document data transformation rules data mapping (source, target) and updated as needed in a Clear Case environment.
• Provided and created data models logical and physical, data mapping joins guidelines to implement or modify the schemas in as needed, also maintained the metadata dictionary repository.
• Analyzed and created reports with servicer’s activities information within the MHA-C program, created complex SQL queries and Excel ad-hoc compliance reports as needed for the U.S. Department of Treasury.
• Collaborated and supported to other group members of the Fraud Reporting and Risk Analytics team by creating reports as needed, and other MHA-C functional teams.

Technologies: Erwin, SQL Server, Clear Case.

Sr. Data Analyst

Confidential,Reston,VA

• Supported the accounting and billing Teams by creating the business requirements to migrate the billing system into .NET web based platform, coordinated requirement gathering with stakeholders and managers.
• Conducted JAD sessions to gather functional and non-functional requirements for the transition of the manual billing processes to a web based application.
• Researched and validated the billing data and reporting results from the monthly billing and wholesale invoices created the invoice review reports in a monthly basis for senior management that included pivot tables and vloookup functions.
• Researched and investigate the root causes if were any unusual movements in the wholesale invoices reported results as needed.
• Supported the accounting team by reviewing the accuracy of the reports pulled from the monthly invoices.
• Researched data and assisted the accounting team to provide solutions to increase the revenue and margin from 32 Mil to 41 Mil a month, by matching components and standardize products.

Technologies: MS Access 97, SQL Server, VBA

Business Data Analyst

Confidential, Irvine, CA

• Conducted the data analysis and created the documentation and requirements for the Billing data migration and reporting Website.
• Created SDLC documents to assist with the Billing and Revenue Assurance data migration and implementation of website.
• Created metadata dictionaries and data models transformations rules as needed for the billing data warehouse.
• Conducted data analysis migrated MS Access databases to SQL Server database. Used DTS packages to migrated data from different sources.
• Assisted in the testing of the ASP.Net web base reporting applications to support the billing and fraud departments.
• Participated in the data analysis and validation of the migrations for the billing department.
• Participated in the development and testing of the ASP.NET web based reporting website.

Technologies: SQL Server, ASP.NET, SDLC, ETL, DTS packages, MS Office Suite.