Oracle SQL Server Developer experienced in working in Data Warehouse applications handling large quantities of sensitive data. Experienced handling data migrations requiring design and development skills to preserve historical components of data dimension modeling . Proficient with complex querying and data analysis working with ETL tools of SQL, PL/SQL, T-SQL, Toad, SQL Developer, SQL Loader and recently Informatica and in execution plan analyzing, Data Modeling and logical/physical database design, normalization/ denormalization. Proficient working experience with SQL, PL/SQL, Stored Procedures, Functions, Packages, DB Triggers Indexes and FTP/AFTP processes. Use of Shell scripts to extract and load data from data sources flat files, databases, etc. for efficient Data Asset Management.

Confidential

Data Analyst

• Responsible for ensuring daily/nightly data loads complete for clients in Portfolio utilizing Tidal Enterprise Scheduler and Informatica 9.5 and Unix.Clients consist of :
• Pacific Gas and Electric PG E , Cricket Wireless, TempurPedic and Union chimique belge UCB -Biopharmaceutical
• Development and maintenance of Informatica Power Center mappings, mapplets, sessions, worklets and workflows
• Perform data analysis, cleansing, integration and transformations between source data and Client databases
• Responsible for correcting and submitting tickets via Service Now for Informatica Workflow and Session failures.
• Automated and assisted with automation of some of the existing manual processes with Tidal and Unix Scripting.
• Provide Data Quality Assurance, Research and Adhoc requested data extracts for Internal and External clients.
• Identify and query database with Campaign Analysts toprovide proper data for Marketing campaigns utilizing programming tools and applications of SQL, Informatica, and SQL Developer.
• Received Informatica University on Demad Training: PowerCenter 9.x: Operations and Support

Confidential

Oracle Portal Developer / Programmer Analyst III/Consultant

• Enhanced the frontend and backend of TriQuint Semiconductors Equipment Monitoring System EMS and Fabrication Plant FAB data for producing Radio Frequency RF components.
• Support Oracle Portal Application Server 10gr2/Oracle 11g via ticket system providing Portal Administering and Database enhancements with HTML/JavaScript, PL/SQL Dynamic PL/SQL procedures and packages incorporating ticket requests into ETL solutions and resolving data issues.
• Frontend responsibilities Portal Administrator - Granted access to Fab Engineers/Operators to utilize EMS Portal and Fab Portal at appropriate access level ensuring data security.
• TriQuint Semiconductor Database components:
• EMS EquipmentMonitoring System repository to Qualify equipment, to track up/down time and Preventive Maintenance PM measures of tools.
• FOUNDRY repository to manage securely Customer Prototyping, Design Samples, Tool Libraries, Data Sheets, Handbooks and Training Classes etc. for their design modules.
• FAB Certification/ HR Training Certification repository to manage Engineer/Operator Equipment training and Tool knowledge/Usage Certifications.
• Backend responsibilities Worked with Fab Engineers to provide new features/fixes to Portal Pages, Regions and Portlets using PL/SQL, Dynamic PL/SQL, JavaScript/HTML to enhance equipment Qualifying and Testing processes.
• Worked with HR Staff from user prospective to assist with migration of HR Training Portal to new Learning Manangement System LMS by identifying and extracting data sources for loading into new system.

• Provided International Traffic in Arms Regulations ITAR accounts to employees for EMS and FAB data.
• Support ongoing real time data/reports/documentation updates to Customer Foundry Portal ensuring data is secure from Customer to Customer and compliant for customer requested audits and abides Non-Disclosure Agreements. Outline and document Portal Administrative services as requested by users for support during Customer Foundry migration.
• Support transitioning from Oracle Portal to .Net documenting relationships and process flow of Portal Page Groups to Provider Portlets of Dynamic pages/Forms/Reports/Links and calls to Oracle Database packages and procedures.
• Documented PL/SQL with HTML/Javascript packages and procedures utilized for Portal Form and Report generating and database table updating.

Confidential

Data Developer

• Followed up with customers/vendors to ensure the data has met their specific demands in terms of analysis, content.
• Maintained Originations New Loans and Maintenance Existing Loans in SQL Server 2008 / 2012 Denali databases.
• Started on Maintenance Board Decommissioned DTS packages rewriting them into T-SQL Stored Procedures, Views and/or PowerShell Command/Batch scripts and Moved to Originations Board enhancing/creating T-SQL code.
• Worked with assigned Business Analysts and vendors for user requirements data enhancements/request/models.
• Utilized ControlM for job processing definitions: i.e., job type of script or program, scheduling instructions, runtime preconditions and instructions, flow dependencies, post-processing conditions, cleanup notifications and escalations.
• Setting up Control M environment, tabs dynamic variables for scheduling/enhancing within hundreds of jobs.
• Querying and analyzing Loan Origination data sources to determine logic for ControlM data models - Scheduling tables and job flow designing for ETL with TSQL, PowerShell scripts, BCP Imports/Exports and some SSIS when BCP not used for following vendor deliverables and receivables:
• Chrome Systems BookLink - mapping web service solution providing NADA KBB used automotive data.
• LexisNexis - world's largest electronic database for legal and public-records - deceased and bankruptcy data.
• Computer Sciences Corporation CSC PATRIOT Protector - for financial services firms to comply with U.S. counterterrorism regulations by validating customer and vendor names against the Office of Foreign Assets Control OFAC list of Specially Designated Nationals and Blocked Persons. Set up process for seed data to process monthly or as CSC loaded new data.
• Extracted and provided consumer data needing Truth in Lending Act TILA Letters with APR and Credit terms.
• Salesforce - web-based, CRM cloud application for users to manage/perform nearly every detail of their job.
• Silverpop - a digital marketing technology provider offering email marketing and automation solutions used for web based marketing applications analysis.
• Ensuring deliverables/receivables with Non Public Personal Information NPPI are properly encrypted and archived.
• Utilized Rally Project Management tool with the AGILE/SCRUM Methodology to track Development of User Stories.

Confidential

Oracle Developer/Consultant

• Extracted Long Distance LD data from Ordering, Provisioning and Billing systems in compliance with regulations of onshore Support for Integrated Decision Support System iDSS the official data source of LD reporting metrics including phone line, phone plan and revenue reports for OLAP.
• Migrated this data into datamarts via Appworx scheduling/monitoring application by creating and maintaining PL/SQL procedures, functions, triggers and views to be utilized by various departments for their development and reporting.
• Provided adhoc regional reports for various marketing plans ie. FIOS, International Programming, Verizon Online, Long Distance Local data also for Regulatory, Interrogatory, Legal and Security requests.
• Created technical specifications and test plans, schema and database designs for Monthly/ Weekly reports for Finance/Marketing intelligence Billing Revenue forecasting purposes utilized by internal operations within Oracle Database supported via Appworx, Informatica Toad and a SQL Server Database supported via T-SQL, DTS SSIS. Extensive database design/ ETL with Toad, SQL, PL/SQL, T- SQL and Unix Shell scripting.

Confidential

Oracle Developer / Consultant

• Enhanced the frontend and backend of General Services Administration GSA Public Building Services PBS Computer Integrated Facilities Management CIFM Center with Oracle Portal integrating Dynamic Pages, Reports, Forms , HTML and JavaScript with Oracle Database development, utilizing Dynamic SQL, SQL, PL/SQL in views, triggers, functions, procedures and packages.
• Frontend responsibilities Portal Administrator - Granted users access at appropriate level to PBS Enterprise Portal - a single point of entry web-based nationally integrated database application.
• Enhanced code for PBS Enterprise Portal - Run through of application correcting broken links documents ensuring deleting, updating, pages redirect to proper locations upon submits calls are to proper functions, etc.
• Ensured data types i.e clobs displayed properly from database to PBS Portal.
• Enhanced code to display data based on user group privilege allowing upload and edit privileges by group.
• Modified various Portal Pages, Regions and Portlets with PL/SQL, javascript and HTML to serve up data from databases.
• PBS Enterprise Portal Application Warehouse components:
• BITS Border Information Tracking System repository for Rent Appraisal data of federal properties and Border Station rent data.
• OATOOL Occupancy Agreement OA Tool repository to manage OA s the basis for the federal clients' rent bills to provide accurate billing of PBS space inventory for over 7,000 leased buildings and 1,900 government-owned buildings totaling millions on a monthly basis.
• IRIS Inventory Reporting and Inventory System repository for new construction projects, Repair Alteration Program data, and Occupational Safety and Health data and abatement plans for federal buildings.
• Backend responsibilities Created package to monitor daily, monthly and historical jobs and collect stats to populate appropriate tables.
• Researched and coded various changes to datasets to determine appropriate billing sources based on user requests for OLAP.
• Development work to improve operation efficiencies.

Confidential

ETL Developer/ Metadata Analyst

• Developed/ Maintained an Oracle 10G Enterprise OLTP Data Warehouse and corresponding Data marts utilizing PL/SQL Procedures, Packages, Materialized views, Triggers, Dynamic SQL, and Exception handling for back-end OLAP.
• Querying and analyzing data sources and vendor systems High Touch, ReconNet to determine logic for data ETL of following:Store Manager Base Pay, Fixed Assets, Vacation Balances, Same Store Sales, Inventory, Marketing Analytics, Cashwise Stores,Fuel Card Management, Store Audits, Vendors/Supplier data, Cash Management Late Deposits, NSF'S, Overshort Cash/Credit,Overtime Reports, Telemarketing data and Monthly Store Ranking Reports.
• Provided operational support to production environment including, building, scheduling, and monitoring jobs resolving problems. Gave direction to Business Objects development team.
• Maintained ETL processes accommodating source system and business requirements changes to improve efficiency.
• Developed and implemented logical and physical data models for various datamarts.
• Acquired necessary input/approval of requirements and designed and participated in code reviews then built enterprise architectural and/or infrastructure components.
• Extensive work with Toad, SQL Loader, Unix Scripting and File Transfer Procedures.

Confidential

Central Business Services Associate

• Supported Medical Billing in Patcom and Quic/Trac Environment. Monitor Productivity for Garland Region for commercial insurance.
• Monitored Billing policies and procedures via MircoFocus Cobol Unix. Updated database containing healthcare information.
• Data audit medical bills for accuracy.