Actuate On-site Lead Resume
Chicago
SUMMARY:
- More than 8 years of I.T. experience including 5 years of Actuate development experience.
- Proficient in SQL scripting and stored procedures.
- Familiar with the Onsite - Offshore model.
- Energetic self-starter with excellent analytical, organizational and problem solving skills.
TECHNICAL SKILLS:
BI products: Actuate 7/8/9, Cognos ReportNet, Business Objects 6.5.1
Platforms:: AIX 5.2, Unix, Windows XP Pro/Server 2000
Scripts/Languages:: C, Java, SQL, Shell scripts, Java script, JSP, HTML, XML
Database:: DB2 UDB v8.1, SQL Server 2000, Oracle 9i, Sybase ASE 11
Tools:: Allfusion Harvest 7.1, Rational ClearCase, DbVisualizer 5.1.1, TOAD, Confidential Maximo 7
Web servers:: WebSphere 5.1/6.0
s: Cognos ReportNet Authoring Product Professional
WORK EXPERIENCE:
Confidential, Chicago, IL
Actuate On-site Lead
Responsibilities:
- Managed a three-person offshore development team.
- Worked with the Application TL and BA to understand business requirements, develop high level report designs, mockups and PoC’s and to design the underlying database tables for the reports.
- Developed a Project Plan for project estimation and tracking.
- Reviewed the Technical Design Documents and Unit Test Cases prepared by the offshore team before getting the sign-off from the Application team.
- Performed Actuate code reviews once report development was completed.
- Maintained the code repository on Harvest and coordinated with the Application, Offshore and Deployment teams to push the reports from Dev to ITE, CTE and Production.
- Setup Autosys job schedules throughout the SDLC.
Confidential, Boulder, CO
Actuate Programmer
Responsibilities:
- Developed functional specifications and solution reviews by working with the customer and account focals.
- Designed, developed and maintained reports, information objects and spreadsheets. A variety of complex reports were designed using advanced Actuate features like BSC, database filters and sorters, advanced charts, and dynamic formatting.
- Functioned as the Reporting Team Lead for the Managed Security Services unit which supports over 200 external accounts. Developed automated drivers to schedule reports based on data availability.
- Maintained the Actuate MSSD volume on the production server.
- Wrote SQL and stored procedures on DB2 during report development.
- For Service Requests, proactively managed the entire SDLC from Requirements through UAT. Setup TWS job entries to schedule the report objects.
- Developed Workorder Tracking and Purchase Order reports for Maximo using Actuate eRD Pro v8.
Confidential, Clark, NJ
BI Specialist
Responsibilities:
- Developed reporting solutions for multiple projects using the Actuate, Business Objects and Cognos platforms.
- Responsible for the design of new reports, enhancements to existing reports, implementing information delivery systems, mentoring reporting teams and troubleshooting. Actuate reports were developed using advanced charting techniques such as embedding Excel charts.
- Wrote technical specification and design specification documents.
- Developed stored procedures on Oracle and Sybase for the reports being designed.
- Performed Actuate server administration tasks such as creating and maintaining volumes, backups, etc.
- Developed complex reports using BO WebIntelligence with crosstabs and multiple sections.
- Designed and published packages using the Cognos Framework Manager.
- Developed reports using Cognos ReportNet Query Studio and Report Studio.
Confidential, Philadelphia, PA
Actuate Developer
Responsibilities:
- Closely involved with the requirements gathering process and responsible for creating business requirement documents.
- Developed business reports using the Actuate 7 reporting platform.
- Responsible for the creation of new reports and enhancements to the existing ones.
- Wrote stored procedures and database queries to generate data for the reports being developed.
- Handled the reporting team’s helpdesk and worked with the end users to resolve issues.
- Responsible for the day to day maintenance of the reporting environment including adding and deleting users, scheduling reports, managing security permissions, etc.
- Performed unit testing on the reports to check for data inconsistencies as well as formatting problems.
Confidential, Piscataway, NJ
Consultant
Responsibilities:
- Handled the helpdesk and was responsible for entering and handling tickets for all computer related issues across the organization.
- Responsible for the installation, maintenance and administration of several Windows and Linux servers.
- Developed various types of reports to determine the nature of web traffic through the enterprise domain based on firewall logs.
Confidential
Systems Engineer
Responsibilities:
- Worked in the capacity of a Support Engineer on the DSSP project. It involved interacting closely with Unisys’ engineers to quickly resolve Operating System issues (Maintenance Requests) reported by their customers and occasionally to enhance existing features (Change Requests).
- Worked as a Team Lead on the SMM project. It involved developing a set of Perl scripts to migrate from the ‘Sendmail’, ‘SUNOne’ and ‘Netscape Mail’ platforms to the iPlanet Messaging system.
- Wrote freehand SQL and stored procedures for SQL Server and Oracle databases.
- Provided to the marketing team on the iPlanet software suite.