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