SUMMARY

• Around 10 years of experience as a Database Developer in Oracle 8i/9i/10g/11g(SQL & PL/SQL).
• Involved in all phases of the SDLC (Software Development Life Cycle) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Strong PL/SQL and SQL programming skills in database development life cycle.
• Strong in PL/SQL packages, functions, stored procedure, triggers and cursors .
• Proficient in advance features of Oracle 11g for PL/SQL programming like Records, Collections, Ref Cursors, Nested tables and Confidential SQL .
• Experienced in SQL and PL/SQL tuning and query optimization tools like SQL Trace and Explain Plan
• Extensively used   bulk collection   in PL/SQL objects for improving the performance
• Extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• Experience in creating Repository, Source systems, Target Databases and developing strategies for ETL mechanisms using Informatica.
• Worked extensively with Dimensional modeling, Data migration, Data cleansing, ETL Processes for data warehouses.
• Expertise knowledge in Dimensional Data Modeling, Star and Snow - Flake schema, creation of Fact and Dimension Tables, OLAP and OLTP
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Worked with version control tools like SUBVERSION and CVS.
• Experienced in working with business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements into functional and technical design specifications.
• Experience in working large Database environments and troubleshooting.

SKILLS:

Operating Systems: Windows 7,Windows XP, Windows 9x/2000/2003, Linux and UNIX.

RDBMS: Oracle 11g/10g/9i/8i,SQL Server 2000/7.0,Teradata v2r4/ v2r5

Tools: Informatica Power Center 8.1.2, SAS, TOAD,ERWIN and WINSCP

Data Warehousing: Data Mining, DataMart, OLAP, OLTP, SQL*Loader, Star/ Snowflake Schema Modeling, FACT and Dimension Tables

Programming: UNIX Shell Scripting, Perl, SQL, PL/SQL

Internet Tech : HTML(MS Front Page),DHTML,XML,Flash

Version Control: SUBVERSION, VSS and CVS

PROFESSIONAL EXPERIENCE

Confidential, TX

Sr.Software Engineer

Responsibilities:

• Co-ordinated with the front end design team and provided the necessary stored procedures and packages for TBS, SAM, NETPROV applications.
• Migrated legacy Confidential access circuits data into Verizon’s SNM systems.
• Extensively used REF Cursors for passing data between various modules and front end.
• Extensively used DBMS SCHEDULER to create, modify and maintain various jobs.
• Used Database triggers for making history of insertion, updating, deletion and all kind of Audit routines
• Extensively used the advanced features of PL/SQL like Subtypes, Records, Tables, Object types and Confidential SQL.
• Query Optimization and Performance tuning with extensive usage of index hints and force plans.
• Created sequences for automatic generation of unique keys to support Primary and Foreign Key constraints in data conversions.
• Worked in Production Support Environment as well as QA/TEST environments for projects, maintenance requests, bug fixes, enhancements, etc.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Automated multiple reports using UNIX/PERL scripting.
• Extensively used Microsoft Team Foundation Server for source code management and team collaboration. 
• Hands on experience with JIRA for defect and bug tracking.
• Took ownership of the IAM application and reduced the trouble tickets.

Environment: Oracle 11g, Toad 9, Windows 7, clear Quest, Microsoft TFS.

Confidential, TX

Sr.Database consultant

Responsibilities:

• Enhanced the current Confidential process to include new logic to identify and report Paid in Full Loans with Prior Cumulative balance.
• Created/modified various Packages, Stored Procedure and Functions as part of the data validation and cleansing process.  
• Used  Confidential  for better performance and easy retrieval of data, by reducing context switching between SQL and PL/SQL engines.
• Designed and Created Database objects and Written PL/SQL PROGRAMMING for data extraction and transformation.
• Analyzed and reconciled data from various data sources like Oracle databases, MS Excel and Flat Files and performed data attestation.
• Worked with Confidential SQL, Oracle Collections to deal with large and complex business process.

Environment: Oracle 11g, PL/SQL, Toad 9, Teradata 13.

Confidential, TX

Sr.Database consultant

Responsibilities:

• Designed and implemented the AGENT DESKTOP application to pull the loan history, attributes and status of the loan.
• Extensively involved in tuning the queries and applying hints for faster and better performance of the SQL queries.
• Handled errors using  Exception Handling  extensively for the ease of debugging and displaying the error messages in the application.
• Developed and supported Oracle based ETL & MIS processes and reports for Confidential External Treasury Reporting.
• Extensive use of XMLType data type for handling, extracting and manipulating XML data in the database.
• Developed Database Triggers for audit and validation purpose.

Environment: Oracle 10g, PL/SQL, XML, Toad 9, SQL Plus, Windows XP

Confidential, TN

Sr.Database consultant  

Responsibilities:

• Developed and executed detailed Design Plan and Code for Think FedEx First (TFF) application.
• Prepared and executed Unit test cases for Return To FedEx (RTF) application, Customer Service Innovation (CSI) application.
• Wrote SAS scripts to handle high volume data manipulation and loading to TeraData /Oracle database tables.
• Used SAS MACROS extensively to ease the process of coding and to standardize programs.
• Used SAS for pre-processing data, SQL queries, data analysis, generating reports, graphics, and statistical analyses.
• Converted ORACLE data tables into SAS data files using PROC SQL and uploaded SAS data files into ORACLE tables using SAS DBLOAD procedure.
• Used PERL CGI scripts for execution of SAS programs from a web interface.
• Converted different file formats (XML, XLS, and CSV) into Flat-files and loaded them into staging tables.
• Wrote wrapper Unix Shell scripts for execution of Sql,pl/sql and SAS scripts from UNIX.
• Scheduled tasks using CRONTAB.

Environment: Oracle 10g,Teradata, SAS 9,PERL,PL/SQL,Toad 9,Windows XP

Confidential, IL

Database consultant

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Performed data manipulation using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Maintained Shared Folders and Shortcuts, Repositories and User Security via Repository Manger
• Extracted data from Oracle then used SQL Server for data warehousing.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Expertise in UNIX Shell scripting for scheduling reports and setting up batch reports to make sure that data is in sync.

Environment: Oracle 10g, Informatica Power Center 8.1.2, Windows XP/NT

Confidential, OH

Database Consultant

Responsibilities:

• Worked with integrating around 8 Interfaces and worked very closely with the Interfaces team to resolve Data integration issues.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems (Flat files and Oracle) feeds using OWB, PL/SQL.
• Developed PERL scripts for Creating, Filtering, and Extracting and Modifying data.
• Developed PERL Scripts to get the processed and unprocessed records from the vendors and updated the interfaces database accordingly using DBI.
• Formatting the trace files with tkprof and interpreting the tkprof output.
• Developed Unix Shell Scripts to automate backend jobs, loading data into the Database using SQL* Loader.

Environment: Oracle 10g,PERL,PL/SQL, XML,Toad 9,SQL Loader,Windows XP

Confidential, IL

Database Developer

Responsibilities:

• Involved in writing complex queries to generate reports as per client request as a part of production support.
• Creating .dmp files using export/import utilities for transferring tables from one database to another.
• Automated/Scheduled jobs using Autosys.
• Distributed reports using DBI and NET::FTP. This involved dynamically creating SQL and interpreting results
• Extensively used PERL regular expressions for text processing and validation.

Environment: UNIX, PERL, PL/SQL, Oracle 10g, SQL Loader, Windows XP.