Bala S. Email and Phone Number
• 4+ years of total IT experience as a Data Analyst in the Analysis, Design, Modeling, Development, Implementation and Testing of Data Warehouse applications and acquired excellent analytical, co-ordination and interpersonal skills for leadership.• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings.• Experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Integration and Configuration Management.• Experienced and knowledgeable in Systems Development Life Cycle (SDLC) like Requirements gathering, Analysis, Design, Implementation and Agile (Scrum) Software Development cycle includes Stand-up for story updates, PI Planning, story creation, burning hours and story movement.• Good experience with Customer Insight Analysis, Business Insight Analysis, Product Analysis, Marketing Data Analysis and Business Analysis.• Experienced in Dimensional Data Modeling experience using Data modeling, Relational Data modeling, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.• Proficient in R Programming Language, Data extraction, Data cleaning, Data Loading, Data Transformation, Predictive Modeling and Data visualization using R and Tableau.• Experienced in designing customized interactive dashboards in Tableau using Marks, Action, filters, parameter, calculations and Relationships.• Skilled in using visualization tools like Tableau for creating dashboards.• Experience in development of T-SQL, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.• Expertise in analysis, design and implementation of data warehousing applications using Tableau, Teradata, Google Analytics, Informatica, MS SQL Server, Oracle, MySQL, and OBIEE technologies.• Good understanding of Relational Database Design, Data Warehouse/OLAP concepts and methodologies.• Knowledge in Business Intelligence tools like Business Objects, Cognos and OBIEE.• Experience in Text Analytics, generating data visualizations using R, Python and creating dashboards using tools like Tableau.• Good experience of using Python libraries like Panda, NumPy, SciPy, Scikit-learn, Plotly, Matplotlib, Seaborn and NLTK.• Experience with Data Analytics, Data Reporting, Ad-hoc Reporting, Graphs, Scales, PivotTables and OLAP reporting.
Verizon
View- Website:
- verizon.com
- Employees:
- 97920
-
VerizonNew York, Ny, Us -
Business Intelligence AnalystVerizon Dec 2020 - Present• Developed and maintained ETL workflow using Knime Analytics to extract the data from multiple source systems that comprise databases like SQL Server, Teradata to the Staging area, EDW and then to the ThoughtSpot.• Automated the validation process using Knime & Python to ensure the data quality for better data management. • Created and maintained pinboards using ThoughtSpot for the end users to optimize the sales performance for better decision making. • Worked with different teams to help them with automating their daily data loads.• Coordinate with business users to create consensus on business terms and critical data elements for the individuals and institutional business lines. • Build web application to display the daily load status of all the fact tables and other necessary functions using Python Libraries for the organization.
-
Data AnalystCompugain Jan 2020 - Oct 2020Blue Bell, Pennsylvania, Us• Created functional specification documents and spreadsheets that includes the data mapping & data analysis from different sources and coordinate with the development team for data conversion. • Optimize SQL queries performance, integrity, and security of the project’s databases/schemas. • Contribute to the optimization of data management and performance tuning. • Develop and execute test plans to validate that application meets technical specifications. • Build complex SQL queries to perform data masking and encryption techniques form one data source to another to ensure data security. • Participated in regular Technical Reviews, Defect review and walkthrough meetings with important project and business stakeholders throughout the project life cycle. • Supporting the data warehouse in identifying and revising reporting requirements.• Assessing tests and implementing new or upgraded software and assisting with strategic decisions on new systems. -
Data AnalystHumana Apr 2019 - Dec 2019Louisville, Kentucky, Us• Used Agile scrum methodology and strategies for software development and to provide quick and feasible solutions.• Worked in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings.• Applied data cleansing/data scrubbing techniques to ensure consistency amongst data sets.• Worked in conducting Joint Application Development (JAD) sessions for requirements gathering, analysis, design and Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers and to limit a project’s exposure to the forces of change.• Developed the logical and physical data model for the proposed solution.• Used the Django Framework to develop the web and enterprise-based application.• Worked on data that was a combination of unstructured and structured data from multiple sources and automated the cleaning using Python scripts.• Built Tableau visualizations against various Data Sources like Flat Files (Excel, Access) and Relational Databases (Teradata, Oracle, SQL Server).• Created reports and dashboards, by using Tableau to explain and communicate data insights, significant features, models scores and performance of new recommendation system to both technical and business teams. -
Data AnalystVivma Limited Jan 2015 - Nov 2017• Followed SDLC methodologies like Waterfall for web and enterprise-based project development.• Excellent Business writing skills in writing Business requirements document BRD, Use Case Specifications, Functional Requirement Specifications FRS, Software Design Specification SDS, Software Requirements Specification (SRS), Software External Specifications SES, Software Requirement Document (SRD), Data Dictionary, Workflows and Unified Modeling Language (UML) diagrams such as Activity diagrams, and Sequence diagrams.• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.• Developed views and templates with Python and Django's view controller and templating language to create a user-friendly website interface.• Created functional specification documents that includes the data mapping & data analysis from different sources and coordinated with the development team for data conversion.• Wrote Python routines to log into the websites and fetch data for selected options.• Designed/developed tables, views, various SQL queries, stored procedures, function, complex PL/SQL packages for ETL.• Documented logical, physical, relational and dimensional data models. Designed the Data Marts in dimensional data modeling using star and snowflake schemas.• Created reports using SSRS (SQL Server Reporting Services), SSAS (SQL Server Analytical Services) and Informatica.• Created Tableau dashboards using heat maps, stack bars, lines, area charts, scattered plots, geographical maps using show me functionality.• Expertise in creating Dashboards, stories and developing different charts styles including Bar Charts, Line Charts, Tree Maps, Circle views, Scatter Plots, Bullet Graphs, Heat Maps, Geo Maps, Text Graphs in Tableau desktop environment.
Bala S. Education Details
-
New Jersey Institute Of TechnologyGeneral
Frequently Asked Questions about Bala S.
What company does Bala S. work for?
Bala S. works for Verizon
What is Bala S.'s role at the current company?
Bala S.'s current role is Actively looking for full-time jobs|Data Analyst| Business Intelligence Analyst/Engineer|Python|Tableau|SQL|Power BI.
What schools did Bala S. attend?
Bala S. attended New Jersey Institute Of Technology.
Who are Bala S.'s colleagues?
Bala S.'s colleagues are Chiranjeevi Revu, Anthony Wade Tomlinson, Mark Acker, Darius Glover, Tamara Thompson, Joy Ticko, Scott M Mccraith.
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial