Bala S. Email & Phone Number

New York, Ny, Us

New York, Ny, Us

• 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.

Blue 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.

Louisville, 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.

• 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.