Aruna Sekar Email & Phone Number

Burlington, On, Ca

Toronto, Canada Area

Chennai Area, India

• Experienced in interacting with business users to analyze business processes, requirements and translating them into applications.• Hands on experience in designing and deploying a real time BI system that involved License • Installation / Configuration/ Upgrade/ Performance tuning/ Load balancing and Capacity Planning for the enterprise BI Architecture.• Experience in BusinessObjects XI R2 to 3.1 SP5, XI4.0, XI4.1 upgrade and creation of repositories with user groups, security… Show more • Experienced in interacting with business users to analyze business processes, requirements and translating them into applications.• Hands on experience in designing and deploying a real time BI system that involved License • Installation / Configuration/ Upgrade/ Performance tuning/ Load balancing and Capacity Planning for the enterprise BI Architecture.• Experience in BusinessObjects XI R2 to 3.1 SP5, XI4.0, XI4.1 upgrade and creation of repositories with user groups, security implementation, scheduling, universe and reports migration. • Experienced in SAP Business Objects Administrator related activities like Security management, Object management, Report scheduling, Instance management, Structured content promotion, Repository Migration, BO Auditor, BO Server Administration, shared and distributed repositories, • Clustering, configuration, Deploying BO Apps and Webservers.• Proven abilities in project migration to various environments, setup DB connectivity to various environments, performance issues fix and troubleshooting, adhere to security requirements, patching & bundles • with sandbox testing, • Strong problem–solving, communications and leaderships skills with evidence of success in leading at multi-vendor environment onshore and offshore model interfacing with key business units including finance, operations, HR and consulting with customers. • Establish the team by training /mentoring existing team and attracting right talent. Conduct/ Participate in monthly governance meeting with client management team to discuss status, risks, quality key metrics, scope and capacity planning. Show less

Chennai Area, India

o Responsible for Requirements gathering and analysis.o Coordinating with onsite on Requirements clarifications.o Analyzing Technical specifications that are needed to design the universe for developing static and Ad-hoc reports. Impact analysis on the existing functionalities. Preparation of Technical Design documents/ Response documents. o Designed Data Foundation layer in the Universe according to the user requirements. Added new database tables to the universe, resolving loops… Show more o Responsible for Requirements gathering and analysis.o Coordinating with onsite on Requirements clarifications.o Analyzing Technical specifications that are needed to design the universe for developing static and Ad-hoc reports. Impact analysis on the existing functionalities. Preparation of Technical Design documents/ Response documents. o Designed Data Foundation layer in the Universe according to the user requirements. Added new database tables to the universe, resolving loops, and then creating the classes and objects. Merged Both Domestic and International Universe and delivered as a single universeo Performed End to End Testing of Universe as part of deliverables. Responsible to perform Peer testing of BO reports. Co-ordination with Business users as part of User Acceptance testing.o Implemented Row level security using data profiling. Involved on Performance improvement of the BO Reports.o Participating in regular status meetings and prepared weekly reports on the status of the application. Handled Knowledge sharing sessions to new team Members.Tools: SAP BOXI 4.1, Informatica 9.1,Oracle 11g Show less

Chennai

• Worked as Technical Lead and responsible for delivery of project in all aspects to client. Handled a team of 5 members and executed the project in Onsite-Offshore and Agile model• Analysis of scalability issues surrounding application servers and middleware communication• Oracle scripts Performance tuning - Increased the load performance, Data Model Change so that the reports are created with high performance , SQL scripts tuning, changed the stats collection method• Implemented… Show more • Worked as Technical Lead and responsible for delivery of project in all aspects to client. Handled a team of 5 members and executed the project in Onsite-Offshore and Agile model• Analysis of scalability issues surrounding application servers and middleware communication• Oracle scripts Performance tuning - Increased the load performance, Data Model Change so that the reports are created with high performance , SQL scripts tuning, changed the stats collection method• Implemented Row level Security and Column masking using Oracle policies and inbuilt packages• Planned and executed Disaster recovery for the project.• Involved and coordinate with business on requirements gathering and User acceptance testing.• Database schema design and dimensional Modeling.• Involved in Physical, Logical data modeling which is used to build business Objects Universe.• Co-developed coding standards and best practices for development.• Involved in Design, Coding, Unit testing, System testing, UAT Coordination with business and deployment to production environment• Worked closely with QA to enhance Quality and prepared various documents like HLD, LLD, Data model document, System testing.• Provided 24/7 support for application including load monitoring and met SLA on incidents/problems and changes Show less

Chennai Area, India

o Responsible for the requirement analysis, design and Estimation of Service Enhancement Requests. Coordinating with onsite on Requirements clarifications.o Preparation of Technical Design documents/ Response documents. Impact analysis on the existing functionalities. Responsible for enhancement of Universe and Webi reports.o Developed complex Ad-Hoc reports based on the requests from Business and providing the data model functionalities to the new users.o Performance tuning of… Show more o Responsible for the requirement analysis, design and Estimation of Service Enhancement Requests. Coordinating with onsite on Requirements clarifications.o Preparation of Technical Design documents/ Response documents. Impact analysis on the existing functionalities. Responsible for enhancement of Universe and Webi reports.o Developed complex Ad-Hoc reports based on the requests from Business and providing the data model functionalities to the new users.o Performance tuning of Universe and Reports to improve the report/query refresh time. Effectively coordinated with Business for Adhoc queries. Solid experience in using Remedy tool for creating Incidents, Problem tickets and Change Requests.o Addressing incidents and providing the resolutions within the time of SLA. Effectively coordinated with the third party teams in resolving the issues. Unit Testing – Preparation of Unit Test Scripts and Unit Test Logs, Coordinating with SIT team on System Integration Testing. Providing UAT Support on the new changeso Experience in using Star Team Configuration management tool for version control.o Responsible for Business Objects Admin activities such as access management, server monitoring. Also created batch files for automatic weekly restart of the BO servers. Responsible for the Migration of Universes and Reports across the environments. Automation of BIAR backup on a weekly basis to restore the deleted/modified objects from the repository.o Performed Scheduling on Business objects reports using events (File based & Schedule based) to run on 10th working day of a month. Involved in BOXI3.1 SP3 to BOXI3.1 SP5 upgrade.Tested Disaster Recovery implementation in our environment. Enabled Auditing Database in Business Objects in order to trace the user log information. Built Audit reports as per the user request. Handled Knowledge sharing sessions to new team Members.Tools: SAP BOXI 3.1, Oracle 10g, Informatica 8.6.1 Show less

Chennai Area, India

o Responsible for the requirement analysis, design and Estimation of Service Enhancement Requests. o Coordinating with onsite on Requirements clarifications.o Impact analysis on the existing functionalities. Worked in Autosys scheduling tool for scheduling Informatica jobs. Developed complex Ad-Hoc reports based on the requests from Business and providing the data model functionalities to the new users.o Performed End to End System testing of Business Objects Reports and… Show more o Responsible for the requirement analysis, design and Estimation of Service Enhancement Requests. o Coordinating with onsite on Requirements clarifications.o Impact analysis on the existing functionalities. Worked in Autosys scheduling tool for scheduling Informatica jobs. Developed complex Ad-Hoc reports based on the requests from Business and providing the data model functionalities to the new users.o Performed End to End System testing of Business Objects Reports and Universe.o Coordinating with Business Users for UAT Support. Coordinating with Third party teams for any Infrastructure issues.o Handled Knowledge sharing sessions to new team Members.Tools: SAP BOXI 3.1, Oracle 10g, Informatica 8.6.1 Show less