Sr SAS Developer & Analyst

Venkatesh Muthukumar

Email: *******@*****.***

Phone: 614-***-****

PROFESSIONAL SUMMARY

· 9 Years of experience in software design, development, implementation, and testing

· Full life cycle Software Application Developments, Including Analysis, Requirements Gathering, Design, Development, Implementation, Maintenance and Enhancements.

· Strong experience with databases, including Oracle, SQL Server, DB2, Siebel and Sybase.

· Served as Technical lead and involved in project planning, resource allocation, calculating estimates for the defined scope of work, identifying and mitigating project risks.

· Involved in the coordination with QA team, scheduling rollouts, analyzing and fixing production issues.

· Expertise in data analysis, database design, data management, logical and physical data modeling.

· Experience in system analysis, business, functional, technical requirements gathering, translating to design, system/data architect, data model, prototype, application development, quality control, software distribution, deployment, and production support.

· Good knowledge and extensive experience in PL/SQL such as developing Functions, Database Triggers, Stored Procedures and Packages.

· Good knowledge and experience in database Tuning.

· Experience in server-side programming in Sybase and Oracle.

· Experienced in writing UNIX Shell Scripts, Perl Scripts batch files

· Experience in working in Agile environment

EDUCATION

Masters in Computer Science, Franklin University, OH

Certification

Oracle Certified – Oracle Certified Associate (OCA)

· Oracle Database 11g: SQL Fundamentals I

· Program with PL/SQL

TECHNCAL SKILLS

Programming Languages PL/SQL, SQL, Java 1.2/1.3/1.4, J2EE 1.2/1.3,JSP, PERL, C, Shell Scripts, HTML, COBOL, JCL, ASP,Korn Shell

Operating Systems Windows NT/95/98/2000/XP, Linux, Unix

Databases SQL Server, MS Access, MySQL, Oracle, Sybase and DB2, MS Dos

Tools Used SQL Loader, SQL Navigator, TOAD, CA7, PL/SQL Developer, Embarcadero, DB Ignite, Quality Center, Service Center, ERWIN, VISIO, Oracle Reports, Oracle Designer 2000, Xpeditor, File-Aid, Oracle Forms.

Web Servers Apache, Tomcat, Microsoft IIS 4.0, Java Web Server, IBM HTTP server.

Middleware MQ Series / WebSphere MQ.

Version Control Tools CVS, Clear Case, Visual Source Safe 6.0, PVCS, Sub-Version

PYRAMID August 2008 - present

Senior Database Developer

Client: Nationwide Better Health

Working as a senior developer to maintain the exisisting disablity clients and implement new clients. PYRAMID is a disblity management application which provides employee disablity solutions to our customers. There are over 20 clients to whom employee disablity services is being provided using PYRAMID. Claims processed in PYRAMID have to be sent to centralized data hub for processing and returned back to PYRAMID.

Responsibilities:

· Served as the Technical lead in the project and involved in the project planning meetings, analysis, design, development and production support.

· Coordinated with the Buisness Analysts and the Data Management team to process application data.

· Involved in providing time estimation for the defined scope of the projects.

· Used SQL PLUS and SQL LOADER to develop scripts to load data in flat file format, from the data management team.

· Involved in implementing new disability clients which involves creating the load scripts to load the data which is received from the data hub team to the staging tables and then loading them to the application tables.

· Developed data load scripts using SQL and UNIX.

· Analysed the errored data and moved it back to appropriate tables.

· Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data.

· Involved in coding shell scripts to run sql scripts.

· Tuned queries using EXPLAIN plan, SQL Trace, Oracle Hints, Optimizers and Indexes for better query performance.

· Developed monthly reports in SQL for upper management

· Developed Ad-Hoc reports and Advise to Pay reports for customers depending on the requirements.

· Involved in solving day to day production issues and cordinating with the Business Analysts and Data hub teams.

· Maintained the developed code using Sub-Version

Environment: UNIX, Oracle 9i, PL/SQL, SQL, PL/SQL Developer, Quality Center, SQLPLUS, SQL LOADER, ACCESS, Sub-Version

VIEWS, NRS, PENSIONS

Senior Database Developer, July 2006 – August 2008

Client: Nationwide Insurance

Involved in development and support of 14 aapplications of Nationwide Financials, which involved applications both in house and vendors. Responsible for incident tickets opened for all the 14 applications, making sure the problem is fixed depending upon the priority of the incident. Involved extensive trouble shooting and coding to fix the defects in the system based on the priority of the incident.

Responsibilities:

.

· Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data.

· Provided suitable access to users in the database depending upon their job functions

· Developed Shell Scripts for scheduling start up and shut down of systems.

· Created ad-hoc reports depending on the requirements given by business analysts.

· Created Views and Materialized Views on the tables for data extraction and restricting the users from entire data access.

· Used Export and Import to transport data from the production to accounting databases.

· Monitored and maintained the table space growth, which was created by the DBA’s.

· Worked with the vendor companies to get the data processed if the jobs failed which involved trouble shooting the system in our side.

· Worked on the tickets opened by users for Id locking, batch failures, login problems into the system which involves remotely logging in to their system and trouble shooting or working with them directly.

· Worked with buisness directly in troubleshooting system issues

· Monitored job flows and worked on abended jobs

Environment: UNIX, Oracle 9i, Sybase, PL/SQL, SQL, Embarcadero, Quality Center, Peregrine, Sub-Version

VISION

Software Engineer April 2005 – June 2006

Client: Verizon Wireless

VISION is an online billing system developed for Verizon Wireless to provide comprehensive billing solutions for Verizon Wireless customers. VISION was a billing system with Oracle 9i database and DB2 database. CICS and JAVA was used to develop the front-end screens. VISION keeps track of both personal and business accounts, call records, call charges, message charges. Created tables for both business and personal accounts and maintained them. Used Oracle Reports to generate reports.

Responsibilities:

· Involved in Database design according to the requirements gathered from the business side.

· Involved in designing the Entity relationship diagram (ERD) for the database

· Developed code using SQL and PL/SQL.

· Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data from data-mart based on specifications given by the accounting team.

· Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.

· Developed Views to enhance user restrictions.

· Involved in generating reports using Oracle Reports according to the request from upper management.

· Involved in technical documentation for the applications

· Used Unix KORN Shell Scripting for running nightly and monthly jobs.

· Involved in coding JCL’s to set up rating legs for different regions of the market

· Involved in running the rating jobs in CA7 to rate the calls made by the customers.

· Involved in creating VISION accounts to incoming requests from the testing teams and also from the development teams.

· Provided technical support for the testing teams, responding to their data requests, ID’s request.

Environment: UNIX, Oracle 9i, DB2, COBOL, CICS, JCL, PL/SQL, TOAD, File-Aid, CA7, Quality Center, VISIO, SDSF.

Insurance Accounting Planning System

Senior Developer Jan 2004 to Mar 2005

Client: Farmers Insurance Group

The main function of IAPS 6.2 version was to create an interface the Insurance and the accounting regions. I was involved in the design and development of various Journal entries to be transmitted to oracle EFFS database. Created the tables for the IAPS which where stored in the accounting departments data-mart that acts as a repository for all financial impromptu reports. Designed and developed different financial and budget impromptu reports using result set data from Oracle stored procedures. Impromptu reports are designed as per the specifications. Reports where developed and designed using PL/SQL. Also involved in enhancement to the existing IAPS interface to accounting regions. Wrote test protocols for QA team to the test the financial functionality. Involved in documentation of all software functional and design specification according to FDA regulations.

Responsibilities:

· Actively involved in gathering the business requirements from the service center.

· Designed the work flow diagram using VISIO

· Involved in design of MAPS system using ERWIN designer tool.

· Involved in analyzing the Change requests to add new features

· Involved in analyzing the existing functionality of the system

· Created the tables for IAPS system.

· Developed coding using SQL and PL/SQL.

· Created PL/SQL Procedures, Functions, Packages and Triggers for data validation, data updating and retrieving of data from data-mart based on specifications given by the accounting team.

· Involved in database tuning using Oracle Hints, Optimizers and Indexes for better query performance.

· Created Views and Materialized Views on the tables for data extraction and restricting the users from entire data access.

· Used Unix KORN Shell Scripting for running nightly and monthly jobs.

· Used utility package for moving the data from tables into flat files.

· Used SQL Loader to load data from flat files.

· Used Export and Import to transport data from the production to accounting databases.

· Debugged the developed code using XPEDITOR

· Involved in writing PERL Scripts for the run the jobs and output them to appropriate locations

Environment: Oracle 9i (9.2), SQL, PL/SQL, UNIX KORN Shell Scripting, ERWIN and Toad.

Customer Value Management

Oracle PL/SQL Developer Dec 2002 – Dec 2003

Client: Nationwide Federal Credit Union

As a part of information delivery team within small business financial services, successfully participated in various projects involving data analysis and delivery. Designed and implemented tables and reports for various releases of a web based customer relationship management tool decision engine, used by relationship managers within the bank to touch the customer with appropriate solutions. Created processes, templates and system checks to maintain high quality implementation of projects. Provided extensive support and analysis to business initiatives. Partnered with other technology and business teams to successfully plan on the projects spanning across various platforms. Created programs to generate specific marketing lists, based on business plans used by CRM tools.

Responsibilities:

· Implementation and development of Customer Value Management using Oracle 9i database.

· Participated in data analysis and user requirements sessions.

· Involved in designing the system using ERWIN designer tool.

· Created database tables, indexes, objects and synonyms.

· Developed PL/SQL functions, procedures, triggers and packages for processing the data in the data warehouse as per the specifications given by the marketing team.

· Wrote SQL queries for coding within PL/SQL programs.

· Involved in database tuning by changing the execution plan of queries using Oracle hints, by creating Indexes on the tables and by using different optimizers based on the queries.

· Used SQL Loader to load data from flat files into tables.

· Used built in package utility for converting the data in tables into flat files.

· Created Views and Materialized Views on the tables for extracting of data from a table or two different tables to avoid complex joins and querying.

· Was involved in testing of Stored Procedures, Functions, Packages and Views.

· Used UNIX Shell Scripts to run nightly and monthly jobs.

· Wrote technical specifications.

· Involved in developing project help support documentation.

Environment: Oracle 8i(8.15), SQL, PL/SQL, UNIX KORN Shell Scripting, ERWIN and Toad

Order Processing System

Software Programmer Jul 2001 – Nov 2002

Client - MBDL, (P) Ltd, Chennai, India

This Customer Support and Billing (CSB) were developed in UNIX, Oracle 8i, PL/SQL and Developer 2000 to facilitate routine activities. CSB is the customer-based billing engine. The activities performed were to increase the ability to store more detailed information about customers and their accounts, the ability to positively identify each person on an account when more that one person is listed, The ability to bill for non-energy products and services, Custom pricing abilities.

Responsibilities:

· Worked on analysis, design of the Order Processing System.

· Created tables for the system in Oracle 8i.

· Involved in coding using SQL queries.

· Wrote SQL queries to retrieve and access data from MS Access.

· Developed the test documentation for the testing team based on the specifications of the system.

· Developed supporting documentation and help system.

· Involved in reviewing of project specifications.

· Involved in customer support.

Environment: Oracle 8.0.5,8i, SYBASE, PL/SQL, SQL Plus, TOAD, Windows 2000 and UNIX

Contact this candidate