“Leader, Team Player, Determined”

SYED HAMID

*Canadian Citizen and US Green Card Holder*

Country: USA

Email: syedahamid@yahoo.com

Phone: (515)-661-0136

Openly available and seeking positions in Information Technology!

For additional information please reference to my website: https://sabsidllc.com/

LinkedIn: https://www.linkedin.com/in/syedaqilhamid

Willing to relocate: Anywhere

WORK EXPERIENCE

 Below is a brief explanation emphasizing current work activities.

My project with OTIS Elevator and their client started in June 2020. My major role is to facilitate and produce current functionalities of legacy architectural framework integrating IDMS/ADSO/COBOL languages along with documenting all business functions and edits.

If provided with the opportunity I’m interested in working with DB2 environment. Last 20 years in North America, worked on positions including DBA, Business Analyst, ERP Developer and Mainframe Application Developers. I was involved in a team to convert three legacy systems to ERP in Agriliance (mentioned below), also supported conversion of legacy system to SQL based applications in Service Alberta (mentioned below).

Current tasks include reporting to Legacy & ERP Managers. Besides working with Solutions Architect/Systems Analyst and Developer with expertise in IDMS/ADSO environment.

Managed & worked in diverse environments with exposure to overseas teams. Easily manage competitive projects within tight deadlines. My unique background offers expertise in architectural functions and the ability to focus and manipulate data with accuracy along with acquiring strong attention to detail. My strong technical skills result in the ability to clearly document and communicate with business partners to solve complex problems.

Solutions Architect/Systems Analyst at OTIS Elevator Client (June 2020 to current).

Responsibilities:

1. Facilitate technical framework through documentation. Further the documented architectural functions and provide in depth functionality of data flows for business processes.
2. Weekly presented PowerPoint based documentations of dataflow, business functions and edits along with collected information & reported documentation for business processes to the Mainframe & ERP managers and the team.
3. Review existing dialog’s and COBOL programs logic to extract business processes which was presented and briefly outlined to the project team. My expertise as a dynamic leader had accomplished in the areas of developing innovative solutions, advanced research on existing application with broad technical knowledge.
4. Developing and producing architectural documents for existing online & batch legacy applications, edits, main functions, and process flow which will be used to create specs for new technologies.
5. Expert of Mainframe platform and in-depth knowledge of IDMS database management system. Fulfilled project requirements within allotted timeframe and demonstrated extensive competence within mainframe platform especially the IDMS/ADSO environment. Being able to provide prompt responses with handling complicated solutions, my self-motivated collaborative, fast paced excellent performance had awarded me with a decent reference letter from my manager.

Technical Environment: COBOL, IDMS, ADS/O, JCL, SQL, Servers

Consultant at State of IOWA (June 2015 to Feb 07, 2020).

Responsibilities:

1. I have worked in a multi-task, fast-paced environment with complex programming, tight deadlines and analytical projects with limited directions
2. Increased user satisfaction by adding new functions and improving the overall performance of the process
3. Worked with online screens and changed screens using MAPC, changed map and work records using IDD or IDDM, changes dialog’s/responses using DME.
4. Wrote several new (COBOL batch/DC-Batch) programs and modified existing programs.
5. Used DMLO to fix existing production data some time several every week
6. Worked with Panvelet, maintain program and JCL versions and status. Used Expeditor for batch program, also work with FILEAID.
7. In the duration of five years with State of Iowa, I prepared several detailed Specifications for Programs (batch and online).
8. Within expected timeline, I have prepared individual and complete system Testing. Along with analyzing report status and completing the process of UAT
9. Successfully worked in a collaborative environment and effectively contributed in maintaining and enhancing batch programs using online and dialogues.
10. Will discuss detail in interview.

Technical Environment: COBOL, IDMS, DMLO, ADS/O, MAPC, ADSA, ZOS, TSO, JCL, Abend-Aid, File-Aid and Xpeditor

Sr. Developer with CGI Project on Fannie Mae – Columbia, SC (Jan 2014 to May 2015}

Responsibilities:

1. Work on projects of large financial institution as consultant (Mainframe Developer, COBOL, IDMS ADS/O, ADSA, ZOS, TSO & JCL environment) in SC USA.
2. Increased productivity by effectively resolving troubleshooting in program along with ensuring consistency in the execution of processes.
3. Completed several assigned tasks along with developing detailed program specification for user requirements
4. Changed existing programs and dialogs (ADS/O, COBOL IDMS (Batch) and IDMS DC-Batch).
5. Mentoring IDMS & ADSO and helping in resolving crucial issues
6. Through standard accepted practices, I analyzed and developed through test cases and completed several test programs using unit and system testing
7. Review solutions document create design document and walkthrough with the team via WebEx.

Systems Analyst at EVRAZ – Regina, SK Jan 2010 to Oct 2013

• of employees: 90, 000 (Canada, US & Russia) Overall Project Value: $15M

Mr. Hamid enhanced and maintained running applications on mainframe and designed and developed new user requirements. He also provided production support for online and batch processing. He provided daily monitoring of QA imports and dealt with any issues that arose. He documented issues in Remedy, created internal tasks for development work, and created project requests for work, and sought approval prior to commitment.

Responsibilities:

1. Solutions-oriented Analyst with notable success, having participated in the SDLC including project design and planning, system analysis, development and implementation of system wide applications and manual testing solutions in direct support of business objectives. Documented program changes and user requirements as per business requirements and system specifications. Supervised, reviewed and updated test requirements and got sign-off from project team for industrial based Order, Inventory, Asset Management, Shipping, Finance and EDI applications

1. Developed over 100 IDMS Batch and DC-Batch, ADS/O and CICS online screens, online transaction dialogs, batch programs using COBOL and DC. Used TPSORT on online dialogues and resolved database installation problems after communicating with vendor the online storage issues when releasing large data for sorting using TPSORT in online dialog. Some Netron processor graphical debugger.

1. In-office Lean training and weekly Lean leader.

1. Designed and developed data structure diagram, database record sets and indexes, schema, sub-schema and databases. Used online screen and OLQ to create test data, review data using OLQ and OLQ-Menu, and used OPER to watch online transactions.

1. Coordinated with parallel development team if any of the objects underwent change; coordinated setting up the test environments and performed component installation in test regions.
2. Developed templates used for test cases/scripts, test plans, test summary report and UAT using MS Word and MS Excel, document test results.
3. Worked with users and their requirements for Environmental Record Management Administration system, documented the user requirements, created new query screens and data exports (Web, .NET, Java, HTML and Visual Basic) and updated user manual. Also documented user requirement and design document (SRS and SDS)

1. Have been involved with QA testing per QA guidelines on SDLC, performing testing and user acceptance testing, wrote complex MS/SQL queries.
2. Developed data load and exported programs using COBOL where Excel/ Text file as input/ output was used

1. Worked on data analysis; data from IBM Mainframe and Maximo exported (ETL) daily to SSIS based
2. In the duration of over three years with Evraz, I Prepared several detailed Specifications for Programs (batch and online).
3. I have prepared and further tested individual program/dialogue and complete process testing. Along with analyzing the results followed by completing the process of UAT
4. Also worked with tools like JCL, Abend-Aid, File-Aid and Xpeditor

QA Data Warehouse System, worked with daily data import issues, wrote complex MS/SQL queries.

Developed SSRS reports using SQL queries. Documented system requirement and design document (SRS and SDS) Technical Environment: COBOL, IDMS, ADS/O, ADSA, IDD, DMLO, MAPC, Z/OS, TSO, JCL, MS/SQL, PL/SQL, SSIS, SSRS, Expeditor, FILEAID, Endeavor, IPBridge and Windows Server

Documented and smoothly hand over the project upon departure

Senior Support Analyst at Service Alberta Edmonton AB (Jan 2009 to  Oct 2009)

Mr. Hamid worked on daily high priority to analyze through the IDMS-OPER online transactions. He was responsible for deleting the registry, provided that the task took longer in the system. Land Title Production user support for online applications, watching of SQL and IDMS project, since all IDMS online transactions updated to SQL.

Development and maintenance of applications, including both the batch and online, backed up DBA and PM when needed.

Responsibilities:

1. Worked with users on various technical issues, daily operations and ad-hoc requests; watched daily system maintenance reports and after hour application support
2. Worked with ZEKE for batch job scheduler; scheduled adhoc jobs in ZEKE

1. Provided day-time application, FTP, CASPOOL, DARS, replication between IDMS and SQL project (SPIN) and fax support to Service Alberta Land Registries Examiners
2. Coordinated with other support groups; current IDMS applications were under development on SQL and WEB

1. Following the SDLC; provided system analysis, project design, discussed changes with users, estimated change, development, documented and corrected issues found during software development and testing, user approval, UAT and implemented the changes, documented user and design documents (SRS and SDS)

1. Worked on IBM Mainframe Z/OS platform using COBOL, IDMS, ADSO, DB2 along with SQL servers

1. Corrected batch programs for billing (payment received during day time). Tested the complete batch process to update and to view the $ in online applications executing test plans
2. Reported software UAT testing results to the project manager for SIGN-OFF. Coordinated the sign off documents with development teams in accordance with QA guidelines
3. Developed the templates used for test cases/ scripts, test plans, test summary reports and UAT using MS Word and MS Excel

Consultant  (2006 to 2008)

American Achievement                                  Austin TX                                         Oct  2006  – June 2007

Flint Energy                                                    Edmonton AB                                   July 2007 –  Mar 2008

Raymond Cooperation                                   Syracuse NY                                    Apr 2008 –   June 2008

SNC Lavalin                                                   Toronto CA                                      June 2008 –  Dec 2008

 

Mr. Hamid was involved in upgrading JDE to a newer version with additional reports for all modules that were priority for the financial reports. He tested the new environment, created test cases and presented the issues in weekly meetings.

Responsibilities:

1. Performed system and data analysis following the SDLC to create JDE Contractor application systems; project lead, development screen in JDE 8.11 equivalent to green screen (AS400), implemented Contractor Application and new table help screens. Developed user training and trained contractor user on new developments. Documented user requirement, design and development documents.

1. GL/Daily Trial Balance; converted fields from legacy system into an interim table, mapped the converted fields, and converted the address book values for the component of AP, AR, GL and Asset
2. Documented software and system testing issues, also collected issues found during testing from the team, documented them and presented in weekly progress meeting. Worked with a large team of employee’s and consultants (Letter of appreciation)

1. Utilized SQL Queries to verify test environment data, and DB2 with production

1. Created user reference document and trained user to maintain, monitor and update project testing progress, as detailed as possible to include tasks; such as milestones for task, module level testing and Dry run issues, conversion tables, Sequels, Communications etc. Coordinated with QA and development teams to ensure quality standards were met in development and testing phases

Created a one plan document to maintain, monitor and update project testing progress, as detailed as possible to include tasks such as milestones for task. Testing plan was based on the best information and estimation of times from the project plan. Go No Go impact

Technical Environment: JDE, COBOL, DB2, SQL, PL/SQL, Oracle, AS/400 and iSeries

Lead Analyst Agriliance LLC   MN (June 2000 to July 2006)

• of employees: 20,000 (600 location in US, Canada & Mexico) Overall Project Value: $22 M

Mr. Hamid enhanced and maintained applications running on mainframe. He designed and developed new user requirements and provided production support for online and batch processing.

Responsibilities:

1. Developed new and maintained over 1000 programs using IDMS, ADSO, COBOL, DB2, IMS, CICS, ADSA, IDD, DMLO, MAPC on Order Entry/ Receipt, Price/ Cost Management, Inventory Management, Shipping, Billing and Invoicing, Finance (AR, AP and GL), Customer Management, Rebate Management, Fixed Asset, Sales Profile, Product Purchase History
2. I have focused on maximizing organizational performance through an IT project management knowledge

1. Worked with user project team and technical team members in defining and performing needed enhancements or special requests of the TOPS (Terra Order Processing System) to keep it up to date on business requirements
2. Member of the team that performed all stages of the software development life-cycle including system analysis, project design, development, testing and maintenance of the various legacy IBM mainframe systems and applications (COBOL and CICS), worked portions of design and user requirements.
3. Participated in the evaluation of long term strategies for support of Agriliance Retail system requirements and creation of test plans. Maintained a stable production environment, performed maintenance and enhanced requests and technical participation on development teams in support of Agriliance Retail System
4. Worked on major project ($32 million) towards converting three legacy (COBOL) companies to JDE 8.9 with customization due to the business requirements. Unloaded legacy sales data and created new function in JDE for Agriliance sales history. Participated with Auto Pilot for automated testing, load test and performance test, also worked in parallel with teams overseas
5. Independently maintained all technical and operational aspects of Agriliance’s business; dealt with the users, logged complaints and resolutions in Heat and Remedy ticket systems
6. Provided support for issues related to EDI (Gentran EBD1001-Inbound Editor, EBD1041-Inbound Mapper, EBD1002 Outbound-Editor and EBD1042-Outbound Mapper)
7. Supervised, mentored and trained new staff; QA new development and special nightly jobs if requested to be scheduled
8. Worked with no technical supervision; Created documentation, gathered/ interpreted user requirements and made recommendations, and determined project target dates. Evaluated test scripts and test results to ensure project met requirements and updated user training guide.
9. Logged Application/ Program Report errors found during testing of software and systems and followed- up with the team when ready for re-testing.
10. As a Business Analyst, I prepared several detailed Specifications for new and maintaining the current Programs and Dialogues (batch and online).
11. I Lead the team with testing individual program/dialogue and the complete application process. Along with testing results and coordinated the process results with managers and users.
12. Also worked with tools like JCL, Abend-Aid, File-Aid and Xpeditor

Technical Environment: IDMS, ADSO, COBOL, DB2, IMS, CICS, ADSA, IDD, DMLO, MAPC

 

DBA activities responsible of change and development QA, GE Supply Shelton CT

April 1999 to June 2000

As a DBA, I was responsible for change and development of Database. Other activities included: Quality Assurance (QA) for over 100 developers (local and overseas).

1. Technical project leader for the Application change releases, top contributor and designer of several projects.
2. Redesigned the organizational Database, reviewed User’s and Systems requirements, Defined Entities, Process Normalization and possible Data Redundancy, Populated IDD with Elements, Grouped Elements to Records, Relationship, Attributes, Transaction priorities, Update and Inquired Ratio, Access keys and Generic keys, DB growth, Database Structure Diagram.
3. Backed up and restored procedures. Resolved Applications and User problems, trained Programmers and Users, provided production applications support and resolved number of production after hour issues.
4. Organized, formulated and delegated the morning meeting for nightly batch processing and distributed issues and concerns discussed in the meetings.

Technical Environment: IDMS, ADS/O, COBOL, DB2, CICS, IDD, DMLO, MAPC, MVS, TSO and JCL

Project Lead for Database Design & Maintenance, Personnel & Administration System, Payroll & Log, Recruitment System  Civil Service Bureau – Riyadh, SA  (October 1995 to March 1999)

Responsibilities:

1. Project Lead for Database Design & Maintenance, Personnel & Administration System, Payroll & Log System along with Saudi Ministries Recruitment System.
2. Database Design and Maintenance
3. Task completed for Database Design and Maintenance Projects:

• Estimation of Database Areas and Files, Development of Functional Hierarchy, entity relationship, data flow diagram, data structure diagram, produced data redundancy and created records definitions in IDD.
• DMCL, Schema and Subschema coding and compilations
• Area initialization, Backup and Restore
• Build / Delete / Re-build indexes (Index re-organizations)
• Dump report (File utilization report)
• Area Expansion, Re-structure

Other work completed at Civil Service Bureau:

• Provided training for Database Designer; Explained on how to use IDMS Calc for loading data to IDMS database and Programming techniques using IDMS and ADSO.
• Mentored and coordinated on a large data migration (from old database to new database)
• Developed over 150 online dialog’s using IDMS/ADSO, COBOL/DB2, COBOL/IMS
• Used maximum IDMS features (Store, Connect, Disconnect and Erase) in online dialog’s to update mode, inquiry dialog’s with paging options (forward and backward), statistical dialog’s with generic search (used indexes with partial key), online queries for higher management in Civil Service Bureau with excellent response time.
• Written over 500 Batch and DC-Batch programs using COBOL and IDMS with different systems, Database unload and re-store (with IDMS CALC), database updates (local and CV modes), printing and statistical programs.

Technical Environment: IDMS, ADSO, COBOL, DB2, IMS, CICS, ADSA, IDD, DMLO, MAPC

 

SKILLS & EXPERTISE

• Strong 20+ years of experience within the Information Technology Industry
• Expert knowledge on IBM Mainframes, MVS OS/390.
• Expertise on all phases of Software Development Life Cycle like Planning and Requirements Analysis, Defining Requirements, Application and Database Design, Application and DB Development, Testing, and Deployment (application and databases).,
• Maintained project tasks with changing priorities and tight deadlines. Worked on several technical challenges and provided solutions approved by all stake holders.
• Analytical minded with consistently in resolving ongoing issues that are widely accepted
• Supply Ch, Business Analysis, design and development. Full life cycle systems implementation (COBOL, IDMS, ADSO, MAPC and OLQ).
• Worked on converting Legacy companies to ERP
• Old database structure to new database structure and user training and support,
• Agile and ITIL methodologies.
• Problem identification and resolution, overseas resource communications.
• Specification of original solutions, documentation, Mentoring, Facilitation skills and Change (incident and change management).
• Developed templates used for test cases/scripts, test plans, test summary report and UAT using MS Word and MS Excel, document test results, Peoplesoft, System Analyst/Analyst, Team Player, COBOL, IDMS, DMLO, ADS/O, MAPC, ADSA, DB2, IMS, JDE, JDA (supply chain), Toad, Oracle, SQL, Lotus Notes, UNIX, AIX, Servers, Robot
• PeopleSoft Certificates for JDE Report Writing and Application Development (70 credit & instructor led, MN, USA)
• IDMS (ADV ORGA, Wiesbaden Germany)
• Introduction to IDMS DB/DC, Introduction to Culprit and Database Analysis and Design
• IBM – Computing Systems Fundamental, Introduction to System 360/370, Fundamentals of Programming, ANS COBOL Programming, DOS/VS AMS Facilities for VSAM, DL/1 DOS/VS Information, DL/1 Application Programming, GIS Concept and DOS/VS System Function

 

ADDITIONAL INFORMATION

Dear Team,

As an Administrator, Developer, Programmer & Analyst Major with 20+ experience in IT industry, I possess strong analytical programming, business systems, administrative processes, knowledge of life-cycle application development and wide breadth of technical knowledge. I am confident that I will significantly contribute to the objective of an IT specified company. Throughout my work career I have been exposed to a variety of diverse skills including Data Management Tools, COBOL, IDMS, DB2, IMS, CICS, ADSO, ADSA, ADSO, DMLO, Business Process, System Analysis & Design, Development & Administrator Tools, team management along with develop, maintain processes.

My unique background offers expertise on administrative and implementing solutions. Technical environment: COBOL, IDMS, DB2, IMS, CICS, DMLO, ADS/O, MAPC and ADSA. Designed & developed data structure diagram, database record sets and indexes, schema, sub-schema and databases. I have worked with Solutions-oriented Analyst with notable success, having participated in the SDLC including project design and planning, system analysis, development and implementation of system wide applications and manual testing solutions in direct support of business objectives. Moreover, developing and manipulating existing interfaces, utilizing, programming and analyze customizing applications; resulting in the ability to clearly collaborate with others in diverse settings. Along with identifying and resolving business process gaps and leading to increased performance, through mentorship and coaching is the cornerstone of my approach.

Your company will benefit from my IT expertise as a dynamic player with a track record of success in identifying improvement opportunities, developing innovative & transformative solutions, and leveraging technology to optimize profitability and performance. My demonstrated strengths in Administrative position and my broad technical and business knowledge have facilitated my sustained success.

My strong analysis, team-player and technical skills along with my genuine commitment to a career in IT Administrator, Programmer, Analyst; makes me confident that I will add value, long-term contribution to your company and contribute positively to your company. I would be honored to be granted an opportunity to meet with you to discuss my qualifications and candidacy in further detail.

Thank you for your consideration.

Sincerely,

Syed Hamid (515)-661-0136

 

 

Purge All