Nasim T. Farsani| M: 650.704.7290
Address: 2517 Howard Ave, San Carlos
Over 8 y...
Nasim T. Farsani| M: 650.704.7290
Address: 2517 Howard Ave, San Carlos
● Implemented replication a...
of 2

Nasim T Farsani Resume_g

Published on: Mar 3, 2016

Transcripts - Nasim T Farsani Resume_g

  • 1. Nasim T. Farsani| M: 650.704.7290 Address: 2517 Howard Ave, San Carlos EXPERIENCE SUMMARY Over 8 years of extensive IT experience in different industries as a software Developer and Database Developer. Over 3 Years hands-on experience in Data Warehousing, Database development and Business Intelligence development, with strong understanding of Data Warehouse and BI concepts including all phases of Development life cycle Technical Skills ETL: MS SSIS / Informatica, Data Transformation Services (DTS) RDBMS: Oracle 8i/9i, SQL Server 2008/2012/2014, PostgreSQL, ODBC, MS Access, Teradata, Toad, SQL Server Management Studio, Spotlight BI and Analytics: QlikView, Tableau, SQL Server Reporting Service, Analysis Services (SSAS), OLAP Cubes, Crystal Reports , SAS Languages: T-SQL, Oracle SQL, MDX / DMX, VB.Net, C, JAVA, QV Scripting, C#.Net,, HTML and CSS, XML, DML UML Modeling: Visual paradigm, Rational Rose, Enterprise Architecture, MS Query Analyzer Software: MS Office, Visual Studio .NET PROFESSIONAL EXPERIENCE Wells Fargo Mortgage Credit Risk, Oakland, CA (Apr 2015 – Present) Title: BI/ETL and Report Developer/Analyst (Database Analyst 4) ● Scripting Complex SQL Queries using SSMS and Teradata. ● Database development; Creating Tables, Views, user function, table indexing and etc. ● Integrating Legacy data system with new system. Remap the legacy data extraction and testing Large Data set, Data validation and cleansing. ● ETL development using MS SSIS and INFORMATICA ● Design OLAP data model (Star/snowflake schema) and implementation of Data Marts ● Design and develop MS SSAS Cubes ● Create Interactive Executive dashboards and reporting using SSRS and Tableau (SQL/MDX) Reply Inc., San Ramon, CA (Apr 2012 – Oct 2014) Title : BI/ETL, Report and Data warehouse Developer/Analyst (Software Developer) ● Designed and developed data warehouse from the scratch, included different OLAP Data Marts, ETL(SSIS), SSRS reports OLAP cube(SSAS) and OLTP DB in SQL Server 2008R2/2012/2014 and PostgreSQL. ● Gathered and organized all business requirements, created documentation and designed the system model ● Wrote complex SQL for stored procedures/extraction/load/data cleansing/reports/data integration/XML queries, table indexing, creating: views, user defined functions. ● Designed and implemented OLTP for store historical data and OLAP to make organization-wide data in DW.
  • 2. Nasim T. Farsani| M: 650.704.7290 Address: 2517 Howard Ave, San Carlos ● Implemented replication and data transform system to update data warehouse OLTP databases. ● Developed ETL system using SQL Server Integration Services (SSIS) and T-SQL job to integrate data from different type of sources like database, text file, flat file, CSV. ● Designed and developed dimensional data models (Star/Snowflake Schema) in SQL Server and QlikView. ● Developed MS OLAP cubes and defined data sources, data source views, dimensions, measures, hierarchies, ETC. ● Developed number of different interactive reports using SQL query and MDX queries in SSRS. ● Created many different SQL jobs, T-SQL Job, DTS Job. ● Wrote complex MDX/DMX queries for reporting system and software platform. ● Trained and support end users to learn MDX, cube, requirement spec. and BI concepts etc. ● Used spotlight in order to monitor databases for maintenance and troubleshooting DB server. ● Experienced in reverse engineering code with C#.Net and codes. Sana System Corporation, Mahshahr, Iran (Jun 2005 – Jun 2006) - (Dec 2008 – Sept 2011) Title: SQL/Report Developer/analyst (Sofware Developer) • Wrote different type of query for Oracle database and configured Oracle Client. • Designed, developed and supported software systems. • Created UML model for existed software and the entity systems by reverse engineering the codes. Nahadin Arman Inc. , Tehran, Iran (Aug 2006 – Nov 2008) Title: Report Developer/Data Analyst • Developed interactive software for the company with / MS Access • Visual Basic module programing for Excel • Developed reports with crystal report and created reporting system using Excel EDUCATION • Bachelor of Computer Software Engineering, Azad University, Mahshahr, Iran (2006). • Certificate of Oracle instruction for SQL. • Certificate of UML designing.

Related Documents