SUMMARY

• Over 12+ years of IT experience in System Analysis, Design, Support, Maintenance, Testing and Development of various systems using various Databases - Oracle, Sybase, SQL Server and DW/BI-Informatica technologies.
• Good team player as Lead/Developer/Data Analyst/Developer/Data Architect.
• Experience in all phases of the project life cycle (SDLC) like Agile/waterfall development methodologies.
• Expertise in oracle data pump - expdp, impdp, export, import and SQL*Loader utilities.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Relational database Schemas in dimensional and multidimensional modeling.
• Experienced in writing UNIX shell scripts, SQL*Loader, Database Performance and Tuning.
• Proficient in SQL, PL/SQL, Procedures/Functions and Packages.
• Hands on experience on Relational, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Expertise in Data Integration, Data Quality, Data Conversion, Data Distribution and Data Summarization from single to multiple Legacy Source / Downstream System / Process.
• Experience in performance tuning of sources, mappings, targets and sessions.
• Experienced in OLTP/OLAP tools using Hyperion, Cognos and BOXI reports.
• Experience in Informatica Power Center/Power Exchange on Client/Server environment.
• Good Experience TSQL/NZSQL Scripts.
• Excellent Experience to handle critical data disasters and recovery.
• Experienced in communicating wif Business partners.
• Excellent communication and interpersonal skills.
• Experience in Offshore, Onsite project models
• Experience in handling multiple projects at same time.
• Experience in Release/Change/Configuration Management processes.
• Ability to work TEMPeffectively as a Team Leader/Member as well as individually.

TECHNICAL SKILLS

Operating Systems: Linux, UNIX, windows 95/98/NT 4.0/XP

Languages: SQL, PL/SQL, T-SQL, Shell Scripting, HTML, XML

RDBMS: Oracle10g/11g, SQL Server, Netezza, Sybase, DB2

Administration Utilities: Export, Import, Data Pump SQL*Loader, NZload, NZsql, NZadmin

Tools: Informatica, TOAD, Optim, PowerShell,Control-M, Autosys, Quality Center, Crystal Reports, Hyperion Essbase, Hyperion Planning, Erwin, Visio, Microsoft VSS6.0, Ab initio, WinSQL, Forms, Reports, V.B6.0, CVS, Eclipse, Aginity Netezza Workbench

Web Related: VBscript, SOAP, IIS4.0, Web Logic, XSL, Java, WSDL

Domain Knowledge: Finance, Trading, Compliance, Risk, Telecom, Health Care Manufacturing, and Enterprise Performance Management.

PROFESSIONAL EXPERIENCE

Confidential, VA

Sr.PL/SQL Developer

Responsibilities:

• Worked on PL/SQL stored procedures (procedures, functions, packages, triggers, views, MVs and other database objects).
• Developed queries for weekly/monthly reports and adhoc reports (SQL or PL/SQL scripts running in Unix System) to extract data from database.
• Worked on Production issues: debugging and fixing errors, tuning SQL queries, checking indexes usage.
• Worked on Database bookmarks and DB restore using Delphix application.
• Worked wif TIBCO administrators to setup HAWK monitoring rules for Inbound and Outbound endpoint URL’s EDI,eServicing and SLA applications.
• Worked on PL/SQL performance tuning of stored procedures and tables for better performance on reporting and updates.

Environment: Oracle 11g (SQL, PL/SQL), TOAD, Delphix, Unix, JIRA, SOAP, WSDL, TIBCO, GEMS, XML, Autosys, Visio, Erwin

Confidential, NY

Sr. Developer

Responsibilities:

• Worked on writing, reviewing PL/SQL stored procedures (procedures, functions, packages, triggers, views, MVs and other database objects) and Informatica mappings.
• Created DDL scripts (partitioned tables, indexes, materialized views and others).
• Worked on diagnose root cause, problem solving and identify solution alternatives for various kinds of business scenarios.
• Worked on research various data sources and target mapping analysis to validate customer, accounts, Positions, Cash balance, margin data and security data.
• Experienced deep understanding of Trading workflow, Manager Workbench, Blotters and Compliance to address all production issues as they arise.
• Worked on analyzing Cusip, ISIN, FIX tag, Gaotag information for various kinds of trade issues and providing solutions to resolve issues.
• Worked on analyzing Bloomberg, Pershing files security information loads into trade systems.
• Worked on pre/post trade various application batch data loads from upstream and to downstream.
• Worked on application administration, production support + UAT testing.

Environment: Oracle 11g (SQL, PL/SQL), Informatica 9.5.1, Charles River Development (CRD), Sybase, SQL Server, Control-M, Quality Center, SVN, TOAD, Linux, Erwin,Splunk,AppDynamics

Confidential, NJ

Sr. PL/SQL Developer

Responsibilities:

• Worked on writing, reviewing PL/SQL stored procedures (procedures, functions, packages, triggers, views, MVs and other database objects).
• Worked on export, import, expdp and impdp utilities.
• Experience in providing data size estimations to DBA team for data migrations various client staging environments.
• Used Views, Materialized Views, Cursors, REF Cursors, Collections, Exception handling, Bulking Techniques.
• Worked on migration of database objects and data into different environments.

Environment: Oracle 11g (SQL, PL/SQL), Informatica 9.0.1, Optim, SVN, Autosys, TOAD, UNIX

Confidential, Charlotte, NC

Sr. PL/SQL Developer

Responsibilities:

• Created DDL scripts (partitioned tables, indexes, materialized views and others).
• Worked on creating validation strategy, validation plans and validation scripts to validate different events.
• Worked on analyze customer data to understand customer behavior, preferences and trends.

Environment: SQL, PL/SQL, Informatica, Netezza, Autosys, TOAD, UNIX, Informatica, Cognos

Confidential, Nashville, TN

Sr. PL/SQL Developer / DBA

Responsibilities:

• Worked on PL/SQL Procedures, Functions and Packages using PL/SQL to implement business rules which will create cost plans, keep track of providers billing, claims submitted to TennCare.
• Worked on maintaining HIPAA compliance guidelines for all database related information.

Environment: SQL, PL/SQL, TOAD, Informatica6.5, SQL*Loader, UNIX, Erwin, Crystal Reports