Resume:
Seshu Kanuri
Skillset: Sybase + SQL Server + ORACLE + Data Warehousing. Kimball’s methodology, Inmon’s Methodology, Data Mart Modeler and Architect with ERWIN/ ER Studio / Informatica / Cognos/ Brio /Business Objects / Middleware / Data Modeling / Data Architecture / Data Analysis / ETL/ Data Extraction/ Data Migration.
Additional Skills: Internet Technologies/ Ecommerce, UNIX, NT, IIS, APACHE, SendMail, DNS and Web Hosting.
Date of availability :
December, 2003
Current Visa Status: Permanent US Resident.
Contact Ph Nos.: (860) 308-5470 (Work)
(732) 213-2422 (Mobile)
(732) 452-9222 (Home)
Email: seshu.kanuri@citigroup.com
seshukanuri@yahoo.com
Hardware/ IBM RS6000 Sun Sparc
OS : Windows N.T AIX
SCO Vr4 Solaris
Windows 2000 Novell NetWare 4.10
Languages: Visual Basic Delphi Pascal
HTML VB Script
SQL
Datawarehousing:
COGNOS Informatica
ORACLE Business Objects
Brio MS OLAP
ERWIN Crystal Reports 8.5
Databases: MS SQL Server
Sybase Adaptive Server
ORACLE
Modeling: Erwin 4.1, Visio, DB Artisan
Middleware: Platinum Infopump 2.3 and 3.1, Informatica ETL, Microsoft DTS
Test Tools : Preview, Load Runner, SQA
Summary of Qualifications :
15 Years of overall experience in I.T Management with Data Modeling, Database Systems Architecture, Database Reverse Engineering / Forward Engineering, Systems Analysis, Software Development & Systems Administration in the areas of Banking, Annuities, Mortgage, Stock Broking, Mutual Funds, Investments, Financial Services, E-commerce, Supply Chain and Helpdesk Operations on multiple database platforms.
12 Years experience in Sybase/SQL Server RDBMS, which includes Dimensional, logical and physical modeling, requirement gathering, gap analysis, schema design, development, administration and fine-tuning of Sybase SQL Server, Replication Server and application software. Deployment of software on wide area Network. Setting up of Sybase Server & clients on AIX/Solaris/Windows N.T / win95 / NetWare 3.12 / 4.1 workstations.
10 Years experience on Windows NT/2000 Server, NT Workstation administration and Sun Solaris UNIX Administration.
10 Years overall experience in Dimensional and logical database modeling, Star Schema (OLAP) Creation and Data warehousing using SQL Server 6.5/7.0 and Oracle 7.03/8.05, Infopump, Informatica/ETL, Cognos, Crystal Reports, Brio & Business Objects.
8 Years experience in E-commerce and web architecture using MS Site Server, Cold Fusion, IIS/NT, IIS/Windows2000, Apache/Solaris/Linux and DNS Administration.
Summary of job functions :
· Dimensional, Physical and Logical Modeling for OLTP and OLAP methodologies,
data mart and data warehousing applications in Sybase, SQL Server and ORACLE for Banking, Finance, Annuities, Equities, Share, Stock, Mutual Fund & Mortgage Processing applications.
. Star Schema Creation, Logical and Physical database modeling for very large 3 tier and N tier Client server database systems using SQL scripts and data modeling tools.
· Conversion of existing application on MS Access to SQL Server 7, ORACLE . Developed the required guidelines for device and table design, index schemes for best query performance.
· Assisted GUI developers develop the middle tier DA objects
· Unit, Integration level and Benchmark testing of user application.
· Carrying out database size estimation to create devices and user databases.
· Disk space management – Initializing, designating and dropping devices.
· Creation of user databases, moving transaction logs, changing database
ownership, dropping corrupted and suspect databases.
· Creating and assigning segments to user databases. Automating Maintenance of
thresholds using sp_thresholdaction and other custom procedures.
. Configuring Database integrity with Primary & Foreign Key references, Check
constraints, Defaults and Triggers.
· User administration - creation of users and groups. Changing user information.
· Addressing security issues - user management by granting roles, permissions to
database users for access rights.
· Maintaining Database consistency using DBCC checks and fixes.
· Version Control to keep track of database changes.
. Dumping and restoring database and transaction logs for recovery.
· Backup and Recovery plans for system and user databases. Automating
backup and recovery with cron jobs for daily maintenance.
· Fine tuning of server parameters and application queries to improve performance
using sp_sysmon dumps and Index strategies from show plan outputs .
· Designing and developing stored procedures and triggers for applications.
· Designing and developing triggers on tables to maintain data integrity.
· Writing stored procedures for reports generation.
· Conversion of stored procedures and triggers from Oracle to Sybase and SQL Server
to Sybase. Dealt with various porting issues.
· Monitored usage of disk space, memory and user connections.
· Unit, Integration level and Benchmark testing of applications.
. Setting up and configuring replication server for decision support systems.
· Developed several business processes for the day-to-day use of systems.
O/S Environament Expertise IBM AIX, SCO Unix, HP 9000, HP-UX 10.0, Sun Solaris 2.6/2.7, NT 4.0, Windows 2000, SQL Server 7.0
Education :
M.S (Science)
MBA (Marketing) Honors
Certified Network Administrator
Certified Systems Analyst
Professional Experience : Details of the Projects handled :
Data Warehouse Architect - Aug 2003 – Current
Citigroup, Inc. Annuities Division(Travelers Life & Annuity) - Hartford, CT
Currently leading a 9 member team in the architecture and design effort of Annuities Data Warehouse at Citigroup using Kimball’s Architecture & Methodologies with ERWIN, Informatica, Business Objects and Cognos as the toolset. Oracle 9i on SUN Solaris 2.7 is installed as database platform holding different schemas under the data warehouse, including the staging area, operational data store (ODS) and the data marts. Inmon’s methodology was initially used to create the ODS and now I have been designing multiple data marts ( Producer, Qualified Plans, CAM etc) off of the ODS.
1. Architected Oracle 9i based enhancements including Bitmap/Join Indexes, List Partitioning, External Tables, Index Monotoring
Data Warehouse Architect - Jan 2001 – July 2003
EB2B.com, Internet Based B2B Vertical Supply Chain(www.eb2b.com) - NY
Managed a 5 member team and lead the development effort of Retail Supply Chain and Customers Management Solutions under Kimball’s data warehouse methodology environment.
1. eB2B Trade Gateway
The Web based ‘Trade Gateway’ enables Pharmacy Retail customers to comply with electronic trading requirements (EDI) of large companies with minimal monthly costs. Web based datamart provides required Business Analysis reports for the customers
2. eB2B Trade Network™:
A hosted infrastructure that empowers Pharmaceutical retailers to increase the efficiency of their trading relationships with existing business partners, fully leveraging their existing investment in technology. The eB2B Trade Network™ powers eB2B Commerce’s hosted solutions for B2B trade: eB2B Trade Gateway™ and eB2B Trade Exchange™ which were designed for trade partner collaboration and automatic business document exchange. The eB2B Trade Network™ scales to handle millions of transactions per day and effectively support businesses of all sizes across the Trade Lifecycle™, which spans from product requisition to settlement.
My Role:
1. Managed and lead the architecture and development of pharmaceutical retail vertical supply chain management data warehouse for client reporting using Crystal Enterprise Server. Clients include Right Aid, Duane Read, Eckerd, Drug Fair etc.
2. Managed architected it’s Oracle7.3, Oracle 8.i, SQL Server 7.0 and SQL Server 2000 databases and data migration scripts to the data marts.
3. Designed and developed the USA Wireless Ecommerce Solution in SQL Server / Oracle, Using Erwin / ER STUDIO, Replication Schemes and DBARTISAN from Embarcadero technologies.
4. Migrated several data bases from Unix/ Oracle to MS SQL Server 7.0 on InterWorld Ecommerce Platform.
5. Informatica ETL and Microsoft DTS tools were used for data migration and transformations.
6. Developed Datamart Reports in Crystal Reports 8.X for client data analysis.
Database Manager - Jan 2000 – Dec 2000
X.com/PayPal, Internet Based payment System(www.paypal.com) - CA
1. Managed a 6 member team and lead as Database Manager for for X.com’s Internet Bank and Micropayments System named PayPal (http://www.paypal.com and http://www.x.com now merged into Ebay).
2. Designed and setup the replication schemess for failover safety and created automation
3. tasks for regular downloading of data from Eprofile (Internet Banking System) database. Performance tuning of Oracle Database running on Oracle version 8.05
4. Database Administration and tuning of queries for day to day production issues and redundancies. Worked on Sybase 11.5 and Replication Server on Windows NT and Oracle 8.05 on Sun Solaris.
5. Successfully integrated the X.com system with Paypal after the merger of the two companies.
6. Full life cycle development of the Sybase SQL Server databases including the phasing out of X.com’s Internet based banking and mutual funds division and supervised the final closure of the bank on 15th December, 2000.
7. Used Cognos (Powerplay and Impromptu) as reporting tools
8. Erwin 3.52 has been used as the data modeling tool.
9. Informatica ETL Tool was used for data migration and transformations.
Database Manager - Nov 99 – Jan 2000
IMotors.com, Internet Based Used Car Dealer(www.imotors.com) - CA
1. Managed a 10 member team and lead the Internet Platform effort as the Architect, data Manager & DBA for iMotors.com’s ecommerce site named http://www.imotors.com.
2. Managed the redesign of the database and improved the architecture. Worked on MS SQL Server 7.0 with Site Server and Coldfusion as the Server Side tool.
3. Identified several design problems in the Database design and implemented necessary fixes as a quick hit list. Submitted standardization recommendations for improving the naming consistency, performance and utility of the database systems existing.
4. Informatica ETL Tool was used for data migration and loading.
5. Used Crystal reports for the reporting. Erwin 3.52 has been used as the data modeling tool.
Datawarehouse Consultant and Technical Auditor - Sept 99 – Oct 99
AVON Products, Inc., Global Head Quarters (www.avon.com) - Newyork, NY
1. AVON has hired me as a consultant to study the referential integrity problems faced by their UK and Germany offices in the implementation of the datamart on which was not performing as much as the money they spent on. As a consultant for the project, I visited AVON’s offices in these two countries and conducted system study, technical architecture and functional analysis, Dimensional and logical model of the Star Schema for Marketing Datamarts at Munich and London for this Cosmetics Company using Oracle 8.03, Cognos (Powerplay and Impromptu) Datawarehousing tools NT and AIX as the OS. Erwin 3.52 has been used as the data modeling tool.
2. Used Informatica Powermart and Power center tools and audited the ETL processes and Implemented redesigned extracts, to load the data correctly to the destination databases.
3. Identified technical and operational problems in the Datamart design and ETT implementation. Submitted wide ranging recommendations for improving the performance and utility of the OLAP Systems on the existing Star Schema. Recommended the required ETL processes for data cleanup and movement to the datamart.
Datawarehouse Architect and Data Modeler - June 99 - August 99
Lucent Technologies ( Bell Lab Innovations, www.lucent.com ) - Warren, NJ
1. Managed a 5 member team and lead the system study, data, architecture and business analysis, Dimensional and logical modeling, design & development of the Star Schema for Datawarehouse Project “Lucent Business Knowledge.com” as OLAP System for the #1 Technology Innovations Company using SAP, Oracle 8, Informatica Datawarehousing tools, Business Objects and Cognos for Reporting. NT and AIX as the OS. Erwin 3.52 has been used as the data modeling tool.
2. Stored procedures and ETL programs for data cleanup and movement to the data warehouse.
3. Assisting the GUI Developers in creating the Reports components for the decision support interface and report generation.
Datawarehouse Architect - Jan 99 - to May 1999
Advanta National Bank, Inc., Horsham, PA (www.advanta.com)
1. Involved in the system study, analysis, Relational and logical datamodeling, design & Development of AIMS (Intelligent Mortgage System) using ORACLE 8.3, with VB6, Infopump 3.11 as GUI/Middleware Tools, NT and AS400 as the OS. Erwin 3.51 has been used as the data modeling tool. Star Schema has been created on Oracle 8.3.5
2. Created the Data Architecture for the OLAP database, required stored procedures and triggers for data transfer, cleanup and storage from DB2 database on AS400 Servers into Oracle Database (Using Oracle Default Gateway). AIMS System uses ART Enterprise 3.0 Artficial Intelligence Engine for Automated deal generation (As AI component of the application.)
3. Created the Infopump Scripts for data transfer and cleanup.
4. Assisted the GUI Developers in creating the ADO components for the decision support interface and report generation.
Datawarehouse Architect - Oct 98 - Dec 98
Customer Analytics, Inc., Burlington, MA (www.customeranalytics.com)
1. Involved in the system study, analysis, Dimensional and logical datamodeling, design & Development of Explorer++ Banking Data Warehouse System for CitiBank using SQL Server 7.0, Oracle 8.0, Sybase Adaptive Server 11.9 with VB6, OLAP, Microstrategy DSS, ADO, VB Script ASPs as GUI Tools, NT and UX as the OS. Erwin 3.51 has been used as the data modeling tool.
2. Created required stored procedures and triggers for data cleanup and movement to the data warehouse. Currently Developing English Query Application for artficial intelligence component of the application.
3. Currently Assisting the GUI Developers in creating the ADO components for the decision support interface and report generation.
Data Architect & Administrator - Feb 97 - Sept 1998
IBM Global Services, Austin, TX 78758, USA (www.ibm.com)
Besides the normal production database development, maintenance and recovery
jobs at IBM Austin, some of the important project assignments I have completed
for IBM and its customers are as under.
1. Involved in the system study, analysis, physical and logical database
design & Development of NWS Repository integration System using
Sybase 11.03, Adaptive Server 11.05 and replication Server with
JAVA, VB Script ASPs and Powerbuilder as GUI Tools, NT and AIX as
the Operating System.
2. Performance Tuning for IBM’s North Carolina Helpdesk Database Operations.
3. Application Performance Benchmarking for McAffee Help Desk System at
IBM’s Superlab, Gaithersburg, MD using Sybase 11.3.3 as the backend server.
4. Sybase Server Upgradations and Data migration for IBM’s Comprod, TEXACO,
LUCENT and SEARS’ Helpdesk databases.
5. Feasibility study for Integration of Chrysler Systems’ EAM Software with IBM’s
Assetworks Software to create a common repository for Lucent.
6. Trouble shooting 605 Errors and Performance Tuning/backup scheduling for
TEXACO and RYDER.
7. Handling IBM’s NWS Support desk as the main Sybase database resource.
8. Development and maintenance of Infopump Middleware scripts for data migration
between IBM’s NWS and CS System’s TMS repositories.
9. Database performance tuning for Lucent’s Helpdesk database at Boulder,
Colorado to improve the response time for their MHD database.
Sr. Manager I.T - Jan 94 to Feb 97
Karvy Consultants Ltd., Hyderabad, India (www.karvy.com)
As Sr.Manager of I.T I was incharge of a 30 member I.T team and managed the 1) Installation of Systems and Tools for a 2000 Employee Database driven stock registry, 2) managed system study, analysis, logical and physical database design of SIGMA (Mutual Fund Management system) using Erwin 2.x, VISUAL BASIC + Windows Image API on windows 3.11 + SYBASE System 10 on Novell Network (Intel), and Windows N.T Server. This system also uses Modems, Leased lines, VSATs, Cray Routers and E-mail.
Manager Systems & Database Administration, - July 1984 - Dec 1993
Bharat Petroleum Corp. Ltd., India ( A Government of India Enterprise )
Worked as Manager I.T I have managed a 15 member team and has lead the Systems Study, design & development of BPCLIP ( Marketing MIS System) BPPAY ( Pay Roll Management System) and BPCASH(Finance & Accounting System using SCO - FoxBASE+ on Netware, Sybase RDBMS, UNIX(HP 9000) and
NetWare 2.2 Networking.
Applications Developed as Project Lead:
Mutual Fund Account Management System
Insurance Client Management and Accounting System
Equity Stock Accounting and Transaction Processing System
Inventory & Distribution Management System
IPO Processing and Stock Allocation System
Financial Accounting System
|
