Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Profile & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
Download Resume Format
KAYA CHENNAKESHAV
309 Anthony Wayne Drive
Collegeville, PA 19001
(610) 676-9876
Mobile: (484) 868-9876
kaya@yahoo.com
EXECUTIVE
SUMMARY
· Systems Analyst
with several years of experience in Information Technology.
· Extensive experience in
information management, IT, manufacturing, distribution, pharmaceutical and
health care industries.
· Excellent analytical
skills, extensive technical capabilities in database solutions, data
warehousing, system architecture, data modeling, BI reporting and Internet
technology and tools.
· An outstanding team player
with excellent management, communication and mentoring skills.
EXPERIENCE
April 2010 – February 2012
American Board of Internal Medicine,
Philadelphia, PA 19106
Database Developer/Analyst:
·
ABIM certifies one out of every
four practicing physicians in the United States in Internal Medicine and
nineteen Sub Specialties.
·
Full life cycle development
(SDLC) of code in PL/SQL using dynamic SQL, Parallel Pipe Line function,
encrypting secure data using DBMS_CRYPTO and related database objects for ABIM
Maintenance of Certification (MOC) financial and reporting system.
·
Full SDLC of code in PL/SQL,
using dynamic SQL, Parallel Pipe Line function, Analytic functions, use slowly
changing dimension (SCD Type 2) and related database objects for ABIM Clinical Supervision
Practice Improvement (PIM) system - a web based tool for analysis of medical
practice and analyze research trends.
·
Support database PL/SQL code,
table and related objects for web front end applications, content management
systems, performance tuning using Explain Plan, AUTOTRACE, DBMS_XPLAN,
SQL_Trace, ETL process using SQL*Loader and External Tables, use of Triggers
for automated data management, loading medical
research and reporting tables on a nightly schedule from ODS, code
change management using MKS, Oracle interface database architecture for SOA
implementation, and other data mining requests.
·
Assist staff in database
querying/reporting, QA, application design, product analysis, use of XML features, XML file generation, use of
UTIL_FILE, automated Error Log, use of Autonomous Transactions, random allocation
of medical specialty content using DBMS_RANDOM, Pro*C enhancements, statistics
computation on objects using DBMS_STATS, BI reporting, data cleansing, data
mining and related data analysis for medical research, medical survey and
medical exam communication processes.
·
Manage database objects and
analyze ASP.Net application codes, solve issues in front end call interfaces
for local and off-shore development teams.
December 2009 – March 2010
RemX IT Services: Assignment -
ABIM, Philadelphia, PA 19106
Database Consultant:
·
Full life cycle development of
code in PL/SQL for ABIM Practice Performance Selector Tool web front
application and ABIM IVR system. Used Parallel Pipe Line function, Bulk Collect
and Dynamic SQL, Ref Cursor output, use of MERGE feature and Associative
arrays, encrypted and decrypted credit card numbers using DBMS_CRYPTO and
related secure data.
May 2008 – December 2009
Iowa Foundation for Medical Care, Elkridge, MD
21075
Lead Programmer Analyst:
·
IFMC is healthcare data service and healthcare
quality management company providing for many Center for Medicare and Medicaid
(CMS) programs.
·
Involved in full SDLC of code
in PL/SQL for PQRI (Physician Quality Reporting Initiative) a Center for
Medicare and Medicaid (CMS) project.
Involved in data loads, NPI reporting projects, Registry data
submission/loads, Electronic Health Record (EHR) data load and processing. Used
object relational features, Oracle Types, Parallel Processing hints (8-core
processor), Parallel Pipe Line functions, Bulk Collect features and analytic
functions in data management, performance tuning using DBMS_XPLAN and stats
computation by DBMS_STATS.
·
Involved in Oracle database
objects design, development, ICD-9-CM, CPT, HCPCS code table setup, claims
processing code/objects, code standardization, maintenance, code review,
testing, software QA, system/process documentation and enhancements.
·
Involved in ETL loads from
Part_B, Part_D star schema objects to PQRI database objects using Parallel Pipe
Line functions and MERGE features, External Tables to load data into
Partitioned tables, loading Oracle tables using Informatica from flat files.
·
Other areas such as data
warehousing design, ETL processes automation using Informatica, capacity
planning data analysis, code change impact analysis, adherence to CMS System
Life Cycle Framework, system documentation and maintenance.
·
Provide guidance to staff in Oracle
database PL/SQL code, data modeling, objects setup, use of Bitmap Index for
data warehousing, performance tuning
using Explain Plan, Java, XML features in Oracle.
·
Also involved in system/process
enhancements to attain CMMI level 3 rating.
Jan. 2001 – Apr. 2008
Unisource Worldwide Inc., Exton,
PA 19341
Systems
Analyst:
· Unisource Worldwide Inc., is
one of the industry’s largest global marketers of printing, supplies, equipment
and distribution
· Involved in full life cycle development (SDLC) of database systems
for Assortment Management Tool (AMT) in PL/SQL, an application to manage
product state changes in source/legacy systems and in the Oracle data warehouse
· Involved in analysis for implementation of ETL tools for data
warehouse loading such as Informatica, Oracle Warehouse Builder (OWB) and SSIS.
· In an application DBA role maintained PL/SQL code base, ETL
objects, gather statistics, process tuning, change management using Source
Safe, Unix shell scripts and Cron/Maestro scheduling.
· Involved in full SDLC of New Item Request (NIR) an application to
analyze and create new products for marketing and sales. Architecture consisted of Oracle database on
UNIX, and Windows based SQL Server database and implemented automated loading, error processing and two
way data transfers between Oracle and SQL Server using (Data Transformation
Services) DTS process tuning and product performance reporting.
· Involved in full SDLC of Inventory Data Review a web application in
ASP.NET. Features included data review, cleansing, audit trailing, and
scheduled automated emailing, PL/SQL code, change data synchronization and backlog
analysis, concurrently managed data in both Oracle data warehouse and SQL
Server databases.
· Involved in full SDLC of Supply Chain Management (SCM) data
warehouse structures for sales, inventory forecasting, customer service,
backorder analysis and reporting.
Developed PL/SQL code in Oracle data warehouse for nightly update of
divisional hierarchy from financial system and also code to load data in SQL
Server using DTS and procedures in T-SQL.
· Business Development Reporting (BDR) application to create monthly
and annual summary reports for management about sales, inventory, customer,
vendor and other management reporting data load in PL/SQL and reports in
Crystal Reports.
· Full SDLC of Unisource Logistics RPM (Resource Planning
Measurement) to manage logistics, truck delivery metrics, DW Load Stats,
Unisource Customer Service Center (CSC) management application all Microsoft
ASP web applications. Developed PL/SQL
code, ASP code for web front end
consisting of ADO, Java script, VB Script, encryption of secure data along with
scheduling of UNIX shell scripts.
· Full life cycle development of Inventory Data Mart consisting
daily, weekly, monthly Fact table, National Accounts Sales (NADW), National
Accounts AR (NAAR) and enhancements to
Dimension tables in Data Warehouse star schema. Implemented Data Quality initiatives in ETL,
Automated load failure reporting, Error Tracking and rejected data review
processes. Implementation involved PL/SQL code, UNIX shell scripts, UNIX Cron
scheduling, scheduling in IBM-Tivoli Maestro, data transfer to/from Oracle-SQL
Server databases using DTS, stored procedure in T-SQL and email enablement.
Developed automated daily and weekly refresh for Sales Planning RPM summary
tables, triggered loads for web and BI reporting systems.
· Developed database objects, code and reporting structure for
monthly Georgia Pacific - Xerox joint venture sales data reporting.
Sep. 2000 – Dec. 2000
ICI Consulting Assignment -
Aventis Pharmaceutical, Collegeville, PA 19426
Applications
Analyst:
· Involved in the development of Unix scripts, PL/SQL code, tuning
queries using Explain Plan in conversion
from a DB2 system based on an IBM mainframe to an Oracle8 data warehouse
system. The custom reporting and user front end on Windows-NT utilizing Visual
Basic and MS-Access architecture.
· Involved in development, enhancement and testing of front end forms
and MS Access based reporting system.
Aug. 1998 - Aug. 2000
ICI Consulting Assignment -
SmithKline Beecham R&D, Collegeville, PA 19426
Analyst/Programmer:
· Developed Oracle PL/SQL code and reports scripts to assist Clinical
Data Management (CDM) department in clinical response analysis of patients to
medications being researched for data warehouses in UK and US.
· Developed Sybase (T-SQL) scripts and Access reports for Remote Data
Management (RDM) systems where data is validated at various clinical research
centers around the world.
· Assisted and supported
clinical staff and management in enhancement of Lotus Notes databases, provided training and support to IT, clinical
staff and other technical staff in various
database environments (Oracle, Sybase and MS-Access) and programming issues.
· Developed a Base Query Generator application in MS-Access to
connect to several MS-Access/Sybase databases via ODBC and create base table
queries for various RDM studies.
Nov. 1996 - Aug. 1998
Unisys Corp., Blue Bell, PA 19424
Business Information Analyst:
· Developed ETL scripts in PL/SQL for Worldwide Intranet Management
Reporting (WIMR) data warehouse using Oracle Financials (9.4 and 10.7) and for
PeopleSoft database objects. Also developed several scripts for Accounts
Receivable (AR), Accounts Payable (AP) and General Ledger (GL) data
extracts/transfer to SQL Servers databases for Web reporting. Developed UNIX
shell scripts, SQL*Loader interfaces and FTP scripts.
· Developed web application using ASP using ADO to display Oracle
database objects .
· Involved in development of a Internal Quote System, a database used to manage internal partner
quote approval process, automating the work flow between various business units
within Unisys Corp. using Lotus Notes 4.5. Developed Hyperion Release Library a
database to manage worldwide release information of Hyperion Accounting
Software using Lotus Notes 4.12.
· Developed SQL queries, automated reports in Siebel and enhanced
system configuration files for Siebel Sales Automation/Management System.
SKILLS
GUI: Visual Basic.NET, Visual Basic
4GL: SQL, T-SQL
Languages: C#, C/C++,
Java, PASCAL, FORTRAN & Basic
Database:
RDBMS: Oracle
11g, 10g, 9i, 8i, SQL Server, Sybase and MS-Access
Oracle Applications/Tools:
SQLLDR, Oracle Financials
Oracle Development Tools:
TOAD, SQL-developer, SQL-Navigator, OEM
ETL
Tools: Informatica,
OWB, SSIS, DTS
BI
Tools: Discoverer, OBIEE, Cognos
Language
Interface: PL/SQL
Data
Warehousing: Star Schema, Snow Flake, Hybrid models, Dimensional modeling.
Master Data
Management
Data
Modeling: Erwin, ER diagram, Metadata
Reporting
Tools: Crystal Reports
Other Tools:
Lotus Notes. Visio
Operating Systems: UNIX
(HP, SCO and System V), Linux, Windows-XP, 2K, NT, 95/98,
MS-DOS, VMS (VAX) and NOS/VE (CDC)
Web Tools: ASP.NET, VBScript, JavaScript, Active Server Pages (ASP), HTML,
DHTML,
PHP, XML, CSS, X
L
Change Management Tools: Clarify
(CRM), MKS, Visual Source Safe, Subversion
Misc.: JDBC, MS Office, OpenOffice
Suite, Lotus-123, TCP/IP Protocol
HONORS
· Georgia Pacific Information Security Expert of The Month -December
2001
· Temple University Scholarship
· National Merit Scholarship, Government of India
EDUCATION
Course work & training in
UNIX OS, C, C++, Java architecture and Programming
Pennsylvania
State University, PA
Graduate studies in Computer Engineering &
Information Science
Temple
University, PA
M.S Mechanical Engineering
South Dakota
School of Mines & Technology, SD
B.E Mechanical Engineering
University of
Mysore, India
·Target Tech: Obtain login username from Oracle V$ view for ODBC/JDBC, nominated
tip of the week Feb/March 2002
· Target Tech: String Trimming for Oracle versions before 8i, nominated tip of
the week Feb 2002
REFERENCES
Available
upon request
Download Resume Format
.JPG)
0 comments:
Post a Comment