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