Data warehousing Resume Profile

SUMMARY OF QUALIFICATIONS

Over 18 years of technical experience in OLTP and Data Warehousing environments.
Independent outside-the-box thinker well versed in but not limited to conventional theory and practice.
SQL Tuning expert with strong understanding of optimizer internals.
Solid experience with emphasis in Database Design and Oracle-based Applications development.
Oracle expert with strong PL/SQL development experience and DBA background.
Passion for solving hard data challenges.
Strong Information Delivery Background, including BI and Reporting.
Solid ETL experience using enterprise tools and custom-coded solutions.
Work closely with the business and BSAs to understand/question/negotiate requirements and to enforce clarity.
Client focus and timely delivery.
Strong training and mentoring experience.
Agile, Scrum, Waterfall and Hybrid SDLC methodologies.

TECHNICAL SKILLS SUMMARY

Languages:

DBMS Platforms:

OLAP/BI Platforms:

Software and Tools:

Data Modeling:

Administration:

Development:

ETL:

Reporting/BI:

Version Control:

O/S:

Project/Issues Mgmt:

Industry Experience:

SQL, PL/SQL, Unix Shell Scripting, Perl, Batch Scripting, XML, HTML, Java, C, Fortran

Oracle 7/8/8i/9i/10g/11g, MS SQL Server, Access, Sybase, RDBMS DB2/400

OBIEE,ORACLE, Microsoft, Jaspersoft, Tableau

Oracle Designer, Visio, ERwin

Oracle Enterprise Manager OEM , RedGate, SQL Server Management Studio, Control-M Jobs Manager

TOAD, PL/SQL Developer, SQL Developer, Oracle Forms

ODI, External Tables, GoldenGate, Oracle Warehouse Builder

SSRS, Jaspersoft, Oracle Reports, Oracle BI, Oracle Discoverer

Visual SourceSafe, PVCS, Subversion

MS-Windows, UNIX Solaris, HP-UX , Linux Red Hat

Microsoft SharePoint, Jira, Confluence, Wiki

Pharmaceutical, Healthcare, e- Marketing, Non-Profit, Travel, Logistics, Finance, Education

PROFESSIONAL EXPERIENCE

Confidential

Senior member of the DWH team responsible for Data Analysis, DB design, ETL processes development and Oracle DWH and Data Marts maintenance for Health Plans and PBMs Pharmacy Benefit Manager .
Delivered data solutions for Decision Support Portal Applications in heterogeneous environment containing Oracle and SQL Server databases and reporting platforms SSRS and Jaspersoft .
Designed and developed infrastructure solution that incorporates service-oriented data access layer, run-time data integration, and framework for code re-usability.
Data Mart and ETL design and development, hands-on database development and SQL tuning. Provided Client and Application Support.

Confidential

Provided data solution in high-performance automated transactional messages used for the email mobile marketing and online advertising display retargeting. Worked with the campaign managers and BAs to identify, clearly define and automate the highest performing campaigns in the customer lifecycle. Analyzed and optimized ETL processes for the trigger-based campaign driven by customer behavior or an event, part of the Precision Central technology platform. Provided application support in very large DB environment Oracle 10g on Linux Red Hat .

Confidential

Developed and implemented ETL procedures to load large datasets into the staging area, to validate the data by applying business rules, to download them into the target tables using Oracle Data Pump Utilities, SQL and PL/SQL.

TSF consulting, Freelance ETL development work

Analyzed existing systems and developed technical specifications, worked on existing Informatica Mappings to produce correct output, made adjustments in Data Model and SQL scripts to create and alter tables.

Confidential

Oracle 10g application developer working in PL/SQL, Forms and Reports. Responsible for designing architecture, coding database objects, creating database design, creating forms and reports to support enterprise application for the Educational Travel company. Developed new code standards, templates and re-usable components. Primary source of Oracle technical expertise within the IT Team. Consulted other teams on application data modeling and interfaces design. Advised Reporting Team on optimizing SQL queries and PL/SQL procedures.

Confidential

Designed, developed and enhanced Team Approach System interfaces utilizing Oracle9i with Oracle Forms 6i/Reports 6i for client-server application and Oracle10g with Oracle Forms 10g/Reports 10g for Web-based application. The system is used by major non-profit organizations such as American Diabetes Association, Alzheimer's Foundation and Public Broadcasting Stations in organizing and managing fundraising events and campaigns.
Participated in every stage of software development cycle, in particular: Conducted direct communication with the clients on defining system modules requirements Participated in general and functional design of enhancements Participated in database schema design and implementation Developed PL/SQL stored procedures, packages and triggers Designed and developed user interfaces and reports Developed code standards, templates and re-usable libraries Participated in Test Plans creation and assisted with QA testing Provided technical consultation for production deployment team.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship