RAUL PINTO
*** * **** ******, *********, WI *****; Contact: +1-312-***-****; *********@*****.***; https://www.linkedin.com/in/raulnpinto Summary
Possess data management experience in the field of Marketing, Finance, and CRM. Display good analytical and logical skills dealing with qualitative and quantitative data.
Education
Masters in Information Technology and Management GPA: 4.0/4.0 May 2017 (Expected) Illinois Institute of Technology Chicago
Bachelors in Computer Engineering GPA: 3.53/4.0 May 2008 – May 2012 University of Mumbai India.
Work Experience
Fraud Data Analyst at Fidelity National Information Services Inc., U.S.A. Current Environment: ebtEDGE (Fraud tool), DbVisualizer, Anaconda (Python distribution), JIRA Explore patterns and relationships in data to identify fraudulent transactions and entities using data analysis and statistical methods. Determine quantitative methods for resolving client issues. Research Assistant at Illinois Institute of Technology, U.S.A. September 2016 –December 2016 Use SAS for pre-processing large datasets and setting up statistical models to gain valuable insights into ‘Prosper Marketplace, Inc.’ peer-to-peer loan lending system
Trade Promotion Analyst Intern at Tyson Foods Inc., U.S.A. June 2016 – August 2016 Environment: Accenture CAS (Trade Promotion Management tool), SQL Server, SAP BusinessObjects Facilitate account planning activities of retail trade spend and its integration with downstream financial and sales applications
Built insightful reports based on KPIs to make strategic decisions on consumer purchases towards promotions
Resolve data issues, debug stored procedures, collaborate with cross-functional teams ETL Developer and Support at Quinnox Inc. June 2012 – July 2015 Client: Waste Management U.S.A.
Environment: Informatica PowerCenter (ETL tool), Oracle 11g, Control-M Scheduler 6.4, BMC Remedy Involved in all phases of ETL development, data integration, support, and maintenance activity
Translate business requirements into technical specifications after detailed analysis
Perform backtracking, root cause analysis and resolution fixes
Query tuning to eliminate bottlenecks and optimize performance of long running processes
Develop ETL mappings and workflows, write Unix shell scripts to monitor and archive files
Exposure to OLAP tool - Hyperion Essbase to build multidimensional cubes for reporting purpose
Analyze data warehouse design, implement star schema and slowly changing dimensional data models, and maintain system integration
Brainstorm sessions with stakeholder to implement design for new applications, discuss potential improvements
Perform data scrubbing; handle Ad-hoc requests and database outages
Identify application issues and manage change requests, automate ETL jobs to meet SLA deadline Big Data & Hadoop Certification in progress
Technical Skills
Management tool: Informatica, Oracle, MySQL, SQL Server, MS Office Suite (Excel [pivot table, lookup, Macro, functions], PowerPoint, Visio, Word, Access), BMC Remedy, JIRA Programming language: SQL, Java, Unix Shell Scripting Statistical & BI tool – SAS, R, Python, SPSS, Tableau, SAP BusinessObjects
Experienced in different phases of software development life cycle (SDLC) using Agile Scrum methodology
Sound knowledge of Project Management, Statistics, Predictive Modeling, Big Data, Data Mining, Data Warehousing, and Object Oriented Programming(OOPS) methodologies