Ali Pirayandeh Email & Phone Number

Austin, Tx, Us

Atlanta, Georgia, Us

* Managed all daily and hourly mission-critical concerns regarding data availability, integration, architecture, parallel processing, performance, integrity, workflow, modeling, recovery, dependencies, reporting, notifications, revenue related inquires and product delivery SLA’s with clients (large financial institutions).* Worked with the infrastructure, development, multiple other departments and Senior Management to identify; solve and redesign Data Integration challenges between FAS, Vendors and Clients.* Designed and built the new QA and Test environments for a critical data integration application. This environment did not exist and because of this void, it had become a major risk factor in pushing changes in processes and code into production.* Worked on design of a new Enterprise Data Warehouse platform which would include BI interface, Fact and Dimension Data, ETL processes and Reporting.* Performed successful due diligence and feasibility studies for a few technologies the company could use to become more efficient and profitable and with expected short term ROI, including QlikView BI Dashboarding, Windows Azure, Amazon AWS, and Enterprise Service Bus architecture.ENVIRONMENT: SQL Server 2005/2008/2012, Win 2003/2008, .NET, VMWare, Replication, QlikView, Sharepoint, OLAP/OLTP, BLOB Data, Red-Gate, SSIS, SSRS, SSAS.

Austin, Texas, Us

* Responsible for overall support, design, security, performance, and high availability for the BancVue data infrastructure at corporate and data centers in a 24X7X365 environment. * Database Solutions Architecture - Working with project managers, finance, leadership teams, analytic teams, development and QA to discuss and achieve a variety of data related design, resolutions, forecasting and implementations including communications on new applications, security, compliance, workflow, data storage, environment refreshes, and all Enterprise Database environment improvements.* OLAP, OLTP, BI and Reporting Isolation – Split Production environment into two logical and physical entities, an OLAP environment which addresses all data utilization for analytics, BI and dashboards, and the OLTP production environment, which is the host for live production data feeding off of 650+ data sources from clients.* Designed a new Centralized Management console to manage all SQL Server environments across data centers, managing encrypted Backups, Maintenance's, DR and application tasks across all server databases. * Data Center Migrations/Consolidations – Managed a mission critical migration of all Production databases and applications to a new data center with a Enterprise database infrastructure with multiple cluster nodes and data storage layers. The migration was a success and was completed with zero downtime.* Design and optimization of a Data Distribution Map across physically separated database environments. This mapping enables the integration of all company data across multiple applications and databases on different platforms and allowed us to mine into valuable new data connections.ENVIRONMENT: SQL Server 2005/2008, MySQL, Hadoop, MongoDB, Win 2003/2008, .NET, ASP, SAN, Solid State, VMWare, Linked Servers, Clusters, Mirrors, Replication, MicroStrategy BI, QlikView, OLAP/OLTP, VLDB, Red-Gate ToolBelt, SSIS, SSRS, SSAS, Stored Procedures, Jira, Agile, LAMP, SVN.

Us

* Lead the project of building the new DPS SQL Server 2008 R2 HP/HA cluster infrastructure within the Hitachi Enterprise storage, high-end enterprise architect network, Virtual Servers (VMWare) and the IBM blade servers. * Met the objective to migrate all DPS SQL server databases (2000/2005/2008) to the new clustered High Performance/High Availability environment. The database applications included the new Oracle applications SOA stack (with SQL backend), Fusion Center, Business Objects, SharePoint and many other highly critical database environments. * Architected an environment designed for High Performance, High Availability, Scalability/Flexibility, and ease of Manageability. Once the new environment was in production, I was the resource to assist in the migration and tweaking of all SQL server production environments to this highly secure, consolidated, and high performance environment. * Addressing post implementation challenges and tasks to include all documentations, tweaking of applications to point to new SQL 2008 R2 Cluster environments, resolve any/all compatibility issues, migrate all DTS packages to SSIS, and the migration of all SQL jobs/tasks and monitoring systems.

Austin, Texas, Us

* Provided 24X7 support for the mission critical enterprise Trading databases hosted across multiple domains, environments (SQL 2000, 2005 and 2008), clusters, and database instances with zero unplanned production downtime. * Resolved 90% of the top 30 major database environment issues within my first 4 weeks of employment. This was achieved by benchmarking, tracing and sifting thru deadlocks, long running transactions, heaps, identifying source and root causes for the customer impacting issues, then communicating with the business and coming up with quick and decisive action plans to put the fires out.* Completed a migration and consolidation project of moving SQL 2000 and SQL 2005 database environments onto a large high performance Cluster and new SAN at a new Datacenter location. All Databases objects including DTS packages, Jobs, and Tasks were migrated to SQL 2008 A/A/P Cluster environment.* Continuous development on the Trading and Finance database environment reliability, schema designs, data archiving to keep production OLTP lean, index analysis, query execution plan studies, Stored Procedure and View improvements, SQL scheduled tasks improvements, DTS and SSIS Designs. * Setup automated SQL tasks/jobs for Business Operations, to include BackOffice tasks and reports, finance and accounting automated reporting tasks, data synchronization between environments and databases. * Responsible for production Change Management (data, schema, infrastructure), database documentation, policies and procedures, security, and logging. Supported the synchronization of data between environments as requested.ENVIRONMENT: SQL Server 2000/2005/2008, Win 2000/2003/2008, .NET, Log Shipping, SAN Storage, NetApp, Transactional Replication, Multiple Domains & Multiple Clusters, BackOffice, SSRS, OLAP/OLTP, VLDB, Profiler/Perfmon, Red-Gate ToolBelt, SSIS, DTS, Stored Procedures, Virtualization (VMWare and Hyper-V), SharePoint, Ajile.

Us

* Active member of 4 senior Production DBA’s, managing 300+ Production SQL Servers databases, across 45+ SQL Server instances (SQL 2000, SQL 2005 and SQL 6.5), within multiple environments (DEV, QA, UA, PROD, INTEG, DW). * Business Analysis and End User Support - In charge of financial and claims system database application projects, to include migration of large financial applications to SQL 2005 servers, business data analysis, end user support for client\server installs, and performing upgrades and patches for the business applications. * Responding to Production database related requests to include the support of development efforts by validating code from, pushing updates and code changes across environments, support of business application users with application database updates, ad-hoc reporting, DTS and SSIS design for ETL processes, data exports and publications/distributions. * Developed automated DB performance screening and notification processes to include capturing poor performing SQL transactions and queries as they run, performance benchmarking, capturing SQL errors and notification for the DBA team, building a server that is collects selective performance metrics data from all critical Production SQL Servers and performing in-depth data analysis based on the benchmark data. ENVIRONMENT:: SQL Server 6.5/7.0/2000/2005, Win 2000/2003, .NET, MS Access, Log Shipping, OLAP, OLTP, VLDB Apache, Profiler, Perfmon, Embarcadero DBArtisan, ER/Studio, Quest TOAD, LiteSpeed, Spotlight, SSIS, DTS, SQL Analysis Services, Stored Procedures, Replications, Virtualization (VMWare), Blades.

Charlotte, Nc, Us

* As a member of a small Production database support team, I was responsible with 24X7 monitoring of Production server performances. This task was achieved by monitoring SQL logs, Perfmon, Custom Profiler traces, buffer data, and various SQL Mail alerts and notifications. * Optimizations - Query Optimization by capturing poor performing queries and stored procedures, database design evaluations and recommendations for schema updates, hardware and configuration evaluation including RAID considerations, recommendations for index optimization, file subsystem redesign and online database archiving.* Built new SQL 2005 servers for new Migrations and Integrations, to include the migration and conversion of critical and unmanaged MS Access Database Applications onto secure and managed SQL server environments. * Development of a new Backup/Restore strategy, which creates Full DB backups of all Production servers, Encrypts the sensitive Bank Customer data (256bit), Compresses the backup files, logs backup information onto a management table and distributes the files across Integration and Off Site DR locations. ENVIRONMENT: SQL Server 2000/2005, Windows 2000/2003, MS Access, Log Shipping, OLAP, OLTP, Apache, Profiler, Perfmon, Quest LiteSpeed, Crystal Reports, Stored Procedures, VLDB

Austin, Tx, Us

* 24X7 management of high transaction, revenue generating SQL 2000 and 2005 enterprise databases, across multiple domains, environments, servers, and database instances with 0% unplanned production downtime. * Process high priority work requests from management, development teams and customers (external and internal). The typical process included requirements gathering for tasks and projects from clients thru email and meetings. The requests include complex data analysis, research and exports, production database data/schema updates. * Improved the application deployment process by setting up appropriate database environments to include: Development, Integration, QA, UA, Staging (Stress Test analysis) and Archiving (ARCH) environments. * Database design and development to include logical and physical design, schema design, tables and entity relationships, constraints, indexing, stored procedures, triggers. In charge of Database change management, policy and process management and documentation. * Successfully managed a critical SQL Server migration of Production and QA databases from 2000 to 2005, with zero unplanned downtime.* Established, automated and manage disaster recovery planning to include backup/restore policies and procedures. Developed automated maintenance procedures with alerts to include Index Optimizations, DBCC operations, archiving and cleanup tasks, integrity checks, and disk defragmentation. * Direct and develop innovative solutions to improve business continuity and operations through in-depth analysis of business workflow processes and practices in all departments. ENVIRONMENT: SQL Server 2000/2005, Win 2000/2003, MS Access, MS Excel, Visual Studio, OLAP, OLTP, DTS, SSIS, XML, IIS, Visual SourceSafe, Profiler, Perfmon, Red-Gate, Crystal Enterprise, Crystal Reports, Replication, Mirroring, VISIO, Embarcadero E/R Studio, SQL Scaler.

* 24X7 database and data warehouse management of databases in Production, QA and Reporting environments. Administration of servers, database instances, with 0% production downtime. * Built award-winning team that was highly praised for the high quality and speed of our deliverables. * Improved database performance with updates to schema design, indexing, normalization and infrastructure enhancements. * Developed the company data warehouse environment, which uses SQL scripts, jobs, and DTS packages to extract, transform, load and publish selected business data for the executive, sales and marketing teams. * Database change management, policy and process management. * Disaster recovery, data distribution, archiving and cleanup planning. Setup policies and procedures for hourly, daily, nightly and weekly backups (logs and files), data archiving, cleanups, and transfers across servers and environments. * Managed SQL Server migration of the Reporting environment from SQL 2000 to 2005. * Managed critical business systems, including a large in-house developed Claims Management and Billing system and Macola ERP (finance and inventory) system. * Developed and managed systems hardware and platform upgrades, updates, disaster recovery, replications, environments, and supporting development teams to meet objectives.ENVIRONMENT: Microsoft .NET, VB, MS SQL Server 2000 and 2005, SQL Analysis and Reporting, Crystal Enterprise/Reports, Visual Studio, Active Reports, VISIO, Excel, Macola Financial System.

Austin, Tx, Us

* Project and Resource Management – Managed IT department, ongoing projects and a staff of eleven IT and market research analysts.* Development of market research data warehouse for 2 fortune 50 clients. Developed ETL processes and replication for data migration, cleansing and filtering process of market research data. Due to faster and more efficient product delivery and process re-engineering, both clients renewed their contracts. * Database migration from SQL 7 to SQL 2000, and from SQL 2000 to MySQL. Database performance optimization thru indexing, tracing/monitoring, hardware upgrades, and DB normalization.* Implemented policies and procedures for Backup/Recovery, logging, replication. Stabilized the database environments to 0% downtime.* Complete audit of company IT infrastructure, including LAN/WAN, business applications, database systems, servers, clients, storage and backup systems, phone system, vendor contracts, licensing, and ongoing projects and deliverables. The audit resulted in the reduction of IT operations cost by approximately 30%.* IT Infrastructure and Operations Management - Thru detailed audit on all aspects of IT services, implemented new policy and procedures for IT client deliverables, upgraded servers, databases, mail, active directory, domains, routers, firewalls.ENVIRONMENT: SQL 7/2000, MySQL, Win NT, Linux OS, Exchange 5.5/2000, IIS, Apache, Cisco Routers and Firewall, Nokia Firewall, Active Directory, Web Portals, NetMR, JavaScript, VB, DTS, SQL Scripting, Stored Procedures.

* Managed SQL Server 2000 databases and database servers with over 850 million records in a 24X7X365 environment, with 0% unplanned downtime. * Implemented Intranet to integrate sales, installation, and customer service processes as well as provided analysis tools to support Operations, Sales, and Finance departments. * Designed and implemented star schema-based data warehouse to aggregate all management statistics for reporting. * Developed VB.NET/MS SQL Server-based intranet to integrate production systems and dramatically improve decision-making, information gathering, and user effectiveness. * Integrated in-house built financial software system into newly implemented Epicor ERP system.* Developed business and application processes, models and studies to customize business applications (MAS). * Continually tuned and improved integration application programming interfaces between systems and databases. Developed and conducted employee applications training programs to support company regional staff. ENVIRONMENT: SQL 7/2000, OLAP, DTS, XML, Win 2000, VB .NET, Win NT, IIS, Apache, IIS, Apache, Active Directory, JavaScript, VB, SQL Scripting, SQL Trace, Crystal Enterprise, Crystal Reports, VISIO, Active Reports, Stored Procedures, Replication (Snapshot/Transactional), Log Shipping, TestDirector, Epicor, MAS (Monitoring Automation Systems).

Us

* Provided 24X7X365 systems and database support for all critical business databases (SQL Server and Oracle) and the JD Edwards One World Application ERP modules. Managed database environment of 24 SQL server databases, 8 separate database environments, and 12 servers.* Primary JD Edwards ERP application support contact responsible for updates, patches, debugging, customizing, troubleshooting, forecasting growth, securing, improving application and database performance. Continuously updated and enhanced performance of databases and JD Edwards application modules through vendor communication, performance benchmarking, database and server performance monitoring and enhancements.* Performed functional and technical (CNC) administration, support, analysis and training of JD Edwards ERP Applications. * Performed systems integration, data warehouse development and reporting. Developed canned (JD Edwards) and Intranet based, dynamic and logistical executive reports (Crystal Reports and Brio) for Finance, Inventory, and Marketing.* Developed interface that integrated JDE (SQL) with a large Oracle billing system based in Denver that stored customer phone metrics, used for marketing and business development ENVIRONMENT: SQL 7/2000, Oracle 8, Access. Win 2K, IIS, LDAP, JavaScript, VB, Stored Procedures, Profiler, Stored Procedures, DTS, Perfmon, Data Warehouse, Crystal Reports, TestDirector, Cognos, JD Edwards One World.

Us

* Successfully ensured 100% production uptime of all SQL Server databases in 6 separate database environments, across 16 SQL servers and 3 data warehouses, in a critical high availability production environment.* Performed Healthcare Management Systems (QMACS) support as the primary administration and training resource to provide functional and technical support for application modules including: Eligibility, Enrollment, Benefits, Claims, Referrals, Authorization, Credentialing, Case Management, Billing and Reporting.* Managed migration of SQL 7 to SQL 2000 with over 3,000,000 insurance member records database, 250 tables, hundreds of custom SQL programs, users, groups, and code logic updates.* Supported security and customization efforts for the applications process, logic and interface (PowerBuilder/SQL application).* Performed SQL Database Analysis and Reporting, successfully implemented the largely used Crystal Info platform as primary interface for all Insurance and Billing reporting and metrics solution. Developed the initial 30 Crystal Reports, posted, published and administered all (SQL driven) reports.* As key member of the critical Y2K migration planning, supported migration path planning, mapping, and custom SQL programming for data migration and filtering.ENVIRONMENT: 7/2000, IIS, Crystal Reports, Microsoft Access, Crystal Info, SQL Scripting, Query Analyzer, Profiler, Bulk Copy, DTS, ETL design, Replication, Backup/Recovery, QMACS Healthcare Management System.

New York, Ny, Us

Bachelor'S Degree, Computer Science

Associate'S Degree, Photography

Mongodb Development And Administration

Apache Cassandra Training

Education record