Data Analyst Sql Server
Resume:
PETER TARAVIRAS
**** **** ******, ******* **, ***02, U.S.A.
**********@*******.***
SUMMARY
Business Intelligence developer, Data Analyst with more than 10 years of experience in Business, Data Analysis, ETL, Reporting Tools (MSSRS, Crystal Reports, Jet Reports)
Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Validation and Master Data Management SSIS, SSAS, SSRS.
Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities
Software Development Life Cycle (SDLC) experience including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle
Provide desktop profiles, user training, and other special projects as required by Analysing performance, enhancing effectiveness and efficiency of the department to achieve the results within the set parameters
Experience in writing complex SQL Queries to extract data from various data sources.
Experience in understanding and creating Stored Procedures, Stored Functions, Database Triggers, and Packages using T-SQL, PL/SQL.
Expertise in Data Warehousing concepts including Metadata and Data Marts
Experience in conducting Joint Application Development (JAD) sessions with end-users, Subject Matter Experts (SME’s), Development and QA teams.
Interviewing Subject Matter Experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people.
TECHNICAL SKILLS:
Querying Microsoft SQL Server 2012 certification, Business Intelligence Development and maintenance certification, SSIS, SSAS, SSRS ETL, PL/SQL, T-SQL, Tableau, ORACLE, Mat lab, SQL Server 2000/2012, DTS, Integration Services 2005-2007, IFS Financial, IFS Enterprise Asset, IFS CRM, IFS maintenance/distribution; VB.NET, Crystal Reports, IFS Report Builder, MS Office (Excel, Word, PowerPoint, Outlook), Rational Rose, Mat lab.
Implementing Data Warehouse 70-463 certification in progress
SKILLS & ACTIVITIES:
Strong organizational skills. Ability to work well under pressure. Self-motivated and able to work on my own initiative. Proactive and can work flexibly as part of a team.
LANGUAGES:
English Fluent (mother tongue, Canadian citizenship)
Greek Fluent (mother tongue, Greek citizenship)
French Good
HAKS Engineers and Architects, NY, NY 2016 -
BUSINESS and DATA ANALYST, REPORT DESIGNER
Business Intelligence Developer, Data Analysis, Data configuration
Designing and building specialized reports, Performance Indicators for the Financial, Billing, Marketing departments
Technology: Deltek, SQL Server 2012, SSRS 2012
SHELDONS, Antigo, WI 2015 - 2016
REPORT ANALYST DESIGNER
Data Analysis, Data configuration
Designing and building specialized reports and Data Visualizations for Mepps and Mister-Twister Company.
Creating Dashboards, Data Visualizations, Key Performance Indicators and reports for the Financial, Sales and Inventory departments
Technology: Microsoft Dynamics NAV 2014, SQL Server 2014, SSRS 2014, Tableau.
ESRD, Edmonton, Alberta 2014 -2015
Business Intelligence Consultant
Data warehouse Analyst / Developer
Data Analyst/Query Designer
ETL, writing queries, stored procedures, functions
Working for a Data Warehouse Project for the Alberta Environmental and Sustainable Resource Development Ministry.
Technology : SQL Server 2008 R2, SQL Server 2012, SSIS,TFS
BC NDP, Vancouver B.C. 2013 – 2013
Data Analyst, CRM Administrator - Contract
Data Analyst/Query Designer
ETL, BI, wrote queries, stored procedures, functions, data cleansing, Data Mart maintenance, creating insights with implementation of custom statistical algorithms to optimize the donation groups to solicit for donations.
Creating reports and insights for the financial and account department in order to have a benchmark of the amount they could use from each campaign the fundraising team was executing.
Assigned to Fundraising Department with responsibility for direct mail, organizing, creating the mailing lists, making the contacts with external partners. Complied with my deadlines and reported directly to the Fundraising Director and the General Secretary.
Ministry of Foreign Affairs, Athens, Greece 2009 – 2012
Consultant, Data Analyst
Work for Department for Coordination and Implementation of Financial and Investment Projects
Business Intelligence developer, Data Analyst, Query design, data cleansing, Data Mart maintenance, creating reports for the financial and the human resources department using SSIS, SSAS, SSRS, in SQL 2008 server.
Implemented technical aid, supporting actions and the management of respective resources
Focused on improving the effectiveness of the services provided both to Greek citizens and business abroad. Aim to benefit from opportunities arising within the National Strategic Reference Framework, the National Development Program and from other Financing instruments.
Developed procedures for a more effective, responding to the new demands of the global environment, through updating mechanisms at operating and organization level and implementing new technologies.
Evaluated proposals from businesses and handling procurements.
Impact Information Systems (IIS), Athens, Greece 2008 – 2009
Data Analyst / Software Developer
IIS provides electronic document exchange between business partners, while providing the ability for every organization regardless of size, to cooperate efficiently with all their partners.
Business Intelligence developer, SSIS, SSAS, SSRS, ETL,
Provided software SQL development
Data Analysts/Queries, build functions, stored procedures
Level II Support for the i@connect service, a web business solution that provides electronic document exchange between business partners
Providing solutions and support to major industries and retailers in order to have a sufficient exchange of documents such as invoices, dispatches and orders
Provided customer assistance in order to produce statistic reports for their sales.
Worked in a small team of two, reporting to the Director of department.
Informer – Business S.A., Athens, Greece 2004 – 2008
Data Analyst - Consultant
Software Developer, Data Analysts/Queries, creating functions, stored procedures, ETL in Oracle
Provided software development for the IFS ERP to cope with the Greek legislation for the client’s needs.
Involved in the upgrade of “Pako” industry, from IFS 2001 edition to IFS 2007 migrating and transforming data for the needs of the new data bases schema data from the previous edition and building reports. Built new reports also trained the personnel for the new features of the product.
Assisted with the implementation of “Astir” industry (IFS 2003), migrating data and customizing the software for the customers’ needs. Worked at the implementation team of the production and maintenance module. Astir is a company that produces and supplies crown corks to Europe, Africa and Middle East. Also built reports with the IFS reporting tools and Crystal reports too.
Participated in the implementation of “Impereco” trading company (IFS 2003), migrating data, consulting in warehouse management, customizing the software for the customers’ needs, building reports.
Member of team on implementation of “Emporiki Elastikon S.A.” trading company (IFS 2003), migrating data, consulting in warehouse management and customizing the software for the customers’ needs, building reports.
Tutor at High School and Technical University 1995 – 2004
Subjects: Applied Mathematics, Analysis, Algebra, Statistics, Probabilities, Business Research, Statistics Control and Credibility, Risk Analysis
Virtus AELDE (Stock Exchange Services) 1998 – 1999
Technical Analyst
Develop trading models, market tendencies and stop loss techniques.
Consulting role in investment strategies.
Certifications
Microsoft SQL Server 2008, Business Intelligence Development and maintenance
Querying Microsoft SQL Server 2012
Implementing Data Warehouse 70-463 certification in progress
EDUCATION / TRAINING:
MSc Finance 2012
University of Strathclyde, Glasgow, Scotland
BSc Mathematics
National University of Athens (Kapodostriako) - School of Mathematics 1996 - 2006
Specialization: Applied Mathematics and Statistics
Contact this candidate