Senior Analyst/project Manager Resume
4.00/5 (Submit Your Rating)
SUMMARY
- Extensive experience in the BI domain including both data warehousing and reporting.
- Provide roadmap for selection/migration of BI platforms.
- Draft, negotiate and manage SLAs.
- Lead team of onsite and offshore BI developers
- Well versed with data quality issues and their mitigation.
- Ability to provide practical solutions to problems.
- Strong process improvement skills.
- Strong background working with end users at all levels identifying requirements, providing work estimates, designing and creating reports and user interfaces, and developing implementation time lines.
- Excellent communication and presentation skills.
- Recipient of Director’s Award for outstanding Brio support at Amtrak
- Member of committee for technical evaluation of vendors for RFPs at Amtrak
- Member of committee to select IT employees for the CIO’s Star Achievement Award at Amtrak
TECHNICAL SKILLS
Applications: Hyperion Intelligence (Hyperion Interactive Reporting), OBIEE, Business Objects, Crystal Reports), MetaCube(OLAP), Synergy Project Management & Time Reporting System, MS Project, iWay, MS Office Suite (including MS Excel for querying and presentation using macros)
Databases: Informix, MS SQL Server, db2, Oracle, MS Access
Platforms: Windows, Unix\Sun OS, Mainframe
Programming: SQL, JavaScript, HTML, C
PROFESSIONAL EXPERIENCE
Confidential
Senior Analyst/Project Manager
Responsibilities:
- Manage successful development, configuration, and administration of the Enterprise Business Intelligence (BI) Application (Hyperion Interactive Reporting). Provide roadmap and technical guidance for the migration of Hyperion reports to OBIEE.
- Provide user support for EDW. Work with ETL and DBA teams to ensure performance improvements and resolve data issues.
- Work with different IT teams and business users to resolve issues, gather requirements and suggest/implement BI design/architecture solutions. Provide training to business users as needed.
- Provide leadership and oversight to stabilize Hyperion reporting environment. Work with IT Service and HAEA resources to support recommendations and implement changes.
- Devise reporting roadmap to support growing business demands within a more governed strategy and technology leverage.
- Implement process improvements to increase system efficiencies.
- Devise plans and strategies to enhance user experience. Implement solutions for recurring issues. Reduce technical team's time spent on resolving user issues. Customer education/training to make users more self - reliant.
- Develop/maintain Hyperion reports. Setup automatic data exports to Excel. Create macros for analytics within excel using pivots and charts.
- Help users query data from within Excel for analysis and reporting. Used also for account reconciliation.
Confidential
Systems Developer/Tech. Lead
Responsibilities:
- System Administrator - Hyperion, Business Objects, Synergy, RWD uPerform and Data Warehouse (IBM Informix, MetaCube), IIS.
- Manage system configuration, systems/change management, and operational deployment of Hyperion Brio, Business Objects and Data Warehouse. Manage Audit and CMS databases.
- User account maintenance, file system administration.
- Provide support to users (more than 500) spread across the country. Address end users’ technical issues.
- Create reports in Brio and later convert these to Business Objects. Create macros in excel for users to work with exported data from the reports.
- Work across internal and external resources to resolve technical challenges.
- First and last line of support for BI and Data Warehouse.
- Design, code, test, implement and document BI solutions, including integration with databases.
- Maintain and support systems for data warehouse and business intelligence (BI) initiatives. Troubleshoot tools, systems, and software; performance-tune these applications.
- Perform analysis, testing, debugging, audits, disaster recovery, and problem resolution.
- Research and evaluate technology solutions and present recommendations for improved system operations.
- Participate in design, analysis and pre- and post-installation reviews.
- Gather requirements, locate sources of data, suggest solutions and develop reports. Work with stakeholders across multiple functional areas, including Finance, HR, Payroll, Labor Management, Call Center, Marketing and Planning.
- Analyze, design, develop, test and implement Data Warehouse applications. Manage ETL scripts and monitor data loads.
- Monitor and resolve production issues.
- Develop training manuals and conduct training sessions for internal users.
