krishnamurthy srinivasan

* Enterprise Warehouse - EW Quarterly Release * Implemented all the major enhancements bundled together as EW Quarterly release. * Coordinate with Data steward group to review the requirements. Gathered and prepared LOE from all the source systems and downstream systems to get funded for the Quarterly release. * Coordinate with offshore, source system and downstream system teams to Analysis, design, develop and implement the enhancements. * Manage the budget, resources and work plan. * Enterprise Warehouse - Server Refresh * As part of a contract with IBM, IBM provides new servers to EW development, UAT and Production environments. * Coordinate with Unix Admin, DBA and AD teams to check all the applications are installed on the new server. * Prepare a cut over plan. Review the plan with IBM, Unix Admin ,networking,security, DBA and all AD teams * Also initiate a process to request any new hardware and software to be installed. * Environment : Sun Solaris, Informatica PowerCentre 7.1, ORACLE 10g, SHELL SCRIPT, * PL/SQL, Business Objects XI R2

* The data for the RSS reporting system is mainly from the OLTP Customer Care and Billing system * CORDAPTIX (DB2/OS390). * Designed and Created a Datamart for Customer Information , Finance and 20/20 Credit Revenue * Reporting. * Designed and created a process for Delta loads to the Customer information Datamarts and metering data marts. * Implemented a slowly changing dimension for all the Characteristics using Change log tables. * Extensive performance tuning of SQL's , Informatica mappings and sessions. * Designed, developed and maintaining a Meta data tool using PERL . * Maintained the repositories, setting up the environments for development, test and production. Release notes documentation. * Environment : IBM AIX, Informatica PowerCenter 6.2, ORACLE 9i, DB2, SHELL SCRIPT, * PL/SQL, PERL

* Design and developed Brio SQR programs and Syncsorts to process the STR file weekly that contains cigarette shipments to retail stores at the brand level (25 million rows per period for a minimum of 900 million to a maximum of 1.2 billion) to create a wide file. * Designed and implemented an ETL strategy for loading the wide file to fact tables. * Created complex mappings for fact summarized data by year, quarter, monthly and weekly. * Developed catalogs, Cubes, for different types of drilldown reports for assortment, distribution, pricing, contract and promotional analysis. * Written Shell scripts and PL/SQL Environment: IBM AIX, Informatica Powercenter 5.2, Rapid SQL, Oracle 8i, Erwin 4.0, Cognos Impromptu, Powerplay and Transformer V 6.0, Unix Script, Syncsort, Brio SQR, Oracle PL/SQL

* Designed and implemented an ETL strategy for loading data from third-party Captura database. * Created mappings, filter, lookup, sorter and aggregate transformations, worklets and workflows. * Developed catalogs, Cubes and cross-tabular reports showing monthly total expenses made on each category by section, by individual manager and hierarchy report. Report showing expenses went for approval by section, by individual and the hierarchy. * Written Shell Scripts Environment: IBM AIX, Informatica Powercenter 5.2, Rapid SQL, Oracle 8i , Erwin 3.5, Cognos Impromptu, Powerplay and Transformer V 6.x, Unix Script, Oracle PL/SQL

* Designed and created a Datamart for call centre application. * Consumers can call to complain about the manufacturing defects, UPC catalog request, coupon requests, addition of mailing list, to inquire, to praise or to suggest. * Developed catalogs and cubes for standard reports like demographics of a CIC caller, brand demographics, manufacturing and non-manufacturing issues, Questionnaire reports. * Written Brio SQR Programs for processing the BAT Japan call center data and designed powerplay cubes for reports like calls per number of cigarettes manufactured. * Converted the SQR Programs to corresponding ETL Mappings, developed worklets and workflows. * Upgraded the Cognos Impromptu from version 4.01 to 6.0 and Cognos Powerplay V5.2 * Environment: IBM AIX, Informatica Powercenter 5.2, Rapid SQL, Sybase 12.5, Erwin 4.0, Cognos Impromptu, Powerplay and Transformer V 6.0, Unix Script, Brio SQR, Sybase BCP

* Designed and implemented a system to replace manual handwritten checks to check generation automation. * Created check request, check view history and check approval screens for Field Sales persons when they visit stores, chains, Distributors. * Written SQR programs for check generation to generate file for Peoplesoft Accounting system. Environment: Windows 2000 Server, Sybase SQL Anywhere V6.0, V7.0,Powebuilder 6.5,PFC, Brio SQR

* As an analyst on a 20-member team, analyzed, designed, and developed a custom, client/server Sales Force Automation application with remote clients. * Designed and implemented the promotional payment, Coupon inventory, contracts and survey module. * Created stored procedures and database triggers. ; * Written SQR programs for the payment file generation containing all the Issued/Stop/Void checks. * Environment: Windows 2000 Server, Sybase SQL Anywhere V6.0, Sybase Data Replication, Powebuilder 6.5,PFC, SQR V4.0, Perl scripts.

Developed a system for bank reconciliation and MIS Reports Environment: TATA UNISYS U 6000, UNIX SVR4, ORACLE 7.0, Powerbuilder 5.0

Employer: Jeraisey Computer & Comm.Services-Alkhobar-KSA Role: Systems Analyst/Programmer As a team member, designed and implemented a EUX/MAVEREC system. A data conversion project from PL/1 running under TSO/ISPF in an IBM mainframe environment to a Distributed Computing Environment (3 - Tier Architecture) using WinSock communications including interfaces to a Sun Unix system. Environment: IBM RS6000, WINDOWS 95, ORACLE 7.2, POWER BUILDER 5.0, MVS, IMS, Pl/1

* Designed and implemented a ETL strategy for Data conversion from the Call Center application CCMS2 (Siebel / DB2 UDB /IBM AIX) to customer care & billing system (CC&B) DB2/OS390 using Informatica. * Developed many mappings, mapplets, worklets and workflows. * Designed and developed Data integrity scripts for validating the data before and after the upgrade. * Maintained the repositories, setting up the environments for development, test and production. Release notes documentation. Environment : IBM AIX, Informatica PowerCenter 7.1, ORACLE 9i, DB2 UDB, SIEBEL 7.7, SHELL SCRIPT, Mainframe DB2, PL/SQL, Oracle Application Customer Care & Billing.

* Designed and implemented an ETL strategy for loading data from consumer marketing database to consolidate data from various consumer touch points. * Synchronized call center database with a third-party CTI database. * Delivered a business user report module in Cognos. ; * Developed Impromptu catalogs, cubes for different types of drilldown reports like high opportunity consumers, level of age verification and consumer segmentation. * Developed shell scripts. * Environment : IBM AIX, Informatica PowerCentre 6.2, Sybase Adaptive Server 13.5, Erwin 4.0, Cognos Impromptu, Powerplay and Transformer V7.1, Shell Script