Trekking
Prachiti Kekre
Sr. Advisor Data engineering
Summary
Detail-oriented data engineer with expertise in designing, developing, and maintaining highly scalable, secure, and reliable data structures. Collaborates closely with system architects, software architects, and design analysts to understand business or industry requirements and develop comprehensive data models. Proficient in developing database architectural strategies at the modeling, design, and implementation stages. Responsive expert experienced in monitoring database performance, troubleshooting issues, and optimizing the database environment. Possesses strong analytical skills, excellent problem-solving abilities, and a deep understanding of database technologies and systems. Equally confident working independently or collaboratively as needed and utilizes excellent communication skills.
Overview
13
13
years of professional experience
Work History
Sr Advisor Data Engineering
Dell Technologies
11.2021 - Current
- Mentored junior advisors, fostering professional development and enhancing overall team performance.
- Established strong partnerships with key stakeholders through consistent communication and collaboration efforts, promoting mutual success.
- Enhanced client relationships by providing strategic advice and guidance on industry trends and best practices.
- Maintained database systems to track and analyze operational data.
- Collaborated with cross-functional teams to develop tailored solutions addressing specific client pain points related to data management and analysis.
- Fostered strong relationships with clients by providing timely, relevant, and actionable insights through effective communication of complex analytics findings to non-technical stakeholders.
- Increased efficiency in database management by optimizing SQL queries and automating routine tasks through scripting languages like Python or R.
- Optimized data processing by implementing efficient ETL pipelines and streamlining database design.
- Collaborated on ETL (Extract, Transform, Load) tasks, maintaining data integrity and verifying pipeline stability.
- Enhanced data quality by performing thorough cleaning, validation, and transformation tasks.
- Migrated legacy systems to modern big-data technologies, improving performance and scalability while minimizing business disruption.
- Conducted thorough code reviews to identify potential issues, maintaining a high standard of quality throughout the development process.
- Streamlined data integration efforts by developing reusable components that enhanced productivity across multiple projects.
- Managed project timelines effectively by prioritizing tasks according to urgency while maintaining superior standards of quality in deliverables.
Sr Consultant
Saama Technology
02.2019 - 10.2021
- Was involved in requirements gathering and business discussion with key stakeholders
- Worked closely with Customer Business team during planning and designing of key BI solutions
- Provide weekly reports on project status, budget, schedule, outstanding issues, off-shore resource utilization
- Facilitated discussions with end-users / managers to gather functional requirements
- Manage & support issues by understanding & resolving Post-Production Issues
- Manage day-to-day operational aspects of project including regular project communication with project team, larger implementation team, stakeholders & sponsors
- Co-ordinated course correction approaches and risk identification & mitigation during entire implementation
- Environment: Unix, Windows, Informatica Power center 10.1, Sales Force, Sap3, Informatica Developer, Oracle 18c
- Mentored junior consultants, helping them enhance their skills and contribute more effectively to projects.
- Prioritized projects and project tasks depending upon key milestones and deadline dates.
- Troubleshot issues by understanding issue, diagnosing root cause and coming up with effective solutions.
- Collaborated with internal teams to develop customized solutions that addressed unique client needs.
- Built strong relationships with clients through consistent communication and proactive problem-solving efforts.
Sr. Data Analyst
Tata Consultancy Services
01.2018 - 02.2019
- Leading the development team of 8 to 10 member
- Worked on functional & mapping specification
- Complex mapping design for history & incremental data load
- Learned & implementation of job scheduling by using tool Autosys
- Data extraction from SAP R3
- Understanding the business needs for the same
- Deploying the data and integrity to sales force dot com
- Writing the program code in Informatica Power Center to create the mappings and sessions in accordance with requirements
- Writing SQL's used in Source Qualifier queries and PL/SQL for stored procedures
- Data Modeling & Dimensional modeling for new modules
- Providing solution to improve the system process & performance
- Closely working with Architect team to synch the end to end project architecture
- Communicating with client to track the process gaps & finding solution
- Understanding & documenting the design overview of ETL mapping & related code
- Worked to automate the release & deployment process standardized by client
- Co coordinating with team to resolving issues & gaps
- Closely worked with client end user to understand the issues and resolve the same after the warranty period
- Environment: Unix, Windows, Informatica Power center 10.1, Sales Force, Sap3, Informatica Developer
- Reduced manual data entry errors by designing and deploying automated ETL processes to transform raw data into usable formats.
- Contributed to overall organizational growth through continuous improvement of data analytics capabilities and processes.
- Analyzed large amounts of data to identify trends and find patterns, signals and hidden stories within data.
Module Lead
Tata Consultancy Services
04.2015 - 06.2017
- Leading the module of 20 member development/support team
- Involved with Proposal writing to Design Process of Functional Design to Technical Design & ETL Spec
- Working with a developer resource on multiple modules of project like nostro, Depot reconciliation
- Actively involved in Requirement gathering of most of the share points of the project
- Sprint planning and documentation
- Dividing the Jira task among the technical teams
- Prepare detailed design in accordance with requirements and specifications
- Writing the program code in Informatica Power Center to create the mappings and sessions in accordance with requirements
- Writing SQL's used in Source Qualifier queries and PL/SQL for stored procedures
- Code changes and enhancements through client request
- Organize weekly, fortnightly and monthly project calls and assign tasks to team members
- Develop and deliver progress reports, proposals, requirements documentation, and presentations
- Used Scheduler to Create, Schedule, and Monitor and Send the Messages in case of process failures
- Technical Support to the Team and as well as Client
- Production support, Debug the issue, Monitor the jobs
- Tuning of Jobs to improve the performance by using explain plan, system performance, debugger
- Releasing & sign off the Patches deployment
- Maintain the Versioning of the object by using Central Repository
- Test mapping to assure that data is loaded as per ETL Specification
- Deployment of ETL & Database objects into UAT & Pre-production
- User testing and UAT sign off
- Leading the team for assigning the work
- Involve in Co-ordinate between Client & Development
- Environment: Oracle, Unix, Windows, Informatic PC, Intellimatch, Sql Server
Developer
JPMC
12.2011 - 03.2015
- This project is all about to maintain the Datawarehouse
- Feed files (including trade, employee and client) come from different regions (including Asia pacific, London, New York and Tokyo) are processed and segregated to the Oracle database which leads to the formation of data warehouse
- Informatica, an ETL tool is used to transform and migrate the data from Data warehouse (Oracle DB) to Data Mart (Vertica DB) which is further processed for Client Reporting
- Working as a developer resource on multiple modules of project like Data Manipulation Application (DMA), Coverage Employee and Data Mart
- Actively involved in Requirement gathering of most of the share points of the project
- Prepare detailed design in accordance with requirements and specifications
- Writing the program code in Informatica Power Center to create the mappings and sessions in accordance with requirements
- Writing SQL's used in Source Qualifier queries and PL/SQL for stored procedures
- Writing Shell programs to carry out the database operations and to invoke the Informatica workflows
- Prepare the test case document and perform unit testing and functional testing as per the system requirements
- Perform peer review as a part of auditing
- Schedule Knowledge transfer sessions for the new associates join the project
- Provide UAT support after code getting deployed to UAT
- Environment: Informatica Power Centre, Unix, Autosys, Oracle, Vertica
- Wrote and optimized in-application SQL statements.
- Implemented proactive monitoring solutions for ETL processes, identifying potential bottlenecks before they impacted users.
Education
Bachelor of Engineering - Information Technology
Sant Gadge Baba Amravati University
Amravati, India 04.2001 -
Skills
UNIX
Windows 2000 Professional
Win XP
DOS
PL/SQL
Shell Scripting
Oracle 11g
MS SQL
Teradata
SFDC
Informatica Power Center
Power Exchange
Cognos
BO
Intelimatch
RELTIO
Teradata
Memsql
Power BI
Power Shell Scripting
UNIX
VERTICA
Control M
SAP R3
Currentemployer
Dell Technologies
Interests
Travelling
Timeline
Sr Advisor Data Engineering
Dell Technologies
11.2021 - Current
Sr Consultant
Saama Technology
02.2019 - 10.2021
Sr. Data Analyst
Tata Consultancy Services
01.2018 - 02.2019
Module Lead
Tata Consultancy Services
04.2015 - 06.2017
Developer
JPMC
12.2011 - 03.2015
Bachelor of Engineering - Information Technology
Sant Gadge Baba Amravati University
04.2001 -