System Programmer Resume Profile
3.00/5 (Submit Your Rating)
PROFESSIONAL SUMMARY
- Highly-skilled and articulate software development professional with extensive years in software design, development and integration specializing in front-end development using PowerBuilder and backend development using PL/SQL and Oracle. A professional who also functioned as a Data Integration Specialist with working knowledge in combining information from heterogeneous systems into a logical data repository: schema construction/data architecture, semantics integration analysis, and ETL design and implementation, and who also have an understanding of data warehouse concepts and possesses the ability to work well under deadline and high-pressure situations. Consistently proactive in complete assignments independently with minimal guidance supervision having an outgoing and inviting personality with extensive experience in interacting with clients and vendors.
- Strong communication and development skills
- Self-sufficient and willingness to learn with fast turnaround time
- Advanced problem solving skills
- Experience as a PL/SQL Packages, Stored Procedures, Triggers, Views, and Functions developer in Analysis, Design, Data Modeling Logical and Physical , and Implementation of Business Application using Oracle RDBMS
- Designed and developed complex procedures to handle errors and exceptions at database level using PL/SQL
- Proficient in Oracle Tools and Utilities for ETL such as TOAD, SQL Loader, and SQL Developer
- Worked with DBA in performance tuning using Explain Plan and Hints for SQL Queries
- Strong skills in Oracle including SQL, PL/SQL Packages, Functions, Stored Procedures and Database Triggers, Views, Static and Dynamic SQL, and Cursors
- Experience in ETL development using Informatica PowerCenter
- Good understanding of Data Warehouse concepts
- Experience in creating and implementing Data Dictionary/Business Glossary
- Proficient in Entity-Relationship, with good knowledge and understanding in Facts and Dimension tables, SCD, and Dimensional Modeling such as Star Schema
- Experience in integrating RDBMS data source such as Oracle with that of non-relational sources such as XML, CSV, TXT, and XLS type flat files
- Experience in using Autosys to schedule Workflows and batch jobs
- Good exposure to UNIX commands for very day tasks
- Experience with SDLC process in performing detailed analysis, collecting requirements, document requirements, coding and unit, integration, and system testing
TOOLS AND TECHNOLOGIES
Windows 8/7/XP Informatica PowerCenter Oracle PL/SQL SQL Loader TOAD SQL Programmer SQL Plus SQL Developer SDLC UNIX Autosys Crystal Reports Powerbuilder Embarcadero Rapid SQL Visio VSS Remedy Service Now
RESPONSIBILITIES
Sr. Developer for Performance Risk
Confidential
- Worked closely with clients in gathering requirements, establish problem specifications, and system design
- Functioned as a Project Lead on a Project to Project basis
- Created, tested, and deployed scalable, highly available and modular in-house application named Contribution/Attribution Performance Reporting CAPeR using RAD with PowerBuilder as front-end and Oracle 11g as back-end. This is an analytical application with what if scenarios which encompasses data such as portfolio level information, security prices and classification, and transactions on top of other criteria. CAPeR also function as a grading system for Portfolio Managers in assessing individual's management of funds' performance
- Created database objects as per the need such as Tables, Views, Procedures, Packages, Functions, Cursors using Oracle tools like PL/SQL Developer, SQL Plus, and TOAD
- Worked with Record Type SQL and usage of Bind variables inside PL/SQL
- Worked with Heterogeneous sources coming from RDBMS for Accounting systems depending on what type of fund it is, e.g. North America or UK and from vendor flat files for Performance Risk business unit. Received sample data such as transactions, securities, and portfolios level information for processing. Some attributes received from transactions were holdings, lot numbers, and prices, on securities level prices, classification, and security level identifiers such as Cusip/Sedol/Isin, and on portfolio/indices level returns. Using Informatica PowerCenter, data was migrated into a Repository/Staging environment
- Used PL/SQL packages and stored procedures in writing complex Static and Dynamic Queries to implement business rules, cleanse and validate data
- Created, troubleshoot, and maintained PL/SQL packages per business changes
- Used Autosys to schedule Workflows and batch jobs
- Participated in the creation of logical and physical data models, security, and identify performance bottlenecks in Oracle
- Created control files to load data into Oracle database via SQL Loader
- Developed in Informatica PowerCenter using different types of Transformations
- Created Data Marts using Star Schema SCD Type 2 which enable the clients to run analysis and generate reports
- Used Data Marts to generate ad-hoc SQL reports on an as-needed basis
- Developed Amvescap Industry Classification System AICS using ASP.NET with SQL Server as the database
- Implemented full SDLC for the upgrade of vendor application StyleAdvisor from SQLServer 2000 to SQL Server 2008
- Supported 3rd party applications such as StyleAdvisor, Morningstar Direct, and Morningstar Principia MF, VA, and CE modules by functioning as a liaison between the vendors and the clients
- Acted as a Visual SourceSafe VSS Administrator for version control
- Worked closely with Citrix team in supporting server applications such as CAPeR and StyleAdvisor
- Participated in Agile's Daily Stand Up
- Participated in the Disaster Recovery process
- Participated in the LEAN process in particular Rapid Improvement Events RIE
- Performed 24/7 oncall support
Project Lead/System Programmer
Confidential
Project Lead
- Coordinated the development of Application Inventory Management AIM Year 2000 conversion, the merging of Chevron Information Technology Company CITC Application Tracking CAT into AIM
- Spearheaded the gathering of business requirements for AIM's enhancements
- Supervised cross training among adjacent applications for support
System Programmer
- Participated in the development of Application Inventory Management AIM Year 2000 Embedded System using PowerBuilder as a front-end and Oracle as the back-end, in the business re-design of data model for litigation project Royal Information System RIS , and in the creation of GAS Marketing Contracts GMC using EASEL SQL
- Developed Reporting Module for AIM using MS Access as front-end and Oracle as back-end
- Converted AIM's Reporting Module from MS Access to PowerBuilder
- Developed Project Tracking System for group's usage using PowerBuilder as front-end and Oracle as back-end
- Participated in the data loads for RIS using SQL Loader, in the development of GAS Marketing Contracts GMC using EASEL SQL Report Writer and Oracle as back-end, and in the enhancements of Crude Oil Scheduling System COSS using QBasic
- Conducted the GasLink/PREMAS integration
- Converted GMC to accommodate Transportation Deal Application, i.e. created a link between the two systems for leverage purposes
- Functioned as a primary support for GMC Transportation Deal Application, and as an active member in the Common Engine Committee, Documentation Methodology Committee, and EASEL Standard Committee