SUMMARY:

• Around10yearsof experience as aDatabase DeveloperinOracle8i/9i/10g/11g(SQL & PL/SQL).
• Involved in all phases of theSDLC (Software Development Life Cycle)from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• StrongPL/SQLandSQLprogramming skills in database developmentlife cycle.
• Strong inPL/SQLpackages,functions,storedprocedure,triggersandcursors.
• Proficient in advance features of Oracle 11g for PL/SQL programming likeRecords, Collections, RefCursors, Nested tablesandDynamic SQL.
• Experienced in SQL and PL/SQL tuning and query optimization tools likeSQL TraceandExplain Plan
• Extensively usedbulk collectionin PL/SQL objects for improving the performance
• Extensively worked in developing ETL program for supportingData Extraction,transformationsandloadingusingInformatica Power Center.
• Experience in creating Repository, Source systems, Target Databases and developing strategies for ETL mechanisms usingInformatica.
• Worked extensively withDimensional modeling, Data migration, Datacleansing, ETL Processesfor data warehouses.
• Expertise knowledge in Dimensional Data Modeling, Star andSnow - Flakeschema, creation ofFact and Dimension Tables, OLAP andOLTP
• CreatedUNIX shell scriptsto run theInformatica workflowsand controlling the ETL flow.
• Worked with version control tools likeSUBVERSION and CVS.
• Experienced inworkingwith business users, business analysts, IT leads and developers in analyzing business requirements and translating requirements intofunctionalandtechnicaldesign specifications.
• Experienceinworkinglarge Databaseenvironmentsandtroubleshooting.

SKILL:

Operating Systems: Windows 7,WindowsXP,Windows9x/2000/2003, Linux and UNIX.

RDBMS: Oracle11g/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 SchemaModeling,FACTand 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 packagesforTBS,SAM,NETPROVapplications.
• MigratedlegacyXOaccess circuits data intoVerizon’sSNM systems.
• Extensively usedREF Cursorsfor passing data between various modules and front end.
• Extensively usedDBMS SCHEDULERto create, modify and maintain various jobs.
• UsedDatabase triggersfor making history of insertion, updating, deletion and all kind of Audit routines
• Extensively used the advanced features ofPL/SQLlike Subtypes, Records, Tables, Object types and Dynamic SQL.
• Query Optimization and Performance tuning with extensive usage ofindex hints and force plans.
• Created sequences for automatic generation of unique keys to supportPrimary and Foreign Keyconstraints 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 andmaterialized viewsfor remote instances.
• Automated multiple reports usingUNIX/PERLscripting.
• ExtensivelyusedMicrosoft Team Foundation Serverfor source code management and team collaboration.
• Hands on experience withJIRAfor defect and bug tracking.
• Took ownership of theIAMapplication andreduced the trouble tickets.

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

Confidential, TX

Sr. Database consultant

Responsibilities:

• Enhanced the current LRA 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.
• UsedBulk Collectionsforbetter performanceand easy retrieval of data, by reducing context switching betweenSQLandPL/SQLengines.
• 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 withdynamic SQL, Oracle Collectionsto 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 theAGENT DESKTOPapplication to pull the loanhistory, 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 usingException Handlingextensively 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.
• ExtensiveuseofXMLTypedata typeforhandling, extractingand manipulating XML data in the database.
• Developed Database Triggers for audit and validation purpose.

Environment: Oracle10g,PL/SQL, XML, Toad 9, SQL Plus, Windows XP

Confidential, TN

Sr.Database consultant

Responsibilities:

• Developed and executed detailed Design Plan and Code forThinkFedExFirst(TFF) application.
• Prepared and executedUnit test casesforReturn ToFedEx(RTF) application,Customer Service Innovation(CSI)application.
• Wrote SAS scripts to handle high volume data manipulation and loading to TeraData /Oracle database tables.
• UsedSASMACROSextensively 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.
• ConvertedORACLEdata tables intoSAS data filesusingPROC SQLand uploaded SAS data files into ORACLE tables using SASDBLOADprocedure.
• UsedPERL CGIscripts for execution of SAS programs from a web interface.
• Converted differentfile formats(XML, XLS, and CSV) into Flat-files and loadedthem into staging tables.
• Wrote wrapperUnix Shell scriptsfor execution of Sql,pl/sql and SAS scripts fromUNIX.
• Scheduled tasks usingCRONTAB.

Environment: Oracle10g,Teradata,SAS9,PERL,PL/SQL,Toad9,Windows XP

Confidential, IL

Database consultant

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• UsedInformatica Power Centerfor (ETL) extraction, transformation and loading data from heterogeneoussource systemsintotarget database.
• DevelopedInformatica MappingsandReusable Transformationsto 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 likeFilter, Expression, Lookup(Connected and Un-Connected), Aggregate,Update Strategy, Normalizer, Joiner, Router, SorterandUnion.
• Maintained Shared Folders and Shortcuts, Repositories and User Security viaRepository 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.
• Useddebuggerin identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Expertise inUNIXShell scripting for scheduling reports and setting up batch reports to make sure that data is in sync.

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

Confidential, OH

Database Consultant

Responsibilities:

• Worked with integrating around8 Interfacesand worked very closely with theInterfaces teamto resolveData 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 usingOWB, PL/SQL.
• DevelopedPERLscripts for Creating, Filtering, and Extracting and Modifying data.
• DevelopedPERLScripts to get the processed and unprocessed records from the vendors and updated the interfaces database accordingly usingDBI.
• Formatting thetrace files with tkprof and interpreting the tkprof output.
• DevelopedUnix Shell Scriptsto automatebackend jobs, loading data into the Database using SQL* Loader.

Environment: Oracle 10g,PERL,PL/SQL, XML,Toad9,SQLLoader,Windows XP

Confidential, IL

Database Developer

Responsibilities:

• Involved in writing complex queries to generate reports as per client request as a part ofproduction support.
• Creating .dmp files usingexport/import utilitiesfor transferring tables from one database to another.
• Automated/Scheduled jobs usingAutosys.
• Distributed reports usingDBIandNET::FTP.This involved dynamically creating SQL and interpreting results
• Extensively usedPERLregular expressions for text processing and validation.

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