| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Linkedin PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEPROFESSIONAL SUMMARYOverall 5+ years of experience as well as 2+ years of Data Analytics Professional Extensive Experience with SQL development, Reporting, Database Design, Development and Implementation of Client-Server Applications & Business Intelligence/Reporting applications using SQL Server, Business Objects and Tableau.Hands on experience with Tableau desktop 8/9/10.1 and 10.3, Tableau server and Tableau Reader.Extensive experience working with Tableau Software as a dashboard developer.Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.Hands on experience with Business Objects 4.1Expert in Data Warehouse development starting from inception to implementation and ongoing support, Strong understanding of BI application design and development principles.Highly experienced in whole cycle of DTS/SQL server integration services (SSIS Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.Employed various Tableau functionalities like Tableau Extracts, Parameters, Filters, Contexts, Data Source Filters, Actions, Functions, Trends, Sets, Groups, Calculations and Maps etc.,Experience in creating visualizations using Bars, Lines and Pies, Maps, Scatter plots, Gantt charts, Bubbles, Histograms, Bullets, Heat maps and Highlight tables.Expertise in generating reports using SQL Server Reporting Services, Ad hoc Reposts, Crystal Reports, and MS Excel spreadsheets and Power Pivot.Expert in designing Enterprise reports using SQL Server Reporting Services, generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS.Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.Company data assets (data models), spark, sparkSQL, and hiveSQL to populate data models.Implemented Agile methodologies across projects, resulting in improvement in project completion rates and enhanced team collaboration.Expertise in Data Governance, Metadata Management, and Information Governance within legal project management and law firm environments.Proficient in Content Management, Data Architecture, and Software Tools for managing projects, legal technology, and system design. withStrong background in Information Security, Cybersecurity, and Engineering a focus on data strategies, automation, and governance.Designed, implemented, and maintained scalable technical solutions in production environments, leveraging Docker for containerization, AWS EC2 for compute resources, and DBT for data transformation.Engineered data warehouses by creating efficient data models to enhance BI reporting and analytics.Led project management for database applications, ensuring alignment with business requirements.Applied data warehousing techniques to deliver real-time analytics for improved decision-making.TECHNICAL SKILLSSQL, Python (Basic), MS SQL Server 2016, 2014, 2012, MS-Access, Sybase, Oracle, Hadoop, Tensorflow MySQL, No SQL(MongoDB), Postgre SQL, DB2, Teradata, Splunk.Tableau, Power BI, Data Bricks, Data Factory, Snow Flake, Snap logic, AWS, GCP, Power shell.SAP BW/4HANA, Linux, Git Hub, Service Now.Microsoft Office Suite & Visio studio, Lucid chartEXPERIENCETechie Brains Incorporated Normal IL USA, remoteBusiness Data Analyst Aug 2023 - PresentCreated Tables, Stored procedures and defined functions.Created SQL scripts for tuning and scheduling.Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).Integrate various data sources into Snowflake, ensuring seamless data ingestion and consolidation from multiple sources such as databases, APIs, and flat files. This involves using tools like Snowpipe for continuous data loading and managing ETL/ELT processes.Experience in ETL, Data warehousing, Data pipelines, Data Analytics, in Amazon cloud and AWS Data Stack.Create executive-level reports including dashboards and flash reports, to afford quick and easy understanding of business results.Develop and maintain metrics database and metadata, and ensure metrics are accurately sourced and validated.Predictive modeling and fact-based management to drive decision making.Built several dashboards in Tableau for analysis using multiple data sources.Implements Tableau Maps and heat map analysis using locations in dashboards.Implemented Actions and Data Filters in Tableau, looker and power BI across multiple sharepoint dashboards.Implemented Row level security in Tableau and worked with multiple data sources using Data Blending.Identify and analyze behavioral data, patterns, and techniques.Identify and implement data solutions into power BI enable creation of new and existing reports and metrics.Maintain knowledge on current and emerging developments and trends for assigned areas of responsibility, assess the impact, and collaborate with senior management.Creation of report objects like attributes facts, metrics, filters, prompts to meet report requirements.Creation of the databases and experience with front-end reporting tools including Workday Prism and Workday Advanced Reporting.Creation of various SDK Code/plugins supporting file subscriptions on the fly, exporting and Packaging various MicroStrategy Reports in a single Document.Direct and enhance organizational initiatives by positively influencing and supporting change management.Identify and direct the implementation of process improvements that significantly improve quality across the team, department, and business.Led the design and implementation of a database application, improving server management and increasing system efficiency by 20% in a dynamic environment.Managed cross-functional teams to gather business requirements, conduct acceptance testing, and ensure timely system integration.Developed scalable data models integrated into the data warehouse, driving advanced data analysis and business metrics tracking.Operations Specialist - Business Analyst Finacct Solutions, India January 2022 August 2022Implement data processing tasks using Apache Spark for batch and real-time and E commerce Adobe analytics.Conduct detailed data analyses to evaluate the effectiveness of health programs, focusing on health outcomes and operational efficiencies.Bridged the gap between business needs and technical teams by translating quantitative models and business rules into actionable data analytics for rare disease call center data flows.Engage with stakeholders to gather comprehensive requirements for service functionalities, ensuring alignment with business objectives and user needs.Contributed to the development of high-performance software solutions using Python and object-oriented design principles.Design, implement, and manage complex data integration pipelines using Azure Data Factory and AWS leveraging services such as S3, Redshift, RDS, Aurora, DynamoDB, Lambda, SNS, SQS, Kinesis, and IAM for efficient data processing and storage.Developed and delivered microservices to support various applications, ensuring scalability and reliability.Conduct rigorous testing of service solutions to ensure functionality, reliability, and performance meet business requirements and quality standards.Design, develop, and maintain interactive dashboards and reports using Tableau and QuickSight to communicate program performance and impact.Collaborate effectively with global teams to understand regional requirements, align on solution designs, and support the implementation and maintenance of service solutions across diverse geographical locations in Migration projects.Senior Associate - Data Analyst Wipro LTD India May 2020 January 2022Developed machine learning models (classification, regression, clustering) using Python for Building predictive models for tasks like customer segmentation and demand forecasting.Writing Python scripts to automate data workflows and analysis tasks for extraction, transformation to reduce manual efforts, improve operational efficiency, and enable real-time data-driven decision-making.Integrated SAP data for unified business insights and reporting to Streamline business processes.Stay updated with SQL, machine learning, scripting languages, and SAP ERP technologies to apply latest tools and techniques to optimize data analysis and project outcomes for evolving business needs for sustained organizational growth.Collaborated with cross-functional teams to define data quality requirements and provide analytical support for business initiatives.Presented findings and actionable recommendations to senior management to support strategic decision-making.Process Executive - Data Operations / Cognizant, India July 2018 April 2020Extracted Sales transaction data from SAP ERP using SQL queries to gather information on sales orders, invoices, and customer data.Used Python scripts to automate data extraction and integration from AWS S3 buckets and Azure Blob Storage, ensuring data consistency and reliability.Perform exploratory data analysis (EDA) to understand trends, customer behavior, and product performance.Clean and preprocessed data using Pandas for consistency.Conduct statistical analysis such as regression models & time series analysis to forecast sales trends and identify seasonal patterns.Stay updated with the latest trends and best practices in data visualization, analysis, and business intelligence tools.Deploy and manage machine learning pipelines to automate model training and evaluation, integrating predictive analytics into the Sales dashboard.Education:Governors State University University Park/IL, USAMasters in Business Analytics August 2022 May 2024Mother Theresa PG College Telangana, IndiaMBA in Finance August 2018 October 2020Certifications & Projects:TATA Data Visualisation using Tableau:Empowering Business with Effective Insights Job Simulation on Forage - September 2024Completed a simulation involving creating data visualizations for Tata Consultancy Services.Prepared questions for a meeting with client senior leadership.Created visuals for data analysis to help executives with effective decision making.AI Projects With Python, Tensor flow and NLTK:AI-Powered Customer Engagement Solutions using NLP and Deep Learning September 2024Developed an AI-driven chatbot using Python, NLTK, and TensorFlow for intent classification, improving response accuracy by 25%.Built a sentiment analysis system with NLTK and TensorFlow, achieving 90% accuracy in classifying customer feedback.Designed a recommendation system using deep learning in TensorFlow, enhancing customer engagement and reducing bounce rates by 15%. |
