Data Sales
Resume:
SENIOR INFORMATICA ENGINEER
Summary:
* Around Thirteen years of experience in the IT industry with Eleven years
of progressive hands-on experience in Data warehousing and ETL processes
using Informatica.
* Exposure to Informatica B2B Data Exchange that allows to support the
expanding diversity of customers and partners and their data with
capabilities that surpass the usual B2B solutions
* Worked with the B2B Operation console to create the partners, configure
the Partner management, Event Monitors and the Events
* Exposure to Informatica B2B Data Transformation that supports
transformation of structured, unstructured, and semi-structured data
types while complying with the multiple standards which govern the data
formats.
* Used the Data Transformation Studio 4.0 to create scripts that convert
complex data formats, into standard ones and then integrate to
Informatica's Power Center platform, using the UDO transformation.
* Defined JMS queues managed by ActiveMQ which is pipe-line for the data
between DX and PowerCenter.
* Defined the new queues in QueueAdmin.properties in DX, which are then
updated in the JNDI bindings file.
* Designed and developed efficient Error handling methods and implemented
throughout the mappings in various projects.
* Analytical and Technical aptitude with ability to work in a fast paced,
challenging environment and keen to learn new technologies.
* Proficient in understanding business processes/requirements and
translating them into technical requirement specifications.
* Excellent interpersonal and communication skills, technically competent
and result-oriented with problem solving skills and ability to work
effectively as a team member as well as independently.
* Developed effective working relationships with client team to understand
support requirements, develop tactical and strategic plans to implement
technology solutions and effectively manage client expectations.
* Very strong mix of Academic and Professional experience in the related
area demonstrated through the implementation of successful projects and
diverse roles and can cope well in a high intensity work environment.
Technical Skills:
Databases Teradata, Oracle 11g/10g/9i/8i, MS Access 2000, MS SQL
Server 7.0, DB2
ETL Tools Informatica B2B Data Exchange, B2B Data Transformation,
PowerCenter 8.x.x/7.1.3/6.2
Data Modeling Star-Schema Modeling, Snowflakes Modeling
Languages PL/SQL, HTML, DHTML, XML, Java
Tools and Servers Toad 9.6.1.1, Data Transformation Studio 4.0, MS Access
Reports, Microsoft Visual InterDev 6.0/1.0, MS FrontPage
98, SQL*Plus, SQL*Loader, FTP
Operating Systems Windows 95/ 98/NT/2000, XP, Linux, UNIX
Cisco Systems Inc, CA August'
13 - Till Date
EDW: ELT to ETL Conversion Track
This is an Architectural change to enable utilization of ETL capability of
Informatica and hence reducing the load on Teradata servers & saving CPU
time. Existing ETLs are modified to use ETL approach instead of using PDO &
utilize Informatica server to do the transformations.
Responsibilities:
. Analysis and identifying the list of all the tables across the EDW
based on the complexity and data volume to shortlist the eligible ETLs
(using the complexity Calculator document) for conversion from ELT to
ETL logic.
. Current code analysis where the ELT logic (Teradata queries) and
pushdown optimization is used in the informatica mappings and
workflows.
. Created the design document, including the high level design flow
diagrams.
. Implemented the new ETL logic for converting the existing ELT logic;
made use of the dynamic, persistant properties of lookup transformation
wherever applicable for building the informatica caches.
. Implemented the new feature of Native MERGE INTO in Informatica 9.5.1
for the SCD type-1 logic for the better performance.
. Parameterized all the session level Relational, Loader connections and
the filenames, filepaths. Defined the entries for these in the job
control table, these are used by the script that invokes infa WF.
. Enabled the concurrent execution (only with the unique instance name
property at WF level) for the reporting WFs to load the reporting
tables concurrently into 2 different databases (PROD1 and PROD2).
. The script to invoke the infa WFs are defined in the $U (scheduling
tool) jobs.
. Extend the support to the QA testing, creating the deployment documents
and ensuring the successful code deployment in the Prod environment.
. Extending the QA and PROD support for the daily cycles to fix issues
(if any).
. Identifying any bugs in the existing logic while doing the analysis,
and coordinating with the SME & Operation teams, and accordingly raise
the CRs in the defect tracking tool.
. Tracking all the issues encountered in the HP quality center, for each
phase/release, and identifying the lessons learnt to improve the
quality of code in the next phases/releases.
Environment: Informatica Power Center v9.5.1, Oracle 11 g, Teradata SQL
Assistant 14.0.1, SQL, PL-SQL, Microsoft Visio, Dollar U, Toad, Unix, Perl,
HP Quality center, PVCS, Kintana deployment tool.
Kaiser Permanente, Pleasanton, CA
August' 11 - July' 13
Claims Data Warehouse
To provide a consistent industry standard view of claims data to all
regions for reporting, analytical and non-real-time operational functions.
Responsibilities:
. Requirements analysis and converting the specifications to the
Technical design documentation.
. Created the Data flow diagrams for the high level design; Source data
analysis and identifying the lineage of the data elements (as a part of
the detailed design) to load the staging and reporting tables.
. Worked on the Change Requests for the scheduled release time frames.
. Involve in the design decision reviews for the implementation of the
ETL process for the CA region from different version of the Xcelys
(Oracle db) and GA Tapestry: Clarity (Teradata db) source systems
. Implement Regionalization logic in the same ETL code base though the
business rules are different for ROC (Regions other than CA) versus CA
regions. Created and used Persistent lookup cache on a table
(XL_CDW_RGN_IDENTIFIER) that requires to be looked up across various
sessions to load all the staging tables to determine the REGION_CODE
(NC/SC) based on the SOURCE_SYS_CODE (CA / ROC).
. Implemented the conditional logic at the workflow level, based on the
Business rules, to look up the Persistent cache for processing the
multiple cycles per day on incremental fashion, and to process the next
day cycle by dropping and recreating the PC. (The table is truncated
before staring the next day's 1st cycle).
. Responsible for handling all the financial data extracts (General
Ledger, Accounts Payable, and so on) from source to stage and stage to
reporting tables.
. Implementation changes to fix the workflows per the CRs, Eg: (a) to
convert from regionalization logic to the shared logic (Eg: certain
finance VENDOR tables) (b) To convert from Type1 to Type2; and then
historical fix to the existing data either using SQL scripts or one-
time mappings (ETL).
. Eg: While the source system has the Vendor data for CO and HI regions,
the CDW has only the CO region:
CR: Certain set of Vendor tables were identified to have shared logic
across all the regions: This requires the Historical data extraction
exclusively for the HI region from the source till the CR release date.
Solution in Informatica: Created one-time mappings to all such
applicable vendor tables: (a) Remove smart code logic per business
rules (b) used joiner transformation with Master Outer Join on Source
(Detail) and Stage (Master) tables; Insert into stage table using a
Filter transformation to populate data based on ISNULL (STG_TABLE_PK)
(c) Flag such records to identify easily.
. Identified and fixed the lookup transformations in certain mappings for
only the incremental dataset, to achieve a better performance, which
reduced the WF run time.
. Upgrade and maintain the consistency of the CDW table structures and
the ETL code for every Version & Release upgrade to the tables on the
Xcelys Source system side, and released to Prod on planned dates.
. Create Informatica deployment groups, Service Requests (Remedy tool) to
migrate the code to QA/ UAT/ PROD environments.
. Creating the parameter file based on the configurations
(Regional_Subject_Area, Line_Nbr, Param_Line) set in the
ETL_SESSION_PARAMETER table and defining all parameters at the workflow
level.
. Parameterize the mappings across the regions for loading the stage,
dim, fact tables.
. Enabled concurrent execution of the workflows to allow the parallel
execution of the same set of sessions pointing to different parameter
files to run cycles for each of the regions.
. Worked with the reusable transformations, mapplets, mappings, sessions,
worklets, workflows.
. Creating the Unit test case document with the test results and
screenshots.
. Managing the cycle loads in the QA, UAT environments on the daily basis
to ensure the data reconciles for the counts and amounts: across the
source to staging and staging to reporting levels for all the claims
and finance, shared (across all regions) tables.
. Worked on fixing the emergency RFCs by identifying the issues and
testing: before promoting to Prod.
. Worked with HP Quality center tool to identify the assigned defects,
and update the progress.
Environment: Informatica Power Center v8.6.1, Oracle 11 g, Teradata SQL
Assistant 14.0.1, SQL, PL-SQL, Microsoft Visio, Tivoli, SQL Developer,
Remedy tool (for creating SRs).
Bank of the West (BOW), San Ramon, CA
March 11 - July'11
Projects: RMS, TSYS Consumer
BOW developed an initiative to create a centralized DWH hub and the
necessary environment to support it (for regulatory compliance of Basel II
accord). A single repository of data to accommodate modeling, analytical,
reporting and management needs to satisfy BOW's Basel II regulatory
requirements.
Recovery Management system (RMS) - is to manage the Account recovery
transactions.
TSYS Consumer Credit Card is maintained by Total System Services in
Columbus, GA. A consumer credit card account is an unsecured, revolving
line of credit with a pre-authorized open-ended dollar limit granted to
creditworthy customers.
Responsibilities:
. Derived the Technical specifications document, based on the Functional
specifications.
. Worked with B2B Data Transformation to split the cobol source
files(Account Master, Account History, Account Transactions, Customer
Master, Score Master), and deployed the projects to the ServiceDB in the
server.
. Used CM_console command to split the original file into multiple files,
using the DT service name.
. Worked with Informatica Power Center to load the data into various stages
till it gets loaded into the core db.
. Loaded the data into delimited flat files for providing the TSYS data to
the Financing team
. Written the Views in Teradata database to handle the Change Data Capture
mechanism
. Used Pushdown Optimization technique in Informatica that enables faster
processing of the huge data loads
. Used MLOAD utility for the loader connections to load the cobol source
data into the Teradata database.
. Used Indirect file loading method to process the data catch ups for the
Recovery Management System
. Used parameter files widely at every layer of the data loads (SRC (B2B (
STG ( WRK ( PRE-CORE ( CORE), and avoided any hardcoding in the power
center workflows.
. Unit Testing in DEV, Prepare the migration checklist documentation,
QA/UAT Support, Production support.
Environment: B2B Data Transformation Studio 8.6.2, Informatica Power Center
v8.6.1, Teradata SQL Assistant 12,Windows 2000, ANSI SQL, UNIX Scripting,
PVCS
Cisco Systems Inc, San Jose, CA August 10
- Feb 11
Project : TL-9000 Certification (Re-joined the same project - worked
earlier)
As per the new version of the TL Hand book, the counting rules for one of
the metrics: SFQ (Software Fix Quality) are changed to the extent that the
whole design and development is to be re-built.
Developer Role:
. Derived the SDS document based on the Functional specifications.
. Developing, maintaining, and promoting the database tables and index
creation scripts.
. Developing mapping documents from QDI source to different data warehouses
based on the requirements.
. Worked as an Informatica administrator to create the development folders,
users and backing up repository etc.
. Developing Informatica workflows and perform the unit testing for the
developed mappings.
. Filling release management templates.
. Integrating all the mappings, sessions and created workflows in the
application folder and used $U scheduling tool to set the dependencies
between the workflows.
. Migrating Informatica mappings, sessions and WFs from development
environment to beta and production.
Technical and Application Production Support:
. Monitoring, working on problem tickets resolution, being on call for
production support on a rotational basis.
. Providing ongoing support for service view applications at agreed service
levels.
. Analyzing source system data, and working with source team to resolve any
issues.
. Interacting with system administrators, DBAs and other teams to
troubleshoot application performance issues.
. Analyzing long running SQL's and tuning them using Explain plans,
creating required indexes, hints etc.,
. Requirements gathering coordinate implementation of requested
enhancements for the applications.
. Develop test plan and scripts, conduct testing, and dealing with business
partners to conduct end-user acceptance testing.
. Ensuring that all production changes are processed according to release
management policies and procedures.
. Ensuring that appropriate levels of quality assurance have been met for
all new and existing applications / CRs.
. Ensuring that application changes are fully documented, supportable.
. Proactively identifying opportunities for change within the production
environment.
Environment: Informatica Power Center v8.6.1, Oracle 10g, Windows 2000,
Oracle PL/SQL, SQL Loader, UNIX Scripting, $U, Kintana package for the
production deployment, PVCS
VMware Inc, Palo Alto, CA
Jan 10 - July 10 Project: Everest BI
Salesforce.com system - used by entire Sales Organization of VMware to
manage customers, potential customers, track opportunities, contacts and
activities. This project - To extract the data from salesforce.com to the
EDW system (Keystone). The data is then loaded into the Sales BI and
Marketing data marts which are the basis for the Reporting.
Responsibilities
. Involved in the design and development of the Keystone Phase III to
extract the data from SFDC source system into the EDW database and then
to the Sales BI and the Marketing data marts.
. Developing the mapping documents and the ETL logic for loading into the
global data warehouse
. Worked with Salesforce UI, Apex explorer and Apex data loader.
. Creating Informatica mappings to populate the data into dimensions and
facts using various transformations.
. Handled the historical data loads into the Type2 dimensions facts, with
the Type1 dimensions and facts as the sources.
. Handled the logical deletes in the Type1 and the Type2 dimension and fact
tables.
. Implemented the re-startablility in the Type 2 ETL logic by including the
PROCESS_FLAG attribute in the type 1 Dim/FACT table that gets updated to
Y whenever the record gets processed; and by choosing the Source-based
commit at the session level. This attribute is reset to null in the Type
1 mapping - whenever a source row passes through the UPDATE flow.
. Avoid hard coding at the session/workflow level, parameterized and
defined the variables at the database level in a table for the minimal/no
changes while promoting the code across different environments like
QA/UAT/Production. Then with INFA mapping these values are used to
generate the parameter file.
. Worked on the condensation of the historical data in the Siebel system
(that is not handled by the Conversion process into the salesforce.com
system) - identifying the proposed set of the critical columns of Siebel
system, and then migrated to the EDW database directly.
. Documented Informatica ETL design & Mappings and Prepared the Unit Test
cases documents.
. Created and monitored workflow tasks and sessions using Informatica power
center.
. Used the workflow tasks such as sessions, email, command, decision, event
wait.
. Identified the tracks where the performance was poor and worked to tune
such mappings and workflows.
. Used Informatica scheduler, to set the dependencies between the jobs.
. Involved in creating Unix Shell Scripts for tasks like ftp, moving and
archiving files.
. Created Unix Shell scripts to call Informatica workflows using the PMCMD
command.
. Maintained an exclusive folder called Workflow Schedule in the
Informatica repository for scheduling the dependencies of the workflows,
and invoked each of the workflows from the command tasks.
Environment: Informatica Power Center v8.6.1,Salesforce.com UI, Apex
Explorer, Apex Data loader, Oracle 10g, Erwin, PVCS, Windows 2000, Oracle
PL/SQL, SQL Server 2000, UNIX Scripting
Aspen Marketing Services, Sandiego, CA
April 09 - Dec 09
Aspen Marketing Services is the fifth largest marketing services firm in
the United States and this is the nation's largest privately-held marketing
services agency. Aspen Portal is available for thousands of dealerships at
www.aspenmsportal.com.
Responsibilities
. Participated in the design and prepared the Technical documents based on
the Business Requirements Specifications.
. Worked on several applications in this automotive domain such as E-
Strike, Welcome Point, Smart touch 2.0., Enterprise reporting for ST2.0
customers.
. Handling the data feeds for General Motors such as Integralink, Maritz
for Nissan and Infiniti of North America to load the staging tables
related to the vehicle inventory, parts inventory, vehicle sales, service
repair order, Customer layout, Sales transactions, customer & email
suppressions, Hand raisers.
. Worked as the B2B DX Operator to define and configure the Partners and
create the Profiles
. Responsible for the DX Administrator tasks such as - Creating the
Application & Template, Defining JMS & JNDI connections, Creating Queues,
Defining End-Points - composite (scdl) file
. Used Data Transformation Studio 4.0 to simplify the complex data
transformations by visualizing the data and converting them into standard
ones.
. Worked with the new transformations of the Informatica 8.x such as
Unstructured data transformation, Java transformation, SQL transformation
. As a Flow Designer, developed the ETL mappings & Workflows using
Informatica Power Center
. Worked as the System Administrator to configure and administer Data
Exchange (DX) and PowerCenter
. As the Power center Administrator, Participated to Create the users,
grant privileges
. Responsible to create ordinary and reusable informatica folders and
manage privileges to the users.
. Creating users, groups in informatica Administration console for
informatica domain and Repository.
. Defined the JMS queues managed by ActiveMQ which acts as the means for
the data that passes between DX and PowerCenter
. Responsible to bounce and restart the DX server, the Active MQ, the Power
Center - as and when required.
. Configured the xeruntime.composite file to set the services (input
landing zone) for the flow templates.
. Extensive use of Command tasks, Decision tasks, email tasks in the
workflow design.
. Responsible in Migrating the Developed Components from Dev Environment to
QA and Prod Environment
. Created the unit test plan document and Involved in unit testing and load
testing
. Created ETL Mapping Specification templates and Unit testing templates.
. Used the mapping variables and parameters files at the mapping level,
workflow variables at the workflow level. Also per the requirements when
applicable - worked with assigning the mapping variable to the workflow
variable or the other way round.
. Implemented the HTML tags in the Unix Shell scripting while sending a
mail from the script that is in turn invoked from the informatica
workflow
. Filling templates for the migration of ETL objects migration, Unix Script
migration, database object migration and Scheduling request forms
. Involved in identifying and creating reusable objects, efficiency of the
ETL code, the business logic and standardization. Developed mapplets to
use across various modules which generate Batch ID and implement the Data
validation process.
. Developed UNIX Shell Scripts to Create Indexes, Truncate tables using Pre
and Post session command tasks
. Created and maintained the shell scripts and Parameter files in UNIX for
the proper execution of Informatica workflows in different environments.
. Created and maintained the Informatica Best Practices document as per the
Informatica Velocity rules.
. Being in the Lead role, taken the responsibility to review the work done
by the team, and make sure of the best performance of the mappings and
the workflows and the best practices are followed.
Environment: Informatica B2B Data Exchange and Data Transformation (B2B DX-
DT), Informatica Power Center v8.6.1, Oracle 9i, System Architect,
Perforce, Unix scripting, Windows 2000, Oracle PL/SQL, SQL Server 2005
Cisco Systems Inc, Sanjose, CA Jan 07 -
March 09
TL-9000 Project [DAVA - Deep Application Vulnerability Assessment
Certified,
External Audit (Sept'2008) finding categories-: Strengths - Positive
comments & Best Practice]
("Track Internal Assessments, Results & Actions" (TIARA) tool is used to
manage, report, and track the results of the audit events.)
TL 9000: globally recognized quality standard, designed to improve
telecommunications products: hardware, software and services. It improves
the Supplier (to Cisco) - Manufacturer (Cisco itself) - Customer
relationships and co-dependent processes, and benchmark how it works and
provides a continuous improvement feedback loop. TL 9000 comprises
Requirements and Measurements which quantify the product quality and
assurance which in turn projects the company growth. Worked on the Product
Maintenance and NPO & Download to excel, TL9000 MRS System & the metrics
and the Customer definitions & the metrics
Responsibilities:
. Involved in the Anaysis, Design of the MRS system which includes the
various metrics like SHIPMENTS(SHP), INSTALLBASE (IB), ONTIME DELIVERY
(OTI), PROBLEM REPORTS (NPR)
. Involved in Design and Development for the Project CUSTOMER in the
metrics: OTI
. Involved in the Production support work and responsible for running the
monthly loads for all the MRS and Customer metrics (Shipments, Install
base, Returns, On-time delivery, Number of problem reports, Software
problem reports, Software fix quality, Cumulative software fix, Fixed
response time, Outages) and all these metrics for the customers to
generate monthly, quarterly, release specific and release-specific
quarterly metrics.
. Implemented Slowly Changing Dimension methodology for accessing the full
history
. Performance tuning for high volume data load mappings using SQL overrides
in Lookups and Source filter usage in Source Qualifiers as well.
. Involved in the Requirement gathering and verifying thoroughly for any
miscalculations and loop holes from the business functionality point of
view and also recommending the client for the better approach.
. Extensively worked on $U scheduling tool to set up the dependency of the
Informatica workflows and the Unix Shell Scripts which are used to send
the e-mails after processing the ETLs.
. Involved in the Unit Testing, supported the QA and UAT Testing
. Responsible for deploying the code to the Production, and then supported
the post production issues.
. Worked on designing the standard Error handling in the projects for
effectively reporting the IT or Biz errors on the abnormalities,
respectively wit auto generated e-mails.
. Worked extensively on different types of transformations like Lookup
(connected and unconnected), Router, Expression, Filter, Aggregator,
Update Strategy, Source Qualifiers, and Joiner.
. Extensively worked on worklet, mapplets, tasks such as link, email,
command; Pre SQL and Post SQL statements at mapping level, pre session
and post session commands at workflow level, while developing the
mappings and the workflows.
. Implemented the HTML tags in the Unix Shell scripting while sending a
mail from the script that is in turn invoked from the Dollar-U's tailer
task.
. Developed the technical documents for Solution design, Code migration,
Naming conventions and the Mapping documents from source to target, for
the various subject areas that I worked on.
Environment: Informatica Power Center v8.1.1, Oracle 9i, System Architect,
PVCS, Dollar-U, Windows 2000, Oracle PL/SQL, SQL Loader, UNIX Scripting
Symantec Corporation, Sunnyvale, CA
Sept 05 - Dec 06
OASIS Interfaces, Symantec Corporation
Symantec Corporation: undertaken a major initiative, code-named OASIS
(Oracle Applications for Security Integrated with Storage), involves
integrating the separate Symantec and VERITAS ERP (Oracle 11.5.9) instances
into a single ERP instance. This program consists of 11 sub-tracks and
delivers state of the art real-time IT operational systems for the merged
company.
SABA: Learning Management System
Learning Management System is the project for integration of the two
interfaces: Pivotal Sales Order System to Saba Education system and Saba to
the Virtual Academy Portal. Pivotal is the ordering system for licenses of
software, CDs, Education offerings, etc. The ISR (Inside Sales
Representative) enters the order in Pivotal to pass the new Education
orders to the SLMS to automate customer training registration.
Responsibilities:
. Involved in Analysis, Design, Development and Testing of two of the
OASIS sub tracks - Product and pricing, licensing w.r.t Saba 3.4 and
Saba 5.3 systems and Pivotal to Saba and Saba to VA Portal interfaces.
. Understanding the Requirement Specifications, reviewing the Functional
Specifications document and developing the Design document.
. Developed the source definitions, target definitions to extract data
from flat files and relational sources to Data warehouse.
. Used the ETL tool, Informatica to extract the ERP source data and load
into the Saba system
. Developed the interfaces using PL/SQL stored procedures, implementing
cursors.
. Included error-handling and exception handling by logging in the error
tables and sending an alert message via e-mail to the concerned
distributors.
. Created Unit test cases and Responsible for moving the code to QA
environment, and extending the support for the QA and UAT testing for
fixing the bugs.
. Written documentation to describe program development, logic, coding,
testing, changes and corrections, optimized the mappings by changing
the logic and reduced running time.
. Involved in bug fixing of the current production issues, and delivery
in a short time frame.
. Extensively used Debugger to identify data transfer problems in
mappings.
Environment: Informatica Power Center 7.1.3, Perforce, Oracle 9i, Perforce,
TOAD, Sun Solaris (UNIX), UNIX Shell Scripting Windows 2000
Tata Consultancy Services, Hyderabad, India
May 04 - Aug 05
Client: Tata Tele-services Limited (http://www.tataindicom.com/)
Assistant Systems Engineer
TATA Teleservices Limited (TTL) promoted by TATA Group is a licensed
private operator for providing basic telephony services in the state of AP,
Delhi, Karnataka, Tamil Nadu and Maharashtra. Worked on the TTL OSS
Provisioning project.
Responsibilities:
. Involved 24X7 Support, maintenance and enhancements (based on the
change requests raised by the client). The complete cycle of change
request started with feasibility check, impact analysis, development,
testing and implementation.
. Created new database objects like tables, views, sequences, functions,
synonyms, indexes, and roles.
. Worked on CRs (Eg: Millennium Edition (ME), Paluke Bangaram scheme,
SMS-CRM integration and so on.)
. Used various informatica transformations like lookup, filter, router,
sorter, joiner.
. Worked with PL/SQL Packages, Procedures Triggers
. Used Oracle UTL_FILE package for the data extraction.
. Developed SQL*loader scripts to load the data from flat files to the
Oracle Tables
. Involved in integration testing with other interface modules.
. Performed SQL Tuning, code reviews and test case reviews.
. Writing shell scripts to automate the process of monitoring the
engines and adapters of TIBCO EAI.
Environment: Informatica Power Center 7.1.3, Oracle 8i(8.1.7), SQL, PL/SQL
(Packages, Functions, Procedures, Triggers), TOAD, UNIX (Solaris 8.0),
Tibco IM, Exceed, Windows NT, SQL*Plus, SQL * Loader
Techno Design Group, Hyderabad, India.
Nov'01 - April '04
Java and PL/SQL Developer
Responsibilities:
. Interacted with the business users and collected the requirements.
. Programming in Java (Servlets, JSP), Oracle.
. Developing unix shell scripts to run batch jobs for loading database
tables from flat files using SQL*Loader.
. Created SQL*Loader control files for moving the data from flat files
to staging area tables.
. Involved in database development by creating PL/SQL functions,
procedures, triggers, packages, cursors, Error handling.
. Involved in Unit testing and integrated system testing.
Environment:
Java, Oracle 8i, SQL, PL/SQL, TOAD, UNIX (Solaris 8.0), MS Windows 2000,
VSS
Faculty at TRENDZ TECHNOLOGIES
May' 01 - Oct' 01
Project Trainee Anurag Infotech 09/00 - 03/01
Project work: Hyderabad Urban Development Agency - Java(Servlets) and
Oracle- Title: Allotment of Plots. (www.hudahyd.com)
Project Trainee Planet Online 09/00 - 03/01
Web site for purchase of T-shirts - Java & oracle (project for U.S)
(www.mygarb.com)
Education: Master of Science (Computers)
Seminars, Awards and Paper presentations
. Topper in St. Pious X P.G College (M.Sc Computer Science)
. Paper Presentation on "OOPS" at Osmania University.
. 1st Prize in Essay Writing Competition held by VIVEK '99
. Proficiency Prize in Queen Mary's Junior College.
Contact this candidate