Candidates About

 

Riadh Nassir

 

SUMMARY:

A Professional in Information Technology is interested in working for a stable Organization.

•       IT professional with over 10 years of experience in Database application development, Data Management, business intelligence and technical support and leadership.

•       Over 10 year experience in relational Database environments, with extensive experience in Oracle DBA and PL/SQL. Strong SQL skills. 

•       Over 4 year in ETL, using in house tools.

•       Over 4.5 year on Data Warehouse projects

•       Experience in Business Intelligence.

•       In depth experience with UNIX. 

•       Strong communication skills.

•       Proven experience implementing and customizing a Web Architected, n-tiered Enterprise applications.

 

TECHNICAL SKILLS:

 

•       Leadership

•       ETL, OWB (Oracle Whouse Builder) in n-tiered Enterprise Applications.                    

•       Oracle 9i – 12c IAS Upgrade & Apps Migration          

•       Experience with data modeling, using ERWIN.           

•       LDAP (Lightweight Directory Access Protocol)           

•       Oracle – APPS DBA             

•       Erwin 9.x                   

•       BIAP Reports.

•       QTP, Quality Center background, strong in SQL queries, CRM applications and Documentum.

•       Email Infrastructure

•       Network Architecture and topography including typical router, load balancing, proxy services

•       SFDC Development or Administrative experience

•       O365 deployment/support experience,

•       Box deployment/support experience

•       HIPAA, PCI, PII, ITAR, GLBA, SOX, etc.

•       SAAS Cloud based offerings

•       Data Encryption.

•       SSO

•       SFDC

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

BUSINESS SKILLS:

•       Leadership                 

•       Software Engineering | Core Java | JSP | Spring Framework | Web Logic | Cross-Functional Collaboration

•       Oracle Database Engineering | PL/SQL Development | Database Design | Data Warehousing

•       Oracle RAC | ASM | Backup & Recovery | Tuning & Optimization | Knowledge Data Guard | Oracle Streams | Advanced Replication | Oracle Label Security | OEM Grid Control | Linux Shell Scripting |

 

TRAINING:

Oracle Performance Tuning, Oracle Inc., March 2005

 

Education:

University of Pennsylvania, Masters in Computer Science, Philadelphia, PA 19104

Moore School of Electrical Engineering, Computer and Information Sciences Department.

 

EXPERIENCE: 

 

RBN Consulting, Havertown, PA                                                           Nov 2017 – Present

ETL/Data Modeler/Oracle Database Developer

 

Worked in Production Support, and adding new Product Releases. Worked on additions to the Production Management system, with Oracle 12 c databases, and PL/SQL Using Informatica in a Data Warehouse environment.

 

As a Database Developer for the Operations Website Portal, , I provided high quality technology Solutions that address business needs by developing feature enhancements to the Website Portal, i.e. Operations Metrics Portal. l delivered strong object-oriented design skills and strong analytical capabilities. Especially in the Area of distributed computed infrastructures. My other strengths would include experience with TDD/Agile development methodologies and other programming languages.  My requirements Gathering knowledge was a great help in creating feature enhancements.

 

·         Analyze, develop, modify and test Oracle PL/SQL packages and stored procedures used by the form triggers for data retrieval and processing.

·         Developed and modified Linux/Unix shell scripts used to process data for generating reports requested by other processes or forms.

·         Prepared SQL scripts used to create and modify objects and data seed used in database development for a specific product release.

·         Modified and tested translated Java and XML files using Eclipse and Vagrants.

·         Used TortoiseSVN and GIT for version control of all modified files for releases that were checked in/out of the repository.

·         Worked in General product that interacts with all other products in the application.

·         Ensure proper changes are executed for the planned release and that a formal process is followed regarding the tracking and management of application bugs in compliance with quality and IT requirements.

·         Knowledge of (CI/CD) methodologies

·         Knowledge/Understanding of RESTful APIs

·         Knowledge/Understanding of Cloud native Platforms like PCF (Pivotal Cloud )

·         Knowledge/Understanding of Cloud Data stores – In-Memory/Persistent.

·         Knowledge/Understanding of Logging - using tools.

 

 

 

 

 

Infosys Limited Inc., Atlanta/Marietta,                          Nov 2015 – Nov 2017

Consulting For FDC Financial Services Client.

Data Developer/Data Modeler

As a Database Developer for the Operations Website Portal, , I provided high quality technology Solutions that address business needs by developing feature enhancements to the Website Portal, i.e. Operations Metrics Portal. l delivered strong object-oriented design skills and strong analytical capabilities. Especially in the Area of distributed computed infrastructures. My other strengths would include experience with TDD/Agile development methodologies and other programming languages.  My requirements Gathering knowledge was a great help in creating feature enhancements.

 

·         Analyze, develop, modify and test Oracle PL/SQL packages and stored procedures used by the form triggers for data retrieval and processing.

·         Developed and modified Unix shell scripts used to process data for generating reports requested by other processes or forms.

·         Prepared SQL scripts used to create and modify objects and data seed used in database development for a specific product release.

·         Modified and tested translated Java and XML files using Eclipse and Vagrants.

·         Used TortoiseSVN and GIT for version control of all modified files for releases that were checked in/out of the repository.

·         Ensure proper changes are executed for the planned release and that a formal process is followed regarding the tracking and management of application bugs in compliance with quality and IT requirements.

·         Knowledge of (CI/CD) methodologies

·         Knowledge/Understanding of RESTful APIs

·         Knowledge/Understanding of Cloud native Platforms like PCF (Pivotal Cloud )

·         Knowledge/Understanding of Cloud Data stores – In-Memory/Persistent.

·         Knowledge/Understanding of Logging - using tools.

 

 

 

•       Strong in SQL queries in addition to strong experience in CRM applications, Data migration Visio 6.x and Documentum. Worked with more than 150 tables and schemas

•       Primary point-of-contact, post-implementation, to support  Data Mining activities, including Workflow creation for data mining needs, Support for best practices, User guidance, Issue resolution. Perform these functions and Coordinate/ Execute user acceptance test (UAT) efforts before promotion to Production.

 

KFORCE Inc., King of Prussia, PA       Contract                       June 2015 – November 2015

Consulting For JP Morgan Chase Bank,

Data Modeler/Developer

As a Database Developer for the Operations Metrics Portal, OMP, I Built high quality technology Solutions that address business needs by developing feature enhancements to the OMP Portal, i.e. Operations Metrics Portal. l delivered strong object-oriented design skills and strong analytical capabilities. My other strengths would include experience with TDD/Agile development methodologies.  My financial knowledge was a great help in creating NEW features.

 

As an experienced Engineer capable of architecting and engineering Components of Database-as-a-Service (DBaaS)

Create metrics and reporting dashboards to support cross organizational needs. 
Produce / deliver recurring and non-recurring metrics & reporting products ensuring accuracy and on-time delivery - report creation and distribution, dashboard development. 

Work with Cloud and containerization technologies to Containerize and Deploy dashboard solutions into Cloud. 
Responsible for building dashboard solutions for monitoring, logging, alerting, and reporting capabilities of CI/CD pipelines and the health of lower and higher environments.

Work in Financial Services using IBM Information Framework (IFW) Industry models, to map key enterprise banking business processes into IFW based Process (BEPL),

 

VMWare – ability to build VMs and server farms (large amount of VMs like 50-100).

Familiar with DNS, DHCP, Apache/Nginx, routing, IP addressing (IPv4 & IPv6), VLANs, packet analysis, network troubleshooting, etc.

Scripting – bash, Perl and XML scripting.

 

As a Data Modeler I am experienced with data modeling, using ERWIN.

 

As an Application Developer in Oracle 11g, l participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed IT solution. l participated in design reviews and provided input to the design recommendations; incorporated security requirements into design; and provided input to information/data flow and generally was involved in the full Project Life Cycle.  Additionally, l documented the detailed application specifications, translated technical requirements into programmed application modules and developed/enhanced software application modules in Oracle.

 

 

 

Blue Cross/Blue Shield BCBSM     Contract                                                                     Dec 2013 - June 2015

ETL/Oracle Database Developer

Data Modeler/Developer

•       Worked in Production Support, and adding new Product Releases. Also worked on additions to the Healthcare Management system, with Oracle 12c database and PL/SQL Using Informatica in Data Warehouse environments.

•       Familiar with Service Oriented architecture and web services integration SOAP, WSDL,REST

•       Experience with JavaScript, XML, HTML

As a Solutions Architect:

Release management of products on Bi-Weekly basis using Source Code management tools i.e. subversion.

Strong Agile Methodology on a Bi-Weekly basis in software and business systems design, analysis, and deployment.

As a Data Modeler I am experienced with data modeling, using ERWIN.

Installed and managed Oracle RAC databases on VMware and Virtual Box environments using Linux and Windows.

 

Devised and managed Oracle Label Security (Virtual Private Database) to ensuring data isolation between retail brands on Clients Enterprise’s common e-commerce platform.

 

Setup Data Physical Standby Using the Data Broker and Grid Control in Oracle Database 11g Rel 2, also designed databases to support Oracle 12c functionality.

 

Devised and managed Oracle Streams to propagate partners’ catalog and product availability changes between Live and Off DC databases of Clients Enterprise’s common e-commerce platform.

 

 

RBN Consulting, Havertown, PA                                               June 2011 – Dec 2013

ETL/Oracle Database Developer

Solutions Architect

•       Responsible for the Migration and Upgrade of multiple databases. Requirements Gathering, Design, Implementation, Training/Testing of Software Development for Remediation efforts.

•       As a Data Modeler I am experienced with data modeling, using ERWIN.

•       Familiar with Service Oriented architecture and web services integration SOAP, WSDL,REST

•       Experience with JavaScript, XML, HTML

•       Familiar with LDAP, MS Active Directory.

•       Developed numerous Oracle IAS reports and SQL*Plus to summarize monthly and weekly accounts receivable data.

•       Performance Optimization. Employed Explain Plan and SQL*Trace to analyze query path and performance. Tuned SQL scripts statements for their optimum performance.

•       Created PL/SQL code as required to support Daily, Weekly Batch Processes.  Additional Qualifications:

•       Interfacing with the architectural governance team, which owns the logical data models (In IFW parlance it's the BOM - Business Object Model).

•       Reviewed business object Model, logical data model, physical data model and existing services.

•       Strong in SQL queries in addition to strong experience in Wealth Management Processes, IA applications, Meta Data migration Visio 6.x and OWB (Oracle Warehouse Builder) in Oracle. Worked with more than 150 tables and schemas.

•       Business Analyst and Team Coordinator for on shore and off shore development.

•       Primary point-of-contact, post-implementation, to support  Data Mining activities, including Migration and Upgrade needs, Support for best practices, User guidance, Issue resolution. Perform these functions and Coordinate/ Execute user acceptance test (UAT) efforts before promotion to Production.

 

 

RBN Consulting, Havertown, PA                                               Oct 2008 – June 2011

ETL / Oracle Database Developer

 

•       Responsible for the ESA (Enterprise Sys Arch.) Requirements Gathering, Design, Implementation, Training/Testing of Software Development for Employee Management System (EIMS) Remediation effort.

•       Developed numerous Oracle IAS reports and SQL*Plus to summarize monthly and weekly accounts receivable data.

•       Created PL/SQL packages and UNIX Scripts. Extensive experience with UNIX technologies.

•       Performance Optimization. Employed Explain Plan and SQL*Trace to analyze query path and performance. Tuned SQL scripts statements for their optimum performance.

•       Created PL/SQL code as required to support Daily, Weekly Batch Processes. Implemented dimensional data models and ETL design utilizing using Informatica.  Additional Qualifications:

•       Strong in SQL queries in addition to strong experience in CRM applications, Data migration Visio 6.x and Documentum. Worked with more than 150 tables and schemas

•       Primary point-of-contact, post-implementation, to support  Data Mining activities, including Workflow creation for data mining needs, Support for best practices, User guidance, Issue resolution. Perform these functions and Coordinate/ Execute user acceptance test (UAT) efforts before promotion to Production.

•       Interact with all Research areas to define comprehensive data ontologies to support the integration of multiple Research systems to meet Research IS’ long-term systems Strategic Planning.

•       Support the integration of Research systems, such as Research Management System, Integrated Research Workflows, Ingenuity, LIMS, to support progress within Translational Science and multiple Therapeutic Areas to maximize speed for Research projects.

 

GSK Inc., Philadelphia, PA      Permanent                                                                                  Feb 2007 – Sep 2008

ETL / Oracle Database Integration Specialist

Technical Lead: SFA (Sales Force Automation Data Warehouse Test Team)

 

•       Served as the Technical Lead during testing phases of Territory & Portfolio Indexing Project.  ETL tool was in house product and was very similar to Data migration.

•       Offshore project requirements definition and Implementation, on a daily basis, managing the compliance of the program with its initial requirements, and the translation of Business needs to programmers and developers.

•       Offshore project training: Trained an offshore team to support the production system and to enhance the related documentation for solving problems, and solving issues in the database.

•       Created PL/SQL and UNIX Scripts for and supported the Prescriber to Territory relationships. In addition to strong experience in CRM applications Data migration Visio 6.0 and Documentum.

•       Designed and developed reports for applications. The interface from the applications will publish all the reports to the web.

•       This also includes ‘Future Territories’  which denotes that this may not be the Current Alignment but will be Current by the time this Month/Quarter’s Account Targeting data is loaded to SFA (Sales Force Automation DWT Team).

•       Modify PL/SQL code for batch processes and perform unit testing in the development environment

•       Experience architecting, designing, and deployment environments for global web-based systems
Extensive experience with UNIX technologies.

 

 

 

IMS Health, Plymouth Meeting, PA                   Contract                                                     Apr 2006 – Feb 2007

ETL / Oracle Database Developer:

 

GMR Data Migration Project

•       The IMS Healthcare Relational Spheres (HCR) is developing GMR Data Migration operations in the ETL healthcare sector.

•       As an Oracle database developer/analyst, developed PL/SQL and UNIX Procedures and Packages for MII core database based on the views in the MII Core database.

•       Wrote PL/SQL scripts and packages to validate and analyze the data architecture, and Data Sources.

•       The views were designed to map the required fields in the MII Core tables to corresponding fields in the tables in the Data Warehouse.

•       Maintained Metrics log information of the extracts in the metrics log table.

•       Separate special onetime processing was scripted to load the history data into HCRS Data Warehouse.

 

 

Wyeth Inc., Collegeville, PA                 Contract                                                                       Mar 2005 – Mar 2006

ETL / Oracle Database Developer / Analyst

•       Responsible for the development, maintenance and support of the PL/SQL Functions and Packages in Oracle 9i, and UNIX interfaces used in the ETL Sampling process.  ETL tool was developed in house.

•       Created interfaces in PL/SQL and UNIX Scripts supporting Inbound Sampling to Outbound Sampling