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 Server2012suite 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 Financial Reports against db2 and JSON Reports against Sql server databases.
• Financials Reports made/modified ReadingsAdjustments, Sales Weekly GL, Bank Deposit.
• Web Reports modified Recipe Index, Scaled Recipe etc which used JSON Data and Restfull APis
• Made a Report where 2 SPs were used and data of Each SP had to be shown on 2 Excel Tabs.
• Usage of passing multiple parameter values in a Text Box.
• Writing BIRT Reports against Stored Procedures in SQL server..
• Ability to use complex parameters and advanced scripting capabilities in reports
• Complex SQLs on DB2, SQL Server to author BIRT reports
• Used JSON Data & Restful APIs to author BIRT reports in Webtrition Application
• Solid understanding of BIRT report formatters and experience with customizations in HTML, Excel and other formats
• Proven experience in writing highly scalable BIRT reports in high volume J2EE environment
• Strong understanding of data structures and data analysis techniques.
• Java & JavaScript development experience
• Data Modeling & Database/PL-SQL development experience

Environment: Actuate 11/Actuate One/ BIRT 4.3 /BIRT Designer/DB2/SqlServer/Enterprise Manager/IBM Jazz.

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 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, Egg Harbor Township, NJ

Sr. BIRT/Actuate developer

Responsibilities:

• 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 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.

Confidential, Rockville, MD

Sr. Actuate/BIRT/BIRT-Espreadsheet developer

Responsibilities:

• Average, Minimum, Maximum of Volume, Occupancy, Speed and Long Volume for particular location with user configurable filter and sort options i.e. Time of day period and day of week for particular link or site over user specified time period
• Average route travel time by route for current and previous day, week, month and year.
• Average route travel time by route for same month over several years.
• Average Minimum, maximum route travel time for a particular route by time of day period and day of week over user specified time period.
• Bar Chart comparisons of time-stamped detector log values (volume, occupancy, speed, long volume in DETECTOR LOG) with historical detector data values (HD

Environment: Actuate 11/Actuate One/ BIRT 3.7/BIRT Designer/Sybase/Oracle/Enterprise Manager

Confidential, Boston, MA

Sr. Actuate/BIRT/E-Spreadsheet Report Developer

Responsibilities:

• 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

Responsibilities:

• 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 in corporate 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 were to be matched to the GEAC system (mainframe) which had the General Ledger information.
• Made Accounts Payables Reports for Vendors in Actuate 9 and Employee Expense Reports in Cognos Report Net, Frame manager, Report Studio, Query Studio.
• Made Adhoc Reports of Employee Expenses for different associates with their OpID.
• Like EER Total number of transactions Detail and summary, Expenses with No cost Center.
• Employee Expenses with No email addresses EER where monthly Expense greater than 1000 for each OpId.

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 in corporate 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.

Confidential, Boston, MA

Sr. Actuate Report Developer

Responsibilities:

• Worked on this short term project and came in to complete 12 Reports for their Clarity Project Manager Application.
• Understood the Report Requirements and completed 12 Reports namely
• Eclipse Project Task Progress
• Eclipse Project Status
• Eclipse Project Team Actual
• Eclipse Project Hours All By Month
• Eclipse Project Hours by Task
• Eclipse Project hours By Month
• Eclipse Time Sheet Detail
• Eclipse Monthly Billing (Invoice Report)
• Eclipse Timesheet Hours summary
• Eclipse Timesheet Status summaries
• Eclipse Projects Bar Report
• Eclipse Projects Count.
• These Reports were against SQL Server Database and used lot of Dynamic Modifications on runtime.
• Used Group, Sequential sections.
• Used Obtain Select Statement Modification to change the Query at Runtime.
• Generated Dynamic Controls on for frames at runtime based on projects parameters passed.
• Used Oracle Analytical functions for getting Sum on partitions.

Environment: Actuate 7.2/SQL Server 2005/WindowsXp/Clarity

Confidential, Boston, MA

Actuate and BIRT Report Developer

Responsibilities:

• Worked on a Data ware house Project where data was sourced from different data sources like the Wall Street, IBS and in trader and reconciled to the General Ledger Data.
• Made the Reports against the Treasury Data Repository for the internal clients using BIRT Report Designer (Business Intelligence Reporting tool) Actuate 9.3 version.
• Uploaded the .rpt design file on iserver.
• The Business Logic was understood and the Reports were made with the following gist:
• The following Reports were made to know the Exception Rates given to Customer's
• Exception Pricing By Currency SUMMARY and Exception Pricing By Currency DETAIL (Interlinking them)
• Exception Pricing By Site SUMMARY and Exception Pricing By Site DETAIL (Interlinking them)
• Exception Pricing By Account Mgr SUMMARY and Exception Pricing Account Mgr DETAIL (Interlinking them)
• Recon Report SUMMARY (Month end wise) and Detail (for business day)
• Recon Report Transactional SUMMARY (Month end wise) and Detail (for business day)
• Made Materialized views for the above Reports and Packages in Oracle.
• Assets and Liability Reports.
• 1)GAP Reports 2) Customer Balance Analysis, Assets and Liabilities 3) Average Maturity and yield by currency and MM 4) Total Average Maturity by Branch 5) Reports to show Transaction type, currency, principal amount, USD equivalent, rate, and days to maturity for different customers site wise and branch wise.
• Made Fixed income Reports to calculate the Principal, coupon, maturity date etc on transactional basis and on site basis.
• Made Reports to know the Investment of the Street Bank with different Entities:
• Corporate Bonds, Municipal Bonds, Treasury Bonds, Equity securities and know their maturity dates and Interest accrued along with principal.
• Responsible for developing 20 reports in Actuate apart from taking part in the bug fixing and maintenance of reports and resolving Tickets for business users.
• Used BIRT extensively over here.
• 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 in corporate the State Street 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.
• Developed reports using Single Input Filters, Multi Input Filters providing the capability to filter the data.
• Responsible for the enhancements those were eventually made to the reports due to stored procedure changes and business requirement alterations.

Environment: Actuate 9.3(BIRT)/Oracle 9i/WindowsXp/Unix/Data stage/Clear Case version Control

Confidential, Cupertino, CA

Sr. Actuate Developer

Responsibilities:

• Compensation Reports made for different participants in the Organization for different territories based on compensation plans and Rule Elements applied for example: Credit Rule, Measurement Rule and Flat Rate Incentive Rule or Percentage based Incentive Rule in True comp Manager.
• These Reports were made by applying the Rule elements in True Comp Manager.
• The Business Logic was understood and Reports were made with the following gist:
• Compensation Reports according to sales registered by the sales associates according to different plans. Two types of Reports were made, Participants Reports and Program Reports. Compensation Reports Report, New users Reports Account Summary, Account Detail, Incentives Report, Performance Detail Report, Subordinate Performance Report, and Order Detail.
• Program Reports according to different plans: Premier AACR Payment Summary, Premier AAEA Payment.
• Summary, AAEA Payment Summary, Agent Summary Report, Revenue Detail, Premier AAEA Revenue Report, Agent order Report, Monthly Activity Report-CAPS.

Environment: Actuate 8.5/Oracle 8i/True Comp/WindowsXp/Unix/Informatica

Confidential, Atlanta, GA

Sr. Actuate Developer and Actuate Report Admin

Responsibilities:

• Responsible for developing 30 reports apart from taking part in the bug fixing and maintenance of reports and resolving Tickets for business users.
• Developed reports using sequential section, Group section, and Conditional section.
• Created reusable components and published them into Libraries, Created Cross-tab, Sequential, Parallel and Sub-Reports.
• Prepared the Implementation plan for Production Environment. Worked in Production support Environment for Report Scheduling and True comp Pipeline Running process for different Periods (Period Sequence) for Payroll generation for Payout Month and for Calendar month depending upon Different Work streams.
• Looking into Log files under UNIX I server machines to see why Reports have failed and rectifying the reason for failure.
• Different Work streams had different Report list run on daily basis and on weekends.
• Used UNIX to schedule compensates, Pay and post pipelines.
• This included Valid Transactions, Classify, Allocate and Reward. (Measure, Incentive and Reward)
• Knowledge of Configuration files (.xml) to pass the connection parameters in the report.
• Page Level Security was implemented to view the Report per-user basis. Responsible for the enhancements those were eventually made to the reports due to stored procedure changes and business requirement alterations, and scheduling the reports on the Actuate Desktop in Production.

Environment: Actuate5.2/Oracle8i/VisualSourceSafe/WindowsXp/Linux/Informatica/ActuateActiveDesktop

Confidential, Atlanta, GA

Sr. Actuate Developer

Responsibilities:

• Developed 30 reports apart from taking part in the bug fixing and maintenance of reports.
• Developed reports using sequential section, Group section, and Conditional section.
• Created reusable components and published them into Libraries, Created Cross-tab, Sequential, Parallel and Sub-Reports.
• Developed Reports using Cross Tab Report Section.
• Developed Reports using simple and complex SQL queries. (On SQL Server, DB2 etc. using WinSQL).
• Worked on various problems on Report server and Report design.
• Worked with Maximo application to make Reports involving Inventory, Stocks, Orders, Work Order process, Purchasing, Invoicing process, Equipment (Including Service contracts).
• Worked on Following Reports: Work Order, Shift Reporting, Purchasing, Invoicing, Equipment and Service Contracts, Capital Expenditure Budget Reports.

Environment: Actuate 7.2/DB2/Visual SourceSafe/WindowsXp/Seibel/Maximo 6.2

Confidential, Greensboro, NC

Sr. Actuate Developer

Responsibilities:

• Developed Reports for Finance/Re-engineering and Six sigma.
• Reports made for Top 20 Different projects started to in corporate Cost Avoidance, Revenue related and Expense Reduction showcasing Forecast, realized and variance for these.
• Worked on various problems on Report server and Report design.
• Worked with Dashboard Reporting and portal customization.
• Knowledge of Configuration files (.xml) to pass the connection parameters in the report.
• Handled deployment of the reports onto the Report Server.

Environment: Actuate 8.1/SQL Server 2000/Visual SourceSafe/WindowsXp

Confidential, Edmeston, NY

Actuate Report Developer

Responsibilities:

• Developed 20 Reports depicting Claim Count Numbers for different Claim Categories claims paid or unpaid for last 10 years and since the inception of the company.
• Developed reports using Cross Tab, sequential section, Group section, Conditional section, Bar and Pie Charts reports. Etc.
• Worked on various problems on Report server and Report design.
• Worked with Dashboard Reporting and portal customization.
• Knowledge of Configuration files (.xml) to pass the connection parameters in the report.
• Handled deployment of the reports onto the Report Server.

Environment: Actuate8.1/Microsoft SQL server 2000/WindowsXP/Lotus notes

Confidential

QA Consultant

Responsibilities:

• Developed Test plan for testing the application after analyzing requirements specification document.
• Executed test scripts for data validation, UI integrity, and content validation, in manual and automated modes, identified and reported software bugs and logical errors.
• Analyzed Use Case diagrams, Sequence diagrams, and Class diagrams while writing test plans.
• Developed Automated Testing solutions using Data-Driven Automated Testing Methodology in Win Runner.
• Executed Performance tests to monitor server resources for various scenarios and analyzed the test results using various monitors and graphs.
• Performed extensive Backend testing using SQL queries.
• Involved in online monitoring of the users using Load Runner.
• Co-ordinate with developers to fix the problems and enhancing the application.
• Monitoring the defect tracking process, trouble shooting and generating customized graphs and reports.
• Reported Bugs to the development team using Test Director.

Environment: Win Runner, Load Runner, Test Director, HTML, SQL, Oracle 8i