Programmer Analyst Resume
2.00/5 (Submit Your Rating)
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
