PROFESSIONAL SUMMARY

• Over 14 years of experience in the IT industry with data analysis and system analysis, data modeling, application development, procedure system design and developing client/server and Web applications with Relational Databases with six years experience in data warehousing working in India, Mauritius and United States.
• Associated with complete life cycle of software projects including, Oracle Applications, Data Modeling, Reporting projects, adhoc reporting, data warehousing solutions and web applications from drawing board stage to final implementation.
• Proficient in Application Foundation, including Server Products Web Intelligence.
• Involved in Extraction, Transformation and Loading ETL using Oracle Warehouse Builder.
• Extensively used ETL methodologies for supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Oracle Warehouse Builder 10g R2/R1
• Strong with web applications and reports development using Business Intelligence adhoc reporting tools including Oracle Discoverer v9i/10g, Oracle Reports v10g and SQL reports from Oracle and Microsoft SQL Server databases to present the data in an organized manner.
• Knowledge of Dimensional modeling, Data migration, Data cleansing and Web reporting features of data warehouses.
• Involved in documentation once the requirements have been received from the client and preparing the flow charts using Visio.
• Proficient with SQL, PL/SQL
• Involved in ER diagrams using ERWIN.
• System analysis and development experience over 7 years for several projects in a wide variety of environments. Well experienced with all phases of system process development Life Cycle, client handling, requirement analysis, preparing specifications and ERDs
• Strong in defining test methodology, designing test plan, preparing documentation, standardizing procedures and establishing the test environment
• Very strong functional and technical skills in understanding user requirements and writing specifications and documenting the processes, requirements and programs.
• Good written and communication skills and an excellent team player.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Confidential

Database Developer

Responsibilities:

• Gathered business requirements and wrote the initial data model for a customer profitability datawarehouse.
• Job responsibility included requirements gathering, writing specifications, flow charting, designing and creating Adhoc reporting system for the Agency using web-based business intelligence and data warehousing using Oracle Discoverer
• Experience in the Design of Dimension and Fact Tables in Star Schema.
• Used all sort of transformations in Oracle Warehouse Builder 10g to develop mappings and worked on Process flow scheduling.
• Created and executed large number of staging mappings using transformations.
• Wrote efficient and complex SQL queries to analyze raw data. Based on the analysis made recommendations resulting in significant improvements in the database design/layout.
• Wrote PL/SQL packages to extract, transform using business rules and load data from Oracle Applications tables into Oracle data warehouse for creating tables.
• Wrote Database triggers.
• Created dimensions and extensive use of export/import utilities in OWB required for the mappings.
• Used external tables to transform and load data from flat files to target tables.

Environment

Oracle database Server 10g/11g, Microsoft Access 2000/2003, SQL, PL/SQL, TOAD v8.0.1.X, SQL Loader, Oracle Discoverer 9i/10g

Confidential

Database Developer

Responsibilities

• Data Migration from MS Access to Oracle 10g.
• Designed a fully-normalized enterprise data model of clients, members, providers.
• Reverse-engineering business requirements out of the legacy systems b drop obsolete requirements c forward-engineer the surviving requirements, plus any new ones, into a new design.
• Worked on Star Schema and Snow Flake schema.
• Data Conversion using PL/SQL.
• Generating Access Reports.
• Development of Web Forms using Oracle Forms.
• Development of Web Reports using Oracle Reports.

Environment

Oracle database server 10g/11g, Oracle Reports v9.0.4.0.33, Oracle Forms 9i, SQL, PL/SQL, TOAD v8.0.1.X, SQL Loader, Oracle Discoverer 4i/9i/10g, MS Access

Confidential

Sr. Database Developer

• Created strategy for creating of reporting system by implementation of Oracle Discoverer Desktop, Plus, Viewer, Administration so that statewide users could run adhoc reports
• Worked on Dimension modeling star schemas
• Working with OWB and oracle workflow to design and schedule.
• Created Oracle Discoverer End User Layer EUL or Repository , Business areas, Folders, Summary Folders, Custom Folders, Custom Joins In Discoverer Administrator.
• Upgraded from Oracle Discoverer 4.1 EUL to Oracle Discoverer 10g EUL.
• Populated Database tables to EUL from different schemas including Star Schema in Discoverer Administrator.
• Exported and Imported End User Layers eex files and Business Areas eex files Development to QA and QA to Production
• Created reports using Discoverer desktop, Created Table layout and Crosstab Layout reports in Workbooks
• Migrated Workbooks and Business Areas .eex files development to Production
• Scheduled the Reports, granted privileges on report objects.

Environment

Oracle database server 10g/11g, SQL, PL/SQL, TOAD v8.0.1.X, SQL Loader, Oracle Discoverer 4i/9i/10g

Confidential

Database Developer

Responsibilities

• Requirements gathering, writing specifications, flow charting, designing and creating Adhoc reporting system for the Agency using web-based business intelligence and data warehousing.
• Reengineered the Health Care database.
• Assisted in reengineering the Provider database
• Involved in flow charting using Visio.
• Implementation of Oracle Discoverer.
• Web based Report Application Development using Oracle Discoverer.
• Fetching reports using Toad and Oracle 9i. using SQL and PL/SQL.
• Writing and generating Access reports.
• Worked on state wide special projects, produced reports.
• Requirement analysis and Flow charting of HCPR Health Care Practitioners project.
• Testing the application including unit testing and black box testing

Environment

Oracle database server 10g/11g, Microsoft Access 2000/2003, SQL, PL/SQL, TOAD v8.0.1.X, SQL Loader, Oracle Discoverer 4i/9i/10g

Confidential

Database Developer / Government Operation Consultant-II

• Requirements gathering, writing specifications, flow charting, designing and creating Adhoc reporting system for the Agency using web-based business intelligence.
• Involved in database design and preparing ERD.
• Involved in flow charting of the project using Visio.
• Worked with Oracle Discoverer Desktop, Plus, Viewer, Administration for Adhoc reporting as well as an efficient web-based business intelligence tools for users to access data warehouse database with the objective to present the data in report format that is well organized
• Created database tables and views and wrote database packages, procedures triggers, using SQL, PL/SQL and Toad. Designed and created custom reports using Microsoft Access 2000 2003, Oracle Reports v9.0.4 and Oracle Discoverer v10g
• Designed and implemented role based security for user authentication by creating predefined user groups that have access to specific set of reports within Oracle Discoverer
• Wrote test plans and test scripts to verify the automated processes
• Strong functional and technical skills in understanding user requirements and writing specifications.
• Proficient in sourcing fixes from Oracle Metalink Oracle Support for resolving day to day issues/errors
• Automated FETPIP, WISARD, Red Green, MMR and other WIA reports with data processing and report generation processes. This processes involved pulling data from Microsoft Access Oracle databases and using SQL, PL/SQL, SQL Loader, FTP process to load data into one Oracle database. The objective was to prepare user friendly reports using Oracle Discoverer.
• Assisted other groups within AWI for generating weekly and monthly reports. Participated in verification, troubleshooting and fixing of the issues with data processing and web based reports generation.

Environment

Oracle 9iAS/10g Application Server v9.0.4, Oracle database server 10g v10.1.0.2 / v10.1.0.3 , Oracle Reports v9.0.4.0.33, Microsoft Access 2000/2003, SQL, PL/SQL, TOAD v8.0.1.X, SQL Loader, Oracle Discoverer 4i/9i/10g

Confidential

Database Developer

Responsibilities

• Participated in design, analysis, requirements gathering, development, deployment, implementation and maintenance of web based reporting project on 'Permitting Allowances' using
• The primary focus of the project was on implementing reporting system and development of Adhoc Reports using Oracle Discoverer.
• Worked on flow charts, ER diagrams, Adhoc reports, installation, configuration/setup and administration of Oracle Discoverer
• Worked with Oracle Application Server 10g and created Discoverer portlets.
• Install and set up of End User Layer EUL for Oracle Discoverer
• Performed complete Discoverer administration functions including setup of business areas, complex folders, element hierarchies and joins between elements.
• Prepared Entity Relationship ER Diagrams using Erwin
• Prepared flow charts using Microsoft Visio 2000
• Extensively interacted with the user to understand and analyze user requirements
• Created logical and physical database objects based on user requirements
• Created reports using Oracle Reports Builder v10.1.0.2 and automated processes for database jobs and web report creation/submission.
• Designed the database elements and web reports to address software limitations and worked to implement workarounds to implement user requirements. Writing test scripts and test plans.
• Extensively involved in development of Adhoc Reports and training other co-workers on Oracle Discoverer and Oracle Reports.
• Created Permitting History report, Additional Permitting Info report, Time in House report, Time in House Trend report and Office Summary Reports using Oracle Reports v10.1.0.2
• Created training material and helped in training team members in Oracle Discoverer
• Participated in analysis, development, troubleshooting and maintenance of PPMTS project. Involved in debugging issues in the existing application using Oracle Forms v10.1.0.2
• Created and maintained database procedures, triggers, packages, table views
• Moved data and database objects from one database to another using Oracle export and import utilities. Worked on design and coding of Projects, Expenditures, Encumbrances Forms

Environment

Oracle 10g / 9iAS Application Server, Oracle database server 10g v10.1.0.2 / 8i v8.1.7.4 , Oracle Discoverer 10g, Oracle Forms Reports v10.1.0.2/v9.0.4.0.19/33, SQL, PL/SQL, TOAD, SQL Loader, Oracle export import, Erwin v3.5.2

Confidential

Database Developer

Responsibilities

• Fixing WIA programs Reports in OSMIS Project. Based on the requirements from AWI, WFI and 5000 statewide users, project involved fixing reports issues and creating programs for new reports for WIA performance measures, Red and Green, WISARD, FETPIP, Monthly Management Report MMR and ETA 9090/9091.
• Reviewed and fixed data warehouse extraction PL/SQL procedures and debugged issues to find and fix problems.
• Involved in flowcharts using Visio and ER Diagrams using ERWIN.
• Reviewed and debugged Oracle Reports 6i/9i running in Web environment and resolved issues reported by Users.
• Created Oracle Reports 9i complex matrix reports to be run over the web
• Assisted in configuring Oracle Forms Reports services in Oracle 9iAS application server
• Created SQL reports based on data from flat files, that was loaded into temp tables using SQL Loader and PL/SQL database stored procedures, functions and packages
• Involved with running WISARD file through Mathematica software to validate data
• Created strategy for creating of reporting system by implementation of Oracle Discoverer Desktop, Plus, Viewer, Administration so that statewide users could run adhoc reports

Environment

Oracle 9iAS/10g Application Server, Oracle database server 10g v10.1.0.2 / 8i v8.1.7.4 , Oracle Reports 6i/9i/10g, SQL, PL/SQL, TOAD, SQL Loader, Oracle Discoverer 4i/9i

Confidential

Project Lead

Responsibilities

• Unifi Oracle Applications Customizations Offshore Credit Check Application consist of a custom application used by Unifi Inc-USA for Customers for providing customers, the credit information, adding credit lines, providing manual as well as automatic credit approval. This custom Interface consists of 40 custom forms and 27 custom reports attached to Order Entry in 10.7 that is upgraded and converted to OM in Oracle Application 11i 11.5.8 . Export booking a custom application used for Unifi Inc available in 10.7 where forms were designed in Oracle Forms 4.5 and converted to 6i to attach/register Oracle Forms in 11i.
• Requirements Analysis and Designing of Database structure
• Creation of Entity Relationship Diagrams using ERWIN.
• Flowcharting using Visio.
• Implemented security using Roles, views, grants and Oracle security
• Documenting the Life Cycle of the project Requirement Analysis, Coding and Testing and providing training to the end users
• As technical consultant involved in mapping of tables/columns from 10.7 OE to 11.5.8 OM
• Gap analysis and wrote function and technical program specifications
• Wrote conversion programs for custom Reports, Procedures, Triggers and Packages
• Designed and developed custom Oracle forms and attached to 11.5.8 in AP, OM
• Designed and developed custom Oracle Reports 6i and attached the custom Oracle Reports to the application using Application Object Library
• Studied the change in functionality in Order Entry module in release 10.7 to 11.5.8 OM and customized Order Management business processes by customizing Reports
• Converted custom Matrix/Matrix-with-Group Oracle Reports 6i from 10.7 to 11i on AP, AR, OM, GL modules.
• Created new invoice printing reports in AR module i.e. Finance Charge Invoice Print Report using Oracle Reports Builder and registered with Oracle Apps using AOL
• Actively participated in design and creation of ER diagram to create logical database for data warehouse solution using Erwin
• Modified existing interface programs for 11i and re-wrote 7 interface programs to load data from external applications using SQL Loader, PL/SQL
• Implemented Oracle Workflow in OM using Oracle Workflow builder 2.6.1

Environment

Oracle Forms 6i/10g, Oracle Reports 6i/10g, Oracle database v8.1.7, SQL, PL/SQL, SQL Loader, Application Object Library, Oracle Workflow builder 2.6.1, HP-9000