Srikanth Reddy [Data Developer & sr BI]

Ph: 778-***-****

Email ID: ad0rj4@r.postjobfree.com

Career Overview

Around 5 years of IT experience, I possess advanced proficiency in Data Developer, MSBI, Power BI, and Database Development, coupled with a strong command of Azure, AWS technologies. Experience Summary

Enhancing data accessibility across the organization by integrating Power BI with other Microsoft tools like SharePoint and Teams.

Employing data security techniques, such as row-level security and data classification, in Power BI to safeguard sensitive data and ensure regulatory compliance.

Conducting user training and ongoing support to empower effective utilization of Power BI for data analysis and reporting.

Staying updated with the latest Power BI developments and features to enhance data visualization and analysis capabilities.

Good understanding of Data modelling concepts like star-schema Modeling,sowflake schema modelling and Dimension tables.

Work with internal stakeholders to help define business needs and find appropriate solution, leveraging existing digital tools.

Worked on snowflake environment to load real time data from various data sources into Datawarehouse.

Continue to modernize data reporting / dashboards to improve adoption and usage.

Manipulating large & complex databases and data mining tools such as SAS,SPSS

Collaborating with data scientists to create robust analysis and prediction models.

Creating tailored data architectures for BI and analytics solutions.

Developing and managing data transformation processes to facilitate efficient data preparation.

Designing and implementing strategies for database backup and recovery to ensure data protection and availability.

Work with partners within customer operations and across organization to make data-drive business decisions

Assisting in constructing data warehouses or data marts using SSIS as the integration layer.

Enhancing database performance by identifying and resolving bottlenecks, optimizing queries, and implementing effective indexing approaches.

Technical Skills

Proficient in crafting and constructing databases, showcasing expertise in data modeling, schema design, and SQL scripting.

Excellent backend skills in databases, creating, optimizing & performance tuning objects like Tables, stored procedures, functions on multiple databases SQL Server, MYSQL, Oracle

Good understanding in programming languages like Python, Bash, Java

Knowledge of data warehousing, data modelling and business intelligence/rules design concepts and toolsets

Skilled in creating comprehensive business intelligence solutions encompassing data warehousing, ETL processes, data visualization, and reporting, leveraging MSBI tools and PowerBI.

Expert in developing informatica interface to extract, transform and load(ETL) data into data warehouse

/data marts from different sources

Expertise in data integration, ETL/ELT modern tools on AWS cloud to ensure efficient data processing and cutting edge technologies.

Experience with core AWS technologies such as EC2, ELB, Auto Scaling, S3,EFS,LAMBDA, API Gateway, Cloud watch, VPC, Route 53

Experience in Writing Infrastructure as code (Iac) with Terraform, server configuration tools like Ansible for AWS Infrastructure

Well-acquainted with Azure services, including Azure SQL Database, Azure Data Factory, Azure Analysis Services, Azure HDInsight, and Azure Stream Analytics.

Knowledgeable in cloud architecture and adept at applying best practices to develop secure and scalable cloud-based database and BI solutions.

Possessing strong communication skills, both written and verbal, to facilitate effective collaboration with team members, stakeholders, and clients.

Good understanding of Agile methodology and experience with query development using SQL

Experience in reporting and data visualization tools such as Tableau, Microsoft reporting services

Equipped with a history of managing database and BI development projects, encompassing planning, execution, monitoring, and reporting.

Enthusiastic about continuous learning, remaining current with emerging technologies and industry trends in the realm of database and BI development, particularly within the Azure and AWS environment.

Academic Qualifications

Bachelor of Technology in Engineering, SRM University Chennai, India.

Masters in Global Leadership, Fairleigh Dickinson University Vancouver. Professional Experience

Client: CoreLogic, Vancouver, British Columbia

Title: Data Developer

Tenure: Dec 2022-Present

Skills: SQL, Snowflake, SQL Server, ETL, PowerBI, Informatica Cloud, Agile. Ensuring the continuous availability of Power BI assets, optimizing the performance of ETL workflows, creating data integration solutions through Azure Data Factory, facilitating data provisioning via Azure Data Lake, troubleshooting SSIS packages, establishing data integration mechanisms within Azure Data Factory, and facilitating data provisioning using Azure Data Lake.

Responsibilities:

Ensuring data sources' availability and dependability for Power BI through backup and recovery procedures.

Developed ETL (Extract, Transform, Load) processes to transform, clean and load data from different source systems to Data warehouse using informatica cloud.

Wrote complex SQL queries including sub queries, joins and CTEs for faster data retrieval from multiple tables.

Implementing continuous integration and continuous deployment practices via Azure DevOps, ensuring efficient and reliable software delivery.

Responsible for creating SSIS packages for holding data from multiple sources including, Oracle, Excel,RDBMS,textfiles and then dumping that data to SQL Server after various transformations

Worked on Snowflake environment to remove redundancy and load real time data from various data sources into Data warehousing using Informatica.

Coordinating with fellow developers and teams to integrate Power BI seamlessly with other systems and applications, including data warehouses and data lakes.

Crafting and refining T-SQL queries optimized for processing and analyzing substantial data volumes on Azure Synapse.

Developed IBM Cognos frameworks, and reports for real-time business insights

Applied SDLC best practices within Agile and Scum methodologies.

Expertise in converting complex business logic into SQL tools, including stored procedures, User Defined Functions, views and Data Modeling

Enhancing the speed and efficiency of Power BI reports by fine-tuning and optimizing database queries and ETL processes.

Performs Regression testing and finds defect reporting

Created dashboards for data visualization using PowerBI that helped to reduce the issues by 43% and estimate the future growth.

Collaborating closely with data architects, data analysts, and data scientists to design and execute impactful data integration solutions through Azure Data Factory.

Establishing and sustaining data quality controls to ensure consistent and accurate data.

Collaborating alongside Cross-functional teams like stakeholders, such as business analysts and data architects, to comprehend SSIS data integration requisites and deliver effective solution using IICS

Validating and troubleshooting SSIS packages to verify data transformations and uphold adherence to business regulations.

Managing version control systems (Git) to manage database schemes and deploying SSIS packages across diverse environments.

Hand-on experience in developing data warehousing and big data analytics

Providing training and support to end-users on generating and using reports.

Staying updated on the latest features and enhancements within SSRS and integrating them into the report development workflow.

Develop and deploy automated CICD pipelines using tools such as Jenkins, GitHub Client: TD Bank, Victoria, BC

Title: MSBI Developer

Tenure: Sep 2021-Dec 2022

Skills: Ensuring compliance with regulatory mandates within Power BI reports, establishing data integration workflows, configuring SSIS processes, managing access to Azure subscriptions, and upholding regulatory adherence across Azure environments.

Responsibilities:

Partnering with data stewards and data governance teams to ensure adherence to data quality standards and regulatory obligations in the crafted Power BI reports.

Understanding of BI requirements, analysis of business needs with Functional and ETL teams for design reporting.

Crafting and upholding data integration workflows through Power Query Editor in Power BI, enabling data cleansing, transformation, and structuring from various origins.

Responsible for BI Reporting solutions Like Design, Development, testing and implementation of BO reports.

Overseeing and enhancing access security for Azure subscriptions and resources.

Automation of BI reports to end-users via email in various formats like Excel, pdf.

Establishing and managing scheduled data refresh procedures within Power BI to uphold the currency of reports and dashboards with the most recent data.

Demonstrated success in developing distributed architectures and processing technologies(Spark, Kafka)

Enforcing conformity with regulatory mandates and industry benchmarks across Azure environments.

Devising and constructing data models for the purpose of data analysis and reporting.

Formulating and implementing strategies for data anonymization and pseudonymization to safeguard sensitive data privacy within Power BI and MSBI solutions.

Developing and maintaining dashboards and reports tailored for data analysis.

Collaborating closely with stakeholders to gather requisites for BI and analytics solutions.

Documenting the design, configuration, and maintenance protocols for SSIS packages.

Disseminating knowledge and extending support to team members and stakeholders involved in SSIS development.

Remaining current with the most recent SSIS features, optimal practices, and prevailing trends in the field. Client: 3i Infotech, Hyderabad, India

Title: Jr BI Developer

Tenure: Nov 2018-Dec 2019

Skills: Addressing performance issues in SSIS ETL workflows, data encryption in SSIS packages, ensuring data traceability in Power BI, developing segmentation engines in MSBI solutions. Responsibilities:

Enacting mechanisms for data lineage and data auditing to monitor data alterations and ensure data traceability within Power BI.

Collaborating intimately with business users to comprehend their reporting requisites and transforming them into impactful data models and visual representations within Power BI.

Offering technical assistance and troubleshooting support to Power BI users, addressing data-related concerns and guaranteeing the seamless operation of reports and dashboards.

Partnering with data scientists to create customer segmentation engines and predictive analytics models within Power BI and MSBI solutions.

Constructing and overseeing tools for data visualization to amplify the effectiveness of BI and analytics solutions.

Developing and sustaining data integration solutions to streamline data movement within BI and analytics contexts.

Formulating and upholding predictive analytics models to facilitate precise data analysis and forecasting.

Diagnosing and rectifying performance challenges in SSIS ETL workflows.

Ensuring data security and implementing encryption measures within SSIS packages.

Overseeing and optimizing the execution of SSIS packages to achieve resource-efficient operation. Client: Yes Bank, Hyderabad, India

Title: SQL Developer

Tenure: Dec 2016-Nov 2018

Skills: Resolving performance challenges within SSIS ETL processes, implementing data encryption within SSIS packages, guaranteeing data traceability within Power BI, and crafting segmentation engines in MSBI solutions. Responsibilities:

Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.

Employed SSIS for database migration, encompassing Excel files, flat files, and SQL Server databases, to a centralized IT destination.

Created intricate database code objects like Stored Procedures, views, and Functions, employing them to generate reports and enhance query performance through indexing on minimally updated tables.

Generated diverse SSIS packages to transfer data from OLTP (Tabular) databases to staging areas and subsequently into data warehouses. Deployed packages using SSIS and implemented dynamic package configuration.

Collaborated with Service Management teams to establish and oversee service level agreements, communication protocols with data suppliers, and data quality assurance policies.

Offered advisory services on data quality to clients and internal stakeholders, suggesting enhancements to data acquisition processes for improved accuracy within the data warehouse.

Provided support and developed solutions for the Association Management System, actively participating in system and user acceptance testing.

Presented technology options and recommendations to address business challenges, possessing a robust understanding of database and system performance monitoring. Demonstrated the ability to convey ideas effectively in both written and verbal communication to various organizational levels.

Extensively utilized SSIS transformations, such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task, and Send Mail task.

Supported Batch and Online processes, involving the development, enhancement, and maintenance of T- SQL procedures, views, triggers, and query tuning.

Employed various Control Flow Tasks and Data flow Tasks for designing SSIS Packages, alongside employing diverse Transformations to facilitate Data Conversion, Sorting, and data cleansing from disparate Sources into standardized Company Formats.

Established XML Package Configurations and integrated Error Handling utilizing Event Handlers for scenarios such as On Error, On Warning, and On-Task Failed Event Types.

Contact this candidate