We provide IT Staff Augmentation Services!

Data Analyst Resume Profile

NY

Objective

An accomplished Technical and Functional experience with demonstrated success of designing and implementing complex business applications and solutions that improve business functionality. Possess diversified background. Proven ability to deal with technologies that decrease costs, increase performance and positively impact the bottom line.

SUMMARY

  • Total 9 years of rich experience in IT years' with Business Analysis and Project Management experience in evaluation, requirement gathering, design, analysis, development, implementation, and testing of various complex applications environment.
  • 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
  • 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, Microsoft Excel, SharePoint and Clarity.
  • Good communication and presentation skills, which aid me in building strong Client and Vendor Relations.
  • Analysis, development, implementation, and testing of various complex applications environment.
  • 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 Websphere, 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 data integration from multiple data sources into Hyperion Planning and Essbase
  • Managing security, permissions, users and groups, controlling access to database cells through managing filters, filters: creating, copying and assigning filters.
  • Monitoring and support Hyperion Essbase Business Intelligence applications and batch load processes to ensure the highest level of system availability.
  • Applying quantitative methods to analyze synthesize and interpret information from multiple data sources.
  • Support user training, 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: Hyperion Planning 11.x/9.x, Hyperion Essbase 11.x/9.x/7.x/6.x, Essbase Administration Services EAS , Analytic provider Services AIS /EIS , Workspace, Smart View for Office, MS Excel Add-In Essbase query designer, Performance Management, HAL

Reporting Tools: Web Analysis, Smart View, and Hyperion Financial Reporting FR , Excel Reporting

MS Office Tools: MS Office Suite 2010/2007/2003/2000.

Languages: MaxL, MDX, ESSCMD, SQL, Windows batch scripting.

Databases: Oracle 11i/10g/9i/8i, 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, WebSphere, IIS

Additional skills/knowledge:

  • Well acquainted with BI Tools Oracle OBIEE 11g and Microstrategy 9, Birst BI, Tableu 8, IBM Cognos 10, MSBI Reporting.
  • Trained on Oracle eBusiness Suite Financial modules.
  • and dataflow in order to identify, recommend and document the appropriate new business and systems requirements to address those needs. Worked closely with application developers team, users, IS T team, company management, software vendors, contractors and outside business associates in multiple time zones to support the technical system design, systems testing, integration testing, quality assurance and user acceptance testing to implement agreed upon solution.

PROFESSIONAL EXPERIENCE

Confidential

Role: Data Analyst

  • Coordination on designing and deploying reports for all environments.
  • Working on Analytics reporting using IBM Netteza database.
  • Interacting with internal client/business user on the reporting requirements.
  • Requirement tracking using JIRA
  • 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
  • Maintain Adhoc tables, report scheduling Test and promote dashboards and reports.
  • Identify key insights ensure integrity, timing, and accuracy of results

Environment: IBM Netteza, Aginity workbench, Red Hat Linux, JIRA.

Confidential

  • Coordination on designing and deploying Cubes and reports for all environments.
  • Team coordination handling offshore and onshore teams, Scrum meetings.
  • 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.
  • Experienced in Project Management tools such as JIRA, Microsoft Excel, SharePoint, Clarity and using Agile.
  • Troubleshooting and being accountable to application end users
  • Quickly guide the team and resolve any technical issues that come during various phases of development.
  • Team coordination handling offshore and onshore teams
  • Interacting and coordinating with different teams during various stages of development and post production.
  • Manage Scrum meetings.
  • 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.
  • 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 implement SSAS Cube and SSRS reports
  • Report design, drill through reports using OLAP cube features
  • 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: MSBI 2008, MS SQL 2008, Windows 2003 Server, JIRA, Clarity, Agile

Confidential

Role: OBIEE Administrator / Developer Duration:

  • 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
  • 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.
  • Worked with software vendor for upgrade issues, enhancements, fixes and troubleshooting
  • New system is pretty stable and resolved every issue with upgrade, enhanced system availability, integrity and confidentiality.
  • Performing weekly, monthly and yearly activities such as archiving, User Security etc.
  • Developed new Cubes as per Business requirement and optimized cube performance.
  • Provided end-user system training 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 OLAP cube features
  • RPD repository development and deployment, interactive dashboard design
  • Security implementation, administration, troubleshooting, and RPD migration
  • Maintain security in Weblogic environment.
  • Installation and configuration of Tableau Server and Desktop
  • Report and dashboard design and Implementation.

Environment: Oracle BIEE 11.1.1.7, Oracle 11g, Windows 2003 Server, Tableau 8.0

Confidential

Role: Report Analyst.

  • 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 flexfields, descriptive flexfields, 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.
  • organization 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 location in different parts of globe such as India, NA, and UK.

Environment: Oracle E-Business Suite R12, Oracle 10g, Linux ES 5

Confidential

Role: Hyperion Consultant

  • 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 training 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

Confidential

Role: Hyperion Administrator Duration

  • Involvement in the New Implementation and development of Hyperion Solution at the customer's work place.
  • Design the metadata and data flow across the different Hyperion products in the environment.
  • Involvement in tuning the parameters for optimum performance of the system which includes creating aggregation views to speed up the web analysis reports, tuning calc scripts etc.
  • Quickly guide the team and resolve any technical issues that come during various phases of development.
  • Requirements gathering from the requirements team.
  • 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 training 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 PGS Hyperion Planning application. User acceptance Testing UAT, System Integration Testing SIT activities.
  • 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.
  • User acceptance Testing UAT, System Integration Testing SIT activities.
  • Interacting and coordinating with different teams during various stages of development and post production.
  • Documentation of various project specific phases and delivery of critical documents to client.
  • 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
  • Provided technical Support for Oracle- Hyperion Essbase and Hyperion Enterprise 6.0 with clients spread all over Europe, US, EMEA and APAC as a part of Hyperion Worldwide Support.
  • Supported Financial System of IMP involving Net Revenue Reporting, Gross Revenue Reporting, Cash Flow and Balance Sheet, Liquidity reporting etc. Actual, Forecast and Budget data
  • Backup of development and production server.
  • Developed several excel templates
  • Implemented application security process, created users/groups, security profiles and application access to different groups using filters.
  • Trained new users on the Essbase system and Reports, and Essbase Add-In
  • Install Hyperion shared services and configure users with security provisioning
  • Migrating user, filters, applications and databases.
  • Upgrading client machines to new versions.
  • 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
  • Used Shared Services 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.
  • Document Hyperion system processes and responsible for complete system documentation and training materials.
  • Provided training to end users in using the MS Excel spreadsheet add-in to load data and the basic concepts of multidimensional databases.
  • Involved in building an outline and assigning descriptive alias name to members.
  • Extensively involved in Essbase Administration activities such as filter creation, creation of users, and creation of groups and maintenance of Essbase Servers.
  • Provided 24/7 Essbase technical supports to all business units of Essbase / Reports / Enterprise, offered suggestions and proposed solutions to resolve issues and involved in recovery and back up on NT Servers.
  • Involved in performance tuning, backup and recovery of cubes.
  • Involved in system upgrades and client installations based on users requirements.
  • New user desktop installation and tracking Hyperion licenses

Environment: Hyperion BI 9.3.1.0, Windows 2003 Server, Veritas Cluster Server, VMware Server.

Hire Now