We provide IT Staff Augmentation Services!

Programmer Analyst Resume

SUMMARY:

  • Database Architecture and Modeling
  • ETL (Data Extraction Transformation & Loading)
  • Excellent presentation and communication skills
  • MS Access Application Development
  • Data Warehouse (Development and Design)
  • Analysis/ Pivot table Construction
  • Web Page Development
  • Mobile Device Application Development
  • Automation of Data loads and Reports

TECHNICAL SKILLS:

Microsoft Products: (Office, Access, Outlook, Excel, Word, Power Point) / SAGENT Solution (Design Studio, Admin, Automation, WebLink, Analysis, Reports) / Platinum ERwin ERX 3.5.2 / ORACLE / Informix / SQL Server / VB (Visual Basic / Object Oriented Program Development) / Visual Studio (Front Page - HTML) / ADO / ODBC / OLE DB / SQL+ Plus and PL/SQL / Microsoft Interdev (XML and ASP) / DB2 / QMF/ Extra Personal Client / Pendragon Forms 3.2 / Automate 4-10 / Cognos Impromptu / Crystal Reports / QlikView and NPrinting / Essbase / FREVVO

PROFESSIONAL EXPERIENCE:

Confidential

Programmer Analyst

Responsibilities:

  • Create and maintain automatic ETL processes to update and aggregate data 7 days a week
  • Develop and maintain over 200 Access Databases with front end applications
  • Design and build new database environments for Data Warehousing
  • Develop Web based end user forms that are compatible with Android and Apple (iOS)
  • Provide self-service GUI query tools for non-technical users to create on demand reports
  • Automate processes for distribution of over 165 daily reports using Automate 9.0
  • Deliver Ad-Hoc reports through Excel Pivot tables, Access Reports, and Cognos Impromptu, combining data from DB2, ORACLE, Teradata, Informix (EXE) SQL Server and MS Access

Confidential

Senior Consultant

Responsibilities:

  • Designed, built and delivered custom Data Warehouse solutions
  • Developed ETL plans to consolidate information from multiple legacy systems into new environments
  • Developed custom reports and analysis cubes (Pivot Tables)
  • Customized web pages for electronic distribution of information
  • Managed scope of agreed upon deliverables
  • Accounted for time and expenses while traveling to customer sites
  • Met or exceeded time and material deadlines
  • Generated comprehensive documentation of development work for knowledge transfer

Hire Now