SUMMARY

• Overall 8 Years of IT experience in Design, Development, Customization, Integration and Implementation of client/server application using Oracle 8i/9i/10g/11g (SQL, PL/SQL Packages, Procedures, Functions and Triggers), Teradata, Data Migration, ETL Tools, Siebel CRM experience & Reporting.
• Experience on Star/Snowflake Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to Testing, implementation, and support.
• Experience in Data Migration from various Legacy Systems to Target DBs using PL/SQL, ETL Tool.
• Excellent technical and analytical skills wif 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.
• Has experience in Informatica for transforming teh data according to teh requirement and automated thru UNIX Batch scripts.
• Has experience in Data Transformations, cleansing and generating teh reports in teh formats halpful for teh Clients and teh Business Users.
• Having good noledge in Data Transformation and Loading using SQL Loader utility and External Tables.
• Has extensive experience in PL/SQL exclusively on stored procedures, packages, triggers, functions, Cursors and bulk loads as per teh requirements.
• Strong leader wif experience in training developers and advising technical groups on OLTP, OLAP and ETL best practices.
• Has been working on various databases like Teradata, Oracle and SQL Server and optimized teh performance of teh scripts used.
• Worked on error tracking, handling and resolving as per teh business requirements.
• Experience in handling defects and providing swift resolutions.
• Developed campaigns in Unica Affinium, a campaign management tool.
• me has extensively worked on enhancing performance on teh databases and implementing teh industry best practices.
• me am hardworking, creative and highly flexible wif respect to teh Project Objectives.
• Highly self - motivated and able to set TEMPeffective priorities to achieve immediate & long-term goals and meet project & operational deadlines.
• me am inquisitive and a quick learner and has been learning Big Data related Technologies like Hadoop.
• Successfully managed complex projects wif global implementation, and rapidly evolving requirements.
• TEMPEffective communication skills and record for coordination between globally located teams.
• Project delivery under stringent timelines and high pressure.
• Conducted a budget planning of teh 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 wif clients, able to comfortably converse wif all facets in teh clients organization.
• Define Business Process; identify teh 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 wif 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
• Oracle SQL
• PL/SQL.
• Siebel EIM
• Configuration & Proposal Document Template Design.
• Databases
• Oracle
• SQL Server
• Teradata.
• Operating systems - UNIX
• Windows OS.
• ETL Tools - Informatica
• Campaign Management - IBM Unica
• Knowledge on Core Java

PROFESSIONAL EXPERIENCE

Confidential, Stamford, CT

Sr. Oracle Developer

Responsibilities:

• Interacting wif teh Business Users and Project Management for analyzing teh 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 teh current system.
• Dealt wif huge data and resolved issues of system slowness and tackled performance issues while loading as well as retrieving.
• Resolved issues wif 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
• Tuning SQLs to enhance teh performance of teh data to be retrieved, simultaneously to not hamper teh performance of teh application
• Implemented EIM best practices in mapping Siebel data wif 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 teh 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, TKPROF, SQL TRACE, ANALYZE, HINTS etc.
• Automating teh flow using batch scripting like extraction, running teh jobs to delete and reporting as required
• Developing design to maintain teh Archived database for teh legal purposes
• Attachments maintenance in teh archival system
• Providing vital reports to teh client from teh Archived database
• Merging and Unmerging teh key entities in teh database when required
• Providing a run book which provides teh necessary noledge to teh associated admin team about teh steps to be followed, teh objects to be moved and teh objectives to be met
• Involved in Administration activities migrating teh repository from development to testing environment, and assisting teh production support team during deployment activities.
• Involved in resolving teh issues found during Unit Testing & User acceptance Testing.
• Responsible for collecting, understanding, and transmitting teh business requirements for teh project, and translating these into functional specifications and detailed test plans.

Confidential, St. Louis, MO

Oracle PL/SQL Developer

Responsibilities:

• Enhancing and executing teh campaigns as per teh Client requirements.
• Involved in all cycles of teh development like gathering requirements, design, development, testing, deployment and support.
• Involved in Logical and Physical modeling of teh new data marts created for reporting purposes.
• Created ER Diagrams for business requirements and transformed them on to teh database.
• Extensively developed PL/SQL procedures using Ref cursors and collections wif 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 teh performance of teh campaigns, simultaneously to achieve better results.
• Tuned performance risque queries using explain Plan, TKPROF, SQL TRACE, ANALYZE, HINTS 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 has implemented Slowly Changing Dimensions for Historical Data captures
• Automating teh whole flow using batch scripting like creating table structures based on teh name of teh run dynamically, collecting stats, creating indexes, updating teh logs, creating teh QC reports for teh respective runs and also mailing teh reports generated to teh Client members if required.
• Developing macros and triggers for teh common usage across teh campaigns.
• Ensuring error free and timely delivery of business objectives performed.
• Profiling customers wif respect to various business categories and segmenting based on business rules.
• Providing vital insights to teh merchandizing and marketing team.
• Capturing teh changes on teh flowcharts and creating teh code review documents and this will be shared wif teh team as part of noledge transfer initiative.
• Testing teh developed flowcharts using teh temporary tables created and generating teh QCs which once approved by client can be moved into production.
• Assisting teh Admin team in teh smooth deployment of teh developed code into teh Production environment. Providing a run book which provides teh necessary noledge to teh associated admin team about teh steps to be followed, teh objects to be moved and teh objectives to be met.
• Working on RFP requirements and presenting before teh business leads.

Confidential

Oracle PL/SQL Developer

Responsibilities:

• Involved in end to end development cycles of teh including gathering requirements, design, development, testing, deployment and support.
• Created ER Diagrams for business requirements and transformed them on to teh database.
• Preparing teh Mapping document wif teh 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 teh current system.
• Coordinating wif users in functional areas for changes and amendments to teh 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.
• Migrating data from various Legacy Systems like Clarify, Siebel 6.1 to Staging DB.
• Loading data into teh Staging DB using SQL Loader.
• Developed teh mappings and workflows along wif Validations and Transformations in Informatica as per teh requirements.
• Scheduling teh workflows and monitoring teh tasks.
• Checking teh dependencies of teh objects and deploying them in teh subsequent User environments.
• Loading data into Base Tables from teh staging DB wif teh halp of Informatica, where teh data goes through various Validations and Transformations and Siebel EIM IFBs and thus errors are captured, encountered during teh run and teh same is reported to teh Client for ensuring teh Data Quality.
• Automating teh execution by UNIX scripts.
• Clarifying teh technical aspects to teh client as well as getting clarified from teh client teh issues encountered during migration.
• Periodical reports are generated and shared wif teh appropriate.
• Setting up new environments and ensuring smooth deployments of teh developed code into these environments as per teh client requirements.
• Supporting all teh development teams involved in teh project, ensuring teh TEMPeffectiveness in teh implementation of teh Project.
• Developing code for Batch Interfaces to load Historical Data in to Siebel Tables.

Confidential

Oracle Developer

Responsibilities:

• Loading and updating teh 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 Functions etc.
• Added/Changed Tables, columns and triggers.
• Developed Views, PL/SQL procedures, functions, packages and Triggers.
• Strong analytical ability and experience in developing, testing and troubleshooting SQL Queries.
• Created Indexes to speed up teh queries.
• Creating UNIX shell scripts for ad-hoc batch jobs.
• Performed Database Normalization.
• Performance tuning SQL statements and PL/SQL packages using Explain Plan.
• Involved in Debugging, Troubleshooting Procedures, functions, packages, customizing teh 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 wif bulk bind to insert and update millions of rows into target tables.
• Validating teh data which comes from CLARIFY(Legacy System) and other sources.
• Migrating or updating critical data utilizing teh COM Loader.
• Ensuring teh deadlines are met and halping in teh smooth release of teh periodical developments.
• Resolving teh issues raised by teh user in due time
• Design of customer facing documents for entities Opportunity, Quote, Service Agreements and Email templates for teh same
• Developed code is deployed in various Environments by providing Instruction Sheets for teh Admin teams to go ahead as per teh instructions.

Confidential

Technical Consultant

Responsibilities:

• Creation of Technical Design Documents based on teh High Level Design Documents provided by teh Client.
• Communicating teh issues to teh Client and clarifying them for better understanding as well as teh quality development.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into teh current system.
• Developed SQL Loader scripts for loading data from varying resources and inserting teh master data into tables.
• Implemented triggers to enhance functionality, supplement validation, and default transaction Processing.
• Tuned teh queries to improve teh performance using Explain Plan, TK Prof, Auto Trace utilities, assessed teh efficiency of teh code modules.
• Daily Backups of transaction logs and Scheduling Jobs to perform this task.
• Loading and updating teh Key Entities in base tables using PL/SQL Procedures.
• Extensively involved in preparing Mapping sheets for Interface and Base table.
• Preparing CTL files for loading data into teh staging Database.
• Involved in developing detail technical design documents for project implementation.
• Guided and worked wif teh team in configuring teh application.
• Reporting on a regular basis wif teh client as well as teh Development authorities, ensuring timely deadlines are met.
• Resolving teh issues raised by teh testing team and generating teh reports for teh same.

Confidential

Technical Consultant

Responsibilities:

• Analyzing business requirements and supported teh preparation of Technical design documents
• Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
• Developed SQL scripts to Insert/Update and Delete data in Oracle database tables.
• Analyzing teh existing reports and modifying teh reports specific to new requirements.
• Interacting wif teh business users and application owners on their requirements on HR data, modified several existing reports and also developed new HR reports.
• Created Indexes to speed up teh queries.
• Dealt wif huge data and resolved issues of system slowness and tackled performance issues while loading as well as retrieving.
• Configuring Business Objects, Business Components and Mapped them to data base object layer and configured screens, applets, views and drilldowns using Siebel tools.
• Customized Siebel Database tables to include extension columns to map new business component fields
• Coordinating wifin teh team and making sure requirements are met as per teh functional understandings.
• Extensively worked on creating periodical reports, presentations and analysis of teh projects using Microsoft Tools.