We provide IT Staff Augmentation Services!

Senior Business Intelligence, Software Engineer Resume

5.00/5 (Submit Your Rating)

Canonsburg, PennsylvaniA

Hire Now

SUMMARY

  • Database / Business Intelligence Developer with progressive experience in designing dimensional data models, developing database and semantic layer structures, and creating business analytics reports.
  • Created data marts for public and private sector industries using a multitude of Data Modeling, Semantic Layer Modeling, ETL, and reporting tools.
  • Experienced in all phases of the Software Development Life Cycle (requirements analysis, design, development, testing, training, and maintenance) using Waterfall and Agile development methodologies. Held clearances, including Secret and Top Secret.

TECHNICAL SKILLS

  • Oracle10g: Java Programming, Oracle10g: Build J2EE Applications, Oracle9i: Build J2EE Applications, OAS Build Web Forms with PL/SQL, Oracle9i Database Administration Fundamentals, Oracle8 Database Administration, Oracle7 Database Administration, Oracle Designer/2000, Oracle Developer/2000

PROFESSIONAL EXPERIENCE

Confidential, Canonsburg, Pennsylvania

Senior Business Intelligence, Software Engineer

Responsibilities:

  • Designed and developed data marts which house external marketing data loaded into SAP HANA via Informatica. Developed SQLScript procedures and calculation views to combine data from marketing data tables with SAP master data, and created BusinessObjects universes on the views. Reduced reporting time 10 fold.
  • Built combined SAP HANA and BW data warehouse which houses French and Portugese Sales, Marketing, and Financial data from various source systems. Developed Project Plan, created Architecture Diagrams using ERwin and Visio, and led team of developers on backend and semantic layer development. Created composite providers to combine BW and native HANA data for reporting.
  • Designed and led team of developers on SAP HANA implementation of marketing tool using Scrum methodology (Agile Framework). Built Analytic Views, Calculation Views, and Decision Tables to determine which pharmacies were most likely to have specified Mylan product within radius of given location, then returned statuses back to Mobile application via WebMethods using OData Service in JSON format.
  • Consolidated several MS SQL Server databases into a single SQL Server database after the acquisition of Agila. Reversed engineered the databases and designed new database using Erwin Data Modeler. Created reporting layer via BusinessObjects Universes and Web Intelligence reports.
  • Created Business Intelligence Data Mart in SAP BW for storage and retrieval of Procurement information; developed dimensional data model using ERwin Data Modeler; developed ETL and built DataStores & Cubes for reporting via BusinessObjects.
  • Developed Oracle PL/SQL functions and procedures, and created BusinessObjects universes and Web Intelligence reports for organization and retrieval of Chargeback and Rebate information stored in the Oracle 11g RDBMS data warehouse. Modified Informatica Data Flows and Work Flows for the CARS to EDW daily loads.

Confidential, Reston, Virginia principal consultant

Responsibilities:

  • Federal Drug Administration (FDA) - Developed Relational Database storage and retrieval system for FDA using Developer6i; created forms, reports, stored procedures, functions, and database triggers; improved performance of forms and reports by tuning SQL queries and adding indexes as needed.
  • Department of Housing and Urban Development (HUD) - Partnered with DBAs and End-users to redesign Teradata database system into Oracle database system; wrote ETL scripts in PL/SQL to scrub and move data into Oracle database, resulting in better quality data for HUD.
  • Livermore Laboratories - Designed and produced Relational Data Model using Oracle's Designer6 product. Developed forms and reports using Developer6 (Forms 6.0 and Reports 6.0). Trained Livermore Laboratories' developers on Designer and Developer products.
  • Special Olympics - Configured Special Olympics database, including installation of Oracle Software, creation of databases, tablespaces, tables, rollback segments, users, roles, etc. Initialized backups and tested recoveries; performed exports and imports; granted privileges; optimized SQL queries; tuned the database; and performed other DBA activities.
  • General Services Administration (GSA) - Reverse engineered Access tables into Entity Relationship Diagram using Oracle's Designer/2000. Developed table-based interface program using Dynamic PL/SQL and Oracle Forms 5.0; allowing user to add any number of interfaces without having to modify code, only insertions into a table are required to add new interface.

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship