We provide IT Staff Augmentation Services!

Srprogram Analyst Resume

Kansacity, MO

  • 7+ years of result oriented professional experience in the analysis, design and development of database applications.
  • Experience in developing applicationsPL/SQLCursors, Triggers, Exceptions, Packages, Stored Procedures and Functions.
  • Experienced working with clients on-site, analyzing software requirements and developing solutions and procedures.
  • Strong experience ofdeveloping, implementingandmaintaining application systemsunderUNIX Operating SystemusingSQL,PL/SQL,Oracle Forms,UNIXShell Script (VI Editor).
  • Profound knowledge in Unix shell scripting of files and process manipulation.
  • Extensive experience in using Oracleutility tools likeSQL*Loader, Import and Export.
  • Experienced in performance tuning of the database usingpartitioning, Explain plan, SQL TRACE
  • Hands on experience in creatingperformance benchmarksand generatingSQL*Plus reports.
  • Proficient knowledge in creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub-partitioning,Database linksetc.
  • Extensive experience in usingPLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects, FORALL, Merge,Global Temporary tables,advanced replication, DBMS packages and exception handling.
  • Excellent proficiency in Data Transformations and loading usingExport, Import and SQL*Loaderand worked onExternal tables and Transportable table spaces.
  • Excellent experience inERWIN Data Modeling Tool.
  • Experience in working on bothOLTPandOLAPdatabases.
  • Knowledge about star schema and snowflake data warehouse schemas
  • Refined database reports to extract selected data useful for creating training monitoring plan
    Analyzed the Trainees feedback and assessed customers\' needs using Excel advanced functions
  • Exposure to Metrics environment.
  • Exposure to DIAMOND tool
  • Expertise in writingPL/SQL ETL routinesin data warehousing applications.
  • Knowledge ofPLSQL Object Types, Oracle Parallel Queries, Materialized Views, Bulk Collects and Collections.
  • Ability to meet deadlines and handle pressure in coordinating multiple tasks in a work/project environment. Strong communication, organizational and interpersonal competencies along with detail-oriented and problem solving skills in the technology arena.
  • Ability to work individually as well as in a team with excellent problem solving and trouble-shooting capabilities.
  • Excellent interpersonal communication skills and willingness to learn new tools, concepts and environments.
Oracle Technology Expertise
  • Creation of database objects likeTables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database linksetc.
  • PL/SQL Programming using packages, procedures, functions, Object Types, Collections, Cursors and Text APIs.
  • WritingETL Routinesand programs usingMaterialized Views.
  • Bulk Load techniques usingBulk CollectandFORALL.
  • Hands on Experience in usingORACLE HINTS.
  • OracleImport/ExportUtilities andSQL*Loader
  • Knowledge ofautonomous transactions,Oracle Advanced QueuingandOracle Parallel Queries.
  • Generation ofSQL*Plus Reports.
  • Analyze and gather table statistics for query optimization and creatingperformance benchmarks.
  • Extensive Experience in Oracle BI Tools like Discoverer.
  • Knowledge onOWBenvironment
  • HandlingXMLdata in Oracle usingXML Type, XPathandXPointers.
  • ERWINData modeling tool.
  • Oracle Development tools like TOAD, Oracle SQL Developer etc.

TECHNICAL SKILLS

RDBMS

ORACLE 10g, 9i, 8i, 8.x, 7.x, 6.0, SQL Server, Microsoft Access 97, MYSQL,

Design Tools

ERWin 4.1, Visio 5.0 Flow Diagram, oracle designer.

Version Control

Microsoft Visual SourceSafe 6.0, Clear Case, Perforce, CVS

Data Mart/Warehouse

SQL* Loader, Custom built ETL using Pro*C, Oracle Import/Export, Explain Plan, Performance Tuning, Data Modeling, Erwin, Informatica.

Languages

Advanced PL/SQL , SAS

Operating systems

Sun Solaris 2.6, 5.8, UNIX SVR4, SCO UNIX 3.2,Windows 98/NT/2000/XP.

Educational Qualification/Certifications
  • Bachelors degree in Computer Science (CS),
  • Oracle PL/SQL Developer certified associate.

Experience Highlights

Confidential, CASep2012 till date
SrProgram Analyst

Responsibilities:
Confidential, a Fortune 500 and Nasdaq-100 (ROST) company headquartered in Pleasanton, California CA. Wipro Technologies has entered into to an agreement with ROSS to supportSales Audit ApplicaionandPoint Of Sale(Pos)System. POS & Sales Audit are the key business process handling transfer of sales transactions data from POS through Sales Audit and to RMS, PeopleSoft GL, and other systems in need.

Responsibilities:

  • The process is mostly batch based processing being handled by multiple systems and going through multiple steps to achieve final goal.
  • This team owns the responsibility to do all sorts ofcustomization,data fixes,code fixes,performance tuning and other bottlenecks of the queriesrequest logged against the application by the Business User.
  • In addition to that, we are also responsible for all Enhancement work related toPos Sales Audit Applicaion ReconNETandAJB Credit Settlement Applications.
  • This project includesProcess Monotoring,Schedularandrunnig back jobsthrough application, UI Development, Integration of code with existing system,PL/SQLwork likecreateorupdate procedure, functions or execution of query to generate reports.
  • We do follow the completeSDLCin our all Enhancement/Development projects.
  • For development of the code we are mainly using tools likeTOADand some other integrated application software like Export Builder for Sales Audit and POS modules.
  • The application is built and deployed inUNIXandNTenvironments
  • Authentication is happening through IIS in Windows serverAll customer transactions are getting settled by AJB Credit Settlement process with all banks like Visa/Master Card, AMEX, Discover, JCB etc.Reconciliation process is happening through ReconNET application where it gets data feed from POS, Sales Audit and Banks.

Technologies:Oracle 11g, SQL, PLSQL SQL* Loader.
Tools :Toad, ERwin, CVS
Environment:Windows XP, MYSQL, Oracle 11g

Confidential, KANSACITY, MOMAY2012 till Aug2012
Sr Database Programmer

Confidential is a company under health insurance carriers for Federal Government Employees. It deals with the insurance data from Dental as well as Vision Insurance..

Responsibilities:

  • Creating Stored Program Units in the Form of Packages, Functionsandproceduresfor implementing the complex database intensive business rules Developed.
  • Extensively usedREF CURSORSfor data exchange between java platform and database.
  • Creating Stored Program Units in the Form of Packages, Functionsandproceduresfor implementing the complex database intensive business rules.
  • Developedperformance benchmarkscripts.
  • Developed the data load layer using Bulk Collect technology involvingOracle PLSQL Collections.
  • Extensively usedREF CURSORSfor data exchange between java platform and database.
  • Creating Stored Program Units in the Form of Packages, Functionsandproceduresfor implementing the complex database intensive business rules.
  • Developedperformance benchmarkscripts.
  • Developed the data load layer using Bulk Collect technology involvingOracle PLSQL Collections.
  • Experience in working on bothOLTPandOLAPdatabases.
  • Creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
  • Involved in design of master tables to store the business data.
  • Usage of UTL_FILE package to load the data from external files that is exported from Server
  • Wrote SQL Queries.
  • Wrote PLSQL ETL routines usingXMLDB , XPath Queries,PLSQL Objects and bulk loads.
  • Soap requests to access the web service.
  • Involved in Database Tuning and Improved Application performance using Explain Plan
  • Create technical specification documentation.

Technologies:Oracle 11g, SQL, PLSQL SQL* Loader.
Tools :Toad, ERwin, CVS
Environment:Windows XP, MYSQL, Oracle 11g

Confidential, OAKLAND CAJUN2011-APR2012
Sr Data Modeler/ Programmer

Evaluate the cumulative effects of the 2005 PDRS on wage loss, which is necessary to conduct a comprehensive wage loss study using at least three years of post-injury data for Confidential.

Responsibilities:

  • Heavily involved in developinglogical data modelsandphysical database designand generating database schemas usingERwin.
  • Performingconceptual data modeling, dataanalysis, data profiling, data mappingandETLimplementation for product integration with client\'s applications.
  • Database Backend Developer responsible for creating and managingPLSQL packagesused by Front end applications as well as batch applications.
  • WroteStored Procedures, Functions, Packages and triggers using PL/SQLto implement business rules and processes.
  • Expertise in Sql Queries.
  • Used different methods like regular expression for the data
  • Used aggregators,delimiters,
  • Using different Aggregator functions.
  • Experienced in usingERwinindex editor to update, modify existing indexes, andERwinphysical object editor to update, enlarge existing tables, tablespaces and segments.
  • Experience usingERwinentity-attribute editor andERwinrelationship definition editor to modify, update existing primary, foreign, alternate keys and identifying, non-identifying, recursive and subtype relationships.
  • Experience usingERwinsynchronization dialog to synchronize physical object information with the target.
  • Creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
  • Extensively usedREFCURSORSfor data exchange between java platform and database
  • Involved in writing complex queries using joins andAnalytical functions.
  • Optimized SQL used in Reports and Files to improve performance drastically.
  • As a part of production support was involved in bug fixing and system enhancements.

Technologies:Oracle 11g, SQL, PLSQL SQL* Loader.
Tools :Toad, ERwin, CVS
Environment:Windows XP, MYSQL, Oracle 10g

Confidential, Foster city, CAAUG 2008 May 2011
Sr Database programmer

Chemical Export System is trading software used to control the exporting raw materials from Canada to various countries. This includes Request form, Performa Invoice, Order form, Payments, Export Status and Reports. This system gets the input from Request form and Order form which has details of the customer and the products needed. This data is entered into corresponding tables and the data is moved according to the requirement into staging tables. The data is processed and reports are generated. Export Status is maintained till product is delivered.
Technologies: Oracle 10g, SQL, PLSQL, Xpath, Shell Scripts.
Development tools/methods:TOAD, CVS, SQl Developer, Erwin, Informatica
Environment:Windows XP, UNIX, Microsoft Access, Microsoft Visio, Oracle 9i-10g , MYSQL

Responsibilities

  • Worked directly with user groups, management and other team members to analyze and evaluate requests, and write detailed description of user needs.
  • UsedTOADextensively to develop backend packages, triggers and views to implement business logic.
  • Designed the business logic usingUML
  • Heavily involved with theLogicalandPhysical Designof theDatabase using ERWIN.
  • Developed data models andETLdata mapping for application.
  • Participated in and led requirements gathering sessions to determine data and reporting requirements for a20 TB data warehousingproject consisting of 4 data marts.
  • Created DDL scripts and Stored Program Units for migrating the current product from version 1.2 to 2.)
  • Involved in creating theERD(entity relation diagram ).
  • Generated the table scripts usingErwin.
  • Business user interactions to design the database as per the business rule flows
  • Business rule flow diagram representation using UML techniques.
  • Writtenstored proceduresfor the application to be developed on the database side.
  • Using SQL Loader for populating static tables from CSV Files and VSAM files.
  • Involved in logical and physical design of the database usingERWin 7.1version.
  • Involved in reverse engineering the data model as per the need usingErwin.
  • Creating Aggregate Materialized Views for speeding up the response of SQL queries.
  • Using SQL Loader direct path method for populating static tables and fact tables from CSV Files.
  • Used different functions like regular expression,regressions
  • Used different procedures like delimiters,dynamic statements,viewrs,triggers,etc
  • Involved in writing complex queries using joins and Analytical functions.
  • Automated the data insertion scripts for reference/lookup data using the Visual Basic Macros in MS Excel.
  • Organized working sessions with a group, to truncate the development and testing databases.
  • Reverse Engineered databases and built up the subject areas depending on the requirement.
  • Involved in mapping the data elements from the User Interface to the Database and help identify the gaps.
  • Actively involved inNormalization & De-normalizationof Database.
  • Extensively worked in tuning theMaterialized Views
  • Perform Source-to-Target Data Mapping.
  • CreateData Flow/data Lineage Diagrams(DFD/DLD) to depict thesource-to-Target Mapping and Data Lineage Analysis.
  • Source to Target mapping using mapping techniquesinInformatica
  • Involved in dimensional modeling, identifying the Facts and Dimensions.
  • Run SQL ueries
  • Implemented Referential Integrity using primary key and foreign key relationships.
  • Identified and tracked slowly changing dimensions and determined the hierarchies in dimensions.
  • Created Materialized views or the final forge process using Endeca search engine.
  • Extensively used Analytical functions in the business application development.

Confidential Houston, TXOCT 2007 to JUL 2008
Database programmer

Description

This Project primarily deals with converting the existing application in main frames to Oracle/Unix. The Application is basically to schedule the associates for the store. The Project is to Reverse engineer the flow to oracle and find out the main functionalities of the flow and rewrite them in pl/sql.

Technologies: Oracle 10g, SQL, PLSQL Shell Scripts.
Development tools/methods:TOAD, CVS, SQl Developer, Erwin.
Responsibilities

  • Worked directly with user groups, management and other team members to analyze and evaluate requests, and write detailed description of user needs.
  • Analyzed the flow of the application inCOBOL, Reverse Engineered the application to Oracle.
  • Reviewed logicaldata model, physical data model, data mappingandETL design
  • Involved in creating theERD(entity relation diagram ).
  • Generated the table scripts usingErwin.
  • Participated in and led requirements gathering sessions to determine Business requirements
  • Business rule flow diagram representation using UML techniques.
  • Writtenpl/sql packages ,Triggersandstored proceduresfor the application to be developed on the database side.
  • Normalizing the DBand Creatinglogical modelsforEDW
  • Using SQL Loader for populating static tables from CSV Files and VSAM files.
  • Involved inlogicalandphysicaldesign of thedatabaseusingERWin 7.1 version.
  • Involved in reverse engineering thedata modelas per the need usingErwin.
  • Extensively used Sql loader in loading the Files.
  • Usage of bulk collects in inserting huge sum of data in to the tables.
  • Developed build scripts for loading the above mentioned PLSQL routines into database.
  • Created global temporary tables in the package developed.
  • Used oracle inbuiltpackages, analytical, aggregate functions
  • Involved in Post production stabilization.
  • Created jobs on the Unix box and written shell scripts to execute the jobs
  • Created JIL scripts in Autosys.

Confidential, Atlanta, GAAUG 2006 to SEP 2007
Oracle Developer/Data modeler

Practice Management System and Claim Processing

The practice management software involves superbill processing, online appointment scheduling, patient demographic information maintenance etc. It is a web based portal that conveys information according to the role the user work in hospitals. It has well versed role base access and identity management system. The appointment booking module enables doctors to schedule/reschedule their appointment timings and the users to book their appointments online.

The Claim processing system is used for validating the data sent by doctors and to send valid claims to various insurance parties. This module incorporates all the state wise rules for insurance offices. It also incorporates various modes of sending claims like HCFA, UB 92 and EDI ASC X12 Standards.

Business Data Synchronization/ Data Manager/Data analyst
This system takes major responsibility of maintaining data consistency between the outsourced medical billing analysts and healthcare practices available in different geographical locations. It maintains data and structural consistency between heterogeneous databases. This system focuses on the fact that the servers that needs to be in data consistency need to be in online all the time. This synchronization process happens asynchronously by doing time sliced polling on the machines that needs synchronization .

Technologies: Oracle 9i, SQL, PLSQL, SQL Server, XSLT, Xpath, Shell Scripts, CRONTAB.

Development tools/methods:TOAD, CVS.

Responsibilities

  • Worked directly with user groups, management and other team members to analyze and evaluate requests, and write detailed description of user needs,
  • Developed all theOLTPbackend processing usingPLSQL packages and cursors.
  • Dealing with star schema to analyze the data as per the requirement.
  • Involved inData MappingforETLrequirements
  • Involved in design of master tables to store the business data.
  • Developed build scripts for building the PLSQL packages.
  • Created SQL script to create/drop database objects viz: tables, views, indexes, constraints, sequences and synonyms.
  • Developed SQL*Loader scripts to load the data from external files that is exported from SQL Server.
  • Wrote UNIX shell scripts to spawn the SQL*Loader job for daily load of data.
  • Wrote PLSQL ETL routines usingXML, XPath Queries,PLSQL Objects and bulk loads.
  • Involved in SQL performance tuning.
  • Data modeling as per customer requirements using Erwin tool
  • Handling high priority customer queries on the product.
  • Addressing enhancement request to the product.
  • Training new inductees on this product
  • Bug fix releases.
  • Create technical specification documentation.
  • Used TOAD extensively to develop backend packages, triggers and views to implement business logic.
  • Design, quality, SQL and PL/SQL reviews, making specific recommendations to enhance the performance of PL/SQL packages.
  • Analyzed the business requirements and Oracle database architecture (Erwin), translated these business requirements into functional specification and built a Workload Report Application to summarize employees’ workload Upgrade Accounting, Human Resources Databases, Performing tuning activities.

Hire Now