We provide IT Staff Augmentation Services!

Lead Data Warehouse Analyst Resume

2.00/5 (Submit Your Rating)

EXPERIENCE:

Confidential

Lead Data Warehouse Analyst

Responsibilities:

  • Liaison between Business areas and the Enterprise Data Services Organization, identifying business rules, data quality standards, data integration strategy for extraction, transformation and loading (ETL) of data, identifying system of records for requested data, gathering and documenting data, business and technical requirements.
  • Work with Information/Enterprise Architects in creating the original Confidential Canonical Data Model (CDM) which required extensive Business knowledge and interaction with Subject Matter Experts
  • Consult and interact with Single Family Data management and Governance to adhere to the Confidential Data Management standards and policies
  • Assist in defining, monitoring, and improving the Family data governance and data quality process and standards
  • Agile value team member for Affordable Housing and Duty to Serve Reporting platform initiative. Wrote user stories utilizing Gherkin
  • Analyst on the implementation of the Big data Hadoop Eco system to shred raw XML Loan Prospector ( Confidential underwriting system) data.
  • Document Interface agreements with source systems that utilize VSAM, IMS, DB2, XML, Sybase, Oracle, flat files and csv files.
  • Identify Data Producers, Data Consumers and data dependencies between upstream and downstream consumers
  • Consult and interact with Change Control Boards, Information Architects, Subject Matter Experts, Business Experts, Application Architects, Enterprise Architects to ensure project objectives and corporate initiatives are implemented and followed.
  • Source to target mapping, business rule transformation, maintaining metadata repository, assist data analysts with Logical and Physical data modeling, review and validate Relational and Fact/Dimensional (star - schema, Snowflake, slowly changing type 1 and type 2) Data models.
  • Gap analysis, impact analysis, data profiling, data analysis, identifying data sources, identifying and resolving data quality issues.
  • Create System Development Methodology documents and ensured data warehouse standards and best practices are followed.
  • Worked with the Business Intelligence (BI) application team aiding in their development of BI applications
  • Create complex SQL to answer business questions and summarize/explain data differences, create and assist in the development of Technical Data Quality ( Confidential ) reports involving source and target data.

Confidential

Senior Business Analyst

Responsibilities:

  • Develop metrics and reporting to assess performance and impact to client and customers' business, and evaluate planned versus actual results.
  • Create queries and run reports in support of Account Management and their client reporting needs for debit, credit, and commercial products.
  • Provide analysis of client and customers business and operating practices.
  • Develop business case scenarios and models that quantify financial opportunity and evaluate the business, technical and systems feasibility of their implementation through financial analysis and internal and customer research utilizing Micro strategy.
  • Gather detailed requirements and reverse engineer an existing application utilizing Microsoft Access to a Micro strategy environment.
  • Evaluate Complex issues, determine key drivers and identify performance/process improvements.

Confidential

Business Analyst/Data Warehouse Analyst

Responsibilities:

  • Liaison between Business areas and the Data Warehouse development team, identifying business rules for extraction, transformation and loading (ETL) of data, gathering and documenting data and business requirements.
  • Source to target mapping, maintaining metadata repository (data dictionary), assisted data analysts with data modeling and design of physical database, reviewed and validated Relational and Dimensional Data models.
  • Gap analysis, impact analysis, data profiling, data analysis, identifying data sources, identifying and resolving data quality issues.
  • Created System Development Methodology documents and ensured data warehouse standards were followed.
  • Responsible for integration testing, regression testing, and system testing and assist in user-acceptance testing.
  • Tracked and resolved problems/issues that required interacting with various Business Area Subject Matter Experts (SME's) other Business Analysts and support personnel. Would look beyond the obvious and don' Confidential stop at the first answers, probe all sources for answers, pay attention to details and look at the big picture.
  • Created complex SQL, used SQL to answer business questions and summarize/explain data differences, created and assisted in the development of Technical Data Quality ( Confidential ) reports involving source and target data.

Confidential

Business Analyst/ Technical Lead

Responsibilities:

  • Responsible for coding, testing, providing technical support, and assisting in user-acceptance testing. data assessments, data profiling, data analysis, identified data sources, identified and resolved data quality issues.
  • Identified business rules, gathered and documented data and business requirements.
  • Assisted data architects with data mapping and reviewed/revised Entity Relationship diagrams (ERD).
  • Created System Development Methodology documents as needed.
  • Generated and validated ad-hoc reports from business requests.
  • Tracked and resolved problems/issues that required interacting with Business Units, other Business Analysts and support personnel.
  • Worked on a variety of applications including Web Banking, Customer Information System (CIS), Deposits (IMPACS), Savings/Time, Retail and Commercial Loans, ATM and Credit Cards.

Environment: Teradata /Unix

Confidential

Programmer Analyst/ Project Lead

Responsibilities:

  • Responsibilities were the monetary interfaces and monetary downstream processes.
  • Coded, tested, analyzed requirements and interfaced with clients including ACH, IMPACS, TPA (loans), G/L, ATM, VRU and other financial and marketing groups

Environment: COBOL/COBOL II, CICS, VSAM, MQ-SERIES, XML, Connect Direct, SAS, File-Aid, CHANGEMAN, XPEDITER, ZEKE, WORD, EXCEL and EASYTRIEVE PLUS in an OS/390 - Z/OS

Confidential

Senior Programmer/Analyst

Responsibilities:

  • Responsibilities included analyzing client change request requirements, recommending solutions, coding, and system testing.
  • Implementation of solutions, performance tuning of DB2 programs, loading and unloading DB2 tables, importing/exporting DB2 data.
  • Troubleshot and did problem tracking that required interfacing with clients and other support personnel.

Environment: DB2, CICS, VSAM, COBOL II, CHANGEMAN, XPEDITER, EXCEL, WORD on an IBM 3090 with Windows NT.

Confidential

Programmer Analyst

Responsibilities:

  • Responsible for reviewing and approving software development and technical documentation.
  • Provided technical support, writing, reviewing and executing computer validation test cases and protocols.

Environment: COBOL, DB2, CICS, Oracle, and Windows NT.

Confidential

Systems Analyst

Responsibilities:

  • Gathered requirements, developed and documented current and proposed process flows, developed and documented current and proposed Entity Relationship diagrams (ERD) and Create, Read, Update diagrams (CRUD).
  • Participated in joint application development (JAD) sessions with clients.
  • Created requirements document and various systems development methodology documents.
  • Reversed-engineered physical database using ERWIN.
  • Worked on various maintenance projects.
  • Worked very closely with client to development supplemental financial reports for collection of Citation fees and penalties through DMV Enforcement.
  • Developed enhancements and conducted analysis and problem resolutions from client change requests.

Environment: COBOL, DB2, CICS, XPEDITER, ENDEVOR, EASYTRIEVE PLUS, IBM Mainframe environment utilizing Windows 95/98. Received training in BPWin, ERWin and Client/Server Methodologies.

Confidential

Consultant

Responsibilities:

  • Responsible for gathering and analyzing requirements, map data from current VSAM files to DB2 tables, develop and analyze programs to map data from source to target elements, recommending solutions, trouble shooting, performance tuning/monitoring of all DB2 batch programs, loading/unloading DB2 tables, coding and integration testing.
  • Developed the entire batch system for the Crew Management system, ran and supported the batch system during the 6-month integration testing.
  • Supported the batch system for the first month in production. Primary support for the other developers and on-call personnel, investigated and determined the root cause of all production abends and worked with other developers and internal clients to implement solutions.

Environment: MICROFOCUS COBOL and CICS, XDB on an OS2 LAN based client server and DB2, CICS, COBOL, ENDEVOR, XPEDITER on an IBM 3090 on multiple LPARS.

Confidential

Senior Programmer/Analyst

Responsibilities:

  • Responsibilities included developing project schedules, coding, system and integration testing.

Environment: POWERBUILDER and SYBASE on a UNIX box and COBOL, DB2 on an IBM 3090.

Confidential

Senior Programmer/Analyst

Responsibilities:

  • Responsibilities included gathering and analyzing requirements, recommending solutions, coding, system testing, implementation of solutions, trouble shooting and problem tracking which required interfacing with clients and other support personnel.

Environment: DB2, CICS, TELON, COBOL on an IBM 3090 using 3270 emulation on an Ethernet LAN running Banyan.

Confidential

Programmer/Analyst

Responsibilities:

  • Responsibilities included designing the project procedure guide, project standards, analyzing requirements, writing program specifications, writing and testing on-line and batch programs.
  • Analyzed and documented the marketing computer systems. This included documenting interface files to each system, defining the data and documenting the processes of systems.
  • Wrote programs to extract data from the IEF public interface tables to produce reports.
  • Analyzed concerns and recommended solutions on how to replace the existing tool used to do the Current Systems Analysis.
  • Developed and tested on-line and batch programs in a DB2, Telon, COBOL environment.
  • Developed and modified program specifications and test plans.

Environment: DB2, TELON, EDI, COBOL II, XDB, PC TELON and Micro Focus Cobol.

Confidential

Programmer/Analyst

Responsibilities:

  • Developed and tested on-line and batch programs.
  • Analyzed new requirements and developed program specifications.

Environment: CICS, VSAM, COBOL II.

Confidential

Programmer/Analyst

Responsibilities:

  • Developed and modified program specifications and test plans for on-line programs.
  • Developed and tested on-line and batch programs.
  • Batch testing was done utilizing XPF. On-line programs were tested in the Telon Test Facility.

Environment: TELON, COBOL, COBOL II and DB2.

We'd love your feedback!