My career has been focused on helping drive value from the mountains of data collected by organizations. Until recently, data and analytics have been the driver of competitive advantage in industry. In the last years, Generative AI Models have expanded the ability for humans to convert data, into actionable intelligence.
14 years of progressive experience in Generative AI, Data Warehousing, Business Intelligence, and Data Integration initiatives
Full life cycle implementation of new and existing Data Warehouses utilizing both Waterfall and Agile methodologies
Data Warehouse Modeling, primarily in Ralph Kimball and Bill Inmon methodologies with Erwin Data Modeler
Extensive knowledge in implementation, development, and administrative duties on a wide range of Informatica Products such as Power Center, B2B, Metadata Manager, Power Exchange, and Informatica Data Quality
Designed and Deployed Informatica B2B with high availability for mission critical ACH and Fed Wire File processing
Installation, configuration, and maintenance of Hyperion 11.1.2 and Power Exchange for Essbase
Great working knowledge of SQL, PL/SQL, Oracle, SQL Server and many other data related technologies
Experience with various reporting platforms such as Cognos, SSRS Hyperion, Crystal Reports, Business Objects
Design and development of hundreds of Tidal Scheduler jobs for efficient management of ETL loads
Development of numerous korn, bash, and batch scripts for automation and validation of loads
Implemented encryption of sensitive customer data with consideration to performance degregation of loads
Expertise in System Architecture, Trouble Shooting, Performance Enhancement and Design
Self directed with a reputation for taking on challenges and consistently delivering high quality results
Proven ability to rapily learn new technologies and leverage them to deliver results
Excellent track record of working on multiple teams across distributed geographies
Led tech efforts pursing a strategic shift towards building an AI-first company
Designed and deployed an LLM enabled AI interview chatbot which increased hire ratio by 230%
Launched a comprehensive HR AI marketplace, offering a wide array of tools for clients
Generated numerous POCs to showcase new tech's viability and support strategic decisions
Engaged investors, highlighting technology roadmap and progress in order to pursue funding
Supported sales calls with technical insights, boosting client engagement and conversion
Mentored the tech team, promoting a culture of growth and development
Managed security incidents, strengthening defenses against sophisticated phishing attacks
Performed cost analysis and budgeting, ensuring project financial efficiency
Devised strategies to disrupt an industry with entrenched incumbents, aiming for a competitive advantage
Environment- AWS, MYSQL, LARAVEL, PYTHON, Open AI, API, LANGCHAIN
Informatica Cloud installation and administration
Informatica MDM installation and configuration
Rundeck Job Scheduler installation and administration
Development of code for integrating Salesforce.com with existing legacy systems and new POS
Worked with various teams to plan and execute a strategy for moving business critical systems to the cloud utilizing a variety of vendors/technologies: Informatica Cloud, AWS, Motion Soft, SFDC, TeraData Cloud
Helped design and deploy an Informatica Master Data Management solution for customer data
Coordinated to fully automate critical B2B file transfers with external vendors such as JP Morgan
Maintained and enhanced a fully automated Corporate Membership platform
Helped design, and deploy a commissions payment system handling over 2m in payments biweekly
Worked to implement various business systems including ADP, Ultipro, and Enwisen
Architected and implemented Informatica upgrade from version 8.6 to 9.1
Evaluated and implemented recommendations for Tidal and Dataflux upgrade paths
Decommissioned DTS server by converting over 20 integrations to Informatica workflows
Developed a Cash Reconciliation system that dramatically simplified this laborious process
Worked with various teams/vendors on a variety of business intelligence solutions
Provide off hours assistance to teams during critical and close out periods
Environment- Informatica 8.6/9.1/9.6,10, SQL Server 2000/2005/2008/2012/2020, Windows Server 2008 R2, SAP Business Objects, DataFlux, AWS, Redshift, Informatica Cloud
Troubleshooting and issue resolution of an IBM SPSS deployment
Worked to optimize queries to improve performance of jobs taking too long
Analyzed and recommended database fixes for data load schedule management
Environment- Informatica 8.6/9.1/9.6, SQL Server 2000/2005/2008/2012, Windows Server 2008 R2, SAP Business Objects, DataFlux
Technical lead for loading a new data source (Mortgage Servicing Package) to the Data Warehouse
Architected and developed an ACH Payment Processing System with full redundancy on the Informatica B2B suite of products which saves the bank in excess of $650k annually
nstalled, Administered, and created documentation for the maintenance of Informatica PowercCenter 9.1,
Utilized Informatica Data Transformation to create and implement parsers, mappers and serializers for the conversion of ACH files to XML and reverse
Created Informatica Data Exchange sub-routines for updated the DX server with file status notifications
Created over 150 Tidal Scheduler jobs to coordinate Informatica Workflows, Shell Scripts, PL/SQL stored procedures, FTP and other file handling mechanisms to implement the Informatica ACH system.
Review of all development to be released to production via technical review meetings
Coordinate with the Production and Change Management groups to implement code drops
Monitored new code to ensure proper functionality and sustainable performance during UAT stage
Played a critical role in troubleshooting and resolution of issues in the Production Environment
Worked directly with Informatica Tech Support to identify bugs in the software and produce fixes
Participated in ING Direct’s Data Warehouse critical review to identify performance opportunities
Presented project to the IT department and executives at monthly meeting
Participated in all stages of Data Warehousing (Modeling, DEV, QA, Deployment and Maintenance)
Designed and developed numerous mappings, sessions, and workflows for implementing various types of ETL processes such as data cleansing, transformation, extraction, migration and loading of the data warehouse fact, dimension, and reference tables
Worked in Waterfall and Agile (SCRUM) methodologies of Software Development to consistently deliver high quality, low defect code for satisfying business requirements
Recognized multiple times at Quarterly Department meetings for efforts and accomplishments
Developed scripts and procedures for executing, maintaining, and fine tuning the ETL process
Worked with Business Intelligence on data quality initiatives, using SQL to track down ETL bugs and other causes of data corruption and worked on data patches for improving the quality of data in the DWH
Worked with business to refine requirements in order to ensure proper business needs were being met
Developed a new methodology for Delta loading of the Customer Dimension from multiple sources, reducing daily load by several hours
Designed, evaluated, and implemented Encryption of Sensitive Customer Data in the DWH
Researched, evaluated, and implemented Deployment groups for Code Migration saving the company $50k+ annually
SME and lead for the implementation of Informatica Metadata Manager, metadata repository for the bank
Evaluated and implemented Informatica Version Control and wrote the best practices guide for developers
Participated in evaluation, testing, and support for upgrading from Informatica 8.1 to 8.6
Played the role of de facto Informatica Administrator by patching and upgrading repositories (Hotfix), creating backups, maintaining user accounts and performing other Administrator duties
Liaison between Informatica Support and developers for opening and following up on Service Requests
Researched and designed an approach to synchronize and maintain DEV and QA environments
Created parallel loading repository on PROD for performance testing of new Oracle 10g features in cooperation with DBAs
Worked with DBAs to performance tune ETL jobs, reduced month end load by 14 hrs via dropping / recreating indexes and other tweaks
Designed (reusable) approach and scripts for recovering from Replication failure in our sources
Trained fellow developers in Informatica advanced features such as Metadata Manager, Deployment Groups, and other topics
Installation and maintenance of Hyperion 11.1.2.1 and Informatica PowerExchange for Essbase
Environment- Informatica 6.2/8.1/8.6/9.01/9.1 AE, MS SSIS 2005/2008, Oracle 9i/10G/11G, SQL Server 2000/2005/2008, MS Access 2007, IBM AIX 64 bit, Cognos8, Quality Center 9.2, Version One, VSS 6.0, Toad 9.7, Oracle EPM (Hyperion) 11.1.2.1, Linux, VMware
Created reports for the Business Intelligence group using PL/SQL & Cognos (FDIC coverage, Data Date)
Participated in Modeling efforts for bringing new sources systems into the Data warehouse (Tealeaf)
Lead the Intern Website effort and produced a website for the 2007 ING Direct Interns
Created numerous Ad-Hoc reports for business users using SQL and Excel
Pl/SQL for calculating insured/uninsured amounts for FDIC taking into consideration joint ownership
Reviewed and updated Policies and Procedures of Database Systems group on Company’s Intranet
Participated in community events such as Habitat for Humanity
Development of a Software Architecture Metrics tool (SARA tool)
Researched different software metrics for Software Product Line Architecture analysis
Modeled 3 Software Product lines with Star UML, open source modeling tool
Used data mining techniques to analyze and build support for a thesis
Developed multiple websites to support the research and give access to the public (http://www.csee.wvu.edu/swarch/public_html/SARATool/)
Researched and ordered required Hardware and Software such as servers and workstations
Administration of research lab network and systems
Created custom reports on Student ID usage from the University database using SQL and Crystal Reports
Wrote a number of complex ad-hoc SQL queries for analysis of student activities such as peak hours of PRT (Personal Rapid Transit system) usage
Participated in the design and implementation of backup strategies
Researched and evaluated new hardware and software purchases
Troubleshooting and maintenance of many different types of hardware, as well as network and operating system errors
Implemented biometric, hand geometry identification systems throughout the University
Day to day activities of registering new students and issuing new Student IDs
Designed graphical template for new WVU student ID
Since 2002 I have been actively consulting friends’ and family businesses on their IT solutions
Designed and implemented an 8 system network (server/client architecture) for a family dentistry practice (Shahla Azadi DDS, Morgantown WV)
Developed a website and web marketing strategy for Shahla Azadi DDS.
Designed and implemented office network for Dr. Farzaneh Hassani, MD
Miscellaneous Farsi to English Translation work
Provided web design, and graphic design work for Zeytoon Inc., restaurant management company
Developed and maintained website for Mercury Tapas Bar, Morgantown WV
Built numerous PCs from components, and set up 20+ home/office networks
Working with influencers and content creators on utilizing and understanding the new data landscape
Lead and operate a 150+ person theme camp at Burning Man
Master of Science in Computer Science
Emphasis in Software Architecture and Data Mining
Thesis Title: “A Methodology for Risk Assessment of Product Line Architectures
Bachelor of Science in Computer Science
Minor History
· Informatica Developer Level II · Informatica Administrator Level I
· Informatica Metadata Manager · Informatica Data Quality I
· Data Validator · Passport for MSP by LPS
LLMs
Diffusion Models
AWS
Redshift
LINUX
Informatica
Python
SQL, PL/SQL
SSIS, DTS
Windows, UNIX
Stable Diffusion
Machine Learning
GNU, BASH
WEKA (Data Mining)
Web Development
Problem Solving
Data Analysis
Self-Motivation
Creativity
Business Knowledge
Critical Thinking
Collaboration
Communication
Technical Ability
SQL, PL/SQL
Informatica 6, 8, 9, 10
Python
SSIS, DTS
Windows, UNIX
C, C++
GNU, BASH
WEKA (Data Mining)
Web Development
Administration
Business Systems
Predictive Analytics
Email Marketing
Customer Retention
Master's Thesis, WVU
"A methodology for risk assessment of product line architectures." (2008). Graduate Theses, Dissertations, and Problem Reports. 11086.
Children's Book, Iran
First translation of Frankenstein to Farsi (2001) ISBN 964-5722-33-0