Ramin Dadashian MS

Phone: 510-***-**** City: Dublin, Ca

Email: ad3uc8@r.postjobfree.com LinkedIn: https://www.linkedin.com/in/ramin-dadashian-39b4523/

Professional Summary:

Senior data warehouse and integration IT professional with decades of diverse experience across multiple global industries and large to medium size enterprise projects. Excellent collaboration, technical, and managerial skills, allowing for effective working relation with various business and management groups with diverse geographical, cultural, and technical backgrounds.

Expertise in Data-Mart, Enterprise Data Warehouse/EDW, Business Intelligence/BI, modernization, near real-time ODS, and data integration project execution and implementation using SDLC and agile.

Experience in Finance, Global transportation/Logistics, healthcare insurance, professional service, and manufacturing industries with fortune 500 companies.

Expertise in enterprise solution, architect, and project management/lead role.

Experience in building, managing, motivating, and retaining talent.

Experience in implementation of software package and training using professional services.

Professional experience:

Wells Fargo

08/2011-05/2023

Data Warehouse Architect/Sr. System Engineer

Reduced customer support by providing self-service reporting to business by converting major metrics to Data-Mart using Kimball bus/pipeline star schema methodology/technology.

Established data replication strategy and solution across multi-server for the enterprise data warehouse.

Met regulatory tight deadline to upgrade 8 environments while meeting commitments of existing projects.

Promoted expansion of a standalone project to the enterprise data warehouse, delivering added business values, functionality, and cost reduction.

Delivered Data-Mart project(s) including ETL, Cube, and UI component by coordinating between various geographically dispersed teams.

Converted all the feeds/sources from PeopleSoft to WorkDay feeding Oracle/MsSql/SAS.

Converted 7 applications with 500+ batch jobs from IBM Platform Manager Scheduler to CA Autosys.

Release Management.

Proposed and implemented a seamless release and deployment coordination process that can be used for multiple simultaneous project tracks by various on-site and off-site team members.

Designed systematic and detailed project sizing, and tracking that has been used as the standard.

Revised improving team’s Technical Design Document (TDD) that has been adopted as the standard.

Increased efficiency by shifting business practice, processing, and reporting on a daily basis.

Increased quality of financial applications by shifting the creation of test cases to the development team.

Implemented industry best practice and architecture by reviewing and assessing all sub-systems.

Enforced standard and methodology.

Interview and screen candidates for developer and architecture positions.

Keane Consulting

04/2010-08/2011

Principal Consultant/Architect

In charge of conversion of Wells Fargo and Wachovia bank merger wholesale applications which was the largest conversion in history of exchange.

Support other client site consultants/team over coming project issues and proposing directions.

Plan for growth by forecasting volume and upgrading to grid computing and high availability.

Proposed purchase of software tools by writing business use cases and evaluating vendor products.

Created statement of work (SOW) and acceptance criteria for implementation of software packages and training by vendor’s professional services.

Performed application performance tuning, identify network latency, and propose change to data center network topology.

Delta Dental of California/TEKsystems

04/2007-03/2010

Lead Engineer/System Analyst III Consultant

Led the rewrite and modernization of all sub-systems by producing detailed design/walk-through.

Designed automated job flows using Tidal, MOVEit, and ETL.

Created system environment, physical, logical, and security assessment documentation.

Confirmed defects and validate fixes.

Increased quality and reduced cost by promoting and establishing Software Development Methodology.

Produced Capacity Planning, Environmental Plan, and security Audit documentation.

Mentor and lead for all analysts/Build release coordinator.

American President Line Logistic

05/2001-12/2006

Project leader and Data Warehouse Engineer

Created a new reporting platform by loading all sub-systems to a new enterprise data warehouse (EDW) using Kimball bus/pipeline star schema methodology/technology. Performing all aspects of project lifecycle from design, architect, development, implementation, and support. Also managed full project lifecycle through collaboration and utilization of offshore resources.

Converted 300 slow MQ data feed to near-real-time operation data store (ODS) by using changed data capture (CDC), reducing data delivery delay and backlog by 500% while increasing timeliness and data availability to Data Warehouse and user community. Kept the project on track and on time by keeping four decision making departments/stakeholders informed.

Increased data availability and turnaround by 50% by performing enhancement, Oracle/SQL, and Informatica tuning and optimization.

Produced complete detailed analysis and documentation for external software company which accelerated completion of project, saving cost for the company.

Produced Logical, Physical, and Metadata Data Models for new Data Warehouse projects.

Provided Brio (Hyperion) support and administration for a worldwide user community.

System Analyst and liaison for a new application with 300 databases.

Maintained and supported tracking system processing EDI transactions.

Visa International

06/1996-04/2001

Project leader/Senior Software Developer

Managed a team of four employees and two contractors where the majority of the teams were new to their assigned area (including me) supporting 21 applications. Consolidated production support and pager rotation by cross training the team. Managed Y2K projects using few team members from a consulting firm in addition to my own team. Established and maintained a project plan for each team member and their projects. Conducted annual performance reviews and established an effective incentive program. Implementation and support of a new Visa Cash pilot project, Visa reward, and various sub-systems.

Technical Skills:

Application Development Tools:

ETL/Informatica Power Center, Informatica Metadata Manager, SQL*Plus PL/SQL, Microsoft SSIS, Business Object Data Integration, CA Autosys, IBM Platform manager, Brio/Hyperion, Tidal, MOVEit, Stylus, Erwin, SELECT SE, ER Studio, C++, Visio, MS Projects, Shell script, PL1, CaliberRM.

Databases:

Oracle, Microsoft, NoSql, and DB2.

Hardware:

SUN Solaris, IBM AIX, and FUJITSU M780

Operating Systems:

Unix, Linux, Solaris, Windows, OS/390

Testing Tools:

Test Director, WinRunner, Smart Test

Other:

JIRA, Confluence, ServicNow, Scrum/Agile, Visual Studio, NDM, IBM Rational (ClearCase, ClearQuest), HP Quality, Pitney Bowes

Education/Training:

M.S., Computer Science, Dimensional Modeling in Depth, Kimball University, Planning and Project Management of a Data Warehouse, Project Management, TOGAF, Agile, Tableau, OOAD, UML, Python, Google Associate Cloud Engineer(ACE), and Apache Spark, Snowflake, Power BI.

Contact this candidate