Lead Data Analyst Resume Samples

As a Lead Data Analyst, the professional undertakes the duty of managing all aspects of the reporting requirements and data management. The job description entails managing the data science team, planning projects, and to build analytics models. Other work activities are mentioned on the Lead Data Analyst Resume as – creating and managing the reporting specs process lifecycle, performing data mining to identify data-quality issues, root cause, and resolution based on data management; creating and maintaining scorecard and metrics dashboard reports, and providing new insights to improve the decision-making process.

Required qualifications are – a good understanding of data management practices, experience in Power BI/Tableau/BO micro strategy, the ability to work within a fast-paced environment, technical skills, and experience in creating and documenting scorecard lifecycle processes. Employers typically hire those having a degree in computer science or engineering or technology.

 

Lead Data Analyst Resume example

Lead Data Analyst Resume

Summary : A detail-oriented leader capable of ensuring his team meets mission critical deadlines. Highly experienced in diversified training and production environments. Knowledgeable of MS Office with an emphasis on data capture and presentation in Excel and Access. Experience in conducting research and analysis of complex contract requirements and vendor performance metrics.

Skills : SQL, SSRS, Microsoft Office, Crystal Reports, SSIS, Cognos.

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.
                      Years of Experience
                      Experience
                      7-10 Years
                      Experience Level
                      Level
                      Management
                      Education
                      Education
                      BS In General Studies


                      Lead Data Analyst Resume

                      Headline : SQL Developer/Data Analyst with 5+ years experience in SQL and SQL Server, BI Reporting Worked closely with business unit stakeholders to ensure alignment with enterprise business plans and strategic initiatives. Collaborated with business team, data warehouse members and leaders from other functional areas to produce efficient reporting solutions, maximize best practices and to ensure business alignment.

                      Skills : Sql Server, Excel, Reporting, Data Analysis, Project Management.

                      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.
                      Years of Experience
                      Experience
                      5-7 Years
                      Experience Level
                      Level
                      Executive
                      Education
                      Education
                      Graduate Certificate


                      Lead Data Analyst Resume

                      Summary : A graduate qualified Database Professional with over 15 years of experience across multiple industries including Banking, Healthcare, Financial Services, Legal Services, Manufacturing, and Sports Retail. Technical experience includes Database Development and Design, ETL, Data Analysis, Automation, Optimization, Reporting, Release and Deployment Strategies, Database Code Standardization, and Source Control Solutions in an Agile environment.

                      Skills : MS SQLServer, T-Sql, SSIS.

                      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.
                      Years of Experience
                      Experience
                      10+ Years
                      Experience Level
                      Level
                      Senior
                      Education
                      Education
                      Master Of Science In Management

                      Lead Data Analyst Resume

                      Summary : Lead Data Analyst with over 10 years experience in database management in the health care industry. Proactive individual adept at analyzing, developing and creating various functional databases. Proven ability in overseeing systems migration and development.

                      Skills : Data Analysis, Microsoft Office, MS SQL Server, Oracle, Electronic Spreadsheets.

                      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.
                      Years of Experience
                      Experience
                      10+ Years
                      Experience Level
                      Level
                      Senior
                      Education
                      Education
                      Masters Of Science In Electrical Engineering

                      Lead Data Analyst Resume

                      Summary : Data analysis and report development is an excellent combination of technical and personal activities to make the day interesting. My past experiences involved teaching computer languages, programming, managing a technical Help Desk, Database Management, and ETL.

                      Skills : Agile, Client Relations.

                      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.
                      Years of Experience
                      Experience
                      7-10 Years
                      Experience Level
                      Level
                      Management
                      Education
                      Education
                      Master Of Business Administration In Finance/Accounting

                      Lead Data Analyst Resume

                      Summary : Fourteen years of professional experience with data warehousing in a reporting and analytics environment - creating and maintaining data marts and semantic layers to fulfill the business' need for data and information in the healthcare, manufacturing, mortgage, and finance industries. Twelve years of professional experience designing comprehensive Business Intelligence systems with OLAP, reporting, and dash-boarding capabilities.

                      Skills : Excel, SSIS, SSAS, SSRS, Agile, Analytics, Business Analysis, Business Intelligence, Business Intelligence, BI, Data Analysis, Data Analysis, Database Management, Databases, SQL, Data Modeling, SQL Server, DAX.

                      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.
                      Years of Experience
                      Experience
                      10+ Years
                      Experience Level
                      Level
                      Senior
                      Education
                      Education
                      Bachelor Of Science

                      Lead Data Analyst Resume

                      Objective : A Lead Data Analyst with expertise in database analysis. I have documented problem-solving skills of a highly analytical and detailed nature utilizing mathematical concepts and general quantitative statistics. Adept with MS Excel (including pivot tables and charting) Access, database optimization, and SQL Processing & Programming.

                      Skills : SQL, Access, Excel, XML, Statistics, Mathematics, SAS, Programming, Analysis.

                      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.
                                    Years of Experience
                                    Experience
                                    2-5 Years
                                    Experience Level
                                    Level
                                    Executive
                                    Education
                                    Education
                                    ITE Database Management Software & ITD SQL

                                    Lead Data Analyst Resume

                                    Headline : Performing manual testing of straight hedging by squared out terminal market position with Physical market, against Futures and determining the differential to realize profit or loss Verify the data from premium functionality of futures contract profitability at the strike price, in-the-money or out-of-the-money Developed, implemented, and maintained of business solutions.

                                    Skills : SQL Server, Business Analysis.

                                    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.
                                                Years of Experience
                                                Experience
                                                5-7 Years
                                                Experience Level
                                                Level
                                                Executive
                                                Education
                                                Education
                                                GED

                                                Lead Data Analyst Resume

                                                Headline : Lead Data Analyst with around 5 years of IT experiences in Business Analysis, Requirements gathering, Data Analysis, and Testing of business applications. Results-oriented professional with experience in analyzing and gathering user requirements and converting them into system specifications.

                                                Skills : Microsoft Office, Excel, Word, Powerpoint, Data Analysis.

                                                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.
                                                Years of Experience
                                                Experience
                                                5-7 Years
                                                Experience Level
                                                Level
                                                Executive
                                                Education
                                                Education
                                                M.S In Accounting

                                                Lead Data Analyst Resume

                                                Headline : Developing data models and reporting to improve the speed and quality of the decision-making process across the logistics organization, and also working with partners to find opportunities for using company data to drive solutions.

                                                Skills : Accounting, SAP, Management, Financial Analysis.

                                                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.
                                                Years of Experience
                                                Experience
                                                5-7 Years
                                                Experience Level
                                                Level
                                                Executive
                                                Education
                                                Education
                                                Bachelors Of Business Administration