We provide IT Staff Augmentation Services!

Lead Data/quality Analyst Resume

4.00/5 (Submit Your Rating)

Wilmington, DE

SUMMARY:

Hands on developer, from early SQL languages forward to Informatica Powermart/Powercenter, Oracle, SQLServer and UNIX. With expertise in diagnosing problems, possess excellent analytical, organizational and problem - solving skills, able to provide quick accurate technical support. Assist with client and internal users. A goal oriented, highly motivated self-starter with a strong orientation to customer service. Able to work independently in self-directed work environments or across a wide array in collaboration with other teams as a Data/Business Analyst.

TECHNICAL SKILLS:

Languages: SQL, Informatica 6.x-9.x, Informatica Powermart/Power center, Ab Initio, PLSQL, Sqlserver Business Objects, Focus, Holos, SQL, T-SQL, sqlserver,C, Natural, Rexx, Basic, Cobol

Databases: Oracle 8i-11, TeraData, MS Access, SQL

Operating System: UNIX, Solaris, HP-UX, AIX, Linux, Windows, MS-DOS

Software: SAP BPC, Microsoft Excel, Word, Office 2000/2003/2007 , Project, Powerpoint, AccessVisio, Vi, Syncsort, TSO, JCL, Class in Tableau

Tools: Oracle, Control M, CA ServiceDesk, Teamtrack, Clearquest, Clarify, HP Quality Center, Tivoli, Toad

PROFESSIONAL EXPERIENCE:

Confidential, Wilmington, DE

Lead Data/Quality Analyst

  • Responsible for identifying correct/incorrect data sources from up streams systems to create accurate reports to the downstream systems.
  • Provide and update data mappings based on new and existing data sources.
  • Ability to identify root cause for data anomalies and data quality issues and translate into meaningful explanations.
  • Compare data/datasets to identify bad records from source to target systems using SQL queries, unix
  • Mockup test data using Ab Initio for code changes for data transformations.
  • Creating test plans, test strategies using HPALM.
  • ETL using Ab Initio, Oracle, Control M, Excel.
  • Analyze and revise existing functional requirements and technical documentation.

Confidential, NYC,NY

Business/Data Analyst - Data Solutions Delivery team

  • Support ratings 360 project design and data processes and workflows for capital markets, BICRA and financial statements.
  • Assist with system integration and user acceptance testing.
  • Generate Data Requirements, review with Business Owners, and get sign off.
  • Collaborate with the technical, data assurance and data content management teams.
  • Provide Data Support to Developers and QA teams.
  • Conduct Data Profiling, and Mapping documents across data domains (People, Reference, Rating, Scores, etc).
  • Analyzing data using sql, excel, pivot tables, vlookups.
  • Assist with tracking, investigation and resolution of data issues raised thru Version One stories.
  • Check which services are called from JSON code(.js) on web page using Google chrome.

Confidential, Jersey City, NJ

Business/Data Analyst

  • Engage with business user to prepare and execute UAT testing for the reporting application infrastructure.
  • Use SQL queries to gather appropriate data and get desired outputs for end users.
  • Identification of data lineage, domain, valid values and data quality issues.
  • Understanding of business requirement to create workflow environment.
  • Create mappings using Informatica to source different sources into IntelliMatch.
  • Defining rules/process to expedite on data profiling and automated identification of data quality issues.
  • Create SQL queries ensuring application is stable and defect free.
  • Extract, Validate, transform and summarize data generated from database using SQL, and MS Excel.
  • Ability to analyze large amounts of data from multiple different systems, identify disparities and draw conclusions.
  • Ability to gather business requirements, and in some cases develop process/system designs based on the analysis.

Confidential, Mount Laurel, NJ

Data Quality Analyst

  • Responsible to test the upgrade to Oracle 11g, and Informatica 9.
  • Create/Write test scripts against Systems Requirements Specification (SFS).in Excel and then upload to HP Quality Center Suite (ALM),
  • Develop solutions to respond to business needs using SQL, Informatica, Oracle, HP Quality Center Suite (ALM), Excel.
  • Responsible for various aspects of software application testing, ensuring application is stable and defect free.
  • Support a number of projects and work with other ETL testing developers with onshore and offshore resources to test data warehouse, datamart and data integration solutions.
  • Analyze data models and create SQL queries ensuring application is stable and defect free.
  • Validate data using Informatica Powercenter 9.5.2.1 - Data Validation Option (DVO)

Confidential, Wilmington, DE

Data Quality Analyst/ Data Steward

  • Identifies data integrity issues in the Bank Data systems and creates processes or audits to address data issues.
  • Production Support - Identify issues, review errors, approve resolution, and advise of potential downstream impacts.
  • First line of support for Business Users and Analysts including mailbox support, researching questions and maintaining web based knowledge base.
  • Develop solutions to respond to business needs using SQL, Informatica, Ab Initio, Oracle, TeraData, HP Quality Center Suite (ALM), Excel, Tableau
  • Trouble shooter using technical expertise to assist both sides (User/Level 3 Support) in understanding why data doesn’t appear as it should, and then work with both sides to see that it gets fixed.

Confidential, Wilmington, DE

Data/Quality Analyst

  • Data warehousing and ETL processing to test credit card (POS) / Fraud Prevention applications using ETL tools.
  • Compare data/datasets to identify bad records from source to target systems.
  • Create test data using Informatica, Ab Initio for code changes for data transformations.
  • Creating test plans, test strategies, resource scheduling and test timelines for credit card applications.
  • ETL using Informatica, Ab Initio, Oracle, TeraData, HP Quality Center Suite, Control M, Tivoli, Excel.
  • Analyze and revise existing functional and technical documentation.
  • Participate in developer led code reviews & documentation and Business analyst Functional requirements.
  • Quality Assurance / Control with a thorough knowledge of Software Development Life Cycle principles and QA methodology.
  • Experience in Backend Testing using SQL queries and Unix Shell Scripts, Unix commands diff, wc, tail, head, grep, sed .

Confidential, Yardley, PA

Solution Architect

  • Configure, build, and implement SAP BPC solutions including upgrades to BPC 7.5. SAP BPC utilizes OLAP technology with multi-dimensional which allows users to “slice and dice” the data according their needs (Configuration management).
  • Data Tie Out and Validation.
  • Conducted training to clients in using SAP BPC.
  • Configuring Appset, Applications, Dimensions, Properties in BPC.
  • Create cubes in SQL Server Analysis Services (SSAS) and update/build SSIS packages.
  • Establish, maintain and update BPC Security.
  • Configuring EVDRE reports and fixed Report and Template Issues (Excel).
  • Responsible for the designing the advance SQL queries, procedure, triggers, functions, scripts.

Confidential, Roseland, NJ

DATA WAREHOUSE - LEAD PROGRAMMER/ANALYST/QA/SUPPORT

  • Designed and developed mapping process required to extract, transform, and load data ETL for Confidential Reporting into Oracle databases using Informatica, SQL, Unix. Responsible for ETL deployments and support in a large production environment.
  • Analyze and performance tune tables, views, and ad hoc queries.
  • Experience in working with and development of Star/Snowflake Schema Design, DataMarts and Dimensional Models, stored procedures, triggers, MQTs, views, cubes.
  • Identified defects, user error or enhancements for Confidential reporting application. Work closely with development organizations and other corporate departments in US, India and Brazil to troubleshoot the situation, or creating a work around. Research resolutions to problems and provide reasonable set expectations when addressing the client or business partner. Provide daily updates or follow-ups to clients.
  • Experience with Data Warehousing concepts, Data Analysis, Data Warehouse Architecture.
  • Involved in all phases of Software Development Life Cycle (SDLC) for Confidential Reporting product.
  • Recognized for the ability to meet and exceed client’s expectations in providing support.
  • Supervised staff that provided product and technical support for clients.
  • Produced Weekly and Monthly reports to upper management of the usage of Confidential reporting.
  • Trained new employees in the use of specific Confidential applications, and processes.
  • For all processes and procedures in production, change management was used
  • Tested Confidential Reporting application and setup automatic testing using QTP and sql queries in sql oracle, SQL Plus.
  • Identified numerous new methods for resolving common issues more efficiently.
  • Excellent ability to resolve and document the root cause for reported issues. Troubleshoot and identified application vs. user problems

Confidential, Piscataway, N.J

DATA WAREHOUSE PROGRAMMER/ANALYST

  • Data warehouse development and implementation for Financial and Time Mart using Informatica and Oracle databases in Unix.
  • Developed mapping process required to extract, transform, and load data, ETL for Financial Mart from Oracle financials and Time Mart from Peoplesoft.
  • Created mappings and Unix shell scripts for ETL process (extract, transfer and load) data.
  • Assisted in designing the Data warehouse models.
  • Tested new and existing mappings for Financial Mart using Metadata from ErWin.
  • Use Pre-Session and Post-Session to run shell and SQL commands.
  • Run session and batch jobs using Informatica Powercenter Server Manager.
  • Oncall for production support.
  • Responsible for weekly Crystal HOLOS (OLAP) time reports by Organization, Products, Projects. Data from Peoplesoft is loaded to oracle tables and cubes are created for the Holos reports.
  • Designed and coded Profit and Loss reports in HOLOS (OLAP). Created cubes from oracle databases.
  • Responsible for monthly data loads for HOLOS Financial reports.
  • Developed common functions used by HOLOS programmers.
  • Trained new Informatica and Holos Programmers.

We'd love your feedback!