We provide IT Staff Augmentation Services!

Senior Data Warehouse Analyst Resume Profile

5.00/5 (Submit Your Rating)

KEY SKILLS

  • Technical Business Analyst
  • Banking / Financial
  • Credit Card
  • COBOL, SAS, CICS
  • Trouble Shooting
  • Diagnosis
  • Technical Writing Documentation

Confidential

  • Gathered requirements of the current global security group, created documents for an Global Information Portal so upper management could get a better understanding of the complexity and volume of data needed for access, permissions, entitlements for individuals, groups and platforms,,,
  • Suggest performance solutions, for SDLC Software Development Life Cycle process Six Sigma, Agile ,and Waterfall application enhancement, system, code,,,,
  • Code programs in JCL, COBOL, SAS, CICS and CLIST/REXX, RPG, C , code review, test then implement into production
  • Assist and train others with any code issue, understanding or implementation
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide
  • Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB
  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures Six Sigma, AGILE, Waterfall.
  • Leads delivery teams to deliver quality working tested software each iteration.
  • Facilitates agile ceremonies including Release Planning, Iteration Planning, Demonstrations and Retrospectives.
  • Assign resources according to the resources skills and the project at hand.

Project Manager

  • Projects were established, generated timelines and budgets per phase of the Six Sigma, Agile, Waterfall SDLC.
  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures Six Sigma, AGILE, Waterfall.
  • Ensure the design integrity of the solution such that it meets the agreed functional and non-functional requirements, specifications and code.
  • Suggest performance solutions, for SDLC Software Development Life Cycle process Six Sigma, Agile ,and Waterfall application enhancement, system, code,,,,
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide
  • Write status reports, review and assist in BRD, HLD, LLD and Test for all interested of current and future projects. Used SAS to create analysis for BOA's Data Warehouse, for specific requirements or determination of information for projects
  • Create Schedules, Traceability Matrix, Distribute tasks, coordinate kickoff meetings, assemble and coordinate documentation from SME's Subject Matter Experts on a Share Point drive. Create QC Defects for every suggestion from the SME.
  • Facilitates agile ceremonies
  • Ensures teams risk management occurs
  • Responsible for dependency management
  • Represents team's commitments but does not make them
  • Champions agile values, principles and practices
  • Consistently exhibits servant leadership
  • Leads delivery teams to deliver quality working tested software each iteration.
  • Facilitates agile ceremonies including Release Planning, Iteration Planning, Demonstrations and Retrospectives.
  • Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Sr Business Technical Analyst

  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Kept upper management abreast of the status and percentage of completion for each phase of the task and activities accomplished. Established deliverables, roles and responsibilities procedures, Created Timelines as well as the Traceability Matrix then store upon the Share Point Drive
  • Analyzed production issues as they arise. Then supplied short and long term resolutions. If they were short term, made the corrective resolution. Created performance evaluation and implementation of the feasibility of BRD, HLD and LLD. Ensured the design integrity of the solution such that it met the agreed functional and non-functional requirements.
  • Suggested performance ideas for IMS, PLI, COBOL, DB2, VSAM for a telecommunication billing application.
  • Created status reports for all interested of current and future projects.
  • Data mined, reported and tuned DB2 DB data warehouse, IMS, VSAM a variety of file types were used in moving data from Online to Data-Warehouse source to target , world-wide, transactions.
  • Assisted in the Business Requirement Document for functionality, specifications and requirements. Wrote the High-Level Design HLD /Integrated System Design. Identified the scope for improvement in HLD and suggested possible solutions. The SDLC at AT T was Agile and Waterfall.
  • Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation.
  • Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster ran once a year over a weekend.
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Confidential

  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Kept upper management abreast of the status and percentage of completion for each phase of the task and activities accomplished. Established deliverables, roles and responsibilities procedures
  • Wrote Impact Analysis Functional and Technical Specifications, Project plans and Timelines. Contacted the Vendor when the complexity of the problem was too much for our resources.
  • Scheduled Oncall 24 X 7 as the primary for HR, Benefits, Payroll and Finance DB, Application and Systems
  • Performance Tuned and enhanced the Oracle, DB2 and Sybase DB's, Application and Code,
  • Accessed, Trained and Mentored individuals to meet and exceed milestones
  • Managed Billing, Payroll, Benefits and Finance errors and resolved issues
  • Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory .
  • Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster
  • Wrote policies and procedures for the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects they were modifying PeopleSoft DB and the updating other DB's mirrored DB had the information as well Synchronization

Project Manager

  • Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data
  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Wrote the Business Requirement Documents BRDs and High Level Documents HLDs for the 7 strategic environment Projects to comply to the standard of Agile. Wrote Ad-hoc reports to determine if Specifications were accurately processed and data was not compromised. Status Reports and Traceability Matrixes, Share-Point drive folders created and filled out.
  • Oncall 24 X 7 data refreshes, code and systems for all environments, disaster recovery
  • Scrum Data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in move data from Onlines to Data Warehouse source to target and from Production environments to SIT, QA, Unit and Parallel
  • Performance tuned and enhanced DB2, Oracle DB's as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation.
  • Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Senior Lead Programmer Analyst

  • Gathered and wrote requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures for each of us during the aggressive timeline 350 modules converted in 3 months. Wrote the HLDs for each of the 350 modules.
  • Coded, Unit Tested, Systems Tested and QA Parallel Production tested all modules impacted in production prior to implementation for quality work, 2 weeks early through AT T's IT-using Agile SDLC methodology.
  • Converted all SAS modules to COBOL and taught others to meet the aggressive deadline, which we completed two weeks early.

Senior Team Lead Business Analyst

  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings to comply to the Six Sigma SDLC. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Programmed, tested, evaluated, mentored and taught Analysts of all levels COBOL, DB2 , SQL and Logic through BOA's SDM SDLC methodology and procedures.
  • Gave DB2 performance enhancement and technique suggestions to upper management to establish better performance and throughput with access to old and new tables. Plus 3 new stored procedures
  • Wrote a couple of tools still used today to established that all specifications are in compliance, written and the result of percentage completion report sent to upper management when completed.
  • Created SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .
  • Performance Tuned backups for the Disaster Recovery process, ran to completion in a mock disaster
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Senior Team Lead Business Analyst

  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Wrote BRDs, HLDs and Traceability Matrix for the Agile/Waterfall SDLC. Plus Programmed, tested, evaluated, mentored and taught Analysts of all levels COBOL, DB2 and Logic through Citi's SDLC methodology and procedures.
  • Taught COBOL, SQL, DB2, JCL, Dyl280, Sort, and File-Aide and other utilities. Reviewed the distributed work with management for performance and efficiencies. As well as hands on assistance for all having to correct remedy tickets.
  • SAS Demand planning, Data mining, reporting and tuning of DB2 DB data warehouse, IMS, VSAM a variety of file types were used in move data from Onlines to DataWarehouse source to target and from Production environments to SIT, QA, Unit and Parallel
  • Credit Card processing from Collections to Billing/Statements, modifications, projects, enhancements and corrections.
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide
  • Performance Tuned backups for the Disaster Recovery process, ran to successful completion in an annual mock disaster, the current departments DB rebuilds, applications, batch cycle jobs.
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Senior Lead Business Analyst

Confidential

  • Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data
  • Distributed work to two individuals in order to meet project milestones. Reviewed the distributed work with management for performance and efficiencies. Taught seasoned Consutalnts how to view Teradata, DB2 and Oracle extracts, uploads and scripts to verify all modules for project impact.
  • Performance tune and enhanced COBOL, DB2, Oracle DB's as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.
  • Wrote the impact analysis, BRD, HLD and LLD to comply with their SDLC.
  • Suggested better ways to store and retrieve that data that would save time and gain access quicker.
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide

Senior Lead Business Analyst Consultant

  • Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data
  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Wrote BRDs, HLDs, and LLDs to comply with their Six Sigma SDLC process. Upper management was kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Converted a department and their entire Database from a Mainframe to a UNIX Oracle server. Was responsible for Technical Specifications, designing, coding, testing and the transformation process to implementation in production application development systems.
  • Developed enhancements to Online CICS maps, Batch updates and Purge processes for the Credit Department.
  • Created an automated process to print Store's General Manager signature on thank you letters as well as Customer Response Surveys in this Merchandising environment. Added barcode and POS process to an old department.
  • Performance tuned and enhanced DB2, Oracle DB's, as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.
  • Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory .
  • Performance Tuned backups for the Disaster Recovery process, ran to successful completion in an annual mock disaster, the current departments DB rebuilds, applications, batch cycle jobs.
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Senior Data Warehouse Analyst

  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Wrote LLDs for the impacted artifacts of the Agile projects that I worked on. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Analyzed performance tuned, designed, developed, implemented and maintained BCBS's Enterprise Data Warehouse EDW production processes. From DB2, Oracle DB's as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.
  • Data mining, reporting and tuning of Teredata DB, as well as SAS Demand planning Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide
  • Performance Tuned backups for the Disaster Recovery process, ran to successful completion in an annual mock disaster, the current departments DB rebuilds, applications, batch cycle jobs.
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Senior Data Warehouse Analyst / Data Warehouse Analyst

  • SunGard Enterprise engine experience establishing where issues between SunGard and the Mainframe were. Then either correct or write a project plan. Analyze, Establish and Document where any anomalies are then fix or write a project plan.
  • Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data .
  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Upper management kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Modified/enhanced/developed production programs, data-structures and data of Cash, Custody, Accounting and Securities transactions for JP MORGAN's EDW.
  • Established four country's foreign exchange rates were off three to four digits. The issue had been going on for months, and would have continued if is not put together a daily reporting process. Found a variety issues that were just as important that I documented and resolved.
  • Performance tune and enhance, DB2, Oracle DB's as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.
  • Diagnosed production issues with the WorldWide Trade Transactions Data Warehouse. Once the issue was diagnosed an establish a resolution criteria with a 3 tier server system. Unix, Cisco, and IBM Z-plex systems established.
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide
  • Performance Tuned backups for the Disaster Recovery process, ran to successful completion in an annual mock disaster, the current departments DB rebuilds, applications, batch cycle jobs.
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB

Senior Data Warehouse and Business Analyst

Analyst / Data Warehouse Analyst

  • Create SAS ad-hoc reports of DB, Files and anomalies. SAS used to extract, modify and sort/report data
  • Gathered and documented requirements for Architecture, Design, Development, Test and Implementation Meetings. Wrote LLDs for each and every artifact that I modified through the project and SDLC process. Upper management was kept abreast of the status and percentage of completion for each phase of the task and activities accomplished. Establish deliverables, roles and responsibilities procedures
  • Was responsible for the programming analysis, design, development and implementation of COBOL batch and Online core programs to meet JCPenney specifications. Plus, enhanced, debugged and documented Specifications, Analysis, Status, Enhancements and Memos for JCPenney's management needs.
  • Performance tune and enhance, DB2, Oracle DB's as well as the processes to update and refresh environments and performance tuning techniques for efficient programming and effective processing.
  • In the Merchandising and Warehousing modifications/enhancements to performance tune slow batch programs and processes.
  • Source Platforms worked with Mainframe, As400/ISeries, Windows, Unix, VM, SQL, Active Directory . All a crossed our great nation as well as world wide
  • Performance Tuned backups for the Disaster Recovery process, ran to successful completion in an annual mock disaster, the current departments DB rebuilds, applications, batch cycle jobs.
  • Collaborate with the Data Center and the Infrastructure Group with the implementations of data security issues, and those the projects that they were modifying our Security DB
  • COMSYS - Cutler Williams February 1996 to February 1998
  • EXCEL Telecommunications, Sr Business -Programmer Analyst - Addison, TX
  • Sprint, Contract Programmer Production Support - Irving Los Colinas , TX
  • MBNA, Contract Programmer/Development Programmer Analyst - Addison, TX
  • Henderick Medical Center, Senior Programmer Analyst - Abilene, TX February 1995 to February 1996
  • IBM Consulting Contract Project Manager / Business Analyst - Abilene, TX February 1994 to February 1995
  • West Texas Utility WTU - Central Southwest

Project Manager

  • Information Retrieval Methods, Inc., Senior Programmer Analyst - Carrolton, TX February 1993 to February 1994
  • Banctec Systems Inc. Programmer, Systems Analyst and Account Manager Farmers Branch, TX 1989 to 1992 Systems Analyst for Mainframes, Mini's as well as PC's
  • Honeywell Worldwide Information Systems, Junior to Senior Programmer / Project Leader/ Tech Writer - Phoenix, AZ 1978 to 1989 Systems Analyst for Mainframes, Mini's as well as PC's

We'd love your feedback!