We provide IT Staff Augmentation Services!

Associate - Business Data Analyst Resume

0/5 (Submit Your Rating)

SUMMARY

  • Cognos Report Developer with over 5 years’ experience in Business Intelligence reporting and data analysis.
  • A strong combination background in Information Technology and Finance supports a practical and efficient approach in the determination of client business requirements, and development of the technical specifications needed to construct custom - fit business reporting solutions.
  • 5+ years experience in Cognos 10 BI tools (Report Studio, Analysis Studio, Metric Studio, Query Studio, Cognos connection, Transformer, Framework Manager, Cognos Workspace.)
  • Demonstrated experience in the creation of complex reports and dashboard style solutions using Cognos Report Studio.
  • Possess in-depth knowledge of IBM Cognos TM1 9.5 (TI Processes, TM1 Architect, TM1 Perspectives)
  • Solid understanding of data warehousing, star schema, and OLAP.
  • Experience in full life cycle project development, including requirements gathering, design, development, testing, implementation and ongoing product support.
  • Strong experience in client interaction and understanding business applications, business data flow and data relations.

TECHNICAL SKILLS

Applications: IBM Cognos 8 /10 BI Suite (Report Studio, Cognos connection, Query Studio, Metric Studio, Analysis Studio, Cognos Workspace, Cognos Transformer, Framework Manager), Cognos TM1 9.5, Tableau PeopleSoft, SAP Financial, IBM AS 400

Databases: MS SQL Server 2008/2012, Oracle, MS Access

ETL Tool: SSIS, TM1 Turbo Integrator

Languages: SQL, XBRL

Operating Systems: Windows XP Professional, Windows

PROFESSIONAL EXPERIENCE

Confidential

Cognos Report Developer

Responsibilities:

  • Develop high level solution design and detailed technical specifications for Cognos BI Reports.
  • Perform translation and transmission of management needs, gathering business requirements for design of OLAP cubes and reporting mechanisms for various operating units.
  • Produce business objectives dashboards and key performance indicator scorecards for management and operational reporting.
  • Provide ad-hoc support for various business units for their monthly, quarterly and annual reporting needs.
  • Create reports with Optional filters, drill through, and custom prompt pages in Report Studio.
  • Bursting reports to different user groups. Monitoring and validating the accuracy of data delivered to the business.
  • Act as the primary liaison between Corporate Finance and the IT Division. Management and maintenance of sales budget uploads to the BI system.
  • Provide solutions by converting business requirements into technical design for Cognos TM1 models.
  • Liaise with Senior Management team to implement any new reporting requirement for the Group.
  • Understanding the business process and various business systems used for data capture. Reviewing and improving the reporting processes.

Confidential

Associate - Business Data Analyst

Responsibilities:

  • Collected complex financial information from different departments (e.g., business services, global market & investment, wealth management, and operation) and prepared consolidated results for reporting to Financial Leadership Team.
  • Prepared monthly sales and revenue reporting pack for management.
  • Produced monthly, quarterly as well as year-end financial reports for the Financial Planning and Analysis team.
  • Analyzed the key drivers and metrics vs historical performance, budgets, forecasts and communicate results to senior management for decision making.
  • Worked closely with senior management to establish budgets and assess projected needs of departments based on growth projections.
  • Performed statistical analysis to determine trends, estimates, and significant changes, and report findings.
  • Developed and established procedures and methodology for streamline reporting and operational efficiency.
  • Assisted in developing databases around industry and sector trends.
  • Reduced cycle time of key reporting processes by automating the business reports and improving workflow after careful examination of current system functionality and components.

We'd love your feedback!