Candidates About

Taib Ibrahim

SUMMARY OF QUALIFICATIONS

Taib has over nine years of Information Technology experience at software development companies within the government, real estate, fixed income banking and health care industry.  He has spent the last six years mainly in data analysis roles for Oracle, SQL Server, Netezza data warehouse and pipe delimited/semicolon files along with some web development.

KEY SKILLS

v  Project Domain: Customer Relationship Management, Marketing, and Advertisement

v  Languages: PL/SQL, HTML, CSS, Bootstrap, XML, XSLT, JavaScript, JSON, Visual Basic, ASP, PHP, Python

v  Operating Systems:  LINUX, UNIX, WINDOWS

v  RDBMS: Oracle 10g, 11g, MySQL 4.1, SQL Server, Microsoft Access, Netezza

v  Version Control Tool and Software: CVS, PVCS, WINSCP, IDEA IDE 6.0, JIRA, Confluence, Clarity

v  Development Tools: TOAD Data Point, SqlDiffFramework 1,0.3.0, SQL Developer, SQL Navigator, WinSQL, SQL*PLUS, SQL*Loader, Selenium IDE, ANT, Dreamweaver Mx, WordPress, SecureCRT, Cygwin, Informatica Powercenter 9.1, Crystal Reports

EXECUTIVE SUMMARY

v  Experience with navigating through relational data models in 3rd normal form to properly query OLTP/OLAP databases.

v  Experience with understanding Ralph Kimball’s data warehousing methodology for a star schema.

v  Experience with Ralph Kimball’s methodology for data modeling techniques utilizing conformed dimensions, slowly changing dimensions, fact and factless tables for a data warehouse.

v  Experience with creating use and test cases based on documentation provided for application redesign, newly incoming source provider data feeds and any SDLC project requirements.

v  Experience with communicating and training off-shore QA team with using web-based applications and best test development methodologies.

PROFESSIONAL EXPERIENCE

Northwell Hospital, August 2015-December 2017

Office: New Hyde Park, NY

Role:  Data Analyst

• Validate SSIS ETL data migrated/mapped accurately from SQL Server 2012 to Oracle 11g using Toad Data Point and SqlDiffFramework for up to billions of records of data within a table.  Utilize some Oracle hints to optimize source to target data comparison/mapping for healthcare inpatient/outpatient and claims data for a datawarehouse Star/OLAP Schema.
• Create custom advanced PL/SQL subqueries cleansing scripts to fix data discrepancies such as Orphan records, duplicate data, etc using conditional logic for SSIS ETL transformations and data mapping from source to target.
• Utilize SQL function queries for XML Query and XMLTable data manipulation from Oracle XML DB repository.
• Perform the implementation of data loading, conversions, integration, testing and validation by assisting data architect with data modeling and using complex SQL by creating objects such as Tables, Views, Stored Procedures, Functions and PL/SQL/Merge Statements for Crystal Reporting purposes.  
• Perform data analytics, performance tuning using Explain Plan/Statistics/Indexes, profiling raw data files, metadata, mapping, functional, regression, black-box testing, and smoke testing using SQL/PLSQL within a SCRUM/AGILE methodology for healthcare Medicaid/Medicare inpatient/outpatient and claims data for Star Schema data warehouse.
• Experience with documenting, tracking, profiling and verifying data defects in assigned database applications and in flat/log files on LINUX/Windows operating system using commands based on client facing discovery of data discrepancies.

• Experience with developing, documenting BRD/FRD’s and implementing QA Standards for assigned relational and data warehouse database applications based on software requirements from clients and users with Jira and Confluence.
• Created/Executed quality assurance test plans, test scenarios, test cases, checklist and validation scripts that match to functional specifications, design and business requirements from client requirement sessions with Jira and Confluence.
• Held responsible for estimating, planning and executing testing activities to completion of lifecycle of defects for clients.

Sixteen-Things-Kids-Can-Do Org, March 2017-Present

Office: New York, NY

Role: Web Developer

• Develop web pages with WordPress using various HTML tags with nesting of tags within the body section of HTML documents for HTML 5 to display content and for responsive web design with Bootstrap Framework.
• Utilize CSS to style web pages by using some inline or global font, text, background, positioning, box model, list style, outline, table, border, and page break properties to style the HMTL page element layout in HTML 5.
• Utilize JavaScript to customize the behavior of clickable buttons and element attributes/content/style on HTML pages.

CKGS, January 2015-July 2015

Office: New York, NY

Role:  Data Analyst

• Ensured accuracy of metadata through performing data analytics on raw flat files and ensuring web-based applications populating consumer data using MSQL Serve OLTP database to properly store data by creating complex T-SQL logic in order for customer Indian VISA application processing.
• Used V-Lookup and Pivot table function in Excel to search/summarize data requirements and query MS SQL Server database to ensure data business logic is accurate for VISA application processing.
• Created test plans and executed test cases to ensure the functionality of Web-based/Desktop applications displayed accurate data along with utilize Informatica 9.1 session properties to load source/target data.

Cablevision, May 2014-December 2014

Office: Bethpage, NY

Role: Application Deployment & Support Data Analyst

• Deploy code written by developers to UAT environment by checking out code from PVCS and executing UNIX, SQL/PLSQL Oracle and Netezza OLTP/OLAP Star Schema data warehouse scripts from UNIX Korn Shell and SQL*PLUS.
• Assist developers in AGILE environment triaging where code failures/metadata issues are occurring when trying to deploy code in UAT environment so the developer can fix problem quickly and to ensure when I deploy code in production the success rate is basically guaranteed to be error free.
• Defined, documented and validated Media/Sales/Customer business requirements. Reviewed business requirements with internal/vendor programmers and ensured understanding of application functionality.
• Utilize Appworx (UC4) to run required jobs that are part of chain for code deployments.
• Utilize Informatica 9.1 to import jobs within WorkFlow manager developed by ETL developers.

Epsilon, March 2013-March 2014

Office: Wakefield, MA

Role:  Production Data Analyst

• Troubleshoot daily failures in AGILE environment for metadata/data modeling issues, data file processing/integration feeds developed in UNIX Shell scripts to load data from Oracle database to operational/customer datamarts in Netezza data warehouse.
• Executed SQL scripts in an OLTP and Netezza Star Schema data warehouse to ensure IBM UNICA marketing campaigns, and SAS Admin jobs can extract and post correctly to Pharmacy providers Biogen, Sunovion and other consumers to track KPI.
• Generated complex SQL subqueries with inner, outer joins, and aggregate functions to update and delete data in Oracle database and Netezza Star Schema data warehouse.
• Utilize LINUX/UNIX commands (vi, ls, mv, cd, /, grep, wc, head, tail, find,.etc) to ensure files are in appropriate directory paths; troubleshoot raw file data issues by performing data analytics and file counts are correct for files to be processed by UNIX jobs that also execute SQL scripts.
• Utilize sFTP protocols to move files between production, qa and stage environments using commands (get, put, bye, exit, chmod).
• Managed offshore team and documented technical system processes for them to perform daily tasks.

IGATEPatni, December 2011-November 2012

Office: Cincinnati, Ohio

Client: General Electric Aviation

Role: SQL Server/Informatica Analyst

• Provided daily production support for data loading activities from various source suppliers’ data warehouse into a target SQL Server database using T-SQL and Informatica.
• Manually execute ETL workflows using workflow manager and task manager in Informatica 9.1 Powercenter.
• Validated data successfully loaded into staging SQL Server tables by verifying workflow monitor record count matches the records in SQL Server stage table.
• Provided source data suppliers with information regarding bad data they are sending when workflow errors/failure occurred and performed data analytics/profiling on raw flat files.

Role: Oracle/Appworx Analyst, December 2011-September 2012

• Provided database production support to correct data discrepancies using Oracle SQL/PLSQL through creating anonymous blocks.
• Utilized SQL Loader and Appworx to load and process data feeds into appropriate Oracle tables for TIPQA application.
• Tested web based applications to ensure new functionality or bug fixes worked according to specifications.

REI Systems Inc, June 2009-October 2011

Office: Chantilly, VA

Client: Department of Justice, Washington DC

Role: Oracle Database Developer

• Created complex ad hoc Crystal reports using SQL to create correlated/non-correlated subqueries, inline subqueries, and union, single row/aggregate functions for the DOJ grant management system in order to provide statistics of their funding activity for organizations across the United States.
• Created PL/SQL functions to pass and return appropriate parameter values to stored procedures and complex SQL queries to process CSV and XML raw files that I performed data analytics/profiling on for accuracy.
• Provided OLTP production support by correcting several data discrepancy utilizing PL/SQL anonymous blocks using nested Cursors/For Loops, IF/Fetch Statements, and Variables to insert, update and delete data from several DOJ relational databases.

Bootstrap Software Inc., November 2006-April 2009

Office: New York, NY

Role: Data Analyst

• Worked in an OLTP production environment to create several ad hoc report requests for statistical information about CB’s real estate insurance properties, brokerages, offices and agents using Oracle 9i/10g through creating correlated/non correlated subqueries, inline subqueries, union, single row/aggregate/analytical functions and researched about Oracle SQL to produce reports in a timely fashion.
• Used SecureCRT to navigate to appropriate directories to locate/profile comma separated value (CSV) flat files and to manipulate existing control files from data feed providers to load data into staging tables using Oracle SQL Loader. 
• Created PL/SQL anonymous blocks using Cursors, IF/Fetch Statements, Variables and For Loops to manipulate data to support application functionality and business rules.
• Troubleshoot and enhanced existing MYSQL and PL/SQL Stored Procedures for client reporting applications in a production environment for a Star Schema data warehouse.
• Worked in preparing documents like Target to Source Document, Data Model Testing and Test Scenarios (UAT).
• Created SQL subqueries using Oracle 9i/10g to validate CB’s business requirements (No Photo/Six Photos rule) and to update data in the database to ensure when stored procedures are executed for CB’s office listing rule.

Role: Business/QA Analyst Projects

• Performed manual testing for new features and functionality implemented to existing client reporting Real Estate web applications owned by Realogy.
• Utilized Selenium IDE automation tool, created build.xml files, html wrapper scripts and used Ant to run the automated tests as a full suite.
• Researched, installed Ant and figured out how to run automated test via Linux command line using Cygwin.
• Developed and maintained over 300-user acceptance use and test cases and created some BRD/FRD’s.
• Worked with QA Team lead to create documentation on how to use Selenium IDE.

Complex Corporation, January 2006-October 2006

Office: Great Neck, NY

Role: Software Quality Assurance Analyst

• Tested client-server desktop medical billing applications developed in Delphi, Pascal, Crystal Reports, and Oracle 9i to ensure applications were compliant and functional with medical industry regulation standards by (HIPAA).
• Performed data analysis on patient’s medical history and payment processing through creating ANSI SQL queries using Oracle 9i, SQL Monitor and SQL with the usage of single row/aggregate functions, group by, order by, having and where clause, joins, insert, update, delete and select statements. 
• Tested a PDA application to ensure the quality of patient’s data is being properly stored in PDA mobile application and syncing correctly to doctor’s desktop PC application so that doctors will be able to use PDA’s while traveling to facilities.
• Troubleshoot and instructed clients how to use medical billing software applications in order to produce desired results for medical claim processing, billing, scheduling, and previewing validation reports for Medicaid/Medicare.

EDUCATION & SECURITY CLEARANCE

The University of North Carolina at Greensboro                                                                                              

B.S. in Information Systems & Operations Management, Concentration: Information Systems; December 2004

B.S. in Business Administration, Concentration: Marketing; December 2004

Certificate: Learning Tree International Training New York, NY

Trained and passed examination for Oracle Database 10g:  A Comprehensive Hands-On Introduction.

Clearance –Public Trust/SBI (Received security clearance in order to work for the Department of Justice