Kalpana Rachapalli

Email: ad2x6x@r.postjobfree.com

Mobile: +1-469-***-****

SUMMARY

●Seasoned analytics professional with more than 11+ years in business process and project management specializing in Business Analytics/Business Intelligence, Data Warehouse, Data Modelling, architecting ETL processes, developing visualizations using tools like Tableau and Power BI using Snowflake and Redshift Data warehouses.

●Proficient in creating Tableau dashboards using advance Tableau functions like Calculated fields, Sets, bins, Groups, Parameters, Actions, Ad hoc Calculations, etc.

●Experience in creating various filters like quick filters, data source filters, global filters, context filters and user filters in Tableau.

●Determined to carve a niche in the field of Data warehouse Concepts, BI and ETL Tools.

●Worked on Snowflake to support analytical reporting and business intelligence initiatives.

Strong experience on data analysis in Finance domain.

Good knowledge on producing reports and interactive analytics dashboards using Tableau and Power BI.

Experience in data visualization developments using Tableau desktop covering all aspects of development life cycle including requirements gathering, dashboard designing, coding, unit testing, implementation, publishing on Tableau server, user configuration and support.

Good Knowledge in cleaning the data using Tableau Prep.

Extensive experience in creating users, groups, sites, row level security user's filters and monitored server activities in Tableau Server.

Excellent analytical and debugging skills using Tableau, Power BI, and SQL.

Have good understanding of Tableau and Snowflake architecture, design, development, and end user experience.

Strong understanding of development life cycle methodologies including Waterfall and Agile. Extensive experience in understanding companies BRDs for Prototype and Analytics project.

Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.

EDUCATION

Master of business Administration (MBA) From Visveswaraya Technological University, India (2007 to 2009)

TECHNICAL SKILLS

Datawarehouse & BI: Tableau Desktop/Server, Power BI, Snowflake, Redshift

Languages: SQL

Databases: SQL Server, MySQL

Operating Systems: Windows

Microsoft Tools: MS Excel, MS Word, MS PowerPoint, Power BI

Domain: Banking/Financial, Marketing, IOT, Web analytics

Document Management: JIRA, Share Point

PROFESSIONAL EXPERIENCE

Schneider Electric Oct-2019 to Sep-2023

Technologies: Tableau Desktop, Tableau Prep (ETL Tool), Tableau Server, Snowflake, Excel, Csv files

Job Responsibilities:

Working on testing of data migration and supporting database team in building of ETL process for the efficient usage.

Designed captivating and interactive dashboards using Tableau and Power BI across various areas such as Sales, Monthly Active Users (MAU), Active Accounts, Learning. These dashboards have made substantial impact on business by providing visually appealing insights and facilitating data-driven decision-making.

Analysing complex data sets to identify trends, patterns, and relationships. Collaborate with business stakeholders to understand their requirements and translate them into actionable visualizations that provide meaningful insights.

Developing and maintaining Tableau dashboards, ensuring they are optimized for performance and usability. Implementing filters, parameters, and interactivity to allow users to explore and interact with data.

Designing and building data models. Creating efficient data connections and data blending techniques to combine data from multiple sources. Ensuring data accuracy, consistency, and integrity.

Extracting data from various sources, including databases, spreadsheets, and APIs. Transform and cleaning data to make it suitable for analysis and visualization. Perform data wrangling tasks, such as merging, aggregating, and filtering data.

Optimizing Tableau workbooks for efficient performance and quick response times. Identify and address bottlenecks or data issues that may impact performance of visualizations.

Collaborating with cross-functional teams, including data analysts, business analysts, and stakeholders, to gather requirements and understand business needs. Provide training and support to end-users, helping them navigate and interpret Tableau visualizations effectively.

Keeping up with the latest trends and best practices in data visualization and Tableau development. Continuously enhancing skills and knowledge by participating in training, workshops, and industry events.

Worked on Admin related activities like Stale content, extract priority monitoring, server upgrades in multimode cluster, providing access to users, and assigning license keys.

Analysing the different data sources related to exchange platform.

Interacted with business users to gather requirements.

Presenting Community related KPI’s, its Visits, unique visitors, page view, topics discussed in the community, solutions on weekly and monthly basis.

Worked on process documentation.

worked on tickets related to issues on Tableau Server and desktop.

Luxoft June-2019 to Oct -2019

Technologies: Tableau Desktop,Tableau Server, Sql Server, Excel, Csv files

Job Responsibilities:

Reporting & Analysis: Develop, Analyse, Manage and publish KPIs/Metrics to be used to measure the effectiveness and efficiency of the “in scope” ITSM process.

Providing the best inputs to IT service manager through visualizations about the incidents, changes, and problems of different applications.

Presenting the data to management about each application criticality and their risk level

Presenting data to IT service manager about servers and their vulnerability to prone to risk

Providing to Management about unauthorized user’s access details to IT applications which are used for daily trading.

Caterpillar Inc Nov-2017 to Feb 2018

Technologies: Tableau Desktop, Tableau Server, Excel, Csv files

Job Responsibilities:

•Manage rate database for projects review, Audit, compute rates and payments, examine invoices and shipping documents.

•Auditing of freight invoices for US & Belgium locations against contract rates

•Presenting the visualized dashboards to management

•Created and modified some of the existing reports and dashboards.

•Created Parameters to achieve desired functionality.

•Created and maintained accurate charts and reports to examine percentage of audit completion.

•Prepare monthly metrics and report it to carriers to see their accuracy levels of invoicing.

•Handling of claims process

•Analysis on daily reports to find the duplicate payments.

•Comparing invoices charges against contract rates through by SAS queries.

•Pulling of Crystal reports and report it to management.

Tata Consultancy Services Dec-2009 to Mar-2016

Technologies: Tableau Desktop, Tableau Server, Sql server, Excel, Csv files

Job Responsibilities:

•Understand Requirement, Analysing Systems and Source Databases.

•Designed, developed, and implemented Tableau Business Intelligence reports.

•Representing data using the visualizations such using Charts.

•Use Trend Lines, Reference Lines, and statistical techniques to describe the data.

•Responsible for dashboard design, look and feel and development.

•Combine data sources by joining multiple tables and using data blending.

•Enhance the reports based on the client requirements.

•Processing Weekly, Monthly and Annual viewing and tuning data using statistical tools like SAS, UNIX, and Excel

•Interacted with business users to gather requirements.

•Used filters, quick filters, Context filter sets, parameters, and calculated fields on Tableau reports.

•Created extensive joins for data blending from several different data sources.

•Created and modified Interactive Dashboards and Creating guided navigation links within Interactive Dashboards.

•Developed the reports by using extracts to improve the performance of the reports.

•Generation of visualized reports by using tableau at desired frequency and within the timelines defined.

•Publishing sheets and dashboards on server Using Tableau Desktop

•Credit Officer for Low-Risk Funds

•Credit Functions include defining low risk / high risk clients for banks.

•Setting up limits, approving excess tickets, monitoring net worth / NAV, doing credit and rating analysis.

•Preparing Reconciliations to find the differences in Current limit and new limit.

•Managing middle level client relationships to ensure client expectations are met and exceeded.

•Reviewing work of team members to check credit assessments of clients meets the criteria specified by client.

•Liaise with Sales Department & Business Managers to ensure relevant KYC documentation is extracted and processed.

Contact this candidate