We provide IT Staff Augmentation Services!

Reporting/business Analyst Resume

SUMMARY

  • I believe that the best accomplishments are attained from persistent and open minded collaboration among diverse stakeholders.
  • Over 9 years of combined business reporting,analysis and project management experience in varied companies like Confidential, Confidential Corporation, Confidential & Confidential and Confidential .
  • Solution - oriented, forward thinking Senior Reporting Analyst offering over 9 years of experience in identifying and managing risks inherent in business processes that support corporate objectives.
  • Objective and progressive in nature with dynamic leadership and business acumen to provide extraordinary results.
  • Sound knowledge of Microsoft Office suite including Excel, Power point, Visio and Project.
  • Extensive knowledge creating, publishing and automating reports using SQL Server,SSAS,SSRS and SSIS.BI tools like Cognos,knowledge of MicroStrategy.
  • Have working knowledge of product life cycle's phases like requirement specification, software designing and development, testing and maintenance.
  • Understand appropriate technologies, tools and optimization techniques and models.
  • Management of direct/indirect reports in virtual/non-virtual environment.

TECHNICAL SKILLS

Databases: MS SQL Server 2008/10/12, MS Access 2010

Programming Languages: SQL Programming, C, C++, Java, HTML, XML, CGI, Perl

Internet: XML, HTML, DHTML (CSS), JavaScript

Operating Systems: All Windows OS, UNIX, and Mac OS

Reporting Tools: MS Excel, Crystal Reports 11, BI Tools (COGNOS),SSRS/SSIS,SSAS

Others: MS Office Suite 2010 including MS Project and MS Visio, SharePoint

CRM/ERP: End user knowledge of PeopleSoft (CRM), SAP, HEAT

PROFESSIONAL EXPERIENCE

Confidential

Reporting/Business Analyst

Responsibilities:

  • Appointed as a Senior Reporting Analyst in Mortgage Collections Department of Confidential . This role involved coordinating task assigned and managing a team of offshore analyst. This role also involved creating various delinquent reports and metrics for mortagage forecasting and discrepancy resolution usage.
  • In this role hands on reporting in SQL by collecting, analyzing, interpreting the requirement from various stake holders and translating into appropriate solutions for end user was required.
  • Initially was involved in a transition project while migrating from one reporting platform to another. Overlooked this project from initial mapping stage to complete trasition to the newer server and reporting system stage which created transparency in reporting and also assisted in easier tracking, and reporting to facilitate faster analysis.
  • Involved in creating adhoc reports by mining data from varied data sources with multiple format and provide analytic solutions in form of reports for any unresolved issues using SQL, creating reports in SSRS extracting from SSAS.
  • Extensively used SQL in reporting, solely was responsible for the complete ETL of a Forclosure metrics that was created for forclosed loans trend analysis and short sale decision making process for leadership team.This report was generated daily for stakeholders in SSRS and published automatically onto a sharepoint site.
  • Worked on a project involving 15 other analysts to create a centralized reporting reporting HUB. All these reports were automated using autosys in SSIS and created in SSRS. These reports were automatically published to various level for stake holders in different formats based on underlying complex SQL queries.
  • Was involved in intial design phase in identification of cubes, fact and dimension tables for transition to Cognos BI.

Confidential

Reporting Analyst

Responsibilities:

  • Appointed as senior subject matter expert in billing division of Confidential & Confidential . Role involve managing a team of offshore analyst in reporting various spend and discrepancies in billing system for various voice and data usage in Confidential & Confidential .
  • Involved in software lifecycle and application design phase of a project on voice and data usage billing system integration for projected FY13 by collaborating with various teams and divisions within Confidential & Confidential .
  • Involved in creation of direct report in providing resolutions and quantifications for urgent impact request and projection reports.

Confidential

Business Analyst

Responsibilities:

  • Involved in complete software lifecycle and creation of Specification document during application design phase in conversion to Business Objects/Business Warehouse (BIS) from SAP database reporting platform. Consulted with multi-functional teams throughout project lifecycle.
  • Analyzed data in Business Intelligence platform using BW/BO to drive the reporting strategy, testing, and data integrity of financial analysis, revenue and profitability trends.
  • Uncovered spend inaccuracies via data migration routines by usage of Excel, SQL Sever and Business Objects(BI platform) that have provided high quality reporting solutions across 15 business units by extracting data from various databases like Epicore,Peoplesoft others and SAP.
  • Built an Access reporting tool as a consolidated approach to managing high volume transactions in Supplier Diversity vendor database; best practices approach was integrated internally and externally.
  • Collaborated with finance team and developers to write specifications documents, and translate needs and ideas into effective strategies extensively used tools like MS Visio and MS Word to achieve a holistic approach in transition of various platforms in reporting. Extensively used Power Point in reporting metrcs information.
  • Designed comparative summaries of loss/gain trend analysis, and expenses for ad-hoc management of supplier contracts. Efforts contributed to the contract renewal of an external vendor. Extensively used Excel and Power point.
  • Worked on development of online self-certification with developers on SharePoint. Regularly updated and uploaded enhancements on training manuals and procedure manual on SharePoint.
  • Shaped the approach to supplier certification process and instilled a standardized process for managing supplier master database.
  • Integral team member on an Enterprise-Wide Reporting System Project; collaborate in formulating data-driven thought leadership to drive reporting and insights regarding trends and opportunities.
  • Worked as a prime analyst in determining sizing and buget constraint in renewal of a contract with third party vendor.
  • Awarded Spot Buy team award on contribution towards creating unified reporting system and metrics and bringing awareness of the team within and outside the organization.

Confidential

Business Analyst

Responsibilities:

  • Project managed the migration of a legacy Treasury Management system to PeopleSoft CRM
  • Developed the business case as a justification for new tools/software integration; liaised with IT; managed change requests, requirements, timelines, specifications, business processes and recommendations.
  • Synchronized IT planning with enterprise-wide processes; mapped end-to-end integration points, information flow, handoffs, and communication pathways.
  • Interacted with QA/Quality Assurance teams and key stakeholders to in corporate diverse views and to ensure accurate translation of requirements into transformation.
  • Compiled SQL status reports summarizing the identification and resolution of system defects.
  • Analyzed process gaps/opportunities, assessed the impact on existing systems and recommended cost effective solutions to support the architectural, physical, and logical design of application integration.
  • Jointly defined, developed and documented comprehensive test cases, scripts, and test strategy utilizing Test Director. Instrumental in creating end-user training guides and mentoring the migration team.

Confidential

Incident Process Analyst

Responsibilities:

  • Instituted root cause analysis to clear roadblocks and drive continuous improvement to ensure the Incident Management Process confirmed to ITIL standards.
  • Documented business requirements, understood critical success factors, internal capabilities, timelines, and current infrastructure for upgrade activities.
  • Executed user guides and detailed functional design specifications; monitored QA/quality assurance, fit-gap analysis, workflows, test plans, and scripts.
  • Transferred knowledge and provided leadership support to less experienced team members on migration standards. Designed Crystal Reports to equip management with the ability to respond to SLA performance more rapidly.

Confidential

Support and Document Analyst

Responsibilities:

  • Monitored Gas and Electrical Maintenance System performance 24x7 to ensure optimum availability of the enterprise environment to its end users.
  • Liaised with internal teams in designing, developing, and implementing improvements to drive system enhancements and upgrades.
  • Tracked and reported defects Confidential checkpoints during the test run, using industry accepted techniques for debugging, fixing and improving applications throughout their development life-cycle.
  • Conducted UAT/User Acceptance Testing and authored detailed new hire training documentation and procedures for identifying and resolving defects.

Hire Now