Post Job Free

Resume

Sign in

Sr SAS Developer & Analyst

Location:
Pinellas Park, FL, 33782
Posted:
June 01, 2010

Contact this candidate

Resume:

HAMIDA MOHAMMAD

**** ***** **** *** ****: 727-***-****

Pinellas Park, FL 33782 Email: jqh6x1@r.postjobfree.com

Summary:

Over 9 years of software industry expertise in Client/Server based database application development using Relational Databases Oracle, MS Access, SQL Server and Sybase in MS-Windows environment.

Proficient in PL/SQL, Oracle Forms. Oracle Reports, Crystal Reports, Delphi and VB 6.0/5.0. VB.Net, ASP, HTML,

MSSQL 2005, Reporting services, Oracle Business Intelligent Tools, VBA, PowerBuilder, UNIX and Excel.

Seeking a position as a Programmer/Analyst, Report writer. Team player and self-starter with excellent communication and analytical skills.

Professional Skills:

Development Tools: Oracle 11i, SQL, SQL*Plus, Sybase, Oracle Forms 6i and Oracle Reports 6i,

Business Intelligent Tools, Delphi 6.0/5.0, Crystal Reports 9.0/8.0, VB.Net,

MS Access 2003/8.0/7.0, VB 6.0/5.0, CGI Forms, Visual InterDev, PowerBuilder,

ASP, Front Page, MSSQL 2005, Reporting Services, UNIX, Spherical Timesheet

Languages: PL/SQL, HTML, Java Script, Visual Basic, JCL

Operating Systems: Windows 2000/NT/XP

Project Software: Visual InterDev, ASP, ODBC, ActiveX, TOAD, VISIO, Rapid SQL, Easy SQL, PVCS, MSWord, Excel, SVN, Control-M, CA7, T204, SAR, Lotus Notes, Multi Edit, Lemmy, SVN,

MSSQL Reporting Services (SSRS), Oracle Business Intelligent Tool (BiTool), Mercury

Work Experience:

Oracle PL/SQL Developer, Ciber Inc Tampa, FL Feb 2009 – Apr 2010

As one of the PL/SQL Developer involved in the development of procedures, functions, triggers, Packages for the Exchange Traded Funds, a financial trade transaction system, that uses PowerBuilder for front-end development and Oracle PL/SQL as back-end.

• Modified a procedure to move the data from the temporary tables to the main tables. Used merge and Object types to make the procedure more efficient.

• Involved in the development of Canadian Ishares create order file project. This is an extensive package involving the validation of the approved orders created for the current date and the order file get created in the fixed length format in the UNIX directory.

• Complex stored procedures are written in PL/SQL to create the tables and then insert the data into the tables.

• Got to learn PowerBuilder fast and got assigned to create some PowerBuilder screens for the Underwriters project.

Environment: Oracle 11i, TOAD, SQL Plus, PL/SQL, PowerBuilder 9.0, VB.NET, JAVA, Net Beasn, MS Word, PVCS, Mercury, UNIX and Windows XP

SQL Programmer/Report Developer, Revolution Money, St .Petersburg, FL Dec 2007 – Feb 2009

I was one of the reporting and development team member at Revolution Money. My responsibilities include developing complex reports, data analysis, coding, testing and research. Helping the users in day to day problems and providing them easy solutions. Designed and developed reports in oracle SQL and used excel as the reporting tool to deliver the reports. Learned the new Oracle Business Intelligent tool (BiTool) to deliver web based reports to the customers. Complicated stored procedures are written in oracle 11i.

• Designed and developed dashboard reports.

• Developed front end excel form to deliver the reports. Complex macros are written in VBA to parse the data into different tabs based on the program name.

• Complex stored procedures are written in PL/SQL to create the tables and then insert the date into the tables. DBMS scheduler is used to schedule the jobs to run daily, weekly and monthly basis to insert the data into the tables and the data is extracted for building reports.

• Used direct SQL functionality to create the Oracle Business Intelligent web based reports.

• Used the SVN software for change control.

Environment: Oracle 11i, TOAD, SQL Plus, PL/SQL, Excel, Access, MS Word, BI Tool, SVN, UNIX, Crystal Reports

And Windows 2000

Page 1 of 3

Resume for Hamida Mohammad 727-***-**** ------------------------------------------------------------------------------------------------

Programmer/Analyst, Nielsen Media, Oldsmar, FL Feb 2005 – Dec 2007

One of the technical team members of DDM (Distributed Database Management). Responsibilities include report development, helping and rectifying the problems the users in daily basis. 24/7 pager support. Designed and developed Main frame reports for the Client service department into Crystal reports 9.0. Complicated SQL queries are written in Sybase to accomplish these tasks. Involved in the Spherical Timesheet project. Creating reports using Microsoft reporting services.

• Developed several reports based on the user requests using crystal reports.

• Developed Lineup Data Entry form for the data collection group in MS Access. The users can enter their channel numbers, Channel names, dates, formats, etc instead of time consuming manual work.

• Created ASP pages using real time data from the database for the department website.

• Changed the JCL code in the TSO based on the user requests and ran the jobs in the CA7.

• Created and maintained the Employee database application written in Ms Access and Visual basic.

Environment: Sybase, Rapid SQL, MSSQL, Reporting Services, Crystal Reports 9.0, Excel, Access, CA7,

Control - M, VISIO, Front Page2003, ASP, Ultra Edit and Windows2000

Software Engineer, Veredus Corp, Tampa, FL Aug 2004 – Nov 2004

Client: Homeshopping Network, Saint Petersburg , FL

Designed and developed Finance Reports using Crystal Reports 9.0 and Oracle stored procedures. All the business rules and user specifications are used in developing the oracle stored procedures. More complex queries are written to accomplish these tasks.

• Developed the Complex Sales Journal report and financial reconciliation reports running daily and monthly basic.

• Oracle analytical functions are used in developing the stored procedures.

• Maintained the MS Access database for all the reports created in the finance department and documented.

• Developed the Customer information screen where the user enters the customer information, their address, orders and other personal information.

• Developed reports for the IT department-using oracle Reports6i.

Environment: Oracle 8i, PL/SQL, SQL Plus, Forms6i, Reports6i, Crystal Reports 9.0, Toad, Excel,

MS Access, PVCS, Ultra Edit and Windows2000

Programmer/Analyst, PSCU-FS Inc, Saint Petersburg, FL Jun 2000 – Jun 2003

Achievement: At PSCU-Financial Services striving to meet the goal of Go-Live date and keeping the project in the budget has always been my utmost responsibility above and beyond quality deliverable work. Developed most complicated reports on a very demanding schedule.

• Worked independently on a project to implement inbound interface into Oracle from BONDATA

&BONHISTORY Parsing Application.

• Developed the above process using Delphi 6.0 to parse a huge data file into multiple files based on dynamic

conditions specified by various user parameters.

• Created numerous Oracle stored objects, Packages, Procedures, Functions and Triggers to support the Oracle

data conversion.

• Designed and developed summary and detailed reports using Crystal Reports to according to user

Specifications.

• Did extensive analysis and development on the new Billing Application using Oracle 8i & Crystal Reports 8.0.

• Interacted directly with the users in business requirement analysis, process design & enhancement, application

Development, testing, and documenting the same.

• Converted all the Delphi 2.0 Reports to Delphi 6.0 Quick Reports and Delphi 5.0 Application to Delphi 6.0 Application.

• Designed & Customized the Credit Union web sites using Web Administration Tool and XML Style sheets.

Environment: Oracle 8i, PL/SQL, Delphi 5.0/6.0, Crystal Reports 8.0, Excel and Windows/NT

Programmer/Analyst, Mango Technologies, Tampa. Dec 98 – May 2000

Achievement: Worked as a team member in developing an application for USF Tampa and was used for student registration, grade report and employee information. Oracle 7.3 was used as the database engine with Developer 2000 as the GUI tool. Oracle forms are used in developing the student’s registration screens. All the functionalities like menu bars, tool bars, tool tips are used. All the forms are consistence by using visual attributes. Developed, lots of reports using Oracle Reports 2.5.

Page2 of 3

Resume for Hamida Mohammad 727-***-**** -----------------------------------------------------------------------------------------------

Environment: Oracle 7.3, Developer 2000, Forms 4.5, Reports 2.5 and Windows95

Education:

• Certificate of Advanced Training in Oracle Database and Oracle Forms and Reports

• Certificate in Object Oriented Programming in Delphi.

• Certificate in Crystal Reports Designing by Hammerman Associates.

• Took course in VB.NET from St. Pete Junior college, USA GPA (4.0)

• Master of Science, Andhra University, India.

• Bachelor of Science, Andhra University, India.

• Bachelor of Education, Andhra University, India.

• Certificate of Achievement in UNIX ESSENTIALS

• Certificate of Achievement in FrontPage

Awards & Honors:

1. Certificate of appreciation for securing highest marks in overall Master’s Program.

2. Winner of National Merit Scholarship in Bachelor’s Program.

Personal: Enthusiastic, Organized and Hardworking.

References: Available upon request.

VISA Status: US Citizen

Page 3 of 3



Contact this candidate