SUMMARY

• Around 8+ years of Industry experience in various roles as Sr.Oracle Developer with solid understanding of Business Requirements Gathering, Business Process Mapping, Evaluating Data Sources, Data Modelling, Data Mapping, Translating Requirements into Specifications, Application Design.
• Successfully managed Multiple Projects in a team of 25 members, working through different geographical location (onshore - offshore) for Finance, Banking Insurance, Energy and Health Care domain
• Solid understanding of Business Process Flows, Case Tools, and Business Analysis.
• Excellent Work Experience in Finance, Investment Banking, Home Loan Mortgage, Retail, Asset Management, Wealth Management.
• Excelling Experience in Confidential / JPMC / Confidential in Credit Card Industry and worked in PCI Audits for Banks to meet Industry Compliance Standards.
• Hands on experience in managing multiple projects at the same time using Project Management Body of Knowledge (PMBOK), Six Sigma and CMM understanding.
• Good Knowledge of various financial products like Stocks, Bonds, Mortgage Backed Securities (MBS), Asset Backed Securities with knowledge of Securitization Process, Collateral Mortgage Obligation (CMO), and Fixed Income Instruments.
• Functional experience with concentration on Use Case Modelling using UML, Business Process Modelling, Data Modelling, Change Management, Technical Training, Software Development methodologies, QA testing, and Systems Testing of client server and web-based systems.
• Sound Knowledge of data architecture concepts, data warehouse, data marts and ETL processes.
• In depth knowledge Rational Unified Process (RUP) methodology, Use Cases, Software Development Life Cycle (SDLC) processes, Object Oriented Analysis and Design (OOA/D).
• Experience in business consulting for Customer Relationship Management (CRM), Enterprise Resource Planning (ERP) and Enterprise Content Management (ECM) solutions.
• Strong project management skills including planning, scheduling, monitoring and budgeting with experience in requirement gathering, gap analysis, risk analysis, effort estimation etc.
• Expert in writing PL/SQL queries and excellent understanding of Databases and ETL.
• Experience in development methodologies like RUP, SDLC, AGILE, SCRUM and Waterfall
• Extensive experience with Content Management tools such as CVS, Harvest, Sharepoint.
• Strong experience in conducting User Acceptance Testing (UAT) and documentation of Test Cases. Expertise in designing and developing Test Plans and Test Scripts.
• Used Issue Tracker and Remedy for fixing defects and Issues and resolving Priority Tickets.
• Used JIRA/Issue Tracker and Remedy for fixing defects and Issues and resolving Priority Tickets.

TECHNICAL SKILLS

Operating Systems: Win 98, XP/NT, Windows 2000, Sun Solaris 7, 8, HP-UX, Red Hat Linux 7

Languages\Scripting: C, Pro*C, Visual Basic, PL/SQL, SQL, Java, J2EE, XML, JavaScript, VBA, VB, ASP.Net, Korn & Bourn Shell Scripting, JDBC, Web Logic BEA and Web Sphere.

Databases: Oracle 8i, 9i, 10g, Oracle 11g, SQL Server, MS ACCESS, DB2, Advanced Queuing

SQL Utilities: SQL*Plus, SQL*Plus Worksheet, SQL*Loader, Export, Import

Performance Tuning: TKPROF, EXPLAIN PLAN, HINTS.

Version Control Tools: CVS, Star Team, Visual Source Safe, Clear Case.

Issue Tracker Tools: Clear Quest, Peregreine Ticketing, Issue Tracker, Defects resolver.

Unix Shell Scripting: Korn, Bourne, C shell Scripting.

IDE: SQL Navigator, SQL Station, ERWIN, TOAD, Informatica, VISIO and Eclipse

GUI: Oracle Forms 6i, 9i, 10g and Reports 6i, 9i, Oracle 11g version, Apex (2.0,3.1,3.2 ), Reports and Discoverer Reports, Business Objects XI.

Claims Management: Amisys Advance 4.0

Business Process tools: HP Quality Center, HP Quick test Pro, Rational Rose, Requisite Pro.

ETL Tools: ODI, Informatica, SQL Loader.

PROFESSIONAL EXPERIENCE

Confidential, Washington DC

Sr.Oracle Developer

Responsibilities:

• Expert in DataModeling and have used Erwin Data Modeler to design Logical and Phsyical Datamodels for IFC Loans Approval System Transactional / Enterprise DataWarehouse Legacy systems.
• Interacted with Various team to understand their Process and Created Centralized Database with a New Data Model and Multiple Schemas to handle the Business Rules.
• Translated Business Requirement Documents into Data Models. Created Multiple Subject Areas for Various Schema Creations in Database for Handling Deals, Commitments, Loan Approvals, Billing, and Payment Applications in Confidential . Created Various Schemas like In Staging / Out Staging / Billing / Payment / Deal / HR and so on .for Front end teams / Back end teams to understand and access data in a Optimal Way.
• Proficient in all phases of System Development Life Cycle (SDLC) including Design, Analysis, Development, Testing and Implementation using Oracle 11g / 10g.
• Designed DataModels PDM for Centralized App for IFC and Performed Data Migration.
• Experience with Creating Star Flake / Snow Flake Schemas in Dimensional Modeling.
• Translated Business Process flows and Requirements in Possible Dimensional and Fact Tables.
• Created STAGING Areas INBound / Out Bound Staging so that Data Loading / ETL jobs are faster.
• We have Multiple 23 Data Sources (Flat Files / SQL Server / Other Oracle DB.).
• Data Sources - > Staging Area --> DataWarehouse --> DataMarts --> (User Applications/ Reports)
• Created Fact tables with Several Dimensional Tables in the Star Schema.
• Created tables for Various Layers like Staging Layer / Data warehouse Layer / DataMart Layer and Aggregation Layer to better handle the Business Rules and Reports.
• Created Dedicated Table Spaces for handling Various Layers Tables.
• Partitioned the Tables based on Range / Interval and used Partition Pruning so the queries are Faster when accessing Legacy Data in EDW.
• Created Master Tables in the DataWarehouse (SOR) Layer so aggregate tables in aggregate layer could use of Master table data.
• Created DATA Marts (Seperate Tables / Views) for the Individual / Operation data to tailor to the needs of Individual Application for the reports.
• Creation / Set up of Databases Schemas / User / Roles in Dev. SIT, UAT. PROD Environments.
• Defined Referential Integrity/ Constraints / Surrogate Keys between dimensional tables
• Responsible for Work Break Down / Deliverables of Project from Data base Team.
• Developed Low Level Tech Design Documents / Data Mapping Documents and Procedure Signature Design to support the Front End .NET / JAVA web based Apps.
• Performed Database Synchronization (Export/Import Schemas) From PROD Environment to UAT / DEV environments.
• Created Multiple Subject Areas and have created Data Models following Normal Standards NF1, NF2, NF3 and BCNF.
• Established One-One, One -Many Relationships between the Objects Created in Subject Areas.
• Created Bitmap Indexes on Foreign Keys on Fact tables based on the Cardinality for Performance.
• Data Volumes were around 6 TB. Created Materialized Views for Replication of data from Various Data Sources.
• Identified high Volume tables which contain more than 400 millions and Partitioned them by range /hash based on the data.
• Used tools like clear quest, clear case and Subversion for version management and change request management.
• Expert in writing/Creating Generic Stored Procedures, Functions, Database Triggers, Packages, tables, indexes, views, synonyms, sequences using SQL and PL/SQL in Oracle 11g.
• Worked on Dynamic creation of Tables and Loading data into them.
• Gathered Business Requirements from LOB for IFC and Prepared Tech Design Documents for Presentation to the LOB before Coding.
• After Approval of Tech Design Document, Developed Code and then Raised ECMs to do the Deployment in UAT and Generated UAT Volumes sent them for approval and Migrated code to PROD Environments.
• Experience in developing Dynamic SQL and Ref cursors and Use of Immediate Execute to run the SQL statements build during Run time.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors in Oracle 11g.
• Creating and managing tables- namespaces, data types, and data dictionaries and Meta Data Management.
• Hands-on experience in writing Packages, Stored procedures, Functions, and Database Triggers using SQL and PL/SQL.
• Extensive experience and knowledge in Oracle Forms and Reports, SQL*PLUS, SQL*Loader, SQL Developer, PL/SQL Developer and TOAD Tools.
• Analyze data quality and report the anomalies to business users while merging databases.
• Performed EOM pl/sql code development for Report Generation for Volumes of Queues and Incentive Calculation.
• Clear understanding of SAS and translating it to PL/SQL procedures.

Environment: Microsoft Project, Oracle 11g / 10g PL/SQL, Oracle Performance Tuning, ETL, Informatica, Erwin, TKPROF, Oracle Hints, Unix, C, ODI, C++, CVS, Sub Version, Export / Import Utilities, TOAD, SQL Navigator, SQL Server, Query Analyzer, Enterprise Manager, Visio .

Confidential, Pittsburgh, PA

Sr.Oracle Developer

Responsibilities:

• Worked on Designing the Oracle Data Model for Wealth management of Confidential External and Internal Clients Projects.
• Designed Design document for Migration of Oracle Database from 10g to 11g.
• Identified the new features in 11G and implemented them in our Data base archtiecture for better Partitioning (Space utilizatin and better Performance)
• Created Dimension / Fact tables for Star Schema Creation.
• Created Indexes / Partitions for the tables to handle performance in DW Environment.
• Identified Daily Nightcycle process scheduled which call PL/SQL, Procedures/ Packages / Triggers and Tuned them for Performance by use of various Oracle Performance Monitoring tools (Explain Plan/ TKprof, V$ tables for identifying High load sql statements in code). Performance tuned 4hours Replication process to 20 min.
• Generated AWR reports to identify issues like Highload sql statements, Cursor Leak issues and resolved them.
• Worked on the Data Replication from Source systems to Target systems. Designed Data model and new Schemas to maintain daily transactional data.
• Created History Tables to maintain history and Delta tables/ Materialized views for improving data Replication Speed.
• Managed offshore team of 7 DB developers in Chennai and Calcutta and assigned them DB tasks.
• Worked with Dataware house and created Dimension and Fact tables in star Schema
• Used ODI knowledge Modules IKM and Created Datastores and Interfaces,
• Worked on Performing Synch of QA / Test Environments.
• Performed Data Masking to ensure we meet Audit for QA to Protect and Mask Personal information of Customers.
• Experience in developing Dynamic SQL and Ref cursors and Use of Immediate Execute to run the SQL statements build during Run time.
• Performed QA deployments and Prod Deployments of Every Month.
• Worked with the DBA’s for Migrating existing DB’s to New servers for Test/ QA / Prod, Table space creation and increase of size based on Requests.
• Used PL/SQL procs and Oracle directories and Export / Import / Data Pumping utilities for data loading. PL/SQL Coding and SQL tuning throughout the development wherever needed. Used tools like clear quest, clear case and Subversion for version management and change request management.
• Worked on Dynamic creation of Tables and Loading data into them.
• Prepared Functional Design Documents for Presentation to the LOB.
• After Approval of Tech Design Document, Developed Code and then Raised REMEDY / ECM’s to do the Deployment in UAT and Generated UAT Volumes sent them for approval and Migrated code to PROD Environments.
• Worked with advanced features of OOPS in Oracle such as Collections, Varrays and Objects
• Expertise in exports and import of PACE table data using PL/SQL code and SQL*Loader, UTL File package.
• Scheduled DBMS jobs in Oracle and Unix.
• Experience in performance Tuning using Explain plan and hints. Experience with Query Optimization procedures using SQL Advisors in Oracle 11g.

Environment: Oracle 11g / 10g PL/SQL, Oracle Performance Tuning, Erwin, TKPROF, Oracle Hints, Unix, Java, ODI, Sub Version, Export / Import Utilities, TOAD, SQL Navigator, SQL Server, Query Analyzer, Enterprise Manager, Visio.

Confidential, Lewisville, TX

Sr.Oracle Developer

Responsibilities:

• Involved in project planning sessions with project managers, business analysts and team members to analyze business requirements and proposed IT solutions.
• Worked on SDLC Iterative life cycle model
• Created Star Schemas (Dimensional / Fact) tables in EDW.
• Created Logical / Physical Data Models
• Worked on OLTP environment as a result of daily numerous transactions and Developed Oracle Forms and Reports for daily reports and Transactions.
• Worked on Asset Management and Asset Pricing.
• Generated Reports for Assets Management and Occupancy reports.
• Designed the Data Model using ERWIN.
• Worked on TKPROF, explain Plan and Hints for performance tuning.
• Generated various reports in Oracle APEX and Oracle reports 10g for Order - to - Activate Automation different formats like Group Left, Group Below and Matrix Reports and Calculated Summary at various Levels and produced reports in the output format of PDF, Excel, JSP and so on.
• Worked on Various PL/SQL Triggers, PL/SQL Exceptions and Event Handling in Forms and Reports.
• Worked on PL/SQL Implicit and Explicit Cursors and used Dynamic SQL.
• Used APEX 3.0 forms to design Master Detail Forms.
• Worked on Data Relations ships and used oracle Enterprise Manager in Oracle 10g.RAC.
• Involved in designing the procedures for obtaining the data from all systems to Data Warehousing.
• Generated Datawarehouse reports using Business Objects. Worked on Universe creation and managed dataloads into Dimension and fact tables.
• Worked on Snowflake and Star flake schema design. Worked on ASM.
• Used PL/SQL collections and Records, Dynamic SQL and Types and Objects.

Environment: Oracle 10g, Oracle (10g / 9i / 6i) Reports, Oracle Performance Tuning, Info view, Query Analyzer, Enterprise Manager, Visio, Peregrine and Issue tracker.

Confidential

Internship

Responsibilities:

• Used Unix in Production support and used AWK and SED for writing scripts.
• Worked on Data Migration from Microsoft Access and Excel sheets to Oracle databases using ETL tools like Datastage and APEX sql*loader.
• Imported and Exported Databases. Used Informatica. Worked on DBMS packages like DBMS UTIL, DBMS PROFILE and UTL RAW.
• Wrote JDBC code to access oracle Database from java. Developed Java Servlets and deployed them on web server.
• Used Java Script and Perl for validation of web screens
• Worked as a DBA for databases using Oracle DB, DB2, and SQL SERVER.
• Executed Unix Korn shell scripts, directory structures and I/O file handling in Production
• Worked on Oracle Performance tuning to improve the performance of SQL queries and PL/SQL code using Explain Plan, TKProf and Hints.
• Responsible for troubleshooting the errors that occurred when the production group hit a roadblock (Production Support)

Environment: Test Director, Rational Rose, Oracle Developer Suite 2000,Microsoft Visio, Erwin, Visual Basic, ASP, Oracle, HTML, VB Script, PL/SQL, SQL, and Windows NT, Dream Weaver.