Data Quality Analyst Resume
Charlotte, NC
OBJECTIVE
- To continuously work as a Data Analyst, in a progressive environment, with the opportunity to contribute to the success of the Organization that would allow me to utilize my technical, analytical, as well as interpersonal skills.
SUMMARY
- 8+ years of IT Industry Experience in the Data Analysis, Design, Modeling and Data Warehousing.
- Expertise in Microsoft SQL Server and Sybase.
- Proficient in Informatica.
- Professional experience using advanced SQL coding, in various platforms, such as Oracle, Teradata and SQL server for data mining and report generation.
- Expertise in DDL and DML, as well as using Aggregate Functions.
- Extensively worked on MS SQL Server Databases, as well as Microsoft Access.
- Professional experience in data analysis and identifying issues, as well as report creation from several and Complex data sources.
- Created numerous Volatile, Set and Multi - Set tables using Teradata.
- Developed numerous SQL Queries for data Extraction.
- Proficient in Conceptual, Logical and Physical Modeling
- Expertise in the use of UML Diagrams (Use Case, Class, and Package).
- Proficient in Data Cleansing and Scrubbing.
- Excellent communication with multifunctional teams, programmers and technical staff at all levels.
- Strong customer service skills and experience consulting with users, resolving problems and meeting specific technical and business needs.
- Participated in requirements gathering and analysis, as well as Design sessions to understand the needs of the users.
- Highly proficient in understanding end user requirements and submitting efficient and quick solutions.
- Solid background in technical and problem solving concepts and have an excellent capability of utilizing academic knowledge and previous experience.
- Comprehensive knowledge and experience in all phases of the Software Development Life Cycle (SDLC).
- Strong team building and development skills.
- Ability to meet deadlines, and produce effective results, while working both independently and in teams.
TECHNICAL SKILLS
Operating System: Win XP, 7, and 8, Windows Server 2003, 2008, (X64), and Linux
Databases: MS SQL Server 2008/2012, Sybase, Netezza, Reports-To-Go
ETL/Other Tools: SSAS, SSRS, SSIS, Sybase
Scripting: SQL, Tableau, MicroStrategy
Querying Tools: SQL Server Management Studio 2008/2012, Teradata SQL Assistant, SQL Developer, MicroStrategy, Reports-To-Go
Software: Microsoft Office Word, Excel, Access, PowerPoint, Visio, and SQL Server Power Pivot for Excel
Software Development: Analysis, Design, Coding, Testing and Documentation, Software Development Life Cycle (SDLC)
PROFESSIONAL EXPERIENCE
Confidential
Data quality Analyst
Responsibilities:
- Prepared Business Logic Document (BLD) to transition manual data quality work to Ab Initio, configuring the datasets and writing business rules respectively.
- Leveraged Ab initio reporting tool for our data quality reports.
- Involved in creating dashboards and reports inTableauto monitor scorecard defects
- Wrote and configure data quality rules in Ab Initio
- Wrote and develop SQL query for business rules
- Responsible for developing data quality checks on the Teradata/Oracle Landing Production environment for Master and Reference data, ensuring that the processes and tasks were executing correctly, so the Business Owners could certify on the accuracy of data controls and data quality.
- Leveraged the FSD and BRD to write business rules for Reference data and monitor rules daily using SQL queries.
- GeneratedTableauDashboards with quick/context/global filters, parameters and calculated fields inTableau reports
- Prepared reports to summarize the daily data quality status and work activities.
- Worked with the QA team in preparing testing strategies, wrote test scripts and coordinated testing with business line partners.
Confidential - Charlotte NC
Data Analyst
Responsibilities:
- Gathering and analyzing business requirements, conduct gap analysis, set operational specifications, designing.
- Developing and testing of Client/ Server and Internet based applications using Java, JSP, Servlets, SQL, XML, MS Access, Oracle and QA testing tools.
- Migrate reports from multiple platforms to centralized BI ODS platform in order to get centralized source suing ICOMS and CSG Billing systems for all the reports.
- Create and maintain reports based on report requests from different customer and sales, Finance, Marketing and several other departments using SQL/TSQL, (AS400), Oracle and develop and maintain Ad-hoc reports using Microstrategy tools.
- Work on SSRS reports and deployment, create or automate Peer Review Templates using Excel VBA
- Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
- Develop reports using complex formulas and to query the database to generate different types of ad-hoc reports usingSSRS.
- Create and maintain reports based on report requests from different customer and sales, Finance, Marketing and several other departments using SQL/TSQL, (AS400), Oracle and develop and maintain Ad-hoc reports using Microstrategy tools.
- Developed codes in multiple billing applications using SQL queries/scripts based on the approved Business Requirement Document.
- Provided functional / technical support on current systems in ICOMS, ODS and CSG billing system by ensuring escalated issues are communicated, managed and resolved considering priority and customer impact
- Create and develop report using Microstrategy reporting tools and maintains data consistency and integrity
- Created dashboards and reports inTableau and created report schedules onTableau
- Work with Business Analysts to understand client needs and suggested alternatives for a more effective and efficient Business process.
- Interacted with end-users and business analysts, identifying and developing business requirements.
Confidential - Burlington NC
Data Analyst
Responsibilities:
- Requirements gathering & analysis.
- Performed Documentation of Business & Systems Requirements.
- Performed numerous SQL Statements to Load and Extract Data to and From Database.
- Created Multi Set, Set and Volatile tables using Teradata.
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
- Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau
- Developed Tableau visualizations and dashboards using Tableau Desktop
- Developed Tableau workbooks from multiple data sources using Data Blending
- Extensive use of OLAP Function as well as complex joins to extract data for reporting purposes.
- Created views to make data available on need to know basis.
- Created queries to fetch data from different tables, using derived tables, Sub queries, as well as Correlated queries on SQL Server platform.
- Performed numerous SQL queries that were highly tuned using concepts like Explain, Stats and CAST.
- Used SSAS to import and export data from and into SQL Server platform.
- Used UML Diagrams to graphically capture system functionalities.
- Periodically Designed Conceptual, Logical and Physical Models to effectively improve Business processes.
- Modified various data sources, writing complex new queries based on business needs.
- Maintained departmental reports on daily basis and managed performance issues.
- Daily interaction with internal users, and business analysts for updates and implementation of data request for key business reports.
- Interacted with Business Analysts to understand client needs and suggested alternatives for a more effective and efficient Business process.
- Worked side by side with end-users and business analysts to identify and develop business requirements.
Confidential - Abbott Park IL
Data Architect
Responsibilities:
- Created and refreshed monthly Data Marts for various processes.
- Requirements Analysis, identifying the necessary tables that need to be populated into the database.
- Performed numerous data extraction requests involving SQL scripts.
- Analyzed data coming from different Data Sources.
- In depth analysis and preparation of data, generating weekly, biweekly and monthly reports using MS Access and SQL.
- Extensive use of SAS functions such as Proc Report, Proc Summary, Proc Print and Data Null Reports.
- Data Analysis, Documentation, and Data Quality Checking.
- Periodically created UML Diagrams to come up with a Data Design, that helped the business run more efficiently.
- Created Multi-set and Set tables in Teradata database.
- Maintained Data consistency and integrity.
- Excellent Analytical and Documentation skills, along with the ability to be a key player in a Team Environment.
- Interacted with end-users and business analysts, identifying and developing business requirements.
- Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects reports.
Confidential - New York, NY
Data Analyst
Responsibilities:
- Understanding Business requirements, and translating them into System requirements.
- Created Data Models using Conceptual, Logical and Physical approach.
- Performed calculations for expected results.
- Performed Data analysis and generated Datasets for quantitative analysis.
- Created Tables in Teradata Database.
- Wrote complex SQL statements using joins to extract data from the Tables.
- Performed numerous SQL Queries using OLAP Functions, such as RANK, QUALIFY, CUBE, ROLLUP etc…
- Performed in depth analysis of data & prepared weekly, biweekly and monthly reports by using MS Excel, MS Access and SQL.
- Periodically interacted and coordination with end users and team members to identify Business system needs, to evaluate solutions for business problems and come up with alternative methods that will increase efficiency and improve performance.
- Analyzed and documented information system requirements and related outcomes on business processes.
Confidential
Data Analyst
Responsibilities:
- Developed new reporting solutions and updated existing reports
- Developed simple to moderately complex SQL queries for ad-hoc reports
- Completed user service/maintenance requests
- Maintained user application access control through Azure Active Directory
- Worked in cross-functional collaboration with internal customers to identify opportunities for improvement in business operations and processes
- Provided functional / technical support on current systems in production and new development by ensuring escalated issues are communicated, managed and resolved considering priority and customer impact
- Provided process improvements as requested by researching existing functionality and working with vendors to design functional changes for implementation
- Resolved data issues and updates for multiple applications using SQL queries/scripts
- Assisted in testing proposed vendor solutions
- Created support documentation for common issues in new and existing applications
- Provided periodic user training (for new application users, on application updates, for general issues)
- Assisted in new system implementation and tasks (CRPs, running Go-live meeting calls and noting/resolving issues