Ketrus D. Collins

acq0nl@r.postjobfree.com

513-***-****

Summary

Expertise - Data Analyst and Data Architect who has translated complex business needs and data into actionable learning-based solutions.

Responsibilities have also included gathering and assessing business information needs and preparing functional requirements, system use case, detail design artifacts and data requirements necessary for ETL, BI reporting solutions.

Provide leadership in implementing Data Management solutions such as DW, ODS, Data Marts, Data Quality, MDM, Metadata Management, Big Data, Advanced Analytics, etc.

3+ years experience building dashboards and reports using Tableau

Proven ability to independently champion business intelligence and data visualization principles with business owners, application owners, data analysts

Strong SQL skills and understanding of relational databases

Comprehensive understanding of the Agile Development process

Participated in intensive data analysis from documentation of transformation rules, investigation and technical profiling (queries). Roles also involve interfacing between various business and technical teams to compile requirements and design solutions

Experience with technical analysis in specific technology areas such as platforms (such as ETL, and data warehouse, data marts, and vaults)

Performed data profiling, aggregation and data analysis in support of data quality rules generation, data lineage documentation, and general understanding of data relationships between systems

Act as liaison between business unit and software development teams.

Experience with all aspects of the system implementation including, but not limited to, gathering requirements, designing the future state solution, the development objects related to their process scope, as well as supporting QA testing and post implementation activities

Possess a detailed understanding of traditional waterfall and agile software development methodologies

Education & Certification

B. S. Computer Science - DePaul University, Chicago, IL

ab Initio Training Certification – ab Initio Headquarters, Lexington, MA

RFID Certification

Technical Skills

Primary Skills: System Design and development, Data Architect, Project Management

Languages/Tools: ab Initio, Informatica, DataStage, SQL

Reporting: Cognos, Business Objects, QlikView, Tableau

Databases: Oracle, DB2, Teradata, SQL Server

Data Modeling Tools: ERwin, Visio, ER/Studio

Ancillary Skills: MS Project, Tivoli Job Scheduler, Control M, Remedy, ClearQuest, ClearCase, Share point, Requisite Pro, Quality Center

Operating Systems: Unix, Linux, Windows

Project Experience

I-ON Analytics – Chicago, IL March 2013 – Present

Project sponsored by Golf Delta

Data Analyst

Responsible for:

Creation of dashboards and perform data visualization on golf data collected by way of RFID technology

Responsible for high level/detailed design and implementation

Also responsible for review and requirement gathering sessions with business partners

Analyze the customer’s business needs

Analyzing solution requirements (requires use of different methods - prototyping, questionnaires, surveys, brainstorming, analysis of existing documentation and competitors)

Designed the layout of the user interface as well as reports and interfaces with other systems

Formalized requirements (including requirements on business and functional and non-functional requirement specification writing)

Managed requirements (processing change requests, analysis and description of the impact on existing requirements)

Communicated requirements between the developers and the Golf Delta

Created and manage test plans, scripts, and test data;

Blue Cross Blue Shield Illinois (BCBSIL) – Chicago, IL March 2014 – April 2015

Data Architect / Systems Analyst

Must have defined Data Architecture, Data Strategy and Roadmap for large Healthcare (Payer, Provider, Pharmacy) organizations and complex systems

Worked with multiple teams within TIS to design project scope for various project segments

Worked with business team to analyze, probe and gather requirements

Developed and executed test plans; analyzed data and test results

Utilized Sparks Enterprise Architecture and other data ware house technologies

Conducted advanced-level design JAD sessions in order to gain understanding of how data is processed and maintained throughout the enterprise

Provides advice, system design solutions in any area associated with the planning, delivery, management and effective business use of data delivery and BI environments

Worked with DBA’s, business analyst, system analyst, ETL development teams

Solid prioritization and project management skills including schedule development and assessment

Blue Cross Blue Shield Association (BCBSA) – Chicago, IL February 2013 – February 2014

Technical Data / Systems Analyst

Worked with multiple teams to design project scope for various project segments

Worked with business team to analyze, probe and gather requirements

Identifies, proposes, initiates and leads significant improvement programs establishing requirements for the implementation of significant changes in business functions and processes, organizational roles and responsibilities and scope or nature of IT service delivery

Created User Requirement (URS) Functional Requirements (FRS), System Use Case (SUC) and High level design documents

Utilized Sparks Enterprise Architecture and other data ware house technologies

Participated in advanced-level design JAD sessions

Provides advice, assistance and leadership in any area associated with the planning, delivery, management, maintenance and effective business use of information systems

Conducted daily SCRUM meetings

Supported the maintenance of the system request and worked with development teams to resolve

Provided support to the business team on User Acceptance testing

Worked with development teams leveraging both IT solutions and business process improvements

Solid prioritization and project management skills including schedule development and assessment

Responsible for re-prioritizing daily tasks, triage defects, and tracking issues

Environment: Sparks Enterprise Architecture, Datastage, DB2, Autosys, Oracle, Toad, Cognos, Requisite Pro, Clear Case, Sharepoint

Lygase – Chicago, IL November 2008 – February 2013

Data Architect/Analyst

Provides advice, assistance and leadership in any area associated with the planning, procurement, provision, delivery, management, maintenance and effective business use of information systems

Translates business requirements into functional requirements; performs data and process modeling; manages change; and leads, coordinates / performs testing, verification, and validation of requirements

Identifies, proposes, initiates and leads significant improvement programs establishing requirements for the implementation of significant changes in business functions and processes, organizational roles and responsibilities and scope or nature of IT service delivery Designed and developed complex SQL queries for reporting

Coordinated and led a 15 person team of managers and consultants responsible for business development, operations, marketing, sales, software development, and engineering.

Conducted comparative analysis between ClikView and Tableau visualization tools

Responsible for re-prioritizing daily tasks, triage defects, and tracking issues

Work with end client to understand their project requirements and coordinate with our offshore and in-house development teams to customize a reporting system that delivers meaningful data reports.

Created a patent pending real-time online business intelligence tool that monitored movement

Responsible for re-prioritizing daily tasks, triage defects, and tracking issues

Utilized Informatica, SSIS and other data ware house technologies

Managed medium to large BI projects/programs

Environment: Informatica, SSIS, Flex, Java, SQL Server, Online reporting tools, Tableau, Oracle, Teradata

U.S. Cellular – Chicago, IL April 2008 – August 2008

Systems Analyst/Architect

Design and develop the data warehouse/data mart applications utilizing the Cognos tools

Document data standards, requirement specifications, and business processes

Be responsible for establishing best practices for several developers working in the same environment on different projects.

Strong working experience in ETL tools in Informatica, AbInitio Experience with SQL, Erwin data modeling tools

Deep understanding of relational databases and query tools (e.g., Oracle PL SQL, Toad)

Gathered project requirements from the business teams and worked with an integration team for development of the Revenue Automation Process.

Designed the Revenue Automation Process using Informatica 8 using Web Services API.

Maintained project plans and managed the design and development efforts throughout the entire SDLC

Environment: Informatica, PL/SQL, Oracle, Clear Case, Clear Quest

Fannie Mae – Washington D.C April 2007 – January 2008

Designer/Lead Developer

Deep understanding of relational databases and query tools (e.g., Oracle PL SQL, Toad).

Responsible for larger initiatives such as transitioning to new reporting technologies.

Solid understanding of the impact to all Business Objects Reporting application areas of systems/sub-systems modifications and enhancements; understands impact to business; has broad, over-arching understanding of impact to IT.

Assist the Director of Analytics with designing and developing new studies and reports.

Worked with business teams to understand project requirements and documented all processes in ClearCase and ClearQuest.

Responsible for re-prioritizing daily tasks, triage defects, and tracking issues

Worked with various teams to manage and schedule project deliverables.

Conducted code reviews with developers prior to migration for system test and acceptance environments.

Maintained project plan and lead a team of 15 developers and QA testers.

Environment: ab Initio, ER/Studio Repository, PL/SQL, Oracle 10g, SQL, Share point

Fannie Mae – Washington D.C May 2006 – March 2007

Data Architect

Worked with business teams to understand project requirements.

Created high level and detail design documents.

Worked with various development teams for project setup and created new common projects.

Led a team of 10 developers.

Created PL/SQL packages and developed ab Initio graphs.

Worked with developers on application code to ensure final deliverables.

Conducted peer reviews and regular status meetings to ensure development teams were meeting the business requirements

Environment: ab Initio, Oracle 10g, PL/SQL, SQL

Citigroup – New York March 2006 – May 2006

Data Architect

Worked closely with development team members to design and deliver new Enterprise data warehouse capabilities for existing customers.

Scheduled batch jobs using Autosys, and monitored jobs and data flow through EME to observe timings and bottlenecks in job flow for performance optimization.

Collaborated directly with end users on select projects to define, design and implement new Cognos reporting solutions or subject areas.

Worked closely with other BI team members on recommending improvements related to all aspects of our data warehouse architecture and data design.

Environment: ab Initio, DWL, Oracle, Cognos, Sharepoint

Fannie Mae – Herndon, VA September 2005 – March 2006

Architect/Designer/Lead Developer

Responsible for design of Guarantee Fee Accounting System. This project was needed to restate accounting facts for securities and loans for years 2001 through current. Data volumes ranged from 15 to 22 terabytes.

Oversaw design and development efforts of 25 ab Initio developers.

Responsible for delegating and scheduling tasks in the project plan.

Conducted design reviews, peer reviews and defined ab Initio standards for the project.

Performed unit test, system test and performance tuning on all modules.

Documented the entire process.

Environment: ab Initio, Oracle 10g, PL/SQL, SQL

TransUnion – Chicago, IL July 2005 – September 2005

Senior Data Analyst

Developed use cases for TransUnion “True Credit” reports.

Benchmarked business case using DataStage, Informatica, and ab Initio

Oversaw developing ab Initio graphs and reports that managed data pertaining to credit strategies, models and analytics, and credit bureau data and analysis.

Assisted in data analysis utilizing data disparate source systems data to support teams.

Made recommendations to management regarding new development.

Developed effective strategies for performance testing that ensured business processes were performing as expected.

Oversaw the creation of weekly status reports and team status

Environment: DataStage, Informatica, ab Initio, DWL, Oracle, SQL

Crate & Barrel – Northbrook, IL January 2005 – July 2005

Ab Initio Developer

Oversaw design of a system that drove Crate and Barrel’s marketing campaign. The system was designed for postcard and catalog marketing.

Created extracts for data modeler so that predictive scoring could be performed against the data.

Oversaw design of Audit/QA/QC system to support the CBCM data warehouse.

Performed peer reviews with team before migrating code to test environments

Environment: ab Initio, Oracle, SQL, ER Studio

The Kroger Company – Cincinnati, OH November 2003 – December 2004

Senior Business Analyst

Managed data warehouse Risk Management project throughout its entire lifecycle from gathering requirements, design and implementation. Risk Management was designed to process Kroger’s claim data, both Workers Comp and General Liability on a daily basis. This involved tracking payments, change in reserves, open and close status, and other updates on a claim.

Performed duties ranging from gathering business requirements to design, implementation and QA.

Worked closely with data modelers to design fact and dimension tables and designed ab Initio graphs and scripts.

Environment: ab Initio, DB2, SQL, ER Studio

The Walgreen Company – Deerfield, IL November 1999 – October 2003

Senior Programmer Analyst

Managed data warehouse team projects. Duties ranged from gathering requirements to design and implementation.

Worked with development server architecture. Trained and led a team in various ab Initio related projects.

Trained personnel in advanced ab Initio concepts.

Managed projects throughout entire life cycle.

Created Oracle script enhancements.

Implemented scripts that allowed developers to truncate create/drop indexes, grant/revoke privileges and swap tables.

Environment: ab Initio, DB2, SQL, ER Studio, Perl, Kornshell

Contact this candidate