ISMEL RODRIGUEZ

Miami, Florida

305-***-****

adkino@r.postjobfree.com

Professional Summary

I am an energetic and passionate Data Warehouse Developer and professional with determined leadership qualities and proven abilities to analyze business processes and standards.

Able to play a key role in analyzing problems and come up with creative solutions.

Well organized and detail oriented with a strong focus on competitive intelligence, strategic planning and market research and analysis procedures.

A quick learner who can absorb new ideas and can communicate clearly and effectively.

Now looking for a new opportunity in an ambitious company. A company where young professionals have the possibility to flourish and be part of the future technology leaders of this community.

Technical Skills

Operating Systems: Microsoft Windows, UNIX, MS-DOS

ETL Tools: Informatica Power, SQL Services integration services SSIS, Tibco Clarity

Databases tools: SQL Developer, MySQL, Toad for Oracle, MS SQL Server 2012/2016.

Data Modeling tools: ER/Studio

Languages: T-SQL, PL/SQL Shell scripts, R Statistical Programming

Scheduling Tools: Op Com Manager.

SQL Server Reporting Services SSRS

SQL analysis services SSAS

Microsoft Power Bi

Microsoft Share Point

Microsoft Office Suite.

SPSS

ServiceNow

Education

Miami Dade College, Miami, Florida

Bachelor of Science in Data Analytics

Miami Dade College, Miami, Florida

A.A Associated in Arts – Information Technology

Miami Dade College, Miami, Florida

Business Intelligence Professional certified

Recent Professional Experience

Carnival Corporation LLC

Data Warehouse Analyst/Developer, June 2018 to June 2020

Responsible for the maintenance of the Operational Data Store (ODS), Enterprise Data Warehouse (EDW), associated Data Marts, CRM/Guest Loyalty application, Oracle, SQL, and Informatica integrations.

Working closely with the Business analysts in acquiring and developing technical requirements and will deliver the expected results. Design, develop, and document complex code integrating warehouse and transactional business applications using current knowledge of enterprise application technologies and development techniques.

Design, develop, and test dimensional data model extensions using Star & Snowflake schema methodologies under the Kimball and Inmon methodologies.

Lead troubleshooting and debugging of software integration and performance problems.

Conduct performance analysis and suggest potential solutions for highly complex integrations and reporting needs.

Partner with the Business Intelligence teams in defining the end state reporting goals and/or dashboard requirements. Design and develop data-based solutions that meet either a 'publish or 'subscribe' data requirement.

Construct and maintain the necessary support Run-Book, scheduling, and ER\Studio data model documentation and artifacts in accordance with Carnival’s System Development Methodology (SDM).

Assist in developing and then meet agreed-upon deadlines and perform other project duties as assigned.

Communicate technical and non-technical information clearly, concisely, and effectively both orally and in writing. Present findings, recommendations, and specifications in formal reports and/or oral presentations.

Strong Data Warehousing ETL experience of using Informatica 10.1 Power Center Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.

Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modeling using ER-Studio.

Expertise in working with relational databases such as Oracle 11g, SQL Server 2016.

Experience in developing Stored Procedures, Views and Triggers, Complex SQL queries using SQL Server 2012/2016 (T-SQL) and SQL Developer - Oracle PL/SQL.

Experience in writing UNIX shell scripts for the automation of the ETL processes.

Proficient in the Integration of various data sources with multiple relational databases like Oracle11g, MS SQL Server, DB2, VSAM files and Flat Files into the staging area, ODS, Data Warehouse and Data Mart.

Experience in using Automation Scheduling tools such as Op Con Manager.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.

Excellent interpersonal and communication skills, and is experienced in working with Directors, Managers, Business analysts and developers across multiple disciplines.

Used various transformations like Lookup (connected and unconnected), Router, Filter, Expression transformation, Sequence Generator, Aggregator, Normalizer, Update Strategy, Joiner, Stored Procedure, and Union to develop mappings in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.

Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.

Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.

Modified existing mappings for enhancements of new business requirements.

Used Debugger to test the mappings and fixed the bugs.

Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.

Involved in Performance tuning at source, target, mappings, sessions, and system levels.

Prepared migration document to move the mappings from development to testing and then to production repositories.

Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.

Wrote SQL Queries, Views, Triggers, and Store Procedures involving multiple tables with joins.

Utilized Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper level management.

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

Designed complex data intensive reports in Power BI utilizing various graph features such as gauge, funnel, line better business analysis

Optimized report performance with caches and snapshots.

Proactively resolve issues to drive quality and system performance improvements across the application

Participate in cross-team information sharing resources and work to identify risks early in the development process

Implemented TFS for project version control and change management with bug tracking.

Rapid Form LLC

ETL Developer, July 2017 To Sept 2018

Performed data extraction, transformation and loading (ETL) between systems using Oracle, and Informatica Power Center.

Wrote SQL Queries involving multiple tables with joins.

Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.

Parsed high-level design specification to simple ETL coding and mapping standards.

Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Proficiency in developing Stored Procedures, Views and Triggers, Complex SQL queries using MS SQL 2016 and SQL Developer - Oracle.

Proficiency in writing UNIX shell scripts for the automation for ETL processes.

Proficiency using Tibco clarity to extract, transform, and load data from multiple data sources.

Conduct performance analysis and suggest potential solutions to improve execution time for process.

Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.

Used different transformations such as Lookup, Router, Filter, Expression transformation, Sequence Generator, Aggregator, Normalizer, Update Strategy, Joiner, and Union to develop mappings in the Informatica Designer.

Developed mapping parameters and variables to support SQL override.

Maintained stored definitions, transformation rules and targets definitions using Informatica repository Manager.

Exceptional interpersonal and communication skills, and is experienced in working with Directors, Managers, Business analysts and developers.

Created DML, and DDL scripts.

Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.

Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.

Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Contact this candidate