SUMMARY:

• 8+years of Information Technology experience at software development companies within the government, real estate and health care industry. Expect in data analysis roles for Oracle database, Netezza data warehouse and pipe delimited/semicolon files.
• Experience with navigating through relational data models in 3rd normal form to properly query OLTP databases.
• Experience with understanding Ralph Kimball’s data warehousing methodology for a star schema.
• Experience with Ralph Kimball’s methodology for data modeling techniques utilizing conformed dimensions, slowly changing dimensions, fact and factless tables for a data warehouse.
• Experience with creating use and test cases based on documentation provided for application redesign, newly incoming source provider data feeds and any project requirements.
• Experience with communicating and training off - shore QA team with using web-based applications and best test development methodologies.

TECHNICAL SKILLS:

Project Domain: Customer Relationship Management, Marketing, and Advertisement

Languages: PL/SQL, HTML, XML, Visual Basic, ASP, LINUX, UNIX

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

Version Control Tool and Application: CVS, PVCS, WINSCP, IDEA IDE 6.0

Development Tools: TOAD, SQL Navigator, WinSQL, SQL*PLUS, SQL*Loader, Selenium IDE, ANT, Dreamweaver Mx, SecureCRT, Cygwin, Informatica Powercenter 9.1

PROFESSIONAL EXPERIENCE:

Confidential, Bethpage, NY

Data & Support Analyst

• Deploy code written by developers to UAT environment by checking out code from PVCS and executing UNIX, SQL/PLSQL Oracle and Netezza scripts from UNIX Korn Shell and SQL*PLUS.
• Assist developers in identifying where code failures 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.
• 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

Confidential, Wakefield, MA

Data Analyst

• Troubleshoot daily failures for data file processing feeds developed in UNIX Shell scripts to load data from Oracle database to operational/customer datamarts in Netezza.
• Executed SQL scripts in Netezza data warehouse to ensure marketing campaigns can extract and post correctly to health care providers and consumers.
• Generated complex SQL subqueries with inner, outer joins, and aggregate functions to update and delete data in Oracle database and Netezza data warehouse.
• Utilize UNIX commands (vi, ls, mv, cd, /, grep, wc, head, tail, find,..,etc) to ensure files are in appropriate directory paths; troubleshoot file data issues 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.

Confidential, Cincinnati, Ohio

Data Analyst /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 Informatica.
• Manually execute 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.

Oracle/Data Analyst

• 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.

Confidential, Chantilly, VA

Oracle Database Developer

• Created complex ad hoc 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 organization’s across the United States.
• Provided 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.
• Worked with CVS to maintain and execute SQL scripts as well as SQL*PLUS to spool scripts to text file.
• Created PL/SQL functions to pass and return appropriate parameter values to stored procedures and complex SQL queries.
• Recoded and maintained custom PL/SQL Packages and Stored procedures for the application redesign of DOJ’s GPRS online fund request system and the financial management information system.

Confidential, New York, NY

Data Analyst

• Worked in a production environment to create several ad hoc report requests for statistical information about CB’s 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 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 PL/SQL Stored Procedures for client reporting applications in a production environment.
• 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; only the properties meeting price threshold are classified as a luxury property display within an office for Coldwell banker’s luxury property application.

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.
• Worked with QA Team lead to create documentation on how to use Selenium IDE.

Confidential, Great Neck, NY

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.