Summary Experience

Over 9 years of experience in Development, Testing & Implementation of Business applications. Have strong foundation of Object-Oriented Programming, GUI and RDBMS concepts with excellent analytical and problem solving skills. Possess strong verbal/written communications and presentation skills. Has expertise in the development of projects, Client/Server technologies, Coding and Debugging.

Education:

Post Graduation Diploma in Computer Applications

Certification/Trainings:
Oracle Business Intelligence Enterprise Edition plus & Essbase technical hands on workshop
Oracle Hyperion Essbase 9 certification.
IBM Certified TM1 Developer

Languages: Sql, Pl/Sql, Java 2.0, C

Databases: Oracle 10g, Sql Server 2000/2005, Ms Access

Tools / Utilities: Cognos TM1 9.5,Oracle Business Intelligence Enterprise Edition (OBIEE) , Oracle BI Publisher, Hyperion Essbase 9, Informatica 8.6, Oracle Discoverer, Crystal Reports 8.5/9, Sql Reporting Services, Developer 2000, Visual Basic 6.0/5.0

Web Technologies: HTML, JavaScript, VBScript, ASP, PHP, XML

Multimedia tools: Macromedia Dreamweaver, Macromedia Flash, MS Office 2007

Operating Systems: Windows XP/2000/2003/Vista, Linux

WORK EXPERIENCE:

Confidential,Oct 09 – Till Date

TM1 Developer

• Participated and Analyzed requirements with Business Users and Business Analyst.
• Built TM1 metadata objects, such as Cubes and Dimensions, using Turbo Integrator.
• Used TM1 Rules functionality to implement complex business, financial and operational rules.
• Used Turbo Integrator to connect to various sources, such as flat files or ODBC connections to Oracle or SQL Server for uploading and updating existing financial data into TM1 multidimensional cubes.
• Built Budgeting Input worksheets as well as business financial statement reports using TM1 and Excel functionality.
• Designed Security for applications at User role level.
• Designed and Implemented JOE, Spend plan and Master budget process.
• Sliced the data according to customer reporting needs and analysis.
• Created chores and processes for dimension and data loads using Turbo Integrator.
• Provided training to users and prepared documentation.

Confidential, Oct 08 – Sep 09

TM1 Developer

• Worked closely with Business Users and Business Analyst and participated in preparing requirement specifications.
• Created chores and processes for dimension and data loads using TI.
• Created dimension elements, calculated elements and cubes.
• Used Rules for calculations, sharing of data between cubes.
• Designed Security for applications at User role level.
• Diced and sliced” the data according to customer reporting needs and analysis.
• Designed and Implemented Budgeting and Forecast process.
• Provided system maintenance using Turbo Integrator and TM1 Rules.
• Provided training to users and all appropriate levels of management.
• Built Budgeting Input worksheets as well as business financial statement reports using TM1 and Excel functionality.
• Used TM1 web to upload all budgeting and forecasting input reports as well as other reports, providing the client the ability to access the application regardless of their location.

Confidential,DC Oct 07 – Sep 08

Oracle discoverer and OBIEE Consultant

• Worked closely with Business Users and Business Analyst and participated in preparing requirement specifications.
• Created and Modified Existing reports according to client requirements.
• Created and provided access to the Business areas, Folders and Work Books.
• Created Simple and Complex joins Conditions, Totals and Percentages
• Scheduling the daily data loads and reports.
• Display the reports in SharePoint portal.
• Created Repository in OBIEE using the Admin tool taking oracle as the data source.
• Used the Security settings in Admin Tool to set up users, groups, access privileges and query privileges.
• Worked extensively on Answers, used the Subject Areas, Filters, Charts, Tables and Drill-downs for effective querying and reporting.
• Configured Repository and session variables to get dynamic reports and dashboards
• Worked with dashboards, dashboard prompts, Repository and session variables to get dynamic reports
• Created some preformatted reports using the BI Publisher.
• Assisted in Testing and Documentation.

Environment: Windows 2003, Oracle Discover Admin/Plus 10g, SharePoint, OBIEE 10.1.3.3 with BI Publisher, Informatica 8.6

Confidential,Washington, Oct 05 – Sep 07

Discoverer Admin/Developer

• Worked with Business Analyst and Key Business Contacts to translate functional and technical specifications into a comprehensive reporting design.
• Requirements Gathering, Report Specification Creation, Report Design/Develop/Test, Report Security
• Created and providing access to the End User Layer (EUL)
• Designed & created business areas, folders to meet business requirements.
• Maintained joins, hierarchies, item classes
• Created Joins, Conditions in Discoverer Admin/Plus
• Created Lov’s Item Class, Drill Down, Hierarchies, Functions and Aggregations
• Created Workbooks and provided sharing to other users.
• Created Database views and used in Discoverer
• Created Calculated Items and Simple, Complex and Custom folders
• Created Tabular, Page and cross tab reports with drill down
• Migration from 4i to 10g
• Established and maintained Discoverer security and privileges to business areas and views
• Migrated Business Areas and Work Books from Development to Test and Production Instances.
• End-User Training

Environment: Oracle Financial Analyzer, Oracle 10g , Discover Admin/Plus/Viewer 4i/10g.

Staff Consultant, Confidential,India, Jun 03 – Aug 05

Everest - "mini ERP" small business management software

Everest has been designed to accommodate the needs of both large and small businesses, which will take the enterprise to the highest level. Everest gives total control and access to everyone in the company, depending on their job position, wherever they are - in the boardroom, on a runway, behind a cash register, working from home, in front of a telephone, at an Internet cafe, in a service truck, in front of a customer, in the warehouse, at the loading/receiving dock, or on a boat.

The major customizations included: Integration of credit card payment processor with Everest Ecommerce Importing the customers information, sales orders, sales invoice from the excel file into Everest Writing triggers for sales orders, sales invoices, purchase orders, purchase invoices, stock transfers etc. Creating new reports using crystal reports etc.

Responsibilities:

• Gathered the requirements from the clients for customizations.
• Optimized queries by creating indexes and reindexing them whenever required.
• Created stored procedures to be called by the visual basic for different modules
• Wrote Database level triggers
• Worked extensively with Triggers, procedures and functions.
• Created user interface forms using Visual Basic 6.0
• Worked with ADO\'s, COM objects
• Worked with different controls like tree, Data grids, and Flex grids. progress bars etc
• Created reports using Crystal Reports 8.5 and 9
• Created different kind of reports like sub reports, mailing reports, charts, Drill down reports
• Worked extensively with groups, selections, formulas, charts, parameters.
• Published reports in Crystal enterprise.
• Familiar with APS, Page server, Job Server, cache server
• Created ASP pages based on the requirements.
• Tested and implemented the solutions at the clients place.

Environment: VB, Sql server, Html, Java Script, ASP, Crystal Reports