We provide IT Staff Augmentation Services!

Data Analyst Resume

Cranford, NJ

SUMMARY:

  • Experienced Data Analyst/SQL Analyst/Data Quality Analyst/Business Analyst with 7+ years’ experience in IT, Ecommerce, Banking, Hi - Tech and insurance industry.
  • Adept at analyzing and modeling business processes, requirements gathering and expectation management.
  • Skilled at developing a deep understanding of an organizations business and culture and building collaborative environments receptive to views of divergent stakeholders.
  • Experienced in data mapping, data modeling and collecting various data metrics for marketing, performance return of investments and customer-level engagement projects.
  • Extensive experience in Process/Data Modeling, Quality Assurance/Testing of both client and server side and data warehousing applications.
  • Well versed in analyzing requirements, instilling changes in business processes and managing data flow in a project.
  • Skilled in eliciting stakeholder demands and translating them to data, functional, quality and usability requirements.
  • Experience in full Software Development Life Cycle (Waterfall, Spiral, Agile & other SDLC implementation) and Project Management Life Cycle (PMLC).
  • Strong experience in UML artifacts related to Business Modeling and Requirements, to support requirements Elicitation, Analysis, Specifications, Traceability, Validation, Verification and Requirement Management.
  • Experienced in preparing Score Cards and metric reports using MS Access and Excel.
  • Business Intelligence experience including requirements, data analysis, designing /mode ling relational DB, data warehousing, transformation and conversion, report development and prototyping, root-cause analysis, reverse engineering and data reconciliation
  • Worked with data validation, adhoc report, report validation using excel, VBA Macro, crystal Reports and Business Objects.
  • Excellent SQL and PL/SQL skills for creating queries, procedures, database triggers to collect profile and scan data.
  • Worked with Teradata, MS SQL Server, Oracle and MySQL database environment.
  • Good analytical and communication skills and ability to work independently with minimal supervision vis-à-vis contributing productively as a team member.
  • Experienced in creating and review data models PDM using ErWin and ERstudio. And reverse engineering documentation and understanding the CDM using Visio.
  • Extensively used HP QC for reviewing the data / data quality related issues that needed escalation to the governance team / steward.
  • Actively used Requisite Pro to capture data requirements that helps improve scalability and traceability of application.
  • Used configuration management tools like VSS, clear case and BMS
  • Performed Data profiling and scanning for the data governance team to set the data quality criteria using rules engine

TECHNICAL SKILLS:

Operating Systems: Microsoft Windows 2000/NT, UNIX, WINDOWS XP/98/95 and LINUX

Databases & Tools: ORACLE 8i/9i/10g/11g, MySQL, MS SQL Server, DB2, T-SQL

ETL: Informatica 9, AbInitio, DataStage

Reporting Tools: Crystal Reports, Microsoft SSRS, Business Objects, Cognos, SAS

Web Technologies: XML/HTML/DHTML/CSS MS SQL, Servlets

Quality Management: Jira, HP QC

Process Tools: Rational Requisite Pro 2001, Rational ClearcasePackages MS Office (Word, Access, Excel, PowerPoint, Project, Visio), Macros using VBA

Languages: VBScript, SQL,PL/SQL

PROFESSIONAL EXPERIENCE:

Confidential, Cranford, NJ

Data Analyst

Responsibilities:

  • Identified and prioritized strategic themes of the business to align them with IT strategies thereby growing revenue, improving profits through efficient quality of services.
  • Collected key data metrics to determine mandatory and discretionary investments based on the prioritizations and projected the expected returns using MS Access.
  • Created implementation checklist, using MS Excel for turnover to Application Continuity and Production Support.
  • Validated and informed the technical design through data analysis across multiple layers of data warehouses, source systems and B2B channels
  • Responsible for data mapping and data mediation between the source data table and WMO data tables using MS Access and MS Excel.
  • Created SQL queries to pull out data and metrics from the database.
  • Used Quality Center to resolve data and reported system defects by coordinating between the SME and development team.
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
  • Creating/altering T-SQL stored procedures, UDFS, and statistical sampling code that feeds (SSIS) packages.
  • Tested datasets using several stored procedures.
  • Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results.
  • Checked the naming standards, data integrity and referential integrity.
  • Wrote complex SQL queries to identify granularity issues and relationships between data sets and created recommended solutions based on analysis of the query results
  • Tested the database to check field size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.
  • Identified, suggested and managed improvements in the process to meet data quality criteria.
  • Using and generating pivot tables to provide LOB ad hoc reports via SSRS
  • Created adhoc reports and pivot tables in Excel 2013 using VBA and macros.

Environment: SQL Server, Quality Center 9.0, Business Objects, Oracle 10g/11g, Unix IBM AIX 5.5, T- SQL, XML Files, XSLT, XML Spy 2010, Pivot Tables, Macro, SQL,DWH ETL, T-SQL, SSIS, SSRS, PL/SQL. Excel, UAT.

Confidential, Foster City, CA

Data Analyst

Responsibilities:

  • Review Mapping Documents formula and rule engine.
  • Involved in Logical and Physical modeling of various Data marts as well as data warehouse
  • Analyzing change request for the existing mapping and creating an impact analysis for the change on Data
  • Writing new mappings specification according to the business data requirements
  • Suggested and reviewed Materialized views to store aggregate values
  • Prepared Test data preparation strategy and data masking strategy for the shared test environment
  • Involved in completing data testing before the UAT.
  • Co-ordinate with development and QA team for handling of defects with respect to data
  • Interact with clients/business users when issues arise on Data governance
  • Provide support during parallel and reverse parallel runs.
  • Created spreadsheet with all the production issues/solutions as part of lessons learnt and to help form FAQ for the maintenance team.
  • Used Pivot tables, vlookups and conditional formatting to verify telemarketing data against data uploaded to proprietary database and online reporting.
  • Created ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
  • Created data rules to handle SCD Type II data using PL SQL.
  • Helped sequence the workflows for batch based on dependency to improve the time taken for end to end loading.
  • The order data thus loaded into SQL Server was used to generate reports using the new SSRS 2008
  • Reviewed all artifacts created with respect to Logical and physical data models including Tables, procedures, indices, synonyms, views, functions, triggers, sequence, constraints

Environment: Quality Center 10.0, Agile, Java, .NET, XML, HTML, Windows and Unix, Shell Scripting, SQL, PL/SQL, TOAD for Oracle 9.1, Oracle 10g, Pivot Tables, MS Office, COGNOS, UAT.

Confidential, San Jose, CA

Data Analyst

Responsibilities:

  • Gathered Business requirements based on the project scope and SDLC methodology.
  • Conducted JAD sessions with SME including business owners, sponsors and analysts.
  • Worked with the Product Managing team in setting realistic project expectations and in evaluating the impact of changes on the organization and plans accordingly.
  • Conducted back end email tracking using MySQL to do the success rate study to measure Email Broadcast campaign success, deliverability and measure marketing response for each of the campaigns.
  • Collected metrics using MySQL like number of emails generated, percentage of who opens, forwards and clicks-through for the campaign.
  • Analyzed and conducted data mapping of the metrics with the member profile data and also the attendance and purchasing data to understand the overall profiles of the members.
  • Designed and developed Use Cases and Activity Diagrams using UML in rational rose and Visio.
  • Created MySQL queries to pull out user-level activity data and various other metrics defining popularity of products on the website.
  • Collected user related visitor-level metrics like frequency of visits, duration and number of unique visits and stickiness to measure the effectiveness of the recommendations available.
  • Extensively used MySQL Toad for querying underlying database tables and resolving data issues.
  • Assisted the Product support team to create and constantly update the FAQ section by actively researching issues and addressing customer questions.

Environment: MS SQL Server, MS Access, Excel, Excel Data Analysis features, Excel VBA, MS Word, UML, ETL, SQL, TOAD, Visio.

Confidential, Roseville, CA

Reporting Analyst

Responsibilities:

  • Created workflow diagrams for the Claims Management module including, track, record and calculate lost work time.
  • Provided business cycle time and cost metrics to suggest re-engineering of processes to reduce them and increase output for customer satisfaction.
  • Understood the process flows, data and algorithms for Claims Management module including the ability to track employee benefit type, out-of-work time period, wages earned etc.
  • Subject Matter Expert of the National Council on Compensation Insurance NCCI and EDI-IAIABC Reporting requirements and reports generation using MS Excel and advanced use of VBA and macros.
  • Created SQL queries and database triggers for state mandated reports and data elements.
  • Conducted data modeling and data mapping for reporting data elements.
  • Analyzed data discrepancies and validated them with the client business rules.
  • Defined milestones in project plan using MS Visio with the help of WBS and network diagram.
  • Produced documentation including detailed Business Requirements, Functional Requirements and assisted to produce Technical Specification and Operations Manual.
  • Identified Use cases from the Functional requirements and wrote Use Case Specifications and created business process workflow diagrams in MS Visio.
  • Assisted Developers in Data Modeling using Entity Relationship Diagrams (ERD).
  • Collaborated with cross-functional teams throughout the project life cycle.

Environment: MS SQL Server 2008 SSRS, SSIS, MS Access, Excel, Excel Data Analysis features, Excel VBA, MS Word

Hire Now