Data Developer
Resume:
SUDHIR R
PROFESSIONAL EXPERIENCE
• More than 12 years of experience in all phases of Software Development Life Cycle (SDLC).
Involved in delivering applications, systems analysis, design, and creation of decision support
systems (DSS) utilizing DSS tool suites. Integrate and administer applications such that they
meet organization requirements defined by business needs, SLAs, and IT governance
policies.
More than 5 years of experience to provide architecture design, which includes logical and
physical design of data warehouse, data marts, staging area, etc. Provide technical expertise for
data warehousing, OLAP technology, and data management including data extraction,
transformation and loading processes (ETL).
Develop applications, implement, integrate and administer applications such that they meet
organization requirements defined by business needs, SLAs, and IT governance policies.
• Experience with various architectural and methodological approaches in BI infrastructure
development, including star-schema modeling, ODS development, conceptual and logical
modeling, control table data management and rapid-iteration development.
• Certified Oracle/Developer 2000 Programmer from Brain Bench
TECHNICAL SKILLS
OPERATING SYSTEMS Sun Solaris 2.7/2.7, HP-Unix, Windows
XP/2000/2003/Advance Server
RDBMS/DBMS ORACLE 10g/9i/8i/7.x, DB2, SQL Server 7.0,
MS-Access, IDMS
DATABASE EXPERIENCE Handling Oracle Installation and Configuration,
Migration, Partitioning, Tuning, User/Space
management, Backup/recovery techniques,
SQL*Net configuration, SQL Loader, Export,
Import
DBA TOOLS OEM (Oracle Enterprise Manager), TOAD,
SQL Lab, SQL*Navigator, SQL Developer.
ETL/DATA MODELING/ DATA MIGRATION Informatica, OWB (Oracle Warehouse
TOOLS Builder), Pentaho, ERWIN, VISIO, ER/Studio
GUI TOOLS Oracle Developer 2000 (4.5 - 9i)
REPORTING TOOLS Business Objects XI, COGNOS, Crystal
Reports, Developer 2000 (Reports),
WEB TECHNOLOGIES HTML, ASP
WEB SERVERS IIS, Oracle 9iAS
OTHER SKILLS Rational Tools, Clear Case, Clear Quest,
Autosys
Project Details
VODAFONE (AUG 08 – TILLDATE)
Reston, VA
Role: Data Architect
• Provided technical expertise for data warehousing, OLAP technology, data management, data
extraction, transformation and loading process (ETL)
Configured OLAP to employ and perform a multidimensional analysis of business data and
provide the capability for complex calculations, trend analysis, and sophisticated data model and
allowing for complex analytical and ad-hoc queries with a rapid execution time
Design and Implement ETL (Extract, Transform and Load) BO Data Integrator / Pentaho handling
large amount of data. Creating Reports using Business Objects Web
• Proactively identify opportunities to improve the quality, scalability or usability of data warehouse
applications
• Analyzed and determined information needs and elements, data relationships and attributes, data
flow and storage requirements, as well as data output and reporting capabilities
Familiarity with telecommunications based data models and third party databases
Environment: Oracle 10G, SQL-Server, Sybase, Informatica 8.1, Pentaho (Data Integrator/Kettle),
Business Object XIR2, ERWIN 7.1, Windows 2003, XP, SQL and PL/SQL.
WSSC (MAY 07 – JULY 08)
Laurel, MD
Role: Senior Corporate Reporting & Document Management Analyst
• Create and test backup and recovery processes for all TDS, ODS and Production environments.
Test, implement, and integrate DSS reports and make modifications as required and provide
data warehouse architecture design, which includes logical and physical design of data
warehouse, data marts, staging area, etc.
Perform tasks relating to data extraction, data scrubbing, data transformation, maintenance of
metadata and data dictionaries.
• Define metadata standards for the data warehouse and direct the data warehouse meta data
capture and access effort.
Create logical universes and work with OLAP reporting technologies.
• Work as BI developer and SQL developer to deliver the appropriate BI solutions for the
businesses requirements.
• Provide performance analysis & tuning to ensure DSS software is working to enhance the
interaction between user applications and the databases.
Provide technical expertise for data warehousing, OLAP technology, and data management
including data extraction, transformation and loading processes (ETL).
Environment: Oracle 10G, Oracle Financials, SQL-Server, IDMS, Business Object XI, Crystal
Reports XI-8.5, Informatica 8.1.1, ERWIN 7.1, Linux, Windows 2003, XP, SQL and PL/SQL.
FREDDIE MAC (APR 06 – APR 07)
Mclean, VA
ROLE: Data Architect
• Designed, constructed, modified, integrated, implemented and tested data models and database
management systems in OLAP system
• Define technical requirements for the data warehouse and recommend/select data warehouse
technologies (e.g., ETL, DBMS, Data Quality, BI)
• Define and direct the information access, delivery effort and implementation of security
requirements for the data warehouse.
• Responsible for data modeling and participated in data acquisition and access analysis and
design, and archive, recovery, and load strategy design and implementation.
• Published standards and procedures for data analysis and design activities.
Coordinated with Operational Data Store (ODS) and Corporate Data Warehouse (CDW) data
administrators to determine associated changes to the Integrated Data Model.
Environment: AIX, UNIX, Windows 2000, DB2 8, Oracle10G, ERWIN, Clear Case and Clear
Quest
LANCOME (OCT 05 – MAR 06)
New York, NY
ROLE: Database Consultant
• Owns the enterprise logical model, defines standards, drives consolidation of redundant data,
enforces the strategic vision through data models and performs data analyst and data
modeling roles for highly complex or critical projects
Performs the data analysis activities to capture data requirements clearly, completely and
correctly, and represent them in a formal and visual way through the data models.
• Fine-tuning of SQL queries and views by passing hints and analyzing them using plan_table
• Assist in the ETL development efforts, making sure that the business rules are implemented
correctly and clarifying issues as they arise. I often even participate in the testing efforts.
Needs to drive not only data modeling but also needs to make sure that data integration is based
on a common metadata framework and that the integrated data is presented to the business as
valid information." Other terms gleaned across responses include "holistic," "future," "politician,"
"long-term vision," and "enterprise information model."
Analyzes and determines information needs and elements, data relationships and attributes, data
flow and storage requirements, and data output and reporting capabilities.
Environment: LINUX, Windows 2003, Windows 2000, Oracle 10G/9i/8i, ERWIN and SQL
Navigator, Crystal Reports, OWB (Oracle Warehouse Builder), Oracle, SQL, PL/SQL and TOAD
SABER (APR 05 – Sep 05)
Salem, OR
ROLE: Datawarehouse Consultant
• Analyze and document the data received from each county and identified the relevant
data and complexities of the data.
• Install, Configure OWB development/QA environments for different state projects on
Windows and Install and setup OWB clients on developers desktops
Extract, transform, and load data (ETL) from heterogeneous state/county systems to new state
repository using Oracle Warehouse Builder 9.2/10g, UNIX script, and PL/SQL.
• Develop ETL mappings using OWB 9i/10g by Designing, creating, deploying and
execute process flows. Use Runtime audit browser for auditing the maps and
processflows
• Document and create internal QA packages by writing complex SQL and PL/SQL
sub-programs.
Environment: HP, Windows 2000, Oracle 10G, OWB (Oracle Warehouse Builder), Oracle, SQL,
PL/SQL, TOAD and ERWIN
PEROT SYSTEMS TSI (JUL 04 – MAR 05)
Bangalore, India.
ROLE: Data warehouse Consultant
• Performs the data analysis activities to capture data requirements clearly, completely and
correctly, and represent them in a formal and visual way through the data models.
Responsibilities include project management, developing best practices and repeatable
procedures for deploying databases, day-to-day operational activities including break/fix, space
management, backup and restore, replication management, performance monitoring and tuning.
Responsible for extracting data from source systems, transforming the data (i.e. standardizing,
cleaning, de duping, etc), and then loading and mapping the data into the corporate data
warehouse (CDW).
Establish database change control and versioning procedures and work with data architects and
developers to migrate database changes into test, acceptance, and production environments.
• Responsible for analyzing, solving and creating solutions to very complex performance tuning
issues and queries.
Environment: Sun Solaris, HP UNIX, Windows 2000, Oracle 9i/8i, ERWIN, VISIO, Autosys,
Timbuktu, Oracle, SQL, PL/SQL, Business Objects v5.1.7 (Designer, Supervisor, Broadcast
Agent), Cognosv6.5 (Impromptu, Transformer, power play) & Informatica.
Reliance (APR 03 – JUL 04)
GIMAPS
Reliance, India
ROLE: Technical Consultant
• Duties include database creation, database tuning/reorganization, SQL statement tuning, general
troubleshooting, performance monitoring, backup/recovery and security of production
database applications to ensure maximum availability and reliability.
• Design and create database schemas, Analyzes and determines information needs and
elements, data relationships and attributes, data flow and storage requirements
Design data modeling with data integration based on a common metadata framework and that the
integrated data is presented to the business as valid information for their long term vision and
meet the Enterprise Information Model of the company.
• Promoted physical sharing of databases.
Published data dictionaries that facilitate communication about all corporate business models
through the Meta Data Repository.
Environment: Windows 2000, Sun Solaris, UNIX, ERWIN, Oracle 8i/9i, OEM, TOAD, ER/Studio &
Crystal Reports.
EBS (electricity billing system)
Reliance Energy, India
ROLE: Technical Consultant
•Requirement Gathering, Analyzing and Designing according to the requirements.
•Implement data models and database designs, data access and table maintenance codes;
resolve database performance issues, database capacity issues, and other distributed data
issues. Maintain and utilize policies and procedures for ensuring the security and integrity of
the databases.
•Responsible for optimizing any processes, programs, and functions to improve data quality,
data security, and data consistency. Develop data collection and reporting applications using
Oracle 8i & 9i.
•Create and update the prescribed and necessary documentation (e.g. release notes,
Designer repository) during all phases of the projects for the modules assigned.
Support all areas of database development including table architecture, database optimization,
data import/export, data migration, production updates and rollout onto a live DB, Reporting, SQL
development, development of schema and scripts as needed for business application integration
and reporting.
Environment: Windows 2000, Solaris, UNIX, ERWIN, Xwindows, Oracle 8i/9i, Developer 2000
(Forms 6i & 9i, Reports), Crystal Reports, Oracle 9iAS, ER/Studio.
MARVELNET (MAY 00 – MAR 03)
etoursindia
Rath Tours & Travels, India.
ROLE: Senior Software Engineer
•Research new features and product capabilities and provide guidelines and procedures for
use as appropriate. Recommend process improvements and enhancements to policies,
standards and procedures.
Responsible for requirements analysis, design, development, testing, implementation, and
documentation of the system design, system configuration and test results.
Support all areas of database development including table architecture, database optimization,
data import/export, data migration, production updates and rollout onto a live DB, Reporting, SQL
development, development of schema and scripts as needed for business application integration
and reporting.
•Provide architectural design, oversight, direction, and review of all database schemas,
stored procedures, scripts and layout of all tables, storage, and optimizations across all
product lines, Responsible for coordinating between client and the development team.
Environment: Windows 2000, Oracle 8i, ASP, Flash, ERWIN, Adobe PhotoShop and Developer
Forms 6i & 5, Reports), IIS, ER/Studio
WINSONLINE
Mumbai, India
ROLE: Senior Software Engineer
•Migration from SQL Server 7.1 to Oracle 8.
Altering, modifying and creating tables, tablespaces, indexes and other database objects
Fine Tuned the SQL queries using hints for maximum efficiency and performance.
Created Stored Procedures and Functions to call various oracle developer modules.
Environment: Windows NT, Oracle 7.X-8, SQL Server 7.1 & Developer 2000 (Forms 5 & Reports)
Practice Enchancer (AUG 98 – APR 00)
Valuehealthcare, Mumbai
ROLE: Senior Developer
•Create and implement PL/SQL packages, stored procedures, forms, triggers, tables and
views. Optimize code performance by analyzing indexes, joins and views.
Recommend security models in Oracle, Develop Oracle forms.
Altering, Modifying and Creating tables, tablespaces, rollback segments, partitions, indexes and
other database objects, created database triggers for data security.
Statistical reviews, Integration testing and Acceptance testing, Building Program Units, Standard
Libraries, Property Classes, Visual Attributes, tab canvases, Standard toolbar in Forms.
Create standard Error messages specific to application that made the application more use
friendly, Preparing test plans and testing Units based on test plans and perform System Testing,
Preparing Implementation Documentation and user support documents
Environment: WinNT, ERWIN, Oracle 8 & Developer (Forms 4.5 & Reports)
PATHOLOGICAL LABORATORY (AUG 97 – JUL 98)
Dharwad, India
ROLE: Developer
• Designed, Developed, Tested and Maintenance of the Application.
Solely responsible for implementation of the application.
• Involved in developing logic by writing Stored Procedures and Functions.
Environment: Windows 95, ORACLE 7.3 and Developer (Forms 4.5 & Reports)
EDUCATION
• Executive MBA (Master in Business Administration) from Canadian School of
Management
• B.S. in Computer-Science
Contact this candidate