Candidates About

 

Kasthuri Jegatheesan

SUMMARY OF EXPERIENCE

About 19 years of experience in IT with expertise in Data Warehouse (ODS-DM-ETL), Oracle Data Base, Exadata Administration /Architect/ Development, BI, Informatica, Data Modeling and in Analysis, Design, Development, Testing, Implementation and Maintenance of databases (including backup and recovery), PL/SQL, UNIX Shell Scripting, Reporting and front end applications.

 

·         In-depth expertise throughout DSS life cycle experience from Business Requirements – Conceptual Design – Detail Design phase – Development – Application Quality Assurance – Go Live – Maintenance.

·         Successfully designed (logical and physical), setup, developed and implemented the data warehouse for JPMI– from scratch, working with the business team, IT, management and consultants(CSC) .

·         Successfully stood up the conversion of ERP from SAP to Deltek with Oracle Data Warehouse, playing a significant role in all fronts from the database and the DW design through implementation of the Reporting in Cognos. Lead the setup of all environments from scratch .

·          Strong analytical and problem solving skills

·         Efficient in creating, managing and monitoring backup/recovery RMAN, setting up DataGuard

·         Professional experience with Star/Snow Flake, normalized Schema Design to meet OLAP needs.

·         Proficient in installing, configuring and performing upgrades of Oracle, OEM 12& 13& Informatica.

·         Skilled in monitoring the system performance and trouble shooting issues of OLTP and DW.

·         Excellent leadership and communications skills, planning, delegation and execution.

·         Reputation for high-quality work, cost reduction  and a commitment to user satisfaction.

·         Experience managing a team of technical associates, consultants, vendors and offshore associates.

·         Strong ability to translate business problems into technology solutions on time and budget. Proven experience in delivering innovative solutions using the latest technology in environment.

·         Ability to communicate in a variety of settings including 1 on 1s, small and large groups, with peers, project team, business partners, and senior management.

·         Worked extensively under heterogeneous environments including mergers, acquisitions and spin-offs  in Finance, ERP, Investments Brokerage & MF, 401K, ID Card (images) DOT,DET.

·         Highly motivated and able to juggle multiple priorities concurrently

·         Migrated from Oracle Linux/SAN to Exadata, implementing Transparent Data Encryption and Compression

 

OS                                        Linux, UNIX, Sun Solaris, Windows NT/2003/XP/7

DATABASES                     Exadata, ORACLE 12c, 11g, 10g, 9i, 8i, SYBASE 12.5, SQL Server 2008

TOOLS /Software              OEM 12c,13,  Informatica (PowerCenter and PowerExchange), Cognos 8.4,10, Business Objects BI, Erwin, RMAN, Oracle Designer, Toad, PL/SQL developer, SSH, PGP, CRM, Veritas Cluster,Sharepoint, Hadoop, Oracle Text

Web/Mail SERVERS          Informatica WebServices, Netscape Messaging Server, WAS (Weblogic)

LANGUAGES/SCRIPT      UNIX Shell Scripts, Perl, sudo, PL/SQL, C, C++, Java JDK

BACKUP SOFTWARE      Veritas NetBackup, AmeriVault, RMAN

STORAGE PRODUCTS     Exadata, EMC EVA6400, Sun StorEdge A1000/D1000, Clariion Cx600, SUN ETL 4/1800 Tape Library, EMC Symmetrix

 

EDUCATION                      Master of Computer Applications  (MCA) 93%

Bachelors in Science - Mathematics Major 93%

Ralph Kimball certified data warehouse training

Certified Informatica Training

AWARDS                         Rank holder, Best Employee Award,  Star Award,  Vanguard Awards (2), Innovation Awards

                

 

PROJECT DETAILS:

 

TASC – Englity -  ( 2010 – till date) 

Lead DataWarehouse Specialist (architect) & DBA ( ERP )

Environment: Oracle 12c,11g,10g, RHEL  VCS, UNIX Shell Scripting, SSH, PGP, Deltek ERP, Time and Labor, CRM, CRM On demand Ticketing, Onbase, ERWin, Exadata, RMAN, Informatica  PowerCenter and PowerExchange, Cognos, PL/SQL,TM1,SQLServer 2005 /2008, PricetoWin, SIMS,Visio, LDAP

 

Responsibilities

* Responsible for day to day operational support, reporting requirements. Design and develop normalized data warehouse and snowflake datamart that is scalable, efficient and meets the needs.

* Lead the Informatica ETL processes, replication and CDC, all core Deltek ERP (Costpoint, CRM, TESS, Docs Onbase ), Propricer, Govwin Webservices, ATS Kenexa BrassRing, Workbench, SIMS. Worked from scratch - install, configure , design and development through implementation & maintenance.

* Reloaded Cognos Framework into Database and developed facts from it used in reporting

* Support a number of external vendors(ICIMS, AMEX JPM,ADP,IJET,BRASSRING,ATS etc), design & develop interfaces for inbound and outbound files. Setup and configure encryption using PGP & SSH/SFTP. Created scripts to automate this process over DMZ

* Worked in many upgrades of Oracle, Informatica (PowerCenter and PowerExchange), Onbase & Cognos

* Design and develop ETL for budgeting data from TM1 to the warehouse and back to TM1 cubes.

* Migrated from HP Linux to Oracle Exadata, DB Upgrades to 10 to 11.2 and 12.

* Design , develop & implement WebServices from Informatica  to IBM, Govwin

* Integration of Informatica with Sharepoint & .Net, implementing automation of a number of  activities for the business saving time and money including time and labor, payroll processing.

* Design and implement an in house Resume Wizard talent search automating resource and talent using Oracle Text, ClobAgg, Stragg .Standard Reports and dashboards for the same.

* Install and configure Hadoop to test text search for Onbase files

* Creating dashboards and reports in Cognos for Usage Tracking, Manager Dashboard (Time, Payroll, Leave). Worked on the DW MV’s and Fact tables for PM dashboard, Employee, Bills payable, Invoice, Expenses

* Lead the GRID OEM setup, configure & monitoring for all instances and servers across the Prod, DEV, QA, TEST &  DR environments Linux and Windows servers. Setup AD Access control to GRID.

* Auditing across db’s and linux. Assist with Sox and ISO auditing  certifications

* Significant contribution in transitioning of db/server maintenance inhouse from hosting facility, thereby helping save significantly on the support contract costs.

* Auditing – both FGA and Policy management setup across all databases.

* Designed developed and implemented the automation of  ATS/Brassring with TASC DataWarehouse

* Automated cleanup scripts and maintenance across servers.

* Setup RMAN for backup across all instances, Dataguard standby & manual standby (scripts) .

*Providing technical  leadership and guidance to other developers while extensively working with the users defining report requirements and business algorithms , program management for scope of work and plan, senior management facilitating different issues and resolution.

* Awarded The VanGuard Award (Thrice) and Innovation Awards

* Direct development team of new methods and techniques

* Server migration for informatica, LDAP plugin install and setup, AD to DW and DW to AD updates.

* Golden Gate Trial install and test replication

 

JPMORGAN CHASE - INVEST LLC – BROWNCO  (2003 – 2007)

Data Warehouse Specialist  & DataBase Administrator (EIS/401K/Discount brokerage)

Environment: Oracle 10g,9i/8i, Sun Solaris 9,8,  VCS, VVM, UNIX Shell Scripting, ERWin, Oracle Designer, EMC Symmetrix – SRDF, Veritas Netbackup, Shadowbase DB, Informatica & Business Objects, PL/SQL, SQL, Axciom, LDAP, Ascential DM, Agile Methodology

 

Responsibilities

* Lead the EIS data warehouse application conceptual design – detail design phase logical & physical– development – application quality assurance – go live – maintenance and enhancements.

* Capacity planning and archival of data. Restore data from archival and ETL into ODS/DM

* Install Oracle, Create and configure databases for both OLTP and DW ( Dev, Stg, Uat and Prod )

* Database Modeling for OLTP & Data Warehouse – Star/ Snow Flake Schemas

* Development of scripts for Backup & Recovery, export of the databases

* Implement 3 Tier Schema update to existing database environments

* Coordinate STG, UAT & Production builds & release for database – release management using CVS

* PL/SQL development for the various modules  (Packages, Procedures, Triggers, Functions, Materialized views, Dynamic SQL) for OLTP and DW

* Trouble shooting problems in Application for backend (BAU Activities)

* Design and develop replication between Shadowbase and Oracle

* Report Design and development – Unix Shell Scripting, PL/SQL, BO (BI)

* Creating and follow SOP’s (Standard Operating Procedures) and CCP’s (Change Control Plan)

* Design of scalable, reusable and low maintenance ETL to extract data from various sources including shadowbase database, SIS, LDAP etc using Informatica mappings

* Conducted cost benefit analysis on various ETL tools, Front-end tools and designer tools.

* Train and manage users, advising other groups on DW development, EIS, best ETL practices.

* Successfully implemented two efficient phases within a short period of two years building the DW. Serving Finance, Marketing, Operations and Customer Service departments, over 170 metrics, supporting 65 users, generating over 45 complex reports + 52 automated reports.

* Worked with diverse teams including outside consultants (CSC), business users from all over the organization, consultants from India (for BAU tasks) coordinating the efforts

* Manage status reporting and problem escalation to senior technology and business users

* Obtain sign offs from all groups at every stage to ensure proper implementation of the project phase

* Followed agile methodology for phase 2 enhancements and successfully implemented subsequent modules based on backlog.

* 24*7 on call support

 

KSI  (1997-2003) Sr Consultant

CLIENT: EMPLANET  (2000 – 2003) Sr Consultant – Oracle DBA/Developer

Fully Automated e401k Plan  

Environment: Oracle 8i, ERwin, Sun Solaris 8, Weblogic, IPlanet 4.1, Veritas Cluster Server, Veritas Volume Management, UNIX Shell Scripting, Netscape Messaging Server, PGP, Netbackup and Amerivault

 

Responsibilities:

* Install Oracle, Database Creation, and Administration (DBA) for all STG, DEV, UAT, and PROD.

* Interact with DB, Application analysts and Business users for requirements gathering and validation.

* Logical design and Physical design (Data Modeling), Schema generation through ERwin, applying changes and maintaining the scripts for database changes and involved in UAT and Production release control of database changes

* Document and adhere to best practices for DB design. Development and testing standards including code walkthrough. Communicate the established guidelines to all levels and get signoffs.

* Designed and implemented the extraction of data from OmniPlus to Oracle (ETL)- k-shell, awk scripts and packages using PL/SQL, Materialized Views, and Dynamic SQL.

* Design and development of PL/SQL based on Middle Tier requirements

* Design, develop and implement complex queries for Payroll related services - scripts and process for upload from payroll providers, Net upload as files, manual entry, Validation procedures and corrections

* Scripts for backup and restoration (hot and cold), export and import of data and database objects

* Assist team members and users in diagnosing database related problems and problems in application

* PL/SQL and UNIX scripts to generate day-to-day reports needed for users, dba and sysadmin

* Used loadjava for few complex payroll validations

-- Multitasked on system Admin tasks

* Created Scripts to have Parallel Updates and Oracle Standby databases in the Staging environment just as in Production.

* Used Veritas Cluster Service (VCS) for High Availability and Failsafe

* Co-ordinate Production Installs and Updates, OS patches and packages

* Ensure proper Backups and restores for the various system using Netbackup and Amerivault

* Install and Renew Certificates for Oracle. Veritas, weblogic and web services

* Install and configure SSH, ProFTPC, CVS for Oracle database, PGP for secure file transfer, NFS

* Responsible for evaluating, testing, and creating implementation plans for all new technology, hardware, software, and processes to be implemented within the IT department.

* Facilitated development of required documents and procedures including DR document

* Design and derive the data model for Employee Stock Option and Stock Purchase plan.

* 24 X 7 on call support

 

CLIENT:              Massachusetts DET (Oct 2001 – Dec 2001 Part Time)

Call Center – NabCTI, IVRS System Upgrade  (DBA)

Environment:  Sun Solaris, NT, ORACLE 8i, Sybase, PL/SQL, PRO*C, Unix scripts & Cognos Impromptu for Reports

 

Responsibilities:

* Data modeling based on report requirements.

* Upgrade from UNIX to NT

* Upgrade from Oracle 7.3.2 to Oracle 8i

* Backup and Restore of the database – Scripts and Test

* Work with different teams – IVRS and CTI * Best Performance Award

 

CLIENT: VIISAGE TECHNOLOGIES  (1997- 2000) Sr Consultant (Oracle DBA/Developer)

24 *7 on call support for the databases on all projects

 

Digitized Driving License (DDL) for Ohio DoT- Porting CTree to Oracle

Environment: Dec Alpha OSF 3.2, Unix C, C Tree, Unix Shell Scripts, NT with VC++, Oracle 8i, PL/SQL and MKS toolkit, ERwin

Responsibilities:

* Modeling – logical and Physical design, Install Oracle, Scripts to Create Database and objects

* Capacity planning  & Oracle Database Administration – Database size approx 1.5TB

* Design the Porting application, Development of the purge process using FTP and Unix Shell Scripts.

* Modify backup utility to do Incremental Backup

* Scripts & packages (PL/SQL) to List and port all records from Ctree (Unix to NT) to Oracle

* Assist in application issues (VC++) and supporting PL/SQL code

* Porting the Unix scripts using MKS Toolkit.

* Sign off’s from the State at every stage of design through implementation.

* Manage status reporting and problem escalation to senior technology and business users.

* Team up with QA for testing plans to ensure all business needs are met

 

Digitized Driving License (DDL) for Florida Department of Transportation

Environment: Dec Alpha OSF 4.0D, Windows, Oracle 7.4, PL/SQL, PRO*C, Shell scripts, VB, ERwin

Responsibilities:

* Administration of the system including the database in the test server - Dec OSF 4.0D and Oracle 7.2.3

* Resolve issues with application, performance tuning and capacity planning.

* Create/Modify PL/SQL code, Pro*C and scripts for various modules including new enhancements

* Recovery of data (Oracle and at File System Level)

 

Digitized Driving License (DDL) for Arizona Department of Transportation 

Environment: Dec Alpha OSF 3.2, Sybase, Unix C, Shell scripts

Responsibilities:

* Configuring the RAID - mount as Advfs, DLT Tape Drives

* Migrating data from the old RAID to new RAID.

* Create devices, database, segments and tables, user logins and granting permission

* Scripts for database and transaction backup, troubleshooting

*  Created system procedures and modify code for new enhancements.

 

Mass DTA

Primary objective was to set a local backup server in sync with the remote production server, administer the system and the database.

Environment: Dec Alpha OSF 3.2 -OSF 4.0D, Unix C, Oracle 7.2.3, PL/SQL, Unix shell scripts

Responsibilities:

* Upgrade of the Dec OS from 3.2c to 4.0D & Setting up of the system.

* To create a local backup server in sync with the remote primary server.

* Troubleshoot backup and application problems in the primary server.

* Perform as system administrator for Unix and oracle.

* Porting the database between the Secondary and Primary Server.

* Configure RAID as Advfs and DLT Tape Drive.

* Moving the database to the RAID from local storage and expand the database in the primary server.

* Recovery of data ( Oracle and at File System Level )

 

CLIENT:              CREDENCE CORPORATION  (1995 – 1997) Sr Systems Engineer

Design and Development of diagnostic controller for Wolf Sequencer

'Wolf Sequencer' is a super compact tester designed for production testing of many types

Of devices, which include chips with a clock, speed within 200 MHz.

Environment: Sun Solaris 2.5, X-Windows, Motif, C, Java, CodeCenter, Purify, SparcWorks

Responsibilities:

* Solaris Administration, Create and manage users, Application Support

* Design and Development of prototypes in Motif and Java

* Design and Development of Commandline version in Motif and C

* Design and Development of GUI in Motif and C

* Testing and logging results using Purify

* Integration of all modules with GUI module

* Management of source code (version control) using SCCS

* Design and Development of special add-on features like dynamic display of summary report, tester map and bar chart

 

Advanced Graphical Icon Language Environment (AGILE)

Environment:   Sun Solaris 2.0, X-Windows, Motif, C, SparcWorks, CodeCenter, Purify, dbxtool

Responsibilities:

* Design and development of few modules/enhancements

* Solaris installation and administration

* Bug fixing* Testing using Purify* Management of source code using sparcworks

* Putback of code to the master code using SparcWorks

* Backup and client communication