Pl Sql Data Modeling

Asim M. Azeem

*********@*******.***

(Cell) 405-***-****

SUMMARY

I have been working as an IT professional, experienced in Oracle RDBMS for more than 15 years, experienced in Data Modeling and Data Warehousing projects. I have been working with PL/SQL applications in Oracle Enterprise Application Server environment. I have experience of writing complex SQL queries and advanced PL/SQL code, experienced in designing, coding, implementing and maintaining of complex relational database models. An experienced professional in SDLC and Agile processes and able to understand and work within these processes. I’m a versatile team player with excellent verbal and written communications skills.

Database Specialist, Employee Group Insurance Division OMES Sep 2015 – Present

The division administers, manages and provides group health, dental, life and disability insurance for current and former employees of state agencies, school districts and other governmental units of the State of Oklahoma. The Oklahoma Insurance and Benefits Board has oversight responsibility and decision-making authority to adopt policies regarding the division’s financial matters.

Environment: Oracle 12, SQL Server2003, Toad, Unix, Jira, Confluence, OEM, Autosys

Responsible for creating and modifying the PL/SQL packages, procedures and functions according to the business requirements

ETL process using SQL Loader, External table and PL/SQL Packages

Involved in developing and scheduling Reports using Oracle BI Publisher

Scheduling jobs using OEM Grid Control and Autosys

Writing batch scripts using Unix/windows for automation including FTP process to download and upload files

Extracting data from Oracle and SQL Server databases for daily and adhoc reporting

Analyze, research and troubleshoot daily database and business issues

Tickets and assigned work progress is maintained by Jira and Confluence

Encryption and Decryption using PGP for secured file transfer

Develop and maintain the documentation to support the team and business

Associate, JP Morgan Chase Jun 2014 – Sep 2015

Chase Mortgage Banking helps customers achieve and sustain homeownership by offering purchase and refinance home loans to first-time and experienced homebuyers, servicing residential mortgage loans, and providing affordable solutions to customers struggling with their mortgage payments. External Reporting Team evaluates and reports modified loans to U.S. Treasury under HAMP various directives. Team supports External Reporting requests for various recipients such as Private Investors, Rating Agencies, Borrower Advocacy Groups and GSEs.

Environment: Oracle 11i, .Net, PL/SQL developer, Toad, UNIX, Subversion, Windows 2000

Responsibilities:

Part of a development team to develop a .Net application with Oracle RDBMS. This application provides LOB users a convenient way to examine and approve default loan modifications, which would eventually be reported to U.S. Treasury under HAMP directive.

Worked directly with users to analyze legacy data, gather requirements, and develop mapping documents for functional specifications.

Wrote Technical specifications from BRD for developers to build the application.

Worked with DBA group for the architecture, data model, spacing and maintenance of this application.

Wrote various reference documents including FAST DEI, Code QA standards for the group. Peer reviewed application code before it goes to production through ITSM.

Experience working across multiple teams in a global organization.

Interface with various stakeholder groups, technical and non-technical.

ETL Data Specialist, Vitech Systems Group, Inc. Sep 2008 – Jun 2014

Vitech Systems Group is one of the world's leading providers of administrative software to pension, investment, insurance and health plan administrators. V3, a Java application using Oracle Database is widely used by various state governments and multi employer pension fund administrators such as VCERA, SBRB, MTRS, NYTU and others.

Environment: Oracle 9i/10g, Java, PL SQL developer, Window server 2000, Windows XP

Responsibilities:

Worked as a conversion team specialist for one of the Vitech’s bigger client.

Worked directly with client to analyze legacy data, gather requirements, and develop mapping documents for functional specifications.

Wrote Technical specifications for junior developers to load this data into V3.

Responsible of receiving this legacy data to be loaded into V3, Vitech’s propriety application. This data included demographics, enrollment, pension, disbursement, SCP and other modules.

Worked extensively with SQL*loader, pl/sql procedures and packages along with batch processing.

Completed SDLC for conversion cycle every month and generated scorecards and reports about each legacy field’s acceptance or rejection into V3 system.

Scheduled meetings with client to resolve issues and enhance programs for next month cycle.

Consultant, BearingPoint, Inc. Feb 2007 – Aug 2008

Maintenance and Repair Overhaul (MRO) Project.

This Government project was to design, develop, construct, install, implement, and deliver dramatically improved maintenance, repair, and overhaul process and facilities support functions for the F100 Engine Business Unit within the Oklahoma City Air Logistics Center at Tinker Air Force Base. The Decision Support System (DSS) support the Business Intelligence requirements of the Maintenance, Repair, and Overhaul (MRO) Transformation of the Oklahoma City Air Logistics Center. The DSS solution provides performance management information to the workforce and Business Unit Management to support shop floor operations and measures the performance of the MRO transformation itself.

Environment: Oracle 9i/10g, Cognos Reports Studio, Cognos Frame Work Manger, OEM, Toad7.5, Sun Solaris UNIX, Windows XP

Responsibilities:

A Key member of the Data Architecture and DBA team on the transformation project.

Gathered functional requirements from users based on the knowledge of Air Force legacy systems.

Designed and developed the Data Model and Mapping of the Lean Transformation Data Warehouse project using Oracle 10g.

Designed database structures in Operational Data Source (ODS) and Data Marts (DM) for data warehouse integrations.

Worked on Oracle ERP module to create multiple Data Mart for various applications within Air Logistics Center.

Developed complex PL/SQL integrations to extract and transform the data into information useful for the Cognos Reports development.

Designed, developed and tested these Oracle database integrations for the ETL process involved in the Transformation project, a complete life cycle.

Used Cognos Framework Manager and Report Studio to create Cognos reports and measurement of performance (MOP) for users.

Sr. System Analyst, BearingPoint, Inc. Feb 2004 – Feb 2007

Tinker AFB APS Project.

USAF pathfinder project, Advanced Planning and Scheduling (APS) that provided an integrated, near real-time, responsive approach of planning and assessment of feasible execution plans through an enterprise-wide view of all Air Force (AF) logistical organizations with which it was connected.

Environment: Oracle8i/9i, OEM, Toad7.5, Sun Solaris UNIX, Windows XP

Responsibilities:

Worked on Advanced Planning and Scheduling pathfinder project for USAF at OC-ALC. The project included the creation and implementation of Oracle integrations and UNIX scripts to pull various legacy data into one Operational Data Source.

As Technical Lead for Demand Planning, he worked with Manugistics Demand Planning and Collaboration Applications on this project.

Worked as Application Administrator for Manugistics Demand Planning and Collaboration applications.

Worked and supported Oracle ERP module to be the sole Data Mart for other various data streams to support OC-ALC.

Was responsible for running and maintaining the monthly batch cycle, which was the heart of the APS project.

Used import and export Oracle utilities for importing and exporting legacy data into Pathfinder databases.

Sr. System Analyst, Contractor TekSystems, Inc. Nov 1997 – Jan 2004

As a TekSystems contractor I have worked as a database/application developer at various clients. I have worked on Oracle ERP, CRM, Siebel, Essbase and legacy systems during these projects. Some of clients were:

Ernst & Young LLP, OH Cigna Dental, FL

Nationwide Financials, OH BP-AMOCO, OH

Motorola, IL Ogden AFB, UT

National City Bank, OH Escalante Power Plant, Grants NM

Education & Professional Certificates & Diplomas

MS Computer Science, NYIT, New York, NY

Oracle Certified Associate in PL/SQL development

Certificate in Oracle9i Advanced PL/SQL Programming

Certificate in Developer6i/Forms & Reports

Certificate in Java Language

REFERENCES AVAILABLE ON REQUEST

Contact this candidate