STEFFIN PAINEL
Manager
Bengaluru,KA
Summary
Highly motivated Business intelligence professional with 9+ years of experience in Informatica Development, Report Development and Database Development. Demonstrated leadership abilities and team work skills as well as the ability to accomplish tasks under minimal direction and supervision. Proven history of utilizing strong anaytical skills, attention to detail and hard work ethics to turn complex requirements into working systems.
Overview
1
1
Language
3
3
Certifications
4
4
years of post-secondary education
9
9
years of professional experience
Work History
Specialist
SUN LIFE FINANCIALS
GURGAON, HARYANA
05.2014 - Current
- Managing a agile team that uses Kanban Approach for the current project (enterprise date lake)
- Reviewed requirements, specifications and technical design documents to provide timely and meaningful feedback.
- Designing and developing new ETL code, enhancement to the existing code, Data Migration, Data Integration, Unit Testing, System Integration Testing, UAT Support, Code
Deployment, Production deployment and warranty support. - Hands on experience in data masking, data
profiling, data generation, data
warehousing using Informatica Power Center &
Power Exchange(9.6, 10.2HF1 & 10.2HF2,10.4.1), Informatica
IICS. - Worked on integration and development for
Salesforce based applications using Informatica Powercenter. - Experience in creating and scheduling Jobs using ZEKE(Mainframe)
- Worked with Administration of Business intelligence reporting suite at the enterprise level and worked on configuration, utilization and management of CMC, Infoview Explorer.
- Interfaced with cross-functional team of business analysts, developers and technical support professionals to determine comprehensive list of requirement specifications for new applications.
- Provided reporting solutions to business using Crystal reporting tool.
SOFTWARE ENGINEER
ENTAB INFOTECH
NEW DELHI, DELHI
08.2011 - 05.2014
- Understand the requirement by business
- Analyzing different user requirments and coming up with specifications for the applications
- Identifying issues with the database and resolving them
- Design solution for the requirement given by the client
- Plan, design, and implement application database code objects such as stored procedures and views
- Managed the migration of SQL server 2000 databases to SQL Server 2005
- Build and maintain SQL scripts, indexes and complex queiries for data analysis and extraction.
- Perform validation and verification of product deployment in production
- Build Complex reports for Schools using Crystal reports XI R4.
- Enhance/ Modify existing reports by creating Parameters, formulas
- Performance Tuning for SQL Queries
Education
Bachelor of Engineering - Electronics And Telecommunication
St. Vincent Palloti College Of Engineering And Tec
Nagpur 08.2007 - 04.2011
Skills
Informatica Powerenter 1041
Informatica PowerExchange 1041
Informatica Cloud
Date Warehousing
Batch Scripting
Crystal Reporting
SQL Development
MS SQL Server 2014/POST GRES SQL/ DB2
SAP Business Object XI
Business View Manager
Webi Reports
Interpersonal Communication
Teambuilding
Planning and Coordination
Accomplishments
- GEM Award for ability to pick up work in multiple technology areas and supporting varying delivery needs
- SHINING Star - Recognized by various business partners for excellence, Customer focus and building value
Certification
LOMA 281
Timeline
ITIL Foundation
07-2017
Insurance Basics
04-2016
LOMA 281
08-2015
Specialist
SUN LIFE FINANCIALS
05.2014 - Current
SOFTWARE ENGINEER
ENTAB INFOTECH
08.2011 - 05.2014
Bachelor of Engineering - Electronics And Telecommunication
St. Vincent Palloti College Of Engineering And Tec
08.2007 - 04.2011