Cristiane Silva

Focus on developer AWS EMR workflows and jobs using pyspark and python. Designer solutions, modeller databases, developer Jobs, and workflows using Cloud Bigdata S3 and redshift. Also using tableau for dashboards and customer care references. I have worked with preparation data to load in entities to the model for datalakes and consolidate databases in a master database daily. - Data modelling: snowflake - Gather data from services to AWS EMR: data stored in S3 - Data Visuliazation in Tableau

Focus on developer BI process in ETL Tools with cloud AWS glue using pyspark and python. Designer solutions, modeller databases, developer Jobs, and workflows using Cloud Bigdata S3 and redshift sources. Also using Athena, SAS and tableau for financial reports and customer care. I have worked with preparation data to load in redshift and entities to the model for datalakes. - Data modelling: star schema (fact and dimension tables) - Data Migration (SQL Server -> AWS redshift) - Gather data from services to AWS redshift: data stored in S3 Mission: Create Integration data from Salesforce to S3 and create a model BI and Data lake to attend the dashboards in Tableau.

I have worked with many projects such as time log system. And I do POC (prof of concept) and applications for small clients (Timesheets Controls, Financials systems)Using PL/SQL, PowerBI, SSIS, SAS, SQL Server and REST PrimeFaces consuming API and reports. I participated in many meetings with the user and stakeholders in order to collect information about what their needed.Designer solutions, modeling, developer coding and validation, reconciliation of metadata and error handling in ETL processes.Reports mobile.Business or sector Commerce

Client Bank - Sicoob. Migration all DWH - DB2 from CDC to Datastage jobs and Informatica Workflows. Developer shell scripts, Java Script Programs and tunning all Querys. Update 30 Datamarts at six months, used new architecture of the process and the loads gain performance from 3 days to 30min. Start of the process Big Data and Learning Machine with DBM informatica. Datastage Developing, Diagnostic and analytics BI Netezza, DB2, SQLSERVER, Cognos Complete projects of Banks Modeling Data Base, ETL, DataQuality, Designer, Support performance analysis, tuning and QA.

Developer Powercenter Informatica, Powerexchange project "IBM Cúram Social Program Management Platform” , developer and modeling with Erwin DWH, Database Oracle, Db2. Designer solutions, integrations, mappings, complex workflows and scripts. Development of software components using Java Platform. Rest API design and implementation using Swagger and Spring Boot/Spring MVC MQUEE. OAuth 2 implementation. Integration with legacy systems written in Cobol.

Developer / ETL-PowerCenter / Oracle Atos Origin Brasil  Client: Claro Telecom At this company we were building software for a great mobile company in Brazil, I worked on many projects. I did software to sell services by SMS, to control customer's life cycle, to port in and port out customers, to improve some legacy systems, etc... Here I started working as a developer . I used a mix of new and old technologies like, Java 1.4, Java 1.5, Spring, Hibernate 3, EJB 2.1, Struts 1.1 and 1.2, JSP, Servlets, Tiles, Shell Script, Stored Procedures on Oracle 8i and 9i - Advance PL/SQL and information Powercenter( Design and pipelines), AWK,, WebLogic Web Services. I also introduced some guide lines to test the softwares like: white box tests, black box tests , unit tests, integration tests, acceptance tests and I also introduced some testing frameworks like Junit, DBUnit and Selenium. I also use as a Agile Coach, helping my team and the company to apply agile philosophy, in one year we achieved aggressive targets and have increased the team size in 500%. We were using a mix of Scrum + XP. integration mappings algorithmics, Integrations and Visualizations online. Mission: Developed and deployed same solutions interactions using Powercenter Informatica Oracle and Java environment Unix, HP-UX projects like the Project Nine Digit, Integrations BOD, B2B, Legacy Databases, manipulation to Mastersaf catalog.

Independent, São Paulo (Brazil) Oracle 10g database management, Sql Server 2005. Maintenance routines, RMAN, performance analysis, RAC, tuning and Dataware House bank creation with OWB and ISSI modeling tools. I worked in some Clients e.g. Pernod, Jhonson’s Cottons, Habib’s and Support for Storages and Oracle licenses.

PowerCenter 8.x Developing, PowerCenter Designer, Workflow Manager, Workflow Monitor tools. Write and debug mappings for data warehousing, development skills, PowerCenter Data Analyzer, Profiling, Metadata Manager and Powercenter Administration management. Mission : Client CPFL Company of Energy in Campinas SP I worked in a Migration of Data from SAP - DB2 to Powercenter - Oracle.

Oracle 9i, developing systems to extract reports, tuning of process and date extraction for billing, DatawareHouse, Data Administrator and development using Asp.net. Also, I used Shell script, and Unix HP-UX environment for called process to Control-M.

Administrator Data Base and Developing systems to Brazilian governament (Codeplan) using Oracle 9i and Informix and consolidation of dates of schools of Distrito Federal and Goias. I worked to same projects as Bolsa Familia, Bolsa Escola - Caixa Economica Federal, Banco Regional de Brasilia, DFTRANS, Renda Minha, SIGE (Management Scholl), 156, Telematricula. Using Congnos, Business Objects and QlikView.