Bi Analyst Resume
Stamford, CT
SUMMARY
- Around 10 years of rich experience in IT with specific focus on Business Intelligence and Analysis.
- Preparing project documents such as Project Execution Plan, Design Doc, BRD, HLD/LLD and Implementation Plan, and ensuring that the SDLC 2.0 process is being followed and uploaded in SharePoint.
- Extensive knowledge in data visualization using tools e.g. QlikView, Oracle Hyperion EPM/BI, and Tableau 8.0, OBIEE etc.
- Strong experience with Qlikview application design and development, BI Publisher, QMC.
- High organizational and project management skills.
- Excellent ability to translate client requirements into effective solutions.
- Sound ability to interact with end users and craft clear technical requirements from business language.
- Experience in gathering requirements from Business, SMEs (which includes mockups, assumptions, current reality and use cases), scheduling meetings, preparing minutes (MOM), action items, maintaining log files and follow - up.
- Schedule meetings regularly with stakeholders and drive calls for all ongoing issues and to fill up the gaps between Business and Tech team.
- Responsible for completion of all Phases deliverables and get sign-off from stakeholders on time for each project document and any change in the process or application.
- Experienced in Project Management tools such as JIRA (Agile, Scrum), Microsoft Excel, SharePoint and Clarity.
- Recognized ability to identify, design and deploy innovative solutions, make real time decisions and provide directions during critical project situations.
- Extensive Knowledge with deployment using Web sphere, Web logic, Tomcat, IIS and Oracle application server.
- Knowledge of Change management for the System/Infrastructure/Business requirement Changes.
- Extensive experience in designing and developing OLAP cubes from a conceptual level.
- Capable of managing organizational data, assess and fulfill its reporting needs, and develop powerful BI solutions that have true impact on the performance of a company.
- Hands on experience with Qlikview Publisher and QMC.
- Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
- Applying quantitative methods to analyze synthesize and interpret information from multiple data sources.
- Support user, documentation, and rollout of new projects.
- Excellent communication and interpersonal skills with ability to be a team player and team leader.
- Handled many complex business application systems and projects by working closely with a variety of individuals at all levels.
TECHNICAL SKILLS
OLAP and BI Tools: Qlikview 11, OBIEE 11g, Oracle Hyperion BI/EPM System
Reporting Tools: Hyperion Interactive (IR), Financial Reporting (FR), Smart View, and Excel Reporting
MS Office Tools: MS Office Suite 2010/2007/2003/2000
Languages: MaxL, MDX, ESSCMD, SQL, Windows batch scripting
Databases: Oracle 11g/10g, MS SQL Server, IBM Netezza
Operating Systems: Windows 2008 Enterprise Edition R2, Physical as well as virtual machines, Windows NT/2000 /XP/Server 2003
Virtual Server: VMware Server\Client
Directory Server: MSAD, LDAP
Application Server: Weblogic, Web Sphere, IIS
Additional tools: Micro strategy 9, Birst BI, Tableau 8, IBM Cognos 10, MSBI Reporting
PROFESSIONAL EXPERIENCE
BI Analyst
Confidential, Stamford, CT
Responsibilities:
- Design and deploy reports for all environments
- Interact with internal client/ business user on the reporting requirements
- BI data modelling as per business rules and business matrices to support reporting.
- Engaged in requirement tracking using JIRA
- Report customization and embed with dashboard using QlikView BI solution.
- Collaborate with team members and stakeholders as and when needed
- Provide support for automation queue of reoccurring and ad hoc reports
- Troubleshot report issues, discrepancies, optimization, and other risks and concerns
- Maintain ad hoc tables and report scheduling
- Test and promote dashboards and reports
- Identified key insights, and ensured integrity, timing, and accuracy of results
- Managing onshore and offshore model.
- Report Performance tuning and troubleshooting
- Responsible for configuration management activities
- Tracking and managing end-to-end implementation
- Interpret written business requirements and technical specification documents.
- Act as evangelist for BI benefits across the organization
- Promote BI usage to relevant departments
- Responsible for demonstrating software to internal users
Environment: QlikView 11, MS SQL SERVER 2008, JIRA
BI Analyst
Confidential, New York NY
Responsibilities:
- Coordination on designing and deploying reports for all environments.
- Acted as Data analyst and Interacted with business community and gathered requirements based on changing needs.
- Extensively worked on Agile scrum environment for several claims processing modules
- Analytics reporting using Qlikview BI.
- Developed Qlikview Load Scripts for distribution across multiple data sources.
- Designed and maintained Qlikview applications.
- Managed all new and some existing projects.
- Interacting with internal client/business user on the reporting requirements.
- Collaborate with team members and stakeholders on needs
- Provide support of automation queue of reoccurring and ad hoc reports
- Troubleshoot report issues, discrepancies, optimization and other risks and concerns
- Migrated the data from the appropriate databases to end database and maintained batch log files.
- Coordinating with the other IT teams to collect design needs and making specialized structured written papers based on the operative needs
- Assisting the users and writing and producing specialized particularities
- Aiding the support and supervision of BI software programs
- Translating business requirement into Database objects.
- Assisting the structural and specialized designs of the schemes to make sure that the judgments are being made in accordance with the existing and forthcoming business plans of actions and chances.
- Coordinating with the end user gathering to ameliorate the overall individual architecture expertise
- Decreasing the information repetition and division and ruling out unneeded motion of information and enhancing the choice of information
- Making sure that the meta information is right, legal and reclaimable
- Team coordination handling offshore and onshore teams and delivery.
- Recognizing different matters and collecting and writing down the needs and actions of the scheme plans
- Maintain Adhoc tables, report scheduling; Test and promote dashboards and reports.
- Identify key insights & ensure integrity, timing, and accuracy of results
Environment: Qlikview, IBM Netezza, Agility workbench, Red Hat Linux, JIRA.
BI Analyst
Confidential, Nashville TN
Responsibilities:
- Participated on implementing Qlikview by replacing SSRS.
- Working with Business, SMEs (which includes mockups, assumptions, current reality and use cases), scheduling meetings, preparing minutes (MOM), action items, maintaining log files and follow-up.
- Maintained user guides for Qlikview applications.
- Provided ongoing Qlikview implementation and support.
- Outlined new features of Qlikview for clients.
- Design project plan, road map and project status evaluation.
- Extensively worked on agile scrum environment for several claims processing modules
- Troubleshooting and being accountable to application end users
- Quickly guide the team and resolve any technical issues that come during various phases of development as defined SLA.
- Team coordination handling offshore and onshore teams and delivery.
- Interacting and coordinating with cross teams during various stages of development and post production.
- Troubleshooting and being accountable to application end users
- Requirements gathering from the requirements team.
- Work with IT team to create users, groups and assigning roles according to the requirements.
- Provided technical assistance and support to end users and was involved in developing documentation.
- Development of new applications and future enhancements based on client’s requirements.
- Experienced in Project Management tools such as JIRA, Microsoft Excel, SharePoint, Clarity and using Agile.
- Writing test cases and executing test cases and implementation of change requests, User acceptance Testing - UAT, System Integration Testing - SIT activities.
- This project is to identify SSRS reports and implement the same using new Qlikview environment.
- Report design, drill through reports using OLAP cube features, Power Pivot.
- Link reports for all the clients.
- OLTP reports from DAX system.
- Disaster recovery procedures and blue prints in different environments.
- Interacting with the client managers for getting feedback on the deployed applications and ensure the quality of deliverables.
- Configuration Management activities.
Environment: Qlikview, MSBI 2008, MS SQL 2008, Windows 2003 Server, JIRA, Clarity
BI Analyst
Confidential
Responsibilities:
- Designing and deploying RPD using OBIEE environment
- Being involved in security implementation using WebLogic application server and server monitoring
- Designing and customizing reports and embedding with dashboard
- Troubleshooting and being accountable to application end users
- Report and dashboard design using Qlikview BI.
- Developed Qlikview Load Scripts for distribution across multiple data sources.
- Designed and maintained Qlikview applications.
- Managed all new and some existing projects.
- Maintained user guides for Qlikview applications.
- Provided ongoing Qlikview implementation and support.
- Migrating OBI repository and deployment of the OBI application
- Analysis, design, integration and implementation of solutions across multiple applications in domain, to include work processes, modifications, interfaces, and reports.
- Provided end-user system as needed.
- Performed and reviewed recurring tasks and user support on timely basis. Provided end user support for technical problems or application questions
- Implement OBIEE environment, report design, drill through reports using Essbase OLAP features.
- RPD (repository) development and deployment, interactive dashboard design
- Security implementation, administration, troubleshooting, and RPD migration
- Maintain security in Weblogic environment.
Environment: Oracle BIEE 11.1.1.7, Qlikview, Oracle 11g, Windows 2003 Server
BI Analyst
Confidential
Responsibilities:
- Participated in requirements gathering from functions such as Purchasing, Admin, HR, Finance, Contracts, and Discussions for the AS-IS process
- Defined organization, legal entity, banks, branches, chart of accounts, calendar and currency, key flex fields, descriptive flex fields, and segment value
- Customized report design such as Purchase Order and Requisitions
- Designed and developed reports as per the requirements
- Part of ERP System Implementation as team member. rganization business requirements such as Financials (GL, AP, AR, and Fixed Assets)
- Purchasing, Inventory, HR Projects, and Contracts
- Reengineered the process to suite the global standard for multiple locations in different parts of globe such as India, NA, and UK.
Environment: Oracle E-Business Suite R12, Oracle 10g, Linux ES 5
Hyperion Consultant
Confidential, Chicago, IL
Responsibilities:
- Interacted with the client for requirement gathering/ implementation of reports
- Understood the business logics, domain, and existing reports
- Verified Hyperion reports as per the business requirements during development and post-deployment to the quality testing and staging/ UAT environment
- Designed and developed the IR BQY queries and reports as per the requirements
- Team leader, involved in hiring new people and them on Essbase
- Daily maintenance, support and enhancement
- Worked on currency conversion on Essbase cubes.
- Created MAXL scripts and developed batches to automate them.
- Worked extensively on Hyperion Reporting, EAS and Created numerous users, groups and provided them different privileges.
- Used Hyperion Essbase Excel Add-In for data manipulation and report creation.
- Worked extensively on production support and was involved in solving the production tickets.
- Developed functional as well as technical documentation of the existing Essbase cubes and financial reports to transfer knowledge for users, for administration and support.
- Extensively involved in total SDLC (Software Development Life Cycle) of Essbase Cubes.
Environment: Hyperion Interactive Reporting 9.2.0.0, Oracle 9i, Windows 2003 Server
Hyperion Administrator
Confidential, Nashville, TN
Responsibilities:
- Involvement in the New Implementation and development of Hyperion Solution at the customer’s work place.
- Quickly guide the team and resolve any technical issues that come during various phases of development.
- Migration and integration of various Hyperion components - Used LCM and other migration utilities to migrate the artifacts from Dev to QA to Prod.
- Overseeing the deployment of the new applications into the production environment by providing necessary support to the support team and post production activities.
- Schedule end user and provide required guide lines to finance team regarding new Hyperion system components.
- Development of new applications and future enhancements based on client’s requirements.
- Writing test cases and executing test cases and implementation of change requests on Hyperion Planning application. User acceptance Testing - UAT.
- Interacting with the client managers for getting feedback on the deployed applications and ensure the quality of deliverables.
- Working closely with offshore project management team in updating project plan and Interacting with offshore project leads to track progress of tasks. build rules/ load rules/calc script development, EssCmd/MaxL Scripting, security/administration
- Implemented application security process, created users/groups, security profiles and application access to different groups using filters. Used Shared Services to create users, groups and assigning roles according to the requirements.
- Trained new users on the Essbase system and Reports, and Essbase Add-In
- Using windows task scheduler for customized DOS batch scripts with ESSCMD to backup periodically.
- Performed optimizations of Essbase database calculations, load and query performance times. Responsible for Performance Monitoring, Backup and Recovery of the cube.
- Troubleshooting Essbase database partitioning related issues and data-load on portioned cubes.
- Automated Essbase system with MaxL and server side batch scripting.
- Work with client's IT administration team to configure firewall and network requirements for Hyperion applications
- Provided technical assistance and support to end users and was involved in developing documentation.
- Document Hyperion system processes and responsible for complete system documentation and materials.
- Provided to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
Environment: Hyperion BI+ 9.3.1.0, Windows 2003 Server, Veritas Cluster Server, VMware Server.
BI Analyst
Confidential
Responsibilities:
- Interacted with the client for requirement gathering/ implementation
- Maintained BSO cubes
- Involved in creating reports
- Created MaxL (batch script) for data load and calculation
- Participated in data loading to BSO cubes from flat files
- Supported production environment
- Conducted sessions and mentored new members of the team.
- Took initiative to market the reports to the sales and practice heads.
- Identified methods to create awareness amongst employees and implemented the same to increase the foot print of the team.
- Involved in negotiation with the customers for requirement gathering
- Performed User Acceptance Test of the Competitive Intelligence System
Environment: Hyperion Essbase 7.1.5, Hyperion Analyzer 7.x, Hyperion Report 7.2.1, Windows 2003 Server
Hyperion Consultant
Confidential
Responsibilities:
- Migration of BSO Cubes to ASO Architecture
- Involved in creating partitions between ASO to BSO
- Created load rules for building dimensions and data load
- Data loading to ASO cubes from flat files
- Performance monitoring
- Supporting production environment
Environment: Hyperion Essbase 7.1.2, Hyperion Analyzer 7.x, Windows 2003 Server
Hyperion Consultant
Confidential
Responsibilities:
- Installed and implemented System 9 BI+ (Web Analysis, Workspace, Production Reporting, Planning, and Interactive Reporting)
- Worked on Analytic Server, AAS Console, and Smart view
- Deployed the Web Services using Application Server
- Performed User Acceptance Test of the Competitive Intelligence System
Environment: Java Hyperion System 9 BI+, Hyperion System 9 Analytic Services, Red Hat Linux 4.0 Advance Server, Windows XP
Hyperion Support Analyst
Confidential
Responsibilities:
- Provided consulting in Hyperion products for Hyperion clients worldwide
- Worked on Hyperion products such as Essbase and Reports
- Provided support
- Handled installation of various versions of Hyperion products, licenses, and administration
- Responsible for technical queries and objections, a major part of the job profile
- Handled Essbase issues such as MaxL scripts, calculation scripts, ESSCMD, performance issues, backup files, and Excel add-in or spreadsheet issues
- Worked with Essbase, and deployed with web application servers such as Tomcat, WebLogic, and WebSphere
- Worked with various Hyperion products, which run on various operating systems such as Windows 2000/ 2003 Server/ XP and UNIX
Environment: Hyperion Essbase System 9 BI+/ 7.x/ 6.x/ 5.x, Windows 2000/ 2003, Red Hat Linux 4.0, VMware Server/Clients.