Farzad Khansanami

Worked on all phases of data warehouse development lifecycle, from gathering
requirements to testing, implementation and support
• Monitor all scheduled jobs as daily basis and troubleshoot any failed jobs before dead
time
• Expertise with all ODI tools - Topology, Security Manager, Designer and Operator
including ODI 12c install and configuration
• Strong Knowledge in Data Warehouse architecture and Data Warehousing concepts
like Star Schema, Snowflake Schema, Data Marts, Dimension and Fact tables
• Used Spark Scala to perform analytics on data in Impala
• Developed Scala scripts, UDF’s using both Data frames/SQL and RDD/MapReduce in
Spark for Data Aggregation, queries and writing data back into DB through Sqoop
• Developed churn data prediction and reported to marketing manager as monthly basis
• Implement Unsupervised learning to catogerized Customer based on their usage

Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation and support
Monitor all scheduled jobs as daily basis and troubleshoot any failed jobs before dead time
Expertise with all ODI tools - Topology, Security Manager, Designer and Operator including ODI 12c install and configuration
Strong Knowledge in Data Warehouse architecture and Data Warehousing concepts like Star Schema, Snowflake Schema, Data Marts, Dimension and Fact tables
Used Spark Scala to perform analytics on data in Impala
Developed Scala scripts, UDF’s using both Data frames/SQL and RDD/MapReduce in Spark for Data Aggregation, queries and writing data back into DB through Sqoop
Developed churn data prediction and reported to marketing manager as monthly basis
Implement Unsupervised learning to categorize Customer based on their usage

Translate business requirements into specifications that will be used to drive data store/data warehouse/data mart design and configuration
Extraction, consolidation, analysis, and validation of data sets needed to support various QA and RA programs, which will require collecting data from different MtnIrancell vendors
Use ICare for handling Mtn Customers faults and issues
Hands-on experience with OBIEE Answers – Development using different Reporting Views, Set operators, Pivot reports
Create ETL to load data into Hive
Implement OBIEE 12c SSL configuration and Setup dynamic SQL authentication
Apache Nifi Implementation to load CDR and EDR Dumps to Hbase
Worked in a team and collaborated using Agile Scrum, daily stand-up meetings, Atlassian Products (Jira, Confluence)

Discussing with onsite team for field feedback of S-NOC product and getting it implemented in the system
Understand the issues and feedback from the onsite team
Setup and config Mongo DB to store Product information of subs
Validate the developed solution as per requirement document
Solving the queries and clarifications raised by the onsite team for launch in different line of business
Integration product categories on S-NOC DB from postgre DB
DB administration and data guard implementation of Mongo DB for related service network operation center
Creating 2 phases of SRS document and report to CEO

Creating star schema data models, performing ETLs and validating results with business representatives
Supporting Implemented BI solution by monitoring and tuning queries and data loads, addressing user questions concerning data integrity
Monitoring performance and communicating functional and technical issues
Turning data marts into a robust data warehouse Own, and build from the ground up, a data infrastructure, including end to end data flow and storage
Monitoring all ETL process and data warehouse services and find and fix issues related to any failed jobs using Linux command and shell scripting
Creating hourly, daily and monthly reports for MTN (telecom) subscribers (Finance, CR, RA) using Pl/Sql

Works closely with project manager to develop a work plan for projects and keep the manager aware of any issues
Develop framework, metrics and reporting to ensure progress can be measured, evaluated and continually improved
Determines data retention and archiving policies
Responsible for data services and data movement infrastructures
Support business decisions with ad hoc analysis as needed
Initiated a lot of fine-tuning mechanisms to tune the database as well as the queries to complete a set of given jobs or tasks in optimal time
Ability to work independently and collaboratively within a team