Ajay Tanikonda Email & Phone Number

San Francisco, Ca, Us

San Francisco, Ca, Us

GCP, Big Query, Airflow, Composer, DBT, Microsoft SQL Server, Tableau, Data Studio, GitHub

Santa Clara, California, Us

Azure Migration & Data orchestrationLarge SQL Server maintenance with over 350 Million transactions per dayStructured & Unstructured data volume over 75 PB on AzureAccomplishment of Azure Cost reduction involving great ambiguity coordinating with various teams and resources saving millions of dollars a month in less than 2 months of effortEnd to End knowledge in Software architecture & issuesCoordination between teams with challenging time zonesPowerBI reportingDeveloping, maintaining, and managing reporting, analytics, dashboards

Redwood City, Ca, Us

Develop scalable data pipeline to support healthcare analytics. Architect ETL development framework, provision development virtual machines, and administer project repositories and codebase. Lead ETL team development efforts and provide direction on pipeline development.Responsibilities:• Lambda Architecture implementation based on use cases• Batch Processing and Streaming experiences.• ETL pipelines using Databricks.• Writing complex and optimized Sql queries.• Build tableau dashboards for helping business to understand the results.Environment: Databricks, Python, Cassandra, MySQL Workbench, Service Now, Tableau.

Part of data engineering team, where the project required a ownership of designing, development, administration and monitoring of Database and Data Warehouse, creating reporting solutions. Responsibilities:• BI Engineer for handling end-to-end project.• Implementation partnership with various product managers and development teams with data gathering requirements.• Aliging Timelines & features based on Priority from Business and process TPMs• POC on Apache Spark using pyspark for BI team to provide an analytical view of web logs in Tableau.Environment: MS SQL Server, Vertica, Python, Linux, SQL, Toad Data Point, Tableau.

Redmond, Washington, Us

As a Program Manager at Infosys played the role of an onsite coordinator for Microsoft Budget Workbench, accountable for all the quarterly releases and deliverables to the customer.• Responsible for preparation of the detailed level design documents, data models, for the security models.• Manager for onshore and offshore team, coordinated across multiple regions.

Bangalore, Karnataka, In

Senior Software Engineer with expertise in designing and development of Database (Relational modelling) and Data Warehouse (Dimensional modeling) architecture, creating ETL packages using Integration Services (SSIS) & custom ETL scripts, creating OLAP cubes using Analysis Services (SSAS), creating end-to-end reporting solution using Reporting Services (SSRS), administration of Database and Data Warehouse. Responsibilities:• Worked directly with clients to understand requirements and then Design, Develop and Administer database and data warehouse from end-to-end like SaaS. • Involved in business requirement gathering phase by conducting JAD sessions.• Used ER-Win tool extensively and performed the data modeling (Star Schema).• Performance tuning, maintenance, configuration, service monitoring, and alerting. • Created SQL batch scripts, database scripts, indexes, stored procedures, views, tables, CTE’s, triggers, table-valued and scalar functions etc.• Optimized poorly performing queries and stored procedures for optimal performance.• Excellent command of writing ad-hoc queries utilizing Dynamic SQL and SQLCMD utility.• Involved in unit testing and preparing test cases with QA’s for new functionality in application. • Developed complex ETL packages to load fact and dimension table in an Enterprise Data warehouse, using various SSIS transformations and keeping auditing and error log information.• Involved in all the phases of report life cycle (Authorizing, Managing, and Delivery).Environment: MS SQL Server 2012, SSIS, SSAS, SSRS, TFS, Lite Speed, SQL Profiler, Power BI.

Bangalore, Karnataka, In

Software Engineer with expertise in development of Database (Relational modelling) and Data Warehouse (Dimensional modeling) architecture, creating ETL packages using Integration Services (SSIS) & custom ETL scripts, administration of Database and Data Warehouse. Responsibilities:• Involved in Requirement Gathering and System Appreciation document creation. Worked on end to end migration of Databases from one UI to another UI.• Created SQL batch scripts, database scripts, indexes, stored procedures, views, tables, CTE’s, triggers, table-valued and scalar functions etc.• Optimized poorly performing queries and stored procedures for optimal performance.• Developed complex ETL packages to load fact and dimension table in an Enterprise Data warehouse, using various SSIS transformations and keeping auditing and error log information.Environment: MS SQL Server 2008, SSIS, TFS, Lite Speed, SQL Profiler, Power BI.

Bangalore, Karnataka, In

Software Engineer with expertise in development of Database (Relational modelling) and Data Warehouse (Dimensional modeling) architecture, creating ETL packages using Integration Services (SSIS) & custom ETL scripts, administration of Database and Data Warehouse. Responsibilities:• Created SQL batch scripts, database scripts, indexes, stored procedures, views, tables, CTE’s, triggers, table-valued and scalar functions etc.• Optimized poorly performing queries and stored procedures for optimal performance.• Developed complex ETL packages to load fact and dimension table in an Enterprise Data warehouse, using various SSIS transformations and keeping auditing and error log information.Environment: MS SQL Server 2005, SSIS, TFS, Lite Speed, SQL Profiler, Power BI.

Bachelor'S Degree, Mechanical Engineering

High School, Mathematics, Physics And Chemistry