Professional Objective: Seeking an ETL / Data Analyst /Modeler role.

General Experience / Background

Sr. Oracle DBA/ ETL Developer providing support for production databases / development / test environments

• Demonstrated pragmatic execution of technology projects with critical timelines
• Ability to multi-task and meet strict deadlines and learn new concepts and technologies
• Databases - Oracle. Knowledge of MySQL and MS SQL servers
• Oracle tools Designer, Grid, SQL Developer and Quest Spotlight,
• Development Tools - Toad and SQL Developer
• Modeling Tools - Toad data modeler, CA Erwin r7
• ETL Tools - Ab Initio
• BI - OBIEE
• Scripting - Unix and Perl
• Languages - PL/SQL
• Software methodologies Agile, Waterfall and RAD
• ERP applications PRISM/CMS and STARS
• Big Data - Knowledge of hadoop core components HDFS / MapReduce processing
• Environments LINUX, HP UNIX, SOLARIS and MS Windows
• PROFESSIONAL EXPERIENCE Confidential DATA Analyst Supporting a SaaS-based Integrated Clinical Research Suite For clinical trials from Phase 1 through regulatory submission and post-approval monitoring
• Install / Configure / tune Oracle databases 10G/11G on Linux / Windows platforms
• Perform backup and recovery of databases
• Develop best practices for naming standard conventions and coding practices to ensure consistency of data models.
• Evaluate data models and physical databases of existing systems and legacy systems and presented at meetings - making recommendations for change to facilitate performance improvements in data access.
• Using Erwin - created logical physical data models and ETL architecture in collaboration with Business Analyst for OLTP and Data Marts. Types of models created - dimensional modeling - star schema / OLTP 3NF
• Performed data mappings of source and target systems and developed procedures for ETL process
• Validate business data objects for accuracy and completeness.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Performed database maintenance of business processes such as code for maintaining security on database level.
• Provided support for and worked with development and infrastructure teams to ensure code releases meet Oracle security standards.
• Created materialized views for data replication in distributed environments.
• Partitioned large Tables using range partition technique.
• Performed analysis of requirements and follow the SDLC standards to implement the requested changes
• Developed Oracle SQL scripts and PLSQL functions, procedures and packages
• Created and maintained of Materialized View scripts to aggregate data
• Created Test plan and Test scripts, unit and integration testing, developing and maintaining the test results
• Performed maintenance/enhancement of ETL mappings, work-flows, processes for all work streams
• Gather and analyze business reporting requirements from end users and translate them into reporting designs.
• Provide BI data architecture and data model design, configuration, development, deployment.
• Participate in all phases of the BI software development life cycle including business analysis and technical design of BI data models, multidimensional metadata layers, query objects create and monitor , and ETL processes development of the reports and report templates, prototyping, testing and deployment.
• Troubleshoot BI related issues such as performance, data integrity, user access, security, and report delivery.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Confidential

Snr Application DBA/ Modeler

• Design, develop, install and administer Oracle 10g
• Using Erwin design and support OLTP / Data warehousing environment
• Identified source systems, their connectivity, related tables and fields and ensure data suitability for mapping
• Engineering of legacy systems to derive physical models for further analysis and work
• Analyze business/functional requirements to derive logical models
• Analyze data-related and system integration opportunities and challenges and make recommendations
• Addressed issues involving data mapping / cleansing on source and target systems
• Perform re-design of legacy systems
• Worked with cross-functional teams and prepared detailed design documents for production phase of current customer database application
• Participate in review of models performing presentations
• Plan and implement partitioning, replication, backup and recovery of the Oracle databases performance
• Perform capacity planning and implement database security applying hardening rules and patching
• Monitor/perform ongoing tuning of the database instances and capacity planning
• Troubleshoot problems regarding the databases, applications and development tools
• Perform data analysis and mapping of source/target databases
• Perform data extraction and transformation of data
• Write scripts for data loads and updates

Confidential

Database Analyst PRIZM

• Install, configure, monitor and tuned Oracle databases in VMWare Linux / windows environments with a focus on resource sharing and its impact on performance. Also performed capacity planning /implement database security
• Run AWR / ADDM / ASH / Trace reports for analysis and perform tuning based on results
• Install / configure / maintain Microsoft IIS server and Component Object Model COM services applications and providee 3rd level support to customers using ERP PRIZM product

Confidential

Snr. Data Modeler / ETL Tester / DBA

• Identified source systems, their connectivity, related tables and fields and ensure data suitability for mapping
• Design and support OLTP / Data warehousing environment
• Analyze business/functional requirements to derive logical models
• Analyze data-related and system integration opportunities and challenges and make recommendations
• Create logical physical data models using ERWIN on OLTP / Data marts.
• Used SQL Developer Data Modeling tools on other projects to perform modeling functions.
• Worked closely with development teams generating designs for schemas and performed reverse engineering on legacy systems for review and generated and maintained new models for new applications. Also performed reverse engineering on as needed basis for model maintenance.
• Maintain ETL architecture in collaboration with DBA, Business Analyst, and developers to support the standardization of facts and dimensions.
• Develop data mappings specifications capturing business rules and logic a common data dictionary for business
• Developed design of exception handling and data cleansing procedures and business transformation rules logic
• Addressed issues involving data mapping / cleansing on source and target systems
• Perform re-design of legacy systems
• Implement change management and version control using ClearCase and ClearQuest
• Install, configure and tune Oracle databases and implement capacity planning.
• Perform capacity planning and implement database security applying hardening rules, CPUs and PSUs
• Troubleshoot and resolve database related issues using Grid and Quest Spotlight in RAC environments
• Run AWR / ADDM / ASH / Trace reports for analysis and perform tuning based on results
• Implementing database security through Database Vault
• Partitioned large Tables using range partition technique.
• Worked extensively on Ref Cursor, External Tables and Collections..
• Performed ETL tasks involving techniques involving mapping, transforming and loading of data followed by data analysis and generating reports..

Confidential

GBS IAS Snr Applications Architect

• Design, develop, install and administer Oracle 10g
• Evaluate data models and physical databases for variances and discrepancies..
• Implemented Slowly Changing Dimensions - Type I II in Dimension tables as per the requirements.
• Involved in all phases of the SDLC Software Development Life Cycle from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Translate business requirements into flexible and scalable data model that represent business goals and objectives
• Perform source data profiling to ensure data quality and conduct data quality audits to maintain data integrity
• Create logical physical data models and ETL architecture in collaboration with DBA, Business Analyst, and ETL developers to support the standardization of facts and dimensions.
• Develop data mappings specifications capturing business rules and logic a common data dictionary for business
• Developed design of exception handling and data cleansing procedures and business transformation rules logic
• Evaluate query plans to improve performance
• Developed Complex database objects: Created Packages / standalone Procedures and Functions to assist in migration of legacy applications to Oracle hosted environment for clinical drug research.
• Implement Triggers, SQL and PL/SQL, DB maintenance of business processes.
• Enhance ETL process through tuning, scheduling and exception-handling routines.
• Database Query Optimization and I/O tuning techniques have been used for performance enhancements.
• Developed graphs to extract Historical and Incremental Data.
• Responsible for extracting daily text files from ftp server and historical data from client sources, cleansing the data and applying transformation rules and loading to staging area.
• Performed analysis, Design, Development, Implementation, Deployment and maintenance of Business Intelligence applications - Business Objects XI.
• Participate in peer reviews