Summary

• Over 15 years of comprehensive experience in Information technology
• Excellent implementation experience of Enterprise / Web / Client Server systems using WebFOCUS, FOCUS, Java, J2EE, JSP, Servlets, EJB, XML, HTML and Java Script.
• Extensively worked on WebFOCUS 4.3.6/4.3.5/5.3/7.1.4/7.6.4/7.6.9/7.6.10/7.7.01/7.7.02 /7.7.03 Crystal reports 8.5/8.0.
• Expert in developing reports using graphical tools like Developer Studio 7.7.03, Report Assistant, Report Painter and Graph Assistant, iWay DataMigrator, Dashboard,
• Expert in developing web-reporting applications using WebFOCUS Scheduling the reports using Report Caster, deploying the reports on web pages using HTML hyper links, creating web based tools using MRE tools.
• Good knowledge in System Architecture and Design Patterns.
• Developed Web applications using HTML, XML, and JavaScript.
• Experience with Microsoft.NET Framework, Visual Studio. NET, ASP.NET, C , VB.NET, ADO.NET, Web Forms, Win Forms, XML, XSL/XSLT, Web Services.
• Extensive experience in design, development and implementation of Internet/Intranet applications using C , ASP, ASP.NET, VB, VB.NET, IIS, ADO, ADO.NET, HTML, DHTML, VB Script, Java Script, XML, XSL, COM/DCOM, Visual Source Safe.
• Strong experience in Design, Development and Implementation of Multi-tier applications.
• Well experienced in COM/DCOM/COM technologies
• Microsoft Certified Professional Microsoft Certified Solution Developer: ID 1495738
• Good expertise in storing the data in XML files.
• Experience in preparing Requirement Specifications, Functional Design Specifications, Detail Design Specifications, Various test plans and test cases.
• Possesses good skills in implementing Databases with Focus, Teradata, DB2, and Sybase, MS-Access, Oracle, and SQL server.
• Experience in Dimensional Data Modeling Star Schema, Snow-Flake Schema, Fact and Dimensional Tables
• Involved in Business requirement meetings with Business Users and prepared Technical Design Document for ETL development Process
• Extensive experience in UNIX.
• Capable of communicating well with both technical and non-technical people.

Skills/Tools

• Operating Systems: Windows-NT/XP, Windows 95/98/2000, MS-DOS, UNIX
• Languages: Focus, VB, VB.NET, JAVA, C, C , FORTRAN, SQL, PL/SQL
• J2EE: EJB, JSP/Servlets, JDBC, Java Mail, JNDI
• Web Tools: XML, XSLT, HTML, ASP, ASP.NET Struts Frame Work
• Web Servers: IIS, Apache Tomcat Server
• Application Servers: WebLogic 5.1/6.1, WebSphere 4.0/5.0, IIS, IPlanet.
• RDBMS: Essbase, Oracle 7.x/8.i/9.i/10g,Teradata, SQL Server 2000, DB2
• IDE: WebFOCUS Developer Studio, WebFOCUS MRE thin client tools, InfoAssist
• Reporting Tools: WebFOCUS 7.7.03, Developer Studio 7.7.03,Dashboard Report Caster, Report Painter, MRE, Crystal Reports 8.0/8.5, SAS/7.0,
• MS-Excel, Cognos, Business Objects/5.1
• ETL Tools: Informatica Certified Designer, iWay DataMigrator,
• Objects Model: COM/DCOM, COM , MTS and .Net components
• Data Modeling Tools: Erwin 3.5.2, Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension Tables

Professional Experience

Confidential

Sr. WebFocus Developer

• The objective of this project is to eliminate trade secret claims made on hydraulic fracturing chemical disclosure reports posted to FracFocus.org
• The purpose of this project is to create automated reporting capabilities utilizing the system style disclosure format for hydraulic fracturing chemical disclosures in the US Land market.
• Baker Hughes has implemented a policy to move to a system format. This policy will impact how Baker Hughes discloses hydraulic fracturing chemicals only on jobs where Baker Hughes is the primary pressure pumping services provider. In instances where Baker Hughes is a third party supplier of products directly to a customer or to another pressure pumping services provider, then trade secrets protections previously employed may be utilized dependent on supplier approval applies to bulk and third party sales and Water Management sales of products that are generally disclosed on FracFocus.org.
• Created WebFOCUS reports from user specifications.
• Modified reports that have been developed in Webfocus.
• Developed and maintained Web Focus Reporting system.
• Worked with the client management and IT staff to develop the functional requirements from which the applications were developed.
• Create Dashboard Applications, launch pages, and reports
• Create advanced level reports with drilldowns to extensive detail reports.
• Interface with business customers and management for scope, estimates, requirements, and project deliverables.
• Create and maintain production reports. More

Environment: Web FOCUS Developer Studio 7.6.11, Report Caster, Oracle 10g, UNIX, Windows

Confidential

WebFocus Developer

• Confidential is a privately held home decor retail chain based in Plano, Texas. The chain currently operates 67 stores in 20 states, primarily in the Southeast and Midwest.
• Created WebFOCUS reports from user specifications.
• Modified reports that have been developed in Webfocus.
• Developed and maintained Web Focus Reporting system.
• Worked with the client management and IT staff from various departments to develop the functional requirements and technical documentation from which the applications were developed.
• Create Dashboard Applications, launch pages, and reports in the Web FOCUS Managed Reporting Environment.
• Created various reports and custom user interfaces.
• Create advanced level summary graphs with drilldowns to extensive detail reports.
• Interface with business customers and management for scope, estimates, requirements, and project deliverables.
• Create and maintain production specification and support documentation. More

Environment: WebFOCUS MRE 7.7.05, Developer Studio 7.7.05, Report Caster, Java Script, HTML, Oracle 11g, Windows

Confidential

WebFocus Developer

Created a system of information structures for PWE Public works Engineering to allow a business user organization to quickly provide information to assist their customers, provide information to supervisors, managers and executive in determining the best courses of actions. Designed a self-serve reports information structure the most commonly asked operational questions to be answered in a timely manner that allows the business user to get the information they need for reporting .The ILMS application will update the informational data mart structures as required by the business organization.

Responsibilities:

• Created Dashboard Applications launch pages, and reports in the Web FOCUS Managed Reporting Environment.
• Create advanced level summary graphs with drilldowns to extensive detail reports.
• Interface with business customers and management for scope, estimates, requirements, and project deliverables.
• Created Web FOCUS reports from user specifications.
• Create and maintain SDLC documentation for all aspects of applications development and support
• Troubleshoot problems in Web Focus Application

Environment: WebFOCUS MRE 7.7.03, Developer Studio 7.7.03, Report Caster, Java Script, HTML, Oracle 11g, Windows

Confidential

WebFocus Developer

• Supported BNSF Engineering services department creating reports to the management for PTC project
• Developed self-service applications to the manager's for daily ongoing support activity reports with Reporting Hyperlinks. Multiple report that drilled down to detail, with user interfaces delivered in a variety of formats, including Excel, HTML, and PDF also provided to have reports, visualize data with graphs and charts and drill down from summaries to details.

Responsibilities:

• Created Reporting procedures for populating database driven Dropdown boxes.
• Managed and controlled flow of Procedures with Dialog Manager.
• Developed reporting procedures FOCEXEC , which call reports conditionally
• Using Developer Studio 'SQL pass thru' functionality developed reports.
• Create advanced level reports with extensive drilldowns
• Created various reports and customs user interfaces.
• Used JavaScript Style sheet for formatting the report
• Utilized WebFOCUS Report Caster to schedule and distribute the reports to E-Mail.

Environment: WebFOCUS MRE 7.7.03, Developer Studio 7.7.03, Report Caster, DB2, Teradata Java Script, HTML, Windows.

Confidential

WebFocus Developer

• The reports for management to review the statistics for Food stamps and MO HealthNet web application reports.
• The Data is extracted from FAMIS database Family Assistance Management Information System Using CoolGen Cobol/Db2 Programs . These programs are scheduled to run on last calendar day of every month. Each extract file is loaded into data warehouse table.
• When the user logs on Webfocus to request online reports from Launch page this reports picks up the data against data warehouse tables to produce reports. Based on report level security for each FAMIS reporting groups, State office domain - This includes all information for all FSD Family Support Division Offices within that FAMIS FSD Office within the State of Missouri will access to statewide FAMIS customer statistical data, similarly for county office field Liaison office domain.

Responsibilities:

• Developed reporting procedures FOCEXEC , which call other reports.
• Managed and controlled flow of Web FOCUS Procedures FOCEXEC with Dialog Manager
• Created Reporting procedures for populating database driven Dropdown boxes.
• Used Style sheet for formatting the report.
• Used JavaScript Style sheet for formatting the report.
• Involved in all the phase of the project development, interaction with Various Business Users to transform the Business Logic to reports.
• Work directly with users for evaluation, or issue resolution
• Communicate effectively with various levels of management, Transform Data to the business requirement

Environment: WebFOCUS MRE 7.7.03, Developer Studio 7.7.03, Report Caster, DB2, Java Script, HTML, Windows.

Confidential

WebFocus Developer

Confidential , Developed Financial Reports for the Commercial lines Personal Lines Departments including reports for Loss control, Risk management regional supervisor, Bound Underwriters, Special risk analyst, where they can analyze the premiums earned, Incurred losses from Different branches from all the agency, converted external spread sheet specification to WebFOCUS language according to financial business needs with styling for the reports. The primary objective is to provide comprehensive reporting of all data collected. These reports are generating monthly fulfillment and also other required subsets of reports. Analyzing reporting requirements and providing scheduling mechanisms for the systems, these reports are delivered via Email in PDF Format to Department Managers, Underwriter Supervisor and Underwriter on the monthly bases scheduled through Report caster where they able to track the Performances of all branches.

Responsibilities:

• Created Metadata Master file, access file to store information about each data source.
• Managed and controlled flow of WebFOCUS Procedures FOCEXEC with Dialog Manager.
• Developed reporting procedures FOCEXEC , which call other reports conditionally
• Utilized WebFOCUS Report Caster to schedule and distribute the reports to E-Mail.
• Used Style sheet for formatting the report.
• Communicate effectively with various levels of management, both verbally and in writing.
• Work directly with users for evaluation, or issue resolution

Environment: WebFOCUS MRE 7.7.03, Developer Studio 7.7.03, Modify Report Caster, DB2, Java Script, HTML, Windows.

Confidential

WebFocus Developer

• Confidential Managed Transportation Service provider: On-Demand TMS a complete capability that allow you to mine the extensive database of shipment history for decision-making. With the information collected from numerous sources and integrated into a common database, created reports, valuable to all levels of personnel within organization. These reports generally fall into two categories: management reports and operations reports. Management reports are summary reports that management personnel use to determine performance, spot trends, and correct problems. They include: volume analysis, performance analysis, financial analysis, and trend analysis. Operational reports are detail reports used by operations personnel to manage the day-to-day business of an organization. They include: schedules and notifications for daily operations for trading partners. They ensure that all parties are informed of their role and the schedule.
• For Lean Logistics - Report conversion project. Converted SQL-based reports, written against an ACCESS database, were converted to WebFOCUS. Desktop Developer Studio application later imported into Dashboard and MRE .The html pivoted slice and dice information to benchmark against a similar ACCESS application.

Responsibilities:

• Developed reporting procedures FOCEXEC , which call other reports.
• Managed and controlled flow of Web FOCUS Procedures FOCEXEC with Dialog Manager
• Created Reporting procedures for populating database driven Dropdown boxes.
• Used BI Dashboards for launching MRE Reports.
• Worked with SQL to interact with database.
• Used JavaScript Style sheet for formatting the report.
• Involved in all the phase of the project development, interaction with Various Business Users to transform the Business Logic to reports.
• Transform Data into various Line Graphs to analysis the business requirement.

Environment: Web FOCUS MRE 7.7.02, Developer Studio 7.7.02, Dashboard, Report Caster, Oracle 10g, ACCESS, JavaScript, XML, HTML, Windows

Confidential

WebFocus Developer

• Supported Confidential
• New wealth Management System which provides the capability for employees in high net worth to track relationship with the clients, customers and prospects alike opportunities, activities, and client profiles to the high net worth business line was created and maintained through this system. Using WebFOCUS Developer Studio 7.7.01 tools included Power/Report/HTML Painter s and PDF Layout as Style sheet then enhanced the code via the Editor deployed to Dashboard and reports scheduled from Report Caster. Most fex's had multiple rolled up and drilled down capability from Division, Group, Section, and Regions contingent upon parms. HTML, PDF and Excel with JavaScript validation, this system shall validate to indicate the desire to view the dashboard has the data entitlements to perform the function. WebFOCUS using a self-service launch page with Reporting Hyperlinks. Multiple tabular/graphic reports that drilled down to detail, Deployed Developer Studio developed reports to Dashboard and MRE launched by URL's. Developed reports with user interfaces

Responsibilities:

• Analysis of Detailed business requirements specification of user requirements
• Created Reporting procedures for populating database driven Dropdown boxes.
• Managed and controlled flow of Procedures with Dialog Manager.
• Using Developer Studio developed reports to Dashboard and MRE launched by URL's
• Used JavaScript for client side validations
• Used Style sheet for formatting the report.
• Involved in all the phase of the project development, acceptance and production.

Environment: Web FOCUS MRE 7.7.01, Developer Studio 7.7.01, Dashboard, Report Caster, InfoAssist, Oracle 9i, JavaScript, XML, HTML, Windows

Confidential

WebFocus Developer

• Confidential is the largest Independent Telecommunications Provider and fourth largest wire line telecommunications provider in the United States - based on access lines - serving 33 states with 7.5 million access lines, 2.1 million broadband customers, 450,000 video subscribers and a nearly 17,000-mile core fiber network. CenturyTel acquired Embarq Corporation EMBARQ one of the leading communications companies in the United States. My role was involved in creating reports for the customer service on going support. Developed Dashboards self-service applications to the manager's for daily on going support activity conversion reports
• The reports are accessible through the WebFOCUS Dashboard expand the reporting capabilities with more sophisticated designs to meet needs. Reports can be delivered in a variety of formats, including Excel, HTML, and PDF also possibilities are - you can have reports, visualize your data with colorful graphs and charts and drill down from summaries to details.

Responsibilities:

• Analysis of the system that included gathering user requirements
• Created Metadata Master file, access file to store information about each data source.
• Developed different types of reports using both MRE and Developer Studio.
• Using Developer Studio developed reports to Dashboard and MRE launched by URL's
• Used JavaScript for client side validations
• Managed and controlled flow of WebFOCUS Procedures FOCEXEC with Dialog Manager.
• Web focus reporting system to Web based reporting system.
• Worked with PL/SQL procedures to interact with database.
• Created Reporting procedures for populating database driven Dropdown boxes.
• Created Reporting procedures and scheduled them to run daily using Report Caster.
• Used Lookup tables for populating the fields on HTML pages using WebFOCUS Procedures FOCEXEC .

• Used Style sheet for formatting the report.
• Created Various Mappings to migrate data from different databases and from flat files to the staging database Which is used to create the Reports
• Created Design for the mappings that is built to load the dimensions in the data mart.

Environment: Web FOCUS MRE 7.6.10, Developer Studio 7.6.10, Dashboard, Report Caster, Oracle 10g, InfoAssist, UNIX AIX 6.1, Windows

Confidential

ETL DataMigrator

Confidential is a leading global supplier of automotive systems, modules and components to global vehicle manufacturers and the automotive aftermarket. They have Corporate Offices in North American Van Buren Township, Michigan, Confidential . As an ETL Developer, was involved in creating the Repository by extracting the data from the various sources and other repositories. During this process had continuous interaction with the business users and the resources of the other projects working on different repositories. Involved in designing and development of data warehouse environment, liaison to business users and/or technical teams gathering requirement specification documents and presenting, identifying data sources, targets and report generation, The objective is extracting data from multiple sources in various formats for Plants, supplier and customer cross reference for world wide Visteon operations transforming it to fit business needs, and ultimately, loading it into a target system. The target system will generally be configured as a data warehouse or data mart that loads to any type of data storage structure. The structure itself will typically be a relational database, but may also be an application, file or other storage facility. The purpose of ETL is to reformat, cleanse and standardize data so that it can be analyzed or exchanged to address business needs and/or promote interoperability and can expect to have data presented in terms that are familiar.

Responsibilities:

• Worked closely with Systems Analyst in creating Process and Technical Design Documents for the mappings that are built to create extract files.
• Created Design Documents for the mappings that is built to load the dimensions in the data mart.
• Extracted data from different sources like SAP, DB2, progress, IMS, systems into Oracle database using iWay DataMigrator.
• Involved in all the phase of the project development, acceptance and production.
• Responsible for technical documentation of the entire ETL process.
• Involved in the interaction with Various Business Users to transform the Business Logic to ETL Process.

Environment: Web FOCUS MRE 7.6.9, Developer Studio 7.6.9, Dashboard, Report Caster, iWay DataMigrator, 7.6.8, Oracle 10g, UNIX, Windows

Confidential

WebFocus Developer

For County of Los Angeles, GGSD - General Government Systems Division Developed Financial Reports for the Auditors where they analyze the revenue from different resources of county, converted pseudo COBOL specification reports to WebFOCUS language according to financial business needs and used different types of styling for the financial needs in reports. The primary objective is to provide comprehensive reporting of all data collected. This includes generating month end fulfillment reports, daily and weekly, and other required reports. Analyzing reporting requirements and providing scheduling mechanisms for the systems, Also Reengineering/rewriting Cognos Reports to WebFOCUS.

Responsibilities:

• Documented Analysis, design development of the system that includes gathering user requirements.
• Developed reporting procedures FOCEXEC , which call other reports conditionally.
• Managed and controlled flow of Web FOCUS Procedures FOCEXEC with Dialog Manager
• Worked with SQL Procedures to interact with database.
• Coordinated integration and user acceptance testing
• Developed different types of reports using MRE
• Created Reporting procedures and scheduled them to run daily using Report Caster.
• Desktop Developer Studio application later imported into Dashboard and MRE .The html pivoted, drill downed, slice and dice information to benchmark against a similar Cognos application.

Environment: Web FOCUS MRE 7.6.7, Developer Studio 7.6.7, Dashboard, Report Caster Web FOCUS, Oracle 9i, UNIX, Windows.

Confidential

WebFocus Developer

Confidential , a unit of Verizon Communications, is a leading provider of advanced communications worldwide. Developed different types of Business reports and also International revenue Planning Analysis information for the management system to retrieve online, Management reports are used to track the business activities on their daily, weekly and monthly basis.

Responsibilities:

• Documented Analysis, design development of the system that included gathering user requirements.
• Created Metadata Master file, access file to store information about each data source.
• Migrated focus reporting system to Web based reporting system.
• Developed reporting procedures FOCEXEC , which call other reports conditionally.
• Managed and controlled flow of Web FOCUS Procedures FOCEXEC with Dialog Manager
• Migrated Web focus reporting system to Web based reporting system.
• Worked with PL/SQL procedures, functions and triggers to interact with database.
• Coordinated integration and user acceptance testing
• Developed different types of reports using both MRE and Developer Studio
• Created Reporting procedures and scheduled them to run daily using Report Caster
• Created UI's with 6 dynamic drop downs, which disabled other 5 once selected. Also had history/current fiscal year functionality with popup validation and hovering. Enabled 6 different departmental multiple tabular/graphic reports that drilled down to detail.
• Deployed Developer Studio developed reports to Dashboard and MRE launched by URL's. Used Report and Report Layout Painter to develop 10's of reports with user interfaces.

Environment: Web FOCUS MRE 7.1.4, Developer Studio 7.1.4, Dashboard, Report Caster Web FOCUS Self-Service, MS SQL Server, Oracle 8i, DB2, JavaScript, XML, HTML, UNIX, Windows

Confidential

WebFocus Developer

An industry in the design, development and production of photo masks for semiconductor and microelectronic applications Reporting environments were developed to keep track of day-to-day business, also transform Data into Graphs in gathering of business requirements and developing Business Analytics solutions in support of distributed platforms.

Responsibilities:

• Gather and document business requirements and develop Business Analytics solutions design development of the system that includes user requirements.
• Documented Analysis, Created Metadata Master file, access file to store information about each data source.
• Migrated WebFOCUS reporting system to Web based reporting system.
• Translate business requirements into technical designs and specifications
• Developed 80 different types of reports Tabular, Matrix, Drilldown using both MRE and Developer Studio.
• Transform Data into various Graphs to analysis the business requirement.
• Created Cross Tab Reports and drill down reports through using WebFOCUS Report Assistant.
• Developed reporting procedures FOCEXEC , which call other reports conditionally.
• Created Reporting procedures for populating database driven Dropdown boxes.
• Used Lookup tables for populating the fields on HTML pages using WebFOCUS Procedures FOCEXEC .
• Used Style sheet for formatting the report.

Environment: WebFOCUS MRE 5.3x, Developer Studio 5.3, Report Caster, BI Dashboards, SQL Server, Oracle 8i, DB2, Java Script, HTML, FrontPage 2000, Windows 2000.

Confidential

WebFocus Developer

• Confidential delivers comprehensive end-to-end payment solutions to acquirers and their merchants to reliably process millions of credit, debit and other card transactions every day.
• E-Connections reports are used to track their daily, weekly and monthly transactions.

Responsibilities:

• Designed and Developed business and presentation logic.
• Migrated existing FOCUS, Cognos, and Siebel reports to WebFOCUS.
• Developed WebFOCUS pages that process the results and embedded the values into the HTML pages.
• Created MFD's for Oracle, SQL Server Databases.
• Created Reporting procedures and scheduled them to run daily using Report Caster.
• Managed and controlled flow of WebFOCUS Procedures FOCEXEC with Dialog Manager.
• Provided Drill-down and OLAP capability using WebFOCUS.
• Developed various reports and graphs using Report Assist, Report Edit and Graph Assist.
• Utilized WebFOCUS Report Caster to schedule and distribute the reports to E-Mail, FTP and Printer.
• Used BI Dashboards for launching MRE Reports.
• Worked with PL/SQL procedures, functions and triggers to interact with database.
• Coordinated integration and user acceptance testing.

Environment: WebFOCUS MRE 4.3.x/5.3.x, WebFOCUS Self-Service, Developer Studio 4.3.x, Report Caster, BI Dashboard, OLAP, Reporting Objects, Focus 7.1, Oracle 8.1.7, MS SQL Server, DB2, Teradata, JavaScript, XML, HTML, Unix, Windows.

Confidential

WebFocus Developer

Project: Enterprise Call Center. Enterprise call center is a reporting environment developed to track and monitor telephonic transactions. This system is used to ensure callers are comfortable with the automated system and to track usage. The principal activities of the group are the provision of global travel, finance and network services, and provision of charge and credit cards, Travelers cheques and other stored value products to individuals. The company offers financial planning, brokerage services, mutual funds, insurance and other investment products help companies and institutions manage their travel, entertainment and purchasing expenses.

Responsibilities:

• Documented Analysis, design development of the system that included gathering user requirements.
• Created Metadata Master file, access file to store information about each data source.
• Migrated focus reporting system to Web based reporting system.
• Developed 80 different types of reports Tabular, Matrix, Drilldown using both MRE and Developer Studio.
• Created Cross Tab Reports and drill down reports through using WebFOCUS Report Assistant.
• Developed reporting procedures FOCEXEC , which call other reports conditionally.
• Created Reporting procedures for populating database driven Dropdown boxes.
• Used Lookup tables for populating the fields on HTML pages using WebFOCUS Procedures FOCEXEC .
• Used Style sheet for formatting the report.

Environment: WebFOCUS MRE 4.5.x, WebFOCUS Self-Service 4.5.x, Developer Studio 3.5, Report Caster, BI Dashboards, SQL Server, Oracle 8i, DB2, Focus, Java Script, HTML, FrontPage 2000,

Windows 2000

Confidential

WebFocus Developer

Cardinal health provides pharmaceutical and healthcare products distribution and services. These services and products include pharmaceutical distribution, provider services, medical-surgical products, and automation and information services to the healthcare industry, chain drugstores, hospitals and mass merchandisers. The company has operations in the United Kingdom, France, Germany, Italy, Australia, Japan, Argentina, Brazil and Canada.

Responsibilities:

• A Star Schema Data Mart is loaded into multidimensional cubes for financial analysis.
• Created Master files that contains metadata and also created Access File.
• Provided drill down and OLAP capability using WebFOCUS.
• Worked with Dialog Manager to create WebFOCUS procedures FOCEXEC that calls the other reports conditionally.
• Created 42 different reports like Cross Tab, Parameterized Reports, Tabular, Freeform Reports and Ad-Hoc Reports using WebFOCUS Reporting tool MRE.
• Created Cross Tab Reports and Drill through reports using OLAP Control.
• Developed testing documents such as test plans, test case specifications and developing test procedures.

Environment: WebFOCUS MRE 3.5.x, Report Caster, BI Dashboards, Modify, FOCUS, Oracle 8i, MS SQL Server, DB2, Teradata, SQL, PL/SQL, Java Script, HTML, Crystal Reports 8.0, Windows NT, Unix.

Confidential

Data Warehouse Developer

Confidential . This system provides services using which user can use the services provided by IP telephony like fax service, long Distance, voice Communication,

Responsibilities:

• Generating different types of reports for different sets of data to target customer segments, which can be changed in many ways to 'Slice and Dice' the data for further analysis.
• Creating PL/SQL scripts for data transformation as per program specifications
• Creating Dimension Maps, Transformer Models, Power-Cubes, Macros and drill
• Through and detail reports, catalogs, folders, filters, prompts, and calculated columns.
• Involved in writing of Stored Procedures.
• Generating Shell scripts for backups

Environment: Oracle, Windows NT, SQL Loader Batch procedures for Data Load, Cognos Visualizer, Cognos Impromptu Power Play

Confidential

Data Warehouse Developer

Innoventry's Network of automated financial kiosks ATM machines allows consumers to cash checks withdraw funds and perform other financial functions quickly, conveniently and securely. Cognos was used for multi dimensional analysis and forecasting the Existing Products for Innoventry ATM, Check Cashing and Money order and for New Products Money Transfer, Short Term Cash Loans and Instant Check cashing . Reports were also developed to forecast and schedule Cash Swap or Cash Add to machines.

Responsibilities:

• Involved in Extracting, Transformation and Loading of the Data using AbIntio ETL Tool.
• Involved in design, development and maintenance of catalogs, complicated reports using different types of drilldowns and multiple prompt selections.
• Trouble shoot and evaluated report effectiveness by tuning query data's and controlling user access.
• Extensively used Power play Transformer to move relative data mart data into power cubes and cube groups.
• Accessed data source and organized data into dimensional maps and transformer model by establishing joins between multiple queries.
• Defined, created Impromptu web reports using Distribution Shuttle Builder and published on NT server. Automated reports and cube generation through scheduler using macros to set distribution strategy to optimize network utilization and end user effectiveness.
• Configured multiple user access and defined dimension views and user class views for different user groups to provide high security for highly sensitive data.
• Responsible for publishing Power play Reports using Upfront to provide end users with a single, Web-based point of personalized access to reports.

Environment: Windows NT / 98, Oracle 8, HTML, SQL Loader, Impromptu Administrator, Power play, Power play Transformer and Power play Enterprise Server,

Confidential

Data Warehouse Developer

This data warehouse system deals with the training, recruitment, budget training, admin budget training, and course session enrollment of PeopleSoft HRMS Module. The data warehouse was designed and the data is migrated using ETL tool Informatica using Power connects to Oracle Database. Reports for the system were done using Cognos Impromptu and Power Play.

Responsibilities:

• Involved in creating different types of Impromptu Reports like Employee Based Details, Details of Training schedules of employees, Details of Course Catalogs, personal details of employees, Salary details etc.
• Involved in the development of catalogs, multiple ad hoc queries with complicated reports and different types of drill down reports on multiple prompt selection. Trouble shoot and evaluated report effectiveness by tuning query data and controlling user access.
• Extensively used PowerPlay Transformer to move relative data mart data into power cubes and cube groups. Assessed data source and organized data into dimensional maps and transformer model by establishing joins between multiple queries.

Environment: Oracle 8, Windows, SQL Loader Batch procedures for Data Load, IIS for NT, PowerPlay Enterprise Server, IE Upfront, PeopleSoft, HRMS Module, Erwin, HTML, Access Manager 6.5, COGNOS- Impromptu 6, PowerPlay 6.6 with web versions

Confidential

Data Warehouse Developer

This project was intended for Unichem PLC, which is a Pharmaceutical firm. This system generates reports using replenishment data available in the Inventory System and provides the Business partners with access to the underlying data and means to generate ad-hoc reports on their own.

Responsibilities:

• Prepared Universe/Report specifications through studying the available information and user requirements.
• Responsible for creating and maintaining a wide variety of reports using querying tools
• Including SQL and MS-Access to manipulate data from both internal and external databases
• Involved in creating Repository Users and Groups, then grant the repository privileges
• Used the Informatica Server Manager to create sessions and batches
• Created Various Mappings to migrate data from different databases and from flat files to the staging database Which is used to create the Reports
• Created DB2 tables, indexes, and clusters and maintained Views.
• Set up Business Objects / DB2 UDB database connectivity
• Proposed the deployment style by considering the HW/SW limitations development was done using thick-client modules and then deployed using Web Intelligence 2.5 to provide access to the international users for viewing the reports generated by the thick-client modules and allowing them to run ad-hoc queries over the Web .
• Installed Business Objects software, created a repository, created users and user groups and assigned them privileges and resources.
• Developed and tested the Universe semantic layer , which was used as a data provider.

Environment: Windows NT, SQL, Informatica 5.0, Power mart, Power Center, Business Objects 5.0, and Web Intelligence 2.5