SUMMARY:

• Innovative, accomplished Software Professional with nine plus years of experience working with top - tier clients in the Financial, Telecom, Insurance HealthCare fields in the U.S
• Partners with cross-functional teams to drive complete business solutions, offering expertise in system analysis, design, coding, testing, and implementation
• Hands-on experience in application development; application and systems management / engineering application / systems integration; and software development life cycle
• Worked on Actuate 5.2, 7,8 and 9 versions of Actuate erdPro
• Worked on Eclipse an Open source Technology and on Eclipse IDE with different Perspectives (BIRT,Java,J2ee)
• Developed Reports in Business Intelligence and Reporting Tool (BIRT) and deployed the .rptdesign files to the Actuate iServer and generated the .rptdocument files
• Wrote PL/SQL programs to write stored procedures, Functions, Packages
• Worked on Maximo 6.2 Application for Asset Management Reports like Work Orders, Inventory, Purchase Orders, Equipments, Equipments and Service Contracts for Different Products
• Familiarity with Maximo 3-tier Business Architecture. (Maximo JSP pages through I.E., Maximo Business Objects, and Data Layer (Oracle Sever/Database or Sql Server)
• Worked on Microsoft (MSBI) ETL tools like SSIS and Oracle Warehouse Builder (ODI).
• Familiar with Cognos Report net and Business Objects(universes)
• Worked on Scheduler Autosys
• Proficient in T-SQL queries using Store Procedure, Dynamic SQL, joins, Views, User defined functions, Cursors, DCL,DML and DDL
• Proficient in Performance Tuning of SQL query.
• Good experience in developing reports BIRT(Business Intelligence and Reporting Tool), SAS 9.3 and 9.4
• Excellent in MS SQL Server   2012   suite of products like SSRS and SSIS
• Knowledge of Erwin Tool for Data modelling, Star Schema and snowflake schema.
• RDBMS and Dimensional modelling(Fact and dimension tables)
• (Writing scripts for generating tables using 3n Normalization process.)
• (Imon and Kimball methodologies)

TECHNICAL SKILLS:

Languages: Object Oriented, Java 2.0, Structured, PL/SQL

Operating Systems: Windows NT/2000/XP/Vista, Windows 2000/2003 Server, UNIX

Web Related: HTML, DHTML, VBScript, JavaScript

ETL Tools : Informatica,ODI,Datastage.

RDBMS: Oracle9i/8i, SQL Server 2005/2000, DB2

Software Tools & Applications: MS Office Suite, Developer 2000, MS Project, MS Visio 2000.

Reporting Tools: Actuate (Erd Pro & E-spreadsheet designer), BIRT 2.2,Cognos Report net, BIRT 3.7,SSRS

Software Engineering: SDLC on Rational Rose, Visio & Data Flow Diagrams, Sequence Diagrams

Testing Tools: Test Director, Win Runner, QTP, Load Runner, Scripting JavaScript, JSP, XML, and HTML, Java, J2EE

Applications: Callidus True Comp Manager, Siebel.7.5 ICM, CA Clarity, Maximo 6.2, Eclipse

Apps & Reporting Tools:   BIRT 3.7/2.3, Maximo 7.x/6.x/5.x/4, Actuate 7, 8 & 9 (Designer Professional, iServer Administration, active Portal 6.0/7.0), Business Objects XI, Crystal Reports 7 / 8 & 9/XI, Xcelsius, & Informatica

Version control: VSS and Harvest, Clear Quest, IBM Clear Case

Schedulers: Autosys, Actuate Desktop

PROFESSIONAL EXPERIENCE:

Confidential,Charlotte,NC

Sr. BIRT/Actuate developer

Responsibilities:

• The Reports were
• Order Spreadsheet, MBOL, BOL Report, Scheduled Jobs, User Activity, User Last Login, Report Execution Report,
• User Activity by client. Alert Detail and Summary, Loss and Cost Saving Detail and Summary, Mode Detail and Summary,
• Spot Quote Detail and Summary, All Carrier Volume Chart, Export on Time Report, Extensively used Java script and different functions for these reports.
• One good achievement was the use of dynamically selecting and showing of the Report columns, i.e. the ability of the user to just show on the Report only those columns which were selected by him/her.
• Usage of passing multiple parameter values in a Text Box.
• Word Wrapping of the route Column.
• Making Connection profile use for database connections as per environment.

Environment: Actuate 11/Actuate One/ BIRT 4.3 /BIRT Designer/Oracle/Enterprise Manager/Perforce version control

Confidential,NJ

Sr. BIRT/Actuate developer

• The Reports are Request List, Request Area, Request Count, Request FIXL, Request LIFP, Request Listo, Request VT,
• Alert Report, GTP ACID, GTP AIRP,RVR Report,. WX Report.
• The project here was to complete the reports mentioned here.
• The Reports were mainly parameterized Reports where in the parameters used were single or multiple airports and there weather conditions, visibility condition on the runway, Routes, ETA ETD (estimated time of arrival), ETD (estimated time of departure) etc. These Reports were meant for Air Traffic Control and other users.
• Also these same Reports were meant for different users and also same reports exclusively for Military and sensitive Flights data too.
• Extensively used Java script and different functions for these reports.
• One good achievement was the use of dynamically selecting and showing of the Report columns, i.e the ability of the user to just show on the Report only those columns which were selected by him/her.
• Usage of passing multiple parameter values in a Text Box.
• Word Wrapping of the route Column.
• Making Connection profile use for database connections as per environment.

Environment: Actuate 11/Actuate One/ BIRT 4.3 /BIRT Designer/Oracle/Enterprise Manager/Red Hat Lunix/IBM Rational Clear case.

Sr. Actuate/BIRT/BIRT-Espreadsheet developer

• The Project here is Traffic Management Report.
• Made about 25 Reports including Charts and Bar Graphs so far on BIRT 3.7 against Oracle Database.
• And Uploaded on Tomcat Apache Server and Tested.

Confidential,Boston, MA

Sr. Actuate/BIRT/E-Spreadsheet Report Developer

• Making new Reports in BIRT Report Designer and BIRT- E-spreadsheet Designer (Financial Reports).
• Resolving Tickets in Actuate Reports made.
• Reports were for Mutual Funds, Fixed Incomes, ETF’s, Equities, and Bonds etc.
• Uploading on Actuate I Server the New Reports and Resolved Tickets Reports after checking them out from VSS.
• Informing the User about Report modification and asking him to test and approve in JIRA
• After approval uploading to the Production Server after raising a Ticket in Change Management on LSProd2.
• Loomis Reports were divided into Following 5 Categories namely: Client Service, Downloads, Operations, Sales and marketing, Research.

Environment: Actuate 9 /11. BIRT 3.7/BIRT-Espreadsheet Designer/Sybase/Oracle/RazorSQL/JIRA/VSS/ODI(Oracle Warehouse Builder) used to ELT(i.e Extract Load and then Trasform) 

Confidential, New Carrolton, MD

Sr. Actuate/BIRT Report Developer

• Developed Reports using simple and complex SQL queries (On SQL Server 2008).
• Made Stored Procedure for all the Report and called them in Reports.
• Made special Report for Provider Search and Member Search for detail and Summary Report with On-Click Button Functionality for getting more Details for Each Members.
• Worked on various problems on Report server and Report design.
• Extensive use of Detail, Summary.
• Implemented custom Data source by overriding the Before Open Method of BIRT, Parameter Binding to modify the Select Statement.
• Supported The Test Team in Report testing.
• Different Work streams had different Report list run on daily basis and on weekends.
• Knowledge of Configuration files (.xml) to pass the connection parameters in the report.
• Handled deployment of the reports onto the Actuate Report iServer (IBM AIX Unix server.
• Developing the Actuate libraries to incorporate the company logo
• Created Debugging, testing and enhancing the reports which were showing false or incorrect data.
• Created Users, Roles and Folders for users on the server.
• Created reusable components and published them into Libraries.
• Used BIRT extensively over here.
• Responsible for the enhancements those were eventually made to the reports due to stored procedure changes and business requirement alterations.

Environment: BIRT 3.2/SQL Server 2008/WindowsXp/SVN Version Control/Win Merge/SSIS 

Confidential , Providence, RI

Sr. Actuate/BIRT Report Developer

Responsibilities:

• The Reports are:
• AllVendors,BACVendorswithVendorGroupNumFilled,CFCCheckRegister,CHLDeposit,eRBIInvoicesforMarch2009,
• InvoiceHeaderDetal,PeopleSoftNoCostCenter,VendorSetupwithDiscountTerms,VendorsonACHwithNoEmalAddress,VendorsPaymentsBalboa208,VendorswithBAPA01
• Viewed SQL of these Reports in order to meet User's request in case of Ado Reports.

Environment: Actuate 7 and 9/SQL Server 2000/Windows Xp/Actuate E-Spreadsheet Designer

Confidential,Cupertino,CA

Sr. Birt Report Developer

Responsibilities:

• Made the following Reports against the Oracle Database in BIRT.
• Compliance Summary by Policy, Compliance Summary by Server, Compliance Detail by Policy, Compliance.
• Detail by Server Compliance Detail by Devices, Compliance Summary by Devices.
• Software Discovery Reports by Application (Summary and Detail), Software Discovery Reports by Servers (Summary and Details).
• Developed Reports using simple and complex SQL queries. (On Oracle 8i, used TOAD).
• Worked on various problems on Report server and Report design.
• Extensive use of Detail, Summary.
• Implemented custom Data source by overriding the Before Open Method of BIRT, Parameter Binding to modify the Select Statement.
• Supported The Test Team in Report testing.
• Different Work streams had different Report list run on daily basis and on weekends.
• Knowledge of Configuration files (.xml) to pass the connection parameters in the report.
• Handled deployment of the reports onto the Actuate Report iServer. (IBM AIX Unix server.
• Developing the Actuate libraries to incorporate the HP logo.
• Created Debugging, testing and enhancing the reports which were showing false or incorrect data.
• Created Users, Roles and Folders for users on the server.
• Created reusable components and published them into Libraries.
• Responsible for Bug fixing for these Reports and other Reports already developed.
• Uploaded the Rpt design through proper HP procedure into clear case and the marked the Bug.
• Status to fix along with comments for QA.
• Used BIRT extensively over here.
• Responsible for the enhancements those were eventually made to the reports due to stored procedure changes and business requirement alterations.