Programmer Analyst Resume
Chicago, IL
SUMMARY:
- Information Technology Graduate & Professional offering a strong foundation in OOP Languages and Database technologies with extensive knowledge of best practices in UX Design principles.
- Designed and developed interactive website that enabled patients to search and find data on various medical conditions and how they are treated. Created custom modules via hook implementations as well as dynamic content using JavaScript. Project also included theme modification.
- Designed and developed website that demonstrated core competencies acquired in Medical Informatics. The website was designed utilizing a stand - alone version of WordPress. Modified WordPress codebase to customize page features, including slider, navigation, header and footers, as well as page layout. Technologies included PHP, HTML, CSS 3, and JavaScript.
- Developed statistical reports to support value-based driven healthcare processes through quality measures that assessed performance in patient safety, risk, utilization and inpatient quality care. Exported data to CSV file from Oracle Apex database using a PLSQL script. Imported that data into SAS to create summary and graphical reports demonstrating factors of influence through logistic regression and other statistical analysis.
- Designed and developed a functional and user-friendly medical records system to support evidenced-based blood pressure treatment protocols. The database was designed based on the relational database model utilizing MySQL. Web-based programming languages included PHP, HTML, and CSS.
- Designed and developed technology based learning system for an e-learning course in building a relational database model. Utilized HCI principles to establish requirements for system, as well as interface design and layout. Also, created the course plan and established the course objectives based on theories and models of human perception and cognition as they apply to learning. Learning system was developed using a combination of HTML, CSS, JavaScript, and SQL Server backend database system.
- Created better user experience by improving online bill payment system that allows users to pay their cell phone bill via the web. Methods included the heuristic evaluation process. Resulted in redesign of interface for improved usability.
- Researched significant factors that impact the usability of hand held devices. Redesigned the user interface and small screen interactions of the Olympus Stylus 1010 digital camera. Research for redesign included interviews, heuristic evaluations, prototyping, and product comparisons. Final analysis resulted in device improvements in Bluetooth device pairing, syncing, social media connectivity, and camera modes.
- Conducted user centered research at the Chicago Lighthouse that would enable the improvement, effectiveness, and redesign of web forms that would give individuals with visual impairments a better user experience when filling out web forms via screen readers. Usability Techniques included heuristic evaluations; think-aloud tests, usability metrics, and rapid prototyping. Employed the use of Fisher’s exact test for statistical data analysis.
- Designed interactive website utilizing HTML, CSS, and JavaScript that allowed users to input song information (i.e.: title, artist, genre) and store it into their personal library to track music data. Created backend database in MS Access to store user (music) input and utilized PHP code to interact with MS Access database.
- Developed Java software program for course grading system that would allow a user to input a numeric score and receive a final term grade based on a predefined grading scale.
- Developed Java software program that would display the day of the week a specific date falls on based on a calendar date inputted by the user.
- Developed a relational database (student enrollment system) from inception to completion using the Oracle 8i RDBMS. Employed DBLC methodologies to deliver conceptual, logical, and physical data models. Utilized ODBC to import Oracle tables into MS Access database for form creation.
- Determined Entities, Relations, & Attributes among various tables.
- Assessed Cardinality of tables in relation to each other to create optimal query strategies.
- Analyzed and organized columns and table relations to eliminate data redundancies and to determine data dependencies.
- Created SQL statements to develop student database based on specified requirements.
TECHNICAL COURSES & SKILLS:
Programming Languages: Java SE 6 & 7, Objective C, C++, C#, XML, Python 3, PHP 5.x, JavaScript, .Net, HTML 5, CSS 3
Database Skills: Oracle (8i, 9i, 10G, 11G), SQL & PL/SQL, MySQL, MS Sequel 2008, 2012, MS Access 2013
Statistical & Reporting Tools & OS: IBM SPSS, SAS Base & Proc SQL, R, MS SSIS & ETL Tools, Unix, Linux, Windows XP, 7, 8.x, 10.x
Content Management Systems & Frameworks: Drupal 6.x, 7.x, WordPress 4.x, Joomla 3.6, Bootstrap 3, SharePoint 2012 & 2013, Drupal development skills: site configuration, custom code via Drupal hooks, custom, APIs for data retrieval, form validation, as well as custom theme design
WordPress development skills: customized themes and developed plugins to add functionality to sites or to provide integration with social media sites.
PROFESSIONAL EXPERIENCE:
Confidential, Chicago, IL
Programmer Analyst
Responsibilities:
- Designed and developed calculator tools utilizing JavaScript, CSS, and HTML to create online graphical user interfaces to assist with testing trade applications.
- Analyzed software application requirements, performed regression testing, executed test plans on UNIX platform and documented results. Included the following:
- Modified SQL DDL statements in text file before running test scripts.
- Traced paths to various CSV files to change required property settings before test runs.
- Logged details of pass or fail tests and escalated results to QA team.
- Effectively delivered stock strategy presentations derived at through research, interviews, and team meetings.
Confidential, Chicago, IL
Senior Internship Project (Team Lead)
Responsibilities:
- Designed & developed frontend website in Dreamweaver for upscale salon.
- Developed backend customer database created with MS Access to allow salon clients to book appointments via website.
- Used SQL DDL commands to define, build, and modify table structures.
- Used SQL DML commands to populate tables based on salon data requirements.
Confidential, Chicago, IL
Database Analyst
Responsibilities:
- Imported and exported data to and from distributed database systems for finance & accounting needs.
- Produced financial reports detailing income & cash flow information using Excel.
Confidential, Chicago, IL
Database Analyst
Responsibilities:
- Responsible for the upkeep and maintenance of databases that house attorney registration and disciplinary history.
- Followed up with attorneys regarding their practicing status (active/inactive) and produced confidential reports relative to attorneys’ disciplinary history.
Confidential, Chicago, IL
Web Content Editor
Responsibilities:
- Maintained Web Design Control by managing website content utilizing the Blue Martini content management system.
- Created, edited and sourced content for company website (included creating slogans to market products).
Confidential, Chicago, IL
Broadband Metrics DB Analyst
Responsibilities:
- Maintained database comprised of metric data pertaining to dedicated circuit access for multiple clients.
- Preserved client relationships by providing progress reports, addressing and following up on problem issues, and communicating effective ways to maximize broadband services.
Confidential, Chicago, IL
Confidential Database Specialist
Responsibilities:
- Assisted with development and maintenance of Confidential MS Access database system created to track IT assets.
- Tracked and monitored data collection and produced progress reports by extracting data using SQL statements.
- Provided backup assistance to war room by responding to field calls and disseminating time-sensitive information.
- Provided help desk support to internal staff.