SKILLS

• Specializing in the functional testing of back-end systems that process data, validating ETL processes that load data into a RDBMS data warehouse, and analysis of data intensive applications.
• Databases: Oracle 7 11g Netezza Microsoft SQL Server, PostgreSQL, and MySQL.
• Programming Languages: Python 2.7 PL/SQL SQL VB.NET ASP.NET Javascript.
• OS: Linux Redhat, CentOS, Ubuntu, ArchLinux, Cygwin on Windows Windows 7 Mac OS X
• Project, Source Control and Management Tools: Git, Github and Gitlab Mercurial and TortoiseHg Rally Perforce P4V JIRA including GreenHopper Confluence Fisheye Microsoft Project Microsoft Team Foundation Server TFS Subversion and Tortoise

EXPERIENCE SUMMARY

Senior Data Quality Analyst

Confidential

• Team lead position on the Business Intelligence team at Beachbody, responsible for testing data loads into an Oracle data warehouse as well as report objects in OBIEE.
• Wrote Python, SQL, and PL/SQL code to test file or database-sourced loads into Oracle. Files were either in XML or delimited format. Database sources were various Oracle applications such as EBS or ATG, as well as MySQL databases.

Highlights include:

• Verified the data conversion of 6 million users from a MySQL database to a staging database in Oracle, to test the future migration of users from a legacy system to a new system. Wrote and executed code to verify the processing of XML call response records from call centers and relate those response records to media buys. Wrote and executed code to test the Informatica loading of FedEx tracking and invoice files into the data warehouse.
• Hired and on-boarded a small, off-shore team to test ETL and OBIEE report changes. Responsible for day-to-day management of the off-shore team.
• Currently hiring additional team members to work alongside Informatica and OBIEE developers.
• Worked with the data warehouse development team to improve the scrums and overall delivery/development process.
• Skills and Tools: Python 2.7 including IPython with pandas SQL both in Oracle and MySQL PL/SQL Markdown Git and Gitlab.

Business Systems Analyst

Confidential

• The RAND Corporation is a unique non-profit entity providing objective research and analysis to a broad range of
• clients and grantors, including the U.S. Government, State and Local governments, as well as Colleges and Universities.
• Systems Analyst/Developer position to build and maintain ASP sites utilizing Oracle Imaging and Process Management formerly Stellent BPM , as well as operationally support the Oracle I/PM system.

Highlights include:

• Designed, developed, tested and implemented two new web applications for research support staff to review and approve grant requests and proposals. Maintained other sites like the internal bug/item tracking system, and a workflow application for Purchasing. Increased the performance of the item tracking system and other web sites. Wrote Python scripts to parse logs from scanning stations.
• Created an initial RFP and reached out to Document Management vendors in order to learn about other systems, as well as look to replace Oracle I/PM.
• Operational support of Oracle I/PM from client machine installs, support of the web interfaces, to supporting the scanning station set up used by HR.
• Sat on an IS project committee for a short period of time. Helped the Library in searching and hiring someone to either replace or maintain their Access database of acquisitions. Pushed to work with IS more and share more platforms, such as the use of Gitlab and looked into TFS and Remedy.
• Introduced concepts of source control and release management that were not being used in Enterprise Applications. Gave high-level presentations to colleagues on concepts such as data distribution and big data.
• Skills and Tools: VB.NET ASP.NET Oracle PL/SQL SQL Python Process Modeling using lucidchart.com Mercurial and TortoiseHg I ran my own repository Git and Gitlab

QA Manager - BI

Confidential

• Demand Media produces articles and videos both for outside publishers and its own network of websites including eHow.com and LIVESTRONG.COM. The company also provides social media solutions for its branded partners. At the time, it owned the world's second largest domain name registrar group.
• Created data and regression test strategies to test daily loads into the data warehouse on Netezza. Source data included Omniture exports, SQL Server database queries and stored procedure calls, and file feeds from revenue partners.
• Developed a regression test system in Python to verify data warehouse loads. Used SQL to find problems with stored procedures on source SQL Server systems.
• Also responsible for the daily operation of the entire data warehouse chain, including identifying and troubleshooting issues with pulls from source systems and the daily data warehouse load. Managed the operations issue list and made sure issues were assigned to appropriate developers or analysts.
• Skills and Tools: SQL Linux shell commands to analyze large files Python Aginity Quest Toad for Data Analysts, SSRS and SSAS, analyzing T-SQL procedures SoapUI JIRA and GreenHopper TFS Some MongoDB and experimented with pymongo.

Manager Data Quality

Confidential

• Confidential is the creator and provider of Edmunds.com and integrated website brands such as Edmunds
• Inside Line, CarSpace, and AutoObserver.com, which serve to educate automotive consumers.
• Managed a team responsible for QA of data warehouse ETL processes and data validation of MicroStrategy reports. Wrote PL/SQL procedures and minus queries to validate file loads and transfer of data from staging tables to fact tables includes verifying dimension key accuracy . Worked with development, business analysts and project management to improve team performance and productivity. Mentored other team members when necessary to assist with logistical testing questions, and helped analysts with SQL and PL/SQL questions.
• Worked on a project to migrate the data warehouse from Oracle into Netezza. Worked with developers on a POC of Hadoop Map/Reduce using Hadoop streaming, and worked with BI developers to implement Hive ODBC and Netezza ODBC drivers to analyze how Microstrategy performs.
• Improvements: Streamlined a data cleansing process in Edmunds model data in the data warehouse to be more automated, take less time and improve accuracy by 35 . Highlighted data modeling problems with Edmunds model data. Created repeatable scripts to improve regression testing time and efficiency for ETL loads, and implemented Quest Code Tester for Oracle as a testing framework. Assisted team with the creation of a database package to gather and store high-level metrics on a daily basis for operational monitoring of the data warehouse.
• Skills and Tools: PL/SQL SQL Linux shell commands to analyze large files Python Quest database tools TOAD, SQL Navigator and Code Tester for Oracle running workflows in Informatica MicroStrategy web interface Rally for Agile project management and logging test cases Perforce P4V as a code repository .

IT Manager, J2 GLOBAL

Confidential

• j2 Global provides messaging and communications services to millions of customers around the world. The company's core brands include eFax, eVoice and Onebox. j2 provides localized services to more than 2,000 cities in 26 countries.
• Responsible for subscription billing, usage rating, and credit card processing systems as Manager of Billing Systems. Also responsible for support systems used by Customer Service, Marketing, Accounting and Finance including EDI interfaces to Oracle On Demand . Compliance responsibilities included working with external auditors during Sarbanes-Oxley audits to demonstrate data and process controls, PCI/DSS audits to ensure protection of cardholder data, and internal audits of revenue recognition.
• Team members included J2EE and VB developers, PL/SQL developers, and Systems Analysts. Developed the initial and daily ETL loads in PL/SQL while implementing j2's first data warehouse. Supported the data warehouse by making and testing program changes when needed. Coded PL/SQL package and trigger changes to support usage rating and the billing database.
• Technologies used by the team include: J2EE Sun GlassFish Application Server, Stripes framework, TopLink , Oracle 10g v10.2 and 9i databases, Linux CentOS and Redhat , Solaris and Windows operating systems.
• Skills and Tools: PL/SQL SQL Subversion Tortoise Confluence JIRA Fisheye.

OTHER EXPERIENCE LISTING

SENIOR QA DATA ANALYST

Confidential

• MedImpact is a Pharmacy Benefits Management PBM company that services 27 million members nationwide.
• Their clients include Fortune 500 corporations, unions, managed care organizations and insurance carriers.
• This position was a SQA position responsible for verifying requirements at the very beginning of the SDLC. Worked with business analysts, project managers and developers at the beginning to address any requirements issues. This included working with the data architects to identify changes that would be needed to the data
• model. Then assigned test plan, test execution script and test report creation to junior members of the QA team.

MEDIATION TEAM MANAGER

Confidential

• Wingcast was a joint venture of Qualcomm and the Ford Motor Company to provide telematics devices and services to the auto, auto rental and transport industries. Wingcast dissolved in 2002.
• This position was responsible for implementing the mediation system. The mediation system would receive call detail records from a wireless carrier, then parse and converge it with data received from internal service platforms. The output of the mediation system is a single format sent to billing and rating systems, financial systems, the data warehouse, etc.

DEVELOPMENT PROJECT MANAGER/QA

Confidential

• AIS Consulting provided and maintained provisioning and rating systems for telecommunications companies,
• with the largest client being Williams Communications of Williams Energy . AIS dissolved in 2002.