Senior Reporting Analyst/developer Resume
5.00/5 (Submit Your Rating)
Belle Plaine, MN
SUMMARY:
- Senior BusinessObjects Analyst with a proven record of successful project completion.
- 5 plus years of professional experience in several database technologies: Oracle, SQL Server, Data Warehouse
- Exceptional knowledge of SAP BusinessObjects products (Crystal report, Web Intelligence, Universe Design, Information Design)
- Work thoroughly with end users to identify and specify complex business requirements and process
- Strong understanding of Data Warehouse concepts
- Provide input to peers, management and customers for recommendations and alternate solutions and/or improvements
- Excellent skills in adopting and learning new technologies, analyzing user requirement, and excellent team player with excellent interpersonal skills.
- Prepared test scripts and test cases
- Proficient in Troubleshooting and identifying underlying issues
- Verify accuracy of reports and provide insights with guidance.
- Excellent oral and written communication skills
SKILL:
MS Office: MS Office, MS Access
RDBMS: MS SQL Server 2005, 2008,and 2012, Oracle 11g and 12c, DB2
BI Tool: SSRS, SSIS, SSAS, BusinessObjects Suite, Power BI, QlikView, Tableau
Case Tools: MS Visio 2007, Bomul
Web Tools: HTML 5, JavaScript, CSS, and JSP
Languages: Java, Python, SharePoint, MS Project, Visual Studio
Others: HPE Agile, HP Quality Center, Cherwell, Jira, Confluence, and DataWarehouse
EXPERIENCE:
Senior Reporting Analyst/Developer
Confidential, Belle Plaine, MN
- Served as technical liaison between the company and third party vendor in defining, designing, and implementing SAP BusinessObjects 4.2.3 system
- Consult on business issues and solution considerations
- Research on industry trends, business products and competitors, analyzing trends, and making tactical recommendations
- Coordinated upgrades of existing applications, including testing, user acceptance, and monitoring performance following company change management procedures, for those items not run by the PMO
- Provide application support and maintain BI Reports throughout the enterprise.
- Created new reports and modify existing Crystal Reports using SQL Views and Stored Procedures on SQL Server.
- Responsible for configuring and updating reporting solutions enabling an automated reporting for all users.
- Designed Ad Hoc Webi and Crystals report as needed from business requests.
- Produce presentation quality reports for executive and business partners.
- Evaluate and update reports providing both archived and interactive dashboard reports.
- Documentation of reporting definitions, metrics and structures for transparent information sharing.
- Communicate solution changes, enhancements, and modifications, verbally or through written document to management and end users
- Collaborate effectively with Business managers, Project manager, Business analysts, DBA, and end users.
- Review and validate reporting solution in development before migrating to production.
Tableau Developer/Admin
Confidential, Belle Plaine, MN
- Work with BI Tableau versions 9.3 and 10
- Designed and developed Dashboards/Stories to address business needs and questions.
- Designed several worksheets.
- Managed contents and sites
- Administered users and groups
- Setup tasks and monitored scheduled tasks
BusinessObjects Reporting Analysts
Confidential, Le Sueur, MN
- Acted as a subject matter expert between business units and IT Department
- Facilitated requirements gathering meetings with stakeholders to prepare design documents
- Created system test plan and execute test suites to conduct function, regression, system integration testing, and user acceptance testing of complete issues, enhancements and projects
- Used Agile methodology for streamlining development activities
- Analyzed flaws in the current system and recommend solution for future improvement
- Responsible for support and maintenance of production system
- Designed BI reports to provide technical specifications
- Mapped data between external database and BI reports
- Used BI Central Management system to maintain Users and Groups management, content management, and Universe security management.
- Developed various business area’s BI ad hoc reports using BI Web Intelligence tool
- Used scheduling solution to distribute BI reports daily, weekly, monthly, and yearly
- Maintained best coding and standard practices
- Responsible for standardizing Report Formats, SQL Stored Procedure Best Practices, Enterprise wide Standards for specific calculations, and formulas
- Experienced in designing a report strategy and implementing a BI report solution.
- Testing and implementation of standard and ad hoc reports
- Elaborate knowledge and understanding of the technical and functional out - of-the-box features of the Business Objects platform