SUMMARY

• Expertise - Systems Analyst and Data Architect who TEMPhas 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 wif 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 wif 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 wif 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

Responsibilities:

• 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, wif beautiful and useful visual report using Tableau software.
• Confidential is amanufacturerand marketer of medium and heavy truck, buses and mid-range diesel engines having plants in the following locations: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 dat 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

Responsibilities:

• Document reference architectures, best practices, standards, use cases and processes for Member/Subscriber and Practitioner data.
• Collaborate wif 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 dat the acceptance test strategy and plan are aligned wif the requirements
• Conducted daily scrums in order to halp the team to reach consensus for wat can be achieved during a specific period of time (sprints).
• Help to remove obstacles dat would impede the team's progress.

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

Confidential - Chicago, IL

Systems Business Analyst

Responsibilities:

• 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 wif 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 wif 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 between the developers and the Golf Delta
• Created and manage test plans, scripts, and test data

Environment: Sql Server, Tableau, RFID, Visio

Confidential - Chicago, IL

Data Architect / Systems Analyst

Responsibilities:

• Defined Data Architecture, Data Strategy and Roadmap for large Healthcare (Payer, Provider, Pharmacy) organizations and complex systems
• Worked as project manager wif multiple teams wifin TIS to design project scope for various project segments
• Worked wif 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 halp the team to reach consensus for wat can be achieved during a specific period of time (sprints).
• Help to remove obstacles dat would impede the team's progress.
• Provides advice, system design solutions in any area associated wif the planning, delivery, management and effective business use of data delivery and BI environments
• Worked wif 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

Responsibilities:

• Worked wif multiple teams to design project scope for various project segments
• Worked wif 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 halp the team to reach consensus for wat can be achieved during a specific period of time (sprints).
• Help to remove obstacles dat would impede the team's progress.
• Provides advice, assistance and leadership in any area associated wif 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 wif 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 wif 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

Responsibilities:

• Provides advice, assistance and leadership in any area associated wif 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 wif end client to understand their project requirements and coordinate wif our offshore and in-house development teams to customize a reporting system dat delivers meaningful data reports using Tableau
• Created a patent pending real-time online business intelligence tool dat 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

Responsibilities:

• 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 wif SQL, Erwin data modeling tools
• Deep understanding of relational databases and query tools (e.g., Oracle PL SQL, Toad)
• Gatheird project requirements from the business teams and worked wif 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

Responsibilities:

• 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; TEMPhas broad, over-arching understanding of impact to IT.
• Assist the Director of Analytics wif designing and developing new studies and reports.
• Worked wif 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 wif various teams to manage and schedule project deliverables.
• Conducted code reviews wif 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

Responsibilities:

• Worked wif business teams to understand project requirements.
• Created high level and detail design documents.
• Worked wif 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 wif 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

Responsibilities:

• Worked closely wif 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 wif end users on select projects to define, design and implement new Cognos reporting solutions or subject areas.
• Worked closely wif 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 – Herndon, VA

Architect/Designer/Lead Developer

Responsibilities:

• Responsible for design of Guarantee Fee Accounting System. dis 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

Responsibilities:

• Developed use cases for Confidential “True Credit” reports.
• Benchmarked business case using DataStage, Informatica, and ab Initio
• Oversaw developing ab Initio graphs and reports dat 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 dat 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 – Northbrook, IL

Ab Initio Developer

Responsibilities:

• Oversaw design of a system dat drove Confidential and Barrel’s marketing campaign. The system was designed for postcard and catalog marketing.
• Created extracts for data modeler so dat predictive scoring could be performed against the data.
• Oversaw design of Audit/QA/QC system to support the CBCM data warehouse.
• Performed peer reviews wif team before migrating code to test environments

Environment: ab Initio, Oracle, SQL, ER Studio