Programmer Analyst Resume
3.00/5 (Submit Your Rating)
ChicagO
PROFESSIONAL SUMMARY:
- Ten plus years of experience in Database systems, with skills in developing
- Information systems using Oracle and Informatica Products.
COMPUTER SKILLS:
Skills: Oracle 10g/11g, SAP BODS, Informatica Power Center, OWB, Data Security, Toad DBA Suite, Toad Data Modeler, SQL Loader, SQL, PL/SQL, Confidential Data Quality Tools (QAS), Data Center Management, Amazon Web Services.
EXPERIENCE:
Programmer AnalystConfidential, Chicago
Responsibilities:
- Manage a remote team and develop various solutions for the real - estate industry.
- Designed and built data warehouse systems containing real estate related data in the Chicago land area
- Designed systems to handle multiple formats of large data sets from different sources and input them into an Oracle database using Informatica and other ETL tools.
- Developed and implemented various Mappings and Transformations using Informatica for the different stages of ETL process.
- Designed SQL and PL/SQL code for the Oracle Database.
- Implement a system to clean and process all addresses in the data warehouse using Confidential Address verification software.
- Designed and Implemented data warehousing projects that allow Chicago Title to gather real estate data from various sources and different platforms and port them into an Oracle Database (ETL programming and report generation).
- Planned, scheduled, and executed data migrations from older versions of Oracle Database to newer versions. Supported reporting and data analysis using Oracle.
- Worked with developers to diagnose database related issues and perform tuning of various components to increase the efficiency of systems.
- Gathering business requirements, surveying end users and analyzing usage patterns of Data to develop Real estate Reports.
Programmer Analyst
Confidential
Responsibilities:
- Lead Programmer in design and development of the company’s online Real estate information website in a startup environment.
- Designed a system to handle multiple formats of large data sets and input them into an Oracle database.
- Implement an online payment system using PayPal toolkits.
- Developed a Debit system for Customers who were skeptical of using a credit card online.
- Developed site content, release notes and Help information.
- Worked with graphic designers at Confidential to manage graphic and visual elements of the Confidential website.