Business Objects, Crystal Reports, Oracle, Sql Server, Lawson, Kronos resume

Resume

Business Objects, Crystal Reports, Oracle, Sql Server, Lawson, Kronos

Posted by:	Sai M
Posted date:	8/3/2009
Contact Info:	********@*.* * * **** Show Contact Info
Country:	United States
State:	Missouri
Email:	gvme9x@r.postjobfree.com

Resume Text:

SUMMARY:

• Over Six years of software development experience, working in all phases of the project life cycle.
• Excellent experience in Data Warehouse Design with Business Objects XiR2/R1/6.x/5.x, Good Knowledge on InfoView Portal / Dashboards, Datastage, PL/SQL, Stored Procedures, Performance related transactions.
• Well versed with Normalized Star-Schema & Snowflake Schema for designing the Data Marts.
• Extensive knowledge in Business Objects Full Client & Thin Clint environment.
• Extensively involved in Managing Repositories, Connections, Creating and managing users/groups, Assigning Resources to Users, Importing/Exporting Documents.
• Strong testing and debugging skills and knowledge of ETL procedures and strategies to extract data from different source systems.
• Strong experience in performance tuning Crystal Reports, WebI Reports, SQL and PL/SQL.
• Familiar with three-tier client/server development architecture and distributed Computing architecture.
• Possess a thorough understanding of structured software methodology from requirement specification to Testing and Implementation.
• Robust record of success in achieving complex objectives and timelines.
• Excellent communication, interpersonal, analytical skills and ability to perform alone and as part of team.

TECHNICAL SKILLS:

Business Intelligence Tools Business Objects 4.x/5.x/6.x/XI R2(Designer, Reporter, Supervisor, CMC, Business View Manager, Web Intelligence, Broadcast Agent Server), Crystal Reports 8.5/9/10/XI, Xcelsius, Erwin, DataStage
Database Oracle, SQL Server, MS Access
Data modeling Star-Schema, Snowflake
GUI Visual Basic, FrontPage
Programming Languages C, C++, SQL, PL/SQL, FORTRAN
Web technologies HTML, XML, VB .NET
Testing Tools Test Director, Mercury Quality Center
Operating Systems Windows 98/NT/2000/XP, UNIX
Applications LAWSON, KRONOS
Other Tools & Utilities TOAD, CVS, APPWORX, Peregrine, Maximo, SharePoint

PROFESSIONAL EXPERIENCE

Sisters of Mercy Health System, St. Louis, MO Jul ’05-Jun ‘09
Business Intelligence Analyst/Developer

Sisters of Mercy Health System is a leader in Patient Care, Medical Education and Research. Information Technology is a key enabler of activities to improve Mercy’s Clinical and Business processes. To better support Mercy, the Mercy Information Services Division (MISD) completed a comprehensive reorganization which included consolidating all Co-Workers into a single operating structure. The change has created a centralized structure and the goal is to improve safety, clinical outcomes and customer service for patients and improve work environment for Co-Workers and Physicians.

Responsibilities:

• Co-ordinate Business Analyst’s interaction with Customers and Users to gather report requirements.
• Convert Business specifications to Technical Specifications.
• Map Report Columns in Functional specifications to Fields in the database.
• Create and maintain views, functions, and stored procedures.
• Design, Develop delimited extract files using Sql Queries, Views and format the delimited files using functions for Interfaces used by Legacy Systems.
• Design and Develop Crystal Reports using Views and Stored Procedures as sources for Lawson HR, Finance, Supply Chain Modules and Kronos time records.
• Develop Crystal Reports using complex formulae, sub-reports, on-demand reports and link to other Crystal and Enterprise WebI reports using opendocument function.
• Design Security for Crystal XI Reports using Business Views.
• Performance tune the Crystal Reports and Views.
• Design and Develop Universes using tables, derived tables, views, materialized views and building contexts and aliases to resolve loops and handle security for WebI reports through Universes.
• Design and Develop Custom WebI Reports using Multiple Data providers in Cross Tab, Master Detail and Tabular format.
• Convert Cognos cubes to WebI reports using drill by, drill down and drill through in Business Objects.
• Maintain Crystal Xcelsius Dashboards designed using QAAWS and Oracle Materialized Views.
• Troubleshoot issues in Live-Office with WebI Reports.
• Develop Lawson Smart Notifications for HR, Finance and Supply Chain Subject Areas.
• Automate Lawson Back Office Report Bursting by overriding schedule times using Stored Procedure in underlying Lawson Business Intelligence tables on Sql Server.
• Troubleshoot issues by looking at logs on Sql Server for Lawson Back Office Report Bursting and Maintain schedules through Sql Server Enterprise Manager.
• Good knowledge of Lawson ERP table structure and relationships (Finance, Supply Chain, HR)
• Good knowledge of Kronos tables, views and their relationships.
• Exposure to Lawson Business Intelligence Portal to publish Crystal Reports.
• Publish Crystal reports to Business Objects Enterprise and maintain the reports.
• Maintain custom WebI reports and Adhoc reports on Business Objects Enterprise.
• Change CMC, Page Server, Cache Server and Report Server settings to optimize parameter value population and report performances on Business Objects Enterprise.
• Unit test the developed Reports to ensure reporting standards and data validation.
• Document the Development, Testing and promotion procedures.
• Provide Production Support.

Environment: Business Objects XI R2, Crystal Reports 10, Crystal Reports XI, Data Stage, AppWorx, Java, Lawson ERP, Kronos, Lawson Business Intelligence, Lawson Smart Notes, Oracle 10g, MS Access, Erwin, Mercury Quality Center, Toad, Windows XP, UNIX

RalCorp Holdings Inc., St. Louis, MO Jan ’05-Jul ‘05
Business Objects Analyst/Developer
Ralcorp Holdings, Inc. through internal growth and strategic acquisitions has emerged as a leader in private label, or store brand, foods. Ralcorp produces a variety of foods sold under the individual labels of various grocery, mass merchandise and drug store retailers throughout the United States and Canada.
Responsibilities:

• Interacted with Business Users, Business Owners to know their Business views in developing and modifying Universes and Reports accordingly
• Involved in the designing and Building of Universes, Classes and objects.
• Designed developed, maintained and tested universes for supporting Ad hoc and canned reports and implemented advance features such as aggregate awareness, context, etc.
• Migration of Universes and Reports from development, test to production.
• Created Cardinalities, Contexts, Joins and Aliases for resolving Loops and checked the Integrity of the Universes
• Organized data in the reports by using Filters, Sorting, Ranking and highlighted data with Alerts. Extensively used Supervisor Module for Managing user groups and users
• Created various geographical and time dimension reports of Fiscal Year, Quarter, Month, week and daily reports for all Domains and published through Web Intelligence
• Designed, developed and tested the reports based upon data generated by enterprise transaction, financial, and customer information systems using Business Objects 6.x connected to Oracle 8i data source
• Scheduled reports using Broadcast Agent (BCA) and implemented Report Bursting.
• Migrated Full Client reports, webi reports & Universes from version 5.x to 6.x.
• Involved in training the end user in basic and advanced Ad Hoc reporting as well as create queries, format results, and share them with others within the enterprise and beyond using Web Intelligence.
• Retrieved and Published Documents from and to Corporate Repository respectively.
• Scheduled and Distributed the Documents through Broadcast Agent Server.
• Maintained the Repository (i.e., Security, Universe and Document Domains).
• Created Adhoc Reports According to the user requirements.

Environment: Business Objects 6.x, Broadcast Agent, WebI, Data Stage, Java, oracle 8/9i, MS Access, Erwin, XML, Test Director, Toad, Windows XP, UNIX.

Indiana State University, Terre Haute, IN Jan ’02-Oct ’04
Graduate Student Assistant

Worked as a Graduate Student Assistant at the Math & Computer Science Department. The following were my responsibilities:

• Worked as a Computer Lab Assistant.
• Helped students in C & Visual Basic Programming Languages.
• Assisted Students with SQL to Practice against Oracle Database.
• Tutored Math to Undergraduate students.
• Designed Interaction Manager Client application to schedule meetings and events in organization with ease as thesis project using VB .Net.

MxSecure Technologies Pvt. Ltd., India Jun ’00-Aug ‘01
Software Programmer

MxSecure is an organization, which have comprehensive suite of Enterprise Application Solutions covering all stages from pre to post-implementation and Reporting. The project involved extraction of information from ERP system, providing timely and accurate production reports to territory managers by streamlining the custom reporting process.

Responsibilities:

• Interacted with Business Users to identify key dimensions and measures for Business performance.
• Responsible to create and run queries against PeopleSoft Data Marts
• Participated in PeopleSoft Interface team tasked with assisting in the creation of SQR’s to transfer information to new Benefits Vendors.
• Generated reports using Cognos Impromptu and Power Play.
• Created customized reports linking various databases to meet the user requirements.
• Provided web based reports of the current and future needs based on the information received from the transactions in the Data warehouse.
• Converted Cognos reports to Business Objects reports.
• Involved in Performance Tuning and Optimization Techniques

Environment: PeopleSoft, Oracle, Sybase, Data Stage, Cognos, Business Objects, Sql, PL/SQL, Toad, PVCS, Java, Sun Solaris 7.0, Windows NT/2000

Education:

Masters in Mathematics and Computer Science – Indiana State University, IN

Contact this job seeker

Similar resumes:
warehouse - 6450
java - 2627
medical assistant - 7513
sharepoint - 725
java developer - 1076

Similar jobs:
warehouse - 805
part time - 5306
customer service - 5365

Jobs vs Resumes

Support

PostJobFree

Become
a
Premium
Recruiter

$20/month