Oracle Developer Us Citizen

Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.*** (Preferred) Work Authorization: US Citizen OBJECTIVE

To become a strategist who helps business grow exponentially streamlining the processes and systems using years of functional and technical experience in several industries. To be part of a result-oriented and challenging work environment where I can teach and learn at the same time contributing towards the success of employer and myself. SUMMARY

Around 22 years of experience and have been responsible for design, development and implementation of software applications using Oracle Database, Oracle Developer tools and Sun Solaris. Experience with data migration, SQL, Advance PL/SQL, Oracle Developer6i / 8i/ 9i / 10g / 11g / 12c / 19c, stored procedures, functions, triggers, packages, Import/ Export Utility, SQL*Loader, very good understanding of Business Process / System Analysis/Design, Data Modeling.

Experienced in customized application development using Advance PL/SQL APIs.

Experienced in data migration using SQL * Loader and external table.

Strong hands-on Oracle Forms and Oracle Reports & PLSQL all versions.

Experienced in Object Groups, Property Class, LOVs using OO techniques and template base programming.

Experienced in complex reports using Oracle Report Writer 6i, 9i, 10g, 11g, 12c.

Worked with Business Managers/Analysts and developers to correlate business logic, requirement specifications.

Delivered optimum benefits and has full life cycle implementation exposure: Business Requirements Definition, Modeling, Logical Database Design, Mapping, Data Conversion, Validation, Testing, Documentation, Production Migration, Post Implementation Support, Assessments, Enhancement and Refinements.

Experience in Client/Server development using different databases like MS Access 7.0/2000 and Oracle 7.x to 19c on Windows and UNIX platforms.

Various projects analysis and designing in Manufacture, Pharmaceuticals, Healthcare, Entertainment and Research Industries.

Hands on experience in all aspects of System Development Life Cycle (SDLC).

Strong analytical, problem-solving, organizational, communication, learning and team skills.

Excellent interpersonal skills, motivated, energetic team player with demonstrated proficiency for learning new tools and business environment with excellent communication and analytical skills.

Experience in maintaining existing Java soap web services and Restful service API’s. Also experienced with designing reports in core Java. Knowledge of JSP and able to understand and debug J2EE applications.

Able to manage changing responsibilities and deliver time critical projects on schedule.

Migration/upgrading of Oracle8i database to Oracle9i database & from Oracle 9i-> 10g-> 11g-> 12c.

Proven ability to accept challenges and produce results in a multitask environment.

Some experience with Crystal Reports.

Exposure to Informatica Power Center & MicroStrategy & Oracle DRM.

Experience in leading multiple teams domestic and international. Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen TECHNICAL SKILLS

Languages: Oracle Forms & Reports, Oracle Designer, SQL & PLSQL, Java, XML, HTML

ETL Tool: Informatica 6.x. Micro-strategy.

Reporting Tool: Crystal Reports.

Scripting languages: Korn, C shell programming.

Operating System: Windows, Sun Solaris UNIX, Linux. Commercial packages: Oracle Developer Suite, SQL Loader. Jenkins, Serena Business Manager,

Database Oracle 6/7/8i/9i/10g/11g/12c,19c, MYSQL & PostgreSQL Modeling Tools Visio, ERWIN

Internet Tools JDBC ODBC, IIS, Apache Tomcat, WebSphere 5.0, Eclipse, IntelJ

Methodologies Object Oriented, Structured, Waterfall, Agile Other Utilities & Tools TOAD, SQL Developer, PL/SQL Developer Version Control PVCS, Subversion, SourceSafe, TFS, Bit Bucket, Github. EMPLOYMENT HISTORY

Staff. Software Engineer (Database) April-2017-May-2024 Thermo Fisher Scientific (Fulltime)

Responsibilities / Accomplishments

Project is based on EAV model on AWS Server.

Mainly into 3 different types of tasks

o Product improvement. Find bugs, performance issues.

Provide best possible solution to solve issues.

o Re-Architecting current project to improve performance.

Data Modeling, redesigning database structure.

Wrote new codes in PostgreSQL (Version 12).

• Procedures, functions, triggers, Views, Materialized Views, Sequences, Types objects.

Migration / Transformation of data from Oracle to PostgreSQL. o Client Support

Includes day to day request to solve customer issues. o Help in other projects where needed.

Optimizing queries using explain plan and different ways of writing queries to improve execution plan for each client based on their requirements.

Suggesting new techniques to get queries results get fast and accurate.

Follow JIRA and Pivotal tickets to communicate with clients and Support and Service Teams.

Helping and mentoring another team members.

Working with TechOps & DevOps team members when need copy of client schemas with their permission using AWS Oracle Database or resolving database issues.

Completed HIPPA training for each client we directly access their database remotely.

Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen

Working with multiple teams in India and Vietnam to support the product and customers.

Lead multiple teams, local and international (Vietnam) to improve product. Technologies: Toad, Oracle 11g/12c/19c on AWS, PostgreSQL 10 & 12. Aquadata, IntelliJ. Sr. Oracle Developer Mar-2017-April-2017

ESPN (Contract)

Responsibilities / Accomplishments

This project exists in BI Group

Analyze schema’s to find out which database object will get impacted when user change table in their OLTP System.

Show how column mapping which already exists and which are not exists with future columns which are going to map to bring data in Landing and then to ODS Schema’s.

Compare DW schema’s with ODS Schema’s to check we are not missing any columns and show the difference if exists.

Wrote some optimized adhoc queries as per requested.

Helped Micro-strategy Developer to write optimized query for their reports. Oracle Lead Consultant May-2016-Feb2017

UTC Aerospace Systems (Contract)

Responsibilities / Accomplishments

Engineering Information System (EIS also known as Material Master System)

Completed numerous task in short period of time.

Establishing process in place to avoid direct access to production data change.

Help resolve issue related to bill of material (BOM) using EIS System.

Working directly with stake holders/customers to understand the issue and if it is a user error, train user on spot how to use this screen or else request user to create ticket. Also follow up on users to test and approve their tickets.

Working with stake holder to gather information's about enhancement requests.

Pre-estimate task time line to be completed, tested and up to implementation.

Writing complex queries to create adhoc reports per request.

Creating/modifying functions / procedures / database packages to resolve issues and complete enhancement tasks using Toad to meet the dead line.

Working on Oracle Form 10g (Web based custom Application).

Working with triggers, functions / procedures & Oracle built-in packages.

Providing best possible solution to the task, so same issue will not recreate.

SAP Integration with EIS

Working with SAP development team on the following:

Integrate Cage Code data from SAP to EIS System (in progress).

Integrate BOM for Type 'S' to send data in bulk instead of individual parts to SAP.

Upgrading Oracle 10g to 12c (Forms / Report)

Helping team member in installation process or Weblogic and client Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen development environment.

Converted 10g forms & Reports to 12c.

Sr. Oracle Developer

ESPN Inc. (Full Time) March 2006 to Jan-2015

Responsibilities / Accomplishments

Bass Fishing Project

o Pre-existing system was mostly manually entered data in production database. o Conduct data model reviews with Manager.

o Create data objects (DDL).

o Enforce standards and best practices around data modeling efforts. o Lead project to analyze, design, and develop, Implement Event Registration System. Later Bass requested to do the same for their Athlete Profile and Registration System. This system was done in Oracle Forms, Reports & PL/SQL. o Designed multiple Oracle reports for registration systems and athlete profile data.

X Games Project

o After successfully deployment of Bass System. Manager requested to take a lead and incorporate X Games Event and Athletes Registrations System under same screens and separated by roles so Bass only see Bass data and X Games users only see X Games data. This development was also done in Oracle Forms, Reports & PL/SQL.

o Responsible to import data from SQL Server to Oracle for X Games Payments. o Designed Screen in Oracle Forms for athlete’s payment system that allow accounts department to modify payments and issue manual checks and generate some Oracle Reports for them as per their need.

Re-Architect Event and Athletes Registration System o Interact with 3rd party vendor to fulfill their UI analysis needs. o Lead team to re-architect Event & Athletes Registration Schema and setup roles for end users which includes data modeling using ERWIN. o Conduct data modeling reviews with team members. o Generated SQL Scripts and created data objects (DDL). o Lead team and myself extensively involved in writing SQL & PL/SQL code to transform data from old schema to new schema.

o Worked with end-user to identify mandatory and nice to have reports which reduced from 180 to 100 reports and re-write 100 reports for new schema. o Helped team to test third party vendor UI and worked on Java after they delivered incomplete project and made system stabilized and delivered to end- user, that include debug SOAP services

o Maintain existing web services developed in Java. Debug code to find issue and provide solutions to the issue and fix issue when needed and test service to verify results.

o MicroStrategy

Introduced this tool to Team and other development groups in ESPN

Designed prompts and filters to generate reports in grid and graph mode.

Created customized reports to fulfill customer requirements.

Created dashboards to access reports for each user.

Setup accounts for each users to access their dashboards.

Migrated whole Events Database Schema, Oracle Forms & Reports from 9i to 10g and later from 10g to 11g. Find and fixed invalid objects and test all types of scripts and worked with end user to test their applications.

Outsourced Event & Athletes Registration to New Vendor. o Worked with vendor to provide all UI information’s and business logics. o Have vendor transferred data in JSON format wrapped around XML via Web Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen Services to ESPN on each action.

o Atomized process of receiving data and updating tables by extracting data from Web Services and insert into Event Schema Tables.

Actively provided onsite and offsite support to each events (Bass / X Games).

Responsible to optimized preexisting queries and write optimized queries. Performed cost base optimization techniques.

BottomLine Project (Bottom ticker on all ESPN Channels) o Responsible to setup new networks for BottomLine Project to show their data as per their requirement, such as ESPN Brazil, ESPN Argentina, ESPN Australia. o Responsible to maintain over 4 schemas that mainly includes Packages

(Procedure/Functions) for automated scores/messages, manual scores/messages, graphics and networks.

o Created XML from data and extract data from XML. o Performed SQL and PL/SQL tuning and Application tuning using various tools like EXPLAIN PLAN, SQL*TRACE, TKPROF and AUTOTRACE. o Extensively involved in using HINTS to direct the optimizer to choose an optimum query execution plan.

o Interact with offshore staff (Bangalore, India) to discuss issues and worked together to resolved issues.

o Responsible to create project executables file of BottomLine project and deploy code in DEV and QA environment.

o Worked with system support team to deploy BottomLine project to production. o Testing / Re-testing new code and write bugs in Jira application. o Helped other teams in different groups on their Forms and Reports projects that includes designing screens and reports, writing queries, triggers, functions and procedures.

Technologies: Oracle Forms 9i & 10g, Reports 9i & 10g, PLSQL, PLSQL Developer, Java, PVCS, Oracle database 9i, 10g, 11g, Java, Citrix, Windows, UNIX, Linux, ERWIN, ER Studio, Visio, HP Quality Center, JIRA System, Parasoft SOATest, Tortoise SVN, Sourcesafe Oracle Programmer/Analyst September 2004 to July 2005 System Research Automation Inc., Mississauga, ON, Canada Responsibilities / Accomplishments

Wrote Procedures, Functions and SQL Loader scripts.

Designed and developed the high-level system specifications as team effort. Also designed and developed the high level and low-level functional specifications.

Involved in Analysis, design and Development of the System

Performed SQL tuning and optimization on views and queries generated by reporting front-end packages and developers.

Interpreted logical and physical data models for business users to determine common data definitions and establish referential integrity of the system.

Accurately code and unit test each modification by meeting System Requirements.

Worked with team members to share functional and technical knowledge.

Provide timely status feedback to the team leads and manager.

Database application development; created tables, relationships, queries, forms and reports.

Modified the database structure and updated database based on user requirements.

Writing and debugging triggers and stored procedures and database functions.

Production support of Oracle applications.

Heavy interaction with users, make them understand the use standard reports. Trying to keep changes to minimum.

Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen Technologies: Oracle tools (Forms, Reports and PL/SQL), Oracle database (8i & 9i), UNIX (shell scripting)

Oracle ETL Developer / Java Developer June 2003 to August 2004 BSmart Technology Inc., Woodbridge, ON, Canada

Responsibilities / Accomplishments

Involved in developing Logical and Physical Data Models using ERWIN.

Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements.

Involved in creation and maintenance of Repositories, Folders, Users and Groups.

Worked extensively with Lookup, Router, Aggregator, Expression, Joiner and Filters etc.

Configured source, targets, mappings and workflows.

Created Mapplets transformations.

Developed 100s of complex stored procedures using advance PL/SQL.

Fine-tuned and improved the performance of mappings.

Created Partitions and Indexes on tables for faster execution of queries and improving performance.

Developed data base triggers for data validations.

Loaded client data from ASCII files using SQL*Loader.

Involved in writing queries in MySQL for Java project.

Developed some reports in core Java for Java Team and in Crystal Reports for BI Team. Technologies: Informatica Power Center 6.x, Oracle 9i, PL/SQL, Java, MySQL, Crystal Reports, Windows 2000/XP, TOAD, ERWIN

Oracle Developer Consultant January 2001 to May 2003 System Research Automation Inc., Mississauga, ON, Canada Responsibilities / Accomplishments

Involved in Analysis, Design and Development, Testing, Maintenance and resolved problems during implementation.

Involved in designing the requirement document using Erwin & Visio.

Worked on Food Processing System and Misc. Items Procurement System.

Modules Includes Order Entry, Raw/Packaging Materials & Misc. Items Procurement System, Store Inventory Control System.

Produced various reports as per the requests of the other departments using Oracle Reports.

Tuning SQL queries in order to increase the performance related issues of the existing database packages & functions.

Assist in migration of database from Oracle 8i to Oracle 9i. Technologies: Oracle Developer Suite, Oracle 8i, SQL, PLSQL, Oracle Utilities, Windows Oracle Developer/DBA January 1997 to August 2000

Knoll Pharmaceuticals Ltd., Karachi, Pakistan

Responsibilities / Accomplishments

Involve in Analysis, Design, Development, Testing, Implementation and Maintenance after implementation or Material Resource Planning System (MRP).

Designed conceptual data model based on the requirements, interacted with non- technical end user to understand the business logic.

Modeled the logical and physical diagram for the MRP project. Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen

Discussed data model, data flow with development team members.

Modules include

o Material Planning for Planning Department.

o Local Procurement System.

o Import Procurement and Tracking System.

o Inventory Control System.

o Quality Control & Assurance System

o Production Control System.

o Distribution System.

All systems are integrated with each other and are automated.

Designed, Developed, Implemented some Finance Department Systems: o Purchase Analysis System (Integrated with MRP System) o Material Valuation System (Integrated with MRP System) o Work in Progress (WIP) System (Integrated with MRP System) o Prepaid & Deposit System.

Developed Engineering Spares Inventory Control System.

Wrote PL/SQL Procedures, Stored Procedure, Functions, Packages, Libraries and Custom Views.

Technologies: Tools used ORACLE 8,8i, SQL Navigator, SQLPlus, SQL, PLSQL, Designer 2k, Developer 2k, Reports 2k, ERWIN and Visio. Windows NT/Server 2000, Novell Netware 3.5, 4.01, 5.

Programmer Analyst February 1994 to December 1996

Computer Services Consultant, Karachi, Pakistan

Responsibilities / Accomplishments

Worked for Gatron Industries Ltd. (Manufacturing Silk Threads).

Analyzed, Designed, Developed, Implemented of following Systems: o Order Entry System.

o Procurement System (Local & Imported Items).

o Store Inventory System.

o Production Control System

o Payroll System and integrated with already designed Personal Information System.

o Designed some MIS reports as per special instructions of Company Directors that allow the Directors to keep track of each department performance and Production Loss.

Worked on Procedures, Functions, Form and Reports.

Migrated data from FOXPRO based Time Management System to Oracle Database using SQL*Loader.

Technologies: Tools used ORACLE 6/7, SQL*Plus, SQL, PLSQL, SQL*Loader, Visio, FOXPRO, UNIX

Programmer June 1992 to January 1994

The Computer Wizard, Karachi, Pakistan

Responsibilities / Accomplishments

Personnel Information System and Time Management System (TMS) developed for this company. Those comprehensive systems are versatile systems and are integrated with each other and TMS have capability to integrate with any payroll system and can be installed in any company with some required modifications. Wrote Procedures and Functions using PLSQL. Haji Syed Hassan

Cell: 860-***-**** Located in Bristol, CT, 06010

Contact: ********.******@*******.***, Work Authorization: US Citizen Technologies:

Tools used ORACLE 6, ORACLE Forms & Reports, SQL*Plus, SQL, PLSQL, UNIX EDUCATION

B.S., Computer Science

Bachelors in Computer Science from University of Karachi, Pakistan. Passed 1997. PROFESSIONAL COURSES

Advance Oracle Form & Reports

Advance PL/SQL

Java /J2EE

COBOL

Contact this candidate