Sr. Programmer Analyst Resume
SUMMARY
- Strong credentials in designing, implementing and supporting technical solutions for Product based and Service based IT services. Received multiple appreciations organization wide for delivering cost effective solutions as per business requirements and track record of on - time delivery.
- Dynamic and accomplished professional with around 7 years of experience in Information Technology and Services industry.
- Having 7 yrs. of experience in IT industry.
- Undergone professional training in Oracle 9i form.
- Worked Extensively on Informatica Power Center tool.
- Worked on Java, JSP, HTML, Informatica 8.6.1, PL/SQL programming, SQL, Querying & Stored procedures and D2K.
- Good self-learning capabilities and quick learner in new technologies and proved productive within short period of time.
- Good communication skills and excellent team player.
- Managed team of 10-15 resources.
TECHNICAL SKILLS
Languages: Java,PL/SQL,SQL, Shell Scripts
App/Web Servers: Tomcat
Databases: Oracle 9i,Oracle 10g
Web Technologies: Java Script, HTML, XML
Tools: Informatica Power Center 8.6.0 and 9.0.1, FCI (Reporting tool), Actuate 8, BIRT and TOAD
Operating Systems: UNIX, Linux, Windows
PROFESSIONAL EXPERIENCE
Confidential
Sr. Programmer Analyst
Responsibilities:
- Prepare the HDL (High level Design) and LLD (Low Level Design)
- Create PDM (Physical Data Model).
- Requirement Analysis through business model and functional model.
- Developed Java Application,Ext JS,modules, Informatica 9.0.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
- Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
- Effectively involved in test data preparation and code review.
- Attending Daily client calls for Project discussion.
- Actively involved in Defect solving in SIT, UAT and PROD testing phase
Confidential : Java, Ext JS, Informatica Power Center 9.0.1, SQL Developer, Shell Scripts
Confidential
Tech Lead
Responsibilities:
- Reduce operational risk through process change, improved data quality and Automation.
- Improve reporting and analysis capabilities, reliability and timeliness.
- Improve the quality, accuracy, and consistency of all data coming into business by providing a unified capability for acquisition of data and proactive management of upstream SLA.
- Reducing the time and cost of data cleansing activities by doing it once as the data model created and complex data sourcing logic in multiple application.
- Doing Changes in LLD (Low Level Design) PDM (Physical Data Model) and new CR.
- Requirement Analysis through business model and functional model.
- Developed Informatica 9.0.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
- Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
- Effectively involved in test data preparation and code review.
- Attending Daily client calls for Project discussion.
- Actively involved in Defect solving in SIT and UAT testing phase
Confidential : Informatica Power Center 9.0.1,SQL Developer, Shell Scripts.
Confidential
System Engineer
Responsibilities:
- Developed Informatica 8.6.1 mappings/Workflows using various transformations like
- Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
- Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
- Effectively involved in test data preparation and code review.
- Attending Daily client calls for Project discussion.
- Actively involved in Defect solving in SIT and UAT testing phase.
- Attending Daily client calls for Project discussion.
- Monitoring the Dashboard DAC
Confidential : Informatica Power Center 8.6.1, OBIEE(reporting Tool), SQL DeveloperShell Scripts.
Confidential
Senior Software Engineer
Responsibilities:
- Prepare the HDL (High level Design) and LLD (Low Level Design)
- Create PDM (Physical Data Model).
- Requirement Analysis through business model and functional model.
- Done the Data Profiling in informatica Power Center 9.0.1.
- Developed a Metadata as per the data model for Project work.
- Developed Informatica 8.6.1 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
- Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
- Effectively involved in test data preparation and code review.
- Attending Daily client calls for Project discussion.
- Actively involved in Defect solving in SIT and UAT testing phase
Confidential : Informatica Power Center 8.6.1, BIRT,FCI,Jasper(reporting Tool), SQL DeveloperShell Scripts. Java,JavaScript
Confidential
Senior Software Engineer
Responsibilities:
- Reduce operational risk through process change, improved data quality and Automation.
- Improve reporting and analysis capabilities, reliability and timeliness.
- Improve the quality, accuracy, and consistency of all data coming into Finance by providing a unified capability for acquisition of data and proactive management of upstream SLA.
- Reducing the time and cost of data cleansing activities by doing it once as the data enters the gateway and Eliminating redundant and complex data sourcing logic in multiple application.
- Requirement Analysis through business model and functional model.
- Developed a Metadata as per the data model for Project work.
- Developed Informatica 8.6 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
- Improved Performance by selecting all Dimension LKP cache as persistent and reused those caches for Fact loads.
- Effectively involved in test data preparation and code review.
- Attending weekly client calls and Video conference for Project discussion.
- Actively involved in Defect solving in SIT and UAT testing phase.
Environment: 2 Tier Architecture.
Confidential
Senior Software EngineerResponsibilities:
- Working as a developer for the entire modules.
- Responsible for timely development and release of modules in phases.
- Involved in Problem Solving and maintaining a constant interaction with the Onsite and Configuration team for speedy closure of development related issues.
- Requirement Analysis through business model and functional model.
- Developed a Metadata as per the data model for Project work.
- Developed Informatica 8.6 mappings/Workflows using various transformations like Expression, Router, Update strategy, Connected and Unconnected lookup’s, Aggregator, Sorter, Sequence generator etc and having files as a source and targets along with database objects.
- Developed test cases and unit testing, conducting peer reviews of all my mappings before moving it to production.
- Effectively involved in test data preparation and code review.
- Attending weekly client calls for Project discussion.
- Actively involved in Defect solving in SIT and UAT testing phase
Environment: 2 Tier Architecture.
Confidential
Senior Software EngineerResponsibilities:
- Working as a developer for the entire two modules.
- Responsible for timely development and release of modules in phases.
- Monitoring Patch releases to QC and Onsite team.
- Involved in Problem Solving and maintaining a constant interaction with the Onsite and
- Configuration team for speedy closure of development related issues.
.