SUMMARY:

• Over 8 plus years of IT experience in the Analysis, Design, Development, Testing, and Implementation of business application systems for Medical Devices, Pharmaceutical, Financial, Insurance and Technology Sectors.
• 6 plus years of experience as Informatica ILM developer.
• Involved in around 300 plus applications Retirement archival on various RDBMS like Oracle, SQL server, DB2.
• Archived and Retired various SAP ERP and ECC applications using Informatica ILM accelerators
• Experience with various reporting tools like Jreport, Cognos, QLIK and Tableau.
• 2 years of experience as Informatica ETL developer in the analysis, development, testing and implementing.
• Archived the structured files using PowerExchange into Informatica ILM
• Archived the unstructured files using Metalogix and Informatica ILM
• Experience in live archival for various applications
• Installed Informatica ILM Data archive products (Data archive and FAS) in windows and Linux environments
• Created Custom entities with Business rules for online archive and file archive.
• Good knowledge in standalone jobs create tables, create indexes, create archive folder
• Good knowledge in Data type Mapping.
• Restored online archive data using transaction restore, cycle restore and full restore.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Strong with relational database design concepts
• Team player, motivated, quick learner with analytical and problem solving skills

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX and Linux

Programming Languages: SQL, PL/SQL

ETL,Data Integration/Archiving tools: Informatica ILM Data Archive 6.4, Informatica DVO, Informatica Power center 9.x, Informatica PowerExchange, IBM Optim and Metalogix

Databases: ORACLE 11g/12c, SQL Server 2014, MySQL, DB2, Netezza

Scripting Languages: Perl, Shell Scripting, HTML/XML

Reporting Tools: Jreports, Cognos, TABLEAU and QLIK view

Cloud Technologies: AWS, Salesforce

PROFESSIONAL EXPERIENCE:

Confidential, Raritan, NJ

Databases & Reporting Tools: Informatica ILM, Jreports, Cognos, QLIK View Reports, Oracle 11g/10g, MS SQL Server 2010/2008/2005 , DB2 AS400, Jreports, Cognos, QLIK and Tableau

Operating Systems: Windows 98/XP/2000/Windows 7, Windows 8, UNIX, LINUX

Programming Languages: SQL and PL/SQL

Responsibilities:

• Requirements gathering from business team for structured and unstructured data and thoroughly analyze their requirements.
• Analyze tables relationship then creates schema and entities based on tables, mining them with ILM, export/import entities.
• Create source and target connections along with target folders creation.
• After defining roles retention policies and groups with entities, run the archival jobs.
• Creation of table and web reports using various reporting tools like Jreports, Cognos and QLIK View reporting tools.
• Documents creation for all Development, QA, and Production environments and get the approval wherever required from business unit and other stockholders.
• Maintain and update Archive Services standards documents and work instructions that can be presented to clients as deliverable examples.
• Development of shell scripts and PL/SQL to execute the jobs that are being invoked by the Informatica process.
• Ensure all deliverables are accounted for and prepared in a profession manner for client delivery.
• Ensure work task implementation and delivery is on time.

Confidential, Raritan, NJ

Databases & Tools: Informatica ILM, Jreports, Cognos, QLIK View Reports, Oracle 11g/10g, MS SQL Server 2010/2008/2005 , DB2

Operating Systems: Windows 98/XP/2000/Windows 7, Windows 8, UNIX, LINUX

Programming Languages: SQL and PL/SQL

Responsibilities:

• Requirements gathering from SAP business team and thoroughly analyze their requirements.
• Installing and configuring the SAP transports and SAP Java connector in both SAP servers and ILM servers which enables ILM servers to connect the SAP server and then extract the data.
• Analyze tables relationship and import the data structures into ILM by using Data mining option.
• Creation of logical objects called Entities in ILM by grouping SAP tables based on their modules.
• Creation on Source, target connections along with user roles, retention and legal hold.
• Scheduling archival jobs for all SAP created entities along with retention and legal hold.
• Configuring the SAP standard reports and creation of SAP custom reports based on the user requirements using reporting tools like Jreports, Cognos and QLIK View.
• Documents creation for all Development, QA, and Production environments and get the approval wherever required from business unit and other stockholders.
• Maintain and update Archive Services standards documents and work instructions that can be presented to clients as deliverable examples.
• Development of shell scripts and PL/SQL to execute the jobs that are being invoked by the Informatica process.
• Ensure all deliverables are accounted for and prepared in a profession manner for client delivery.
• Ensure work task implementation and delivery is on time.

Confidential, Raritan, NJ

Databases & Tools: Metalogix

Operating Systems: Windows 98/XP/2000/Windows 7, Windows 8, UNIX, LINUX

Programming Languages: SQL

Responsibilities:

• Requirements gathering from business team for Unstructured applications.
• Provisioning the space in windows NAS drives or AWS S3 buckets to users for copying the unstructured files into staging directory.
• Configuring and scheduling archival jobs using Metalogix tool.
• Applying the retention and legal hold based on user requirements.
• Performed Data Verification using HP - ALM tool. Maintain and update Archive Services standards documents and work instructions that can be presented to clients as deliverable examples.
• Ensure all deliverables are accounted for and prepared in a profession manner for client delivery.
• Prepare and complete the standard checklist of post archive deliverables ensuring all supporting documentation specified in the checklist is organized, accurate and complete.
• Ensure work task implementation and delivery is on time.