Andrew Smith


(000) 000-0000


287 Custer Street, Hopewell, PA 00000

Professional Summary

Seasoned investment professional offering 20+ years of expertise in the areas of investment strategy and asset allocation.  Success managing billions of dollars across multiple portfolios while leading efforts in reforming investment strategies.  Senior leader adroit in providing executives and Board of Directors with evidence and reports that influence and inform the vital decision-making process.
Financial Analyst equipped with the tools and knowledge needed to advance into senior-level roles within innovative, growth-driven companies.  Expert at developing and tracking budget expenses and strong ability to analyze and organize large data sets.  Deep technical knowledge with proficient use of QuickBooks and Excel programs.
Recent graduate outfitted with a Bachelor of Science in Accounting and 2 years of internship experience as a Jr. Accountant.  In-depth knowledge and use of accounting software to include Intuit, Zoho Books, FreshBooks, and Xero.  Extreme attention to detail and ability to multitask within fast-paced environments.
Customer-oriented licensed Massage Therapist specializing in deep tissue, Swedish, sports massage, hot stone therapy, and reflexology.  Equipped with personal massage table, oils, linens, and music, dedicated to providing high-levels of service at every encounter.  Willing to work as a contractor or full-time therapist within a hotel spa.
Talented, progressive, licensed Stylist with over 20 years of experience working in high-end salons within Beverly Hills.  Expert in women’s cuts, color, and style including up do’s, highlights, and treatments.  Additional experience providing beauty consultations, makeovers, and wardrobe styling.
Dedicated senior-level executive offering over 5 years of consistent career progression in the areas of operations and warehouse management for a multi-million-dollar, global enterprise.  Expert in ensuring operational efficiency, workflow management, process development, production performance, and low-cost solutions.  Strong ability to lead cross-functional teams and collaborate with business leaders as well as build and cultivate strategic relationships with internal and external stakeholders and business partners.
15-year tenured leadership, education, and evaluation professional adept at helping organizations optimize their performance through professional and organizational development.  Strong ability to acquire and retain high-levels of talent through creating and implement training, coaching, and mentoring programs.  Visionary executive equipped with an entrepreneurial mindset and in-depth knowledge of business operations and development on a global level.

Employment history

Aug. 2018 – Jan. 2019
Lissastad, Texas
database analyst, Bradtke, Beer and Hermann

  • Encrypt data transmissions and erect firewalls to conceal confidential information as it is being transmitted and to keep out tainted digital transfers.
  • Develop plans to safeguard computer files against accidental or unauthorized modification, destruction, or disclosure and to meet emergency data processing needs.
  • Review violations of computer security procedures and discuss procedures with violators to ensure violations are not repeated.
  • Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.
  • Design database applications, such as interfaces, data transfer mechanisms, global temporary tables, data partitions, and function-based indexes to enable efficient access of the generic database structure.

Jan. 2017 – Jun. 2017
Volkmanstad, Wyoming
Maths, DuBuque-Yundt

  • Adapt teaching methods and instructional materials to meet students’ varying needs, abilities, and interests.
  • Maintain accurate and complete student records as required by laws or administrative policies.
  • Assign and grade class work and homework.
  • Prepare and administer written, oral, and performance tests, and issue grades in accordance with performance.
  • Establish clear objectives for all lessons, units, and projects and communicate those objectives to students.
  • Instruct students individually and in groups, using various teaching methods such as lectures, discussions, and demonstrations.
  • Observe students to determine qualifications, limitations, abilities, interests, and other individual characteristics.
  • Prepare objectives and outlines for courses of study, following curriculum guidelines or requirements of states and schools.
  • Register, orient, and assess new students according to standards and procedures.

Dec. 2013 – Jan. 2014
Strosinfurt, Alabama
Data analyst, Ernser-Turner

  • Manage project execution to ensure adherence to budget, schedule, and scope.
  • Develop or update project plans for information technology projects including information such as project objectives, technologies, systems, information specifications, schedules, funding, and staffing.
  • Monitor or track project milestones and deliverables.
  • Confer with project personnel to identify and resolve problems.
  • Develop and manage work breakdown structure (WBS) of information technology projects.
  • Submit project deliverables, ensuring adherence to quality standards.
  • Prepare project status reports by collecting, analyzing, and summarizing information and trends.
  • Assign duties, responsibilities, and spans of authority to project personnel.
  • Establish and execute a project communication plan.
  • Negotiate with project stakeholders or suppliers to obtain resources or materials.
  • Identify need for initial or supplemental project resources.


Aug. 2008
MBA: Business

  • South Flatley – South Angelenaborough, Colorado

Jan. 2004
Business & Information Technology: Information Technology

  • East Rath University – Chongchester, Vermont




Data analyst

Team work

Project Management

database analyst

  • Participated in meetings impacting databases physical design.
  • Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
  • Provided appropriate access to client except system databases owners’ and Client will have access to their respective needed application schema owners.
  • Developed & maintained scripts, utility jobs or implement needed software for database maintenance.
  • Implemented & managed database clustering, failover and load balance technologies as per client requirement.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Conducted root cause and analysis for database incidents and problems.

database analyst

  • Prepare data for marketing events and perform campaigning.
  • Work with external data suppliers regarding data accuracy and integrity.
  • Collecting and Analyze information on novel business opportunities– finding ways of trapping information.
  • Identification of current growing sector in country through secondary research study and as inline to that analyzing the companies from target geographical region of world on the basis oftheir business segment and market value, sectors, products and services.
  • Daily basis report submission of targeted potential companies/ partners with information like revenue, business type, global existence etc. which are further being contacted by sales teamAssisting marketing managers to conduct research in US, UK, Germany, Canada region which includes name identification, Talent mapping, SWOT analysis.
  • Company Profiling/ Data Profiling.

senior database analyst

  • Disaster Recovery methodologies and high availability techniques and implementations.
  • Up gradation of Database from SQL Server 2000 to 2005 and 2008R2.
  • Performed database/infrastructure physical design, database upgrades & applied software patches to databases as per application/client requirements.
  • Setting up SQL Server Security.
  • Performed acceptance testing to verify that database changes perform without adverse consequences.
  • Estimated disk storage requirements for database software, database files & database administration needs.
  • Provided optimal database file layout for utilization of storage and performance acceptable to client.

database analyst

  • Maintain database; ensure the security, quality, and integrity of data resources; performs related work.
  • Manage the firm’s database with responsibility for planning and managing data collection, data cleaning, and statistical analysis,
  • Involve in establishes security standards, and procedures for controlling and monitoring user access and for establishing and maintaining user passwords, roles, and profiles.
  • Interfaces with applications development, distributed systems, operations, and operating systems personnel and users to maintain control of the configuration of the database structure, establish database access techniques, address database performance issues and resolve database problems.
  • Analyzes business processes, procedures, and problems to develop database and data solutions to meet business needs.

database analyst

  • Confirms project requirements by studying user requirements; conferring with others on project.
  • Facilitated portfolio performance review and implemented new strategies.
  • Evaluated portfolio performance and risk exposure to ensure client success.
  • Communicated market developments, portfolio changes and annual performance to end clients.
  • Provided strategy advice to high net worth clients.
  • Clients Handled: MARS , Kraft Heinz & Riviana Foods.

database analyst

  • writing complex queries which are fetching analytical and report data from larger no.of tables.
  • setup replication to make high availability of the database, to handle in 
  • Provides database development support to the product developers
  • Technical assistance and support to database modeling of product modules and different projects
  • Database migration from MySQL environment to the AWS Aurora MySQL compatible environment for different projects
  • Worked on database administration tasks such as database installation, upgrade the database, daily backups, migration of databases, purging of data by retention period, tuning the server configuring parameters, query tuning, limiting the user privileges.
  • Develop and test new database scripts to deploy for every month’s production release