herohas.blogg.se - Toad data modeler resume

#TOAD DATA MODELER RESUME PATCH#
#TOAD DATA MODELER RESUME PROFESSIONAL#

#TOAD DATA MODELER RESUME PATCH#

Upgrades of database from 9i to 10gR2, Database Patch up gradation.

Expertise in Oracle 11i, R12 Apps Installations, applying Patch Sets, System Administration, Cloning, Database and applications guard configuration.

X years of industry experience, including X yrs of Oracle DBA/Oracle Applications DBA Experience.

Designed release management procedures for Development.Designed production database maintenance schema.Worked on optimizing SQL Server performance, monitoring and queries tuning using Microsoft tools Performance Monitor.Developed over 1000 T-SQL stored procedures, functions, triggers and views.Converted logical model into physical model.Created logical model, including Entity-Relationship diagram.Designing automated procedures using C#, VBScript, and autosys.Designing and creating ETL and Integration Services packages.Designing, debugging, and optimizing T-SQL and MDX queries, T-SQL and CLR stored procedures, functions, views and dynamic queries for SQL Server, OLAP Server.Creating logical and physical model for relational and multidimensional databases.

Developing Relational, OLAP and Data Mining projects.Improving mathematical model for Fixed Income Performance Attribution system.Designing and creating SSIS packages to ETL data from databases.Developing T-SQL stored procedures, functions, triggers, views.

Creating logical and physical model for analytical databases.

Designing and creating SSIS packages to extract, transform and load data from mainframe files and ORACLE database.

Developing T-SQL and C# stored procedures, functions, triggers, views.

Design datamart architecture for Business Online Reporting System.

#TOAD DATA MODELER RESUME PROFESSIONAL#

Professional Experience Client: Xyz Company, Mumbai July 2009 – Till now

Loaded the data using the SQL loader, Imports & UTL files based on file formats.

Load the data from MS Excel to Oracle Table and Oracle table to MS Excel.

Worked with team on customizing the abilities of Crystal Enterprise such as exporting, previewing, printing and emailing reports.

Developed complex reports: multi-functioned, leveled and grouped, summary functionality in main reports providing detailed drill down through On Demand Sub-reports, dynamic link labeling, complex functions, cross-tabs, charts, shared variables, imported parameters and record sets from stored procedures, conditionally suppressed sections, error handling/messaging, clean and attractive designs, user friendly with instructional ToolTips.

Worked heavily with relationship database models, schemas & entity-relationship diagrams (ERMs) to create technical/system design documents.

Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain, Trace, and Stored Outlines.

Created Oracle Tables, Views, Constrains, Synonyms, Sequences.

Agile, analyst 9.x, API, AS400, auditing, automation, big data, Business Analyst, BI, Business Objects, Cisco, COBOL, interpersonal skills, CRM, client, data analysis, Data Management, data migration, Data Modeling, data warehouse, Databases, database, delivery, documentation, enterprise resource planning, Erwin 4.0, Erwin, ETL, features, Functional, Hub 9.x, Human resource, DB2, Image, IMS, Informatica 8.x, Informatica 8.6.1, Informatica 9.x, Informatica, insurance, inventory, Leadership, Linux, logistics, Director 9.x, Maestro, mainframe, meetings, access, MS Dynamics, Exchange, Exchange 9.1, Exchange 9.