Data Analyst Integration

SARATH KUMAR KONAKANCHI

Gmail:***************@*****.***

Contact: +1-205-***-****

ROLE : DATA ANALYST

SUMMARY

Seasoned experienced as Data Analyst and Data Integration Specialist with 3+ years of expertise in ETL processes using Informatica PowerCenter, data visualization with Tableau, and SQL-based database management. Skilled in leveraging data security best practices to enhance data integrity and protect sensitive information.

2+ years of experience in designing, developing, and implementing ETL processes using Informatica PowerCenter to extract, transform, and load data from various sources into data warehouses or data marts.

Effective team player as well as individual performer with experience in SQL, PL/SQL and Oracle, MySQL.

Expertise in generating reports using Tableau.

Created and customized interactive dashboards in Tableau using advanced calculations, parameters, and visual analytics techniques to meet specific business requirements.

Proficient in creating complex mappings, mapplets, workflows, and sessions to facilitate data transformation and loading.

Experience in creating aggregates, hierarchies, charts, table calculations, trend lines and calculated measures in Tableau.

Proficient in OOP (Object-Oriented Programming) concepts such as inheritance, polymorphism, encapsulation, and abstraction.

Hands-on experience with Java 8 features, including Lambda expressions, Stream API, and functional interfaces.

Editing and publishing views and data sources on tableau server by assigning tasks and schedules for refreshing at regular intervals.

Implemented cross-platform data integration solutions, connecting multiple systems and databases to create a unified data environment for enterprise reporting.

Experience in working closely with business analysts, data architects, and other stakeholders to understand data requirements and design effective ETL solutions.

Leveraged Tableau and SQL to perform advanced data analytics, including trend analysis, predictive modeling, and generating actionable insights to support strategic decision-making.

Design and implement advanced Tableau visualizations using action filters, user filters, advanced navigation techniques using sheet & Dashboard level Actions and Level-of-Detail (LOD) expressions.

Expertise in database modelling, administration and development using SQL, PL/SQL in Oracle (8i,9i and 10g), and SQL Server environments.

Provided training and mentorship to junior team members on ETL processes, SQL development, Tableau reporting, and data visualization best practices.

Optimized ETL workflows and database queries for better performance, resulting in reduced processing time and improved data load efficiency.

Good experience in using various project management tools like JIRA and Version.

Skilled in writing robust code using try-catch blocks, custom exceptions, and error handling.

Worked on web applications that required cross browser compatibilities like Chrome, Safari, Firefox, Internet Explorer, and Opera.

Participation in Project meetings, good at documenting and understanding System Specifications and User requirements.

EDUCATION

Completed my Bachelor’s in computer Science from Vellore Institute Of Technology (India) – May 2022

Completed my Masters degree in computer science from University of Alabama at Birmingham – May 2024

TECHNICAL SKILLS

Data Warehousing

Informatica (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), SSIS, Data Stage

Reporting Tools

Business Objects, XIR3, Cognos 8 Suite

Data Modeling

Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools

Win Runner, Load Runner, Test Director, Mercury Quality Center, Rational Clear Quest

RDBMS

Oracle, MS SQL Server, UDB DB2, Teradata, MS Access

Cloud Technologies

AWS, Azure

Programming

SQL, PL/SQL, UNIX Shell Scripting, VB Script, Python

Environment

Windows (95, 98, 2000, NT, XP,7,8,10), UNIX

Other Tools

TOAD, MS-Office suite (Word, Excel, Project and Outlook), BTEQ, Teradata SQL Assistant

CERTIFICATION

Cybersecurity Certificate – [University Of Alabama At Birmingham],[2024].

Completed specialized traning in Network Security, Computer Security, and Cloud Security.

INTERNSHIP

●Title: Web Development

Company: Dizi shades Media Pvt Ltd

Developed and maintained dynamic web applications, collaborating closely with cross-functional teams to ensure alignment with project requirements and deadlines.

• Implemented responsive front-end interfaces using HTML, CSS, and JavaScript, enhancing user experience and accessibility.

• Integrated back-end functionalities using PHP and MySQL, ensuring seamless data management and retrieval for optimized performance.

• Participated in code reviews and testing procedures to identify and resolve issues, contributing to the overall quality and reliability of web applications.

• Demonstrated strong communication and teamwork skills while actively engaging in collaborative problem-solving and knowledge sharing within the internship team.

●Title: Digital engagement Specialist

Company: University of Alabama

• Collaborated with university advancement teams to identify fundraising priorities and campaign objectives, aligning digital engagement strategies with overarching fundraising goals and objectives.

• Analyzed donor engagement trends and campaign performance using Excel, SQL, and CRM data to provide actionable insights to the advancement team.

• Designed, developed, and managed ETL pipelines, ensuring seamless data flow between internal systems and external data sources.

•Created interactive dashboards in Tableau/Power BI to monitor fundraising progress, donor engagement, and campaign KPIs in real-time.

●Title: Teaching Assistant for Cyber Risk Management Course

University Name: [University Of Alabama at Birmingham, Department of Computer Science]

• Provided integral support to the faculty in delivering lectures, facilitating discussions, and

conducting hands-on exercises in Cyber Risk Management course.

• Led interactive workshops and review sessions to reinforce key concepts, clarify doubts, and

enhance students' understanding of cyber risk assessment, mitigation strategies, and regulatory compliance.

• Demonstrated proficiency in utilizing relevant software tools and platforms for simulations, risk assessments, and threat modeling exercises, enriching students' learning experience and practical skills development.

PROFESSIONAL EXPERIENCE

HSBC Technology, Hyderabad.

Role: Data Analyst [2021-2023]

Data Analyst

Responsibilities:

•Business requirement gathering and translating them into clear and concise specifications and queries.

•Performed Data Analysis using SQL

•Wrote Data Bricks code and ADF pipeline with fully parameterized for efficient code management.

•Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL

•Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau

•Created the Power BI report on data in ADLS, Tabular Model and SQL server.

•Install and configure Power BI Gateways to keep the dashboards and reports refresh automatically.

•Integrated complex PLM and BOM data into Snowflake for centralized analytics and reporting.

•Create rich Power BI visualizations, DAX queries and work with Power Query, M code language for data integration and transformation as per the business requirement.

•Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.

•Worked closely with business users to identify key metrics and design visualizations that align with their needs and business objectives .

•Implemented data validation rules and error-handling mechanisms to ensure high data quality throughout the ETL process.

•Mapped XML data to relational databases for efficient transaction processing

•Worked in Tableau environment to create dashboards like weekly, monthly, daily reports using tableau desktop & publish them to server.

•Involved in requirement gathering and database design and implementation of star- schema, snowflake schema/dimensional data warehouse using Erwin.

•Performed and utilized necessary PL/SQL queries to analyse and validate the data.

•Creating complex SQL queries and scripts to extract and aggregate data to validate the accuracy of the data

•Used Python& SAS to extract, transform & load source data from transaction systems, generated reports, insights, and key conclusions.

• Created complex visualizations, including heatmaps, scatter plots, cross tabs, bar charts, and geographical maps, to provide actionable insights.

•Integrated data from various sources, including databases (Oracle, SQL Server), flat files, APIs, ensuring data consistency and quality across systems.

•Used Teradata utilities such as Fast Export, MLOAD for handling various tasks

•Used Spark API over Cloudera Hadoop YARN to perform analytics on data in Hive.

•Configured real-time streaming pipeline from DB2 to HDFS using Apache Kafka.

•Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding, replication, schema design.

•Source code admin - Manage and configure SVN resolve issue regarding source code management, manage branching and merging, code freeze process.

Environment: Snowflake, Azure Data Factory, Power BI, Hadoop, MS Excel, Power Point, SQL Server, SVN, Agile, Mongo DB, JIRA, ETL.

Contact this candidate