EXPERIENCE SUMMARY:

• 10+Years of Total IT Experience in requirement gathering, estimation, design, development, testing, implementation and production support in Life insurance/Healthcare/Banking and Drug Distribution.
• 2+Years of hands on experience in Salesforce Developer & Administration with domain experience in Healthcare distribution industry.
• Certified in Salesforce Platform Developer1
• Good experience in developing Salesforce Lightning Apps, Components, Controllers and Events.
• Experience with SDLC process in agile methodology. Strong implementation and rollout experience with salesforce.com CRM (Sales cloud, Service Cloud, Marketing cloud), Communities, Sites and Force.com platform.
• Experience in creating, maintaining and enhancing visual flows, workflows, approval processes, formula fields, validation rules, field dependencies, automated alerts, and field updates according to application requirements.
• Worked extensively on various Salesforce.com standard objects like Accounts, Contacts, Opportunities, Products, Cases, Leads and Campaigns.
• Worked on building Salesforce standard/custom report types, Reports and Dashboards across various objects for different business groups.
• Excellent domain knowledge on ERP Applications: CRM, CPQ solution, Finance, Retail.
• Ability to quickly adapt and learn, work in - groups as well as independently with minimum supervision.
• 2+Years of experience in Informatica (ETL/Informatica Developer) Power Center 9.x/8.x and in the pharmaceutical distribution services.
• Worked on databases like Oracle, MS SQL Server, DB2 and Flat Files.
• Having strong background in Data warehousing projects development and solid exposure to diversified technologies like Informatica Power Center 9.1, Oracle
• Proficient and sound in performance tuning of mappings, sessions and workflows including partitioning, Index optimization maintaining and enhancing ETL code.
• Good knowledge in RDBMS concepts, data models, Star/Snow Flake Schemas.
• 6+ Years of Cobol/JCL/DB2/VSAM/CICS (Mainframe Application Developer)
• Experience in programming and testing on Mainframes using COBOL, SQL, JCL, VSAM, IMS-DB, CICS

TECHNICAL SKILLS:

Salesforce Technologies: Apex classes, Apex Triggers, Apex methods, Apex, Workflows and Approvals, Field Updates, Custom Objects and Tabs, Roles, Dashboards, Reports, Custom settings, Visual force components/controllers, Visualforce pages. Force.com Tools Force.com Eclipse IDE, Force.com Explorer, Apex data loader, Force.com Platform (Sandbox and Production).

Programming Languages: Apex, C, C++, OOPS.

Web Technologies: HTML, XML.

Operating System: MS Window, MAC OS-9/10

Methodologies: Agile, Scrum.

PROFESSIONAL EXPERIENCE:

Confidential

Salesforce Developer

Responsibilities:

• Worked with the user group for requirement gathering throughout the planning and implementation.
• Involved in research and design of the business
• Involved in various activities of the project like information gathering, analyzing the information, documenting the functional and non- functional requirements.
• Implemented E2E Salesforce solution for 100+ customers starting from build to deployment.
• Implemented CPQ solution using Apttus CPQ & Contract Management for various customers in industries.
• Hands on experience in Apex programming, Visual Force
• Created work flow rules and defined related tasks, email alerts and field updates.
• Used Data loader to bulk load data into Salesforce.com.
• Created Profiles, Users and implemented sharing rules, Role hierarchies, Record level permissions to provide data access among different users.
• Designed and deployed Custom tabs, validation rules, Approval Processes and Auto-Response Rules for automating business logic.
• Customized the dashboards to track usage for productivity and performance of business centers and their sales team.
• Created work flow rules and defined related tasks, email alerts and field updates.
• Used Data loader to bulk load data into Salesforce.com.

Confidential

Responsibilities:

• Designed and deployed Custom tabs, validation rules, Approval Processes and Auto-Response Rules for automating business logic.
• Worked with various salesforce.com objects like Accounts, Contacts, Leads, Opportunities, Reports, and Dashboards.
• Developed and configured various Custom Reports and Report Folders for different user profiles based on the need in the organization.
• Developed Custom Objects, Custom Reports and configured the Analytic Snapshots to dump the data on regular basis for the sales performance and lead generation statistics.
• Created and deployed Several Reports using salesforce.com platform.
• Developed Apex Classes, Controller Classes and Apex Triggers for various functional needs in the application.
• Developed and deployed workflows and approval processes for opportunities and products/assets management.
• Performed the roles of Salesforce.com Analyst/ Developer and Administrator in the organization.
• Worked in Data Migration from Traditional Applications to Sales Force Using Data Loader Utility.
• Used the sandbox for testing and migrated the code to the deployment instance after testing.
• Interacted with the Salesforce.com premium tech support team on a regular basis.

ETL/Informatica Developer

Confidential

Responsibilities:

• Requirement Gathering and Business Analysis.
• Worked with multiple sources such as Relational/Flat Files/Excel Sources for extracting the data.
• Designed the ETL Process for extracting the data from heterogeneous source systems, transform & load into the Data Mart.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router, Update Strategy, Filter, Stored Proc, sequence generator, Joiner, union transformations and Mapplets.
• As a Team Lead assigning the tasks to the team members and will get the status by end of the day and consolidated all the tasks send that to the client on daily basis.
• Develop Technical specification documents, Unit Test Cases.
• Development of Informatica sessions with Push down Optimization in Informatica Power Center 9.1.
• Created Workflows to run these Informatica mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Provided training to all the new team members in new business requirement.

Confidential, New York, NY

PL SQL Developer /ETL

Responsibilities:

• Coordinated with the front end design team to provide them with the necessary stored procedures and packages and the necessary insight into the data.
• Worked on SQL*Loader to load data from flat files obtained from various facilities every day.
• Involved in the continuous enhancements and fixing of production problems.
• Generated server side PL/SQL scripts for data manipulation and validation and materialized views for remote instances.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Creation of database objects like tables, views, materialized views, procedures and packages using oracle tools like Toad, PL/SQL Developer and SQL* plus.
• Created records, tables, collections (nested tables and arrays) for improving Query performance by reducing context switching.
• Extensively used the advanced features of PL/SQL like Records, Tables, Object types and Dynamic SQL.
• Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the application.

Environment: Oracle 11g, SQL * Plus, TOAD, SQL*Loader, SQL Developer, Windows XP

Confidential

ETL/Informatica Developer

Responsibilities:

• Involved in requirement gathering and created requirement specification to ensure functional correctness, accuracy, functional completeness and usability.
• Created, designed, and implemented specifications and developed ETL processes to support the development and implementation of data warehouse projects using Informatica.
• Designed and developed Informatica Mappings to load data from Source systems to Data Mart.
• Interacted with users to design the architecture of ETL mappings and developed them.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Worked extensively on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Update Strategy, and Sequence Generator and performed performance tuning of ETL process.

Environment: Informatica Power Centre 8.x., Windows, Oracle