SUMMARY:

• Expertise - Systems Analyst and Data Architect who has translated complex business needs and data into actionable solutions for the following industries (manufacturing, insurance, healthcare, retail, supply chain, high tech, financial, mortgage).
• 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.
• Liaison between business unit and software development teams.
• 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 Scrum andAgile 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, reporting)
• 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
• 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

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, Oracle Hyperion, DB2, Teradata, SQL Server

Data Modeling Tools: ERwin, Visio, ER/Studio

Ancillary Skills: Tivoli Job Scheduler, Control M, Remedy, ClearQuest, ClearCase, Sharepoint, Requisite Pro, Quality Center

Operating Systems: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

Business Analyst / BI Developer

Responsible for:

• Defined, analyzed and created business requirements for CIO working alongside data architect, modelers and developers on a initiative designed to transform data by analyzing data fast and easy, with beautiful and useful visual report using Tableau software.
• The primary goal was to make business data actionable through visual, interactive and high performance reports.
• Facilitated development of solution thru formal technical reviews and requirements lockdown.
• Day to day task include design of workbooks and dashboard that summarize day to day, monthly, yearly and forecasted product movement. designed KPI reports for the following subject areas which included inventory, production, chargeouts, net orders and DTU's (delivered to users).

Environment: Hydoop, SQL Server and Microsoft Analytic Services cubes.

Confidential, Chicago, IL

Systems Business Analyst

Responsible for:

• Document reference architectures, best practices, standards, use cases and processes for Member/Subscriber and Practitioner data.
• Collaborate with various teams, including Product Development, in delivering the solutions, roadmap and vision.
• As a SQL BI developer assisted in the implementation complex queries used in data profiling for data needing to be migrated to Teradata platform from SQL server.
• Liaison for strategic initiatives for managed and support services organization.
• Responsible for the traceability Matrix and ensure that the acceptance test strategy and plan are aligned with the requirements
• Conducted daily scrums in order to help the team to reach consensus for what can be achieved during a specific period of time (sprints).
• Help to remove obstacles that would impede the team's progress.

Environment: SQL Management Studio, PLSQL, Teradata, SQL Assistant, Tableau

Confidential Chicago, IL

Systems Business 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, dashboards as well as reports using Tableau and interfaces with other systems
• Performed data analysis on data using Tableau
• 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)
• Performed data modeling task
• Communicated requirements
• Created and manage test plans, scripts, and test data

Environment: Sql Server, Tableau, RFID, Visio

Confidential, Chicago, IL

Data Architect / Systems Analyst

• Defined Data Architecture, Data Strategy and Roadmap for large Healthcare (Payer, Provider, Pharmacy) organizations and complex systems
• Worked as project manager with multiple teams within TIS to design project scope for various project segments
• Worked with business team to analyze, probe and gather requirements
• Created sql queries in DB2 in order to provide analysis on data
• Developed and executed test plans; analyzed data and test results in DB2
• 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
• Conducted daily scrums in order to help the team to reach consensus for what can be achieved during a specific period of time (sprints).
• Help to remove obstacles that would impede the team's progress.
• 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

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

Confidential Chicago, IL

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
• Conducted daily scrums in order to help the team to reach consensus for what can be achieved during a specific period of time (sprints).
• Help to remove obstacles that would impede the team's progress.
• 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
• Created sql queries in DB2 in order to provide analysis on data
• Developed and executed test plans; analyzed data and test results in DB2
• 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

Confidential, Chicago, IL

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
• Identified, proposed, initiated and lead 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 using Tableau
• 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

Confidential, Chicago, IL

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

Confidential, Washington D.C

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

Confidential, Washington D.C

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

Confidential, New York

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

Confidential, VA

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

Confidential Chicago, IL

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

Confidential, IL

Developer

• Oversaw design of a system that drove Crate and Barrel’s marketing camp Confidential n. 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

Confidential, Cincinnati, OH

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

Confidential, Deerfield, IL

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