Arvind Rao Kotha Email & Phone Number

Peachtree Corners, Ga, Us

Atlanta, Georgia, United States

• Worked on eGRC (Governance, Risk ,Compliance) Platform, understanding business needs, data structure, and building Data-marts according to business requirement.• Utilization analysis, backup & recovery for ibm datastages.• Define database architectures and communicate those designs to business and engineering partners, analyze existing data design and suggest improvements that promote performance stability and interoperability.• Created ‘FR Y-14Q’ and ‘Operational Risk Capital’ Reports as per the rules and definitions provided by the business which are required by the client and to submit to the Feds for every quarter.• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.• Developed the ETL jobs as per the requirements to update the data into the staging database (Oracle, MSSQL) from various data sources and REST API’s.• Created and automated the tasks of finding the current exchange rates between any two countries using Python for the purpose of internal Accrual reports.• Built a pipeline to extract CSV files from an FTP server, transform it and automatically load into a data-warehouse using Python in Google Cloud Functions.• Strong command of SQL for data manipulation and extraction.• Developed Spark applications using Pyspark and Spark-SQL for data extraction, transformation and aggregation from multiple file formats for analyzing & transforming the data to uncover insights into the customer usage patterns.•Designed, developed, and implemented end-to-end ETL processes using IBM DataStage to extract, transform, and load data from diverse sources into target systems• Responsible for estimating the cluster size, monitoring and troubleshooting of the Spark databricks cluster.• Experienced in performance tuning of Spark Applications for setting right Batch Interval time, correct level of Parallelism and memory tuning.•Optimized Sybase ASE performance through various techniques, including query.

Sterling, Virginia, United States

● Implemented reporting Data Warehouse with online transaction system data.● Developed and maintained data warehouse for PSN project.● Provided reports and publications to Third Parties for Royalty payments.● Managed user account, groups and workspace creation for different users in Powercenter.● Wrote complex UNIX/windows scripts for file transfers, emailing tasks from FTP/SFTP.● Worked with PL/SQL procedures and used them in Stored Procedure Transformations.● Extensively worked on oracle and SQL server. Wrote complex sql queries to query ERP system for data analysis purpose● Worked on most critical Finance projects and had been the go to person for any data related issues for team members.● Migrated ETL code from Talend to Informatica. Involved in development, testing and post production for the entire migration project.● Documented the code.● Tuned ETL jobs in the new environment after fully understanding the existing code.● Maintained Talend admin console and provided quick assistance on production jobs.● Involve in designing Business Objects universes and creating reports.● Built adhoc reports using stand-alone tables.● Involved in creating and modifying new and existing Web Intelligence reports.● Created Publications which split into various reports based on specific vendor.● Implemented security measures in DB2, managing user access and permissions.● Worked with business partners internal and external during requirement gathering.● Worked closely with Business Analyst and report developers in writing the source to target specifications for Data warehouse tables based on the business requirement needs.● Exported data into excel for business meetings which made the discussions easier while looking at the data.● Proficient in Transact-SQL for developing complex queries and stored procedures.

Harlingen, Texas, United States

● Worked with DBA to create the physical model and tables. Scheduled multiple brain storming sessions with DBAs and production support team to discuss about views, partitioning and indexing schemes, case by case for the facts and dimensions.● Requirement gathering from the users by conducting a series of meeting with the business system users to gather the requirements for reporting. ● Identification of risks in schedule and marking them in the UseCases. ● Worked on creating new tables and columns to Basel data mart. ● Extensively used StarSchema methodologies in building and designing the logical data model into Dimensional Models.● Intake, load and integrate large volumes of raw, complex health care data from various health plans and disparate sources.● Conduct preliminary and final QA reviews to ensure consistency and integrity of reporting outcomes.● Produce Excel-based business performance reports (i.e., For claims data, provider data, utilization data) and provide an assessment of performance deviations and anomalies to the project consultant.● Design and develop "on the fly" solutions, utilizing SQL code to resolve data process issues.● Mentor and train lesser experienced analysts through instruction, peer review, and sharing of "best practices", to improve team efficiency.● Achievements: Successfully trained and triaged workload to (on and offsite) support members, whose contributions were noted for significantly impacting the team’s ability to meet deliverable goals ahead of schedule.● Used Model Mart of ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement. ● Reconciled a 50% discrepancy in client health plan cost after resolving complex data mapping issues.

Dublin, Ohio, United States

● Analyzed collected data via multiple software programs, such as PowerBI, ServiceNow, Python, and Excel.● Proficient in change management, incident management, ITSM practices, and disaster recovery.● Assisted with generation and review of knowledge articles for use by the service desk.● Worked closely with other analysts, data engineers to develop data infrastructure (data pipelines, reports, dashboards, etc.) and other tools to make analytics more effective.● UsedErwin Data Modeler tool for relational database and dimensional data warehouse designs. ● Supported team development by reviewing and analyzing business process issues and providing recommendations.● Worked with colleagues on various levels within the organization to accomplish a common goal.● Participated in the development/updating of procedures and guidelines to ensure the quality and integrity of the insurance risk management policy.● Conducted statistical analysis of loss information and identify trends for loss prevention with the objective of reducing operational and reputational risk across the Corporation.

Pune, Maharashtra, India

● Collaborated with other departments to deliver business value through database development, reporting, and related projects.● Become familiar with agile development practices and learned how to reflect business priorities into solutions.● Built and deployed these solutions through efficient MS SQL Server databases, Enterprise Reporting Platform (SSRS), Modern Web App, and/or Modern Windows App.● Performed Normalization & De-normalization on existing tables for faster query results.● Wrote T-SQL Queries and procedures to generate DML Scripts that modified database objects dynamically based on inputs.● Created SSIS package to import and export data from various CSV files, Flat files, Excel spread sheets and SQL Server.

Master'S Degree, Information Technology Management, 3.77

Bachelor Of Technology - Btech, Mechanical Engineering, 3.10