SUMMARY

• Over 8.5 Years of development experience as Senior PL/SQL Programmer Analyst/Lead, in Analysis, Design and Implementation of Business Applications using the Relational Database Management System (RDBMS).
• Extensive experience in all phases of SDLC (Software Development Life Cycle) from Requirements Level Estimation, Functional and Technical Systems Analysis, Design Level Estimation, Design, Implementation, Testing, and Maintenance using SQL/PLSQL (Oracle/DB2/Sybase), ETL (Homegrown ETL, IBM Datastage), XML, Oracle Reports & Forms, and Scripting - KIX(Windows Scripting) & Unix Scripting (sed, awk, perl), C++, Core Java, COBOL, Web Services.
• Experience with Data Flow diagrams, Database Normalization & De-normalization techniques, ER (Entity-Relational) modeling and design techniques, Dimensional Data modeling and design techniques.
• Expertise in understanding, re-writing, and writing of complex SQL queries - Hierarchical Queries, XML Query, Complex outer joins, Correlated Sub-queries, Hints for optimized data retrieval.
• Performance tuning of SQL, PLSQL code by indexing, using hints, or optimal re-write - by using Explain Plan, TKProf, and other performance analysis techniques.
• Effectively made use of Database Objects - Tables, Constraints, Indexes, Sequences, Triggers, Views.
• Used Database Links - to access data in other upstream/downstream applications, and to access work tables from QA to Production - which would be used for application maintenance, External Tables - to access data from the file system as relational data.
• Materialized Views - to replicate data in distributed environments.
• Complex Database Objects - Object Types, Object Tables, Functions, Stored Procedures, and Packages - to build client/server applications and batch processing.
• Bulk Data load using - SQL Loader utility.
• Expertise in creating Rule Engine Based Design/Implementation - using Dynamic SQL.
• Experience with Oracle Provided packages - UTL FILE, UTL HTTP, UTL SMTP, DBMS OUTPUT, DBMS SQL, DBMS LOB.
• Partitioning to maintain large database tables - Range partitioning, List Partitioning.
• Used PL/SQL looping features - with Ref Cursors, External Cursors Bulk Collect, Collections, and Record types.
• Exception Handling - Efficient exception handling for all the applications designed, which helps in Control and Error Reporting.
• Experience with Data-warehousing Concepts - Data Analysis, Data Profiling, Master Data Management, Data Cleansing, Data Transformation, Loading, Data Mart design.
• Experience with Dimensional Modeling – Dimension tables, Fact tables, Star Schema, Snowflake Schema.
• Expertise in Unix Scripting (used sed, awk and perl) – developed scripts - for complex text manipulation, for database interactions, creating complex batch programs, environment set up scripting, complex search scripts, complex compare scripts, complex parallel processors and handlers, directory and file management scripts, complex self-healing & fail-safe programs, file transfers scripts, schedulers scripts.
• Oracle Reports – Developed several reports ( Confidential -least over 60 new reports, many other enhancements) using the oracle reports, which are used for business decision making.
• Oracle Forms – Used Oracle Forms Builder to analyze the Application Front End which was built on Oracle Forms.
• Experience in KIX Windows Scripting – Developed many KIX scripts – to read, create, manipulate MS excel spread sheets, load data from/to excel to/from database, text manipulation, call datastage jobs.
• Expertise with Object oriented design, good experience in C++ & Core Java Programming.
• Web Service - Experience using WSDL, creating web service soap request and handling web service soap response.
• COBOL – Analyzed the application code, and mainly for reverse-engineering to document the legacy application code (which was used to understand functionality, migrate the legacy code to PL/SQL code).
• IBM Datastage Designer – Expertise in creation of Server and Parallel Jobs and their configuration settings, Data Sources – File (Sequential file, Complex file, Data set), Database Objects; Sequencer Stage – Exception Handler, Looping, Command Execution, User Variables Processing Stages – Transformer stage, Lookup stage, Merge stage, Funnel stage, Filter stage, Join stage, Modify stage, Remove Duplicates stage, Sort stage, Slowly Changing Dimension stage.
• Executed software projects for Financial Sector – Group Insurance Industry, and Telecom Industry.
• Personality Traits: Highly Motivated, Strong Logical/Analytical Thinking, Quick Learner, Lucid Communication, Excellent Interpersonal Skills, Team Player, Lead by Example, Project First Team First Attitude, Well Planned, Excellent Aptitude to learn new technologies and applications on job.

TECHNICAL SKILLS

RDBMS: Oracle 10g/11g, DB2 9, Sybase 15

ETL Tools: IBM Datastage 8.5, SQL*Loader

Reporting Tools: Oracle Reports

Languages/Utilities: SQL, PL/SQL, Unix Scriping (with Sed, Awk, Perl), Kix Windows Scripting, C++, Pro*C, Visual C++, Core Java

Schedulers: Unix Crontab, CA Workload Center Autosys

Operating Systems: UNIX (Sun Solaris, HP Unix, AIX), Windows NT/98/95/2000 & Windows Development Tools Oracle SQL Developer, SQLPLUS, Toad

Other Tools: PVCS Version Manager, HP ALM (Application Lifecycle Manager)

Process: Waterfall Model, Agile Development

PROFESSIONAL EXPERIENCE

Confidential, New Jersey

Tech Lead/Senior Analyst Developer

Environment: Sun Solaris, Windows, Oracle 10g, SQL, PLSQL, Unix Scripting, ETL, IBM Data Stage V8.5, Oracle Reports 10g, Oracle Forms 10g, COBOL, KIX Scripting, Web Services

Responsibilities:

• Created PL/SQL Coding Standards and Best Practices, used by the development team-members.
• Created exception handling and error reporting standard, which is followed for all pl/sql development by the application.
• Developed many generic re-usable parametrized modules, such as Generic script to trigger oracle reports, and transfer the pdfs to share drive, Generic script to run complex and data intensive sqls by breaking them into ranges, and spawning batches of processes, and handling them, 3. Generic Code Builder which would identify DMLs from a file, and create the run DMLs and the corresponding back-out DMLs, 4. Created a generic XML generation module which would generate XMLs based on the ER Map Setup, using Oracle XML Query, 5. Generic get procedures to get the application data, by passing the key populated structure (which would have both key and value attributes), the procedure would populate the structure with data attributes for the provided key, 6. Generic Datastage ETL Jobs which can be re-used across different application jobs, 7. Reusable KIX Windows scripts – for Reading & Modifying Excel Spread Sheets, 8. Standard SQL Code which can be reused by other developers.
• Developed Unix Script (including sed, awk, and Perl), Kix Windows Script, PL/SQL, SQL Performance Tuning, and Oracle Reports.
• Developed scripts to generate test data for unit testing.
• Delivered Several Projects – with zero UAT/Production defects, with very minimal - close to zero QA defects, on time.
• Tuned Several Complex SQL Queries – improved performance, by reducing time between 50% up to 5%.
• Developed several re-usable SQL queries – which are used by many developers in their code.
• Developed several generic UNIX scripts, pl/sql, datastage modules – which reduced development time, hence cost.
• Value Adds such as i) Code Generation for several frequent haste requests – which prevented allocation of many developers to perform coding and testing in short time, instead was achieved by allocating 1 developer to run the automated script and unit test the generated code, this resulted in a quantifiable saving for the client. ii) Streamlined in-consistent logic, by analysis and business buy in – which created consistency across different modules, which was appreciated by the client. iii) Created generic process for parallel execution and handling of complex and voluminous data queries, which saved lot of time, and also provided team with a process for re-use – hence creating consistent, and efficient way of handling voluminous data queries.
• Guided team as project lead: Accomplished many projects on time with high quality, robust, and reusable application modules which is appreciated by the client – Received Service Excellence Award.

Confidential

Sr. ETL Database Analyst Developer, Project Lead

Environment: Sun Solaris, Windows, DB2, SQL, PLSQL, UNIX Scripting, ETL, Crystal Report

Responsibilities:

• Developed ETL Frameworks, such as Generic Loader Framework which was developed mainly in UNIX & Awk scripting for reformatting data into standard format, and load data into database staging tables using the DB2 load utility. Generic Validation & Stage Framework which would trigger the complex pl/sql procedures to perform data validations – i. validations based on the requirements, ii. to validate the data against the data already present in the database (partial refresh), identify and load the change records to the active dimension tables, move the old data to history tables. Generic Aggregation Framework which would aggregate the data Confidential the level and load the aggregated data to the fact tables. Created Reporting Framework – which creates the control and error reports using the process, staging & dimensions tables.
• Developed Complex UNIX & Awk Scripts (including sed, awk, Perl), PL/SQL, SQL Performance Tuning, SQL Reports.
• Developed scripts to generate test data for unit testing.
• Code Reviews -
• Performed Code reviews – to identify missed requirements, check on coding standards, exception handling, cover all scenarios, scheduling, performance issues, other application impacts.
• Identified and fixed issues during code review stage, which prevented issues slipping into QA.
• QA Support & Production Support – Root Cause Analysis on the issues reported, code changes/fixes, impact analysis, work around until code changes.

Confidential

Sr. PL/SQL, UNIX Analyst Developer, Module Lead

Environment: SunOS 8, Windows NT, VB.Net, Korn Shell scripts, Sybase 15, Crystal Report, Java

Responsibilities:

• Delivered Several Projects – with minimal UAT/Production defects, with very minimal - close to zero QA defects, on time.
• Tuned Several Complex SQL Queries – improved performance, by reducing time between 50% up to 5%.
• Developed several re-usable SQL queries – which are used by many developers in their code.
• Developed several generic UNIX scripts, pl/sql modules – which reduced development time, hence cost.
• Value Adds such as i) Automated Reporting Tool – which saved licensing cost for the client ii) Claims Creation and Completion Process – efficient pl/sql code with turn-around time well within the SLAs considering the complexity of the processes, ii) Absence Management Process – efficient pl/sql code with turn-around time well within the SLAs considering the complexity of the processes, iii) Output Comparison Tool – saved lot of time by avoiding manual comparison of the test results, for systems streamlining projects, iv) Documentum Conversion – High data volume handled efficiently considering the volume of data validated and loaded.

Confidential

Environment: UNIX, C, C++, Clearcase, ORACLE, DEC Message Queue.

Responsibilities:

• ITB is the team involved in the enhancements of the application following the processes stipulated in the Project Plan
• Contributing in Analysis, Design, and Coding and Unit Testing phases of SDLC.
• Responsible for Analyzing the existing system and the feasibility of incorporating the new functionality in the existing system
• Utilize Technical knowledge of C, C++, Shell Scripting, PL/SQL, pro * C to develop the efficient code for the project, following all CMM level 5 standards
• Designed Pro*C method 4 for one of the project.
• Enhanced many applications which had complex C++, Pro*C, SQL Code.
• Prepare the process deliverables and participate in process review meetings and prepare Defects sheet, which comprise of all the defects, which is generated during the design, development & testing phase of the project.
• Working on Message queues like DMQ, MQ series etc.
• One of the senior application developer in the team – provided Object Oriented Design.
• Created servers to handle the customer information for VOIP (Voice over IP), IP Toll Free service, MNS (Managed Network Services), MIS (Managed Internet Service etc.).
• In RTB (Run the business)
• The RTB, Run the Business group is involved in production support in interface with Managed Operations team and troubleshooting the CADM Applications and databases.
• Coordinate with Resources from different interfacing applications as well as the client to identify and solve issues in the Production Environment
• Handling the production problems of CADM MIDDLEWARE Sub Application and LGW (Legacy Gateway) Sub Application.
• Data Fixes – Analyzing the data and designing the solution to correct corrupted data.
• Code Fixes – Identified complex C++, SQL, PLQL issues, and provided work-arounds and permanent fixes.