Developer Data

AKIF SYEDSHAH

TECHNICAL SUMMARY:

. Over * years of IT experience in Developing and maintain Database

driven applications.

. Good knowledge in development, testing and implementation using Oracle

9i/10g.

. Excellent experience in designing and building custom applications

using Oracle developer, PL/SQL SQL*Loader.

. Analyzing business needs and translates into system/functional

requirements and write maintainable and optimized PL-SQL procedures,

when necessary.

. Experience in application design, development of specifications,

prototypes, and the development, maintenance, and testing of programs.

. Developed program specifications, detailed design documents, code,

test, and debug application programs.

. Writing test cases, unit test plans. Performs exploratory testing.

. Reviews and optimizes SQL queries for various applications.

. Experience in requirements gathering and documenting, creation of

detailed specifications, Technical Specifications.

. Participated in development, testing and migration of Oracle

applications to the production environment.

. Oracle Application Performance Tuning and SQL Query Tuning.

. Experience with Oracle utilities SQL*LOADER, UTL_FILE, SQL functions.

TECHNICAL SKILLS:

Databases: Oracle 10g, 9i, MS SQL Server, MS Access

Languages: PL/SQL, SQL, HTML, PL/1, Shell Scripting

Tools: SQL*Plus, SQL*Loader, SQL Developer, Toad, Visual Basic.

Software: Microsoft Office (Excel, Word, Power Point, and Access),

Visio.

Operating Systems: Windows 7, Windows XP, Windows NT, Windows 98,

Windows 95, MS-DOS.

EDUCATION:

BS - Bachelors in Computer Science

Northeastern Illinois University, Chicago IL with Minor in Mathematics

PROFESSIONAL EXPERIENCE

Delta Financials Inc Chicago, IL Sep 08 - Present

Oracle Developer

Responsibilities

. Implements data models and database designs, data access and table

maintenance codes.

. Resolves database performance issues, and replication issues.

. Queried from different database tables as per the requirement.

. Used many tables in different schemas for several views,

Procedures, packages, triggers.

. Coded several stored procedures, triggers and packages to

incorporate the business logic.

. Used Oracle DBMS packages to carry out dynamic SQL processing.

. Performed query analysis and enhanced Query performance.

. Used Oracle's indexing features and table partitioning features.

. Developed SQL Loader scripts to load flat files into Oracle

database.

. Designed and created logical data models, schema objects,

validation code and performance-tuning strategies using various

types of Indexes

. Wrote PL/SQL Stored Procedures, Functions and Packages to enforce

business rules

. Generated and used SQL*Loader scripts. Utilized partitions to fine-

tune SQL data retrieval and load

. Extensively utilized PL/SQL Cursors, REF Cursors, Collections

features to perform ETL load from multiple-feeds of source data

. Used SQL*Loader to load bulk data from various flat files.

. Involved in logical and physical database design and Star Schema

design, Identified Fact Tables, Transaction Tables.

Environment: Oracle 10g, SQL, PL/SQL, SQL Developer, TOAD

NEWEDGE FINANCIALS LLC Chicago, IL July 08 - Sep 08

Oracle Developer

1. Worked for a stock exchange company.

2. Developed and test all programs and configurations.

3. Implements data models and database designs, data access and table

maintenance codes.

4. Resolves database performance issues, and replication issues.

5. Database development of stock exchange data using Oracle tools.

6. Queried from different database tables as per the requirement.

7. Used many tables in different schemas for several views, Procedures,

packages, triggers.

8. Coded several stored procedures, triggers and packages to incorporate

the business logic.

9. Used Oracle DBMS packages to carry out dynamic SQL processing.

10. Performed query analysis and enhanced Query performance.

11. Used Oracle's indexing features and table partitioning features.

12. Developed SQL Loader scripts to load flat files into Oracle database.

PLEGO Technologies, Chicago, IL Jan 07 - June 08

Oracle Developer

Responsibilities

. As a Oracle Developer interacted with Business Analysts and client

representatives for requirements gathering, research and solving

client specific data issues.

. Data Analysis, Data Mapping and defining data flows.

. Designed GUI Screens and implemented business rules using Oracle

Forms.

. Created and Integrated Oracle Reports with Oracle Forms.

. Created Procedures, Functions and packages using PL/SQL.

. Written Triggers, Stored Procedures to perform or automate some of

the tasks and enforce business rules.

. Extensively used SQL Loader to transfer data from legacy feed flat-

files to conversion staging area

. Responsible for developing and converting customer information

table, ESN table and SIM table from Legacy systems.

. Optimized and tuned PL/SQL to reduce the loading process - Utilized

SQL*Loader to perform bulk data loads into database tables from

external data files.

. Used Cursors, Ref Cursors and Exceptions in developing Packaged

Procedures and Functions

Detected and corrected bugs during system integration and user

acceptance testing.

. Involved in formulating general methodologies, naming conventions

and coding standards for various procedures and packages.

. Involved in Production Support to resolve end-users data related

reports issues

Environment: Oracle 10g, Oracle Developer Suite 10g - PLSQL, TOAD,

SQL*Loader, Windows XP.

PETERS SECURITIES, Chicago, IL Aug '04 - Jan '07

Database Application Developer

Developed and maintain database for online stocks. Retrieve data from New

York stock exchange as CVS files and convert it into Access database.

Helped users to print daily and specific automated reports.

Responsibilities

. Responsible for Stocks online application, email alerts modules

requirements gathering, preparing Functional and Technical

specification documents.

. Coordinated specifications signoffs with end users

. Designed and created logical data models.

. Wrote Visual Basic Codes, design forms, retrieve data and insert data.

. Involved in logical and physical database design

Environment: Visual Basic 6.0, Access 97, MS SQL

Remington Associates, Schaumburg, IL Jan '02 - Aug '04

Visual Basic Developer

Village of Arlington Heights. Develop database for property tax,

residential and commercial, for the residents of Arlington heights.

Responsibilities:

. Involved in gathering, coordinating and collating data.

. Creating physical and logical data models for rationalizing items,

products and Customer data.

. Created Forms and reports using Visual Basic 6.0 and Microsoft

Access.

. Maintaining Rationalized tables in Development, Conversion, Testing

and QA environments.

Environment: Windows 2000, Visual Basic 5.0, Visual Basic 6.0, Access 97

Sprint PCS, Overland Park, KS Oct '99 - Dec '01

Enterprise Integration

Enterprise Integration allows different applications within Sprint PCS to

coexist and be able to communicate and share data within the enterprise.

The EI provides a consistent and credible business transaction layer across

the diverse applications with substantially varying data needs. EI is the

Sprint PCS strategic data store for common, core enterprise data. Based on

the request, the EI will retrieve and forward data from its own database

and/or the system of record's database.

Responsibilities:

. Involved in creating technical mapping specification documents for

Customers, Orders, Inventory pricing feeds from legacy systems

. Responsible for validating data mappings with end-users and conversion

lead

. Designed and developed Integration interface specifications

. Responsible for data conversion activity for System Integration and

User acceptance testing

. Provided production support to assess conversion impact and timely

resolution

AEROTECH Inc, Chicago, IL Aug '98 - Sep '99

Information System Analyst

Responsibilities

. Involved in validating technical specs for RFQ, Purchase Order,

Vendors, Customers, stock availability and Invoicing processes.

. Designed and fine-tuned the logical and physical data model for Quote-

to-Invoice process

. Generated number of SQL scripts to create Master and transactional

tables, Views, Synonyms, audit, integrity constraints setup

. Assisted DBA and System administrator in scheduling Order validation

and confirmation jobs.

. Prepared and maintained documentation capturing the process,

troubleshooting tips and scope changes

Configure, maintain of standalone units and troubleshoot hardware failures.

Help setting up user accounts and provide system support.

Environment: Microsoft Access, Windows 98, Excell

Contact this candidate