Software Engineer Project
Resume:
Nimisha Patel
Phone: 214-***-****
E-mail: ************@*****.***
Website: http://www.linkedin.com/in/nimishapatel
SUMMARY:
. Over 16 years of experience in the industry, involved in analysis,
design/develop, testing and implementation.
. Strong experience in Perl Script, C, C++, ETL AbInitio, JavaScript, HTML,
CGI, SQL, PL/SQL, Oracle, and Shell Script.
. Experience in design and development of Client Server applications using
Object Oriented Methodologies.
. Ability to lead small team and exceptional ability to quickly master new
concepts and applications.
. Constantly striving to expand existing knowledge base to keep up with the
latest technological advancements.
. Excellent communication and interpersonal skills and team player.
OBJECTIVE: Seeking a challenging position in enterprise application
integration environment where technology integrates with
business functionalities to enhance business process; I look
forward to the opportunities where I can use my analytical
skills in combination with technical expertise to improve all
phases of enterprise development, implementation, maintenance
and performance tuning life.
EDUCATION: Master in Computer Science (Major - NT Programming): Monmouth
University, NJ [2000]
Master in Applied Mathematics (minor - CS) : M.S. University of
Baroda, INDIA [1993]
BS in Mathematics (minor - CS) : M.S. University of Baroda,
INDIA [1991]
COMPUTER SKILLS:
Languages: C, C++, JAVA, HTML, JSP,PL/SQL, SQL*PLUS, PRO*C,
Pascal, ETL-ABInitio
Script: Perl Script, Java Script, Awk, UNIX
Shell/Kshell/Cshell Script, CGI Script, XML, UML
Operating Systems: UNIX, LINUX, DOS, Microsoft Windows
Hardware: SUN, HP, IBM PC & Compatible
DBMS: ORACLE 7.*; 8.*; 9i; 10G, Access
Awards: AT&T CMM Level 2, IBM CMM Level 3, Top 100 MSAs Award, AT&T
Software Excellence Award, AMD SPOT-Light Award from VP
EXPERIENCE:
AT&T - Senior Software Engineer 1125 E. Campbell
Rd.,Richardson, TX 75082[9/09 - Current]
AT&T Revenue Assurance Processing (RAP) Projects - Working on Wireless
Information Technology Revenue Assurance Detection And Recovery Tool
(RADAR) and AbInitio Data Warehousing tool.
. Working on new requirements, analysis, development, and daily Production
Support of RAP for MAF/BID Billing data.
. Worked on re-design/re-architect of existing 'rdr' project, built using
AbInitio, for performance improvement, better production support, and
changing operation system SunOS to Linux. (Ab-Initio and Perl Script).
Epsilon - Senior Software Engineer 4301 Regent Blvd.,
Irving, TX 75063[9/08 - 9/09]
Worked on Epsilon Interactive system to support Citi Cards email
communications programs.
. Working on requirements, analysis, development, and Production Support of
DREAM project
. working on re-design of this email distribution project mainly for the
performance improvement and using latest software technology (Ab-Intio
and Perl).
. Supporting the current citi email-distributions project (DREAM) to add
new clients and functionality. Writing scripts for the testing automation
process. Working on GUI to add many new customized web pages for the
each citi bank clients in DREAM system. Writing many PERL scripts to
expedite the troubleshoot processes and to check the current system from
the daily monitoring/support/performance basis.
AMD - Senior Software Engineer 5113 South West Pkwy,
Austin, TX [2/05 - 9/08]
Project is an end-to-end implementation of a Data Warehouse in Oracle with
Ab Initio as ETL tool and Perl script as the wrapper tool. Worked on 3
different release of CPG DataMart Project.
. Release 3.0 was to fix most of the bugs and load some new test data from
Singapore and Germany Fabs.
. Release 4.0 was a big release where we redesign the all loaders that load
the test data to CPG Datamart. Also upgrade the database version from
9i to 10G, EME version from 2.13 to 2.14, and apply the star schema to
various database tables for the faster data loading purpose. We have
gain 4X performance for most of the loaders with this new redesign of CPG
Datamart.
. Release 4.0.1 was addition and enhancement for the performance
improvement in the CPG Data Mart.
CPGDM was built for the Gathering Test data and equipment data. AMD
Marketing users used this Warehouse for evaluation of campaigns, overall
performance of products and identify cross selling opportunities. The AMD
users used the Warehouse to identify the different product performance and
history information about the product.
Roles and Responsibilities:
. Responsible for building, peer reviewing and unit testing complex Ab
Initio graphs for population of Data Warehouse for Testdata, performance,
and correctness of Data Marts.
. Resposible for conversion of SQL's to Ab Initio graphs of certain tasks
to improve efficiency
. Developed the PERL script wrappers for Ab Initio graphs and automated the
data transfer process between the different graphs.
. Responsible for building test cases for various Ab Initio graphs and
automated the graph testing using perl, and plsql.
. Responsible for Performance Tuning of the systems and tested each loader
using 10K to 50K files to tune each graph settings.
. Worked on archiving the test file using NetBackup. Bring archiving
process to 30 minutes of backup time form the 5 hours.
. Designed various validation processes using Perl Scripts for validating
the data warehouse after one time loads using AbInitio.
. Responsible for a building a data cleanup system using Shell/Perl scripts
that purges data from the system on a frequent basis.
. Responsible for CVS Source Configuration Management for Legacy loader and
also using the EME for the AB-Initio Graphs
. Working on requirements, analysis, quality assurance, product
development, product maintenance and Production Support. Responsible for
providing all the documentations for design, testing, support and
deployments for the project
. Responsible for providing technical support and managing the legacy
development work for the international teams.
Responsible for Acceptance testing, production releases coordination, and
release deployment work for legacy loaders.
. Worked with TSMC/ASEKHT/SPGAMD customers to load their testing data to
SAPPHiRE System using Perl, C, Pro*C and C++ loaders and Worked with CPG
customers to load their testing data to CPG Datamart using Perl, and ETL
Ab Initio
. Develop Ab initio graphs to extract data from Database tables as well as
flat files, applying transformation logic and loading into Oracle
database tables.
. Performed various transformations on source data using various Ab initio
components
Environment: Ab Initio EME, Ab Initio Co>Operating system 2.14, Ab Initio
GDE 1.14.37, Shell Scripting, Perl Script, Oracle10g, Tode of Oracle 9.0,
MS Excel for reports, MS Power Point for Presentations, C/C++,Pro*C, CVS
IBM - Senior Software Engineer 20 Knighbrige Rd, Piscataway,
NJ [ 2/04 - 9/04 ]
NIS - Basic8
This was a project, which I had to design and develop new enhancement for
existing Basic8 system, this project provides 1800 number routing and
billing/feature information. Project was build using Java, IBM Aglets
Software Development Kit. Agents (Java Applets) have purpose in that they
are created to complete some task on behalf of a person or another process.
They can be found in computer operating systems, networks, databases, and
so on. These agent processes have control over their own execution cycle
(to varying degrees of course) and can make their own decisions during the
course of their life.
Roles and Responsibilities: As a Senior Software Engineer -
Designing the database changes and implementing it on Oracle and PL/SQL on
Unix/Linux server. (it involved in adding more feature for supporting 1-
800#)
Developed the Java Server packages, Servlet/JSP and Perl administration
tools. Used JDBC for Linux for database connections
developed Java (Swing/AWT) client to work like an Application and Applet
using the server via RMI
Supported the message exchange system in Java, XML and CORBA for Basic8
enhancement
Designed and implemented a complete 1800# transactions and life cycle
configuration management system in PERL on top of Clearcase.
developed the Web Pages using JSP, Java Applets, JavaScript, DHTML and
graphics tools
Involved in testing and supporting the GUI enhancement.
Environment: Java, Shell Script, Perl Script, PL/SQL, Oracle9i,
TODE, JavaScript, HTML, XML, JSP, Unix/linux, Apache Tomcat, ILC (time
report tool), TMT (Testing Tool), RMT (Requirements tool), Sablime (Source
Code Management Tool)
.
AT&T/IBM - 30 Knighbrige Rd, Piscataway, NJ
[4/96 - 2/04]
LNP-SMS
Worked on a Local Number Portability project, which facilitated the
customer to switch between local carriers without changing their telephone
number. It was an industry wide project, which was developed concurrently
by all long distance providers, like AT&T, MCI, Sprint etc. This project
used message base TCP/IP multi threaded technology for the transmission of
messages from one LNP-SMS subsystem to another, From LNP-SMS to 2NCP/GTR
network switch and from LNP-SMS to industry (RSMS)
Roles and Responsibilities: As a GUI team lead -
. Responsible for building, peer reviewing and unit testing for a
complex C/C++/HTML/JVA Script/Perl-CGI/Perl script legacy loaders.
. Worked on requirement gathering, analysis, quality assurance,
application development, web development, application maintenance and
Production Support.
. Responsible for providing all the documentations for design, testing,
support and deployments for the project
. I was responsible for providing all the technical support,
Communication with user community for their requirements/enhancements
and provided the estimated time and cost for the each GUI (Graphical
User Interface) work.
. Identified the GUI high level impacts for each production release.
. Contributed majority of the GUI detail design content for each
release.
. Provided technical leadership for the GUI in each production
release.
. Provided the GUI work plan for each week.
. Distributed work assignments amongst the GUI developers.
. Tracked the GUI work progress and reported it to upper level
management.
. Represented the GUI team at the weekly MRRB meeting.
. Worked on the GUI architecture/implementation issues.
. Contributed in analyzing the most business initiatives that
impacted the GUI.
Roles and Responsibilities: As a GUI developer -
. Architected, Designed, Developed and verified the GUI (Graphical User
Interface) Provisioning, Query, Static Report and Dynamic report
screens using CGI, HTML, Perl Script and Java Script
. Designed and developed common library for User Interface, Automated
load data system for various UI screens, Customize User Interface
provisioning system for different User Classes using Java Scripts and
Web Cookies.
. Designed and developed various reports to track the GUI activity using
PL/SQL Views/Functions and Shell Script
. Designed and developed Reports, Inquiry subsystem using C, C++,
Oracle, AT&T tools. (G2, NIPC, Data Complete) Used the message based
technology for transmission of messages between GUI and backend
processes.
. Designed and developed automated ORACLE Database table's cleanup
system using PL/SQL Store Procedures, Functions, Views and Unix Shell
Script to clean different tables via Oracle cron job (which runs on DB
server).
. Designed and developed automated file cleanup system using Unix Shell
Script to remove old UNIX files.
. Improved Queries/Reports performance by creating many different PL/SQL
Views, Functions, Store Procedures
. Worked with the user community for the design/implementation issues
and helped them to their satisfaction.
. Designed and implemented a complete general-purpose database
management system in PERL on top of Oracle.
As a System Test Engineer -
. Verified LNP-SMS features with Industry Data in each Production
release.
. Actively involved in the Industry Group testing.
. Performed System and regression testing for the system's new/old
features.
Environment: C, C++, CGI, Shell Script, Perl Script, PL/SQL, ORACLE,
JavaScript, HTML, Unix/linux, Apache Tomcat, SoftBench(code debug tool),
Lotus Notes (e-mail tool), TMT (Testing Tool), RMT (Requirements tool), &
various AT&T's tools NIPC, G2, Data Complete, Sablime (Source Code
Management Tool), EDL, TimeTrax(time report tool), XMS (voucher tool)
KMS (Knowledge Management System) 500 Atrium Drive, Somerset, NJ
[07/97 - 12/97]
Knowledge Management System (KMS), and Coach's Desktop training System of
AT&T is to enable employees/manager to have ready access to the
organization's based knowledge facts, sources of information (in CBT),
require knowledge solutions/training for future projects, and sharing
skills information organization wide. This system also registers/tracks all
the knowledge improvement over the time for each employee.
Roles and Responsibilities: As a GUI developer -
. Architected and documented all the specifications/requirements for the
GUI screens.
. Design and Developed GUI (Graphical User Interface) screens (above 150
screens) using Live Wire (Netscape product which has Programming
language like C HTML, Java Script, PL/SQL, and ORACLE.
. Responsible for Unit/Integration testing & improving performance by
creating many different SQL views and Functions.
Environment: Live Wire, PL/SQL, ORACLE, JavaScript, HTML, Unix/linux,
SoftBench(code debug tool), Lotus Notes (e-mail tool), Sablime(Source Code
Management Tool), TimeTrax(time report tool), XMS (voucher tool)
ACS, Inc. - Somerset, NJ [
08/95 - 04/96 ]
Fannie Mae Loan Search Project
This project was mainly used by the Fannie Mae Agents for the perfect loan
search for individual. With this project, it was easier for tall the Fannie
Mae agent to work with different customers and banks for different
products, registering all the loan/customer information into the centralize
database using the user friendly interface. This project made very easy
life for all Fannie Mae agent to find top ten/twenty/etc.. proper loans for
customers by using very user friendly screens that access the centralize
banks/customers data.
Roles and Responsibilities: As a software Engineer -
. Designed and Developed database table's structure/relationship
according to requirements using Access database.
. Designed and Developed many screens using Visual Basic 3.0, Tab_Pro
1.1, Grid_Vbx 1.0, Access Database.
. Designed and Developed Loan Search Reports, which keep track of loans
approved/rejected from Banks and customers.
. Developed software for transferring data from one format to other
format using Visual Basic, Access.
. Developed script to transfer customer's data from ASCII to Access
Database and Access Database to ASCII.
. Used UUSCAN (testing software from Fannie Mae) to check error while
transferring data from one format to another.
. Worked on requirement gathering, analysis, application development and
provided the documentations for design, testing, support
Fountain Technology Inc., - Somerset, NJ
[03/95 - 08/95]
1. Worked on online system, which guides customers step by step to resolve
various multimedia PC problems.
2. Responsible for technical support for providing solution to customer
computer's software/hardware problems.
3. Responsible for registering new computer's problem in to the system and
updating system with proper solutions.
Lumina Corp., Baroda - [01/94
- 08/94]
( Worked on the Database Project using Paradox 4.0 & SQL
( Designed and Developed a Database application, which keep track of
formula and procedure for manufacturing different Colors and Dies. It
also stored information regarding inventory, customer, and venders. This
application handled various reports generation regarding company's sales,
stocks, order, delivery and multiple reports for color processes.
Courses:
. Took many Computer Programming Classes from Job Place : Advanced Perl
Programming, ETL Ab-Initio, CVS Source Configuration Management,
Oracle 10G, Lean Manufacturing Process.
. Middlesex County College (NJ) : [1995 - 1998] : Advance Computer
Programming classes
. Somerset College (NJ):[1996] : Advance Visual Basic Programming Class
. Infer Data institute [2004 - 2005] : Learned JAVA, J2EE, XML, UML,
JSP, WebLogic, WebSphere, JDBC, and other Java related Classes from
Infer Data institute
STATUS: US Citizen
REFERENCE: Furnished upon request
Contact this candidate