Customer Service Project

AKHIL JOEY

MS Computer Science

abnil7@r.postjobfree.com Contact - 313-***-****

PROFESSIONAL SUMMARY

Oracle PL/SQL Developer with over 4 years of experience of building and designing

custom applications using Database tools on UNIX and Windows Environment.

Over 5 years of experience working in software industry and customer service.

I have experience of working in Retail and Financial domains thus getting an insight of

both the business.

Working in Financial domain I understood the concepts of TIME, MONEY and RISK

and how they are interrelated.

Working in Retail Industry the attitudes ‘GUEST FIRST’ or ‘CUSTOMER IS ALWAYS

RIGHT’ makes a lot of sense to me.

With excellent communication skills, I can work well independently and with minimal

supervision.

Also working as a freelance website designer and currently working towards ORACLE

APPLICATION Administration.

I graduated with a Masters Degree in Computer Science, Wayne State University, Detroit

MI – Class 2007.

• Ability to build great relationships at work.

• Comfortable working in a team or as an individual.

• Experienced in leading a team of six software developers and gathering user

requirements and developing design documents and scheduling time lines.

• Extensive experience in Analyzing, Designing, Testing Documenting Database

systems and Business applications.

• Hands-on experience in all stages of a Software Life cycle (SDLC), starting with

Feasibility Study until the Maintenance level.

• Developed and deployed numerous PL/SQL packages, stored procedures, Functions,

Views and Triggers.

• Experience in Debugging and Performance enhancement of existing code using

EXPLAIN PLAN, proper INDEXES using HINTS, TRACE.

• Experience working in both OLTP and Data warehouse environment

• Worked on ORACLE APPLICATION 11i – (HR, Finance,Payroll, MRP, Order

Entry)

• Scheduled and requested various Concurrent jobs in ORACLE Apps, worked on

PROFILES and different responsibilities.

• Understanding of Deployment from Development stage to Testing, to Staging (if

available) to Production and Post Production Testing.

• Flexibility to learn and adapt new technologies – INFORMATICA, CAMPAIGN

ENTERPRISE, and Version Control tools (VSS and CVS).

• Experienced working in both OLTP and Data warehouse environment

• Knowledge of Data Modeling using ETL, Star Schema, Snowflake Schema, Entity-

Relationship Diagrams

• Extremely comfortable with Unix Shell Scripting and FTP

• Strong knowledge on TOAD,SQL Navigator, PL/SQL Developer Tools, SQL PLUS

• Provide a Testing Environment with User Test Cases.

• Excellent knowledge/understanding of new features of ORACLE 11g.

• Good understanding of advanced features like Database Replay Tool, Extended

Composite Partitioning, Log Miner Interface in Oracle Enterprise Manager, Enhanced

Schema Management, Adaptive Cursors and SQL Plan Management, SQL

Performance Analyzer.

PROFESSIONAL EXPERIENCE

PROGRAMMER ANALYST

GOLFSMITH International Inc.

Austin, TX

Oct 2008 – Present

Description – Golfsmith International Holdings, Inc. is a 40-year-old specialty retailer of

golf and tennis equipment, apparel and accessories. The company operates as an

integrated multi-channel retailer, offering its guests the convenience of shopping in its 72

stores across the United States, through its Internet site at www.golfsmith.com and from

its assortment of catalog distribution. Golfsmith offers an extensive product selection that

features premier-branded merchandise, as well as its proprietary products, club making

components and pre-owned clubs.

Golfsmith’s Information Services Team is a highly skilled group that develops, maintains

and supports the entire set of Retail applications throughout the Company. This

opportunity was ideal for one who has superior Oracle PL/SQL or SQL Server

programming skills. The Responsibility demands proficiency and energy with an

understanding of system development life cycle and accountability for developing and

supporting the applications.

Responsibilities and Professional Experience (Oct 2008 – Present)

o Building custom applications and gathering specific requirements for Users from

all departments, Accounting, Inventory, Call Centre, and Data Management etc.

o Every project is individual oriented with may be some help or guidance from the

supervisor.

o Designing and giving estimates for development, testing and deployment to the

Director of Application Delivery.

o Post Production Testing / Confirmation before signing off.

o Document the whole SDLC of the project in TRACK IT.

o To attend and schedule meetings with users to document clear and specific

requirements to avoid any production rollbacks in the future.

o Used PL/SQL Developer and SQL Navigator to develop db objects.

o Created complex packages example - sending batch emails to users when a

specific concurrent job fails.

o Created stand alone procedures example – populating a table with all the top

styles/skus/inventory items i.e. top sellers in a particular store.

o Created Triggers, Views and functions to be used in packages.

o Created and worked on complex SQL queries using JOINS, ARRAYS, TYPES,

GROUP BY, ORDER BY, DMLs, DDLs, Transactions, SubQuery, Cursors,

Exceptions, SQL Errors, SQL Msg, Grants / Privileges, Schemas, DB Links,

different data type, DECODE, DATE/Time functions, Concatenation etc.

o Worked on ELECTRONIC DATA INTERCHANGE (EDI) project for Advanced

Shipping Notices (ASN) using PL/SQL, PHP, XML files, XML schema

validation.

o Worked on CYCLE COUNT SKUs project involving PL/SQL, ORACLE Apps,

UNIX shell scripting.

o Converted CRON jobs to ORACLE jobs with scheduling and sending out text

emails.

o Worked on Payment Card Industry Data Security Standards – PL/SQL

o Worked on Order Cancellation project for the Call Centre, sending HTML emails

to customers with notification of cancellation and issuing of unique promo codes

for their next purchase online or in store. – PL/SQL, ORACLE apps, Campaign

Enterprise. The Revenue of Investment (ROI) for this project was appreciated.

o Average Run time of Concurrent Job on ORACLE Apps – this project was to

calculate which jobs in ORACLE are running for longer time than their average

running time including present, previous business days. – PL/SQL, ORACLE

Apps., UNIX

o Besides the projects, my responsibility also included debugging failed jobs

overnight and be on call when needed.

o Also respond to User’s request to create SQL and generate reports for their

analysis.

o Member of the SPIRIT Committee to enhance the work environment and make

Golfsmith a fun place to work at.

Production Environment

Multiple Sun systems running Solaris v2.9 (E450, E3000, E4500, E6500, E6900)

o

Oracle DBMS at v8.1.7 (8i)

o

Oracle Applications at v11.0.3 (HR, Finance, Payroll, MRP, Order Entry, etc.)

o

SQL Server 2000 with .Net applications

o

Microsoft Windows Server 2003 - NT desktop and BackOffice environment

o

MySQL applications developed in PHP language

o

ORACLE DEVELOPER/PROJECT LEAD

INTERNATIONAL FINANCIAL CORPORATION

WORLD BANK GROUP, Washington DC

TATA Consultancy Services

Jan 2008 – Oct 2008

Description – CvaR Corporate Value at Risk is a windows based application with

ASP.net as front end and ORACLE 10g as the backend database. Market Price files are

received from various sources, State Street bank, Bloomberg and Lehman etc, in the form

of BONDS, SWAPS, and SWOPTIONS etc in to the SUMMIT server. Using ETL tool

all the securities and prices are populated in the database, then the Pricing Model (based

on Bloomberg Model) built on VB Applications a Price for each security is generated.

Then using PL/SQL Packages with complex Stored Procedures and Functions the Prices

for the Securities are validated against a User defined Threshold Values. All the securities

which fail the validation or are flagged by the stored procedures are sent as an alert or

notified to the users through ETL again. COGNOS was used to develop reports on daily

basis.

Responsibilities – Oracle Developer (Jan 2008 – Oct 2008)

o Understand the business logic, Data model and the business requirements in a

very short frame of time.

o Deployed new versions of CVaR on every month end, involving requirement

gathering from the users, analyze efforts, build pseudo code for each task,

extensive and long hours of development phase, and run dry test on test

environments, deployment in to Production and prepare Documentation at the end

of every month.

o Involved in five releases of CVaR versions in to Production Database in a span of

six months.

o Built complex Stored Procedures, Functions using IN OUT parameters, DECODE

function, JOINS, DB LINKS, SEQUENCE generator, accessed VIEWS,

TABLES from different schemas.

o Incorporated Triggers to trigger history jobs, functions involving calculation of

dates, populating fields such as DATETIME STAMP and USERID in various

tables.

o Scripted VIEWS to hold dynamic data on a daily basis and store the data in

History tables.

o The whole system was Orchestrated i.e. all the tasks involved in ETL, VB,

PL/SQL had a Start and End function written in PL/SQL so that the date, time is

logged in the LOG schema.

o Used Clear Case for versioning.

Responsibilities – Project Lead (Jan 2008 – Oct 2008)

o Lead in a Rapid Application development Environment

Document all the User Requirements

o

Prepare Project Plans

o

Estimate and gather efforts from all the team members

o

Conduct team meetings to coordinate the tasks

o

Set month end goals and achieved them successfully

o

Get approvals from the client to migrate from development to test to production

o

database

o Working in parallel with the users to get their in-depth reviews and experience on

each version of CVaR

o All production issues were handled successfully and resolved.

o Worked with the DBA team to migrate all the necessary Objects, Grants and

Privileges for the team members to access various schemas and objects.

Environment:-

Database – ORACLE 10g

o

ETL – INFORMATICA

o

GUI – ASP.NET

o

Reports – COGNOS

o

Tools – TOAD, SQL PLUS, SQL Developer

o

PROGRAMMER/ANALYST

International Trade Commerce Net, Mumbai, India

Nov.2004 to Dec. 2006

Description - A client Server application ITCN connects the major forwarders, cargo and

freight movement on the air route like airline, agent, forwarders and shipper to book and

track the flow of cargo bases on the GE’s EDI network.

Responsibilities:

o Loading data into tables using SQL loader.

o Tuning of application using Explain Plan.

o Backend Development.

o Writing stored procedures, database triggers, Creation of indexes, functions,

packages

o Generating Reports.

Environment: Oracle 9i, Developer, Forms, Reports, Windows NT.

EDUCATION

Masters in Computer Science,

Wayne State University, Detroit, MI

Jan 2006- Jan 2008

• GTA, for Computer Science Department.

• Lab Technician, for Computer Science Department

• Lab Technician and Web Master, Economics Department

Successfully completed 38 Graduate Credit hours

• Database Management Systems

• Design and Analysis of Algorithms

• Computer Systems Security

• Data Communication and Computer Networks

• Bioinformatics

• Matrix Computation

• Model: Complex Systems

• Management Information Systems

• Finite Automata Theory

• Advanced Web Technology

• Linux : Administration

• Computer System Architecture

• Principles of Web Technology

Bachelors in Computer Engineering,

Raipur University, India

(1999 – 2003)

Visa Status – H1 B

Professional Experience in Customer Service Industry

• Worked a Technical Support Agent for DELL Systems, providing web and

voice support to US based Customers.

• Worked as Sales Agent for HUTCHISON WHAMPOA Telecommunication

Follow me on LinkedIn: - http://www.linkedin.com/in/akhiljoey

Video Resume available on request

References available on request

Contact this candidate