PROFESSIONAL SUMMARY:

• Over 21+ years of hands - on experience in business intelligence, business analysis, system analysis, OBIEE architecture, design, development, reporting, data modeling, enterprise data warehouse, database administration, application support, and documentation
• Expertise in OBIEE 11g/ 10.1.3.4/, Siebel Analytics 7.8, BI publisher, Siebel CRM 8.1, Actuate 9.2/8.0/7.2, Oracle 11g,10.2,9i, 8i, Oracle WebLogic Server 10.3.6,OLTP, OLAP Cubes, Sybase 11.9, SQL Server 2000,DB2, UNIX/HP-UX/Solaris5.2/AIX5/WindowsXP/DOS Operating Systems, Oracle tools/utilities/ - Developer 2000 (Reports 2.5, Forms 4.5),Business Objects (Crystal Reports), Middleware, PL/SQL, SQLPLUS, SQL*LOADER, Designer 2000, ERwin 3.2.5, ETL/Informatica PowerCenter 9.1, PowerExchange 9.1,B2B 9.1,DAC 10.1.3.4, Oracle Data Integrator (ODI) 11gR1,HTML,XML 1.0, C and C++ Programming languages, JavaScript, Java 2,Web Services, VB 6, Hyperion Essbase.
• Familiar with client server development projects supporting major database systems and have worked on various commercial applications in financial, manufacturing, sales, and telecom services

TECHNICAL SKILLS:

Software: OBIEE 11g1/10.1.3.4/ Siebel Analytics, Siebel 8.1 CRM, Actuate 9.1/8.0/7.2/6.0/5.0/4.0/3.2 , Oracle 10g, 9i, 8i, Oracle WebLogic Server 10.3.6, Developer 2000 (Reports 2.5, Forms 4.5), SQL PLUS 9.2, PL/SQL, Oracle enterprise Manager (OEM), TOAD, HTML, C++, C, MS COBOL, PASCAL, Shell Programming, Wins95/NT, SCO Open Server 5.0, SCO UNIX SVR 3.2, HP-UX 9.0, Java2, VB 6.0, Crystal Reports 8.1

Hardware: HP 9000 model 832s, Sun SPARC ULTRA-4 Server, Sun Enterprise 250, Sun 4000 Series, Compaq Prosignia 300, Compaq Deskpro Pentium IV, Wipros Landmark 4860 mini system (486 based)

PROFESSIONAL EXPERIENCE:

Confidential, Washington, DC

OBIEE / Informatica Architect/Admin

Responsibilities:

• Interact with stakeholder and users, gather the business requirements, design and develop functional requirement documents for Confidential for the Fraud Detection and National Security ( Confidential ).
• Lead the upgrade of OBIEE 10g to OBIEE 11g, ran full SDLC, and integrated OBIEE report with Siebel CRM application.
• Design and develop the subject area, business model, mapping, presentation catalog, answers, and complex dashboards for call center survey Siebel module in OBIEE.
• Extract and load data from ODS and flat files using Oracle Data Integrator (ODI) designer interface, tune packages/interfaces and set data connection in topology manager.
• Use operator to view and manage integration jobs as well as manage users and their repository privileges in security manager.
• Design and develop dimension hierarchies to achieve the drill down functionality, interactive KPI dashboard, and request for Confidential application.
• Provide leadership, design, and development of complex the stored procedure and view and materialize view for performance BI publisher reports using rtf template.
• Implement, configure, and install OBIEE 11g components and Oracle WebLogic Server as well as the Informatica client and server in a stand-alone configuration or as part of the Enterprise.
• Involved in BI server and database tuning, data modeling and query performance tuning to achieve maximum performance, and retrieve data from data warehouse structures.
• Build the Star Schemas based on the functionality as well as design, configure, and document RPD (logical and Physical Data Models, and Presentation Layer including administrator functionality).
• Deliver data modeling, including multi-dimensional modeling & Data Warehousing.
• Provide production support for end-users of the system, including training, responding to questions, resolving problems, and providing ad-hoc reporting.
• Heavily involved and worked in USCIS ELIS data merge and data migration project
• Design, model, and build data warehouse for Confidential system using ETL Informatica and schedule the jobs in DAC for nightly incremental refresh.
• Heavily involved in Informatica MDM,IDQ,Data Governance and profiling
• Validate the high volume of data using Infomatica Data Validation Option (DVO) for fast development avoiding writing lengthy SQL data validation scripts
• Use informatica B2B to extract data from unstructured source files and PowerExchange to extract real time data.
• Create, design, develop, tune, and troubleshoot ETL Informatica staging, SDE, SIL mapping, change data capture (CDC), and session and workflow for full, incremental load.
• Deliver OBIEE, Presentation catalog, Informatica, and DAC build in multiple environments.
• Develop, configure, and schedule DAC subject area, task group, and the execution plan.

Development Tools: OBIEE 11g (Siebel Analytics), Oracle BI Answers, Oracle BI Dashboards, Presentation catalog, BI Administrator and Oracle BI Publisher, oracle WebLogic server 10.3.5, SUN OS 5.10, Windows NT 4,Oracle 11, Oracle 10.2,OLTP,OLAP Cubes, OWB, RAC, Data warehouse, SQL, HTML, JAVA 2, JavaScript, JSP, Java, Middleware, Tomcat 4.0, WebSphere, XML 1.0,XLS 1.0, MS VSS 6, Informatica PowerCenter 9.1,PowerExchage, B2B,Oracle Date Integrator (ODI) 11gR1, Siebel 8.1,,DAC 10.1.3.4, SOA, Agile

Confidential, MD

Oracle BI / Informatica Architect/Admin

Responsibilities:

• Led the implementation of the Oracle Enterprise Business Suite (EBS) and Oracle Business Intelligence applications for Financial Analytics, Procurement, Spend Analytics, and Project Analytics modules.
• Collaborated closely with Business Users, gathered the business and analytic requirements from different user groups, and ran full SDLC.
• Designed, setup security models, and implemented single sign on (SSO) for OBIEE dashboard and BI publisher.
• Configured LDAP server settings in the BI Server and BI publisher to set up users and groups.
• Used the Security Manager in Oracle BI Admin Tool to setup access privileges and query privileges.
• Implemented user and database level security providing mentoring and successful results in a deadline driven environment.
• Designed and developed answer, dashboard, and BI publisher reports for PO, GL, Procurement, spending, and project.
• Troubleshot and performance tuned BI server, data warehouse, dashboard, and answers and providing cache management.
• Setup Multiuser Development Environment (MUDE) and created projects using the Project Manager utility.
• Implemented custom/OOB business intelligence solutions (Metadata and Dashboards/Reports) using the BI Applications Analytics platform.
• Implemented Flex Field (FF) changes in the OOB business model to report on GL, Procurement and spending, Purchase Orders, Purchase Requisitions, Project Billing, and Project Cost, etc.
• Created dimensional hierarchies, level based measures, fragmentation content, aggregations, and complex joins.
• Performed installation and configuration of BI Scheduler for delivers.
• Installed the OBIEE and BI publisher as well as configured the data sources, security, and the setup of the super user for Publisher and integration with BI presentation services.
• Configured the SA System Subject to set the delivery profiles of all the users from LDAP directory.
• Developed iBots for delivering reports through email to the Finance and Procurement users.
• Enabled and administered Usage tracking by using direct insert method.
• Implemented DAC Analysis Subject Area in the RPD to get statistics about execution plans and tasks.
• Did Informatica MDM,IDQ,Data Governance and profiling
• Designed, developed, tuned, and troubleshoot ETL Informatica mapping, session, and workflow for full, incremental load using EBS data source.
• Developed, configured, and scheduled the DAC subject area, task group, and execution plan.
• Developed drill down reports, created templates for Publisher reports, and used guided navigation feature.
• Configured global filters, dashboards, and page prompts in OBI web catalog.
• Managed migration of RPD and presentation catalog changes across environments through catalog manager.
• Configured charts, pivot table views, and filters in user interface.
• Configured repository/session variables and initialization blocks to get dynamic reports and dashboards.

Environment: OBIEE 10.1.3.4.1 , OBI Apps 7.9.6.1, Oracle BI Publisher 10.1.3.4.1 , Oracle 11G, SQL Developer, Middleware, ETL/Informatica PowerCenter 8.6, DAC 10.1.3.4, OWB, Linux 2.2, EBS Financials, EBS Procurement and Spend, EBS Projects.

Confidential, Washington, DC

OBIEE/Informatica Architect /Admin

Responsibilities:

• Served as the Architect entrusted to interact with stakeholder and users, gather the business requirements, and design and develop functional requirement documents for Confidential for defense personal property system(DPS) application.
• Designed and developed subject area, business model, mapping, web catalog, answers and complex dashboards for call center survey Siebel module in OBIEE.
• Designed and developed dimension hierarchies to achieve the drill down functionality, interactive KPI dashboard, and answers for DPS application.
• Designed and developed complex stored procedures as well as viewed and materialized view for performance BI publisher reports using rtf template.
• Converted Actuate 7.2 reports to BI publisher reports and modified existing BI publisher reports rtf templates and SQL queries.
• Implemented, configured, deployed Oracle Business Intelligence Enterprise Edition (OBIEE) components in a stand-alone configuration or as part of the Enterprise.
• Involved in BI server and database tuning as well as in data modeling and query performance tuning to achieve maximum performance while retrieving data from database structures.
• Built the Star Schemas based on the functionality and handled data modeling including multi-dimensional modeling & Data Warehousing.
• Designed, configured, and documented logical and Physical Data Models as well as Presentation Layer including administrator functionality.
• Provided production support for end-users of the system, including: training, responding to questions, resolving problems, and providing ad-hoc reporting.
• Designed, developed, tuned, and troubleshot ETL Informatica mapping, sessions, and workflow for full, incremental load.
• Provided development, configuration, and scheduling of the DAC subject area, task group, and execution plan.
• Upgraded Informatica from 7.8 to Informatica 8.6, DAC from 7.8.2 to DAC 10.1.3.4, and Siebel analytics from 7.8 to OBIEE 10.1.3.4.
• Delivered OBIEE support, web catalog, Informatica, and DAC built in multiple environments.

Development Tools: OBIEE 10.1.3.4 (Siebel Analytics), Oracle BI Answers, Oracle BI Dashboards, Web catalog, BI Administrator and Oracle BI Publisher, SUN OS 5.10, Windows NT 4, Oracle 11, Oracle 10.2, OLTP, OLAP Cubes, OWB, RAC, Data warehouse, SQL, HTML, JAVA 2, JavaScript, JSP, Java, Tomcat 4.0, Agile, WebSphere, Middleware, XML 1.0, XLS 1.0, MS VSS 6, Power Center Informatica 8.1, Siebel 8.1, DAC 10.1.3.4. SOA

Confidential, Washington, DC

OBIEE/Informatica Lead / Architect

Responsibilities:

• Served as the Lead and Architect entrusted to design and develop dimension hierarchies to achieve the drill down functionality, interactive dashboard, answers for Non response follow up reports for housing unit, group quarter enumeration, group quarter advanced visit, remote Alaska and elementary transitory location operations.
• Collaborated with stakeholder and users, gathered business requirements, designed and developed functional requirement documents for PBO application for NRFU, GQE, GQAV, RA and UL operations for Confidential 2010.
• Designed and developed complex stored procedure as well as viewed and materialized view for performance BI publisher reports using rtf template.
• Provided modification in existing BI publisher reports rtf templates and SQL queries.
• Implemented, led configuration, and deployed Oracle Business Intelligence Enterprise Edition (OBIEE) components in a stand-alone configuration or as part of the Enterprise.
• Directly involved in BI server and database tuning, and data modeling and query performance tuning to achieve maximum performance while retrieving data from database structures.
• Built the Star Schemas based on the functionality, design, configuration, and document logical and Physical Data Models.
• Presentation Layer included administrator functionality.
• Delivered the data modeling including multi-dimensional modeling & Data Warehousing.
• Provided production support for end-users of the system which included the training, responding to questions, resolving problems, and providing ad-hoc reporting.

Development Tools: OBIEE 10.1.3 (Siebel Analytics), Oracle BI Answers, Oracle BI Dashboards, BI Administrator and Oracle BI Publisher, Solaris 5.2, Windows NT 4, Oracle 10.2,Oracle 11,OLAP,OWB, RAC,DB2, Data warehouse, SQL, HTML,JAVA 2, JavaScript, JSP, Java, Middleware, Tomcat 4.0, Agile, WebSphere, XML 1.0,XLS 1.0, MS VSS 6,Power Center Informatica 8.1,DAC. SOA

Confidential, Windsor, CT

OBIEE/Siebel Analytics Lead / Application Architect

Responsibilities:

• Served as the main Siebel Lead and Application Architect who implemented and configured OBIEE in Windows environment and integrate it with an Oracle data warehouse and Hyperion ESSBASE.
• Interacted with business and users, gathered the business requirements, designed and developed functional requirement documents for loan, fund, consolidate enrollment tool, and beneficiary maintenance.
• Designed and developed complex reports, interactive dashboard, answers related to payroll deduct and direct bill loan, fund, consolidate enrollment tool and beneficiary maintenance.
• Built the Siebel Analytics repository (RPD) /metadata and defined/created the subject areas where reporting and analysis were centered around.
• Constructed data visibility and security rules as well as implemented them within Siebel Analytics to provide record-level, team-based, and group-based security into the Data warehouse.
• Collaborated with client to define corporate Key Performance Indicators, business intelligence corporate strategy, and roadmap.
• Created, modified, and administered analytics intelligence interactive dashboards, answers with links to web sites, HTML text, links to documents, and embedded content, such as images, text, charts, and tables.
• Designed and developed complex financial BI publisher report using rtf template and writing complex SQL queries in BI Publisher data set.
• Provided modification, enhancements, and changes in exiting BI publisher reports as per the business requirement.
• Captured and documented Business Requirements from client conducting interviews and workshops.
• Completed the development on the functional and the technical specifications.
• Assisted in the performance of gap Analysis related to Data Models and data extracted in ETL’s, and map client requirements into OBIEE/ Siebel Analytics functionality.
• Extensively handled data modeling, including multi-dimensional modeling & Data Warehousing.
• Built the Star Schemas based on the functionality.
• Designed, configured, and documented logical and Physical Data Models.
• Presentation Layer included the administrator functionality.
• Produced on the different layers of the Siebel Administration Tool.
• Designed, built, and tested reports, Dashboards, BI Publisher, Microsoft Integration, and other functionality within the OBIEE suite.
• Create Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Implemented Multi-User Development (MUD) in Production and created dimension hierarchies to achieve the drill down functionality.
• Performed administrative tasks like creating Users and assigning them to a group and restricting users to the development environment.
• Implemented caching to increase performance as well as created, modified, and administered analytics intelligence dashboards.
• Maintained Session and Security in OBIEE and created users and groups assigning these users and groups to the Dashboards.
• Developed Test Plan including test scripts for Unit, System, and User Acceptance Testing including resolution of bugs.
• Delivered world class business and technology solutions that enable client to become high performance businesses.
• Led configuration of in-scope functional and technical requirements based on design documents including data structures, data mapping, and related Performance Tuning.

Development Tools: OBIEE 10.1.3 (Siebel Analytics), Oracle BI Answers, Oracle BI Dashboards, BI Administrator and Oracle BI Publisher, Solaris 5.2, Windows NT 4, Oracle 10,OLAP,Oracle BAM 10g, Sybase 11.9, DB2,Datawarehouse,T-SQL, DBArtisen, SQL, HTML, JAVA 2, JavaScript, JSP, Java, Tomcat 4.0, WebSphere,XML 1.0,XLS 1.0, MS VSS 6,Power Center Informatica 8.1,DAC, Hyperion Essbase, SOA

Confidential, NJ

Siebel Analytics Consultant/Lead

Responsibilities:

• Interacted with management, business and users, gathered the business requirements, designed and developed complex dynamic business quality compliance group reports related to annuity, audit and early warning.
• Designed and developed functional requirement documents for agency system business quality for compliance group.
• Debugged and troubleshot the existing report for better performance and fixing the errors.
• Gained an understanding Client requirements, source data, business objectives, and key performance indicators.
• Designed the Technical Design documents by understanding the Functional Design documents for the sales performance.
• Created and developed complex reports, interactive dashboard, answers, and BI Publisher.
• Identified the Facts, Dimensions, and grained of the Dimensional mode and referential joins.
• Built Siebel Analytics Repository at 3 layers i.e., Physical Layer (connecting to Data sources and import schema), Business Model / data mapping (create Logical tables and data source mapping) and Presentation Layer level (create presentation catalogs).
• Developed Business Facts and Dimensions as well as defined Logical relation between them in BMM layer.
• Created Dimensional Hierarchies for the Drill Down functionality and implemented Business Logics for Facts.
• Analyzed and validated the business model in Siebel Administration Tool by performing consistency checks, validating logical source tables, logical columns, and validating repository level calculations done in the business model layer.
• Imported Physical Tables and defined Relations in Physical Layer in Siebel Analytics.
• Created Reports using different Analytics Views (Pivot Table, Chart, Column Selector, Table).
• Developed Pivot Tables and manipulated Init Blocks for report analysis.
• Tuned the performance of the reports by creating various types of indexes wherever appropriate.
• Used many pre-processing, post-processing, and validations scripts using Oracle PL/SQL.
• Managed the security of the defined users and groups, set permissions, Group Inheritance, Authentication Methods, Query Limits, Timing Restrictions, and Filters.
• Converted and migrated actuate reports to Business Objects and created new crystal reports.
• Created parameterized Crystal Reports using Charts, Cross-Tab, Sub-reports, Xcelsius, dashboard, Running Totals, chart, and Live Office documents.
• Provided extensive analysis to design the Universes and assign them to respective domains.
• Used Business Object Universe, Business Objects Reports, and Business Objects repository as well as new enterprise universes were designed and developed to support the user requirements.

Development Tools: Siebel Analytics 7.8.4, Windows NT 4, Business Object X1,Sybase 11.9, Oracle 10.2,Datawarehouse,T-SQL, DBArtisen, SQL, PL/SQL, HTML,JAVA 2, JavaScript, JSP, Java, Active portal, Web Services, WebSphere, IIS, XML 1.0, XLS 1.0, Power center Informatica 7.1, MS VSS 6, Hyperion Essbase, BI Publisher

Confidential, Boston, MA

Sr. Siebel Analytics / Actuate Consultant Lead

Responsibilities:

• Served as the Lead, designing and developing functional requirement documents (FRD) for GPS, Fixed Income, Mutual funds, Hedge fund, and Derivatives.
• Developed application in Java and called the dynamic actuate reports from Java application using requester, report server APIs, and actuate web services.
• Interacted with business and users around the world and gathered the business requirements.
• Designed and developed complex dynamic financial reports related account distribution, account listing, sales, stale price, prime brokerage, and multiple products etc.
• Designed and developed the business model, mapping, physical design, and universe for GPS in Siebel Analytics administration.
• Built the Siebel Analytics repository/metadata, and defined/created the subject areas where reporting and analysis were centered around.
• Created financial interactive dashboard and answers in Seibel Analytics and developed the complex drill down financial reports in Seibel Analytics.
• Designed and developed espreadsheet using actuate 7.2 eSpreadsheet designer, Java Callback classes, and XSLT templates file for top management to analyze the data and to take the appropriate decision.
• Migrated reports including espreadsheets from actuate 5 and actuate 7.2 to Actuate 9.1.
• Installed Actuate 9.1 iserver and iportal on Solaris 5.2 and customize iportal.
• Designed and developed new libraries and bas file and did some modification in existing libraries.
• Developed and tuned package, stored procedure, and used them in reports to enhance performance.
• Debugged and troubleshot the existing report for better performance and fixed the errors.
• Extensively used multiple / single Data Filters, Memory Buffer, Sequential, and Conditional sections.
• Created information objects from number of heterogeneous data sources for end user using actuate information object designer and used these information objects in Actuate query for ad-hoc queries.
• Provided Multiple Level Dynamic Groupings and wrote Actuate iserver online backup Shell Script.

Development Tools: Solaris 5.2, Windows NT 4, Siebel Analytics 7.8.4, Actuate 9.1/8.0/7.2 (eRDPro), Machine console), Actuate iServer, eSpreadsheet engine 10, Actuate Query, eAnalysis, BIRT 2.2,LDAP,RSSE, Sybase 11.9,Oracle 10.2,Datawarehouse,T-SQL, DBArtisen, SQL,PL/SQL, HTML,JAVA 2, JavaScript, JSP, Java, Tomcat 4.0, Active portal, Web Services, IIS, WebSphere, XML 1.0,XLS 1.0, MS VSS 6, VSS 6, JIRA, Informatica 7.1

Confidential, NJ

Sr. Siebel Analytics Lead/Application Architect

Responsibilities:

• Designed and developed business requirement documents (BRD) functional requirement documents (FRD) for Global equity office (GEO), Fixed Income, and Mutual funds.
• Developed the application in Java and called the dynamic actuate reports from Java application using requester APIs.
• Designed and developed complex dynamic financial equity research reports related to McLagan, PAN European, soft dollar, account by account, sales, and market sales.
• Designed and developed logical and physical database design and repository for GEO in Siebel Analytics administration.
• Collaborated with business analysts and users around the world, gathering the business requirements
• Designed and developed financial interactive dashboard and answers in Siebel Analytics.
• Developed complex drill down financial reports in Siebel Analytics and extracted data from heterogeneous data source loading in Oracle data warehouse using ETL Informatica.
• Developed and provided page level security to secure the reports and information for appropriate users in Actuate.
• Created various kind of financial eSpreadsheet using Actuate eSpreadsheet designer and XSLT templates.
• Created user interactive form based drill down reports with the help of browser script control, HTML, and JavaScript.
• Developed information objects from number of heterogeneous data sources for end user using Actuate information object designer and used these information objects in Actuate query for ad-hoc queries.
• Designed and developed new libraries and bas file and provided modification in existing libraries.
• Developed and tuned packages, stored procedure, and used them in reports for better performance.
• Troubleshot and debugged the existing report to enhance performance and fix errors.
• Provided analysis, plan, and design for the migration from Actuate 7.2 to Actuate 8.0.
• Extensively used multiple /single Data Filters, Memory Buffer, Sequential, Conditional sections, and Multiple Level dynamic Groupings.

Development Tools: Solaris 5.2, Windows NT 4, Actuate 8.0/7.2 (eRDPro), Machine console),Actuate iServer, eSpreadsheet engine, Actuate Query, Designer, Sybase 11.9,Oracle 9i,Datawarehouse,T-SQL, DBArtisen, SQL,PL/SQL, HTML,JAVA 2, JavaScript, JSP, Java, Tomcat 4.0, Active portal, XML 1.0,XLS 1.0, Web Sphere, Test Director 8.0,MS VSS 6, ETL Informatica 6.2, Seibel Analytics 7,Teradata

Confidential, NJ

Sr. Actuate Consultant / Team Lead

Responsibilities:

• Designed and developed complex dynamic financial trade reports related to export LC, import LC, collection, import bill Schedule, guarantee fee detail, bank trade, and export and import standby etc.
• Installed Actuate 7.2 server and portal on AIX 5 and imported the encyclopedia volume using actuate acimport utility.
• Created user interactive form based drill down reports with the help of browser script control, HTML, and JavaScript.
• Interacted with business analysts and users, gathered the business requirements, designed and developed functional requirement documents (FRD) for MaxTrade7.
• Designed and developed cube cell reports using actuate Analytics for top management to analyze the data and to take the appropriate decision
• Created information objects from number of heterogeneous data sources for end user using actuate information object designer.
• Developed tons of queries to analyze the data using Actuate query and put the result set in e.Analysis for further drill down.
• Designed and developed eSpreadsheets including graph and pai chart to investigate the financial data.
• Designed and developed new libraries and bas file and did some modification in existing libraries.
• Debugged and troubleshot the existing report to provide enhancements and fix errors.
• Developed and tuned packages, stored procedures, and used those procedures for reports to increase performance.
• Analyzed, planned, and designed the migration from Actuate 5 to Actuate 7.2.
• Extensively used multiple / single Data Filters, Memory Buffer, Sequential, Conditional sections and Multiple Level dynamic Groupings.

Development Tools: AIX 5, Windows NT 4, Actuate 7.2 (eRDPro), Actuate 5.0, Actuate query, eSpreadsheet, e.Analysis, Sybase 11.9,T-SQL, DBArtisen, Informatica, HTML, JavaScript, JSP, Java, Tomcat 4.0, Active portal, Web Sphere, Test Director 8.0

Confidential, NJ

Sr. Actuate Consultant / Application Lead

Responsibilities:

• Interacted with the Business Analyst, gathered the business requirements, designed and developed functional requirement documents (FRD) for companies’ financial stock options quick, and provided application support.
• Advanced reports like options outstanding, FAS disclosure summary, option expense, and actual forfeiture complying with financial accounting Standard Board (FASB) rules and regulation.
• Designed and developed quick and advanced dynamic financial stock option reports like options outstanding, FAS disclosure summary, option expense, actual forfeiture, and prime brokerage.
• Developed and tuned Oracle packages, stored procedures, and used them in reports for better performance.
• Developed reports with Export to Excel functionality that sent report data to Excel spreadsheets for specific usage.
• Integrated Actuate reports with VB application using requestor APIs.
• Designed and developed libraries for reusability and bas file.
• Designed, developed, and deployed financial reports as part of the Financial Analysis and Management System (FAMS) group.
• Developed Staff FTE, Head Count, Expense, Revenue, NEV, and Portfolio reports for the current financial year forecast and next financial year plan.
• Developed Monthly, Quarterly, and Annual trend reports for Actual, Forecast, and Plan data.
• Used sequential sections, parallel sections, conditional sections, multiple level nested groupings, dynamic (runtime) queries, and charts in most reports.
• Utilized memory buffers, single/multiple input filter, and output to Excel using Objects.
• Interacted with a group of 200 users to gather requirements, interacted with the DBA for database modifications, SQL queries, and performance tuning, and interacted with the Website Developer for designing the front-end interface.
• Followed the change control process using PVCS and eNotes to deploy the reports on the development server and then move the server to UAT server where it was tested and debugged before final movement to the Production server.

Development Tools: Sun Solaris 5.2, Windows NT 4, Actuate7.2 Oracle 9i,SQL 9.2,PL/SQL Developer, TOAD, VB 6, Microsoft visual SourceSafe 6.0, WebSphere 5.1

Confidential, NY

Sr. Actuate Consultant

Responsibilities:

• Led the analysis, design, development, and deployment of the complex financial monthly, weekly, and daily reports for Student Loan.
• Developed data capture reports for school, guarantor, key master and “change transaction send” from flat files.
• Analyzed the data as well as wrote and tuned complex SQL queries.
• Mentored the developers and converted the existing ACAPS (main frame) reports into APPWORKS (Actuate).
• Wrote stored procedures in Oracle, analyzed and tuned for better performance, used these procedures in Actuate reports.
• Deployed, executed, and scheduled the reports in Report Server.
• Extensively used Data Filters, Sequential, Conditional sections, and Multiple Level Groupings.
• Designed and developed libraries and bas file and called some Actuate reports from VB application using requestor APIs.
• Analyzed existing reports and modified applications to use the updated data layout.
• Tuned SQL queries to use the updated data schema with new tables and columns.
• Provided page level security to secure the reports and information for appropriate user.
• Created libraries for the FAMS group to be used in all the reports for layout consistency.
• Generated urgent AdHoc reports on a daily basis for the upper management.
• Designed and developed analytical reports such as cost per loan report, expense per staff report, forecast vs. plan report, portfolio reports, and net economic value reports and variance reports.
• Designed and developed two comprehensive report packages that were included in the quarterly business reviews for forecasting and budgeting.
• Wrote stored procedures in Oracle and used them in reports for a stronger performance.
• Followed the change control process using PVCS and eNotes to deploy the reports on the development server.
• Moved development server to UAT server, tested, debugged, and then finally moved it to the Production server.

Development Tools: AIX, Windows NT 4, Actuate7.0/6.0, Oracle 9i, SQL 9.2, PL/SQL Developer, Microsoft visual SourceSafe 6.0, MVS TSO,VB 6.

Confidential, MI

Sr. Actuate Developer & Administrator

Responsibilities:

• Led the analysis, design, development, and deployment of the complex dynamic financial and events arrangements reports.
• Analyzed the data and wrote, analyzed, and tuned complex SQL queries.
• Wrote stored procedures in Sybase, analyzed and tuned for better performance, and used the procedures in Actuate reports.
• Developing libraries and bas files provided Report Server Administration, interacted and mentored the users, and gathered the requirements.
• Designed and developed a custom Report Cast interface by overriding report cast (ACHTML) templates.
• Implemented custom Report Cast templates and developed complex dynamic reports in Actuate 6.0.
• Developed reports with Export to Excel functionality that sent report data to an Excel spreadsheet for specific usage.
• Involved in extensive debugging, enhancements, and modifications of reports and applications.
• Mentored the users and extensively used Data Filters, Sequential, Conditional sections, and Multiple Level Groupings.
• Created Groups, Users, Roles, and Folders for users in Administration Desktop for Security.
• Deployed, executed, and scheduled the reports in Report Server.
• Developed some e.spreadsheet reports to analyze the data by decision makers.

Development Tools: Sun OS 5.6, Sun SPARC ULTRA-4 Server, Windows NT 4, Actuate e.Reporting Suite 5.0 (Designer Professional 5, Actuate Administrator Desktop 5, Actuate Report Server 5), Actuate 6.0 ( ERDpro, Machine console) Sybase11,SQL Server 2000, SQL, DBArtisen, ACHTML,HTML, IIS Webserver

Confidential, San Francisco, CA

Actuate Developer & Administrator

Responsibilities:

• Led the analysis, design, and development of daily, weekly, and monthly complex financial, sales, marketing, and performance reports in actuate.
• Heavily used Oracle and Sybase databases and data warehouse in development, test, and production environment.
• Installed the Report Server and generated and deployed the reports on the Report Server.
• Created Groups, Users, Roles, and Folders for users in Administration Desktop for Security.
• Executed and scheduled the reports in Report Server and assigned privileges for the Executables.
• Wrote stored procedures in Oracle and Sybase to populate some aggregate tables and used those procedures and tables in actuate reports.
• Developed complex smart reports, libraries, and bas files as well as wrote Shell Script.
• Wrote, optimized, tuned, and automated complex SQL queries.
• Retrieved the daily requests from users as well as wrote many ad-hoc queries for analyzing, mining the data and sending the result back to users.
• Administrated the report server, created users, groups, folders, and roles, and scheduled and sent email notifications of the reports.
• Deployed the reports on the web using Administrative Desktop.

Development Tools: Sun OS 5.6, Sun Enterprise 250, Sun 4000 Series, Windows NT 4, Actuate e.Reporting Suite 5.0 (Designer Professional 5, Actuate Administrator Desktop 5, Actuate Report Server 5.0), Crystal Reports 8.1, ACHTML, HTML, Oracle8, Sybase11, Data warehouse, SQL, PLSQL 2.3,Tran-SQL,DBArtisen, VB 6.0,IIS WebServer, JavaScript

Confidential, San Francisco, CA

Actuate Developer

Responsibilities:

• Involved in the analysis, design, development, and deployment of the complex financial reports for the investment bank firm, which involves trade, brokerage, sales (in development), QA, beta, and production environment.
• Developed interfaces in VB, analyzed the data, as well as wrote, analyzed, and tuned complex SQL queries.
• Wrote stored procedures in Sybase, analyzed and tuned it for better performance. Used the procedures in Actuate reports. Developing libraries and bas files.
• Involved in report server administration work such as created users, folders and roles and achieved, scheduled, and deployed the reports on the web using administrative desktop.

Development Tools: Sun OS 5.6, Sun SPARC ULTRA-4 Server, Windows NT 4, Actuate e.Reporting Suite 4 (Actuate Developer Workbench 4, Actuate Administrator Desktop 4, Actuate Report Server 4), Crystal Reports 8.1,Sybase11, DB2, SQL, VB 6.0, ACHTML, HTML, IIS WebServer.