The job is essential a consultant job, in here I took care of a couple of projects for different clients. The projects consists of a couple BI solutions that consists of implementing a complete BI Solution, using the Microsoft BI solutions(SSIS,SSMS,SSRS,SSAS), from the ETL stage, creating the Data Warehouse architecture, creating the dimensions and facts tables according to the client needs in order to the creation of the SSRS Reports, OLAP Cubes and Power BI reports.
The job also have a big part that consists of interacting to the clients by Skype, Mail or at the client headquarters. In this regard I was involved with multiple cultures like European, American, Asian and Latin America.
Technical environment: Jasper report, PostGreSQL database, BIRT, SpagoBI server. Project: For financial and IT departments, develop several reports (costs and revenues, taxes, duties) Technical environment: C# and telerik Bi tool reporting design, SharePoint 2010, database SQL Server 2012 • Create connection to data source; • Update views in database model; • Create parameters; • Create buttons for view reports application; • Publish reports in SharePoint in intranet; • Export reports in PowerPoint and create Presentation.
Maintain and develop BIsolutions in accordance with defined objectives; - importing data from external files and inserting them into the DW (SQL) - implementing DW architecture using ETL (SSIS packages) - create SSAS Cubes; - create reports, Dashboards, KPI (SSRS); - deployment (SharePoint, Report Manager). The main tools I used were: SQL SERVER 2008, SQL SERVER 2010, SSIS,SSAS, SSRS, SSMS, T SQL, SharePoint, ReportManager, Postgres Database, Jasper iReport, BIRT, SpagoBI; I worked at Romanian Bank for Develpment ( BRD ), in the BI department. Responsibilities: -deliver reports from Data Warehouse using SAS language; -maintain the Data Warehouse by updating the tables' structures and ETL processes; -analyse Business and Technical Specifications and develop small and medium projects; -code testing; -write Technical Specifications
The main SAS tools I used were: SAS/base language ( data steps + proc steps ), SAS/SQL, SAS/Macros. OS Environment : AIX SAS Programming training and exercises: • Creating SAS Data Sets; • Data Step Programming (Creating variables, Drop\Keep variables, Controlling Input and Output, Processing Data Iteratively); • Combining SAS Data Sets (Concatenating SAS Data Sets, Merging SAS Data Sets); • Producing List Reports and Summary Reports (Print Procedure, Report Procedure, HTML Reports);
Main responsibilities: • SAP reports; • Accounting for suppliers; • VAT-returns; • Monthly statements • Reconciliation of accounts; • Various reports and statistics; • Registration of creditors and debtors company operations, banking operations and other current operations.
ETL, Data Warehouse, Business Intelligence
Oracle, Microsoft SQL Server, PostGreSQL
My education and trainings
Master BDSA, IT - Bucharest Academy of Economic Studies2010 - 2012
CSIE, IT - Bucharest Academy of Economic Studies2007 - 2009
You need this profile next month?Contact us!
You’re about to be redirected to SkillValue
As Pentalog’s Talent Sourcing branch, SkillValue relies on a pool of 400,000+ Tech & Marketing Specialists – including 15,000+ Freelancers, a comprehensive catalog of IT assessments, available projects and job opportunities. Our SkillValue consultants are always ready and willing to help you boost your career.
Stay in the know with Pentalog tech & business updates
WHAT WE'RE ABOUT
Pentalog is a digital services platform dedicated to helping companies access world-class software engineering and product talent. With a global workforce spanning more than 16 locations, our staffing solutions and digital services power client success.