Senior Data Analyst Resume Samples

Description :

1. Database Analysis Created advanced relational database Visual Basic and MS Access formulas such as; Joins, Unions, and ODBC.
2. Maintained, reviewed, imported, exported, cleaned, and created sales and financial relational databases Developed data requirements to support business finance needs with I/T to defined changes.
3. Utilized several financial reporting tools to analyze data and present reports and recommendations including; Brio, Essbase, MS Excel, Hyperion Essbase, and Impromptu Built financial relational database by identifying sources of information, assembling, verifying, and backing up finance and sales data.
4. Data Mining Uncovered patterns in data samples through the use of representative and non-representative samples indicative of the domain and of the whole population by verifying and validating patterns of other samples of financial and sales data.
5. Identified trends within financial data through the use of sophisticated algorithms, to identify key attributes of processes and target opportunities.
6. Extracted hidden patterns of financial data used in a wide range of profiling practices, such as marketing, surveillance, fraud detection and scientific discovery.
7. Performed Data Clustering to automatically discover the segments or groups within a customer data set.
8. Database Design Developed and managed dashboard metrics for the company to improve management decision-making and performance.

Experience

10+ Years

Level

Senior

Education

MBA In Marketing

Description :

1. Maintaining and monitoring processed records for reference of historical and real time Bathymetric Nautical Planning Charts (BNPC), utilizing NAVOCEANO software and tools.
   
2. Work with programmers on testing new beta-type software, tools and variables while maintaining quality assurance of the database production.
3. Merge depth layers into real data that were created using mathematical formulas to give a number value within a specific error percentile for support of war fighters and other functions.
4. Build and subset various databases using Graphical User Interface (GUI) and command scripts for ingest and extraction of sensitive bathymetric and hydrographic data.
5. Examine, evaluate and compare datasets for quality and precision.
6. Ingest, integrate and merge cartographic, hydrographic, geospatial and bathymetric data before inclusion into a gridded database to create seamless digital interface of the seafloor.
7. Coordinate and execute special supplemental database deliveries to customers, agencies and other scientific communities.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Managed and coordinated BI and reporting and process redesign initiatives to support financial, lending, accounting and remarketing services.
2. Elicited, analyzed and validated requirements to identify BI redesign initiatives and demonstrated how technology solutions supported the redesigned business process flow.
3. Operated as change champion through education, leading change, and influencing positive outcomes.
4. Focal point of contact for addressing the reporting needs for Call Centers' executive management.
5. Provided regular, transparent project status updates.
6. Led data integration and migration efforts of merging business applications and data repositories between MarketWise and JM Family Enterprises Identified and documented opportunities for new technology solutions to support reengineered business processes through interactive JAD sessions; provided recommendations for technology selection.
7. Created new reporting solutions, introduced dashboard presentation technology merging business process rules with workforce management reporting, improving call center workflow efficiency.
8. Planned and successfully managed multiple application and reporting upgrade migration projects increasing billing and collection department efficiency by 39% over a 14 month period.

Experience

10+ Years

Level

Senior

Education

Bachelor Of Arts

Description :

1. Identified data discrepancies in key business reports that were leading to incorrect reporting of crucial financial data.
2. Worked with engineers to fix data tables and queries to eliminate discrepancies.
3. Introduced new and formal technical requirements and QA documents to define formal processes for quality assurance, business task initiation, and completion.
4. Held full responsibility for the research, troubleshooting, and utilization of the Omniture web analytics tool and its tracking and reporting functions to ensure all business reporting data elements were accurate.
5. Managed Business Objects user account administration and maintenance.
6. Performed quality assurance testing, created test cases and test plans for data warehouse projects and QA testing.
   
7. Demonstrated understanding of data requirements and the StubHub organization to document requirements for data warehouse projects including a key marketing project to gauge marketing channel performance.

Experience

5-7 Years

Level

Executive

Education

B.Sc. In Marketing

Description :

1. Responsible for the day-to-day analytical operations generating close reports with the Navy and civilian personnel, capturing scope effects safely, in a timely manner with successful accomplishment under contract requirements.
2. Act as the liaison representative between government, military, and civilian contracted personnel.
3. Analyze, collect, record, interpret, and maintain data related to MSC vessel types, force protection, and various special missions and programs.
4. Conduct daily tasks to provide advice and coordinate the execution of special projects related to data collection and analysis, ensuring the completeness and consistency of data.
5. Prepare briefings or support documents related to the specific issue, researching the issue to identify errors and/or omissions, and the proposal of recommendations.
6. Perform data analysis including; data collection in gathering, maintaining, and providing monthly and cumulative tracking of all ship-related data.
7. Conduct analyses and investigations of raw data collected by applying analytical methods from mathematics, science, and engineering to elaborate, advice and provide insight into probable effects of alternative solutions to problems.

Experience

5-7 Years

Level

Executive

Education

Bachelor In Information

Description :

1. Fostered the utilization of SQL and Excel in managing all data transformation, mappings, and migrations for multiple clients.
2. Secured additional information from numerous linked servers connected to SQL and Oracles tables using queries.
3. Prepared and presented SQL Server Reporting Services (SSRS)/Hyperion reports, which detailed risk characteristics and location.
4. Coordinated with the Information Technology department with regard to documented business designs and unit test plans in compliance with Sarbanes-Oxley (SOX).
5. Administered the National Council on Compensation Insurance (NCCI) regulatory and compliance reporting.
6. Made substantial contribution in preparing and presenting reports and analysis, predictive modeling and other data mining results using SSIS, Excel and Access applications.
7. Reliably aided the Underwriting, Actuarial, and Finance and Claims departments with innovative business intelligence and statistical analysis.
8. Defined a large list of related variables using mining techniques including principle components and classification of large datasets to develop business judgment using SQL Server Integration Services (SSIS) and Excel charts/pivot tables.

Experience

5-7 Years

Level

Executive

Education

Bachelor Of Science

Description :

1. Established the creation of metrics, reporting and repeatable processes that provided the basis for robust long-term performance monitoring, cost modeling and trend management of Neustar's Operational Infrastructure and Service Quality.
2. Identified and validated data sources and educated employees throughout the company on how to leverage the information to assist making decisions and understand service health and capacity.
3. Led the design and development of analytical projects to understand key business behaviors that drive customer satisfaction, goodwill, and engagement.
4. Managed the collection, analysis and communication of insights to enable the business to make informed decisions, forecast implications of initiatives undertaken and monitor changes introduced to enhance client experience.
5. Performed Operational Cost analysis to improve operational efficiency and in turn driving revenue growth.
6. Provided monthly reporting to senior leadership on key performance indicators (KPI) and SLA statistics.
7. Provided actionable audience specific recommendations.
8. Worked cross functionally as part of larger project teams to deliver against corporate scorecard initiatives.

Experience

7-10 Years

Level

Management

Education

M.S In Electrical Engineering

Description :

1. Responsible for the design and implementation of a Business Intelligence solution for the entire company, including a data warehouse, automated reports and user interface for ad hoc reports and analytics.
2. Responsible for the data analysis and business analysis to enable the creation, enhancement, and maintenance of the data warehouse.
3. Complex troubleshooting and extensive interviewing of the business users and subject matter experts.
4. Responsible for health care informatics, including calculation of claims lag triangle, incurred but not realized (IBNR) amounts, utilization rates, disease management rates, and risk adjustment factors.
5. Responsible for the management of numerous managed health care compliance reports and data files, both incoming and outgoing.
6. Responsible for the creation and maintenance of business (functional) specifications and technical specifications as well as the creation and maintenance of metadata available to technical personnel and business users.
7. Supervision of two data analysts/reporting analysts.
8. Create and deliver presentations to various audiences as needed.

Experience

7-10 Years

Level

Management

Education

Bachelor Of Science

Description :

1. Responsible for high quality cost variance leadership reporting, Subject Matter Expert for all sales representative hierarchical and channel data, adhoc reporting, enterprise wide product sales reporting.
2. Improved data gathering process, for all AT&T sales representative, to enhance reporting accuracy.
3. Eliminated none essential manual data collection processes, Standardized data entry procedures, automated data collection and storage.
4. Results: Enhanced AT&T Leadership and Channel sales report accuracy, as measured by contrast to actual sales reporting, by 35%.
5. Designed Cost Variance Reports for leadership reporting Developed and Managed comprehensive sales records for leadership sales reporting.
6. Data Warehousing and ad hoc reporting utilizing: as SQL, Microsoft Access, Teradata, Excel, Java (Netbeans IDE).
7. Designed and implemented Consumer Sales reporting tool for service initiatives and employee compensation.
8. Assisted technical operators and Business Analyst to resolve problems in running computer program.

Experience

2-5 Years

Level

Executive

Education

Computer Engineering

Description :

1. Successfully interact with clients to develop business needs assessment and project plan documentation.
2. Work with clients to supply pre-sale and post-sale analytics reporting to determine return on investment of the claims extend product.
3. Teamed with internal IT department and product development to enhance the claims extend product based on customer feedback.
4. Defined with client the specific claims data elements to be transferred to McKesson to be processed in the claims extend product.
5. Managed the ongoing data transfer for clients focusing on accuracy and data integrity as well as working with the clients to determine customized data elements that would be necessary for reporting.
6. Developed client based presentations that reflected return on investment, overall savings, and areas of additional savings opportunities.
7. Coordinated client meeting revolving around data transfer and final analytics report output.
8. Developed and wrote business needs and requirements documents for customized reports.

Experience

2-5 Years

Level

Executive

Education

Bachelor In English

Description :

1. Established and maintained client relationships to create trust and professionalism for approximately 30 clients annually.
2. Created data charts and analyses for special projects according to client's specific needs and requests Spearheaded and managed project for designing, maintaining and updating company proprietary software to eliminate antiquated software and keep up with current company needs.
3. Prepared OFCCP Audit documents and gathered supporting documentation from clients and their outsourced recruiting vendors.
4. Analyzed client workforce and annual personnel activity data to prepare AAP's in accordance to current regulations.
5. Determined and assigned census category codes to client job titles to compute external availabilities for protected classes in AAPs.
6. Collaborated with Project Manager and Data Processors on discrepancies, client policies and procedures and data errors.
7. Provided leadership and direction to keep updated datasets for use in calculation of availability.

Experience

10+ Years

Level

Senior

Education

Chemical Engineering

Description :

1. Increased physician's compensation, streamlined workflows and develops complex financial and business data reports and systems.
2. Demonstrate commitment and leadership through quality-based assessments, strategic implementations, and proven ability to manage multiple projects without supervision.
3. Serve as designated lead during billing migration projects to add specialty business units into inhouse applications.
4. Assist management with new hire training and mentoring of clinical professionals (and office staff) on billing procedures and business applications.
5. Monitors charge index system, performs reviews, collects internal/external data for analysis, synchronization, reconciliation, and financial reporting - enhancing performance growth and Revenue Cycle Operations.
6. Supplemental functions include practice management and A/R Follow-up.
7. Establish and administer workflow policies for tracking and reporting missed charge opportunities with physicians and other stakeholders.

Experience

10+ Years

Level

Senior

Education

Business Administration

Description :

1. Ensured complete, accurate and timely data was reported from Luke AFB that included 4 aircraft types and 138 total aircraft valued at $3.5 billion.
2. Developed policy and procedures and advised and interpreted directives for 13 data analysts.
3. Supervised 13 database managers and data analysts who compiled daily, weekly, monthly and annual reports and ad hoc data mining for executive leadership.
4. Compiled and validated data from six different aircraft units.
5. Provided KPIs, analyzed metrics and generated reports that were used at the highest levels of executive management to make decisions for all units.
6. Created Access database and Excel macros that improved data sharing across multiple DB locations.
7. Determined new staffing requirements of 700 personnel/9.6K equipment for unit reorganization Assessed end-user requirements and communicated customer's technical needs to development team.
8. Effectively served as a communications interface between the two parties.

Experience

2-5 Years

Level

Executive

Education

Business Administration

Description :

1. Oversaw tuning and performance monitoring for UNIX/Linux workstations, servers, and peripherals.
2. Worked on AWS technologies such as, Redshift.
3. Developed OLTP system by designing Logical and eventually Physical Data Model from the Conceptual Data Model and used Erwin tool to develop a Conceptual Model based on business requirements analysis.
4. Determined the best approach for designing data structures that support easy data consumption, trends identification, and ability to highlight exceptions through reporting and dashboard tools.
5. Involved in architecting the data integration, created the data model for the data warehouse, advised the client on the importance of data governance to consistently maintain the data quality Owned and managed all changes to the data models.
6. Created data models, solution designs and data architecture documentation for complex information systems.
7. Implemented and documented systems for high-volume production environment.

Experience

5-7 Years

Level

Executive

Education

MBA In Finance

Description :

1. Deliver actionable insights improving CPC ROAS, website usage, organic search rankings, ecommerce revenue targets, and user experience.
2. Design data gathering structure aggregating all relevant metrics and sources providing comprehensive insights and reporting.
3. Create, educate, and distribute dynamic dashboards in Google Analytics and Tableau for executives' real-time evaluation.
4. Improve customer acquisition through landing page optimizations, and affiliate link building.
5. Support suppliers by tracking and reporting product specific web analytics driven from Rite Aid web properties, applications, and mobile websites.
6. Create and manage product data feeds for a 25,000 + product catalog containing multiple product attributes destined for multiple CSE platforms, such as EBay, Criteo, Google Shopping, and others.
7. Utilize HTML and business knowledge, to optimize product data feeds for higher search rankings, ROAS, cost-per-click, and click through rate.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Arts

Description :

1. Performed statistical analysis of health care data using SAS which were utilized for incentive bonuses, clients' goal setting and performance appraisal.
2. Created ad hoc reports and charts to support management decisions in technology expansion.
3. Testing Led testing of usability, functionality and data integrity of the client-server system's user interface.
4. Developed checklists or standard templates for GUI testing to answer basic questions across all windows within the application.
5. Developed systems documentation such as design specifications, user manuals, technical manuals, and description of application operations which was used by developers and technical staff.
6. Technical Support Provided software/hardware support to end-users and recommended upgrades, improvements, and integration strategies.
7. Trainer Trained new hires and users on existing or new application systems/software.

Experience

2-5 Years

Level

Junior

Education

Information Systems

Description :

1. Deliver actionable insights improving usage, organic search rankings, ecommerce revenue targets, and customer satisfaction.
2. Design data gathering structure aggregating all relevant metrics and sources so comprehensive insights and reporting are provided.
3. Establish, educate, and distribute dynamic dashboards for executives' real-time evaluation.
4. Perform independent analysis to inform various presentations and business decisions.
5. Improve acquisition, landing page optimizations, and link building for 1,000,000 visit athrough conversion and retention campaigns.
6. Support suppliers in tracking and reporting web analytics driven from Rite Aid web properties, applications, and mobile websites.
7. Create and manage product data feeds for a 25,000 + product catalog, containing multiple product attributes and destined for multiple CSE platforms, such as EBay, Criteo, Google Shopping, and others.

Experience

2-5 Years

Level

Executive

Education

Bachelor Of Arts

Description :

1. Responsible for pagination processes within the Billing and Reporting Team's processing tasks.
2. Reports to the Reporting Manager and provides additional data in streamlining and automating tasks/tools for day-to-day duties.
3. Prioritize team workloads to meet strict deadlines within pagination processing within our old and new workflow application.
4. Ensure that all invoicing gets paginated in a timely manner to bill to all clients and work together with Billing and Sales as needed.
5. Processes and uploads data into SAP and rectify any issues or errors with reported data and/or calculations.
6. Resolve Billing or client discrepancies as applicable.
7. Ensure best practice controls are implements around the Reporting process while preparing and reviewing process documentation is up-to-date.
8. Work closely with team members to create and improve implementation processes.

Experience

7-10 Years

Level

Consultant

Education

Masters Of Science

Description :

1. Reviewed accuracy of data, monitor performance of system users, provided system users instructions.
2. Identified problems, deficiencies and provided assistance in resolving database and report deficiencies.
3. Conducted training and inspect system users on installation how to use computer software/equipment.
4. Coordinated work plans for maintaining database activity through uploading and downloading of files for over 20,000 personnel with a rating of 95%.
5. Assisted task force member with developing and administering a comprehensive training program covering basic and technical job skill.
6. Managed the system mobilization and interfacing of an entire military personnel division using the Tactical Army Combat Computer System (TACCS).
7. Possess excellent customer service skills to provide technical instructions and guidance on data maintenance procedures.

Experience

7-10 Years

Level

Management

Education

Certificate In Education