We provide IT Staff Augmentation Services!

Business Analyst Resume Profile

5.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY

  • Proficient in creating Business Requirement Documents BRD , Functional Requirement Specification FRS document, User Requirement Specifications URS document, Application Design Documents, Use Case Diagrams, Activity Diagrams, and Sequence Diagrams using MS Visio.
  • Strong skills in eliciting, analyzing and educing business requirements for projects working closely with clients and IT teams for early gains in project planning development.
  • Excellent interpersonal and communication skills in both independent and team-oriented organizations, client relations and negotiations.
  • Excellent communication skills to present project status and metrics to executive management for organizational tracking and performance.
  • Experience in managing projects contracted to external vendors, engaging vendor dialogue for project planning and execution.
  • Expert at managing multiple, concurrent projects, process improvement and change management.
  • Financial analysis in terms of portfolio budget, capital and expense charges/variances, and status report to the project stakeholders: client and executive management.
  • Prepare Manage project plans, milestone and release schedules on time project/program completions under waterfall and agile/scrum methodology.
  • Strong 10 years of Business Analysis and Project Management expertise in software implementation projects programs.
  • Create and Trace requirements on Requirements Traceability Matrix RTM .
  • Experience in facilitating testing, user acceptance testing UAT for clients and ensure the project is signed off by stakeholders.
  • Strong analytical skills to analyze large data volumes and draw meaningful recommendation in the form or reports/metrics/scorecards.
  • Extensive written and presentation capabilities using PowerPoint and Experience using MS SQL, Netezza SQL Aginity , Business Objects Reporting, Access, Excel, MS Project, Visio, MS Word, Adobe Photoshop and web based software architecture.

CORE COMPETENCIES / STRENGTHS

- Project Management

- Financial Budget Analysis

- Business Case Development

- Requirements Management / Gathering

- Release Management / Tracking

- Client Interface and Status/Metrics Reporting

- Change Management

- Compliance and Project Governance

- PMO Practices Program Management

- Capacity Planning

- Corporate Compliance

- Testing and Defect Tracking / Resolution

- Intermediate SQL experience

- Vendor Management SOW RFP contract negotiations

- Data Analysis

- User Acceptance Testing UAT

PROFESSIONAL EXPERIENCE

Sr. Business Analyst

Confidential

  • Business Analyst for Capital Compressive Analysis Reporting CCAR FRY-14 Monthly Home Equity Loans /Quarterly reporting mandated by Federal Reserve Board under DFAST Dodd-Frank Act Stress Testing DFAST .
  • Use Business Objects to create, validate and manage reports to ensure accurate data on outbound Xml files reported to Federal Reserve.
  • Handle change request to investigate, review or create logic for automation of new fed requirements or changes.
  • Analyze and created executive steering meeting scorecard and metrics presenting populated vs general business rule threshold from LPS Black Knight or Internally suggested threshold.
  • Designed edit checks report for Retail Commercial Schedules reported 600 fields, managing the FRB measurement threshold and risk with Sr. Business Analyst and LOB expectation.
  • Created mapping documents and validated source to target fields, working with Sr Business Analysts maintained the approved mapping lineage.
  • Analyze FRB outbound reported data, identify data quality issues to general business rules and work with technical Business Analysts IT to resolve for proper remediation and reporting purposes.
  • Analyzed the new proposed 2014 technical Instruction from Federal Reserve for FRY-14 M/Q schedules and advised Sr Business Analyst Executive Steering Committee.
  • Analyze Home Equity and Commercial loan data and create data profile, Initiated a trending report which present data anomalies for reported period and further investigation and remediation.
  • Leading Trend Reporting grouping effort with other Business Analyst.

Sr. Business Analyst Market Intelligence

Confidential

  • Leading market business intelligence analysis and reporting services client engaged in international business supply. Leading project management activities for new market launch.
  • Elicit with client on data, analyze data source internal and external resolve impediments for cleansed data source.
  • Perform collection of data fields and create the database structure in MS Access / Excel as per client requirements.
  • Create scorecards based on client elicitation present trends on market movement and intelligence of opportunities.
  • Conduct needs assessments with clients to create detailed business automated reports, and communicate specification documents.
  • Evaluate program management process problems and solutions to them so that the team could achieve target goals.

Sr. Business Analyst / Project Management Consultant

Confidential

  • Involved in various reporting application project management under Executive Metrics and Analytics EMA which provides Business Intelligence reporting for various Verizon segments.
  • Maintained project plan milestones, progress on milestones, maintain issue and risk reports, distribution of project status and project documentation.
  • Managed programs and developed schedules as per discussion with IT and Business Partners internal/external business services
  • Report correct status of the projects for executive status reporting on a regular basis to keep track of the program.
  • Maintained Created IT CapEx budget 96 projects 0.4M , As program manager create budget analysis, cost and time management.
  • Developed the financial models for portfolio of projects, tracked actual charges to budget and variances.
  • Tracked and reported weekly portfolio budget, capital and expense charges, and status report to the project stakeholders: client and executive management.
  • Provide over run / under run labor charge analysis an efficiency increase of 100 in funding utilization.
  • Created and maintained capacity plan dashboard to present yearly / quarterly capacity view for group and application leads.
  • Reviewer and estimator of yearly Business Cases for next year group work with client and IT leads. Ensure allocation of funding as per IT Business Stakeholders review and agreement.
  • Plan and Execute project deliverables. Tracked 8 major / complex projects every quarterly release and managing full SDLC with application IT lead and 8-10 development resources.
  • Provided various weekly statuses to PMO organization on project execution and meet release cycle expectations.
  • Performed project management activities with cross application groups to negotiate deliverables and delivery schedules in alignment to agreed release plan.
  • Gathered weekly status from IT Managers/Leads on application projects and provided summarized view to executive reporting POC's.
  • Tracked program/project issues and worked toward resolution without impacting release. Ensured commitment from all impacted groups for project releases.
  • Created tracked level of effort for ongoing projects with application manager. Manage resource planning within group budget.
  • Led Verizon Lean Six Sigma VLSS deliverables for group with various business segments, researching on needs from VLSS black belt and pursuing delivery of requested deliverables in form reports, data dump, reports.
  • Experience in guiding junior developers with functional and technical specification of project.
  • Custodian for group applications, complete regulatory compliance items, IT Industry updates.

Project 1:

  • Conversion of client maintained existing reports to MS OLAP application and Integration of new data and enhanced business rule for new FIOS and HSI product campaign tracking. As a Project lead acting as scrum master for 3 onshore 7 offshore development team ensuring development activities adhere to agreed project plan and IT SLA.
  • Implemented Scrum methodology for the project initiated 2 week project planning sprint meeting supporting incremental reporting enhancements product backlog , deliverable grooming and prioritization with stakeholder POC product backlog grooming . Align enhancement releases to organization release cycles.
  • Organize and facilitate daily standup meetings IT development team, advising and supporting on removal of challenges and project impediments. Daily Scrum
  • Prioritizing deliverables based on IT team work load and deliverables completion schedules sprint backlog .
  • Ensuring project retrospective items prioritized and added to deliverable tracking list sprint retrospective .
  • Use deliverables stories based on business rules with client poc to define project scope and, requirements, and deliverables and provide detailed business requirements and functional requirements for IT team.
  • Created change management systems for IT and client track new CRs Change Management , issues, user testing, project sign off and maintenance with Clients IT.
  • Advised on project status, IT meeting minutes, facilitate user and business client meetings with IT lead present solutions acceptable to both IT and Business.

Proejct 2:

  • 2012 Verizon IT consolidation required migration of One Bill web reporting engine migration from Oracle to new data source platform using Teradata/SQL developed new ASP.Net web application for user to access reports.
  • Project Lead for 3 cross functional application development team 15 resources ensuring development activities adhere to agreed project SLA and plan for on track delivery.
  • Investigate as-is vs. to-be source table data structure with the development team recommended new design for table and data structure to comply with migration effort.
  • Led reporting GAP Analysis and savings resulted by decommissioning old reports and HW/SW process.
  • Created new metrics and trends as per stakeholder discussions, formulate report design with development lead and stakeholders for meeting stakeholder / user community demand.

Project 3:

  • Transfer reporting application is a critical tool in evaluation of call center transfers between different agents/desktops. Conversion Migration of existing application to new data source and re-design of reports on ASP.Net application framework.
  • Standard 6 month release project being completed in 3 months to meet organizational performance goal with a dedicated team commitment and adherence to aggressive deadlines.
  • Analyzed current reporting inefficiencies and needs of stakeholders, and re-designed data source improved reporting delivery of metrics and trends for better coach of call center agents.

Project 4:

  • PARS'2.0 app development using new single Teradata MDM solution to track customer accounts for Verizon footprint for FIOS/HSI products, allowing sales, and marketing performance of various products.
  • Worked with application clients / owners understand business process and business rules to establish data needs for application. Performed GAP Analysis current versus proposed solution from data warehouse architecture team.
  • Performed data analysis to help design data conversion efforts and establishing data standards as per business rules and processes per agreed SLA.

Senior Business Analyst

Confidential

  • SAP Business One implementation project for Babcor Packaging Corp. Which is a retail packaging specialist. Babcor Packaging provides custom packing utilized by most retailers a professional packaging program.
  • Gathered, understood and articulated business requirements from interaction with the stakeholders to get a better understanding of the business processes.
  • Prepared BRDs and assisted in preparing Use cases and reviewing them with the Developers, QAs before getting sign-off before deadline. Conduct functional requirement reviews and walk-throughs with cross functional teams. Responsible for setting up meetings and RGS requirement gathering session with project stakeholders.
  • Conducted JAD sessions by actively coordinating with the developers and formulated quality documentation.

Business Analyst / Project Lead

Confidential

  • Reporting to Director involved in Project Management and Business Analyst activities for of Data Warehouse group / applications.
  • Established PMO and processes for group from scratch for 15 applications 175 resources
  • Managed PMO team 2 Direct 5 IT Leads on dotted line .
  • Established Project Lifecycle processes including IT Governance, project KPIs, project dashboards, document templates, overall IT Financial reporting and weekly executive reporting processes.
  • Prepare Manage project plans, process workflows, manage milestone and release schedules on time project/program completions.
  • Managed 20M IT CapEX financial budget of the Data Warehouse group and responsible for securing funding for critical Projects.
  • Executed SOW and RFP contracts Fixed Price and T M for worth 12M with various external vendors Infosys, TCS, and Accenture for various approved projects.
  • Implemented capacity evaluation models presenting 90 efficient tracking of 175 resource project release utilization onshore offshore . Model used by other major groups
  • Collaborated with Clients and development team members of Data warehouse gathered and defined requirements. Captured the business rules of the data and documented them in the data model as part of the developing business requirements deliverables.
  • Prepared of General/Detail design documentations for the release / phase of the project ensuring project documentation is in compliance with the requirements as defined in the BRD.
  • Coordinated and facilitates JAD sessions and worked with data architects, developers to translate requirements into technical specifications using the Unified Modeling Language UML and workflow models based on the Rational Unified Process RUP .
  • As SME for IT management activities, created project plans, conversion strategies, document, and present Verizon marketing business rules for the IT team leads, and Workgroup per client requirements.
  • Ensured effective task management, as a Business Analyst overlooked on the entire IT projects and application development provided weekly executive management review reports.
  • Involved in preparation of business flow charts, statements and project reports.

Financial Analyst

Confidential

Sarvodaya labs engaged in the manufacturing and marketing of pharmaceuticals for regional and international market with yearly sales in excess of .200M. As Financial Analyst prepared overhead budgets and forecasts analyze business operations, labor utilization, trend analysis, and headcount data for reporting. Also Involved in maintained of accounting and reporting systems maintained and analyzed costs against budgets. Prepared and reconciled purchase orders to invoices review of invoices for appropriate classification.

TECHNICAL SKILLS

Office Suite:

Microsoft Office Suite Excel, Power Point, Word, and Visio , Microsoft Projects,

RDBMS:

Microsoft Access, Understanding of SQL SERVER, OLAP, SQL Reporting, Query Analyzer, and MS Query, Sagent Information Studio for Reporting

Reporting Tools:

MS Access Reports, Pivot Reports, Crystal Reports

Modeling Tools:

UML, Use Case Models, MS Visio

Languages:

SQL, HTML

Operating Systems:

Windows '8/'7/VISTA/XP/2000/NT/98/95, Mac 10.5.X, DOS

We'd love your feedback!