Sheetal Limhan

Experience

• 

  Tata Consultancy Services

  Oct 2012 - Feb 2016

  Developer

  Project / Client Name / Location / Company– OEDM / MORGAN STANLEY/ Pune/ TCSPeriod: March 2012 to August 2015Technologies – Informatica, Data warehousing, DB2, SQL and PL/SQL, UNIX, Autosys, Business ObjectsDescription:DataMart, for storing the data related to Orders of various MS's financial products, to be built as part of this project. Informatica was majorly used to extract the data from various sources, transformed as per the business needs. DB2 was used as the database platform at the various stages and as the base for all the Business Objects based reports. Role: DeveloperContribution / Highlights:1. Attending client calls to discuss requirements, solutions and issues and document it.2. Worked on different Informatica Components to develop complex mappings, mapplets, Sessions, Workflows to process huge volume data in time critical window. Analysis of requirements of enhancement for the project and impact analysis.3. Providing fixes to the issues identified in testing phase.4. Provide production support for the deployed project.Project / Client Name / Location/ Company –Customer Value Management/Aviva/ Pune/TCSPeriod: September 2015 to Jan 2016Technologies – Informatica 9.5.1, Data warehousing, Teradata, UNIX, Tivoli Description:System to capture the services opted by the customer and provide reports to the client based on that. The Database stores information about the Insurance Policies, its related information and the Customers feedback on it.Role: DeveloperContribution / Highlights:1. Worked on different tools like Informatica, database, UNIX and Tivoli Components to develop code to process huge volume data in time critical window.2. Analysed requirements of enhancement for the project and impact analysis.3. Unit testing and system integration testing of the developed code.4. Analysing the issues with the code in various phases. Show less

• 

  Cognizant

  Feb 2016 - Apr 2017

  Project Associate

  Project / Client Name / Location /Company– RCM-DSS Integration/ Sanofi/ NEW JERSEY US/CognizantPeriod: Feb 2016 to April 2017Technologies – Informatica 9.5.1, Data warehousing, ORACLE, PL/SQL, UNIX SCRIPTING, TIDAL, TableauRole: DeveloperDescription:The project is to upgrade the existing DSS system to point to the RELTIO-based Source (named Central client) from the Legacy source system. The main objective is to update the DSS system in order to incorporate these changes using Informatica and PL/SQL. Tableau used as reporting tool.Responsibilities:1. Understand the existing system and come up with new systems as per the customers' requirement2. Develop ETL code using Informatica to implement the business requirements.3. Design workflows with many sessions with decision, assignment task, event wait, and event raise tasks, use tidal scheduler to schedule jobs.4. Review and analyse functional requirements and mapping documents.5. Performed unit testing at various levels of the ETL and actively involved in team code reviews.6. Created Tableau Dashboards and Story for developing Business Intelligence dashboards7. Extensively used Tableau reporting functionalities such as Hierarchy, Grouping, Calculated Fields, Filters, Ranking, Parameters, Graphs, Forecasting, Trend & Reference Lines.8. Created heatmap using state and county level geographies to give better visualization for Business to identify troublesome states and counties using drilldown Show less

• 

  Wipro

  Aug 2017 - Sept 2018

  Senior software

  Project / Client Name / Location /Company– Recon Factory Non-Swiss/ Credit Suisse/ Switzerland/Wipro TechnologiesPeriod: August 17 to presentTechnologies – Intellimatch, Informatica, Control M, MS SQL server 2008, UNIX, TableauClient: Credit SuisseRole: DeveloperDescription:System to match the trades and Cash data from ledgers and statement side to avoid any kind of loss.Informatica is basically used to pre-process the files from both the sources (ledgers and statements).Intellimatch is the tool used for reconciliation with SQL Server 2008 as the backend database.Control-M is used as scheduling tool to run different processes. Tableau reports are generated over the Database.Responsibilities:1. Analysing, providing solutions and developing the code for the new and existing Recs.2. Worked on the change request from the client.3. Worked on complex mappings to process huge XML files through informatica and load it to database.4. Coordinating with the client to close all the queries before and post deployment.5. Review and analyse functional requirements and documents at each phase of the SDLC.6. Investigating and fixing the bugs occurred in the production environment and providing the on-call support.7. Analysing user requirement, validating available data, propose a usable design and develop on tableau server.8. Development of a new set of reports, dashboards and story9. Creating solution driven views and dashboards by developing different chart types including Line Chart, Bar Chart, Pie Chart, Scatter Plots, Heat map10.Implemented Tableau features such as parameters, calculated fields, groups and filters to implement business logics11. Connecting and extracting data from different data sources 13. Understanding and implementing best practices of data visualization Show less

• 

  Accenture

  Oct 2018 - Sept 2021

  Senior Software Engineer
• 

  Datametica

  Sept 2021 - Apr 2022

  Technical Lead
• 

  Coforge

  May 2022 - now

  Data Specialist