Simi S
Kayamkulam
Summary
Results-driven IT professional with 12+ years of experience specializing in implementing Data Warehousing using Informatica Power Center 10.4. External certified expert in AWS Cloud Practitioner, Azure Fundamentals, AWS Solution Architect, and Power BI PL 300. Instrumental in successfully completing an Insurance reporting project utilizing Power BI and DAX measures. Involved in the entire DWH life cycle development process, from analysis and documentation to design, implementation, testing, and maintenance. Strong skills in preparing design documents, mapping specifications, cut-over documents, and production run books. Keen ability to understand the business rationale behind projects and effectively address technical issues while ensuring alignment with program goals.
Overview
14
14
years of professional experience
1
1
Certification
Work History
Technical Consultant
EY
09.2021 - 12.2024
- Developed and implemented end-to-end data models for Guidewire ClaimCenter and DuckCreek Policy & Billing Systems, specifically tailored for Homeowners insurance,ensuring seamless data integration and Operational efficiency.
- Created comprehensive documentation detailing technical specifications, system configurations, procedures, and user guides for reference purposes both internally and externally for clients.
- Maintain data mapping specification documents for refined layer
- Define and maintain data mapping and transformation rules
- Communicate data model designs and strategies to technical and non-technical stakeholders
- Provide training and support to team members on data modeling best practices
- Responsible for designing and developing interactive dashboards and reports using DAX language and ensuring data accuracy and integrity.
- Enhanced system performance by identifying and resolving technical issues through troubleshooting and root cause analysis.
- Facilitated knowledge transfer among team members by leading training sessions on new tools, techniques, or industry best practices relevant to the role of Technical Consultant.
Assistant Consultant
Tata Consultancy Services
02.2019 - 09.2021
- Led team of 7 members in developing Informatica based ETL jobs
- Adapted quickly to changing project priorities and job specifications with analytical thinking and task prioritization skills.
- Processed large volumes of data using advanced analytical techniques, uncovering valuable insights for informed decision making.
- Served as point of contact for clients regarding follow-up, meeting scheduling, and responses to questions.
- Optimized customer experience by delivering superior services and effectively troubleshooting issues.
- Identified potential risks early in the project lifecycle, enabling proactive mitigation strategies to minimize negative impact on timelines or budgets.
Associate
Cognizant Technologies Solutions
05.2011 - 02.2019
- Migrated Informatica components from Informatica 9.1 to 9.6 version
- Developed and implemented strategies to increase customer satisfaction and engagement.
- Designed Informatica workflows that are callable from a .NET based GUI
- Supported Testing team to prepare input templates (both csv and xlsx) for different companies (Legal entities)
- Supported QA team in providing solutions to the issues identified during system integration testing
- Worked with Client/BA to gather requirements, provide explanation to SIT/UAT issues
- Established strong relationships with key stakeholders, facilitating effective communication across departments and teams.
- Enhanced team productivity by streamlining communication and implementing efficient project management tools.
Education
MTech - Software Management
VIT
B.Tech - Information Technology
College of Engineering
Skills
- INFORMATICA Power Center 10x
- Power BI
- Oracle 11g
- SQL Server
- Teradata
- Azure ADF
- AWS S3
- Functional Area: Insurance
- Functional Area: Healthcare
- Autosys
- GIT
- Data warehousing
- Client rapport
- Business analysis
- Team Collaboration
- Problem-solving
- Active Listening
- Team Leadership & Development
Accomplishments
EY Innovation Award
EY Spot Award
TCS Excellence Award in 2020
CTS Kochi Star Award Winner 2012-13
Certification
- AWS Certified Solution Architect - March 2021
- AWS Certified Cloud Practitioner - Jan 2021
- Microsoft Certified Azure Fundamentals - Nov 2021
- Microsoft Certified: Power BI Data Analyst Associate - May 2022
Timeline
Technical Consultant
EY
09.2021 - 12.2024
Assistant Consultant
Tata Consultancy Services
02.2019 - 09.2021
Associate
Cognizant Technologies Solutions
05.2011 - 02.2019
B.Tech - Information Technology
College of Engineering
- AWS Certified Solution Architect - March 2021
- AWS Certified Cloud Practitioner - Jan 2021
- Microsoft Certified Azure Fundamentals - Nov 2021
- Microsoft Certified: Power BI Data Analyst Associate - May 2022
MTech - Software Management
VIT
Similar Profiles
Mariano PietragalloMariano Pietragallo
DevOps Engineer at EYDevOps Engineer at EY
Mir Mohamed Fazal Mir Mohamed Fazal null
Project manager at EYProject manager at EY
Mayur PatilMayur Patil
SOFTWARE ENGINEERING MANAGER at EYSOFTWARE ENGINEERING MANAGER at EY