Kirty Agrawal

Experience Highlights (Projects)

Domain Expertise:

• Federal
• Integrated Eligibility
• Government Public Sector
• Insurance
• Healthcare
• Banking

Key Achievements

• Improved data quality by 48% through implementation of data validation and data quality checks.
• Enhanced data integration efficiency by 45% through optimization of ETL processes.
• Successfully managed multiple projects, resulting in 25% reduction in project timelines and 20% reduction in project costs.
• Led team of 15 members to deliver large-scale data warehousing project, resulting in 50% increase in business insights and 30% increase in data-driven decision-making.

Team Leadership: Managed teams of 15 and 10 members, respectively, in Federal and Insurance domains, ensuring successful project delivery.
Demonstrated strong Scrum Master skills, facilitating Sprint Planning, Refinement, Review, and Retrospective activities. Worked as the Scrum Master for the Development and Testing Team and successfully delivered close to 300 plus stories over 24 Sprints.

ETL Design: Designed and developed jobs using SSIS and Informatica, enhancing data accuracy and reconciliation.
Implemented performance tuning in Informatica, reducing data load time by 90%.
Developed and modified stored procedures and SSIS packages to meet project requirements.

Reports Expertise: Designed close to 250 Canned Reports and Dashboards using Tableau with high performance

Domain Expertise: Demonstrated proficiency in various tools and technologies, including SSIS 2019, 2015,2022; Oracle SQL Developer; PostGres;Tableau; Bit Bucket; IBM DB2; SAP Data Services Designer; Version One; Informatica Power Center 10.1.1; SQL Server; MS Visual Studio/SSIS; Tidal Enterprise; and CA Automic tool

Project Management: Successfully managed projects in various domains, ensuring timely delivery and high-quality results.
Utilized Agile methodology using Jira and version control systems to streamline project workflows.

Training and Mentoring:

• 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
• Managed cross-functional teams to ensure timely delivery of high-quality solutions for various projects
• Streamlined project management processes, improving efficiency and reducing overall costs

Role: ETL Developer
Domain Description:
Worked for one of the largest provider of supplemental insurance in US. IT provides insurance for individuals and groups to help pay benefits your major medical insurance doesn't cover.
Responsibilities:
• Designed & developed jobs using SSIS and Informatica.
• Worked on various IRs and SCRs as a part of enhancement.
• Worked on Agile Methodology using version One.
• Got trained in SAP BODS (ETL) and started working on it from Day one in the project.
• Lead a team of 4 in the project to implement value add for data accuracy and reconciliation.
• Trained a team of new hires in the firm in SQL and ETL Concepts. Supported clients with business analysis, documentation, and data modeling.

• Analyzed data sets to identify trends and opportunities for process improvements within client organizations.
• Prepared presentations to explain revisions, enhancements and process improvements of organization's systems and programs.
• Mentored junior consultants, fostering professional growth and building strong team dynamics.
• Designed tailored training programs for employees at various levels within the organization, boosting overall skillsets.

• Worked as Informatica Developer and ODI Developer.
• Developed and maintained major codes under team.
• Supported system users, educating employees on troubleshooting and problem-solving protocols.
• Contributed towards continuous improvement initiatives aimed at streamlining internal processes and enhancing overall service delivery quality.