Database Analyst Resume Profile

Summary

Result-driven IT professional with years of diverse experience working in the pharmaceutical, insurance and banking industries. High interest and extended background in Business Intelligence development , Data Warehousing, Database Architecture, Data Analysis.

Areas of Expertise

Business Intelligence Development

Business/Process analysis

Data Warehouse Architecture

Data integrity/Data Quality Validation

Technical Documentation

New technologies implementation / training

Data Modeling , Data Mining, ETL

Database Administration

Project Management/Client Communication

Large Relational Database/Big data expertise

Technical Proficiencies

Analytics/CRM: Qlikview 10 IBM Cognos 10 Crystal Reports 2008 WebFocus Xcelsius 4.5 Toad Salesforce Business Objects 3.0 all Microsoft Office Application Embarcadero ER/Studio Trackwise 8.5 QMS
Languages: PL/SQL SQL Plus Oracle APEX Microsoft Office VBA
Databases: Oracle 11g, Microsoft SQL Server 2008 MS Access Sybase XBASE
Platforms: Microsoft Windows, Linux/Unix

Professional Experience

Confidential

Database Analyst/Programmer

Solely designed and developed company's Sales Data Warehouse based on consolidated the Marketing and Sales team business user's requirements from ERP and Chargeback system as sources. Created Data Warehouse Oracle database architecture using star schema design to accommodate necessary data structure.
Analyzed data flow and integration priorities and developed ETL Oracle stored procedures, triggers and materialized views to satisfy timely data availability. Designed Linux scripts and automated Data Warehouse ETL schedule and monitored ETL process to ensure no errors accurate data updates daily and weekly bases .
Developed and implemented Sales Data Analysis Enterprise solutions on IBM Cognos 10 Platform utilizing Framework Manager Data Mining and OLAP knowledge. Designed and implemented Report Studio reports and dashboards for Sales, Forecast and Hospitals Demographics data for companies Sales Force.
Designed User Training materials and instructions and provided initial and refreshment Sales and Marketing business users training. Provided COGNOS end-user training in both a one-on-one and classroom environment.
Compiled and maintained Sales Data Warehouse technical and user documentation including data dictionary reporting, logical, physical database diagrams.

Senior Software Engineer

Developed effective QlikView Financial Dashboard for used by Finance and Sales departments.
Performed duty of Application Database Administrator for Oracle and SQL Server Databases with responsibility for Oracle installation, schemas update, security roles maintenance, database space monitoring and performance tuning and query optimization.
Handled Oracle 10g database and client installation for company's manufacturing, scientific and financial application.
Performed complex programming tasks necessary to produce custom reports and maintain information files using Crystal Report XI and other various up-to-date report-writing tools such as Excelsius, WebFocus.
Responsible for the design and testing of program logic and integrates routines into completed programs using Visual Basic and Microsoft Access.

Principal Software Engineer

Performed administration, configuration and migration of Trackwise Workflows and Process Management System from IT prospective and maintain proper system Validation state.
Worked in collaboration with international team Germany on two year Trackwise implementation project and launched a reporting component of the project.
Completed decommissioning process for company's major computer systems which included design of the data extract tools, data quality validations and storage solution.

Confidential

System Analyst II

Involved in a database structure design and normalization for new stock options.
Analyzed and converted the complex data from three completely different software systems to bring the information to the unique layout usable for new-built stock option software, completed download data to Oracle database.
Developed extra-ordinary complex Participant Statement in Crystal Report 6 for a massive mailing.

Confidential

Programmer Analyst

Researched and determined ways to increase efficiency of the supported systems and program necessary changes.
Analyzed and modified in-house applications for Year 2000 compliance.
Converted existing DOS applications and data to Windows application using Visual Basic 5.0.
Provided fast and quality an application maintenance to satisfy client's needs.
Extensive experience in design and creation special reports and forms using various report writers and graphical software such as Crystal Report 5, Access 2.0, Visio Tech.
Prepared technical documentation for Claims and Underwriting applications.

Confidential

System Analyst I

Implemented different banking applications on DBASE III, IV and Clipper 5.2.
Responsible for LAN Administration on NOVELL 3.11.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship