Business Intelligence Analyst Resume

Title
Business Intelligence Analyst

Primary Skills
liaison between Finance and IT departments.

Location
US-FL-Miami

Posted
Aug-13-09


PROFESSIONAL SUMMARY

Professional individual with ten years experience in banking, retail and insurance industry with both technical and finance experience reviewing and analyzing the effectiveness and efficiency of existing systems and developing strategies for improving or further leveraging the systems which require liaison between Finance and IT departments. Demonstrate the ability to manage multiple projects with tireless energy and dedication.
Responsible for the activities related to the functionality of the business applications, and gathering new functional requirements, analysis and evaluation of the same.
Exceptional analytical problem solver with great communication skills capable to support customers in Europe, The Caribbean and Latin America. Excellent trouble-shooting skills.
Experience in Cognos EP Series V 7.3 Tools such as Cognos Impromptu, Cognos Powerplay for Excel, Cognos PowerPlay, Cognos IWR, Cognos Web. Proficient with ETL tools and OLAP. Cognos 8.3. Series Tools such as Report Studio, crosstab reports, chart, Query Studio, ad hoc reports and frame- work manager. Cognos Controller V8.0 and administration.
Experience testing to upgrade and migrate a current Cognos implementation into current Cognos.
CORE SKILLS
• MS SQL Server
• Audit Tracking System • HTML
• JavaScript • Visio
• Icat System
• Cognos B.I.
• Cognos Web
• Cognos Powerplay for Excell • Crystal Reports
• Cognos Impromptu
• XML
• .VB NET • Smartstream
• Cognos Powerplay
• Cognos Controller
• MS Office Suite • Windows XP, NT • Quickbooks

PROFESSIONAL EXPERIENCE
Electro Mechanical Services, Miami Florida June 2008 -- March 2009
Business Intelligence Analyst
Report to the Corporate VP. Manage technical support for Cognos 8 applications including report analysis, development, maintenance, and report migration. Work with project teams to ensure that new standards and practices are defined correctly and integrated into the corporate systems. Cognos report writer. Responsible for 27/7 support.
• Team Leader, implementing Cognos application and managing all process and activities at client end, analyzing user's requirements, developing test schedules, reviewing testing plans, tracking and documenting the development and results of these plans, and maintaining tables used in departmental databases.
• Depth understanding of Information Technology Software Development Life Cycle (SDLC) methodology and project management principles.
• Establishing the interview approach and coordinate the interviewing process.
• Implementing a Business Intelligence (BI) program to improve scorecard, dashboard and analysis capabilities.
• Interact with customer as needed to better define and understand reporting requirements.
• Interface with the business leaders and end users to identify areas to leverage Business Intelligence. Created reporting specifications and modified Cognos financial reports.
• Working directly with the business to plan and implement reporting solutions.
• As Cognos Administrator, published and re-published reports in the Intranet, resetting passwords, activating ID's and setting up requests in the Cognos Web.
• Expertise in building business intelligence and corporate performance management solutions including dashboards, score cards, query, and analysis reports with drill up, drill down.
• Performed and unit tested, systems integration (SIT and user acceptance testing (UAT) both independently and in support of formal testing teams. This includes the development of test cases enhancing Oracle packages.
• Acted as liaison between business units and technology groups to identify business processes and system requirements. Including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
• Responsible for support reports using Cognos BI 8.3 interpreting user requests, documenting requirements.
• Develop and maintain documentation. Participating in planning, analysis, and implementation of solutions in support of business objectives.
• to improve production as required.
• Identify and implement new reporting tools or expanded capabilities using existing tools and techniques for the creation and delivery of financial and business information to the business.
• Assisted in the troubleshooting of several financial systems problems and successfully corrected them.
• As a Business Intelligence Analyst I was involved in various business operations and helped the organization to achieve cost-effective production with increased quality, efficiency and satisfied customer service. Involved in documenting the business process by identifying the requirements. Due to my wide knowledge in Business Intelligence, I had to support the application, created and delivered training programs and solve problems including troubleshooting of operational/data issues.
• Responsible for Cognos BI and cognos Controller support. Collecting and organizing the FIPk files, creating CSVs files, then uploading these information into Cognos.
• Interface with the business leaders and end users to identify areas to leverage Business Intelligence
• Prepare weekly project status reports and keep management informed of project status and related issues.
• Assisted in the troubleshooting of several financial systems problems and successfully corrected them.
• Responsible for remote support services for internal and external clients in order to increase productivity, reducing travel expenses and system downtime.
• Analyzed, incorporated new business rules to Oracle packages ETL process to support changes as required by the business.

Mercantil Commercebank, Miami, Florida August 2007 -- May 2008
System Analyst and Audit Specialist
Reported to the Global Executive Vice President of Operations and Technology. Duties included coordination of internal and external bank IT audits, examinations and reviews with external government regulators. Research and analyze technical issues and business opportunities to identify and recommend effective solutions.

• Strong understanding of application systems, and business intelligence methods and the ability to quickly learn new software solutions.
• Analyze financial data, compiles reports and prepares recommendations.
• Prepare project plans for small to mid size including specific task identification, dependencies, assignments, durations and maintaining estimated time of completion statistics.
• Perform analysis, design, and document report requirements
• Develop Business Objects Reporting and Dashboard.
• Working with users and coordinating with application developers to understand and capture data/reporting requirements
• Support Cognos BI applications tools and maintain all the documentation for Cognos reports and create ad hoc queries extracting information from the datamart.
• Interacting with Business Users for gathering Business Requirements to develop the reports.
• Experience with Cognos Series 7 applications (Powerplay, Impromptu, Enterprise Server) creating reports.
• Designing, developing, and testing to upgrade and migrate a current Cognos implementation into current Cognos version.
• Document requirements, assist in clarifying discrepancies in requirements, and assist in obtaining appropriate approvals.
Document report designs and processes in a clear and concise manner.
• Acted as liaison between business units and technology groups to identify business processes and system requirements. Including the implementation of an executive portal to deliver knowledge content and Analytical Reporting.
• Knowledge in business process and system functionality such as research, analysis, testing and documentation.
• Coordination of project teams, including reviewing deliverables and providing technical guidance during projects.
• Prepare weekly project status reports and keeps management informed of project status and related issues.
• Meet with decision makers, systems owners, and end users to define business requirements and systems goals, Identifying, and resolving business systems issues.
• Research and document systems or programs requirements and specifications for the most complex and critical business systems.
• Coordinate and perform in-depth tests, including end-user reviews, to modify new systems to ensure they meet defined system requirements.
• Team player with strong computer background and excellent people skills, in charge of customer support demonstrating ability to perform multitask against the schedule.
• Senior point of contact between external bank examiners/auditors and bank regulators to establish the scope of each audit application. My experience and knowledge of regulatory terminology resulted in smooth project planning and initiation.
• Reviewed and analyzed final audit reports for deficiencies in order to complete a response and make recommendations for corrective actions which resulted in a 20% increase in bank regulatory compliance.
• Assisted the internal auditors with Sarbanes-Oxley review to ensure 100% compliance. My knowledge of Sarbanes-Oxley regulations allowed me to find discrepancies that were previously missed by the internal auditors.
• Ensured that all departmental policies and procedures manuals were kept current and that any changes were made in a timely manner in order to comply with the various government regulations. All changes in policy were presented to the Executive Committee and posted on the Intranet.
• Created a planning system with the unit managers to streamline the external auditing process which resulted in a 50% reduction in the time needed to produce the final audit statement.
• Evaluated new vendor financial statements in order to comply with internal bank policies and procedures.

Assurant Solutions Miami, Florida October 2002 -- July 2007
Cognos Analyst
Reported to the Director of IT. Provide technical support to all users, lead the design & development of Cognos based reports. Liaison between IT and all functional users, address all open issues and actively work towards resolutions. Cognos writer. Responsible for 27/7 support.

• Interface with the business leaders and end users to identify areas to leverage Business Intelligence. Develop and implement new Cognos Web, Cognos Impromptu, Cognos Powerplay, Cubes, and Powerplay reports containing financially sensitive information.
• Experience with Cognos Series 7 applications (Powerplay, Impromptu, Enterprise Server) creating reports.
• Developed a solution to a user technical problem that was previously thought to be impossible to solve. The solution that I developed saved 50% over the previous time needed. The achievement was recognized company wide.
• Responsible to maintain all the documentation for Cognos reports and create ad hoc queries extracting information from the datamart.
• Create batch job, and Schedule them.
• Implementing a Business Intelligence (BI) program to improve scorecard, dashboard and analysis capabilities.
• Designing, developing and testing to upgrade and migrate a current Cognos implementation into current Cognos version 8.3
• Testing and importing new reports into Framework Manager. My experience using Cognos Framework Manager has been concentrated in the creation of data models, from which report writer and business users can develop reports: creating calculations, creating the package and applying security, verifying the model and publishing the package.
• Design and implement interactive reports in Cognos 8.3 BI report Studio.
• Created OLAP cubes using Cognos Power Play Transformer.
• Researched, analyzed, and delivery solutions and guide personnel using Cognos' complex reports demonstrating ability to perform multiple tasks against schedule.
• Developed Standard Reports, List Reports, Cross-tab Reports, Charts, Drill through Reports and Scheduling and Distributing Reports through Schedule Management in Cognos Connection.
• Troubleshoot Cognos Web, Cognos Impromptu, Cognos Powerplay, Cognos Powerplay for excel GLIM, Smartstream and issues relating to the software, interfaces, or application.
• Design and implement interactive reports in Cognos 8.3 BI report Studio.
• Monitor and coordinate end of month/quarter technical processes. Provide technical assistance for re-engineering management reporting processes in Cognos and responsible for trouble shooting entire Cognos system software interfaces or applications.
• Experience analyzing MS SQL Server databases to determine data requirements.
• As Cognos Administrator, published and re-published reports and Cubes in the Intranet, resetting passwords, activating ID's and setting up requests in the Cognos Web.
• Document requirements, assist in clarifying discrepancies in requirements, and assist in obtaining appropriate approvals •
• Experienced with Power Play Enterprise Server inserting Cubes and Power Play reports and publish them to Upfront portals to be accessed by Report Net.
• Maintain and implement all functions related to Cognos Security for financial systems
• Support IT strategies and initiatives to achieve an optimum integration level of business systems and data, as well as communication regarding technology solutions, leveraging cross-functional systems, resources, and development efforts
• Maintain Process of Cognos Web Server.
• Create and execute test plans/scripts to find errors and confirm reports/cubes meet specifications.
• Gather business and functional requirements and work with technical staff to develop solution and alternatives.
• Assisting in testing activities for maintenance, project assignments by identifying testing scope and scenarios, preparing test plans and scripts, results monitoring, feedback and sign-offs and issues tracking and resolution
• Responsible for daily balancing of the P & L cube to the datamart using Microsoft Access.
• Developed special projects related to data collection and the maintain them.
• Responsible for remote support services for internal and external clients in order to increase productivity, reducing travel expenses and system downtime.
• Document report designs and processes in a clear and concise manner.


Miami-Dade Public Schools, Miami, Florida June 1997 -- January 2000
Robert Morgan Vocational Center

Payroll Assistant Administrator
• General Ledger integrity
• Purchasing, vendor account management
• Accounts payable
• Payroll entry

EDUCATION

University of Phoenix
Computer Science June 2009


University of Phoenix
AA Business Administration October 2006

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

Resumes in Miami, FL | Resumes in Florida

View other Business Intelligence Analyst resumes