We provide IT Staff Augmentation Services!

Senior Data Warehouse Consultant/dba Resume

Phoenix, AZ

SUMMARY:

  • Expertise in all versions of Oracle, MySQL, SQL Server, Vertica, PostgreSQL, Hadoop, and Unix systems administration. Proven problem solver/preventer in relational database systems, both OLTP and DSS. Advanced skills in data modeling, data mining, CRM, MDM, ETL, Excel programming, medical systems, financial systems, project management, systems analysis, software architecture, data architecture and system architecture
  • Extensive experience inBusinessIntelligenceSolutions & Data Warehousing in Retail, Healthcare, Financial Services, and Pharmaceutical domains.Strong noledge of the application ofbusinessintelligencetools and techniques to providebusinessinsight and create real value to the organization.
  • BusinessIntelligenceand Analytics.Leader inBusinessIntelligencestrategy formation and executive consultation and adoption of big data analytics.Winner of TDWI 2010 Best Practices in Data Warehousing andBusinessIntelligencefor Govt./Non - Profit Group.Expert in designing QlikView,BusinessObjects, Pentaho, MicroStrategy and Xcelsius Dashboards..
  • Lead designer of Capital Risk Management database, reports and dashboards for Glodman Sachs.
  • Project Manager agent analytics” dashboard incorporating actionable metrics for State Farm.BusinessObjects XI r2,3 and BI 4.0 implementer, trainer, universe designer for retail, healthcare, financial services, consumer goods, and pharma co. 's.Business Intelligence (BI) solutions, Master Data Management (MDM), Data Warehousing (DW), Microsoft BI, SSAS, SSRS, SSIS, BO, Informatica, Qlikview, Cognos, Crystal Reports, OBIEE, ODI, Data Stage, BPM, BSC, Predictive Analytics, KPI, Tableau, and Dashboards.

TECHNICAL SKILLS:

PROGRAMMING LANGUAGES: C, C++, All SQL versions, Java, Matlab, ASP.NET, VB, UNIX scripting, and others

HARDWARE SYSTEMS: IBM PC/XT/AT, AWS Cloud, Sun, Prime, DEC Alpha, HP, TI, Dell, NCR, and others.

OPERATING SYSTEMS: Solaris, AIX, Linux (any), HP-UX, Windows NT/XP/Vista/7.

DATABASE/KNOWLEDGE BASE SYSTEMS: Oracle 8i/9i/10g/11g/12c, MySQL 4/5.6, SQL Server 2000/05/08, Teradata, MongoDB, PostgreSQL, Teradata, DB2, PostgreSQL, Vertica, Netezza and others.

DATA WAREHOUSE/DATA MINING TOOLS: Informatica, Discoverant, Tableau, Brio, Talend, Hyperion, Corda, Microstrategy, Business Objects (BOBJ), Oracle Analytics(ETL, ERP, CRM, OBIEE), Data Integrator, SAS, SSIS, SSAS, SSRS, Parallel Data Warehouse, Excel, Star Schema, Snowflake, OLAP Cubes, Aggregate Navigation, Multi-Dimensional and others.

PROFESSIONAL EXPERIENCE:

Confidential, Phoenix, AZ

Senior Data Warehouse Consultant/DBA

Responsibilities:

  • Performance tuned SQL scripts and Informatica 9.5 mappings and workflows
  • Improved run times for many critical BI processes and ETL workflows
  • Provided guidance for data warehouse design and tuning methods
  • Used partitioning and parallel processing to improve process performance
  • Supported problem solving and ETL processes for Hawq/Hadoop database system
  • Supported DW migration from Greenplum DB to Hawq/Hadoop system
  • Worked collaboratively with Enterprise Data Warehouse team on design and development of conceptual, logical and physical data models to support Enterprise BI projects

Confidential, Los Angeles, CA

Senior Database Consultant/DBA

Responsibilities:

  • Created data models using Toad for implementing in MySQL 5.6
  • Installed MySQL and created 4 node Percona/Galera replication cluster
  • Installed and setup ScanBase for load balancing on the cluster
  • Demonstrated the cluster operations and ScanBase maintenance

Confidential, Wayne, PA

Senior Database Consultant// Project Manger

Responsibilities:

  • Designed and implemented database schemas in Mysql, Vertica, and Mongo DB
  • Created and administered 12 development databases
  • Created data dictionaries and data models, using Lucidchart and Excel
  • Supported, administered, and tuned MySQL and Vertica databases on AWS Ubuntu
  • Created databases for CRM and retail transaction support
  • Provided DBA support and leadership for development team

Confidential, Sherman Oaks, CA

Senior Database Consultant/DBA

Responsibilities:

  • Solved problems in MySql 5.5 Databases, Stored Procedures, Backup, and data migration
  • Instituted Transaction Control into all production Stored Procedures
  • Created data dictionaries and data models, using Toad and MS Visio
  • Supported, Administered, and Tuned MySQL databases on Linux (RHEL)
  • Created databases for Financial Transaction Support
  • Led Team in Agile/SCRUM project management methods

Confidential, Phoenix, AZ

Senior Database Consultant/ Project Manager

Responsibilities:

  • Executed Proof of Concept for DB2 backup, restore, and suitability for Data Domain file systems usage
  • Performed analysis and verification of best practices in DB2 9.6/7, Oracle 10/11g, and SQL Server 2005/2008 databases
  • Setup and configured Oracle 11g EMCTL, RMAN, and Data Warehouse
  • Solved many problems in many different database systems
  • Led project, established requirements, use cases, and identified candidate products/vendors for new Enterprise ILM Archiving project
  • Utilized Toad for DB2, Sharepoint, Lynx, and Putty

Confidential, Fremont, CA

Senior Database Consultant

Responsibilities:

  • Setup RMAN backup system of NASA production and development databases in Oracle 10g and 11g.
  • Tuned SQL queries and solved problems in MySQL and PL/SQL.
  • Setup and used Zoho Application Manager for monitoring Linux based computers and Oracle databases.
  • Utilized Toad for DBA operations, data modeling and ETL processes.
  • Upgraded databases from 10g to 11g.
  • Mentored clients in RDBMS, RMAN, SharePoint, Advanced Queuing, MDM, and Data Guard concepts and usage.
  • Led project to installed Oracle 11g and load the database on a new Linux machine for production.

Confidential, Woodland Hills, CA

Senior Database Consultant/ Project Manager

Responsibilities:

  • Tuned, solved problems, debugged SQL, Java, and PL/SQL programs in Oracle 10/11g databases for financial applications.
  • Used Talend for ETL jobs and data migration.
  • Documented Talend operations and usage.
  • Administered SQL Server 2005/8 for security and agent job scheduling.
  • Used Toad for administering Oracle 10/11g databases to support tax applications.
  • Used and administered Perforce system for document control.
  • Utilized Mongo DB, PostgreSQL, Hadoop, HIVE, HBASE and NoSQL for ETL testing.

Confidential, Medford, OR

Senior Data Warehouse Architect - Consulting

Responsibilities:

  • Responsible for design, development, implementation and support of BI Infrastructure, Reporting and Analytical Applications including design and development of Enterprise Business Intelligence Portal.
  • Tuned, solved problems, and made performance improvements for data warehouses in SQL Server, and IBM DB2.
  • Provided recommendations for best practices and configurations for top performance, scalability, enterprise database monitoring, and MDM.
  • Optimized indexes and buffer pools in DB2 to support ETL and BI reporting.
  • Optimized parallel processes and memory use in SQL Server 2008 for an enterprise data warehouse, using SSIS, SSAS, SSRS, Parallel Data Warehouse, and Business Objects
  • Participated in developing Enterprise BI strategy including research, development and advice on systems and tools.
  • Led informational sessions to Senior Management and Enterprise users on company BI Strategy and Initiatives.
  • Participated in Enterprise Data Warehouse/ BI applications design, development and deployment while managing and guiding IT cross-functional teams, external resources and off shore resources.
  • Managed Team of BI Analysts and System Administrators, assigned projects tasks, conducted coaching and feedback discussions on an ongoing basis and prepared performance review.
  • Managed BI Projects activities and advised management of issue due to the resources availability including budget.
  • Developed Project Plans, Project Risk Assessments, Implementation Plans, produced project status reports, and Projects post implementation analysis.
  • Directed sessions to expand user’s hand-on expertise in Enterprise BI tools and applications.

Confidential, Westlake Village, CA

Senior Data Warehouse Architect

Responsibilities:

  • Tuned and solved problems in Oracle 10g databases and many SQL statements for a data warehouse project.
  • Supported Discoverant applications and automated conversion and migration operations with Korn shell scripts on Solaris 10.
  • Designed, tested and benchmarked the production database system.
  • Fully documented project database administration and designs for the system.
  • Performed all DBA functions using Toad and SQLPlus for DSS type databases

Confidential, Westlake Village, CA

Senior Database Architect

Responsibilities:

  • Solved many problems in SQL Server 2005/2008 for high transaction load OLTP systems and large scale DSS database systems.
  • Made changes dat achieved system stability and significant performance gains.
  • Developed and supported Oracle (8i, 9i, 10g, 11g) databases for security, RAC tuning, database creation, backup, recovery, and data migration.
  • Trained in Netezza database systems and administered 3 large systems in user setup, backup, tuning, migration, and access.
  • Supported Sharepoint and tuned databases and queries in MySQL systems

Confidential, Sherman Oaks, CA

Senior DBA, Data Warehouse Consultant, Senior Analyst

Responsibilities:

  • Administered Oracle 10g/11g (CRM, OBIEE), MySQL 5.1, and SQL Server 2005/8 for financial analysis, reporting and BI using Microstrategy 9 and SSIS/SSAS/SSRS/Excel including Streams Replication, indexing and partitioning.
  • Converted DataCom database to SQL Server 2008.
  • Led projects for data warehouses and CRM analysis using Business Objects, Agile methods, SQL Server, and Subversion for version control
  • Designed MDM development for multi-department company using Cognos.
  • Performed upgrade of Oracle database (2.5T) 10g to11g on Solaris 10.
  • Designed and implemented 3 Universes on Business Objects v10 and 11, and Tableau for reporting.
  • Administered Windows XP Pro and Red Hat Linux (Fedora 10).
  • Evaluated Corda, PostgreSQL, and Teradata v.12.0 for functionality.

Confidential, Los Angeles, CA

Senior Data Warehouse Consultant

Responsibilities:

  • Analyzed the existing systems and requirements for a new data warehouse project.
  • Designed and created the databases and universes using the Star Schema method, developed data models and ETL methods using Business Objects v10 (BOBJ) and DI.
  • Solved problems in SQL Server data warehouses involving the ETL, data, and views.
  • Supported and provided guidance for Oracle 10g DBA.
  • On Linux, AIX, Windows XP and Oracle 10g.

Confidential

Senior Database Administrator, Developer

Responsibilities:

  • Documented production systems in UML using Visio.
  • Load tested applications with Curl and SQL.
  • Converted 4 C programs (~2500 lines) to Matlab for implementation of SIFT based image recognition system.
  • Supported debugging and PostgreSQL database design.
  • All on Linux, Apple OS 10, VM Fusion (Windows XP) and Vista.

Confidential, Philadelphia, PA

Senior Database Consultant

Responsibilities:

  • Provided consulting and analysis of high concurrency database configurations including RAC and replication methods.
  • Developed trigger-based multi-master replication, and Streams Replication (with Advanced Queuing) systems.
  • All on Solaris 10 with Oracle 10g.
  • Installed, configured and patched Oracle on 4 Sun Sparc 2000 class systems for replication.
  • Utilized Excel, TOAD, PL/SQL, and UNIX scripting.

Confidential, Austin, TX

Senior Database Consultant

Responsibilities:

  • Provided support and guidance for Oracle database upgrades (from 9i to 10g), 10g grid control, import and export, tuning, db design and setup.
  • Developed Java wrapper to eliminate database passwords from UNIX shell scripts to enhance security.
  • All on Solaris 10.

Confidential, Torrance, CA

Senior Database Consultant

Responsibilities:

  • Setup benchmarking systems for Oracle 9.2 on Solaris with PL/SQL and shell scripts.
  • Administered Oracle data warehouses with Toad, Enterprise manager, SQLPlus, and Informatica.
  • Did troubleshooting, capacity planning using Excel, and performance tuning of ETL processes, SQL queries and data warehouses.
  • Developed methods for user monitoring and data security.
  • Upgraded Oracle databases from 9.2.0.2 to 9.2.0.8 and planned upgrades to 10g.
  • Supported data analysis and reporting with Microstrategy and Hyperion/Brio in financial systems.

Confidential, Agoura Hills, CA

Consultant, Senior Database Administrator, UNIX systems administrator

Responsibilities:

  • Setup and configured OS and Oracle 10g RAC on Red Hat Linux.
  • Programmed packages and stored procedures in Oracle 9i PL/SQL and UNIX scripts for installment plan fulfillment.
  • Tuned and provided algorithmic support for database operations in Oracle 9i OID and LDAP.
  • Optimized queries and loading systems for data warehousing and business intelligence.
  • Provided support and planning for replication of Oracle 10g OID systems.
  • Setup and maintained Oracle 10g RMAN backup systems and database synchronization methods.

Confidential, Torrance, CA

Senior Database Consultant

Responsibilities:

  • Designed and developed database systems for vehicle technical support.
  • Tuned SQL, PL/SQL and Java code.
  • Used Oracle Designer for ERD design and documentation maintenance.
  • Developed PL/SQL and Korn shell scripts for database loading, filtering and replication.
  • Tuned Oracle 9.2 database using StatsPack. Used Redwood tool for job scheduling. Supported development and test databases (up to 8 at a time) and one production system.
  • All on HP-UX and Windows XP.

Confidential, Downey, CA

Senior Database Consultant/Technical Writer

Responsibilities:

  • Developed documentation for and also did development for web based medical billing applications in Visual Basic .NET/ASP with SQL Server 2000, T-SQL, MS Visual Studio .NET, Visio, Excel, Framework, and FrontPage on Windows 2000/2003 servers.
  • Converted Dbase IV DB to SQL Server. Developed new clinical data models.
  • Corrected problems in HTML and developed web pages.
  • Documented and maintained new HIPAA-compliant system

Confidential, Downey, CA

Senior Database Consultant/Project Manager

Responsibilities:

  • Led project for development of web based medical billing applications using Visual Basic .NET/ASP with SQL Server 2000, T-SQL, MS Visual Studio .NET, Visio, Excel, Framework, and FrontPage on Windows 2000/2003 servers.
  • Mentored and supervised 4 developers and 2 medical coders.
  • Converted Dbase IV DB to SQL Server.
  • Developed new clinical data models.
  • As a Project Manager in collaboration with IT cross- functional teams implemented MMG SAP Business Objects technical infrastructure to create more stable and scaled environment including Enterprise Data Warehouse solution.
  • Led the development and execution of the BI strategy of retiring legacy Cypress/Zena and SSRS reporting systems.
  • As a Project Manager leading implementation of Qlikview BI infrastructure to support MMC initiative to develop Executive Dashboards Analytics and Center of Excellence Analytics.
  • Developed and implemented BI Group Change Management Policy, AD-hoc process, and worked collaboratively with cross-functional team members on establishing and delivering best practices and standards in BI development
  • Corrected problems in HTML and developed web pages.
  • Documented and maintained new HIPAA-compliant system

Hire Now