SUPER RESUME
< Back
Edit this resume to make it your own!

Your Name

Data Analytics Architect

your.email@example.com
111-222-3333
www.your-website.com

Summary

Operating System: Windows NT, Windows 200x, Sun Solaris/UNIX and Linux 
Languages: SQL, PL/SQL and T-SQL 
Database: Oracle 11g / 10g / 9i, MS SQL Server 2000/7.0, MS Access 
Scripting Tool: UNIX / Linux Shell Script 
Scheduling Tools: AutoSys 
Tools/utilities: SQL*Plus, TOAD, PL/SQL Developer, SQL Navigator, SQL Loader, 
CRM Application & Too l: Siebel 7, Siebel 7.7 and Siebel 8; Siebel Tools 
Data Warehouse: Oracle BI (Siebel OBIEE), Cognos 8.3 Framework Manager, Report Studio, Query Studio 
Database Design Tool: Erwin 
Tools & Utilities: MS Office, MS Project, MS Visio

Work Experience

Data Analytics Architect

Merck & Co, New Jersey, USA,

Nov 2009Current

Oracle Consultant / CRM Data Analytics Architect

Merck & Co, New Jersey, USA,

Nov 2009Current


Requirements fulfilled:
  • Developed Data Migration and Conversion process between different sources like SAP & AS400 and target Oracle DB.
  • Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, Dependency documents.
  • Developed Oracle Procedures, PL/SQL script and creating Linux shell scripts to migrate complex data structure from AS400 to Siebel Application database for running the daily loads based upon the business logics.
  • Generated Complex PL/SQL reports during the data migration process to user and support team.
  • Developed Linux program to send reports through E-mail using Oracle Package PL/SQL programs.
  • Developed SQL*Plus data summary report from integrated system to monitor the daily data loading process.
  • Developed ksh Shell scripts and SQL control files to load data through SQL Loader.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
  • Maintained the batch processes using Unix Shell Scripts.
  • Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures.
  • Develop and maintain the documentation to support the team and business.
  • Responsibilities as an oracle developer include management of the queries, enhancement and support service issues.
  • Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
  • Performed unit testing for the scripts.
  • Accomplishments in excess of Requirements:
    • Modified, maintained and developed the SQL codes to develop new enhancements based upon the business requirements.
    • Siebel Application Production support and analysis/fix data related issue in Oracle table.
    • Generated various reports from Oracle tables for the Finance, Credit Deportments using Oracle Procedures and Linux Shell scripts.
    • Developed Linux program to send various automated reports through E-mail using Oracle Package PL/SQL programs.
    • Perfumed as Techno-functional consultant for Cognos Report requirements.
    • Creating Technical design document for Cognos Reports to the developers.

    Environment: Oracle 11g - Unix/Linux - SQL & PL/SQL - Siebel 7.8 eConsumer Goods - Cognos 8.3 - MS Project

Associate Manager

Satyam Computer Services Ltd (USA/UK/India),

May 2003Nov 2009

Project Manager/CRM Functional Consultant/Business Analyst

GE Healthcare, New Jersey, USA,

Jun 2008Oct 2009


Requirements fulfilled:
  • Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, Dependency documents.
  • Involved in creating stored procedures and packages with DYNAMIC SQL.
  • Involved in Oracle Procedures, PL/SQL script to migrate sales, territory data structure from source systems to Siebel Application database for running the daily loads based upon the business logics.
  • Develop and maintain the documentation to support the team and business.
  • Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
  • Performed unit testing for the scripts.
  • Prepared Siebel Application related FAQ issue documentation to application user groups.
  • Developed Shell scripts and SQL control files to load data through SQL Loader.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
  • Accomplishments in excess of Requirements:
    • Successfully played different roles in the project as Project Manager, Functional Analyst, Data Analysts, Siebel Tester and Siebel Analytics (OBIEE) functional consultant.
    • Developed and maintained Application Support Central portal to help development and business teams.
    • Resolved business related critical data issues in the application for users in all the projects. Identified and Implemented areas of Business improvement in applications.
    • Conducted technical/QA Knowledge sharing sessions with team members to help their self- improvement.

    Environment: Oracle 9i / Sun Solaris - SQL & PL/SQL - Siebel 7.8 ePharm - Siebel Analytics (OBIEE)

Data Analyst & Oracle Consultant / Testing

United Nations, New York, NY

Nov 2007Jun 2008


Requirements fulfilled:
  • Created Oracle PL/SQL, Procedures to convert and migrated highly confidential data from MS Access DB and different Flat files into Siebel instances without issues.
  • Used SQL*Loader to load data from CSV files into Oracle tables.
  • Performed unit testing for the scripts.
  • Prepared test data, test plan and test case to validate the data migration process.
  • Accomplishments in excess of Requirements:
    • Successfully played different roles in the project as Data Analyst, Siebel Tester and Oracle consultant.
    Environment: Oracle 9i - Sun Solaris - SQL & PL/SQL - MS Access - Siebel 8 ePublic Sector

Data Migration Release Manager

Elsevier Limited,

Sep 2007Oct 2007


Requirements fulfilled:
  • Monitored and validated the data migration process as per the client standard and requirements on-time.
Environment: Oracle 9i - Sun Solaris - SQL & PL/SQL - MS Access - Siebel eMedia

Project Lead / Data Integrator / Data Migration Analysts

Ford Motor Company, United Kingdom,

May 2004Jun 2007


Requirements fulfilled:
  • Developed document for UI Mapping, Database Mapping and Business Requirement Mapping for Data Migration of multi lingual data from various legacy systems from different European Countries.
  • Worked with Ford business team to collect functional requirements for Data Conversation/ Migration and translate those requirements into technical solutions for Siebel CRM application.
  • Facilitate meetings with the business and technical teams to gather necessary requirements related to Data Migration.
  • Developed Procedures, Functions, PL/SQL scripts to migrate complex data structure from difference source to Siebel Application database based upon the business logics.
  • Lead Offshore Siebel development team from Ford Development center, India.
  • Configuration of Siebel Call Center 7.5.3 Application using Siebel tools 7.5.3 in multi lingual support.
  • Prepared SQL*Plus data summary report from integrated system to monitor the daily data loading process.
  • Developed Shell scripts and SQL control files to load data through SQL Loader.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
  • Involved in the creation and modification of different PL/SQL object like Packages, Stored Procedures.
  • Performed unit testing for the scripts.
  • Accomplishments in excess of Requirements:
    • Responsible for the fixation of the errors in data by utilizing the GUI interface of application and SQL scripting.
    • Migrated data successfully from various legacy systems from different European Countries databases into a Single Oracle database in Siebel CRM Application.
    • Migrated multilingual data into an Oracle tables.
    • Migrated millions of attachments and 10 years historical data into single Siebel Application.
    • Lead Offshore Siebel development team.
    • Provided Oracle technical support to developers and user communities.
    Environment: Oracle 9i - Sun Solaris - SQL&PL/SQL - SQL*Loader - Siebel eAutomotive Call Center - MS Project

Developed Shell,

Mar 2004May 2004


Requirements fulfilled:
  • Developed Data Migration and Conversion process between different sources and target CRM Oracle database.
  • Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, Dependency documents.
  • Developed Shell scripts and SQL control files to load data through SQL Loader.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
  • Developed UNIX shell scripts and PL/SQL script to migrate complex data structure from difference source to Siebel Application database.
  • Accomplishments in excess of Requirements:
    • Provided Oracle technical support to developers and user communities.
    Environment: Oracle 9i - Sun Solaris - SQL&PL/SQL, SQL*Loader - Siebel eFinance 7.52 - AutoSys

CIGNA, USA,

Jan 2004Mar 2004


Requirements fulfilled:
  • Developed Data Migration and Conversion process between different sources and target CRM Oracle database.
  • Involved in creating Specification Documents, Mapping documents, Data Flow Diagrams, Dependency documents.
  • Developed Complex SQL queries using various joins and developed various dynamic SQL's thorough out the projects.
  • Developed T-SQL script, Procedures and DTS Packages to migrate complex data structure from difference source to Siebel Application database.
Environment: MS SQL Server 2000/Windows 2000 Server - TSQL - Siebel eFinance 7.52 - MS Access

Siebel EIM / Data Migration Consultant

Telstra Corp, Melbourne, Australia,

Oct 2003Jan 2004


Requirements fulfilled:
  • Developed Data Migration and Conversion process between different sources and target CRM Oracle database.
  • Creating and maintain the development and Test environment Oracle Database.
  • Create Oracle users and assign roles.
  • Developed PL/SQL script, Procedures to validate the data integration between the legacy and Oracle tables.
Environment: Oracle 9i - Sun Solaris - SQL&PL/SQL, SQL*Loader - Siebel 7.5.3 eCommunication

Siebel EIM / Data Migration Consultant

GSK, Saudi Arabia,

Jun 2003Sep 2003


Requirements fulfilled:
  • Involved in creating Specification Documents, Mapping documents
  • Developed Complex SQL queries using various joins to convert the MS Access data into MS SQL Server database.
  • Developed T-SQL script, Procedures and MTS Packages to migrate complex data structure from difference source to Siebel Application database.
  • Accomplishments in excess of Requirements:
    • Developed successful data migration process from different source into target database..
    • Provided Oracle technical support to developers and user communities.
    Environment: MS SQL Server 2000 - TSQL - Siebel 7.5.3 ePharma Application - MS Access

Team Leader

Vertex System Ltd, Chennai, Tamil Nadu

Jan 2000Apr 2003

Team Lead, DBA and DB Designer

Vertex System Ltd, Chennai, Tamil Nadu

Jan 2000Apr 2003

Accomplishments in excess of Requirements
  • Successfully implemented the project in Berlin, Germany and India.
  • Developed and implemented ERP Application packages.
  • Created complex backend SQL and procedures in ERP application
  • Lead a team of 6 developers, assigned, advised and analyzed work.
  • Involved in system analysis, Data Modeling and Application Design using Erwin/Case Studio tool.
  • Prepared FSD and PSD documents, and database designing
Environment: Oracle 8i - MS SQL Server 2000 - TSQL - MS Visual Basic - Erwin - Case Studio - MS Office - MS Project

Oracle Developer

Giga Byte Information Systems, Chennai, Tamil Nadu

Feb 1997Dec 1999

PROJECT SUMMERY PROFILE

Oracle Programmer

Giga Byte Information Systems, Chennai, Tamil Nadu

Feb 1997Dec 1999


Accomplishments in excess of Requirements:
  • Worked as Programmer in various projects, including coding and creating backend Procedures and Triggers.

Education

P.G Dip in Mgt & Industrial Relationship

Annamalai University,

1996

Bachelors in Science

Loyola Collage, Madras University, Chennai, India, Chennai, Tamil Nadu

19881991

Additional Information

  • Over 14+ year of IT and dynamic knowledge in fundamentals of RDBMS, Client Server Concepts, Data Modeling, Data Migration, PL/SQL Development, Testing process and Oracle CRM packages.
  • Strong in Database Architecture, Database Development, and Data Modeling.
  • Extensive work experience in SQL and PL/SQL by writing Stored Procedures, Functions, Packages and Triggers in Oracle 10g, Oracle 9i, Oracle 8i databases.
  • Strong in ETL Development and Data Integration / Data Migration using PL/SQL and SQL*Loader; mapping development utilizing a defined project methodology and internal standards.
  • Experienced in Dos batch programming and UNIX/Linux shell programming
  • Experienced in Database Optimization by making use of various Performance Tuning techniques.
  • Experience with data flow diagrams, data dictionary techniques, Entity relation modeling and design techniques, database normalization theory.
  • Very good knowledge and experience in using Oracle in-built packages like UTL_FILE, UTL_TCP etc.
  • Experienced in generating Reports from oracle tables using PL/SQL and SQL*Plus Report format.
  • Experienced in writing complex SQL queries, understanding requirements, writing functional specs, writing test specs and plans.
  • Team leadership, Project Management and coordination and development cycle organization.
  • Siebel Architecture and Data Model, Design and Development including Business Modeling, Requirements Gathering, Analysis, Configuration, Data Migration, Testing, Administration and Deployment for Siebel Enterprise.
  • Customer Relationship Management (CRM) with over 7+ years of experience in creating and implementing eBusiness solutions, utilize Siebel CRM v7.x, 8.x products.
  • Subject Matter Expert (SME) in Data Integration using Siebel Enterprise Integration Manager (EIM).
  • Worked with and lead global teams and in both Regulated and Non Regulated Industries.
  • Extensively worked as a Techno-Functional consultant in USA, UK, Germany and Australia, providing CRM solution with excellent business domain experience in CRM Application (Siebel ePharma, Siebel eCommunication, Siebel Call Center, Siebel 7.7 eConsumer Goods, Siebel ePublic Sector and Siebel eFinance Applications).
  • Siebel 7.5 Certified Consultant, Siebel 7.7 Certified Consultant and Siebel Customer Certified Consultant.
  • IBM Certified Cognos 8 BI Data Warehouse Developer
  • Having Oracle BI Architect experience as Siebel Analytics Functional Consultant.
  • Deep understanding of Information Technology Software Development Life Cycle (SDLC) methodology and Project Management principles.
  • Excellent problem solving skills with strong technical background having the ability to meet deadlines, work under pressure and quickly master new technologies and skills. Multitasked, team player, responsible, quick learner, result-oriented.
Resume Builder | Resume Templates | Resume Examples | About Us | Privacy Policy | Terms of Use | Help Articles | Contact Us
Super-Resume.com © 2013-2017