Jyothi ARE
Ph: 732 690 8082(mobile)
SUMMARY
12 years experience in analysis, design and implementing IT projects. Has
performed as Business Analyst, Data Analyst, and Sr. Developer.
Proficient in programming in Oracle 10g/9i/8.x/7.x using SQL, PL/SQL on
Windows NT, HP, LINUX, UNIX
Proficient in programming using FORMS 9i/6i/5.0/4.5, REPORTS 9i/6/3.0/2.5, SQL
LOADER, Designer 6.0
Supported Oracle Data Warehouse databases, complex queries, de-normalized
schemas, Performance related issues related to Data warehouses.
Experience in writing interface between Financials to Custom Oracle
applications to transfer data.
Excellent knowledge in working with physical & relational models of the
database, Data Modeling using ERWIN in multiple environments.
Experience in shell scripting with Unix/Linux and scheduling jobs using cron,
DBMS_JOBS, DBMS_SCHEDULER
Monitoring and managing the space usage and table partitioning.
Strong conceptual, business, analytical skills and innovative problem solving
abilities.
Performance tuning, optimization, troubleshooting using AWR & Statspack, Stats
gathering, CBO,QEP, TRACE and Events setting
Experience in latest features like Data Pump, Flash-Back Recovery, ASM, ADDM,
ASSM and Recycle Bin.
Experience in data management tools like SQL*Loader, EXP & IMP
Extensive working Knowledge of Enterprise Manager/ Grid Control.
Configure & manage standby database for disaster recovery & business
continuity (Data Guard).
Experience in handling tools such as Toad.
Experience in Database Security frame work and SOX procedures, Users, Roles,
Profiles and resource Management
Proficient in Performance Tuning using parallel queries and clustering.
Experience working in a three tier Architecture
Worked in Web Page Design using HTML, JSP, Java Scripting, C#, ASP.Net.
Experience in supporting EDI process and trouble shooting the process.
Analysis, Design, Development, Testing of application software written in
ORACLE/DEVELOPER2000
Version control of scripts and forms.
Estimation of Project schedule & Work Commitments
Effective and Efficient interaction with people
EDUCATION
Andhra University, India
Bachelors Degree in Electronics & Instrumentation Engineering
TECHNICAL SKILLS:
Operating Systems: Windows NT 4.0/2000/XP, Solaris 2.6/9.0,HP-Unix
Database: Oracle (10g/9.x/8.x), DB2, SQL Server
Front End: Forms 10g/9i/6i/6.0/4.5, Reports 10g/ 9i/ 6i/6.0/2.5,
HTML, PL/SQL Server Pages, ASP.NET
Languages: PL/SQL, Javascript, C#
Hardware: IBM AS400, HP 9000,Sun ES250 Servers
Tools: OEM2.0.4, Designer 9i/6.0/2.0,Toad,
Informatica Power center (5.1/6.0)
SQL Loader, Business objects 5i
Networking: TCP/IP, Novell Netware
EMPLOYMENT HISTORY
Century 21 Retail, New Jersey June 2009 to till date
Sr. Application Analyst
The project was migrate data from legacy application to a strategic retail ERP
product Escalate. Interfaces were written to move transactional data from POS
system to ERP Package for inventory and financial updates. Several initial load
programs were written to load data from legacy system into Escalate product
Responsibilities
Created functional and technical specifications to load initial data and daily
interfaces from other retail systems to the ERP package.
Performed data analysis and created mappings from legacy data to the
strategic retail ERP product
Provided shell scripts for Data conversions and also to schedule data merging
between POS and AUDITWORKS and ESCALATE ERP product.
Provided tech lead support by working with development, database
administrators and testing teams to test different Sales data flow from POS to
the ERP product
Worked with the QA team to provide test cases with different scenarios.
MOL IT, New Jersey Sep2005 to June2009
Sr. Application Analyst
Starnet is an application designed to support the standardized shipping business
process. The Starnet application include, but are not limited to, Space
Allocation, Booking, Export Documentation (including C/A), Equipment Control,
Intermodal, Per Diem, Import Documentation (including C/A), Freight Cashier, and
Maintenance & Repair.
Responsibilities:
Gathered business requirements from the end users and created functional and
technical requirements
Provided tech lead support for production systems by working with development,
database administrators and testing teams to resolve the production break fixes
Worked with the QA team to provide test cases with different scenarios.
Writing stored procedures, functions, triggers, packages to meet new features
to be Incorporated in the system to implements business rules
Enhanced application performance with code modifications and database object
modifications for existing web and production applications using ADDM and AWR
repository.
Involved in development of front end screens for Starnet application using
ORACLE forms and reports with 6i and 10g versions
Invovled in converting Oracle 6i forms and reports application to forms and
reports 10g
Developed the existing PSP application to ASP.Net using C# and Java scripting
Developed PL/SQL procedures and shell scripts to load XML files, flat files
sent by vendors to Oracle database and also generate work orders from database to
XML files, flat files to send to the vendors.
Supported daily EDI process and involved in trouble shooting of the process if
any of the files are not processed.
Wrote/updated technical and users documentation for process reports and
screens for each newly developed projects.
Performance tuning of some reports and process using SQL-TRACE and stats Pack
facilities.
Environment: Oracle 10g, PL/SQL, Toad, PVCS, Erwin 4.1, Forms 6i, Reports 6i,
Citrix, PL/SQL Server pages, C#, ASP.NET 2.0, Java Script
JP Morgan Chase, New Jersey
Sr. Analyst
Jan2004 to Sep2005
Supported the Global Financial Architecture and Reference Data Hub for a leading
global financial services firm with assets of $1.3 trillion and operations in
more than 50 countries. The Global Finance Architecture selected Oracle General
Ledger to be the GL component, which requires a Chart of Account Structure to
perform core GL functionality. The code block of the Chart of Account Structure
to support the firms requirements include the following segments Legal Entity,
Business Unit, Counter party Legal Entity, Counter party Business Unit, Product,
Account, Client and Data Source. All the above segment information was sourced
from Reference Data Hub. Involved in implementation of different custom
applications - Reference Data Hub Online Maintenance, Reporting Data Mart, and
Workflow Process for Request/Approval, Straight-Through Process to update the
data directly in the database from XML files, and Web Uploaders to load bulk data
from Excel Spreadsheets.
Gathered requirements from business users and created BRD for reference data
hub
Performed data analysis to convert legacy GL reference data to strategic
reference data hub
Created functional specifications and web screen mockups to add/update
workflow requests to create or modify reference data Legal entities, business
units, accounts, products and their hierarchies
Developed functional specifications to upload reference data in bulk from
excel spreadsheets using web interface
Created operational workflow document for end users to maintain the reference
data
Developed functional specification documents for ETL batch jobs to load data
from external vendor sources for Fx rates, Industry classification, country codes
and move data from data hub to Oracle G/L, customer profitability, time and
expense applications
Created test cases for several business scenarios for UAT testing
Involved in creation of logical data model, using Erwin tool for Custom
Financial Reference Hub
American Arbitration Association, New York April 2000 to January 2004
Oracle Programmer /Analyst
American Arbitration Association is an alternative dispute resolution
organization. It is a nonprofit arbitration organization that has been in
business for more than 75 years.
Automation is implemented from filing cases for mediation or Arbitration to the
conclusion of a case. The case administration and the rules for different types
of cases are assigned automatically.
Responsibilities:
Involved in review of the Database design.
Bulk loading of data from non-Oracle data sources like AS400.
Analysis of existing COBOL program functionality and redeveloping them in
Forms and Reports.
Developed database packages, stored procedures required for the application.
Designed interfaces between Financials to custom application to transfer data
on a daily basis through batch programs.
Worked with 9iAS clusters with multiple OC4J instances providing fail over,
load balancing of requests from intranet and Internet applications.
Designed reusable maplets and transformations and used them in mappings.
Worked with transformations like Aggregate, Expression, Filter, joiner, source
qualifier transformations.
Environment: Linux, Windows NT 4.0, Oracle 9iAS/8i, Forms 9i/6i/6, Reports
9i/6i/6/3.0,SQL, PL/SQL, SQL Loader, Informatica Power Center (5i), Business
Objects (5i), Designer 6.0, Dreamweaver, HTML, Java Script., Java, Toad
Piramyd Holdings Ltd, Bombay August 1999 to March 2000
Team lead
This system handles the Purchase, Inventory and Transfer of goods of
Crossroads, a shopping mall spread across India. One of the main features is the
interface between RADOS - a Point of Sale Application being used for sales on the
shop floor. The uploading and downloading of inventory is done through a form
interface. The system handles discounts, re-pricing, etc and is customized to the
clients process of receiving goods.
Responsibilities:
Worked as a Team Lead responsible for communication with the client
Responsible for project schedule tracking
Involved in the database design changes required for the customization.
Involved in developing the Interface between RADOS (POS Application) and
Nterprise using SQL.
Optimized the query output time using stored procedures.
Increasing the database security by handling the critical validations through
database triggers.
Writing test plan and testing of client side program
Environment UNIX, Windows NT 4.0, Oracle 8.0.5, Forms 5.0, Reports 3.0, SQL,
PL/SQL, SQL Loader
Polaris Software Lab, Chennai March 1999 to July 1999
Senior Analyst/Programmer
Finance and Fixed Asset modules were developed and implemented for in-house
operations of Polaris Software Lab Ltd. Finance module comprises of General
Ledger,
Sub Ledger, Grouping of Accounts, Receivables, Payables, Aging Analysis,
Currency
Management, Bank Reconciliation, Drill-Down Analysis, Month Closing, Year
Closing,
Edition of unauthorized entries, voucher authorization, voucher cancellation
etc.
It generates reports like Trial Balance, Balance Sheet, Profit and Loss
Statement,
GL Statement, SL Statement, Contribution Statement etc. Apart from these The
Application is integrated with Lotus Notes is being used for office
administration.
Responsibilities:
Worked as a Team Leader involved in writing SRS and designing the system
Involved in writing database triggers required for critical validations
Writing test plans and fixing bugs
Tuning the report output time using stored procedures.
Environment Windows NT 4.0, Forms 5.0, Reports 3.0, Oracle 8.0.4,SQL, PL/SQL
SANA International Ltd., Bahrain December 1996 to Feb 1999
Senior Analyst/Programmer
SANA International is a chain of Garment/Department Stores in the Gulf. SANA
wanted to automate their operations throughout their Head Office, Regions and
Branches. This project integrated their Purchase, Inventory, Distribution, Sales,
Human Resources and Development, Financial Accounting, Warehouse and Point of
Sales system. Communication Scripts took care of the communication between Head
office, region and Branches.
Responsibilities:
Worked as a Module Leader for Support Materials module and responsible for
delivering on time.
Involved in programming the packages required for communication scripts.
Tuning the report output time.
Writing Test plan and Bug fixing
Fixing up the timing of query after stress testing
Worked as a Module Leader for Support Materials
Cut report output time from two hours to two minutes using stored procedures
and temporary tables.
Involved in designing the database structure based on the URD(User Requirement
Document)
|
