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.
