Sahithya Jallepalli (Sr. Data Analyst)
Plainview,NY
Summary
PROFESSIONAL SUMMARY
10 + Years of IT experience as a Data Analyst with solid understanding of data warehouse/data mart development, SQL and analysis of Online Transactional Processing (OLTP), data warehouse (OLAP) and Entity Relationship Diagrams (ERD). Superb attention to detail, highly skilled in Data Analytics, Data Mining, Data Visualization, Deep learning, ETL Solutions and Data Management Excellent knowledge of SDLC phases (Inception, Elaboration, Construction and Transition) and Agile Experience in creating the workbooks and dashboards using Tableau that includes tools like Tableau Desktop, Tableau Server and Tableau Reader. Experiences on Tableau tools include Tableau Desktop, Tableau Reader, Tableau Public, and Tableau Server. Optimizing Data Solutions in the Cloud: Developed and deployed data ingestion pipelines using Snowflake on AWS. Managed data lakes and ETL processes on Azure to enhance data accessibility and storage solutions. Designed Logical/ Physical Data Model for E-Delivery System Using ER-Studio. Expertise in creating advanced chart types, visualizations, and complex calculations to manipulate the data as per business need through Power BI. Created paginated reports using Power BI builder and published to Power Bi service. Experienced in developing Power BI Reports and Dashboards from multiple sources using data blending. Experience as a Senior Data Analyst on a Data Ingestion project. This group will be in a Sales force and Snowflake Data Ingestion environment. Advanced SQL skills and ability to analyze complex datasets to identify trends, patterns, and anomalies using tools like Excel, Alteryx, and SQL. Excellent communication skills and client facing skills- able to work with business teams and lead requirement gathering independently. Created SQL Loader Scripts, table sizing, indexing, table partition, SQL tuning. Experienced in developing Web Services with Python programming language and Familiar with NumPy, Pandas, Scikit-Learn, Tensor flow, NumPy, Matplotlib and NLTK also worked with R to understand data and developing applications Experience in writing Sub Queries, Stored Procedures, Triggers, Cursors, and Functions on MySQL and PostgreSQL database Experienced with ETL tools like SSIS, SSRS and SSAS with Informatics Generated Tableau dashboards with combination charts for clear understanding. Adept at providing valuable insights via data analytics and advanced data-driven methods Able to create and present data in graphs, info-graphics, and other visual methods to the team Skilled in developing new data collection systems that optimize data management, delivery, and quality Strong foundation in data structures and algorithm development Excellent understanding of business operations and analytics tools for effective data analysis Self-motivated and team player that has the drive to learn and master new technologies and techniques Practical experience with working on multiple environments like development, testing Exposure in working on e-Commerce application. Production with excellent analytical and problem-solving skills and ability to work on own besides being a valuable and contributing team player. Senior data analyst with strong analytical skills, adept at leveraging advanced statistical tools and data visualization techniques to drive business insights. Proven track record of collaborating with cross-functional teams to deliver actionable results, adapting seamlessly to evolving project requirements. Known for reliability, critical thinking, and ability to translate complex datasets into strategic recommendations. Qualified [Desired Position] with thorough background in data analysis and proven track record of delivering actionable insights. Developed and implemented data models leading to improved business decision-making processes. Demonstrated proficiency in SQL and Python, showcasing keen ability to collaborate with cross-functional teams. Results-driven data professional with strong foundation in data analysis and business intelligence. Known for transforming complex datasets into strategic business solutions while maintaining rigorous standards. Consistently fosters team collaboration and adapts seamlessly to dynamic project requirements, leveraging skills in SQL and Python to drive impactful outcomes. Proactive [Job Title] with [Number]+ years product management experience in small start-up business environments. Effective driver of product development lifecycle from concept to delivery. Communicative and collaborative with proven history of improving business operations to support corporate growth and revenue. Personable business professional bringing successful [Number]-year career in financial roles within large and fast-paced corporations. Release-planning specialist trained in advanced Excel modeling. Creative solutions architect with real-time problem-solving flexibility.
Overview
12
12
years of professional experience
Work History
Sr. Data Analyst
Dallas Independence School District
04.2023 - Current
- Company Overview: Govt
- Organization focused on education
- Design and create data visualizations to report and communicate insights
- Collect and assimilate data from multiple source systems Service Now and TIP Web
- Perform exploratory analysis to identify patterns and insights in the data
- Perform data analysis with Serial Tags comparison to facilitate duplicate and invalid assets data for data cleanse
- Implement and deploy models using predictive analytics with asset data comparison outcomes
- Work with and present analytics to clients
- Translate complex data-driven analysis into simple, easy-to-understand insights
- Support data integrations, cleansing and quality solutions
- Create and maintain data dictionaries and other forms of metadata
- Automate data processes to ensure timeliness, accuracy and scalability
- Utilize technologies such as statistical and graphical tools to drive data insights
- Perform a detailed evaluation to assess the data sources current state
- Establish a baseline for KPI and determine project requirements
- Produce formal reports of the results of the data evaluation
- Clean, standardize, enhance and validate the data
- Provide Quality Control Review
- Assist with establishing a data asset governance Data, Data Lineage, Data Quality policy and procedure
- Create an archival plan for assets not in use but will need to be retained according to the District’s retention policy
- Establish a Standard Operating Procedure to allow the District to move forward once this task has been completed
- Govt
- Organization focused on education
- Environment: MS SQL Server 2016, MySQL, MS Office Professional, Microsoft Excel and Power Point
- Delivered comprehensive reports highlighting key trends, patterns, anomalies, presenting findings to senior management for informed decision-making purposes.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
- Leveraged text, charts and graphs to communicate findings in understandable format.
- Partnered with IT teams to ensure seamless integration between databases and analytical tools, maximizing system efficiency across departments.
- Served as a subject matter expert on various projects, sharing valuable insights derived from extensive industry experience as a Senior Data Analyst.
- Spearheaded the implementation of dashboard visualization tools, providing actionable insights for stakeholders and decisionmakers.
- Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
- Performed root-cause analysis on data-related system problems to recommend or execute corrective action.
- Trained junior analysts in best practices for statistical modeling techniques, fostering professional growth within the team.
- Developed and implemented data collection systems and other strategies to optimize statistical efficiency and data quality.
- Created and automated data visualizations to present insights and tell compelling stories.
- Assessed large datasets, drew valid inferences and prepared insights in narrative or visual forms.
- Implemented machine learning algorithms to generate predictive models, guiding future business strategies and investments effectively.
- Interpreted business questions and collaborated with engineering teams to identify data sources.
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
- Managed key tasks and resources to achieve cost, schedule and strategic growth initiatives.
- Identified, reviewed and evaluated data management metrics to recommend ways to strengthen data across enterprise.
- Used business objects, business intelligence and other reporting tools to extract data from data solutions and data warehouses.
- Assisted in the development of a centralized data repository to improve accessibility and collaboration among teams.
- Provided guidance on data governance policies to ensure compliance with industry regulations.
- Conducted periodic competitor analyses to benchmark and strategize on market positioning, influencing long-term planning.
- Spearheaded project to automate routine data processing tasks, freeing up analyst time for more complex analysis.
- Streamlined data analysis processes, significantly reducing turnaround times for monthly reports.
- Led team in adoption of new data visualization tools, which improved stakeholder understanding of complex information.
- Customized analytics dashboards for executive leadership, providing real-time insights that informed critical business decisions.
- Enhanced data integrity and accuracy by meticulously auditing and cleaning datasets.
- Analyzed data to identify root causes of problems and recommend corrective actions.
- Generated ad-hoc reports to evaluate specific business requirements.
- Generated standard and custom reports to provide insights into business performance.
- Developed customized reports, summarizing and presenting data in visually appealing format.
- Designed and developed data pipelines to acquire, clean and process data.
- Identified patterns and trends in large data sets and provided actionable insights.
- Created data models to support decision-making processes.
- Created dashboards to monitor and track key performance indicators.
- Assisted with creating data cubes and OLAP models to improve data analysis.
- Developed and maintained data warehouses and data marts to support business operations.
- Optimized data access and storage to improve performance of analytics systems.
- Updated and developed scripts and queries to extract and analyze data from multiple sources.
- Deployed predictive analytics models to forecast future trends.
- Implemented business intelligence solutions to increase operational efficiency.
- Developed and implemented data governance policies and procedures.
Data Analyst/Power BI
Nolan Transportation Group
06.2021 - 12.2022
- Involved in analysis of Business requirements, Design, and Development of High level SDLC process flow and Low-level designs, Unit, ETL Solutions, ecommerce application and Integration testing
- Utilized AWS and Azure cloud services for hosting data pipelines and ensuring scalable data storage
- Migrated data to Snowflake for improved performance and cost efficiency in a cloud-based data warehousing environment
- Created calculated columns and measures using DAX queries
- Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI
- Implemented role-based security and row level security on data in Power BI
- Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources
- Created Power BI dashboard and generated reports using the SQL server tables as source
- Lock objects on the reports
- Developed python programs to automate the data flow on day-to-day tasks
- Performed data analysis and data profiling using complex SQL on various source systems including Teradata, and SQL Server
- Developed data quality portal using Python scripting, increasing data quality
- Developed the logical data models and physical data models that confine existing condition/potential status data fundamentals and data flows using ER Studio
- Reviewed and implemented the naming standards for the entities, attributes, alternate keys, and primary keys for the logical model
- Worked with data compliance teams, Data governance team to maintain data models, Metadata, and Data Dictionaries; define source fields and their definitions
- Involved in the daily maintenance of the database involved monitoring the daily run of the scripts as well as troubleshooting in the event of any errors in the entire process
- Scheduling tasks on windows task scheduler to run the Python scripts to generate reports for frequent interval of times
- Document implementation and design details for model choices, rationale, and reasoning
- Created Tableau Dashboards with interactive views, trends, and drill downs along with user level security
- Created dynamic Tableau dashboard reports
- Demonstrate and deliver rapid prototypes for the models and work with SDLC ITIL QA to ensure quality
- Primary focus will be on applying data mining techniques, doing statistical analysis, and building high-quality prediction models to support various Business/service functions
- Enhancing data collection procedures to include information that is relevant for building analytic systems
- Processing, cleansing, and verifying the integrity of data used for analysis
- Doing ad-hoc analysis and presenting results in a clear manner
- Building forecast models and build predictive models with the relevant information
- Implementing and developing data visualization models for the business presentations
- Research, design, implement and validate cutting-edge algorithms to analyze diverse sources of data to achieve targeted outcomes
- Environment: Power BI, Python 2.7 and 3.4, Tableau, MS SQL Server 2013, MySQL, JavaScript, Eclipse, Linux, Shell Scripting, Jira
Data Analyst
Vanguard
07.2019 - 05.2021
- Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report/ Tableau
- Created Tableau Visualizations and Dashboards as per the requirements
- Created DAX Queries to generate computed columns in Power BI for the project related to T
- Row
- Used Power BI Gateways to keep the dashboards and reports up to date
- Utilized AWS and Azure cloud services for hosting data pipelines and ensuring scalable data storage
- Implemented and followed agile development methodology within the cross-functional team and acted as a liaison between the business user group and the technical team
- Analyzed historical data, productivity, and current trends to identify risks and opportunities
- Used SQL queries for organizing and abstracting data from MS Access databases
- Created Power BI Reports using the Tabular SSAS models as source data in Power BI desktop and publish reports to service
- Provided production support on the existing Power BI Dashboards to resolve the issues quickly and published Power BI Desktop reports created in Report View to the Power BI service
- Generating various capacity planning reports (graphical) using Python packages like NumPy, Matplotlib, and SciPy
- Designed and deploy rich Graphic visualizations with Drill Down and Drop-down menu option and Parameterized using Tableau
- Developed Tableau data visualization using Scatter Plots, Geographic maps, Pie Charts and Bar Charts, and Density charts
- Created dashboards for analyzed POS data using Tableau Desktop based on the user requirements
- Visualizing the data with the help of box plots and scatter plots to understand the distribution of data using Tableau, Python libraries
- Performed Data Analysis and Data profiling using complex SQL on various source systems including MS SQL Server, MySQL
- Utilized Tableau and custom SQL features to create dashboards and identify correlation
- Clean data and processed third-party spending data into maneuverable deliverables within a specific format with Excel macros and python libraries such as NumPy and Matplotlib
- Identified data discrepancy, quality, and performance metrics using SQL and python
- The building, publishing customized interactive reports and dashboards, report scheduling using Tableau
- Worked extensively on Data Profiling, Data cleansing, Data Mapping, and Data Quality
- Worked with various Transformations like IRR formula, Joiner, Expression, Lookup, and Aggregate, Filter, Update Strategy, Stored procedure, and Normalizer
- Developed, modified, and maintained for both ad-hoc and ongoing requirements laid by stakeholders and clients
- Fulfilled ad-hoc data requests from clients using SQL, Power BI, Tableau and Excel
- Environment: Python, Tableau, Power BI, MS SQL Server, ERWIN, MS Excel, Excess, Windows
Data Analyst
Macys
07.2017 - 06.2019
- Manipulation of Data using python Programming
- Performed data preprocessing and feature engineering for further predictive analytics using Python
- Developed and deployed data ingestion pipelines using Snowflake on AWS
- Managed data lakes and ETL processes on Azure to enhance data accessibility and storage solutions
- Generated report on predictive analytics using Python and Tableau including visualizing model performance and prediction results
- Worked extensively on BI SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP
- An excellent understanding of both traditional statistical modeling and deep learning (neural networks), etc
- Generated Tableau dashboards for sales with forecast and reference lines
- Clean data and processed third party spending data into maneuverable deliverables within specific format with Excel and Python libraries such as NumPy, Matplotlib
- Imported data from SQL Server DB, Excel to Power BI to generate reports
- Created BI dashboards using SQL and Excel Power Pivot to track weekly/monthly quantitative KPIs for service assurance ticketing
- Generated dashboards in POWER BI Desktop and POWER BI Service using super-fast slice and dice and modern data visualization features
- Used Python to preprocess data and attempt to find insights
- Executed SQL queries from R/Python on complex table configurations
- Create, maintain, modify and optimize SQL Server databases
- Retrieving data from the database through SQL as per business requirements
- Performed SQL Backup and Restore tasks on Various SQL Servers
- Create/run various Ad-Hoc projects and queries for our Executive Management Board using on SQL/Access per requirements
- Using SQL runtime engine to schedule nightly process running the server jobs, monitoring schedules and validating its components
- Used GIT for version control with colleagues
- Improving the project quality in terms of performance and the related documentation
- Performed Impact Analysis of the changes done to the existing mappings and provided the feedback
- Participated in providing the project estimates for development team efforts for the offshore as well as on-site
- Environment: Python, Power BI, MS SQL Server, SQL, Tableau Server, GIT, Deep learning and SSIS
Data Analyst
US Steel
01.2016 - 06.2017
- Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules with ETL Solutions
- Conducted Oracle database analytics using TOAD and other BI tools, Tableau to resolve customer services issues
- Effectively utilized the knowledge of scripting languages in the Unix OS environment
- Manipulating, cleansing & processing call and price data using Excel, Access, and SQL
- Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model
- Implemented Referential Integrity using primary key and foreign key relationships
- Generated ad-hoc SQL queries using joins, database connections, and transformation rules to fetch data from legacy Oracle and SQL Server database systems
- Involved in Data Mapping
- Performed root cause analysis to trace the client-side issues in the data
- Develop and maintain data solutions that utilize SQL, Microsoft SQL Server Reporting Services, and Excel
- Develop new reports both proactively and in response to client requests to improve operational efficiency
- Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Cloud
- Worked on the development of dashboard reports for the Key Performance Indicators for the top management
- Created advanced chart types, rich data visualizations, and complex calculations to manipulate the data
- Good exposure to creating reports from multiple data sources using the Data blending technique
- Good knowledge in creating the user level, Data source level, and row-level security filters for the workbooks, views, dashboards, and data sources
- Performed reverse engineering to analyze and rewrite the programs and queries to create readable documents
- Responsible for creating the staging tables and source to target mapping documents for the ETL process
- Identified and tracked the slowly changing dimensions and heterogeneous sources and determined the hierarchies in dimensions
- Automation of process to keep the system up to date and to reduce manual errors by developing shell scripts and using CRONTAB in UNIX
- Environment: MS SQL Server 2012, Oracle 12c/11g, MS Office, ERWIN, Tableau, Excel, Access, Visio, UNIX
Data Analyst
Srivenk Soft solutions Pvt.Ltd
05.2012 - 08.2015
- Company Overview: IT solutions provider based in India
- Conducted sessions with the Business Analysts to gather the requirements
- Worked as a team to conduct Gap Analysis and identify data anomalies and determined the scope for these anomalies and suggested options for conversion and cleanup of data
- Created and executed SQL scripts to validate, verify and compare the source data to target table data
- Created and loaded temporary staging tables for Data validation and to enhance performance
- Performed data analysis and data profiling using complex SQL on various source systems including Oracle
- Involved in identifying the Data requirements and creating Data Dictionary for the functionalities
- Created Stored Procedures, Triggers, and view, Tables and other SQL Joins and Statements for Applications using T-SQL
- Performed Data mining and hardcopy or electronic document study to improve and expand the databases in the application
- Worked with data investigation, discovery and mapping tools to scan every single data record from many sources
- Performed detailed requirement analysis and created data mapping documents
- Acted as liaison between Business Intelligence and Business User groups to relay change requests
- Working on Data Verifications and Validations to evaluate the data generated according to the requirements is appropriate and consistent
- Implemented python scripts to parse XML documents and load the data in the databases
- Implemented partition techniques to improve the performance and increase optimum utilization of space
- Wrote multiple SQL queries to analyze the data and presented the results using Excel, and Access
- IT solutions provider based in India
- Environment: SQL, Excel, XML, T-SQL, ERWIN
Education
Master in Computer Application -
Acharya Nagarjuna University
01.2010
Bachelor of Science -
Acharya Nagarjuna University
01.2007
Skills
- Erwin 96/97/98
- ER/Studio V17
- Oracle Designer
- Microsoft Visio
- Toad
- Snowflake
- SQL
- MS SQL
- PL SQL
- NOSQL
- T SQL
- UNIX Shell Scripting
- AWK
- Python 2X
- R
- Python 3X
- Tableau
- Power BI Desktop
- Power BI Service
- Power BI Report Server
- Agile
- Waterfall
- SCRUM
- SDLC
- JIRA
- MS Teams
- AWS
- Azure Cloud
- Python Programming
- Advanced Excel
- ETL processes
- SQL Expertise
- Tableau Software
- Data Quality Assurance
- Advanced analytics
- Data Mining Techniques
- Data integration
- Dashboard creation
- Deep learning
- Time-series analysis
- Data and Analytics
- SQL and Databases
- Data Modeling
- KPI Tracking
- Data Mapping
- Documentation
- Gap analysis
- Requirements Analysis
- Data Mining
- Workflow Analysis
Languages
English
Full Professional
Hindi
Native or Bilingual
Telugu
Native or Bilingual
Timeline
Sr. Data Analyst
Dallas Independence School District
04.2023 - Current
Data Analyst/Power BI
Nolan Transportation Group
06.2021 - 12.2022
Data Analyst
Vanguard
07.2019 - 05.2021
Data Analyst
Macys
07.2017 - 06.2019
Data Analyst
US Steel
01.2016 - 06.2017
Data Analyst
Srivenk Soft solutions Pvt.Ltd
05.2012 - 08.2015
Bachelor of Science -
Acharya Nagarjuna University
Master in Computer Application -
Acharya Nagarjuna University
Similar Profiles
David SuaDavid Sua
Service Warehouse/Driver, Warehouse Orders at Independence School District Independence, MO.Service Warehouse/Driver, Warehouse Orders at Independence School District Independence, MO.
Cedriana BrokenberryCedriana Brokenberry
Assistant Club Director at Boys & Girls Club of Greater Dallas / Dallas Independent School DistrictAssistant Club Director at Boys & Girls Club of Greater Dallas / Dallas Independent School District
Davion HollywoodDavion Hollywood
Substitute Teacher at Dallas Independent School District (Dallas ISD)Substitute Teacher at Dallas Independent School District (Dallas ISD)
Bryan SupitBryan Supit
Private Family Chauffeur at Shoughi FamilyPrivate Family Chauffeur at Shoughi Family
Kim JonesKim Jones
Vice President at New American FundingVice President at New American Funding