TECHNICAL SKILLS:

Database Management Systems: MS SQL Server, Oracle RDBMS, NCR Teradata, EMC Greenplum, IBM Netezza, MongoDB, MySQL

Programming Languages: Java 2,5,6,7,8, JEE, TypeScript, Transact - SQL, PL/SQL, JavaScript, Python, Brio SQR, PeopleCode, Visual Basic, ASP, ASP.NET, VBScript, CFML, C#

Operating Systems: Unix (HP-UX, AIX, Solaris), Linux, Windows Server / Workstation, Windows 95/98, XP, 7, Vista

Other Tools and Technologies: Hibernate ORM, Pivotal Spring framework, Oracle Warehouse Builder (OWB) 10g R2 (10.2.0.4); JDeveloper Studio 11.1.1.1.0 , Apache Web Server, Tomcat, JBoss, Hibernate and Spring frameworks, Oracle / BEA WebLogic, IBM WebSphere, Struts, Oracle 10g AS. Informatica PowerCenter Versions 5.x,6.x,7.x, 8.x, 9.x; Informatica PowerExchange 8.6, 9.5.1,JBuilder, Eclipse, Ant, Oracle JDeveloper, IBM VisualAge for Java, Oracle Designer, Discoverer, AWS, HTML, XML (DOM, SAX), DHTML, Cold Fusion, Crystal Reports 6 - 10 Crystal Enterprise 8.5, 9, 10, IBM DataStage 7.5.x,8.0 IBM QualityStage 7.5.x,8.0, ADO, ODBC, JDBC, IIS 4 - 5, UML, ActiveX, VSS, Visual Interdev, Rational Rose, Brio SQR Performance Suite 8, Con-Dev SQR Runner, PeopleTools, CA ERWin, BPWin, Cognos Version 8.x Report Studio, Framework Manager

PROFESSIONAL EXPERIENCE:

Confidential, New Carrollton, MD

Senior Consultant

Responsibilities:

• Designed, developed and maintained Java enterprise (JEE) / serverless applications using various tools and technologies / frameworks including JavaServer pages, Java Servlets, Struts 2, JSF, EJB/JPA, JMS, Pivotal Spring framework (Spring Boot, Spring MVC, Spring Data JDBC, Spring Security, etc.), Hibernate ORM framework, JUnit, Mockito, Redis, web services, OAuth2, REST, SOAP, XML, Git, Maven, Docker, Puppet, Chef, Ant, Angular 2+ framework, Typescript, Javascript, RX JS, Grunt, Gulp, Jasmine framework, Karma, Bootstrap, CSS3, HTML5, JQuery, JSON, Eclipse IDE, IntelliJ IDEA IDE, PowerShell.
• Experienced in utilizing Amazon Web Services (AWS) cloud architecture, operations, administration, AWS CLI/SDK.
• Integrated AWS cloud services with scripts/code to create software solutions.
• Developed program units / scripts for relational databases including Oracle (PL/SQL), Greenplum (PostgreSQL), Microsoft SQL Server (T-SQL). Used IBM Rational ClearCase and ClearQuest. Developed Python programs with GNU bash shell scripts on Red Hat Enterprise Linux servers.
• Provided maintenance / troubleshooting support to help resolve technical issues with production systems by analysis and research.
• Applied internal and industry standards and created relevant documentation.

Confidential, Germantown, MD

Senior Developer

Responsibilities:

• Designed, created and maintained Oracle Java enterprise applications (JEE) using JavaServer pages, Java Servlets, Struts 2, JPA, Hibernate ORM / HQL framework, SOAP, REST, JMS, JUnit, JQuery, JavaScript, Oracle APEX.
• Data sources included the following Oracle relational databases: I-Manage Integrated Data Warehouse (IDW) - official standard accounting and reporting system (Management, Budget & Evaluation I-MANAGE STARS), Strategic Integrated Procurement Enterprise System (STRIPES), Oracle / PeopleSoft HRIS.
• Created and maintained various Oracle program units: PL/SQL procedures, functions, views / materialized views, triggers. Developed GNU bash shell scripts on Linux servers.
• Provided maintenance / troubleshooting support to help resolve technical issues with production systems.
• Applied internal and industry standards and created relevant documentation.

Confidential, Washington, DC

Senior Developer

Responsibilities:

• Installed and administered Informatica PowerCenter 8.6.1 and PowerExchange 8.6 components.
• Created and maintained various PowerCenter repository objects including sources, targets, transformations, mappings, mapplets, workflows and worklets for Confidential Information Management Program (AIM) Enterprise Data Warehouse and Board of Directors Data Mart project.
• Created and maintained various Oracle program units: PL/SQL procedures, functions, views / materialized views, triggers. EDW sources included SAP ERP, Regional Transportation District / TicketLift System, etc.
• Created relevant documentation.

Confidential, Arlington, VA

Senior Developer

Responsibilities:

• Utilized IBM DataStage / QualityStage v7.5, 8.0 to analyze, design and develop ETL processes and procedures to build and manage CAS (Claims Administration System). IBM DataStage / QualityStage were used to analyze / manage / process data from Oracle 10g, xml files and fixed-width / delimited flat files.
• Used IBM QualityStage v7.5, 8.0 to design data quality assessments, matching, and standardization processes.
• Used SQLPlus, SQL Developer and Quest TOAD IDE to create PL/SQL program units (packages, functions, stored procedures, views and triggers) within Oracle 10g databases. Used DataStage Designer to create DataStage Parallel and Server jobs.
• Used DataStage Director to validate, schedule, run, and monitor DataStage jobs.
• Used DataStage Manager to edit contents of the Repository.
• Created parallel jobs using various DataStage PX stages.
• Created local and shared containers.
• Created and configured job sequences to transfer data to target Oracle 10g tables using IBM DataStage.
• Automated execution of ETL processes using CRON scheduler. Created relevant documentation.

Confidential, Delray Beach, FL

Senior Developer - Data Warehouse

Responsibilities:

• Analyzed, designed and developed ETL processes and procedures using IBM DataStage v7.5.X for building and managing data warehouse.
• IBM DataStage was used to manage / process data from Oracle 10g and Teradata V2R5 RDBMS, xml files and fixed-width / delimited flat files.
• Used Oracle E-Business Applications 11i database schema (Oracle 10g RDBMS) as a source to extract customer data to Datasets / Filesets / Sequential files and populate / apply changes to Teradata tables.
• Created and executed BTEQ scripts to manipulate data within Teradata tables.
• Used DataStage Designer to create DataStage Parallel and Server jobs.
• Used DataStage Director to validate, schedule, run, and monitor DataStage jobs.
• Used DataStage Manager to edit contents of the Repository.
• Created parallel jobs using various DataStage PX stages.
• Created local and shared containers.
• Created and configured job sequences to transfer data to target data warehouse tables using IBM DataStage.
• Automated execution of ETL processes using ESP scheduler.
• Used IBM QualityStage v7.5 to design data quality assessments, matching, and standardization processes.
• Used SQLPlus, SQL Developer and Quest TOAD IDE to create PL/SQL program units (packages, functions, stored procedures, views and triggers) within Oracle 10g databases.
• Utilized Oracle JDeveloper IDE to create and maintain J2EE Web applications.
• Built component-based user interfaces using JavaServer Faces and ADF Faces.
• Used the ADF Model to bind user interfaces to backend business services.
• Created menus, home pages, edit pages, and interfactive search pages. Incorporated container-managed security policy based on standard Java APIs.
• Executed PL/SQL program units from web applications.
• Migrated Oracle Forms applications using Oracle JHeadstart.

Confidential, Fort Lauderdale, FL

Senior Developer

Responsibilities:

• Analyzed, designed and developed ETL processes and procedures using Informatica PowerCenter version 7.1.3 / 8.1.0 for building and managing operational data store (ODS).
• Informatica was used to manage / process data from Oracle and Teradata RDBMS, xml files and fixed-width / delimited flat files.
• Used Fidelio cruise management consolidation database (Oracle 10g RDBMS) to extract marketing data for reporting.
• Used Versonix SEAWARE cruise reservation database (Oracle 9i RDBMS) to extract sales, marketing, ship / hotel / air inventory data for various reporting needs.
• Implemented ETL procedures to provide / process data feeds to / from DSI.
• Utilized CA ERwin CASE tool to design / create schemas in ODS.
• Developed reusable transformation objects and mapplets.
• Created and utilized mapping parameters and variables.
• Created the following types of transformations: Aggregator, Source Qualifier, Expression, Filter, Joiner, Lookup, Normalizer, Rank, Router, Sequence Generator, Sorter, Stored Procedure, Transaction Control, Union, Update Strategy, XML Generator, XML Parser, XML Source.
• Developed workflows with various types of tasks to run mappings and control the logic of the operations.
• Imported / created source definitions in the Source Analyzer. Used the Warehouse Designer to import and design target definitions.
• Created and Configured Workflows, Worklets, and Sessions to transport data to target data warehouse tables using Informatica Workflow Manager.
• Automated ETL processes using Informatica Scheduler, parameter files, Email, Decision, Event wait, Event Raise, Command Tasks, PMCMD and shell scripts. Used SQLPlus and Quest TOAD IDE to create PL/SQL program units (packages, functions, stored procedures, views and triggers) within Oracle 8i, 9i, 10g databases.
• Used Oracle SQL Loader to populate relational tables from flat files. Used Eclipse IDE to create and maintain Java-based Struts Web applications.
• Streamlined application logic using the Model-View-Controller architecture. Enhanced JSP development using the Tiles templating library.
• Configured and used the built-in declarative exception handler. used the JSP Standard Tag Library (JSTL).
• Worked with the Struts, Tiles, and Validator configuration files. Secured Struts applications.
• Performed a variety of unit tests on Struts applications.
• Used AJAX with Struts. Developed and maintained Java-based application to process Guest Travel Booklet (GTB) requests from SeaWare database to properly format them into files to be processed by LOFTWARE labeling software suite.
• Created UML use case diagrams. Used Ant to manage projects, integration, and deployment.

Confidential, Miami Lakes, FL

Senior Developer

Responsibilities:

• Analyzed, designed and developed ETL processes and procedures using Informatica PowerCenter / PowerMart version 6.2.2 OEM for Siebel for building, deploying, and managing enterprise data warehouse. Informatica PowerMart was used to manage data from disparate enterprise systems and sources and to load data into a dimensional database.
• Used CA ERwin CASE tool to design and create data warehouse schemas.
• Utilized Informatica PowerMart to work with fixed-width and delimited flat files, relational tables, views as sources in a variety of mappings.
• Developed reusable transformation objects and mapplets. Used SQLPlus and Quest TOAD IDE to create PL/SQL packages, stored procedures, functions, triggers within Oracle 9i databases. Created the following types of transformations: Aggregator, Source Qualifier, Expression, Filter, Joiner, Lookup, Normalizer,Rank, Router, Sequence Generator, Sorter, Stored Procedure, Update Strategy, XML Source Qualifier.
• Developed workflows with various types of tasks to run mappings and control the logic of the operations.
• Imported / created source definitions in the Source Analyzer. Created and Configured Workflows, Worklets, and Sessions to transport data to target data warehouse tables using Informatica Workflow Manager. Automated ETL processes using Informatica Scheduler, parameter files, Email, Decision, Event wait, Event Raise, Command Tasks, PMCMD and UNIX Shell scripts.
• Created Korn shell scripts and executed them through command tasks to implement various processes.
• Used Oracle SQL Loader into the respective databases. Used Brio / Hyperion SQR to create and schedule data cleansing scripts for data extracts from various legacy systems.
• Confidential ' legacy systems included the following: PQMS (Oracle 7 / UNIX), RGS (Oracle 8 / UNIX), DCS (DB2/AS400).
• Database schemas contained the following data: customer contacts, accounts, sales orders, returns, products, complaints, patient data, etc.
• Used Eclipse IDE to maintain and develop JavaServer Pages / Servlets in corporate J2EE portal (Apache / Tomcat servlet container).
• Used Ant to manage projects, integration, and deployment.

Confidential, Plantation, FL

Senior Developer

Responsibilities:

• Created / Modified / Executed SQR program units, PS Queries, Crystal reports, PS/nVision reports in PeopleSoft HRMS V 8.8 / Oracle 9i environment.
• Executed SQR program units from within PeopleSoft using Process Scheduler.
• Created SQR reports that ran without user input.
• Created SQR reports that accepted user-defined input parameters.
• Created Process Definitions and linked them to menu items to launch SQR reports from PeopleSoft HRMS product.
• Granted access by assigning run control components to permission lists associated with specific roles.
• Created SQR programs that loaded data into database tables.
• Used PeopleSoft library files to leverage the power of reusable code.
• Created / modified SQR programs that required generating multiple reports.
• Created complex interface programs for the output of text files.
• Followed XML Spreadsheet (XMLSS) schema specification to create XML files (in SQR scripts) for Microsoft Excel 2002 / 2003.
• Created XML files (XMLSS) for Microsoft Excel 2002 / 2003 that had the following features: character, number and date placement in any cell; Support for complex formulas;
• Multi-spreadsheets in one MS Excel file; various fonts, borders, colors, format; AutoFilter; Page Breaks; Margin control; Sheet and Cell protection; Split and Freeze of Windows.
• Utilized functions that allowed the program flexibility in interacting with dynamically built criteria based on user input.
• Used SQR arrays, Oracle global temporary tables to make programs more efficient.
• Implemented performance tuning of PL/SQL statements within SQR scripts. Created relevant documentation.