Sr program Analyst Resume
Kansacity, MO
- 7+ years of result oriented professional experience in the analysis, design and development of database applications.
- Experience in developing applications PL/SQL Cursors, 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 like SQL*Loader, Import and Export.
- Experienced in performance tuning of the database using partitioning, Explain plan, SQL TRACE
- Hands on experience in creating performance benchmarks and generating SQL*Plus reports.
- Proficient knowledge in creation of database objects like tables, views, synonyms, sequences, Indexes, Triggers, Table partitions, Sub-partitioning, Database links etc.
- Extensive experience in using PLSQL 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 using Export, Import and SQL*Loader and worked on External tables and Transportable table spaces.
- Excellent experience in ERWIN Data Modeling Tool.
- Experience in working on both OLTP and OLAP databases.
- 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 writing PL/SQL ETL routines in data warehousing applications.
- Knowledge of PLSQL 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.
- Creation of database objects like Tables, Views, Synonyms, Sequences, Indexes, Triggers, Table Partitions, Database links etc.
- PL/SQL Programming using packages, procedures, functions, Object Types, Collections, Cursors and Text APIs.
- Writing ETL Routines and programs using Materialized Views.
- Bulk Load techniques using Bulk Collect and FORALL.
- Hands on Experience in using ORACLE HINTS.
- Oracle Import/Export Utilities and SQL*Loader
- Knowledge of autonomous transactions, Oracle Advanced Queuing and Oracle Parallel Queries.
- Generation of SQL*Plus Reports.
- Analyze and gather table statistics for query optimization and creating performance benchmarks.
- Extensive Experience in Oracle BI Tools like Discoverer.
- Knowledge on OWB environment
- Handling XML data in Oracle using XML Type, XPath and XPointers.
- ERWIN Data modeling tool.
- Oracle Development tools like TOAD, Oracle SQL Developer etc.
TECHNICAL SKILLS
RDBMSORACLE 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, CA Sep2012 till date
Sr Program 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 support Sales Audit Applicaion and Point 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 of customization , data fixes, code fixes, performance tuning and other bottlenecks of the queries request logged against the application by the Business User.
- In addition to that, we are also responsible for all Enhancement work related to Pos Sales Audit Applicaion ReconNET and AJB Credit Settlement Applications.
- This project includes Process Monotoring , Schedular and runnig back jobs through application, UI Development, Integration of code with existing system, PL/SQL work like create or update procedure, functions or execution of query to generate reports.
- We do follow the complete SDLC in our all Enhancement/Development projects.
- For development of the code we are mainly using tools like TOAD and some other integrated application software like Export Builder for Sales Audit and POS modules.
- The application is built and deployed in UNIX and NT environments
- 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, MO MAY2012 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, Functions and procedures for implementing the complex database intensive business rules Developed.
- Extensively used REF CURSORS for data exchange between java platform and database.
- Creating Stored Program Units in the Form of Packages, Functions and procedures for implementing the complex database intensive business rules.
- Developed performance benchmark scripts.
- Developed the data load layer using Bulk Collect technology involving Oracle PLSQL Collections.
- Extensively used REF CURSORS for data exchange between java platform and database.
- Creating Stored Program Units in the Form of Packages, Functions and procedures for implementing the complex database intensive business rules.
- Developed performance benchmark scripts.
- Developed the data load layer using Bulk Collect technology involving Oracle PLSQL Collections.
- Experience in working on both OLTP and OLAP databases.
- 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 using XMLDB , 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 CA JUN2011-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 developing logical data models and physical database design and generating database schemas using ERwin.
- Performing conceptual data modeling, data analysis, data profiling, data mapping and ETL implementation for product integration with client\'s applications.
- Database Backend Developer responsible for creating and managing PLSQL packages used by Front end applications as well as batch applications.
- Wrote Stored Procedures, Functions, Packages and triggers using PL/SQL to 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 using ERwin index editor to update, modify existing indexes, and ERwin physical object editor to update, enlarge existing tables, tablespaces and segments.
- Experience using ERwin entity-attribute editor and ERwin relationship definition editor to modify, update existing primary, foreign, alternate keys and identifying, non-identifying, recursive and subtype relationships.
- Experience using ERwin synchronization 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 used REFCURSORS for data exchange between java platform and database
- Involved in writing complex queries using joins and Analytical 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, CA AUG 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.
- Used TOAD extensively to develop backend packages, triggers and views to implement business logic.
- Designed the business logic using UML
- Heavily involved with the Logical and Physical Design of the Database using ERWIN.
- Developed data models and ETL data mapping for application.
- Participated in and led requirements gathering sessions to determine data and reporting requirements for a 20 TB data warehousing project 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 the ERD (entity relation diagram ).
- Generated the table scripts using Erwin.
- Business user interactions to design the database as per the business rule flows
- Business rule flow diagram representation using UML techniques.
- Written stored procedures for 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 using ERWin 7.1 version.
- Involved in reverse engineering the data model as per the need using Erwin.
- 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 in Normalization & De-normalization of Database.
- Extensively worked in tuning the Materialized Views
- Perform Source-to-Target Data Mapping.
- Create Data Flow/data Lineage Diagrams (DFD/DLD) to depict the source-to-Target Mapping and Data Lineage Analysis.
- Source to Target mapping using mapping techniquesin Informatica
- 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, TX OCT 2007 to JUL 2008
Database programmer
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 in COBOL, Reverse Engineered the application to Oracle.
- Reviewed logical data model, physical data model, data mapping and ETL design
- Involved in creating the ERD (entity relation diagram ).
- Generated the table scripts using Erwin.
- Participated in and led requirements gathering sessions to determine Business requirements
- Business rule flow diagram representation using UML techniques.
- Written pl/sql packages ,Triggers and stored procedures for the application to be developed on the database side.
- Normalizing the DB and Creating logical models for EDW
- Using SQL Loader for populating static tables from CSV Files and VSAM files.
- Involved in logical and physical design of the database using ERWin 7.1 version.
- Involved in reverse engineering the data model as per the need using Erwin.
- 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 inbuilt packages, 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, GA AUG 2006 to SEP 2007
Oracle Developer/Data modeler
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 the OLTP backend processing using PLSQL packages and cursors.
- Dealing with star schema to analyze the data as per the requirement.
- Involved in Data Mapping for ETL requirements
- 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 using XML, 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.