Daniel Paes's Email Addresses & Phone Numbers

📖 Summary

With good management skills, professional of Business Intelligence with interest in the area of ETL, with solid knowledge of SQL in ORACLE platform and Informatica applications. ITIL Foundation and OCAJP Certified with English and French Proeficiency. Specialties: ETL Modeling, ETL Extraction, OLAP Development.Développeur ETL @ Development and maintenance and load control on datawarehouse processes using Kimball and Datavault methodologies at Informatica PowerCenter, development of shell-scripts on AIX for non databases processes, and familiar with project control on Sharepoint and Lotus notes tools. From November 2014 to Present (1 year 1 month) Freelancer BI Consultant @ Acting as a Senior BI analyst, using as development tool Pentaho suite (Kettle, Saiku, Mondrian, CDF and Java custom programs), at PostgreSQL environment. Analysing transactional database, data modeling using kimball approach, and development of datawarehouses from the bottom. On the OLAP phase, interviews with final client, for define indicators and metrics. From January 2014 to November 2014 (11 months) Technical Architect @ Administration of Informatica Power Center 8.6 at UNIX environment, whereas I am responsable for workflow tunning, and give development support at data integration and DW/Staging processes, using as data Oracle, SQL Server databases and flat-files, with and without header and trailers. Besides taking SOA administration as well. From January 2013 to January 2014 (1 year 1 month) Informatica Administrator @ Administration of Informatica Power Center 8.6 at UNIX environment, whereas I was responsable for workflow tunning, and give development support at data integration and DW/Staging processes, using as data Oracle, SQL Server databases and flat-files, with and without header and traillers From September 2012 to December 2012 (4 months) ETL Developer @ Development, maintenance, Administration and load control on data flows at Data stage 8.1; Pair development with technical team, and, business team; Change control using Lotus Notes; Development of Shell-Scripts. From September 2011 to August 2012 (1 year) ETL Developer @ Development of extraction flows at Informatica 8.5 Worked in UNIX environment and creations of shell scripts Formulate technical specifications directly to client Communicate with other project members to gather requirements Interacting with internal groups and clients to assess business needs and requirements Providing mentoring to technical team From January 2011 to September 2011 (9 months) Senior Etl Developer @ Development of extraction flows at Informatica 8.5 Worked in UNIX environment and creations of shell scripts Formulate technical specifications directly to client Communicate with other project members to gather requirements Interacting with internal groups and clients to assess business needs and requirements Providing training and mentoring to technical team Managed a small team of developers (3 peoples) Coordinate and management of deadlines and milestones From September 2010 to December 2010 (4 months) Midterm ETL Developer @ Development of extraction flows at Informatica 8.5 Worked in UNIX environment and creations of shell scripts Formulate technical specifications directly to client Communicate with other project members to gather requirements Interacting with internal groups and clients to assess business needs and requirements Providing mentoring to technical team From January 2010 to September 2010 (9 months) Junior BI Analyst @ Universe design and report creation Providing training and mentoring to clients and technical team Assess a customer’s business problem and recommend appropriate solutions Showing the value of BO solutions and Informatica to customer Handling any technical questions/issues From November 2008 to December 2009 (1 year 2 months) Intern @ Development of extraction flows at Informatica 7.1 for data extraction using Teradata Loaders and Oracle database, worked in UNIX environment and creations of shell scripts, communicate with other project members to gather requirements From May 2008 to September 2008 (5 months) Intern @ Worked directly to the client in english, making COBOL procedures and some power center extractions under supervision of mainframe routines Working with split-site teams to rapidly resolve application issues From May 2007 to May 2008 (1 year 1 month) Intern @ Development of extraction flows at Ascential Datastage Formulate under supervision technical specifications Communicate with other project members to gather requirements From January 2006 to July 2006 (7 months) Intern @ Teaching in classes of Office (Word, Excel, Power Point, Access), Visual Basic 6.0, and WEB Applications (Dreamweaver, Fireworks, Flash) for mentoring and outside students. From March 2005 to November 2005 (9 months) Bachelor's degree, Information Technology @ Universidade Estácio de Sá From 2005 to 2008 Daniel Paes is skilled in: ETL, Oracle, Informatica, Business Intelligence, Data Integration, SQL, Data Modeling, Unix, Requirements Analysis, Datastage, Data Warehousing, Business Objects, Teradata, MicroStrategy, Business Objects Data Integrator, CSS Javascript, Java, Object Oriented Design, Data Vault