Summary

• More than 17 years 16 plus in USA of excellent experience in analysis, design, development, testing, implementation, documentation and maintenance using Oracle 7.x, 8.x,9i,10g,11i, DAO/RDO/ADO 2.0, SQL, PL/SQL, Oracle Reports 6i,Crystal Reports, XI, 9.0,8.5,6.0,5.0,3.0, Crystal Enterprise 9.0,8.5.8.0,SQL Server 2000,7.0/6.5, MS - Access 2000,7.0,2.0, Seibel 2000, 7.0,
• Expert in Oracle Applications User Interface Customizations using Forms 6i oracle 11i, 10g Forms R12, Forms Personalization's, 9i JDeveloper Oracle 11i, 10g JDeveloper Release 12 and OA Framework Personalization's.
• Extensive experience in the Application Software Design and Development using Oracle 11i, 10g, 9i 7.x/8.0/8i, Visual Basic 5.0/6.0, COM, Developer 2000.
• Worked extensively using TOAD, SQL Plus, PL/SQL Developer, Workflow Builder and SQL Loader.
• Experienced in UNIX and Shell Scripting.
• Experienced in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Experienced in maintaining one to many and many to one relationships while moving data between two databases.
• Experienced in writing T-SQL Queries, Dynamic-queries, sub-queries and
• complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors.
• Supported team in resolving SQL Reporting services and T-SQL related issues and Proficiency in creating different types of reports such as Cross-Tab,
• Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Experienced in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
• Assisted in setting up the Forms and Reports Services on standalone 10g App Server.
• Worked on different flavors of Unix for supporting 11i Oracle E-Business Suite
• Well versed in web development using Active Server Pages ASP using scripting language VB Script.
• Excellent communication and team skills Is an American citizen.

Technical Skills

• GUI: Crystal Reports XI 9.0, 8.5, 8.0, 6.0/5.0/3.0, UML, Visual Basic 6.0/ 5.0/4.0, .Net, Business ObjectsXI, 3.1,5.0, Business View Manager,VBA
• Object Oriented Tools: CNT Enterprise Access 2000
• Databases: SQL Server 2000, 6.5, 7.0, MS-Access 2000, 7.0, 2.0, Erwin,
• Oracle 7.0, 7.1, 7.2, Paradox
• Technologies: ADO, RDO, ACTIVEX COM, MSMQ
• Web Technologies: ASP 3.0, 2.0, HTML/DHTML, IIS, COM, COM, and Web Server 3.0, Active X, VBScript, JavaScript, .Net
• Operating System: Windows 95, Windows NT 4.0, and Windows 2000 Server
• Others: MS-Office, Visual FoxPro, Visual Interdev.
• Version Control Tools: Visual SourceSafe, Clear case

Confidential

• Modified reports in Active Reports in Visual Studio 2005
• Backed up and Restored Development and Production Databases in SQL Server 2008
• Installed and configured SQL Server 2008 in Production and Development servers
• Designed and developed a tool to run thru the Text files AAE files extracted from command center and update the date columns into current date using C and VB.net
• Checked in and Checked out source code using TFS in Visual Studio 2010
• Created Stored Procedures, Triggers, Views and Functions using SQL Server 2008
• Created Master/Detail Reports, Cross-tabs, Charts and Applied slice-and-dice, implemented different level of hierarchies for drill techniques.
• Created the Reports using SQL Server Reporting Services 2005 .
• Created SSIS Packages to import and export data from Excel, Xml and Text files.
• Involved in Dimensional Data Modeling and Cube development in SQL Server 2008 Analysis Services SSAS
• Implemented the ETL Process using SSIS
• Created and Modified Stored procedures using TSQL in SSMS
• Ran scripts in Command Center to extract the polling files,polling is the process to get the Database upto date in the client environment, FTP the files that include DBF Files,AEE files extract files, Debout.old,txt files.
• Created Macros in Excel using VBA to pull up Zipcodes for cities from the City and State Database
• C, VB.net,Active Reports,Excel VBASQL Server 2008,SSMS,TSQL,Crystal Reports 8.5.TFS,Windows XP,Windows Server,Command Center,ETL

Confidential

• Upgraded the existing Pacman Reports in Crystal Reports XI into using the new database schema, views and stored procedures for Development, Test and Production servers.
• Modified the Stored Procedures using SQL Developer of Oracle 11gs Database in Development, Test and Production databases to use the new views instead of the tables for the schemas and upgraded them to Oracle 11g
• Maintained the Pacman Reports in Crystal Reports 10 using command objects and calls to the Stored Procedures returning the data using Ref Cursor.
• The data for these reports were developed using Command objects in Crystal Reports 2011 and Stored Procedures created in Oracle 11g.
• Created 50 folders in Crystal Management Console for all stations and published the respective reports into each folder,this process was done for all environments and all servers for Development,Testing and Production.
• Maintained the Stored Procedures and Packages returning the Ref Cursor for the queries to build the Data sets for the Reports in SQL Developer using Oracle 11g PL/SQL Cursors, Variables.
• Scheduled the Report in Crystal Management Console and exported it in Acrobat format and Excel Formats.
• Created 50 new users in Crystal Management Console for all stations and published the respective reports for each user to use in Eportfolio,this process was done for all environments and all servers for Development pmudevn, Testing pmutstn and Production pmuprdn .
• Enhanced the existing Pacman Reports namely Option 7 Pick Ticket Reports.
• Created the Database Triggers in Oracle 11g using SQL Developer to insert into the send cust,send pack,send sell,Send tran,send nonsell and the Informix tables repair Invoice etc while the shipment header table is updated.
• Modified the Command objects Queries of the Reports in Development, Test and Production databases to point to the Tables and Views for new users and schemas Stored Procedures in Development, Test and Production databases to use the new views instead of the tables for the schemas.
• Installed the SAP Crystal Reports Server 2011,Tomcat Server and Oracle client 32 bit and 64 bit in the Wintel Production, Development and Testing servers.
• Designed and developed a Alert Procedure in Oracle 11g that sends out emails from the mailing list table driven using SMPT utility.The stored procedure and the SQL are updated using the base table and the Alert Procedure reads thru the tables to send out emails.
• ReCompiled the existing Pro C programs that were pointing to the Oracle 9i databse to point to Oracle 11g database.
• Created Macros using VBA in Microsoft Excel 2007
• Programmed an automated a feature-rich Excel Pivot Table reporting system. Expanded the Pivot Table functionality to provide presentation capabilities not possible with standard Excel Pivot Tables, such as Subgrouping within DataItems
• Developed complex sequential SQL queries and stored procedures to generate statistics, and developed Excel Pivot tables to report the results.

Environment: Windows 7, Wintel Server,VBA, Excel 2007,Oracle 11g,Pro C,AIX,SAP Cyrstal Server 2011,Tomcat Server,SAP Crystal Reports 2011.

Confidential

• Created SQL Scripts to update and insert the Datawareshouse tables namely AP ITEMS,AP MENUS,AP ROLES to enable and populate the Menus for the Reports in the Portal
• Created SQL Scripts to update and insert the Datawareshouse tables namely EVENTS,EVENT PARAMETERS,PARAMETERS,PARAMETER LOVS,PARAMETER TYPES to create or update the Parameters and their types Select Box,Combo Box,Date Control etc, values in the parameters for the Reports.
• Designed and developed the Reports for MDX Client for Violations,Unusual Occurrences,AR Reports,Invoice Processing, Outsource Printing Summary etc using Oracle Reports 6i with Oracle 11i backend Database.
• Designed and developed the Reports for Datawarehousing Project using Crystal Reports 2008 with Oracle 11i backend Database.
• Maintained the Source Code for the SQL Scripts, Report files RDF as well as RPT Files into the respective Folders for DEV,TEST,PRE PROD and PROD using CVS in order to enable the build for release.
• Designed and developed the Reports for ALAMDEDA Client for using Crystal Reports XI with Oracle 11i backend Database.
• Modified the existing Reports in Crystal Report XI ALAMEDA Client that uses Java Bean Class to access the Database in Oracle 11i.
• Modified the the Oracle 11i Stored Procedures to make the changes for the ALAMEDA Reports
• Updated the APPLICATON SQL Table to make changes in to SQL column that has CLOB values of huge queries to access the database.
• Modified the existing Reports in Crystal Reports 2008 for Datawarehouse Project
• Prepared documentation for the Database and Oracle Reports
• Worked with the Testing team to prepare test cases and analysis to the toll system
• Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.
• Assisted with automation of NTTAs toll tag business functions by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

Environment: Windows XP,Oracle 11i, Excel 2007,VBA,Oracle Reports Builder 6i, Crystal Reports XI,Crystal Reports 2008,FileZilla, CVS, Javabean,Net Beans IDE,Java Script,SQL, PL/SQL

Confidential

• Upgraded the existing Pacman Reports in Crystal Reports 10 into using the new database schema, views and stored procedures for Development, Test and Production servers.
• Modified the Stored Procedures using Oracle 9i Database in Development, Test and Production databases to use the new views instead of the tables for the schemas.
• The data for these reports were developed using Command objects in Crystal Reports 10 and Stored Procedures created in Oracle 9i.
• Created 50 folders in Crystal Management Console for all stations and published the respective reports into each folder,this process was done for all environments and all servers for Development,Testing and Production.
• Maintained the Stored Procedures and Packages returning the Ref Cursor for the queries to build the Data sets for the Reports in SQL Developer using Oracle 9i PL/SQL Cursors, Variables.
• Scheduled the Report in Crystal Management Console and exported it in Acrobat format and Excel Formats.
• Created 50 new users in Crystal Management Console for all stations and published the respective reports for each user to use in Eportfolio,this process was done for all environments and all servers for Development pmudevn, Testing pmutstn and Production pmuprdn .
• Enhanced the existing Pacman Reports namely Pick Ticket,TransferWorksheet,NRC XNET.
• Created Macros using VBA in Microsoft Excel 2007
• Programmed an automated a feature-rich Excel Pivot Table reporting system. Expanded the Pivot Table functionality to provide presentation capabilities not possible with standard Excel Pivot Tables, such as Subgrouping within DataItems
• Developed complex sequential SQL queries and stored procedures to generate statistics, and developed Excel Pivot tables to report the results.
• Created the Database Triggers in Oracle 9i to insert into the send cust,send pack,send sell,Send tran,send nonsell and the Informix tables repair .
• Modified the Command objects Queries of the Reports in Development, Test and Production databases to point to the Tables and Views for new users and schemas Stored Procedures in Development, Test and Production databases to use the new views instead of the tables for the schemas.

Environment: Windows XP, Crystal Management Console, MS Access 2007,Crystal E Portfolio Infoview, Crystal Reports 10, Oracle 9i

Confidential

• Reverse Engineered 85 Reports that were created in Business Intelligence Business Objects
• Reverse Engineered 3 Reports that were created in Crystal Reports XI with Oracle 10 g Backend Table,Stored Procedure Ref Curstor and SQL Scriots
• Analyzed the Universes created in Business Objects Universe Designer to get the Data Modeling details that were part of the Reverse Engineering
• Extracted the Queries and Dimension,Fact information from Business Intelligence to build the document for future Report Development
• Involved in full life cycle of Business Objects reporting applications.
• Used Business Object Universe, Business Objects XI Reports and Business Objects XI repository.
• Browsed thru the Tables and Schema of the Oracle database in SQL Developer to get the common Dimensions of all the Reports
• Created Macros using VBA in Microsoft Excel 2007 to calculate complex formulas to evaluate the Verizon Real Estate Schema
• Created the Pivot Tables in Microsoft Excel 2007 and the Macros in VBA to project the Real Estate Share values for Verizon Real Estate Database.
• Business Objects XI,Crystal XI,Universe Designer,Oracle 10g,Microst Excel 2007,VBA,Microsoft Share Point,Crystal Reports,SQL Developer