Sr Developer & Analyst

Hema

Email: *************@*****.***

Phone no: 971-***-****

PROFESSIONAL SUMMARY:

• Around 7.5 years of IT experience in Design, Development, Testing and Administration spanning all facets of package software and Saas application implementation.

• Over 3.5 years of experience in the Salesforce.com CRM space that includes Administration, Configuration, Implementation, Development and Support experience.

• Experienced in Discovery Phase, Scoping Phase, Analysis and Implementation Phase.

• Implementation experience of Salesforce.com applications like the Sales, Marketing and Service and Support Modules.

• Worked on various salesforce.com standard objects like Accounts, Contacts, opportunities, Products, Price books, Cases, Leads, Campaigns, Reports and Dashboards.

• Have in depth Knowledge and understanding of CRM business processes like Forecasting, Campaign Management, Lead Management, Order Management, Account Management, and Case Management.

• Designed Custom Formula Fields, Field Dependencies, Validation Rules, Work Flows, and Approval Processes for automated alerts, field updates, and Email generation according to application requirements.

• Extensive experience of using declarative features like validation rules, workflows, approval process, dynamic approval process, sharing rules automation for satisfying complex business process automations.

• Implemented security and sharing rules at object, field, and record level for different users at different levels of organization, also created various profiles and configured the permissions based on the organizational hierarchy.

• Expertise in Force.com technology stack: APEX, Visual Force, SOQL, SOSL.

• Experience in building Visual Force Pages, Visual Force Custom Controllers/ Components, Advanced Search Functionality, Reports, Dashboards, Tabs.

• Created page layouts, search layouts to organize fields, custom links, related lists and other components on a record detail and edit pages.

• Experience integrating SFDC with various applications like Microsoft Outlook, ACT, etc.

• Knowledge in integration of internal and external management information using Enterprise resource planning (ERP).

• Expert in migrating data from various systems into Sales force CRM using ETL tools – Informatica On Demand, and Cast Iron.

• Strong Requirements gathering experience Conducting User Interviews, and preparing functional documents like Use Cases, Software Requirements Specifications (SRS).

• Good Knowledge of RDBMS, SQL.

• Experience in Query Optimization and Performance Tuning using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance, Database consistency checks using DBCC Utilities.

• Knowledge in developing web-based applications using Java, PHP, XML, CSS, HTML, DHTML, XHTML, JavaScript and AJAX Technology.

• Expert in tasks such as data extraction, transforming and loading using SQL* Loader, Oracle External tables, database links in Oracle and DTS transformations in SQL Server for various file formats.

• Expert level skill in Database Migration from SQL Server 2000 to SQL Server 2005.

• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.

• Installed Salesforce Apps, configured and maintained user security permissions in compliance with organizational Needs .

• Experience of working with diverse database platforms including Oracle, SQL server, MS Access.

• Involved in requirement gathering from the client location, knowledge transfer and setting expectations on project progress at the client end.

• Excellent communication and inter-personal skills, accustomed to working in both large and small team environments.

• A team player with a strong work ethic, a positive attitude and the ability to make the best use of individual resources.

TECHNICAL SKILLS:

SALESFORCE.COM

Salesforce CRM, Salesforce Admin, Apex Language, VisualForce (Pages, Component & Controllers), Salesforce.com Data Loader, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, salesforce offline Edition, Analytic Snapshots, Case Management System, SOQL, SOSL.

SALESFORCE TOOLS AND INTEGRATION TOOL Eclipse IDE, Apex Data Loader, Informatica Data Loader, Ibolt Integration studio.

Cast Iron.

PROGRAMMING

LANGUAGES C++, Java, Apex, SQL

RDBMS MS Access, Oracle

OPERATING SYSTEMS Windows95/98/ XP/2000/vista, UNIX

DATABASE TOOLS Enterprise Manager, Query Analyzer, SQL Server Profiler, DTS, SSIS, SSRS, SSAS, Business intelligence Studio

PROFESSIONAL EXPERIENCE:

Client:Mindray North America, New Jersey Aug 2011 – Till Date

Description: Mindray North America manufactures hospital products, and are largely focused in the areas of anesthesia, emergency medicine and critical care. They are the developer, manufacturer and exporter of medical devices for patient monitoring, diagnostics and ultrasound imaging systems.

Role: Salesforce Consultant

Responsibilities :

• Performed detailed analysis of business and technical requirements and designed the solution by customizing various standard objects of Salesforce.com (SFDC) and other platform based technologies like Visualforce, force.com API, and web services.

• Developed various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Visualforce Pages.

• Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.

• Designed and developed SFA based Application on force.com platform in salesforce.com environment with Apex programming language at backend and Visual-Force pages as user interface.

• Created test scenarios on Sandbox environment, created packages and moved it between Sandboxes and Production environments to place final implementations..

• Used salesforce Automation (SFA) for Territory Management and Opportunity Management.

• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

• Developed Apex Classes and Apex Triggers for various functional needs in the application.

• Used SOQL & SOSL for data manipulation needs of the application using platform database objects.

• Created profiles and implemented Object and field level security to hide critical information on the profile users.

• Created users, roles, public groups and implemented role hierarchies, sharing rules and record level permissions to provide shared access among different users.

• Worked in bi-directional integration of Salesforce and SAP using Cast Iron tool.

• Resolved various issues in the previous implemented integration in Cast Iron.

Environment: Saleforce.com platform, Apex Language, Visualforce (Pages, Component & Controllers), Pages, Data Loader, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Cast Iron, Security Controls, Eclipse IDE Plug-in, Windows XP.

Client:Milliman Care Guidelines, Seattle, WA Oct 09 to July 11

Description: Milliman is among the world's largest independent actuarial and consulting firms. This firm is Involved in consolidating customer information companywide and streamline process. SFDC was integrated with different applications using and managing CRM solution for integrating sales, marketing, and support, while scaling to the company’s rapid growth.

Role: Salesforce Consultant

Responsibilities:

• Participated in requirements Gathering and definition of ER (Entity Relationship) diagrams using MS Visio.

• Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization in enterprise edition.

• Migrated Data from ACT and Microsoft access.

• Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.

• Implemented pick lists, dependent pick lists, lookups, junction objects, master detail relationships, validation and formula fields to the custom objects, Web to case, Email to case.

• Integrated SFDC system with IBM Lotus Notes.

• Designed, developed and deployed Apex Classes, Controller Classes, Extensions and Apex Triggers for various functional needs in the application using the Eclipse IDE.

• Created workflow rules and defined related tasks, time triggered tasks, email alerts, field updates to implement business logic.

• Develop Visual Force Pages, Visual Force Custom Controllers Components, Advanced Search Functionality, Custom Objects, Reports, Analytic Snapshots, Dashboards, Tabs, Tags and Components.

• Developed Custom Reports and Dashboards as per given requirements.

• Processed the data transformation from the legacy system to the SFDC application data schema with data cleanser, data analysis, data quality control, etc.

• Migrated Salesforce data both in/out bound using Cast Iron, Java, Web services.

• Created test scenarios on Sandbox environment, created packages and moved it between Sandboxes and Production environments to place final implementations.

Environment: Saleforce.com platform, Apex Language, Visual Force (Pages, Component & Controllers), Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Data Cleansing, Email Services, Security Controls, Eclipse IDE Plug-in, IBM Lotus notes, Windows Vista.

Client: Amgen, Thousand Oaks, CA Jun 08– Sep 09

Description: Amgen is the world's largest independent biotech firm. Amgen discovers, develops, manufactures and delivers innovative human therapeutics. This project involved in implementing the salesforce.com application for customer relationship management (CRM), fundamental needs of every customer like Account statement, account balance, and transaction. This system allows customers to access their cash statements via the Internet and to check their statement virtually anytime from anywhere.

Role: Salesforce Consultant

Responsibilities:

• Involved in Salesforce.com Application Setup activities and customized the applications to match the functional needs of the organization in enterprise edition.

• Interacted with various business team members to gather and document the requirements.

• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

• Worked on various salesforce.com standard objects like Campaigns, Leads, Accounts, Contacts, Opportunity, Forecast, Cases, Reports and Dashboards.

• Implemented Web-to-lead to track and solve leads from the website.

• Created different workflow rules and Approvals for various campaign processes.

• Designed, and developed the Custom objects, validation rules, Page layouts, Custom tabs, components, VisualForce Pages to suit to the needs of the application.

• Designed, developed and deployed Apex Classes, Controller Classes and Apex Triggers, packages for various functional needs in the application.

• Evaluated Salesforce.com ETL and integration solutions including Informatica, CastIron.

• Perform detailed analysis of business and technical requirements and developed the Apex classes using other Platform based technologies like VisualForce, Force.com IDE.

• Developed and configured various Reports for different user profiles based on the need in the organization.

• Participated in the training sessions provided by the Salesforce team and support end users.

• Providing ongoing salesforce.com maintenance and administration services including periodic data cleansing, custom objects, workflow, Triggers.

• Used the sandbox for testing and migrated the code to the deployment instance after testing.

Environment: Saleforce.com platform, Apex Language, Visual Force (Pages, Component & Controllers), Pages,Informatica, HTML, Java Script, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Security Controls, Sandbox data loading, Eclipse IDE Plug-in, Windows XP.

Client:Sun trust Bank, Atlanta, GA Dec 07– May 08

Description: A Personal Finance focused investment bank, deployed salesforce CRM, to deliver service and support faster and with greater accuracy, and to help ramp up staff more rapidly to improve team sales and improve ROI.

Role: Salesforce.com Consultant

Responsibilities:

• As SFDC Consultant interacted with various business areas to gather requirements and develop data model to suit complex business needs.

• Interacted with various business user groups for gathering the requirements for CRM implementation.

• Involved in Salesforce.com application setup activities and customized the UI to match the functional needs of the organization.

• Implemented the requirements on Salesforce.com platform and Force.com IDE Plug-in using Eclipse.

• Worked on various salesforce.com standard objects like Accounts, Contacts, Leads, Campaigns, Opportunities, Quotes, Activities, Dashboards and Reports.

• Created new custom objects, assigned fields, designed page layouts, custom tabs, components, custom reports.

• Created mash up between sales force CRM and Gmail through Force.com AppExchanges’s email integration engine.

• Created and deployed several reports for different user profiles based on the need in the organization.

• Customized the Dashboards to the track usage for productivity and performance of business centers and their sales teams.

• Designed various HTML Email templates.

• Integrated the Web Services for extracting the data from external systems.

• Installed and deployed OrgView, a Force.com AppExchange tool that allows users to create visual org charts and update them in Sales force CRM using drag-and-drop functionality.

Environment: Saleforce.com platform, Force.com API, Workflow & Approvals, Reports, Custom Objects, Custom Tabs, Email Services, Visual Force,Salesforce.com Data Loader, Security Controls, HTML, Java Script, Web Services, WSDL, Sandbox, Eclipse IDE Plug-in.

Company: iProzone Technology Solotion P Ltd. Aug 06 to Nov 07

Role: Sql Developer

Responsibilities:

• Involved in all the phases of SDLC including Requirements collection, Design and Analysis of the customer specifications, Development and Customization of the application.

• Worked with the 3-Tier Architecture which includes the presentation layer, business logic layer and the database.

• The presentation layer was the front end which included creating web pages and the database acted as the back end .

• Created all the tables for patient's information, doctor's information, medical information and all the relevant information.

• Actively involved in Normalization (3NF) and De-normalization of the database.

• Created several complex stored procedures and triggers using SQL Server 2005 to retrieve data.

• Developed and implemented the SQL Server Integration Services (SSIS) packages to populate the data into the Enterprise Data Warehouse from various sources like Flat File Source, Excel Source into OLEDB Destination (SQL Server).

• Used MS Visual Source Safe 6.0 for the source control.

• Involved in writing T-SQL programming for implanting stored procedures and functions for different tasks.

• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.

• Analyzed the requirements and finely tuned the stored procedures to improve the performance.

• Documented the SQL Server Integration Service Standards to be followed.

• Implemented the DTS packages in SSIS to transfer and load the data.

• Used SQL Profiler and Database Engine Tuning Advisor (DTA) to identify inefficient performance of queries and tuned those using Show Plans and Execution Plans for better performance.

• Used SQL Server Reporting Services (SSRS) 2005 to query the databases to generate different types of complex ad-hoc reports.

• Worked on DTS package in SSIS, DTS Import/Export for transferring data from heterogeneous databases.

Environment: MS SQL Server 2005, SQL Server Reporting services (SSRS), SQL Server Integrating Services (SSIS), SQL Server Analysis Services (SSAS), T-SQL, and Windows 2003 .

Company: Eclat infosoft private limited., India Sep 03 to July 06

Role: Sql Developer

Responsibilities:

• Installation, Creation, Administration and Maintenance of SQL Server Databases (Production/ Development / test).

• Maintenance of Production and Development Servers, ensure the availability of the production databases to end-users and development database to developers in a 24x7 environment.

• Troubleshooting database related problems as and when required and data loading/ Migration.

• Build, configure, monitor and troubleshoot database instances and database servers.

• Establish and Maintain Backup & Recovery policies and procedures.

• Implement, audit and maintain database security (create and maintain user and roles, assign privileges).

• Optimized code and performance, Transaction Management, Creation of scheduled jobs for purging the Data.

• Wrote Scripts for automated database refreshes, automated backups, startup, shutdown or regular monitoring of databases.

• Perform code review on SQL and related code as needed.

• Act as a liaison to development teams to advice on database standards and best practices.

• Perform production SQL release final verification procedure to production.

• Document all database changes and follow and enforce change and release management processes.

• Involved in T-SQL Programming for writing both database and business stored procedures.

• Migrated Code across different environments.

• Involve in co-ordination between On-site and off-shore teams member. Working effectively around the clock for resolving issues.

• Documenting and bug fixes and resolution of Tickets.

Environment: MS SQL 2000/7.0, T- SQL, Terminal Services, IIS, Microsoft SQL Server Reporting Services (SSRS).

Education:

• MS in Computer Science.

References:

• Available upon Request.

Contact this candidate