SUMMARY:

• 9+ years of IT experience with extensive experience in Database, Business Intelligence, Data Analysis, Reporting, ETL and CRM Salesforce (Veeva).
• Experience in Informatica Cloud, extracting data from salesforce.com and after transformation loading data in Database.
• Architect and guide the project teams during full lifecycle project phases, going through requirements gathering, end user interaction, data analysis, data profiling, extraction and transformations, data modeling, Reporting/ Dash boarding - leveraging the appropriate data Integration, modeling and Visualization tools
• Experience in loading data to Salesforce.com cloud using Informatica Cloud.
• Experience in creating architecture of Database, Business Intelligence and Veeva .
• Extensive Database experience using Informatica Power Center as ETL tool.
• Experience in Business Intelligence (SiSense and Tableau).
• Experience in understanding customer requirement and create Business Process Model as per the requirements.
• Experience in creating enterprise logical model (EDM) as part of the information management framework which contains all entities and their relationships and a complete set of documentation.
• Experience in translating the logical model into a physical model and adding the appropriate physical objects needed to create the database e.g. indexes
• Experience in analyzing the requirements and creating database, development and staging areas, and source systems as per business and technical requirements.
• Experience in creating reports using SiSense.
• Experience in Creating ETL packages using Informatica.
• Experience in migrating data from Siebel to Salesforce using Informatica.
• Experience in migrating data from Salesforce to Salesforce using Informatica.
• Experience in creating Elastic Cube using SiSense.
• Experience in creating Report Type, Report and Dashboard in Salesforce (Veeva).
• Experience in Loading/extracting data into/from Veeva using APEX jobs and Apex data loader.
• Experience in working with SQL developer.
• Experience in performance tuning of Informatica Sources, Targets, Mappings and Sessions. Highly proficient in processing tasks, scheduling sessions, import/export repositories, manage users, groups, associated privileges and folders.
• Strong experience in coding using SQL, PL/SQL Procedures/Functions and Triggers.
• Extensively used SQL and PL/SQL to write Stored Procedures, Functions and Triggers.
• Self-motivated, able to set effective priorities to achieve immediate and long-term goals and meet operational deadlines.
• Good knowledge of databases like Oracle.
• Understanding of Salesforce CRM, Salesforce Database Structure.
• Excellent Communication skills, hardworking, highly enthusiastic and good problem solving abilities.
• Ability to learn and implement different languages and complete projects in the given timeframe.
• Work with the Onsite and Offshore lead's to establish a collaborative environment between technology and the other disciplines.
• Gathering requirements from customer and translating them in technical and performing estimation as per technical requirements.

TECHNICAL SKILLS:

ETL / BI: BI (SiSense, Tableau) Informatica (Power Center), Informatica Cloud, CRM Salesforce (Veeva)

CRM Tools: Apex jobs, Veeva Reporting, Veeva Configuration. Salesforce CRM, Salesforce Database Structure, Oracle OnDemand

Languages: SQL, PL-SQL, UNIX Shell Scripting, Windows Batch Programming

Database: Oracle

Operating Systems:: Windows, UNIX

Software Tools: MS Word,MS Excel,MS Visio (user)

PROFESSIONAL EXPERIENCE:

Confidential, New Providence, NJ

Data Architect

Technologies: SiSense, Informatica Cloud, Salesforce CRM

Responsibilities:

• Gather business requirements from customer and transform business requirement into technical and come up with proposed solution.
• Architect and guide the project teams during full lifecycle project phases, going through requirements gathering, end user interaction, data analysis, data profiling, extraction and transformations, data modeling, Reporting/ Dash boarding - leveraging the appropriate data Integration, modeling and Visualization tools
• Analyze and propose solution for SiSense BI as per requirements.
• Create ETL load process and strategy as per technical requirements.
• Create Informatica tasks design specification.
• Receive unstructured data from external sources and transform the same to structure using Informatica.
• Experience in analyzing the requirements and creating staging areas in Salesforce, and source systems as per business and technical requirements.
• Experience in performance tuning and continuous improvements in system.
• Create Data model for proposed solution and design for Informatica as per proposed solution.
• Design and development job notification for all jobs across the systems.
• Discussing with customer daily/weekly to share project status, finalizing deliverables and gathering requirement for new change.

Confidential, Wilmington, DE

Software Engineer

Technologies: CRM Salesfore.com (Veeva), SSRS, SSIS, SSAS, Informatica Power Center, Oracle 10g/9i, SQL Server, SQL, PL/SQL, TOAD, CAWA (Job scheduling) and UNIX shell Scripting.

Responsibilities:

• Gather business requirements from customer and transform business requirement into technical and come up with proposed solution.
• Analyze and propose solution for Informatica Power Center as per requirements.
• Analyze and propose solution for Salesforce as per requirements.
• Create design specification for Database, Informatica and Salesforce.
• Create ETL load process and strategy as per technical requirements.
• Create SQL for reports in SQL developer.
• Involved in configuration, data migration & code migration in Salesforce.
• Created real time and historical reports in Salesforce.
• Understand customer requirement and create Business Process Model as per the requirements.
• Analyze the requirements and create database, staging areas, and source systems as per business and technical requirements.
• Design and development of Apex load for loading data from Oracle database to CRM Salesforce Veeva.
• Design and development of extracting data from CRM Salesforce Veeva to Oracle database.
• Data migration lead for loading data onto Oracle OnDemand from Quattro using Informatica, SQL and Oracle OnDemand Data Loader.
• Involved in interaction with client for requirement gathering and updating on daily basis (since project followed Agile Methodology).
• Gained experience of working on validated applications in Pharma Industry
• Prepared Design documents, unit test scripts.
• Prepared Data Mapping Documents for pulling data from source systems to target flat files using Informatica.
• Prepared High Level and Low Level Design Documents for Informatica Development.
• Coordinated with Onsite and Offshore resources for Project Status Calls.
• Coordinated with Onsite and Offshore resources during Project Implementations.
• Provide timely solutions and reports to client based on their requirements which was helpful for Sales Leads to plan future business activities
• Manage onsite team and coordinate with offshore team
• Managing Data warehousing, Business Intelligence and Salesforce (Veeva) Projects.

Confidential, Wilmington, DE

Software Engineer

Technologies: Informatica Power Center, Oracle, SQL, PL/SQL, TOAD, Autosys (Job scheduling) and UNIX shell Scripting.

Responsibilities:

• Understood the Business point of view to implement coding using Informatica power center designer.
• Created Complex mappings using various transformations inclusive of but not limited to Unconnected/Connected Lookup, Aggregate, Router, Expression, Sequence Generator, Joiner transformations for populating target table in efficient manner.
• Designed complex mappings involving constraint based loading, target load order.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created Mapplet and used them in different Mappings.
• Created events and tasks in the workflows using workflow manager.
• Created Dependency chart to sequence and arrange task in Workflow.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size, sequence buffer length and target based commit interval.
• Developed Informatica mappings and also tuned them for better performance with PL/SQL Procedures/Functions to build business rules to load data.
• Created database objects like Tables, Synonyms, Indexes, Views, Procedure and Function.
• Designed and Developed Oracle PL/SQL and UNIX Shell Scripts, Data Import/Export.
• Developed shell scripts for running batch jobs and scheduling them.
• Provided Production Support for ongoing issues and trouble shoot the issues to identify the bugs.
• Created detailed project outlines and application design specifications.
• Interaction with Team everyday for ongoing work, based on the Tickets/issues and to follow up with them for its progress.

Confidential, Wilmington, DE

Software Engineer

Technologies: Informatica Power Center, Oracle, SQL, PL/SQL, TOAD, Autosys (Job scheduling) and UNIX shell Scripting.

Responsibilities:

• Involved in Functional testing.
• Involved in Creation of test scenarios, Test Conditions and test scripts.
• Execution of test scripts in Hp Quality Centre helped me gaining command on Hp Quality Centre.
• Gained experience of working for a Pharma Industry,
• Understanding the Sales and marketing part of our client.
• Gained knowledge on SQL and Informatica
• Understood the Business point of view to implement coding using Informatica power center designer.
• Created Complex mappings using various transformations inclusive of but not limited to Unconnected/Connected Lookup, Aggregate, Router, Expression, Sequence Generator, Joiner transformations for populating target table in efficient manner.
• Designed complex mappings involving constraint based loading, target load order.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Created Mapplet and used them in different Mappings.
• Created events and tasks in the workflows using workflow manager.
• Provided Production Support for ongoing issues and trouble shoot the issues to identify the bugs.
• Created detailed project outlines and application design specifications.
• Interaction with Team everyday for ongoing work, based on the Tickets/issues and to follow up with them for its progress.
• Providing support and resolving issue by doing reverse engineering.