Lead Data Analyst Resume Samples

Description :

1. Created Logic for Data Cleansing of millions of records Created XML layout mapping for data Lead Data Analyst for MDM team for Cleansing and Matching of Millions of records being loaded into KyBOS system.
2. Pulled all Active business from DOR Data and All Active business from Secretary of State's data and were able to find over 125,000 matching businesses based on the matching rules created by our team.
3. Implemented PME (Probabilistic Matching Engine) from the MDM tool to implement these matches.
4. Designed the entire data flow for this project while also working on the design of KyBOS simultaneously.
5. Divided into two phases RODI Phase 1 Went live Takes New business registered in KyBOS Passes all data down to CRIS (Cross Reference Index System) Jobs in CRIS pick up data and pass to Sale Tax System, Corporate Tax System, and Withholding Tax System.
6. Worked closely with external customers, account managers, and other internal stakeholders to identify appropriate priorities and customer-driven data analysis tasks.
7. Ensured high-quality data was collected and maintained with appropriate integrity.

Experience

7-10 Years

Level

Management

Education

BS In General Studies

Description :

1. Led a team of developers in data analysis for portal transformation processes of Heartfulness.org Developed conceptual, logical, and physical data models for GoH business intelligence (BI) efforts.
2. Provided thought leadership, ensure that all relevant aspects of the data model (granularity) are taken into account.
3. Implemented logical and physical database models for DW storage platforms.
4. Understood the existing functionality of the AIMS database system and other CRMs.
5. Visualized large sets of data in dashboards using bubble charts, bar charts for decision-makers.
6. Translated technical aspects of data modeling (facts, dimensions) into language that non-technical users can understand.
7. Analyzed large and complex data sets, identifying patterns to better understand customer and company needs.

Experience

5-7 Years

Level

Executive

Education

Graduate Certificate

Description :

1. Created, maintained, and supported ETL SSIS packages used for data warehouse and reporting.
2. Automated data extracts by creating SSIS packages and SQL job scheduling.
3. Developed and deployed reports writing sprocs to SSRS or created Excel pivot tables from cubes.
4. Worked directly with the business to translate business logic and data mappings for data extracts.
5. Developed T-SQL code templates with error handling to create various DB objects and data scripts.
6. Provided help to DBA-restore test environments, deployments, permissions, and T-SQL scripts.
7. Communicated effectively and interacted with business stakeholders on a day-to-day basis.

Experience

10+ Years

Level

Senior

Education

Master Of Science In Management

Description :

1. Identified, assessed, and intimated potential risks associated with testing scope, quality of the product, and schedule Created and executed test cases for ETL jobs to upload master data to the repository.
2. Responsible to understand and train others on the enhancements or new features developed Conduct load testing and provide input into capacity planning efforts.
3. Provided support to a client with assessing how many virtual user licenses would be needed for performance testing, specifically load testing using Load Runner Create and execute test scripts, cases, and scenarios that will determine optimal system performance according to specifications.
4. Modified the automated scripts from time to time to accommodate the changes/upgrades in the application interface.
5. Tested the database to check field size validation, check constraints, stored procedures, and cross verifying the field size defined within the application with metadata.
6. Tested the ETL process for both before data validation and after the data validation process.
7. Tested the messages published by ETL tool and data loaded into various databases Experience in creating UNIX scripts for file transfer and file manipulation.

Experience

10+ Years

Level

Senior

Education

Masters Of Science In Electrical Engineering

Description :

1. Developed dashboard for all billing reports that will be expanded to personal lines auto business and other product lines.
2. Analyzed our Chat data and Calls Audio files to understand why we get more than 15 million calls related to billing Applying Pareto Principle to progressive customers to find segments of customers that have a high cost to acquire, retain, and service.
3. Provided technical direction in setting up a strategic roadmap for our Big data self-service environment.
4. Leveraged Tableau's data visualization capabilities, while wrangling/munging data from multiple sources, to create an integrated view of the business.
5. Deeply analyzed payment behaviors, Customer interactions, fraud and return payment behaviors with an estimated benefit of $50 M + in cost reduction and $500 M + in revenue increase.
6. Collaborated with cross-functional teams from R&D and Pricing to identify new variables that have high predictability value, estimated to create profitability by $65 M + in our key segments.
7. Analyzed returned payment behavior of our customers and recommended a change of our NSF restriction policy, thereby reducing our bad debt expense by $20 M + annually.

Experience

7-10 Years

Level

Management

Education

Master Of Business Administration In Finance/Accounting

Description :

1. Responsible for managing the development and maintenance of several data marts - extracting specified data using several database tools, ensuring data quality and accessibility with process controls and exception reporting, ongoing source system data analysis, data modeling, creating deliverables to specifications, managing requested changes, and enhancements as well as problems that arise on a day to day basis.
2. Responsible for working with the business analysts to define and implement business requirements through consultation with business users and analysis of data from multiple sources to design business processes, data marts, and several high-level management reports.
3. Focused includes tracking the inventory of assets and their attributes for risk and performance analytics.
4. Responsible for capturing and maintaining all metadata for the department to serve both the needs of the Information Management group as well as the users.
5. Responsible for data analysis and statistical analysis of internal and external databases as well as several existing reports.
6. Made recommendations and implementing solutions for increasing accuracy and completeness, expanding application, and enabling access to users.
7. Created and delivered verbal and written presentations to others as needed.

Experience

10+ Years

Level

Senior

Education

Bachelor Of Science

Description :

1. Lead analyst in a TransNow multiyear project with Portland State University to evaluate the automatic vehicle location/bus dispatch system (AVL/BDS) employing GPS technology.
2. Performed data entry, verification, and analysis of manual survey data for Phase I of the study and integrated archived automatic passenger counter (APC) data into this data set.
3. Automated Bus Dispatching, Operations Control, and Service Reliability: Baseline Analysis.
4. Collected and verified data sets for Phase II and III of the study by post-processing archived BDS schedule matched data residing in both IBM DB2 and Unix Oracle relational tables using SAS (Statistical Analysis Software), SQL, MS Access, Excel, and ESRI ArcView mapping software as my primary analysis tools.
5. Designed and built a time-point level database as a transit patronage model that relates passenger activity to service reliability and other determinants of transit demand.
6. Provided support to the client with assessing how many virtual user licenses would be needed for performance testing.
7. Processed and conceptualized data, generated ad-hoc reports used for problem-solving and stakeholder presentations.

Experience

2-5 Years

Level

Executive

Education

ITE Database Management Software & ITD SQL

Description :

1. Team managed to collect and parsing data feeds from 34 partners.
2. Processed includes ETL data pick up, reconciliation with external partners, and load transactions to the data warehouse.
3. Involved ETL, SQL, data modeling, business process design, and team management Lead Analyst on assignment to Washington Mutual Bank Managed teams of 7 to 10 analysts in deploying XP at Washington Mutual Bank.
4. Initiated and supported the upgrade of over 6000 bug tracking databases that were being migrated from Raid to Product Studio.
5. Streamlined data integration processes resulting in a reduction of the time required to support new data sets from an average of 2-3 days to less than 5 hours.
6. Supported business users in a prod environment for any Data/Application issues.
7. Worked with the Business and Technology team to transform business requirements into technical solutions.

Experience

5-7 Years

Level

Executive

Education

GED

Description :

1. Performed data analytics on claims and membership data and the associated business processes.
2. Conducted analysis of business and user needs for information, features, reports, and functions in order to develop requirements for data analytics and reporting for operating units and corporate functions.
3. Collaborated with the team in Data Analytics and Data Warehousing, to understand the organization's systems and capabilities to ensure the most efficient use of data assets.
4. Elicited requirements using interviews, data analytics, business process descriptions, and a workflow analysis.
5. Assisted in the creation of deliverables that are developed jointly with the user and technical Guidewire development team, including output definition, logical design (business process and rules, data elements and flows, screens, and reports), implementation plan, documentation, and training needs.
6. Advised and counseled users on data use, definitions, assets' capabilities, and information management processes.
7. Developed detaileded Data Mapping document for generating Workers Compensation compliance reporting through Policy Center.

Experience

5-7 Years

Level

Executive

Education

M.S In Accounting

Description :

1. Scheduled monthly meetings Work with functional and technical users to analyze and document business rules, data requirements and data models Utilize technical tools such as Excel, Access, SQL, etc.
2. Utilized technical tools to identify patterns and data trends.
3. Exercised data quality control by performing data auditing and validation.
4. Imported and exported large data sets from multiple systems Resolve issues and discrepancies in a timely manner Participate in project teams and meets to provide updates, process changes, and review systemic issues.
5. Prepared, generated, and published routine and ad hoc reports/metrics.
6. Served as a mentor to newly hired staff Coordinate and perform routine Information Specialist meetings for training, updates, changes, date reviews, and data cleaning.
7. Collaborated with technical experts and business units to determine the best possible reporting mechanisms.

Experience

5-7 Years

Level

Executive

Education

Bachelors Of Business Administration