Kishore Suryadevara

• Provided strong leadership to enhance team productivity and morale, fostering a collaborative environment. Improved team performance through comprehensive training, mentorship, and regular coaching, focusing on individual strengths and career progression
• Championed innovative solutions to overcome challenges and enhance productivity. Oversaw project estimations, task prioritization, and shared expertise in Data Warehouse architecture and ETL best practices. Led code reviews, optimized performance, and ensured adherence to best practices.
• Collaborated with stakeholders to prioritize deliverables and spearheaded Snowflake & DBT migration efforts.
• Developed and implemented operational standards, policies, and procedures while conducting performance evaluations, compensation, and hiring to maintain optimal staffing. Led process improvement initiatives that resulted in significant cost savings without compromising quality.
• Conducted 1:1 sessions, provided training on DBT and direction on new technologies, and fostered team development and growth, with a strong emphasis on mentoring
• Technology stack: DataStage,DB2,Snowflake,DBT, AWS batch, ECR, Rally and Cybernation

• Served as an ETL Consultant, assisting the team with architecture and migration of data from source systems. Led the conversion of on-prem ETL processes to Google BigQuery, ensuring seamless data loading into the Data Warehouse.

• Contributed to Google Cloud migration by refactoring and migrating legacy Datastage and Teradata processes into BigQuery. Worked closely with the team to architect the migration, establish standards, and ensure a strategic approach that involved code refactoring rather than a simple lift-and-shift. This approach also included identifying and removing unused code to optimize the migration process.

• Technology stack : DataStage 11.7, SQL Server, Teradata, Autosys, Rally, Big Query, Google cloud storage, Terraform, GIT & Astronomer

• Team Leadership & Collaboration: Collaborated with the team on task estimates and provided ongoing mentorship. Conducted 1:1 sessions and performance reviews to foster professional growth and ensure high performance.
• Cloud Migration: Created high-level designs and worked on migrating on prem ETL processes to Google Bigquery
• Google Cloud Architecture: Designed the architecture for Google Cloud Data Warehouse, establishing standards and processes for efficient operation.
• Performance Tuning & Issue Resolution: Tuned long-running ETL jobs for optimal performance and assisted in debugging Datastage batch failures. Prioritized and managed Incident Management tickets to resolve issues promptly.
• ETL Standards & Best Practices: Developed and managed ETL standards and best practices to ensure consistency and quality across projects.
• Job Scheduling & Monitoring: Created and maintained Tidal job schedules to ensure seamless execution and monitoring of ETL jobs.

• Technology Stack: Netezza 7.2, Tidal, GCP (Big query), Linux, Oracle 12.1, BigQuery, Apache Airflow, Fivetran, DBT, JIRA

• Managing and leading different projects, code reviews and performance tuning of long running jobs.
• Performance tuning of long running ETL jobs
• Facets migration project from 4.7 (Sybase) to 5.2 (Oracle) along with DataStage 7.5/8.5 to 8.7.
• Create manage ETL standards and best practices, while coaching and training resources on DataStage and ensuring adherence to these standards.
• Fix TWS schedules to standardize the job streams by removing redundant entries
• Technology stack: DataStage (7.5, 8.5, 8.7, 9.1, 11.3), Sybase, Oracle EXADATA, flat files & Linux

• As a Lead ETL Consultant, I spearheaded multiple projects, designing and creating ETL jobs to load data into data marts, supporting various reporting requirements. Collaborated closely with Data Architects to implement data model changes and updates, while also working with Business Analysts to resolve mapping issues and implement necessary updates. Additionally, I developed high-level ETL designs and workflows to ensure seamless data integration and efficient processing.
• Technology stack: DataStage 8.7, Oracle 9.1, Oracle EXADATA, flat files, Tidal and UNIX

• Data migration project replacing Oracle SQL processes and salesforce data loader with DataStage processes which will extract data from Datawarehouse and creating rollup summaries in Salesforce.
• Technologies Used: DataStage 8.5 & 8.7, Oracle 11g, Teradata and Flat files, Linux, Salesforce, Tidal

• Texas Health Resources has 24 owned, operated, joint-ventured or affiliated hospitals delivers health care in Dallas, TX for 14 counties. The Project is creating a CBI (Clinical Business Intelligence) extracting data from SQL Server, Oracle.
• Technologies Used: IBM Information Server (8.5,8.7), DB2 UDB, Control M, IBM Fast Track, TOAD, Oracle & SQL server

• Created an enterprise solution (PCe- Premier connect enterprise) for premier and its members which will be used IBM CBI model as a target in DB2. The Data Warehouse contains information about safety advisor and quality advisor.
• Technologies Used: IBM Information Server (8.7, 9.1), DB2 UDB, Control M, TOAD, Flat files, Netezza

• The goal of this project was to reconcile and align financial account balances across multiple data source including Merrill Lynch, UK Corporate, Corporate Oracle, Elimination, and Management within Bank of America's operations. Data from both SAP and FIG systems was validated, consolidated, and subsequently loaded into SAP. The processed data was then integrated with the Recon Tool to ensure precise financial reporting.
• Technologies Used: Teradata 12, IBM Information Server 8.1, AIX, SQL Assistant, CONTROL- M SAP Bank Analyzer

• This project migrated old loyalty programs (offline) to new loyalty (Online) program systems.
• Built real time and batch interfaces to and from the vendor in support of SYWR programs. This allowed the client to integrate points earned from multiple stores and locations to points earned from online purchases.
• Technologies Used: Teradata V2R5, IBM Information Server (8.1), Linux, AIX, SQL Assistant, CONTROL- M, JIRA

• The objective of this project is to migrate existing ETL processes using SQL, PL/SQL ETL to DataStage and to rewrite the process to eliminate extra overhead and unused data in production, and it added new functionality through DataStage.
• Technologies Used: IBM WebSphere DataStage 8.1, AIX64 (5.3), Oracle 10g, Cognos, Autosys, Toad, Embarcadero rapid SQL (7.6.3), InfoSphere Data Architect Version 7.5.2

• Worked closely with business analysts and users to design logical and physical database to maintain statistical analytics processes from various health programs to detect fraud and abuse. Implemented design through Data Stage. Performed data quality checks to ensure data integrity, created Business Object universe, and provided various technical support to users.
• Technologies Used: DataStage 7.5.2 Enterprise Edition, IBM DB2 UDB 8.2.7, AIX64 (5.3), Business objects 6.5, WEBi/Info view, OS 3270, ISO Warehouse Tracking Tool, COBOL, SAS 8.2, Korn shell, BCU 1.1

• Migrated data from different sources comprised of multiple casinos, hotel properties and slot accounting management systems, and creating an Enterprise Data warehouse and Data Marts for client’s decision support system and operational data sources. Designed, developed, tested, and supported ETL processes in DataStage.
• Technologies Used: Ascential DataStage 7.5.1(Server, Enterprise Edition), SQL Server 2000/2005, Oracle 9i, Stratus, Tandem, Data wise, Windows clustering, Windows 2003 Server, Windows XP, Red Hat LINUX ROCKS 3 (Cluster/Grid Technology), Golden Gate 8.0/9.0/9.5, FoxPro

• Designed and developed CRM, which is a key component to provide the ability to analyze bid results through business intelligence applications.
• Captured and delivered Bid linkage data, core Bid data, Bid Milestone tracking, Competitive Bid Data and Bid Pricing strategies to the data warehouse for storage in both Enterprise Data warehouse and the Margin/Price Management Data Mart. Used DataStage to develop, schedule, and monitor jobs.

• Customer Data warehouse by integrating multiples sources to provide a solution to business users which will help enabling a central view across the enterprise, including contact details, customer valuation data, and information gathered through interactions such as direct marketing.

• Data Migration within PMAP is the process of transforming data from its initial source system format in the staging database through the cleansing and transformation process into the Oracle warehouse, ORWHSET1 Database.

• The System kept the tracks of inventory items, Customers, Supplier and Inventory Transactions like Sales, Purchases, Issues, Receipts, and Returns easily.