SUMMARY

• 9+ Years of IT experience in Designing, Development, Customization, Integration and Implementation of client/server application using Oracle 8i/9i/10g/11g/12c (SQL, PL/SQL Packages, Procedures, Functions and Triggers), Teradata, Postgres SQL, Data Migration and Integration and Deletion, ETL Tools like Informatica, Salesforce, Veeva CRM, and Siebel CRM, Hadoop functionalities like Hive and HDFS, & Reports
• Have experience handling multiple engagements in various capacities as an Architect in Relational Database and Data Warehouse, Designer and Developer
• Strong experience on Project Management, Data warehouse architecture, Database Design, ETL Design, Report Design, ETL Optimization, Data Profiling, Data quality process design, Best practice implementation, ETL Development, Production support and team co - ordination
• Data modeling experience using Erwin tool involving Dimensional and Fact tables in Datawarehouse
• Worked on various data business models like Hospitality Management, Pharma, Patient Benefit Management, Human Resources, Sales - Order Management, Manufacturing - Inventory Management
• Worked on some of the Oracle Financial Applications like Order Management, Accounts, Cash Management (CM), Assets (FA), Content, Sales, Pricing, Payments (AP), Ledger (GL), etc
• Experience on Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling
• Experience in Data Migration from various Legacy Systems to Target DBs using PL/SQL, ETL Informatica, UNIX scripts
• Excellent technical and analytical skills with clear understanding of design goals for ER modeling of OLTP and dimension modeling of OLAP
• Implemented Slowly changing Dimensions for Historical Data attribute level changes
• Use of Performance enriching techniques like Using Hints, Indexing, Partitioning, Explain Plan, views, materialized views, tkprof, AWR and ADDM, etc.
• Worked on XML functionality using CLOB and BLOB columns.
• Have created Joiner, Router, Lookup, Filter, Sequence Generator, Normalizer, Expression transformations in Informatica as per the defined objectives
• Have experience in Data Transformations, cleansing and generating the reports in the formats helpful for the Clients and the Business Users
• Having good knowledge in Data Transformation and Loading using SQL Loader and External Tables
• Have extensive experience in PL/SQL exclusively on stored procedures, packages, triggers, functions, Cursors and bulk loads as per the requirements
• Strong leader with experience in training developers and advising technical groups on OLTP, OLAP and ETL best practices
• Have been working on various databases like Teradata, Oracle and SQL Server and optimized the performance of the scripts used
• Experience in handling defects and providing swift resolutions
• Lead teams handling the whole Life Cycle of Projects across the domains and have implemented the LEAN methodologies enhancing the overall value for Customers with fewer resources and short timelines
• Developed campaigns in UnicaAffinium, a campaign management tool
• I have extensively worked on enhancing performance on the databases and implementing the industry best practices
• Highly self-motivated and able to set effective priorities to achieve immediate & long-term goals and meet the project & operational deadlines
• Successfully managed complex projects with global implementation, and rapidly evolving requirements.
• Effective communication skills and record for coordination between globally located teams
• Project delivery under stringent timelines and high pressure
• Conducted a budget planning of the project through walkthroughs and meetings involving various leads from Development, QA and Technical Support teams
• Exceptional ability to maintain and build client relationships, frequent travel meeting one on one with clients, able to comfortably converse with all facets in the clients organization
• Define Business Process; identify the risk, doing risk analysis and providing baseline acceptance criteria and deliverables
• Adept in providing Analytical Support to key business Applications /solutions
• Excellent verbal and written skills, especially with regards to presenting findings to both technical and non-technical audiences
• Thorough Understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing
• Acted as liaison between management and development team for Requirements and QA
• Managing reports, analysis and decision-making for a change request
• Project Management, Project Schedule, Project Tracking and Team Management
• Rich experience in translating Business requirements to understandable IT systems requirements

TECHNICAL SKILLS

• Telecom CRM
• E-Sales CRM
• Hospitality Management CRM
• Patient Benefit Management
• Pharmaceuticals
• Insurance and Billing
• Requirements gathering, functional specifications and gap analysis
• Designing, Implementing projects, end to end testing and user acceptance testing
• Oracle SQL, PL/SQL, ERWIN
• Siebel EIM, Configuration & Proposal Document Template Design
• Databases - Oracle, Mongo DB, SQL Server, Teradata
• Operating systems - UNIX, Windows OS
• ETL Tools - Informatica
• Campaign Management - IBM Unica
• Knowledge on Core Java
• Knowledge on Hadoop System

PROFESSIONAL EXPERIENCE

Confidential, San Francisco, CA

Sr Database Developer

Tools: used: SQL Developer, Erwin

Responsibilities:

• Gather, design and develop database based on the requirements from the Business Team and the developers from the Salesforce Application and Oracle Financial applications dealing with Advanced Pricing.
• Coordination with the Development & Reporting Development teams
• Working with DBAs to get the Database design approved and implemented
• New table structures for the business were created and brought into use using Erwin Data Modeling.
• Created, loaded and maintained Archive tables which were created using various types of Slowly Changing Dimensions
• Prepared the logical and physical designs for the business requirements and implemented them as required
• Populated the Metavance tables with the data provided by the Salesforce Team and the Oracle Financial Apps
• Created Packages and procedures for applying logic for New Group, New division and Group Termination and Billing Entities
• Tracking User issues and provide swift resolutions to them as well as provide information to clear out the issues
• Providing alternate solutions or approach to improve the existing process
• Worked on various business reports to handle the performance issues and also helping them achieve the objectives
• Created the following functionality as and when required tables, views, cursors, functions, stored procedures and packages.
• Understand the Salesforce data structures to appropriately populate the Metavance Tables
• Assist the Business team and testing team with the complexities of the data and the roadblocks in the development
• Provide thorough Unit Testing results and provided support in the various testing phases like Integration Testing, User Acceptance Testing
• Supporting deployments and prepping the Environments before the deployments
• Dealt with data inflows on a daily basis and data changesand resolved performance issuesthat hamper the retrieval ability
• Resolved issues with existing PL/SQL Procedures by implementing best practices
• Implemented Error Handler functionality for tracking errors
• Provided the documentations for Business and Technical processes in the system and provided periodic review of the same
• Lead a large team with offshore and onsite model and had gone live with multiple projects

Confidential, Thousand Oaks, CA

Senior Database Developer

Tools: used: Toad, Informatica 9.1, Veeva CRM

Responsibilities:

• Providing alternate solutions or approach to improve the existing process
• Coordination with the Development and Reporting Development team with Design/Development approach to create Datamart for reporting purposes
• Data Integration from source systems into the target system
• Loading Territory Alignments to the Sales Representatives and Customers
• Loading weekly data loads to keep the database up to date with the Addresses, the User and Customer details
• Loading new Users and Healthcare professionals and assigning profiles as per the territories and which is based on the zip codes
• Developed Mappings, Mapplets, Workflows & Sessions in Informatica and monitored the daily runs and reported and accordingly fixed the issues.
• Tracking User issues and provide swift resolutions to them as well as provide information to clear out the issues.
• Creating and managing views for various objects, new profiles, Roles and Territory Hierarchies, Products, Key Messages
• Created reports for User tracking, Accounts, General Ledger, expenditures or Payments, Educational material distribution, etc on Veeva CRM as well as Oracle Financial applications
• Provide weekly reports to the Business team to analyze the activities or the outcome of the Sales Rep activities
• Understand the Lifesciences program and suggest the new technological enhancements that the Organization needs to implement
• Schedule the weekly loads related to Accounts, Users, Territories and Addresses.
• Handle the upstream and downstream teams who rely on the Application database
• Analyzed Upstream and downstream systems architecture, Business Requirements, and Document Business Rules for the associated systems
• Developed Stored Procedures, packages, Functions,Triggers, staging tables and views using PL/SQL to implement day to day modified business rules into the current system
• Dealt with data inflows on a daily basis and data changes and resolved performance issuesthat hamper the retrieval ability
• Resolved issues with existing PL/SQL Procedures by implementing best practices
• Implemented Error Handler functionality for tracking errors
• Provided the documentations for Business and Technical processes in the system and provided periodic review of the same
• Lead a large team with offshore and onsite model and had gone live with multiple projects

Confidential, Stamford, CT

Sr. Oracle Developer

Tools: used: Oracle 11g & 12c, Informatica 9.1, UNIX, Siebel EIM

Responsibilities:

• Interacting with the Business Users and Project Management for analyzing the business needs and develop Design Specification
• Understanding of design goals while creating ER models for OLTP and dimension modeling for OLAP
• Analyzed Source Systems, Business Requirements, Identify and Document Business Rules for Decision Support Systems
• Developed Stored Procedures, packages, Functions and Triggers using PL/SQL to implement day to day modified business rules into the current system
• Dealt with huge data and resolved issues of system slowness and tackled performance issues while loading as well as retrieving
• Resolved issues with existing PL/SQL Procedures by implementing best practices
• Implemented Error Handler functionality for tracking errors
• Worked on Workflows for implementing Account Hierarchy creation process and created Transformations, Sessions, Workflows, Procedures and Siebel EIM Jobs
• Created integration jobs between Siebel and Oracle Financial applications dealing with Pricing and Assets
• Tuning SQLs to enhance the performance of the data to be retrieved, simultaneously to not hamper the performance of the application
• Implemented EIM best practices in mapping Siebel data with external data through EIM tables and implemented Siebel Alerts in EIM Delete and Merge jobs to avoid conflicts
• Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.
• Converted and loaded data from flat files, CSV & Pipe delimited files to temporary tables in Oracle database using SQL*Loader & External Tables
• Tuned long running queries explain Plan, Confidential etc
• Automating the flow using batch scripting like extraction, running the jobs to delete and reporting as required
• Developed Mapplets, Workflows & Sessions in Informatica with various transformations and executed the as part of the batch scripts
• Monitoring the runs and verifying logs as part of the executions during various phases like development, testing and deployment
• Involved in resolving complex scenarios using Informatica transformations
• Integrating Informatica workflows with PL/SQL procedures and Siebel Systems as per the requirements
• Developing design to maintain the Archived database for the legal purposes
• Attachments maintenance in the archival system
• Providing vital reports to the client from the Archived database
• Merging andUnmerging the key entities in the database when required
• Providing a run book which provides the necessary knowledge to the associated admin team about the steps to be followed, the objects to be moved and the objectives to be met
• Lead an offshore team and handled multiple deployments and Go Lives periodically though out the year
• Involved in Administration activities migrating the repository from development to testing environment, and assisting the production support team during deployment activities
• Involved in resolving the issues found during Unit Testing & User acceptance Testing
• Responsible for collecting, understanding, and transmitting the business requirements for the project, and translating these into functional specifications and detailed test plans

Confidential, St. Louis, MO

Oracle PL/SQL Developer

Tools: used: Oracle 11g, Teradata, UnicaAffinium Campaign, Windows Batch Scripting

Responsibilities:

• Enhancing and executing the campaigns as per the Client requirements.
• Involved in all cycles of the development like gathering requirements, design, development, testing, deployment and support
• Involved in Logical and Physical modeling of the new data marts created for reporting purposes
• Created ER Diagrams for business requirements and transformed them on to the database
• Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries
• Tuning SQLs to enhance the performance of the campaigns, simultaneously to achieve better results
• Tuned performance risque queries using explain Plan, Confidential etc.
• Create partitioned tables & moving data from non-partitioned tables to partitioned tables
• Created views and materialized views to resolve complex queries
• Added/Changed Tables, columns and triggers
• Created Dimensions and Facts and have implemented Slowly Changing Dimensions for Historical Data captures
• Automating the whole flow using batch scripting like creating table structures based on the name of the run dynamically, collecting stats, creating indexes, updating the logs, creating the QC reports for the respective runs and also mailing the reports generated to the Client members if required
• Developing macros and triggers for the common usage across the campaigns
• Ensuring error free and timely delivery of business objectives performed
• Created reports out of Data mart based on Oracle Financial applications Cash Management and Ledger
• Profiling customers with respect to various business categories and segmenting based on business rules
• Providing vital insights to the merchandizing and marketing team
• Capturing the changes on the flowcharts and creating the code review documents and this will be shared with the team as part of knowledge transfer initiative
• Testing the developed flowcharts using the temporary tables created and generating the QCs which once approved by client can be moved into production
• Assisting the Admin team in the smooth deployment of the developed code into the Production environment by providing a run book which provides the necessary knowledge to the associated admin team about the steps to be followed, the objects to be moved and the objectives to be met
• Working on RFP requirements and presenting before the business leads

Confidential

Oracle PL/SQL Developer

Tools: used: Oracle 10g, Informatica, Siebel Call Center 8.1, UNIX

Responsibilities:

• Involved in end to end development cycles of the including gathering requirements, design, development, testing, deployment and support
• Created ER Diagrams for business requirements and transformed them on to the database
• Created a reporting mechanism for data of HR - Human Capital Management and Learning Management for Cognizant portal
• Extracted data from Oracle Financial applications dealing with Accounts, Order Management, Pricing, Assets, Content
• Preparing the Mapping document with the corresponding Staging DB Columns and their respective Siebel DB Columns
• Developed Stored Procedures, packages, Functions and Triggers using PL/SQL to implement day to day modified business rules into the current system
• Coordinating with users in functional areas for changes and amendments to the system for its improvement
• Create partitioned tables & moving data from non-partitioned tables to partitioned tables
• Created views and materialized views to resolve complex queries.
• Added/Changed Tables, columns and triggers
• Executed deployment of database schema and code modules
• Migrated data from various Legacy Systems like Clarify, Siebel 6.1 to Staging DB
• Loading data into the Staging DB using SQL Loader
• Developed the mappings and workflows along with Validations and Transformations in Informatica as per the requirements
• Created transformations like Joiner, Filter, Router, Sequence generator, Lookup, Sorter and Normalizer Transformations
• Scheduled the workflows and monitoring the tasks
• Checked the dependencies of the objects and deploying them in the subsequent User environments
• Loaded data into Base Tables from the staging DB with the help of Informatica, where the data goes through various Validations and Transformations and Siebel EIM IFBs and thus errors are captured, encountered during the run and the same is reported to the Client for ensuring the Data Quality
• Automated the execution by UNIX scripts
• Clarifying the technical aspects to the client as well as getting clarified from the client the issues encountered during migration
• Periodical reports are generated and shared with the appropriate
• Setting up new environments and ensuring smooth deployments of the developed code into these environments as per the client requirements
• Supporting all the development teams involved in the project, ensuring the effectiveness in the implementation of the Project
• Developing code for Batch Interfaces to load Historical Data in to Siebel Tables

Confidential

Oracle Developer

Tools: Used: PL/SQL, UNIX Batch Jobs, Clarify CRM, Siebel CRM

Responsibilities:

• Loading and updating the Key Entities in base tables using PL/SQL for like Accounts, Assets, Service
• Requests, Agreements, Orders and Opportunities
• Involved in developing a detail technical design documents for project implementation
• Developed DDL Scripts for generating Tables, Views, and Materialized views etc
• Developed Views, PL/SQL procedures, functions, packages and Triggers
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries
• Creating UNIX shell scripts for ad-hoc batch jobs
• Performed Database Normalization to tackle performance issues on the large tables
• Performance tuning SQL statements and PL/SQL packages using Explain Plan
• Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing the existing ones.
• Converted and loaded data from flat files, CSV files to temporary tables in Oracle database using SQL*Loader
• Extensively used UTL FILE package, external tables to write data from flat files to Oracle Database
• Extensively developed PL/SQL procedures using Ref cursors and collections with bulk bind to insert and update millions of rows into target tables
• Validating the data which comes from CLARIFY(Legacy System) and other sources
• Migrating or updating critical data utilizing the COM Loader
• Ensuring the deadlines are met and helping in the smooth release of the periodical developments
• Design of customer facing documents for entities Opportunity, Quote, Service Agreements and Emailtemplates for the same
• Developed code is deployed in various Environments by providing Instruction Sheets for the Admin teams to go ahead as per the instructions