Swati Chandrakar
ETL- Tableau Developer
Hyderabad
Summary
Experienced Software Developer with a proven track record of over 6 years in proficiently managing development, support, and maintenance tasks across diverse platforms and tools, including Oracle 11g, PostgreSQL, Greenplum, Informatica PowerCenter, Tableau, and Splunk. Demonstrates a consistent commitment to excellence and a valuable contribution to the success of service-based industries. Proficient in SQL/PL/SQL, ETL processes, and reporting tools, complemented by specialized training in business intelligence and performance management. Adept at leveraging technical expertise to drive efficiency and innovation in software solutions.
Overview
6
6
years of professional experience
6
6
years of post-secondary education
5
5
Certifications
2
2
Languages
Work History
Lead Consultant (Data Analyst- Tableau)
Genpact (GE Vernova)
Hyderabad
12.2021 - Current
- Designed and developed GE VERNOVA Labor Hours dashboard, which is designed to be used by more than 15+ sites, successfully live for (Greenville, Birr, Elblag, Wroclaw, Karlovac, Changwon, Schenectady, Bangor), designing this reduced the server load. As earlier each site had individual workbooks consisting of total 84 Dashboards, which has been consolidated into 1 workbook with 8 views serving as centralized workbook for all sites having features like row level security, drilldown, actions, parameter to switch between multiple KPI's.
- Experience in migrating 20+ workbooks from self-service server to certified server, scheduling the extracts and enhancing the dashboards as per new requirement, making it more user friendly by applying relevant filters, minimizing irrelevant data using custom sql , applying optimization techniques like hiding unused columns, keeping minimum LOD calculations.
- Experience in Leading and managing diverse modules in GE GAS Power, consisting of multiple dashboards, datalake objects. Helped stakeholders to provide proper business model according to business requirement.
- Expertise in integrating Tableau writeback extension "Elements" to multiple dashboards and provided cross functional training to various teams of GE, reducing manual efforts and enhancing efficiency.
- Designed and developed the BMS vs. SAP(Powermax) dashboard that serves as a cross-reference between BMS and SAP (Powermax) for confirmation as well as good receipts. This has helped to save 700$ of inventory disconnects and negative impact on consumption issues.
- Designed and developed an Operational Availability (OA) Dashboard for the Total Productive Maintenance (TPM) to reach business goal of 95% OA of machine's, utilizing advanced features such as Level of detail(LOD),parameters, tableau actions facilitating seamless navigation and drilldown capabilities for users, this dashboard is acting as single source of truth for maintenance performance against production scheduled time.its being closely monitored by Value Stream Leaders, ensuring alignment with business goals and annual savings of about $4500.
- Collaborated with cross-functional teams to gather requirements, analyze datasources, and design optimized unified query for loading data for various sites into one reporting table, earlier the logic was distributed as part of alterx code for each site which is now consolidated into one Greenplum Function which is populating the reporting table.
- Created Finance net sales, Quality, Usage, Labor hours and Source data quality analysis report using Reporting tool like Tableau.
- Designed and developed greenplum stagging function to streamline the loading of multiple sites box files into single target table.
- Created multiple Data Flow Diagrams (DFD) to illustrate data movement within the system, conducted user training sessions and provided ongoing support to ensure successful adoption and utilization of tableau dashboards and reports after moving to production.
- Established best practices for managing large-scale datasets within the organization''s database systems.
- Presented complex findings in a clear and concise manner using compelling visualizations that resonated with both technical and non-technical audiences.
- Fixing any intermittent issues raise during production deployment and validations.
Sr. Software Engineer
INCEDO TECHNOLOGY
Pune
01.2021 - 12.2021
- Writing Splunk Queries, Expertise in searching, monitoring, analyzing and visualizing Splunk logs
- Hands on experience in customizing Splunk dashboards, visualizations, configurations using customized Splunk queries
- Developed Splunk queries and dashboards targeted at understanding application performance and capacity analysis
- Working on POC to implement Kafka Schema registry in Splunk Forwarder
- Built a python automation script, integrating Kafka schema registry and Splunk forwarder
- Having experience in understanding of Splunk 8.x product, Distributed Splunk architecture and components including search heads, indexers, and forwarders.
Developer
TATA CONSULTANCY SERVICES LTD
Pune
06.2020 - 01.2021
- Developed integration using TIBCO BW and Informatica Powercentre 9.x between Image Recognition platform and Oracle 11g/Postgresql database for Nielsen's collection application live in 27+ Countries
- Documenting data flow to create a layout for the integration
- Developing integration in Informatica Designer,TIBCO BW on above understanding and bring them to live after UAT
- Monitoring data flow and fix out issues if any identified in production
- Understand the business rules completely and implements the data transformation methodology using DDl, DML, Sub queries, joins, Procedures, Functions etc.
- Effectively engaged with internal stakeholders and end users of different regions including Europe, LATAM, China,SouthEastAsia at the pilot phase of the application, addressed technical issues and guided through resolution.
Developer
TATA CONSULTANCY SERVICES LTD
Pune
03.2020 - 01.2021
- Designed and developed Nielsen's online gaming application integration, a key application for Nielsen Auditors focused on the payroll. This allows Nielsen's representation of a total company in a given country and the scale of uncovered networks across 16 different clients, including Unilever, PepsiCo, Coca-Cola, etc
- Developed an integration on informatica powercentre 9.X using Mapping Designer and worked with Aggregator, Filter, Router, Joiner, Source Qualifier, Expression, Sorter and Sequence Generator transformations that supported 96 countries spread across different region
- Streamlining processes by setting up weekly calls with business COEs to discuss the business requirement as well as the production problems
- Supervised end-user support efforts, designing policies to establish consistent service guidelines and reliable ticket resolution
- Managed daily activities, assigned tasks to specific staff members and utilized proven management techniques to cut work flow downtime and maximize revenues
- Effectively engaged with internal stakeholders and end users at the pilot phase of the application, addressed technical issues and guided end users through resolution
- Creating KPIs and dashboards using Tableau and analyzing various KPI's and Application usage of 10,000+ Auditors across different regions including Europe, LATAM, China, SouthEastAsia
- Preparing Low-level and High-level designs for functional/Business Requirements
- Well versed with business process mapping, development and data mapping using query languages and ETL tools such as SQL,PL/SQL, Postgresql, Informatica powercentre, Tibco BW.
Developer
TATA CONSULTANCY SERVICES LTD
Pune
05.2019 - 02.2020
- Developed integrations for Nielsen Consumer Panel application using Informatica Powercentre 9.X to retrieve data from the Gpms system provided in the form of Flat Files and synchronize it with application using different transformations (Source Qualifier, Expression, Filter, Aggregator, Ranking, Joiner) and databases (Oracle 11g, Postgresql) as per business process and logic.
- Interacting with Business users of different regions (Europe, LATAM), gathering and analyzing requirements and involved in understanding the requirements of the end Users/Business Analysts and developed strategies for ETL processes
- With good leadership qualities, lead team of three during migration phase and delivered the project on time
- Streamlining processes by setting up weekly calls with business COE's to discuss the business requirements.
Developer
TATA CONSULTANCY SERVICES
Mumbai
01.2018 - 04.2019
- Creating the Dashboards and Analysing the financial net sales using Tableau as per business requirements
- Setting up stores in the application for recording the sales and extracting them to create weekly, daily, monthly and yearly reports
- Involved in performance tuning jobs process identifying and resolve performance issues
- Involved in creating database objects like tables, views, procedures, functions using oracle SQL, to provide definition, structure and to maintain data efficiently
- Produce financial net sales standard monthly and yearly reports using Tableau.
- Published Workbooks by creating user filters so that only appropriate teams can view it
- Access and transform massive datasets through filtering, grouping, aggregation, and statistical calculation
- Created consolidated scripts for finding the discrepancy in stage and target data
- Created integration in Informatica Powercentre to load financial sales data provided in form of flat files to target (Oracle 11g) by applying various transformations (Aggregator, Filter, Router, Joiner, Source Qualifier, Expressions)
- Handled Year end activity for LATAM, Europe and Japan region which required data setup in various PROD servers, created DML scripts for same which was used by all other teams
- Thorough analysis, unit testing and integrated testing with other applications of database objects & PL/SQL statements before deployment to the production server.
Education
Bachelor of Engineering Technology - Electrical, Electronics Engineering Technologies
Shri Shankaracharya Technical Campus
Bhilai,India 07.2013 - 05.2017
Higher Secondary School Certificate - Maths
Vishwadeep Senior Secondary School
Durg, India 06.2011 - 07.2012
Secondary School Certificate (10th Grade) -
Vishwadeep Senior Secondary School
Durg, India 06.2010 - 05.2011
Skills
Tableau
Informatica power centre
SQL/PL/SQLPostgresql/Greenplum
SplunkPythonAccomplishments
- Received Multiple Client Appreciation for handling production blockers and managing deliverables on time.
- Star performance award for successful migration of Gpms system to CDAR application and for resolving production server issues
- Two times Super star of the week for Enhancement and Migration activities
- On the Spot Award for resolving production issues
- Best Team Award
- Appreciation notes on Business/Communication Skills in Training period
- Multiple Appreciation from client for handling critical production issues and providing on time support.
Certification
BIPM : Informatica Powercentre Training - 3 Months
Timeline
Lead Consultant (Data Analyst- Tableau)
Genpact (GE Vernova)
12.2021 - Current
Sr. Software Engineer
INCEDO TECHNOLOGY
01.2021 - 12.2021
Developer
TATA CONSULTANCY SERVICES LTD
06.2020 - 01.2021
Developer
TATA CONSULTANCY SERVICES LTD
03.2020 - 01.2021
Developer
TATA CONSULTANCY SERVICES LTD
05.2019 - 02.2020
Developer
TATA CONSULTANCY SERVICES
01.2018 - 04.2019
Bachelor of Engineering Technology - Electrical, Electronics Engineering Technologies
Shri Shankaracharya Technical Campus
07.2013 - 05.2017
Higher Secondary School Certificate - Maths
Vishwadeep Senior Secondary School
06.2011 - 07.2012
Secondary School Certificate (10th Grade) -
Vishwadeep Senior Secondary School
06.2010 - 05.2011