We provide IT Staff Augmentation Services!

Data Governance Senior Data Analyst Resume

TECHNICAL SKILLS

OPERATING SYSTEMS: Windows 2000/XP/NT/VISTA/7/8/10

DESKTOP SOFTWARE: MS Office (Word, Excel, PowerPoint, Access, Project, Publisher, INFOPATH), Ultra Edit

DATABASES: ORACLE 9i - 11g, MS Access, SQL Plus, SQL, SQL Server, Teradata

HARDWARE: Dell, Gateway, Compaq, HP,ASUS, ACER, Lenovo

PROGRAMMING: ASP.Net, VB.Net, Java, C++, Oracle Application Express, VB, VBA, Perl

BUSINESS INTELLIGENCE: Business Objects, SSRS, Cognos, Crystal Reports, BOBJ

NETWORKING: MS Windows Server 2000, Novell 4, MS XP, MS Vista

PROJECT MANAGEMENT: Quality Center

DATA WAREHOUSE TOOLS: Toad, SAS, Advanced Query Tool, Informatica, SAS, RubyMine

DOCUMENT MANAGEMENT: MS SharePoint aWARDS

PROFESSIONAL EXPERIENCE

Confidential

DATA GOVERNANCE SENIOR DATA ANALYST

Responsibilities:

  • Interface with the Data Stewards to complete data clean-up, data mapping, and answer ad-hoc questions
  • Write and maintain data standards documentation
  • Develop and implement data quality rules and monitor their impact
  • Manage the data quality exception process (monitor compliance and triage issues)
  • Partner with business data stewards to ensure policies and procedures relating to corporate master data are met across business and corporate areas
  • Provides issue resolution or escalates as needed to appropriate level or parties
  • On-going support for the Data Requirements, Data Architecture, and Development teams
  • Manage the alignment with IT strategy and architecture, at both the enterprise and business-unit level
  • Handle ad-hoc data quality and data standards requests
  • Write and maintain the data quality rules
  • Write and maintain the ETL mapping documentation
  • Understand data models, defining and implementing data distribution standards and access controls
  • Build the infrastructure to create and continuously maintain a dynamic data dictionary tool
  • Ensures policies and data definitions are understood and broadly communicated across the enterprise
  • Develop internal reports to track efficiencies and identify process improvement opportunities.

Confidential

DATA ANALYST

Responsibilities:

  • Worked with Requirements Analyst to understand scope, semantics, and business rules for the project information and data
  • Advised project team on existing data anomalies, risks, and acts as subject matter expert in resolving these issues
  • Consulted with the Build and QA teams to facilitate the development of the solution
  • Identified data conversion/integration needs and as a result develops data conversion/integration strategy, requirements, plan and design.
  • Elicited and validated information/data requirements from business and technical users
  • Created and modified data models including conceptual, logical, and physical models based on information requirements
  • Mapped new data or remap existing data to new or existing targets
  • Profiled data to identify the nature of the data, relationships between entities, and how it will be used in order to determine the best data model
  • Collaborated with requirements leads and other data analysts to understand cross project impacts of data enhancements and changes
  • Collaborated with architect and tech leads on approaches for complex modeling and mapping to identify or validate that it is the best solution

Confidential

DATA MANAGEMENT ANALYST

Responsibilities:

  • Created and analyzed data queries and performs root cause and other analysis on data moving to Integrated Consumer Data Warehouse (ICDW).
  • Supported the inventory of data fields that will be landed in ICDW.
  • Coordinated the development of requirements with business management staff and technical teams.
  • Coordinated and participated in test execution to ensure data has been properly landed in ICDW.
  • Identified data sources, coordinated data feeds from external sources and developed, or coordinated the development of, reports, queries, forms and screens to meet process and information needs of business unit.
  • Followed through to ensure resolution, responding to user’s inquiries, requests for assistance and needs, and providing user information and training as requested.
  • Formulated recommendations and options based upon analysis, data and input from users, business unit management and other technical staff; participated in project activities including prioritizing, developing schedules, determining resources, preparing plans, data and documentation, and resolving issues.
  • Increased knowledge of the information needs of the business unit and pursue the technical skills necessary to support those needs; and perform other duties as assigned.

Confidential

SENIOR DATA ANALYST

Responsibilities:

  • Maintained existing Service Level Agreement (SLA) reporting functions including aggregation and reconciliation of data
  • SQL Server supporting financial and accounting report information
  • Designed and created reports using Crystal Reports
  • MS Access SSRS reports to SharePoint for management use
  • Created and distributed internal and external SLA reports & scorecards within the required time limits
  • Maintained all data and reports to ensure that data meets compliance & audit requirements
  • Identified & documented SLA and scorecard reporting requirements for new reporting request by gathering the business and data needs from cross-functional business community and translate into business requirements
  • Designed, developed, tested and supported solutions for new SLA & scorecard metrics
  • Identified and drove reporting efficiency and scalability improvement opportunities
  • Analyzed, researched, and problem-solved to produce effective daily reporting operations
  • Translated business information needs into clear, actionable charts, graphs and reports
  • Used Microsoft Sharepoint within the company for document and file management and site collaboration
  • Effectively organized and prioritized work
  • Documented ETL process for EQRM process
  • Assisted in production of mapping documentation
  • Provided innovative concepts to improve data loading and maintenance process

Confidential

SYSTEMS PROGRAMMER

Responsibilities:

  • Site Administrator for Microsoft Sharepoint sites within the company for document and file management and site collaboration
  • Built SQL queries to support report information
  • Created databases in MS access to produce end user reports
  • Created custom data collection applications using various data collection programs (ex. Infopath, Redcap, Select Survey)
  • Established schedules and priorities for system programming, standards definition, and other support activities
  • Reviewed and approved results of software tests prior to implementation
  • Evaluated performance of hardware and software
  • Planned for training of staff in use and operation of installation’s software
  • Determined cost/benefits for various configurations of hardware and software
  • Analyzed proposed modifications to current systems and implementation of new systems for the impact on the installation
  • Assisted in selection of new software and/or modifications that will enhance operating and development activities
  • Designed, codes, and tests special software requirements of the installation
  • Directed equipment evaluation and acquisition projects
  • Projected requirements for configuration changes based on application plans and growth of production systems
  • Analyzed production or testing problems to determine source of problem and makes necessary corrections

Confidential

SENIOR OPERATIONS ANALYST

Responsibilities:

  • Designed, tested, and implemented MS Access/ Oracle databases based on user requests following internal project life cycle
  • Worked with users to develop MS Access databases within the scope that meets the user's needs
  • Delivered regularly scheduled queries/database maintenance in a timely and accurate manner
  • Produced/Completed ad hoc requests when needed
  • Developed scope documents that layout database design and follow a development lifecycle in the most efficient manner to meet user needs in shortest development time
  • Developed innovative solutions and propose process improvements while thinking freely and out-of-the-box
  • Provided feedback to requestors about how to make a process better / faster while maintaining any JPMC Internal Compliance or audit related concerns
  • Developed reports using Crystal Reports
  • Worked with users and team members in positive, productive, and respectful manner
  • Turned in thorough progress reports on due dates
  • Furnished management requested reporting
  • Provided support and feedback to teammates

Confidential

MIS OPERATIONS ANALYST II

Responsibilities:

  • Prepared various management reports for Operations Departments using MS Excel
  • Assisted in resolving Hardware and Software technological issues
  • Arranged and distribute MIS reports to Team Managers
  • Self-motivated in accessing and processing report information
  • Utilize macro’s in MS Excel and Access to create various management reports
  • Ensures department adheres to governmental compliance laws
  • Resolved Telephony issues for department
  • Manage/order contracted help for department

Hire Now