TejoDatta Kiran Mylavarapu

• Architected, Analyzed and maintained scalable data engineering solutions using Microsoft Fabric and Azure Data Factory (ADF). • Designed and implemented ETL/ELT workflows on ADF, Fabric using PySpark and Spark SQL, enhancing the efficiency of business workflows by 40%. • Implemented bronze, silver and gold layers utilized in semantic models using MS Fabric for showcasing the data in reporting layer organically. • Well versed with Data integration designs using IICS data integration (used all features) and application integration (creating process, process object, application and service connectors) • Worked on design and integration to front-end application where in SOAP APIs were developed using informatica application integration and complicated JSON structures were handled. • Built an in-house mass update utility for Agency Management cloud system using Informatica IICS Application integration. • Worked with SSIS catalog packages on all types of transformations to clean up the data in de-duplication efforts and provide robust data for reporting and analytical purposes. • Scheduled SSIS packages using SQL server Job agent. • Deployed various artifacts for SSIS/ADF/Fabric and Informatica IICS to different working environments. • Utilized AI-driven GitHub Actions through Azure DevOps to streamline CI/CD pipelines enabling smooth integration and deployment. • Built and maintained the SSIS packages and resolved various ETL related issues. • Also built SSAS cubes for analysis purposes for finance and accounting users. • Created few Power BI reports using relational data and SSAS cubes as sources. • Worked with IBM TM1 for budget forecasting process year on year. • Worked with cross functional teams to collaborate for achieving multi layered projects on time with success.

• Build and maintain modular ETL applications, which enable the flow of data between data sources. • Analyzed ETL process that is consolidating the data related to different devices, accessories, rate plans and services of T-Mobile existing in SQL Server Source and loading to Oracle. Advised the changes required to enhance the process. • Modified the SSIS packages and SQL queries to fix the errors. • Enhanced SSIS packages to resolve the data integrity issue and extract all the data. • Collaborate directly with other ETL developers, data architects, clients, other technical data warehouse team members and database administrators to design and develop high performing ETL flows and maintain consistent development functions. • Ensure solution designs address performance requirements, reusability, availability, integrity, security challenges, and business functional requirements. • Performance tune SSIS packages and SQL code to improve the overall execution time.

Involved in Data Warehouse designing, Creation of Fact tables, Dimension tables. • Built data warehouse as a source for reporting environment using SSIS, MS SQL server 2008R2 and migrated to MS SQL server 2012. • Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers. • Written various T-SQL queries based upon requirements and necessary calculations and used them in the SSIS packages. • Used performance tuning of SSIS packages and best-known practices for faster data refresh. • Worked with different data sources that NFP data is extracted such as Oracle database, Flat files and Salesforce CRM. • Created and maintained Full Data load refresh that runs weekly schedule once and refreshes Incremental Data load refresh that runs every day nightly schedule and refreshes only necessary data based on date dimension.

• Modify SQL queries to upgrade SQL Server performance using SQL Server 2000/2005 • Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible. • Optimizing Stored Procedures and long running SQL queries using indexing strategies and query-optimization techniques. • Responsible for creating datasets using T-SQL and stored procedures. • Assisted in the design of star schema and snowflake schema. • Responsible for rebuilding the indexes and tables as part of performance tuning. • Used SQL Server Agent for scheduling jobs and alerts. • Active part in creating cubes from which data can be retrieved rapidly. • Optimized queries using SQL Profiler and Database engine tuning advisor.