Resume of Actuate Developer

Title
Actuate Developer

Primary Skills
Actuate, Cognos, Business Objects, Informatica, SQL, PL/SQL, Oracle, MS-SQL Server, Sybase

Location
US-NJ- (will consider relocating)

Posted
Mar-24-08


Summary of qualifications
• Around 7 years of experience in Data Warehousing and Business Intelligence technologies
• Proven abilities of team handling, requirement gathering, analyzing, designing, developing, testing and implementation of small and mid-size projects
• Domain experience in Financial, Insurance and Retail verticals
• Designed different kinds of Reports in Actuate, Cognos, Crystal Reports and Business Objects
• Proficient in using Informatica PowerCenter tool to design data conversions from wide variety of source system.
• Proficient in writing stored procedures for RDBMS like Oracle, Sybase and MS-SQL Server using Third Party tools like Toad and SQLToast
• Good experience in setting up full cycle software development environment including requirements management and configuration, planning and resource management and coding and testing environment
• Have excellent analytical and communication skills, proactive, well organized, efficient, a team player and foster collaborative work environment

Education
• M.S (Computer Science), Andhra University, India

Technical and Professional Skills
Technologies: Data Warehousing/ Business Intelligence and Mainframes

Languages: Java 1.4, SQL, PL/SQL, UNIX Scripting, JCL, VS COBOL II

Database: Oracle 8i/ 9i, MS-SQL Server 2000, DB2 and Sybase11/ 12.5

Reporting Tools: Actuate 6/7/8/9 (e.Report Designer Professional, e.Spreadsheet Designer, Information Object Designer, Analytics Cube Designer, BIRT Reports, BusinessReport, iServer), Cognos ReportNet 1.1, Business Objects 6.5 and Crystal Reports 7.0

ETL Tools: Informatica PowerCenter 7.1

Other Tools and techniques: MS-Visual Source Safe, Eclipse-CVS, Toad and SQLToast


Detailed Experience

Project # 1 GPS (Global Prime Services)
Client Deutsche Bank, NY, USA
Role Software Engineer
Duration Aug 2006 -- Till Date
Deutsche Bank Prime Services is a top-tier provider of financial solutions to hedge funds and hedge fund investors globally. Global Prime Services provides daily reporting and data files for review. The Reporting pages allow you access to your reports, data files, month-end US broker statements, and current International Prime Brokerage settlement instructions. The reports and data files are available for viewing, printing, or downloading as Adobe Acrobat (.PDF) or Excel (.CSV) files.
This project is a migration of Crystal reports and JSP reports which take data from Sybase database to Actuate Reporting tool and Cognos ReportNet 1.1 which points to Oracle database.

Responsibilities:
• Analyzing the requirements with Business Analysts and Reporting Team Lead.
• Participated in client meetings to extract and document functional & system requirements.
• Attending meetings in relation to Production/ UAT status checks.
• Analyzing existing Actuate Reports and Libraries.
• Converted and re-designed existing Crystal Reports into Actuate Enterprise Reporting.
• Converted and re-designed existing JSP reports into Cognos ReportNet.
• Created AD-HOC reports using Information Object Designer.
• Created On-Line and Batch reports using Actuate eRDPro 8.
• Designed Libraries and Report Templates which is used by other reports.
• Created new reports, Master Detail Reports and Parameterized Reports using Sequential, Conditional, Group and Parallel Reports sections.
• Extensively worked on Page Level Security, Data filter, Combined Data Stream, Memory Filter, Data Sorter, Actuate Foundation Classes (AFC) and other objects.
• Created users, roles and given privileges and maintaining the report executables using Actuate Management Console.
• Involved in Actuate iServer System Monitoring & Management, Granting permissions, Access Permissions depending on the User-id.
• Development and implementation of complex Object Oriented applications using Cognos ReportNet.
• Created related models and schemas, joins, namespaces, query subjects, filters and calculated fields in Framework Manager.
• Created data sources in Cognos portal and published packages to be accessed by Report Studio, Analysis Studio, Query Studio, and Event Studio.
• Published packages to the portal to be accessed by Analysis Studio and Report Studio.
• Created/Modified MS-SQL Server Complex Stored procedures in implementing business rules.
• Successfully linked the Dashboard to multidimensional cubes and created dashboard reports utilizing Report Studio within Cognos 8 environment.
• Verified data integrity in all reports against the data warehouse.
• Heavily used TOAD for writing stored procedures and functions in Oracle 9i.
• Used SQLToast for writing stored procedures in Sybase.
• Enhanced and supported existing reports.
• Performance tuning of stored procedures in the existing reports.
• Monitoring Data load jobs using Workflow monitor.
• Fixing production related reporting issues.
• Deployed .ROX files on iServer and given the accessibility permissions and scheduling some of them.
• Systems testing/ Unit Testing & UAT.

Development Environment:
Actuate e.Report Designer Professional 7 SP2, Cognos ReportNet 1.1, Crystal Reports 7.0, Oracle 9i, Sybase, Toad, SQLToast and Informatica PowerCenter 7.1.

Major accomplishments are:
• One of the achievements in this project that clients rate very highly is the development of Actuate libraries (.ROL). These libraries were one of the major hurdles in the project and I was able to do it as required successfully. The libraries are now used throughout the project and serve as a generic template for all the reports in the project. Thus our Clients rated me very strong in Actuate reports writing as many of them have given up this task.
• Got acquainted with Actuate 9 Sp1 features including BIRT and BusinessReport


Project # 2 Factsheet Reporting
Client Deutsche Bank, Frankfurt, Germany
Role Software Engineer
Duration Jan 2005 -- Jul 2006
Deutsche Asset Management (DeAM), the asset management division of Deutsche Bank A.G., is one of the world's foremost investment organizations. They leverage on their presence in key major investment markets and on the expertise of more than 360 portfolio managers and analysts across the globe in the service of our clients. FIX XP provides daily reporting and data files for review. For production of Factsheets, Actuate has been selected as appropriate tool. The generation of .PDF files takes place on Actuate iServer and generated Factsheets may be archived anywhere on the net-work. For administrative reasons, Factsheets will be archived on the server. Administration of Factsheet reporting is accomplished using FIS XP.
This project is a development of Factsheet Reports with Actuate e.Report Designer Professional 8 SP2 and MS-SQL Server as Database and PlausiCheck Reports using Information Object Designer

Responsibilities:
• Creating and Managing users and roles at Actuate level.
• Monitoring of management console activity.
• Gathered specs, designed, developed and documented new report.
• Developed Driver reports that executes all other reports.
• Developed Custom libraries, which can be reusable with other reports.
• Developed Bursting report which generates reports for different regions.
• Coded common routines to the .BAS file, which used in other reports.
• Coded Functions to dynamically reading the .ROX files based on parameters and Environment Variables.
• Designed and developed reports with Graphs.
• Designed and developed a custom library that also includes Browser Scripting controls.
• Implemented Performance enhancement based on user criteria, dynamically construct and bind Select statements with data row variables.
• Developed reports with XML as a DataSource.
• Implemented Page Level Security in the Reports.
• Experienced in using Actuate iServer Integration technology which allows external APIs, such as JAVA, to access Actuate iServer.
• Experience in customizing the Actuate Active Portal application.
• Developed reports with implementation of DashBoards in reports.
• Developed reports with eAnalysis view option. Done a coding to pass the user selection data for eAnalysis.
• Developed Cubes using Cube Designer which gives the circle wise details and that can be drill down to the single customer level.
• Developed PlausiCheck Reports using Information Object Designer.
• Created mappings with various transformations using PowerCenter Designer for data testing of the Actuate reports.
• Monitored jobs for data loading using Workflow Monitor.
• Modified existing reports to accommodate enhancements.
• Wrote and tuned stored procedures and functions in MS-SQL Server.
• Performance tuning of existing reports and new reports.
• Documentation of the scheduling process and report related processes.
• Did “continuous testing” at different levels unit, integration and system testing.
• Analyzing and solving QA identified defects.

Development Environment:
Actuate e.Report Designer Professional 8 SP2, Actuate Analytics Cube Designer, Actuate eAnalysis, Actuate Information Object Designer, Informatica PowerCenter 7.1 and MS-SQL Server 2000

Major accomplishments are:
• Accomplished 23 Actuate eRDPro reports and integrated them into Factsheet report and completed 11 PlausiCheck Reports using Information Object in 3 months.
• Fixed critical production data issues within the given timeline.


Project # 3 SmartStream's Reconciliations
Client Deutsche Bank Operations International, NY, USA
Role Software Engineer
Duration Jan 2004 -- Dec 2004
DB Operations International (DBOI), the global processing arm of the Deutsche Group; develops Operational Strategies form which they get considerable benefits by moving there reconciliation requirements across their organization into a single enterprise wide solution and benefit from the scale effects such as internal and external utilities. SmartStream's Reconciliations helps to monitor, manage and enrich transactions throughout their lifecycle, from inception to settlement, and is capable of extending the process to include external parties when required. It supports an array of reconciliations requirements, from integrated cash and securities reconciliations through to generic, inter-system reconciliations.
This project required to create Actuate reports using SmartStream Reconciliations data in Oracle database. Another module requires creating reports using Business Objects 6.5.

Responsibilities:
• Metrics Preparation and Presentation, Status Reporting.
• Design, Analysis, Coding and Testing of Platform Evolution Reports.
• Participated in weekly management meeting to communicate existing and/or future issues.
• Independently handling report development in Actuate reporting tools (eRDPro, Information Objects, eSpreadSheet, Cube Designer).
• Analyzing Actuate reports and creating analysis spreadsheet.
• Created libraries, Global functions and Standards of Actuate Reporting for SmartStream Reporting.
• Developed a Customized solution for exporting report data into Excel and Text from Actuate Report.
• Created Stored Procedures, Functions and views in Oracle9i for report generation purpose.
• Modified templates to meet user requirements.
• Modified existing reports with new reporting needs of business.
• Designed & Developed Custom Reports.
• Customized reports for filtering, grouping and sorting the report data of custom reports.
• Created cube reports for analysis using Analytics Cube Designer.
• Created Actuate e.Spreadsheet Reports.
• Developed reusable code for Actuate reports using Actuate Basic.
• Worked to resolve defects in Business Objects 6.5 reports.
• Created complex reports Business Objects 6.5 stating revenue generation per year using cascading and user objects like measure objects by using @aggregate_aware function to create the summarized reports.
• Exported the Universes to the Repository to make resources available to the users for AD-HOC reporting needs in Business Objects 6.5.
• Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount using Business Objects 6.5.
• Created complex reports using the multiple data providers and synchronized the data providers by linking the common objects to create the common report using Business Objects 6.5.
• Created different reports containing charts showing revenue and operating income by different divisions and market share using Business Objects 6.5.
• Created complicated reports including sub-reports, graphical reports, formula base and well-formatted reports according user requirements using Business Objects 6.5.
• Implemented Security Features of Business Objects 6.5 like row level, object level and report level to make the data secure.
• Performance Tuning of Reports & Procedures, Impact Analysis.
• Ensure that the project follows all Standards and Quality Guidelines during the full Project Life cycle.
• Participate in Internal code review, User Acceptance Testing, document any failures. Monitoring of installation of changes into the production environment.
• Production Support (Level 2 and Level 3) with root cause analysis and permanent fix to the problem.
• Batch Failure, Report Failure, Report Discrepancy Handling.

Development Environment:
Actuate e.Report Designer Professional 6, Cognos ReportNet 6.5, Oracle 9i and Toad

Major accomplishments are:
• Designed, developed and delivered ACTUATE 6 reports within project timeline 100% of the time.
• Created formatted Text file output reports.


Project # 4 Data Warehousing
Client Deutsche Bank, NY, USA
Role Software Engineer
Duration Oct 2002 -- Dec 2003
Deutsche Bank is a leading provider of financial solutions for private and business clients. They provide all-round service extending from account keeping and cash & securities investment advisory to asset management.
The project is migration from Sybase to Oracle Data warehousing and creating Actuate reports and schedule to generate daily updated reports and enhancements of the existing reports.

Responsibilities:
• Sybase to Oracle 9i Migration, JSP reports to Actuate 8 Migration,
• Understand the existing Sybase data warehouse and Actuate Reports and Libraries.
• Preparing technical specifications.
• Managing Quality requirements as per CMMi standards
• Independently handling reports development in Actuate eRDPro, Spreadsheet, Information Objects.
• Development of Libraries and Enhanced the existing libraries for better functionality.
• Developed smart reports using the parameters passed by the user, smart reports contain the functionalities like dynamic grouping, dynamic sorting and dynamic column selection.
• Used Multiple Input Filters and Memory Data Sorters in designing the reports for this system.
• Designed Global functions in Actuate Basic and custom components that are used for design and development of these reports.
• Development of Core reports useful for all clients.
• Deploying reports to iServer through Management Console.
• Scheduling reports and sending notifications as per the client requirement.
• Functionalities added for Core Generic Reports.
• Dynamic display of no data found when there is no data fetched.
• Dynamic Cover Page with all Parameter List and Report Name
• Added functionality for eRDPro Reports of Page Numberings according to selection of Cover Page.
• Prepared Booklet reports as per the client requirements.
• Performance Tuning of Actuate Reports.
• Interacted with Business Analyst to understand the business requirements. Designed and developed the ETL process as per the EDW (Enterprise Data Warehouse) Framework.
• Extensively used Informatica tools to load data from relational files DB2, SQL Server, Oracle, XML and flat files to the staging area.
• Designed and developed mappings using Informatica PowerCenter Designer.
• Created reusable transformations and mapplets.
• Involved in creating different mappings for loading dimensions and facts.
• Worked on various types of Transformations like Lookup, Update Strategy, Stored Procedure, Joiner, Filter, Expressions, Aggregation, Rank, Router and Sorter
• Responsible for PL/SQL procedures for processing Business Logic in the data base. Tuning of SQL queries for better performance.
• Performance tuning of Stored procedures in Sybase and Oracle.
• Extreme programming methodologies were used in the development phase of the project.
• Involved in the testing like Unit testing, fixing bugs for problems in QA testing and moved application to QA.

Development Environment:
Actuate e.Report Designer Professional 7 SP2, Oracle 9i, Sybase, Toad, SQLToast and Informatica PowerCenter 7.1.

Major accomplishments are:
• Researched and resolved Informatica jobs which involved the process of data being extracted from data warehouse or Source Data and splitting into data files, uploading of data files into data mart tables such as catalogs and cubes and final destination of being queried by SQL command or PL/SQL for Actuate Reporting.


Project # 5 Data Warehousing and Reporting
Client Blue Dart Express Ltd, India
Role Software Engineer
Duration Mar 2002 -- Sep 2002
Blue Dart Express Limited. The Group's principal activity is to provide air and ground transportation and distribution of time sensitive packages. The Group offers integrated transportation and distribution of shipments through its network of 227 offices. It operates in 14,400 locations in India and 210 countries worldwide. The Group has a fleet of 5 Boeing 757 aircrafts.
This project included the creation of historical Data Warehouse in Oracle, Actuate report development, Analytics Cube designing, Dashboard presentation, Portal customization and Server integration with External Security Mechanism. It involved reporting scattering to all the areas of Logistic domain.

Responsibilities:
• Requirements gathering and documentation.
• Involved in designing, development, testing & implementation of Actuate reports.
• Also customized existing Actuate reports.
• Object Oriented Programming concepts and techniques were used in the design and development of this Actuate reporting system.
• Designed forms to be used in the system.
• Created reports using Sequential, Conditional, Group and Parallel Reports sections.
• Creating the reports, those runs on Multi Database systems.
• Creating Libraries with Reusable Custom components for exporting report data to flat file, multi database connections etc.
• Responsible for developing the modules involving the contract people and invoicing.
• Developed reports having special functionality of creating, updating and deleting temp tables in the database.
• Responsible for writing the options module where the preference for each user to be specified.
• Responsible for integration of the entire system.
• Developed a Smart report that uses dynamically selected groups, columns, sorting order and user-defined SQL.
• Designed Actuate Reports using Flat files that are provided by different branches.
• Designed default Actuate Report templates.
• Designed and customized the reports
• Deployed Reports on Actuate Report Server.
• Developed complex Queries / Stored Procedures to handle most of the business logic.
• Modified existing stored procedures to increase the performance of the Actuate reports.

Development Environment:
Actuate e.Report Designer Professional 6, Oracle 8i and Toad.

Major accomplishments are:
• Researched and learned Actuate 6 on job and completed reports and Integrated them in given timeline.


Project # 6 Omni Station (Omni Plus)
Client Mellon Bank, Canada
Role Software Engineer
Duration Sep 2001 -- Feb 2002
Omni Plus is a Sun Guard latest product that deals with 401(k) plan of the retirement benefits for employees. Mellon Human Resources and Investor Solutions uses Omni Plus to administer its defined contribution retirement plan business. The Project deals with converting 40 plans which are based on age old Omni plan to Omni Plus.

Responsibilities:
• Developing & Modifying COBOL, Omni Script, VSAM related programs
• Preparing JCL's for test runs and Manual testing

Development Environment:
OS/390, COBOL, JCL, VSAM and Omni Script


Project # 7 Intranet Purchase Management System
Client CDAC, Thiruvananthapuram, India
Role Software Engineer Trainee
Duration Jun 2001 -- Aug 2001
CDAC is a Research and Development organization of Government of India. The Project maintains a complete product catalog based on product type that lists all assets owned by the organization. Maintain a group of vendors for any product along with price. Create Purchase orders for a vendor and automatically convert PO items into assets. Keep track of outstanding POs and completed purchases. Query from a searchable database of POs and Analyze purchasing trends to leverage negotiations with vendors.

Responsibilities:
• Developing COBOL and DB2 programs
• Preparing JCL's for test runs
• Manual testing -- Test Plans & Test Reviews

Development Environment:
OS/390, VS COBOL II, JCL, DB2

Certifications
See above


You must be logged in and have a current resume access subscription. Login or Register »

View all resumes in US-NJ »

View other Actuate Developer resumes, Programmer / Developer resumes