AJAY JAIN

1209 Creekwood Drive Garland TX
Email: ajain31@Gmail.com • Phone: (972) 675-8178

Achievements	Technical Skills	Experience

 

Data Warehousing architect and Data Modeler, applying Information Systems with Teradata database design, development and implementation, where more than 12 years of Client/Server and 5 years of Mainframe experience will add value in job search. I am a US Citizen.

Post Graduate Study, Computer Science, Illinois Institute of Technology, Chicago, IL

MS, Information Systems (Honors) minor in Business Admin, Roosevelt University, Chicago, IL

BS, Mechanical Engineering (Honors), Birla Institute of Technology and Science, India

§      Elected Vice President Public Relations, Toastmasters International

§      Awarded Outstanding Performance & Achievement Awards, Dale Carnegie Course

§      Secured Merit Scholarship, Award for Academic Excellence, Roosevelt University

§      Nominated for Beta Gamma Sigma, National Scholastic Honor in Business

§      Won Bronze R Pin, University Leadership Award, Senator, Student Senate

§      Nominated for Green Key Society, meritorious ‘Extra Curricular’ performance

§      Recipient of three Graduate Assistantship awards

§      Saved an estimated $5 million from Anheuser Busch’s promotional marketing budget by enabling the individual Marketing Manager assume the responsibility for campaign budget approval

§      Raised QA productivity 50% by modeling and maintaining the Object Database writing 700+ methods and creating 300+ classes automating active testing through ODQL scripts

§      Reduced Audit workload by 50% of Department of Treasury in the State of Michigan through Data Analysis, Data Modeling and Database Design implementing a Data Warehouse

§      Reduced duplicate data by 80% in State of Michigan by integrating various Data Models identifying common inter-agency data using Erwin

§      Increased American Institute Inc. (AMI) revenue potential by 150% as we analyzed, modeled, designed the employee background check Database for AMI through ODQL scripts Web enabling the universal outsourcing by AMI of background checks

Back to Top

§      Database Management Systems: NCR 5100M Teradata, NCR Training: Teradata courses: (Physical DB Design ; Database Administration, Applications Utilities & SQL v2), SYBASE System 10, IBM DB2, ORACLE 8.i , MS SQL Server

 

§      Operating Systems: MS Windows 98, NT 4.0 Server, 2000 Advanced Server, IBM VM/CMS, UNIX SVR4, HP-UX

 

§      Programming Languages: SQL, SQL*PLUS, Transact SQL, ODQL , REXX, FORTRAN, C and Advanced C, UNIX Scripting (C, Korne, Bourne)

 

§      Oracle Tools: ORACLE Express, ORACLE Discoverer 2000, ORACLE Designer 2000, ORACLE Financial Analyzer / ORACLE Sales Analyzer; Awarded four ORACLE Masters by ORACLE Education

 

§      Computer Associates Tools: ERwin 3.5.2 and ERwin 4.x, BPwin 4.x (IDEF1X), KEY, eTrust suite of tools, DecisionBase, TEAMWORK, Jasmine ii with Active X, Jasmine ii Portal, Unicenter TNG Service Desk, TALON (a.k.a. GQL of Andyne Corp.)

Back to Top

Computer Associates International, Plano Texas, Consultant 1999 - 2002

Enterprise software company addressing process management, information management and infrastructure management

§      Increased American Institute Inc. (AMI) revenue potential by 150%. Modeled and maintained the employee background check database through ODQL scripts enabling universal outsourcing

§      Completed the South Central Portal Data Analysis and Data Modeling for CA Consultants and Managers; The Portal database 2 months ahead of schedule

§      Raised QA productivity 50% by modeling and maintaining the Object Database writing 700+ methods and creating 300+ classes facilitating active testing through ODQL scripts

 

Oracle America, Inc., Las Colinas Texas, Sr. Data Warehousing Consultant 1998 - 1999

A leading supplier of software for information management markets systems software & business applications software

§      Increased reporting efficiency by 300%. Worked on Data Warehousing project at Texas Instruments using Oracle Discoverer 2000. Created source target attribute listing enabling Extraction, Transformation and Loading (ETL)

§      Saved an estimated $5 million from Anheuser Busch’s promotional marketing budget by enabling the individual Marketing Manager assume the responsibility for campaign budget approval

§      Was trained extensively in most of the Express suite of Online Analytical Processing (OLAP) tools and Oracle Designer 2000

 

Bull Information Systems, Dallas Texas, Systems Integrator 1997 – 1998

American subsidiary of a French company, strategic partner of NCR working for US State level Teradata applications

§      Integrating various Teradata Data Marts through identifying common inter-agency data reducing duplicate data by 80% in State of Michigan. Investigated initial design using ERwin and Teradata database

§      Implemented a Teradata Data Warehouse that enabled the use of an Expert System reducing Audit workload by 50% of Department of Treasury in the State of Michigan.

§      Designed and created 78 physical Teradata DB tables starting with 36 Legacy sources of Treasury department using Erwin for logical and physical design. Used GQL for ETL and evaluated other S/W vendors

§      Developed a Data Dictionary by understanding and inspecting every field of the Legacy data thus generating an Enterprise wide Teradata database; Irrelevant data was marked for deletion and erroneous data fields were marked for transformation

§      GQL ETL target database was Teradata, used for the Pilot project as well as the final project.

§      Extracted pilot data for 2 years out of 10; Identified gaps in data that required clarification

§      Teradata DB was loaded on developing cleansing routines for transformation and final extraction

Back to Top

 

Lockheed Martin, King of Prussia Pennsylvania, DB Architect 1996 - 1997

Customer-focused, global enterprise principally engaged in systems integration, aeronautics, space and technology services

§      Compiled sources in Data Warehousing, Data Mining and Knowledgebase areas by researching books, white papers in record time and recruited for upcoming project team

Logicon CTG, (now Northrop Grumman IT), IRS, Dallas Texas, Consultant 1996

§      Conducted Integration testing of online Case Processing System software compiled from five different IRS sites

IBM Global Services, Irving Texas, Staff Application Integrator 1995

Manufactures and sells computer services, hardware and software and also provides Global Services

§      Coordinated the development of IBM's global customer support project; Developed Entity Relationship Diagram (ERD) using case tools like ADW and Key on OS/2

§      Analyzed and defined data mappings for Arizona Public Service, an Electric Utility

§      Created mappings with Access DB, documenting knowledge transfer and enabling Data modeling

 

SYBASE, Dallas Texas, Senior Consultant 1993 - 1994

An enterprise infrastructure company that bridges heterogeneous technologies

§      Designed and developed Stored Procedures using Power Builder for AMOCO Business Process Reengineering (BPR)

§      Instructed SYBASE courses for System 10

§      Installed and configured SYBASE products

JIT Resources International, Austin, Texas, Consultant 1992 – 1993

(SUN, UNIX, ORACLE)

Customized JIT (Oracle VAR) package modules using SQL Forms, PL/SQL, SQL*PLUS, UNIX SVR4 on SUN Sparc stations involving heavy user interface, facilitating seamless induction of JIT (Oracle VAR) packages in the production environment.

 

Computer Sciences Corporation, JSC NASA Consultant 1991 - 1992

(VM/CMS, REXX, ORACLE)

1. DBA in NASA's Oracle Help Desk Team; developed a script for automated migration of NASA's 'RIMS' relational database to Oracle v6.0

2. Installed and tested NASA's Oracle upgrades under VM.

3. Was part of a client/server desktop Office System development team using MS WIN3.1 beta, MS VB, MS WordBasic.

Back to Top

 

Community Health Computing, Houston, Software Engineer 1990 - 1991

(SUN, ORACLE)

1. Using Teamwork, a CADRE case tool analyzed a client/server HIS Blood bank application.

2. Formalized brainstorming sessions with visiting industry users, specialists, internal panelists and other participants defined the MOTIF based HIS interface requirements using Builder Xcessory.

3. Seven weeks full time training lead to four Oracle Masters, UNIX SVR4, Interleaf, 'C' and Advanced 'C'.

 

EDS Corporation, Dallas, Consultant 1990 – 1990

(MVS/ISPF, EDS SLC)

Supported IBM COBOL large bank software of newly acquired Mtech Corporation.

 

IBM Information Network, Tampa, Senior Associate Programmer 1988 – 1989

(VM/CMS, REXX)

Defined requirements, analyzed, designed, coded & tested the E-Mail release 2.0, subscriber's directory, a virtual machine written in REXX; Also worked on both IBM's releases of internal & external PROFS.

 

AMOCO Corporation, Chicago, IL. , Consultant 1988 - 1988

(VM/CMS, SQL/DS, Cross System Product[CSP]),

Designed, coded and tested an embedded SQL program in FORTRAN for an SQL/DS database; I was also trained in IBM’s Cross System Product (CSP).

 

CMC Ltd., New Delhi India, formerly IBM India, Area Manager 1986 - 1987

(VM/CMS, REXX, SQL/DS, DB2, ISQL)

Lead as DBA / Project lead, in the design of a Corporate MIS database, a team of four, that grew to a team of twelve installing on INDONET, a national network. Employed Demarco Analysis, Yourdon Design. Initiated database implementation on the INDONET using SQL/DS (evaluated & considered DB2 as option), ISQL & ISPF Dialog Manager, REXX and embedded SQL in COBOL.

 

Blue Cross Blue Shield (BCBS), Unitech Systems, Chicago, Consultant 1985 - 1986

(MVS/TSO/ISPF, COBOL)

Supervised installation of 'Automated Balancing Procedures' in BCBS's

two biggest applications, namely State of Illinois (SOI) and Corporate Coordination of Benefits (COB), on a national network for BCBS's Cost Containment System.

Developed a proprietary spreadsheet using Warnier Orr diagrams and COBOL. Participated in organization of User Conferences and taught at user sites.

Back to Top

Walked for March of Dimes; Raised $2334 for 2002 and $670 for 2001

Weekly volunteer at Northwest Bible Church for Career Transition Workshop sessions

Note: This Online resume listing facilitates resume post for job seekers with Internet Job Hunting