Saleem Khokhar
Res: 805-***-****, Cell: 805-***-****
***********@*******.***
SUMMARY
Accomplished Information Technology Professional with over 15 years of experience in designing, developing, performance tuning, implementing, and supporting software applications. Additional expertise in analyzing, designing, and supporting various data basis. Known for high energy, self-starter, and flexibility in working with diverse audience. Exceeds client and company expectations consistently.
• Complete SDLC Projects
• Database Design & Support
• Production Support
• Team Leadership
• Mentoring
• Multiple Technology Domains (Mainframe, Midrange, Desktop)
• Application & System Performance Tuning
• Project Management
PROFESSIONAL EXPERIENCE
BANK OF AMERICA, Agoura Hills CA 2009 – to date
Led, analyze, design, develop, implement, & production support software applications within PLS team. The team consists of 6 onsite including manager and 8 offshore resources. Major components include HTML, ASP.NET, C#, Oracle, DB2, SQL Server RPG ILE, COBOL, IBM Info sphere and many SDLC supporting tools.
Have successfully implemented following projects on time and in budget:
• Developments lead for MDS project. That includes Analyze, Design, Onsite & Offshore task management, Implement & Production Support of ETL solutions using IBM Info sphere product suits. The project is successfully implemented.
• Analyze, redesign & implement Heliotrope process for performance improvement, reducing process run time by 60%.
• Analyze, design & led an effort for securing & migration of PLS web portal developed in C#, ASP .NET.
• Lead Data Center Integration for PLS Web Portal, the project include migration from standalone IIS6 to load balanced IIS7, Windows 2003 standalone server to VM Windows 2010 server, oracle 10g to oracle 11g.
• Analyze & led an effort to secure FTP password in legacy application on IBM System i developed in RPG & CL.
• Analyze & led an effort to capture & send additional data elements to FNMA. The project is called Uniform Loan Data Delivery Project. It’s in QA and scheduled to be implemented in September.
HEALTHNET INC, Woodland Hills CA 2002 – 2009
Staff Programmer Analyst:
Design, Develop, Implement, Performance tuning & Production support Customer Services Web Application for Commercial book of business, over 3000 users in 5 national sites. Major component includes HTML, JSP, Java, TIBCO, Weblogic, Apache, Web Services, Oracle, DB2, RPG ILE, COBOL, RMS & ACMS tasks.
Implement & Production support of knowledge management application. Major component includes HTML, ASP.NET, IIS, & SQL Server
• Single handedly coded over 150 stored procedures in record time, meeting critical deadline.
• Created iOS system facilities instruction technical manual and as technical expert trained team members, increasing productivity and application support.
• Mentored other teams on configuration and usage of java adapter in iOS, improving system interface and awarded most appreciated person of the month.
• Re-designed and developed simplified security for Customer Services Web Application, reducing over 70% of tickets related to application access.
• Implemented CONNEX tool for data mining RMS files, increasing accessibility and productivity.
• Enhanced benefit data extraction process and ftp to external vendor, reducing over 50% of processing time.
• Developed process to auto sync Knowledgebase application with Active Directory, creating a single sign-on for users, reducing access administration expenses.
• Delivered 55 projects while performing production support, reducing overall IT cost.
VISIONETSYSTEMS INC, Cranberry NJ 1988 - 2002
Project: CountrywideHome Loan, SimiValley CA (2001 – 2002)
Consultant Sr. Analyst Programmer/Project Lead:
Designed, Developed, and Implemented application components for account number expansion, Alltel based loan boarding, and Global Loan Processing application systems. Major application component includes DB2, RPG ILE, CL ILE, COBOL, CICS & JCL.
• Converted classical System i database to new fully normalized DB2 UDB using SQL DDLs, increasing database portability & readability.
• Developed a process to board loans from vendor application, increasing productivity and accuracy.
• Studied, prototyped and proposed data isolation and data abstraction layer solution for existing application software RPG ILE, reducing risk of continuous application software changes.
Project: American Management Association, NY (2001)
Consultant Team/Architect Lead
Migrated one of the core application running in Mainframe environment to IBM System i platform. Major application component includes CICS, COBOL, JCL, DB2, SDA, & SQL.
• Developed tool to auto convert BMS screen sources to SDA DDS sources, and CICS/COBOL constructs with matching COBOL/400 constructs increasing productivity and reducing errors.
Project: Teligent Inc, Reston VA (1999 –2001)
Consultant Analyst Developer/ETL Tuning & QA
Worked on Decision Support System as a team member. The DSS extracts data from source systems (billing, financial, inventory, sales, OE&OM, engineering etc) and loads into Informix based data stores. All analytical reports are than produced using Crystal & ASP. Major application component includes Crystal, RPG, Data Stage, Informix, ASP, & SQL.
• Developed custom ETL process to load large billing data, reducing load time from 22 hours to 3 hours.
• Designed and developed finance fraud management, tax & regulatory report systems, enhancing business control.
• Web-enabled key management reports using ASP, improving easy remote access.
• Reversed data model billing system using Erwin, enhancing understanding and enabling fast business-centric reporting.
• Prototyped, designed & implemented data marts using COGNOS, improving user interface with slice and dice reporting features.
Project: Eaton Corporation, Marshall MI (1999)
Consultant Analyst Developer/Data Architect
Joined Eaton’s Y2K remediation team as Sr. Analyst Developer. The core application was in RPG/400 and CL.
• Proposed new application testing methodology, reducing testing effort from six months to two months and saving significant labor costs.
• Designed and developed customize data aging tool as part of new testing methodology, saving money as compare to third party data aging tools.
• Led integration test effort and developed a process to make sure all screens and documents produced displayed ‘Test Run”, avoiding any unforeseen issuing of wrong check or indent.
• Developed application interfaces in IBM System i to pull data from Oracle, improving cross platform interface.
Project:Benjamin Moore Paints, NJ (1998)
Consultant, Project/Team Lead
Led and successfully delivered the Y2K remediation effort of Benjamin Moore Paints comprising over two million lines of code. This conversion was done using Time Translation Technique (3T).
• Awarded “Y2K project of the year” for exceptional work in leading team of 20 developers and delivering quality work in record time.
• Proposed and implemented performance based incentive system for developers, increasing productivity and enhancing quality of work.
• Trained new hire and known as Master Trainer, ensuring best practice & consistence of service.
• Designed and implemented knowledge sharing process and layout for new knowledge base, reducing training and problem resolution time to 35%.
Project: IBM Pakistan (1995 – 1997)
DBA/Architect/Team Lead
On behalf of IBM Pakistan studied and documented procedures of a large inventory management system then designed a distributed information management system covering 27 locations. The application was developed on IBM System i. Led the development effort in the implementation of the first pilot system. All operations are on-line, interactive and real-time. Code was developed in COBOL/400, ILE COBOL, SQL and CL.
• Developed state of the art store management system, providing simple and unique interface for all different commodities like armament, signals, Engineers, Artillery, Ammo, GS&C, Electromechanical etc.
• Designed distributed database, providing high availability and 100% data redundancy in case of server fail over.
• Created store management application, improving accuracy and productivity from 3 to 8 on 10-point scale.
• Developed training for internal and external audiences, including application users and managers.
• Cross-referenced X-Ref global and local Identification numbers, resulting in better inventory control for location & re-ordering and reducing significant cost.
OTHER NOTABLE ACCOMPLISHMENTS:
• Designed and implemented new motor vehicle registration system, ensuring 100% accuracy and enhancing productivity over 50%.
• Designed & implement new cane accounting & procurement system, resulting in 90% approval rating.
• Re-Designed the costing systems for bureau client to calculate machine wages, reducing execution time from 22 hours to just 15 minutes.
TECHNICAL SKILLS
Languages & Tools SQL, RPG, COBOL, Java, JSP, J2EE, SOA, TIBCO, SOA, VB Script, C#, HTML, Natural, FoxPro, SQL, PL/SQL, SQL Navigator, Sequel, Hawkeye, Erwin, Visio, Websphere, TIBCO , CONNEX, COBOL, CICS, JCL, ICCF, TSO,
Databases Oracle, DB2, Informix, MS SQL Server, MS Access 2000
GUI's & Reporting Tools Seagate Info, Crystal, Impromptu, MS FrontPage 2000.
OS/Networking iOS, VMS, VSE, VSE/SP, MVS Unix, Linux, Windows NT, Windows 98, Windows 2000, DOS 6.0
Change Mgmt. Microsoft Visual Source Safe, MKS, Aldon CMS, Turnover, Continuus
Hardware IBM iSeries, zSeries, pSeries & xSeries servers. Sun E10K, Intel Servers, HP Alpha,
EDUCATION:
MBA, Punjab University Pakistan
B.Sc, Forman Christian College Pakistan
PROFESSIONAL DEVELOPMENT
JAVA programming, VA
NAB 4.0, NAS (iPlanet) Admin NT/Solaris, Sun Education Center VA
Computer Networks, LUMS Pakistan
First level management courses for software development firms, LUMS Pakistan.
Certification course in EDP & COBOL, Lahore Technical Board Pakistan