Data Informatica
Resume:
Ace Analytics Solutions, Inc.
Your Big Data Transformation and Integration Solutions Service provider. ALLEN A. SHE
SEVERN, MD 21144
*********@*****.***
I am a US Citizen with an active DoD Secret and other clearances. Highly skilled and Energetic Data Consultant with more than 20+ years of hands-on, broad-base experiences in Software Development Life Cycle in Information Technology Big Data solution. Such as Software Design, Data Security, Custom Software Implementation and Maintenance. Ability to bridge the gap between Business and Technology, and to collaborate between teams. Architect ETL/ELT solutions and Big Data integration strategy. A highly sought after and broadly skilled Big Data Consultant with Informatica PowerCenter v10.2 Subject Matter Expert (SME), being trained in InfoSphere DataStage v9.1 and working knowledge of OBIEE Oracle BI 11g R1, Virtualization, Excellent Problem Solving skills, Technical Analyst, Team lead offering extensive experiences of successfully analyzing, designing, implementing, data Cleansing/Migration/Conversion, and managing IT and Security Solutions/Programs for the United States Federal Government and Private Enterprise environments. Utilized Agile Software development methodology in successfully delivery of software projects to Clients. Created Business Requirements; Business Process Flow; Data Vault 2.0 model; STAR Schema and Relational database modeling. Experiences in performing Meta Data management and Data Cleansing. Informatica PowerCenter, PowerExchange expertise in dealing XML source schema. Performed Extract, Load, and Transformation (ELT). Senior Requirement Analyst designing Logical/Physical Data Model and Data Analysis. Proven record in ability to deliver cost effective and quality IT Services. Requirements and Analysis and Software Quality Solutions. Creative problem-solver and continuously sought after to turnaround struggling projects/processes. Adept at identifying patterns and operational needs before developing innovate strategies that increase revenues, reduce costs and boost productivity. Talented at quickly earning the trust, confidence, and respect of peers, senior management, clients, and key decision-makers. A respected leader, experienced in overseeing remote teams. Looking for a new, exciting opportunity to contribute to an industry leader. Project Development & Management:
• Proven record in successfully delivered medium to large Data Integrator Projects for Big Data Applications. Extensive experiences in utilizing Informatica PowerCenter (ETL) in delivery data transformation Projects. Delivered Highly Complex SQL performance tuned scripts and written complex UNIX scripts.
• Identified strategies for delivering the company’s revenue growth. Develop, track, and control the annual operating budget for delivering the existing and new projects. Development and management of Data modeling, predictive modeling, business architecture, application architecture and rationalization; Business Architecture with Requirements gathering, project scope analysis and Use Case development.
• Experienced in team assessment, process integration, Change Management, Change Control, integration, and motivation. Experienced in Customer Relationship Management Product life cycle, impact and risk assessment with contingency planning, requirements gathering and writing, Use Case development, activity diagramming, business reengineering & process redesign, standards definition and implementation, project facilitation and meeting management, workflow analysis, testing traceability, budgeting and cost analysis.
• Provided System Engineering and Process Engineering support to the Application Architecture and Engineering. Develop Application requirements, design (conceptual, logical and physical) and review configurations of the infrastructure to ensure all requirements have been satisfied. Requirement gathering and analysis Application Architecture engineering and deployment on different projects. 2
ALLEN A. SHE
Areas of Expertise and Years of Experiences
• Lead Informatica Architect • Performed Big Data Integration using PowerCenter v10.2x; 15+ years in Informatica PowerCenter/PowerExchange Architect; data transformation in Big Data Warehouse with more than 30 TB; data cleansing and data profiling. Created complex Informatica Mapping and Transformations; including workflows tuning.
• System Architecture, Application Development. Agile Scrum Methodology.
• Complex Project Leadership • IT Strategy & Execution • Business Development.
• Requirement Analyst and Data Architect; • Team-Building & Leadership.
• Security knowledge of FISMA Standards - NIST Guidelines.
• 20+ years in Data Cleanse and Quality • Performance Tuning • SQL/PL-SQL and Unix Scripting Expertise.
• 17+ years in writing complex custom scripts using Bourne and Korn Shell; SQL scripts, PL/SQL, SQL tuning; and optimization for automated sub-systems in Oracle environment and participated in Enterprise Wide Data Quality projects.
• 20+ years in Full Software Development Life Cycle, including gathering and compiling user requirements, Data Modeling (Logical), Meta Data Management, system integration testing, and implementation.
• 15+ years in leading technical team in facilitating and discussing business requirements with business users and managers. This include leading the analysis and developing Technical and Functional specification. Ensured Sox documentation Standard and Policies are met.
• Excellent Business background and knowledge coupled with the ability to transform business ideas into successful technical solution.
• 15+ years in designing Logical/Physical Data Model, Data Analysis and Cleansing, and Master Data Management.
• 15+ years in manual QA Testing (functional, regression, integration, UAT, etc) in UNIX environments. Extensive exposure to QA methodologies, best practices, and instilling strong QA approach within projects relative to requirements gathering, building upon a solid foundation and structured model of QA processes, as well as building reusable scripting for testing of data. Extensive experience in developing test plans, testing schedules, and test cases from technical design specifications, functional specifications and functional requirements.
• 15+ years recent experience in designing large Oracle Star Schema Data Warehouse, including writing test scripts against the Data Warehouse and ETL processes in working with data and testing in data marts.
• Completed training on IBM InfoSphere DataStage v9.1 and working knowledge of OBIEE Oracle BI 11g R1.
• 4+ years hands on MS of SQL server database v2012, v2014, and v2016 SSIS.
• 1+ year hands on support on OBIEE.
• Completed ServiceNow Fundamental Administration training. Knowledge of Hadoop MapReduce (Master and Slave).
Technical Proficiency
Languages: Completed OBIEE and MicroStrategy BI Project Design Training, SQL, DB2 SQL, PL/SQL, Passed MicroStrategy Certified Project Designer certification, Completed Oracle OLAP Basic Training, C, PERL, X- QUERY, SQR, XSLT, HTML, Pascal, Basic, UNIX Shell Languages, RDB/SQL, C++, ADA, Fortran. Software Packages: Completed ServiceNow Fundamental training, ERWIN Data Modeling tools, Informatica PowerCenter v10.2x SME on Cloud AWS, Trained on InfoSphere DataStage v9.1, Trained on Ab-Initio, Embarcadero ER/Studio, IBM Rational tools, Rational Quick Test Pro, Clear Quest, Actuate v7, Crystal Reports v8, Visio, SQR Report Writer, Oracle Financial Application 11i, Syncsort, PopKin Systems Architect, PVCS, People Resource Planning (PRP)™ Software-TEDS Application, Ernst and Young Global Expatriate Management (GEMS) Application, Oracle Developer 2000. Knowledge of Security protocol NIST, FISMA, Arcsight.
Operating Systems and Databases: Linux, UNIX/Korn/Bourne Shell, Greenplum,VAX/VMS, NT, DOS, Windows, and MPE/XL; ORACLE v12c, RDB, and have knowledge of Hive and NoSQL. Design Methodologies: Data Vault 2.0 Certification, STAR Schema, Gane and Sarson, Yourdan and DeMarco, Arthur Andersen/Method I, and Booch and Object Modeling Technique (OMT), UML; Kimball and Inmon. 3
ALLEN A. SHE
CAREER SYNOPSIS
ACE ANALYTICS SOLUTIONS, Inc. – Sr. BI/ETL Data Architect/Integrator May 2015 to Present. ACE – Court Services & Offender Supervision CSOSA – Sylger Apr 2020 - Present
Lead Data Warehouse/ETL Enterprise Architect responsible for Design, Implementation, Enhancement Data Vault 2.0 Data Warehouse, and ETL mappings and workflows.
Mentor and Coach other Data and ETL Architects on Data Vault 2.0 implementation methodology.
Design, Developed, Coded, Tested, and Implemented Data Vault 2.0 Data Modeling.
Developed and implement ETL/ELT data integration process.
Created SQL server Stored Procedures and Functions for data loading process, including error handling and tracking.
Utilized Erwin tool for Data Modeling Data Vault 2.0.
Designed and Implemented automate processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Utilized GitLab for team collaboration and software configuration management. ACE – Department of State with Secret Clearance July 2019 to Mar 2020 SIO/IRM – Buchanan Edwards Contract - GS-06F-0717Z SAQMMA13F2905
Lead Informatica Architect responsible for Design, Implementation, Enhancement, and Maintenance of Informatica mappings and workflows.
Maintained and Performed Bug fixes on the existing Production systems.
Monitor daily, weekly, monthly, semi-annually, and annually scheduled and un-schedule jobs.
Developed database scripts and Data Architecting data warehouse model.
Performed tuning, improvement, and redesigned of the existing Production jobs.
Designed and Implemented automate processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Developed data integration tasks via Azure Cloud.
Trained using self-paced ServiceNow Fundamental course. Department Security (DS) – CACI/Pernix Contract May 2015 to July 2019
Lead ETL Architect responsible for Comprehensive implementation of Extract, Load, and Transform of ETL jobs, and parameter files from Development to Production environment.
Utilized Agile approach in 3 weeks Sprint Cycle.
Designed, developed, and implemented PL-SQL module for Data Vault 2.0 loading process.
Data Warehouse is based on Data Vault v2.0 implementation.
Maintained and Performed Bug fixes on the existing Production systems.
Performed tuning, improvement, and redesigned of the existing Production jobs.
Document the process flow for the Production Data Integration processes.
Comprehensive designed, developed, and implemented Data Vault 2.0 for Enterprise Data Warehouse.
Designed and Implemented automate processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Developed data integration tasks via AWS Cloud.
Certified Data Vault 2.0 practitioner.
Implement ELT data load using MS SQL Server v2016 SSIS. ACE – Armed Forces Health Surveillance; Cherokee Nation/Dfuse Tech Mar 2016 to May 2016
Senior Informatica Architect responsible for Create, Develop, Unit Test, System Test and Migration of Mapping, Mapplets, Worklets, Workflows, and parameter file to Production environment.
Maintained and Performed Bug fixes on the existing Production systems.
Performed tuning, improvement, and redesigned of the existing Production mappings, session tasks and workflows.
4
Designed and Implemented automate processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Designed, developed, and implemented PL-SQL and stored procedure.
Document the process flow for the Production Data Integration processes. ACE -- Radiant Advisors’s Enziime Healthcare Data Project: Jul 2015 to Feb 2016
Lead Informatica PowerCenter Architect.
Performed Installation, Security Setup and Configuration of the Informatica v9.6.1 on AWS cloud.
Created, Developed, Unit Tested, System Tested and Migration of Mapping, Mapplets, Worklets, Workflows, and parameter file to Production environment.
Designed, developed, and implemented PL-SQL and stored procedure.
Hands-on created standard documentation and Informatica Client setup.
Installed Actian databases connector for Informatica and ODBC client.
Migrating Informatica v6 artifacts to Informatica v9.6.x. Architect Informatica ETL solutions. Performed Data Source data analysis.
Trained on Actian MPP DB; Vector and Matrix.
Learned and used Ingres SQL.
ACE -- Amtrak CSPMI Enhancement Project – International Logic Systems: May 2015 to Jul 2015
Lead Informatica PowerCenter Architect responsible for enhancing and developing new functionality.
Architect Informatica ETL solutions and Performed Change Data Capture load.
Performed Data Source data analysis.
Architecting target tables with Data Modeler.
Designed, developed, implemented and maintained PL-SQL scripts.
Trained on IBM InfoSphere DataStage v9.1 and Oracle Data Warehouse Administration Console.
Working knowledge, Support, and Modified OBIEE Oracle BI 11g R1. IBM – Senior ETL Data Integration Specialist: Jul 2011 to May 2015 IBM- TSA OASIS SECURE FLIGHT Project: Req. Secret Clearance Dec 2014 to May 2015
Lead Informatica PowerCenter Architect responsible for maintaining and developing new functionality.
Architect Informatica ETL solutions and Performed Change Data Capture load.
Designed, developed, implemented, and maintained PL-SQL scripts and stored procedure.
Trained on IBM InfoSphere DataStage v9.1 and Oracle Data Warehouse Administration Console.
Working knowledge, Support and Modified OBIEE Oracle BI 11g R1. IBM- IRS ACA Coverage Data Repository Project: Dec 2012 to Dec 2014
Architect ETL solution and Big Data integration strategy. For instance, responsible for Architecting and Designing entire defect free 1095A data flow and data transformation for loading to Target database.
Responsible for IRS ACA project with developing information security documentation and providing remediation recommendations for high risk business systems utilizing the NIST SP 800-53 rev3 standard.
Familiar government regulations and standards: National Institute of Standards and Technology (NIST), Federal Information Security Management Act (FISMA), FISCAM, FedRAMP, Gramm Leach Bliley Act (GLBA), HUD Handbook, Sarbanes Oxley (Sox), National Housing Act, etc.
Designed, developed, implemented, and maintained PL-SQL scripts and Stored procedure.
Responsible for the development and implementation of security procedures.
Review security policies and procedures by administering and monitoring security profiles, reviews security violation reports and investigates possible security exceptions, updates and maintains the documented security controls.
Developed data transformation rules and implement extract, transform and load ACA/IRDB data mappings, tasks and workflows.
Created custom XML source view and perform complex XML manipulation using Informatica Powercenter.
Performed deployment of software releases.
Used Informatica ingest source data into Greenplum database.
Performed Informatica Workflows migration from v9.0.1 to v9.6.
Designed, implemented and tested highly complex Informatica workflows for ACA healthcare data. 5
Some Postgres SQL experiences.
IBM – GSA TMS/TPI Project: Jul 2012 to Dec 2012
Designed, implemented and performed quality assurance on Informatica PowerCenter workflows for transferring data to Cognos BI data mart.
Perform data transformation and cleansed. Modified COTS TPI’s ETL mappings.
Perform Informatica administrator related tasks.
Designed, developed, implemented, and maintained PL-SQL scripts and Stored procedure.
Designed and implemented data model for a small Cognos BI datamart.
Assisted Maricom EDSC project to implement Data Quality tasks and Informatica mappings for 3 weeks.
I was on three-weeks borrow resources to Maricom EDSC project. IBM – US Bureau of the Census: Jul 2011 to Jul 2012
Performed extract, transform and load census data that feed into Census Metadata and into Oracle tables.
Performed Data Cleansing and transformation into Census Metadata Depository.
Designed, Implemented and tested Census search Interface and data transformation.
Trained junior co-worker on Census processes and Created ETL documentation.
Designed, developed, implemented, and maintained PL-SQL scripts and Stored procedure. CSC - Senior Consultant Data Warehouse/ETL Architect Jan 2011 to Jul 2011
Responsible for implementing Data Integration strategy between Center for Medicare and Medicaid Services system and DECC systems.
Led and Implemented Informatica PowerCenter Architecture Framework and Standard. Designed and Implemented Informatica Mapping, Workflows, Session tasks, Mappings, Worklets, Lookups, and so on.
Analyzed Claims, Patients and Facilities data lineage/relationship for End Stage Renal Diseases project.
Critiqued and provided feedback on Business Requirements to the Business Analysts.
Created, documented, and delivered the Interface Communication and Data Conversion documents. Multiple Consulting - JHU/APL and Human Genome Sciences Jul 2010 to Dec 2010 Senior Data Warehouse/Data Architect/ETL Consultant
Analyzed data sources from multiple Companies. Using Salesforce Apex Data Loader loading data to Veeva.
Developed Logical Data Model for Enterprise Data Warehouse and MDM for Pharmaceutical Manufacturer.
Created and implemented Oracle DDL scripts for Sequence generators, Triggers and Stored Procedures the Enterprise Data Warehouse.
Developed and Implemented 54 Informatica PowerCenter Mappings, Session tasks, Worklets, and Workflows for Type 6 Slow Changing Dimension Data Model within the first 6 weeks of joining the client.
Tested complex Informatica PowerCenter mappings for Lookups, Aggregation, Router and Mapplets to transfer and load data from Data Warehouse to Oracle Data Marts.
Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Created complex SQL scripts to extract data from Enterprise Data Warehouse for reporting purposes.
Developed, documented, and updated (Wiki) business processes to establish a comprehensive, coherent body of knowledge that can be used to transition onto the data warehouse support team.
Resolved PL/SQL interfaces issues by modifying PL/SQL and UNIX scripts.
Excellent Problem Solving skills and my ability to resolve difficult and complex issues.
Performed Application testing for transition onto Window 7 environment. Apex Systems, Inc., at Veteran Benefits Administration May 2010 to Jun 2010 Senior Data Warehouse/ETL Consultant
Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Created complex SQL scripts to extract data from Enterprise Data Warehouse for reporting purpose.
Designed, implemented and tested complex Informatica mappings for Lookups, Aggregation, Router and Mapplets, and Workflows to transfer and load data from one database to another Oracle database.
Performed Extract, Transform, and Load processes for Data files to feed into Reporting Data Marts.
Gathered, Update, and Documented business and data requirements documents. 6
Advisory Board Company, Washington, DC Sep 2008 to Apr 2010 Senior Data Warehouse/ETL Analyst
Created and implemented automated process using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Transformed business ideas into technical solutions.
Designed, implemented and tested complex Informatica PowerCenter mappings for Lookups, Aggregate, Joiner, Router, Worklets, Mapplets, and Workflows to transfer and load data from one database to another Oracle database, including logical design of Enterprise data flows.
Standardized Informatica PowerCenter naming convention so that it can be executed via UNIX script.
Converted SQL reports from UNIX into multi-tabs Excel Spreadsheet using UNIX and Perl command script.
Managed and multi-task between nursing, surgery and emergency department (ED) projects for healthcare industry.
Defined Global environment variables for Informatica PowerCenter. Labor Department, Washington, DC Jan 2008 to Sep 2008 Team Lead/Senior Analyst
Implemented and automated processes using Unix Shell Scripting to execute SQL, PL/SQL scripts.
Transformed business ideas into technical solutions.
Used Visio Professional to create Logical Data Model E-R diagrams, Business Process and System Process flows.
Performed Extract, Transform, and Load Data files to feed Reporting Data Marts.
Created Complex SQL scripts and Tuned SQL for DB2.
Developed Logical Data model, Data Analysis and Cleansing.
Gathered, Critiqued and Documented business and data requirements documents.
Created Complex SQL scripts and Tuned SQL for DB2.
Developed Logical Data model, Data Analysis and Cleansing.
Gathered, Critiqued and Documented business and data requirements documents Fannie Mae, Washington, DC Aug 2004 to Dec 2007
Data Warehouse/Team Lead
Implemented an automate process using UNIX Shell Scripting to validate all Financial Statements for Income Capital Business Model. Transformed business ideas into technical solutions.
Participated in designing the new Portfolio Data Services systems for Fannie Mae. This new system performs Fannie Mae Assets and Liabilities’ Risk Forecast and Compute duration of the assets and liabilities such that duration gap is within the management’s goal.
Facilitating across Functional teams for Enterprise Wide Data Quality projects. Created Logical Data Model for Loan Database. Created Sample test data. Used Visio Professional to create Logical Data Model E-R diagrams, Business Process and System Process flows.
Lead Technical teams in Facilitating and Discussing Business Requirements with business managers and users; this includes Leading the analysis and creating Functional and Technical specifications.
Created Complex SQL scripts and Tuned SQL. Performed Data Profiling using Exeros Discovery tool.
Performed Extract, Transform, and Load data files to feed Data Marts and Warehouse Database using Informatica PowerCenter. Created ETL data flows. Created and Maintained Oracle Database Meta Data.
Met with stake holders to discuss the scope for Business Requirements.
Performed loan portfolio Data Cleansing; instill documentation discipline; and SOX control procedures.
Created a new General Ledger Oracle database for drill-down of complex financial statements.
Mastered the “SUMMIT”, 3rd
party Financial Application, database in just three weeks, and independently validated the Debts VNML portfolio using SQLs and found 5 errors in the process.
Gathered, Critiqued and Documented business and data requirements documents.
Created Stored Procedures and Performed SQL tuning, using Oracle SQL hints for maximum performance.
Developed and Maintained Oracle Logical Data Model.
Created and Performed overall regression test plan for RBCPro (risk-based capital software) for OFHEO risk management compliance purposes. Created independent Sybase SQLs for automate verification processes.
Implemented test procedures and processes to ensure that all applications are thoroughly tested.
Created XSLT conversion style sheet to flatten XML files for QA automate processes.
Developed processes using Unix Shell scripts to validate all derivative instruments’ data for Fannie Mae portfolio. Ensured Sox documentation Standard and Policies are met.
Documented, Analyzed, and Transformed business ideas into information technology solutions.
Evaluated, Implemented and Supported Custom Off The Shelf (COTS) application for Exeros Data Profiling 7
Discovery and Compuware File-Aid Disguise tools.
Evaluated and Tested Portfolio Data System (PDS) Assets and Liabilities Financial Modeling Systems.
Managed multiple projects for the Portfolio Strategy group in Fannie Mae throughout the different phases of Software Life Cycle Process.
Trained on Ab Initio and perform support for 3 months. Marriott International, Incorporated, Bethesda, Maryland Feb 2001 to Jul 2004 Team Lead/Senior Systems Analyst
Designed, Implemented and Maintained Marriott International Reservation Data Warehouse Oracle databases
(approx. one terabyte).
Hands-on tester for all COTS Application and Oracle-based Data Warehouse.
Software development lead in Full SDLC including meeting with users, gathering and compiling user requirements (Method I), designing logical data models, and implementing sub-systems for data-mart.
Utilized Informatica PowerCenter, Crystal Reports, SQL, PL/SQL, including Stored Procedures/Functions, SQR Report Writer, MS Project, C, UNIX to PeopleSoft interface, Data Conversion, and Unix Shell Scripting.
Utilized Informatica PowerCenter tools to extract, transform, and load (ETL) data and create reports.
Written complex SQL scripts, tunings and utilized hints to optimize SQL performance.
Supported the Marriott International’s Reservation Data Warehouse, utilizing STAR schema methodology.
Performed system integration, regression, and unit tests for Data Warehouse Applications.
Developed test cases for white and black box testing. Performed software development life cycle (SDLC) testing as needed.
Implemented test procedures and processes to ensure that all applications are thoroughly tested.
Created tasks list for step by step procedures for white and black box testing, and assigned resources as required.
Evaluated new custom-of-the-shelf (COTS) applications.
Managed and lead various Human Resources application projects, including TEDS and GEMS applications.
Initiated Request for Proposal for various new software applications for Application Service Provider projects.
Planned and compiled next year budgets for individual projects.
Coached junior analysts on business and systems functionalities.
Coordinated resources from various departments to achieve projects’ objectives.
Performed troubleshooting for COTS applications. World Duty Free Americas, Incorporated, Glen Burnie, Maryland - Feb 2000 to Feb 2001 Oracle Financial Programmer/QA Analyst & Team Lead
Software development lead in Full SDLC including meeting with users, gathering and compiling user requirements, designing logical data models, and implementing sub-systems for 3-way invoice, receipt, and purchase orders matching.
Supported Oracle Financial Application 11i and utilized C, PL/SQL, including Stored Procedures/Functions, Developer 2000, MS project, and Unix Shell Scripting.
Lead the system integration test for Oracle Financial Application, including purchase orders/receipts matching sub-systems.
Performed regression and unit testing for purchase orders/receipts matching sub-systems.
Successfully implemented the new three-way purchase orders/receipts matching sub-system using PL/SQL, Unix Shell Scripts, and SQL/Plus. Resulted in 50% costs saving.
Developed inter-companies ledger reports for auditor, using SQL/Plus.
Designed and implemented Oracle reports for Oracle Payables sub-system, using SQL/Plus and Developer 2000.
Maintained Oracle General Ledger sub-system, using PL/SQL and SQL/Plus.
Resolved Oracle Financial Application systems related problems.
Utilized Developer 2000 to create and enhance Oracle Financial and Payables reports.
Created and maintained a manual accounting data feeder sub-system, using SQL/Plus and SQL-Loader.
Loaded and reconciled monthly sales data into Oracle General Ledger subs-system, using PL/SQL and SQL/Plus.
Congressional Quarterly, Incorporated, Washington D.C. Jul 1995 to Dec 1999 Senior Analyst/Programmer
Software development lead in Full SDLC including meeting with users, gathering and compiling user 8
requirements (Method I), designing logical data models, and implementing sub-systems for night-alert and automate web-publishing.
Utilized Perl, C, PL/SQL, including Stored Procedures/Functions, HTML, and Unix Shell Languages, SQL/Plus, Developer 2000, PL/SQL, SQL/Forms, C++, Digital Command Language (DCL), Lotus Notes, MS project, MS Access, SQR Report Writer, and full system life cycle project development.
Designed and implemented a Personal Library Software (PLS) full text state legislative database for the Washington Alert systems, using Oracle PL/SQL, SQL/Plus, and SQL Report; Developed a state legislative reporting system, using Oracle SQL/Plus.
Performed system test and hands-on implementation of COTS Application.
Developed test cases for white and black box testing and performed software development life cycle (SDLC) testing as needed for all COTS Application.
An assistant Database Administrator (DBA).
Created task lists and performed hands-on regression and unit test for all COTS Application.
Participated in Web development projects. Converted PLS databases into SGML and to HTML files.
Successfully redesigned, streamlined, and enhanced the news Night-alert sub-system and the Congressional schedule database that resulted in 30% costs saving.
Project Leader for the StatetNet project that automates the process of feeding the daily state legislative data to the state legislative full text database, using C, PL/SQL, Stored Procedures/Functions, SQL/Pus, and DCL.
Designed and implemented the FloorWatch and the NewsAlert PLS databases for the Congressional Quarterly World Wide Web site CQ.com, using SQL/Plus and PL/SQL.
Project lead for implementing an automated system for the Weekly Report publication. Ryland Mortgage Company, Columbia, Maryland Jan 1991 to Jul 1995 Financial Systems Analyst
Utilized Pascal, C, PL/SQL, including Stored Procedures/Functions, RDB/SQL, Digital Command Language
(DCL), MS project, MS Access, SQR Report Writer, Basic, and full system life cycle project development.
Hands-on software development life cycle (SDLC) including meeting with users, compiling requirements, including functional design, logical and physical design of database and implementation.
Lead analyst involved in designing, planning, and implementing the new Mortgage Backed Securities
Contact this candidate