Data Analyst Quality
Resume:
Purvi B. Patel
************@*****.***
SUMMARY:
Over 10+ years of experience in Information Technology as a Digital Product Management and Business\Data Analyst within Data Quality Management, with expertise in implementation of IT projects using project management methodologies such as SDLC and Agile.
Support an Agile Software Development process, working in conjunction with end users / stakeholders and technical delivery team
Strong communication and technical skills with the ability to quickly grasp technical issues/concepts
Dissect high-level information into details and is able to communicate details in a manner understood by relevant audience.
Your ability to drill down into the details of a delivery request without losing sight of the big picture
Fast learner; able to learn new software solutions, business processes and design techniques quickly and efficiently
Ability to make critical judgement decisions and solid organization skills.
Excellent written and verbal communication skills, including the ability to understand, work with, and shape the vision of customers and stakeholders
Expert with requirements gathering, process/workflow diagrams.
Proficient in drafting functional documentation: User Requirement Specification (URS), System Design Specification (SDS), Requirement Traceability Matrix (RTM), and test plan.
In-depth knowledge of creating use case, activity, logical, component and deployment views to extract business process flows and workflows thereby helping development and quality assurance in understanding the requirements.
Technical expertise in data profiling, data cleansing, data enrichment, data integrity, reference data, and data quality management.
Expertise in application development with full lifecycle implementation of large Data warehouse including requirements gathering.
Expertise in writing BI report formats and templates/specs.
STRENGTHS:
Professional: Business Analyst, Data Analyst, Relationship Manager, Vendor Management, Reporting and data validation/reconciliation, Writing detail project plans
Personal: Analytical, Organized, Self-Motivated, Problem Solver, Tenacious
Technical: SQL, PL/SQL, SQL Loader, UNIX, UML, MS Office Suite
SKILLS:
UML, MS Visio, MS Project, UNIX, Windows, MS SQL, MS Access, MS Office, SQL Loader, MS Excel, Business Definition Requirements, Business Process Analysis, Gap Analysis, Use Case Modeling & Analysis, Data ETL involving various flat files and database including SQL Server
EXPERIENCE:
ARCH INSURANCE GROUPS, Jersey City, NJ October 2014 – Present
Agile Digital Product Manager\Business Analyst III
Arch Insurance is a market-leading insurer in the US. We provide a wide range of property, casualty and specialty insurance for corporations, professional firms and financial institutions across the US.
Acted as liaison between business and IT teams to refine the product and incorporate features based on market demands
Partnered with IT and product leadership to drive and manage the solution development process and ensure the product team understands the direction and vision.
Collaborated with teams to discover and deliver the best solution to the market presented by the product team lead and the business.
Created and maintained the solution vision, roadmap, and backlog of work through the project's life cycle.
Translated features into user stories within the team’s backlog while managing, ranking, and prioritizing this backlog to reflect stakeholder’s requirements.
Participating in the monthly/quarterly/annual production support processes for data receipt.
Responsible for process review, financial reconciliation, data quality and reporting.
Responsible for gathering requirements, developing workflow and system specifications.
Executing tasks required to deliver IT solutions in support of the Enterprise Data Management department.
Responsible for managing and implementation of data system requirements based on changes in workflow or changes in business requirements
Responsible for providing detailed business plans and business cases with detailed scopes of work.
Post deployment carry out testing of output by building test cases and thereby if need arises responsible fixing upstream data by supporting data quality initiatives
Maintain communication with our Statistical Reporting, Claims, and Finance and Advantage teams and carry out presentation for project onboarding.
Consistently with technical teams (developers, architects, QA, infrastructure), business partners and software vendors to document and implement system modifications.
MOODY’S INVESTORS SERVICE, New York, NY April 2014 – August 2014
Data Analyst
Moody’s Investors Service is a leading provider of credit ratings, research, and risk analysis. Moody’s commitment and expertise contributes to transparent and integrated financial markets, protecting the integrity of credit.
Documented existing and potential data structures and data flow process.
Generated data flow diagram, data mapping document and data dictionary.
Implemented data cleansing and data improvement initiative.
Conducted data validation, data integrity, data profiling, data auditing and data gap analysis using Excel and SQL.
Designed and implemented data quality monitoring reports, alerts and process.
Wrote SQL queries to check data quality and consistency check on SQL Server and Sybase environment.
Interpreted data and analyzed results using statistical techniques and provided possible solution.
Made data chart presentations for summarization of data quality and constancy analysis.
PDR NETWORKS, Montvale, NJ June 2011 – April 2014
Data Analyst/Business Analyst
PDR Network provides innovative products and services that benefit bio/pharmaceutical manufacturers, electronic health record (EHR) and ePrescribing vendors, healthcare professionals and other industry stakeholders, as well as the organizations that support them.
Established research methodology for collection of quality data.
Prepared reports and graphic illustration of data results using Excel.
Weekly monitoring of quality metrics to proactively identify issues related to data loads.
Responsible for data integrity checks, report anomalies, and coordinate with development teams for resolution.
Traced and documented data sourcing.
Identified and leveraged opportunities to improve the quality management processes, systems, and standards.
Utilized profiling, quality tools and various data sources in order to determine root causes of data quality disparities.
Provided data analysis, modeling and mapping along with ETL process description for outbound and inbound data flows.
Developed SQL queries and provided ad hoc reports to internal and external clients/vendor.
Performed integrity checks and quality assurance on all incoming files to ensure compatibility.
Assisted in data mining for direct marketing campaigns.
Administer extensive data management on large and complex databases and files.
Developed detailed and comprehensive business requirements.
Developed and maintain databases in support of management case studies and direct marketing campaigns.
Scrutinized and validated data outputs to ensure all deliverables are released to specification.
Developed user acceptance testing strategy and execution plans.
Performed performance testing to achieve workflow and server optimization.
Identified and summarized data related metrics for internal clients to perform feasibility studies.
VERO SYSTEMS, Howell, NJ August 2003 - September 2008
Business Analyst/Data Analyst
Vero Systems is a global provider of margin management products and services for the wire line, wireless, cable and VoIP service provider. Vero's flagship Acuité solution provides detailed visibility into network costs combined with automated switch updates that enable optimal cost routing, allowing service providers to intelligently and actively control their network costs.
Developed detailed mapping documents to resolve data inconsistencies between source systems vs. target system.
Developed detailed business requirements, use cases and process flow diagrams.
Debug complex data and provide detail report in spreadsheet.
Coordinated with various teams within the organization to gather and document business requirements.
Create data dictionaries based on extensive data analysis and data mapping.
Collaborated with product management and developed detailed functional design documents.
Performed data impact analysis on existing and new fields within the centralized data warehouse.
Reported and monitored defects leveraging Bugszilla, a defect tracking tool.
Propose and draft mock-ups of UI changes for internal-facing and consumer-facing applications.
Successfully developed standard documentation package, including requirements, specification, design, operations, and quality testing plans.
Analyzed business requirements and segregated them into high level and low-level use cases, activity diagrams and sequence diagrams according to UML methodology.
EDUCATION:
BS in Computer Science/Information Systems, Richard Stockton University
Contact this candidate