Data Analyst Resume Profile
Professional Summary
- 12 years of IT experience, with 4 years of experience in Salesforce CRM, Force.com Platform and Apttus Contract Management as Developer/Admin.
- 4 years of experience in the Salesforce.com CRM and Force.com space that includes Business Analysis, Data Migration, Administration, Configuration, Implementation, Development and Support experience.
- Salesforce.com Certified Force.com Developer DEV-401
- Well experienced with Salesforce.com configuration and custom development
- Well experienced in Implementation and customization of Apttus Contract management and Advanced Approvals
- Proficiency in SFDC Administrative tasks like creating Profiles, Roles, Users, Page Layouts, Email Services, Approvals, Workflows, Validation rules, Reports, Dashboards, Tasks and actions.
- Strong Implementation and Integration experience using Custom objects, Triggers, workflows/ workflow rules, approvals, S-Controls, Visual Force Pages, and Apex classes.
- Experienced in SFDC development using Apex classes and Triggers, Visual Force, Force.com IDE, SOQL, SOSL.
- Experienced in Manual and scheduled data migrations using Import wizard and Apex Data Loader.
- Expertise in writing Scripts to facilitate the extraction, transformation and loading of legacy data.
- Well experienced with Eclipse IDE.
- Good experience in deployment of Apttus objects across various Orgs.
- Expertise in design and development of web applications/Windows with .NET framework using ASP.NET, VB.NET, C .NET, ADO.NET, XML, XSLT, SOAP , Web Services and WCF.
- Extensive experience with .Net Framework 1.1/2.0/3.5/4.0.
- Extensive experience in architecture, design and development of Client-Server and Distributed Web Applications with ASP.NET MVC 3.0, 3-Tire and N-Tire Architecture.
- Expertise in Designing Applications using OOAD and Creational Patterns Factory, Singleton ,Structural Patterns Fa ade and knowledge of Implementation methodologies.
- Excellent Experience in using scripting languages like Java Script and AJAX Asynchronous java Script and XML .
- Expertise in writing SQL Packages and Procedures, Functions, Triggers,
- Experience in using Configuration management tools Version Controllers like VSS, VSTSS2005 and Vice-Versa Tools.
- Effective team player and excellent communication skills with insight to determine priorities, schedule work and meet critical deadlines.
- Awarded with Bravo 3 times consecutively from Motorola for the support provided for Law department applications.
Technical Skills
- Force.com Salesforce CRM, Apex Custom Controllers, Apex triggers, Apex classes, Apex web services, Visual force Pages, Eclipse, Force.com IDE, Apex Data Loader, SOQL, SOSL, Workflows and Approvals, Sandbox testing.
- Architecture MVC1.0,MVC3.0,3-Tire,N-Tire,Cleint-Server SOA
- Software Visual Studio 2003/2005/2008/2010
- Frame Work .Net Framework 1.1/2.0/3.5/4.0 WCF WPF
- Languages C 4.0,VB.NET, XML, UML
- Web Technology ASP.NET ,ASP,HTML/DHTML,AJAX,XML.XSLT, WebServices,
- ADO.Net, Silverlight
- Scripting Java Script, VB Script,Shell Scripting
- Middleware COM, DCOM, MTS/COM
- Version Control Team Foundation Server, Visual Source Safe, Clear Case
- Databases SQL Server2000/2005, Oracle
- Reporting Tools Crystal Enterprise 10/9.0/8.5/8.0,HTML Reports
Professional Experience
Environment : Salesforce CRM, Apex Classes, Controllers, Triggers, Visualforce pages, Custom Objects, Tabs, Email Templates, Workflow Approvals, Sharing rules, Reports, Dashboards, Eclipse, Force.com IDE, DataLoader, Milestones PM.
Imagine has a CRM implementation with Milestones PM to manage their Projects Management Lifecycle. The default pages of Milestones PM to enter Projects, Milestones and Tasks needed users to visit multiple pages to enter the data. We have developed customizations on top of Milestones PM to enhance the features of Milestones PM. And we are currently
Responsibilities :
Scheduled the Data sync using the Data Loader
- Developed Multi edit Visualforce page to enter Milestones and Tasks for a specific Project
- Responsible for creating triggers to automate email reminders for survey based on the business criteria.
- Responsible for customizing the timesheet entry screen to accept the non billing hours separately.
- Handling Admin activities like modifying Page Layouts, Creating Modifying Field and its type, Validation Rules, WorkFlow Rules, Email Templates, Picklist, Dependent Picklist.
- Written Apex classes, Visualforce pages and Apex Triggers to meet various functional requirements in the application.
- Created Profiles and defined Object level, field-level and apex classes, visualforce pages security.
- Created Workflow rules and defined related tasks, email alerts, and field updates.
- Implemented Pick lists, Dependent Pick lists, lookups, Master detail relationships, validation and formula fields to the custom objects.
- Provided the training to Business users about the system
- Creation and Customization of various Custom Reports as per the business requirements.
Confidential
Environment : Salesforce CRM, Apex Classes, Controllers, Triggers, Visualforce pages, Custom Objects, Tabs, Email Templates, Workflow Approvals, Sharing rules, Reports, Dashboards, Eclipse, Force.com IDE, DataLoader, Speak2Leads, Pardot, SCRIBE.
Gymsource has a CRM implementation to manage their Customers and scribe integration between their ERP and Salesforce to sync the Leads, contacts and orders information.
Responsibilities :
- Created the design to support store wise and Sales Rep wise Goals.
- Developed and automated the reports and dashboard to show the monthly achieved goal percentages aligning to their respective store goals.
- Responsible for configuring the Email support to report the rejected rows from Scribe
- Integrated Salesforce with Speak2Leads to automate the communication between Leads and Salesreps.
- Created various Custom Objects, Formula fields, Master-Detail, Lookup relationships and Tabs.
- Handling Admin activities like modifying Page Layouts, Creating Modifying Field and its type, Validation Rules, WorkFlow Rules, Email Templates, Picklist, Dependent Picklist.
- Written Apex classes, Visualforce pages and Apex Triggers to meet various functional requirements in the application.
- Created Profiles and defined Object level, field-level and apex classes, visualforce pages security.
- Created Workflow rules and defined related tasks, email alerts, and field updates.
- Implemented Pick lists, Dependent Pick lists, lookups, Master detail relationships, validation and formula fields to the custom objects.
- Provided the training to Business users about the system
- Creation and Customization of various Custom Reports as per the business requirements.
- Import and Export of Orders data using Data Loader to the new objects for reports.
- Created the T-SQL scripts in sql server to automate the data extraction for the scribe sync process.
Confidential
Environment : Saleforce.com CRM, Conga Composer, Apex Classes, Controllers, Triggers, Visualforce pages, Custom Objects, Tabs, Email Templates, Workflow Approvals, Sharing rules, Reports, Dashboards, Eclipse, Force.com IDE, HTML, CSS, Java script, Windows7.
Arrow S3 used to create Quick quotes for their customers in manual way. We automated their Quoting process to support different types of quotes like Equipment, ProServ and Service. Within these quotes Arrow S3 used have sub quotes like Engineered or quick quotes. As part of the project we integrated their Salesforce system with back-office system to support Orders and Payments processing.
Responsibilities:
- Responsible for formalizing requirements and technical design documents.
- Written Apex classes, Visualforce pages and Apex Triggers to meet various functional requirements in the application.
- Created various Custom Formula fields, Master-Detail, Lookup relationships and Tabs.
- Designed and developed templates using Conga Composer.
- Created Profiles and defined Object level, field-level and apex classes, visualforce pages security.
- Designed and deployed Custom tabs, validation rules, Approval Processes and Auto-Response for automating business logic.
- Created Workflow rules and defined related tasks, email alerts, and field updates.
- Used the sandbox for testing and migrated the code to the deployment instance after testing.
- Provided the training to the internal business users to use the application and develop their own custom reports.
Confidential
Environment : Salesforce.com,Apttus Contract Management and Advanced Approvals,
Saleforce.com CRM, Apex Classes, Controllers, Triggers, Visualforce pages, Custom Objects, Tabs, Email Templates, Workflow Approvals, Sharing rules, Reports, Dashboards, Eclipse, Force.com IDE, HTML, CSS, Java script, Windows7.
Responsibilities :
- Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
- Responsible for architecting an overall solution for the Contract Management workflow life-cycle.
- Responsible for formalizing requirements and technical architecture documents.
- Written Apex classes, Visualforce pages and Apex Triggers to meet various functional requirements in the application.
- Created various Custom Objects, Formula fields, Master-Detail, Lookup relationships and Tabs.
- Created Profiles and defined Object level, field-level and apex classes, visualforce pages security.
- Designed and deployed Custom tabs, validation rules, Approval Processes and Auto-Response for automating business logic.
- Developed Cascading Style Sheets CSS for creating effects in Visualforce pages.
- Created Workflow rules and defined related tasks, email alerts, and field updates.
- Implemented Pick lists, Dependent Pick lists, lookups, Master detail relationships, validation and formula fields to the custom objects.
- Provided the training to Business users about the system
- Creation and Customization of various Custom Reports as per the business requirements.
- Installed and utilized Data Loader efficiently for the uploading of various Contracts data as part of the Advanced Approvals Releases.
- Developed the triggers to create the Buffer tables with the changed data for data synchronization of the NDA data.
- Developed and Deployed 12 releases of advanced approvals to align with the organization changes.
- Implementation and Maintenance of the Advanced approvals using Apttus for all the regions.
- Experienced working with Eclipse -Force.com IDE.
- Developed and configured various Custom Reports and Report Folders for different user profiles based on the need in the organization.
- Designed, developed and deployed Custom objects, Page layouts, Custom tabs, Visual Force Pages, Apex classes to suit to the needs of the application.
- Provided ongoing SalesForce.com maintenance and administration services including periodic data cleansing, custom objects, workflow.
- Responsible for formalizing the overall System design, workflows and business processes.
- Involved in customization of approval processes and rules using Apttus Approval Management.
- Responsible for Customization of apttus contract management for storing Non Disclosure Agreements
- Loaded the Legacy NDA data into Salesforce using Data Loader.
- Lead the efforts to integrate the inhouse NDA system to Apttus Contract mangement system.
Confidential
Environment : ASP.net, C , SQL Server 2005
Description : Thomson IP Manager , an enterprise-level intellectual asset management solution from Thomson IP Management Services to enable collaboration between departments, speed decision making and protect those critical assets
Responsibilities :
- Involved in Feasibility study of adopting this new tool
- Gathering the customer requirements
- Customization of the website to align with the Motorola internal standards and needs
- Development of customized reports using Crystal Reports and ASP.net.
- Quarterly Rules Updates
- Implementation
- Integration with the other systems for the synchronization of data.
- Data maintenance using Bulk imports and automated SQLs.
- Production Support
- Responsible for deployment of the Application revisions in production and resolving any post-deployment issues.
- Serving as SME Subject Matter Expert .
- Confidential
Environment : ASP.net, C , Oracle 9i iManage Libraries
Description : KOKO is a centralized portfolio management system which has an underlying database that is widely accessible and easily searchable, containing all data necessary to satisfy the stated requirements and business needs of IPS. Precisely, it's a web front-end data interface tool for reporting, querying and data entry against the IPM database
Responsibilities :
- requirements gathering, analysis and design, development, testing, debugging, implementing and deployment the application
- Developed various web forms, web controls and reusable business logic components in an Object-oriented manner
- Responsible for the designing and developing the Web based GUI using VB.NET, ASP.NET, web pages, ADO.NET and Stored Procedures to retrieve data
- Developing the database and writing Views, Store Procedure, Functions and SQL queries to retrieve the data using Oracle 9i
- Analyze and develop the business process flow using use cases, Sequence Diagrams, Database Diagram using MS VISIO
- Performed client side server side validations
- Development of modules using VB.NET and ASP.NET
- Written stored procedures in Oracle and got significant performance improvement
- Used SQL Data adapter objects, Dataset, Data Table objects for manipulating data in the SQL data source using ADO .NET
- Designed and developed the various reports based on user requirement and export reports into excel and PDF files
- Worked Extensively with Data bound controls like Grid View, Data Grid and Data List
- Set up and managed IIS and database servers establishing a life cycle for implementing changes using development, test and production implementing Visual Source Safe as the source manager
- Tested, maintained, documented, and deployed applications
Confidential
Environment : ASP.net, C , SQL Server 2000, XML Web Services and ActivePDF
Description : Motorola's vision is to have a web-based non-disclosure agreement system that will provide a common workflow and interface for all Motorola employees to create accurate and timely NDA documents. This website is designed to generate electronic NDAs between Motorola and their customers. A Non-Disclosure agreement is a legal document in which the parties agree that a recipient will not disclose the confidential information, knowledge, or data belonging to the disclosing party.
Responsibilities :
- Involved in Requirements gathering, Conceptual Design, Analysis, and Detail design, Development and System Testing.
- Provided estimates, daily weekly status report to the client on progress of the tasks.
- Implemented graphical user interface GUI for web forms.
- Implemented data access and business logic to meet client requirement.
- Created Business Logic Layer Data Access Layers to implement the MVC architecture.
- Implemented Routing, URl, Security, Action Filter techniques for application development.
- Implemented Cascading Style Sheet CSS to improve look and feel of the ASP.NET web page.
- Used the word and activepdf libraries to fill in the word document and convert it to PDF.
- Created Stored Procedures to perform automated rules, updating to related tables using SQL Server 2000/2005.
- Developed core functionality with the ASP.NET MVC Framework C .NET, ADO.NET .
- Created DAL Data Access Layers to establish database connectivity and data manipulation.
- Created re-usable utility libraries to generate reports in various formats from ADO.Net Dataset.
- Handled ASP.NET features such as Exception Handling, and Custom Error Messages.
- Handled Run Time Errors Design Time Errors by implementing appropriate Error handlers in C .Net.
- Performed unit testing on every new version before sending it for User Acceptance Test UAT .
- Responsible for deployment of the Application in production and resolving any post-deployment issues.
Confidential
Environment : ASP.net, C , SQL Server 2000, Acrobat Professional and PDF Toolkit
Description : Rapid Fire is a intranet website which helps the network IT team to generate proposals on the fly in PDF format for their network related products. This system is completely configurable from all perspectives which makes the system work for any technology.
Responsibilities :
- Played an active role in all stages - requirements gathering, analysis and design, development, testing, debugging, implementing and deployment the application
- Developed various web forms, web controls and reusable business logic components in an Object-oriented manner
- Responsible for the designing and developing the Web based GUI using VB.NET, ASP.NET, web pages, ADO.NET and Stored Procedures to retrieve data
- Developing the database and writing Views, Store Procedure, Functions and SQL queries to retrieve the data using SQL Server 2000
- Analyze and develop the business process flow using use cases, Sequence Diagrams, Database Diagram using MS VISIO
- Performed client side server side validations
- Development of modules using VB.NET and ASP.NET
- Written stored procedures in SQL Server and got significant performance improvement
- Used SQL Data adapter objects, Dataset, Data Table objects for manipulating data in the SQL data source using ADO .NET
- Designed and developed the various reports based on user requirement and export reports into excel and PDF files
- Worked Extensively with Data bound controls like Grid View, Data Grid and Data List
- Set up and managed IIS and database servers establishing a life cycle for implementing changes using development, test and production implementing Visual Source Safe as the source manager
- Tested, maintained, documented, and deployed applications
Confidential
Environment : ASP.NET, XML Web Services, .Net Framework Oracle 9i
Description : eCOPS application is being further extended to provide Police related services to other external agencies like Jails, Prosecution, Passport Services and Forensic Science Laboratories. This acts as a layer over the already existing eCOPS application. It provides interface with other external agencies. It provides various services to the external agencies. The external agencies such as Prosecution, Passport Office etc. can interact with eCOPS Police through this interface to gather any relevant information. For example the Passport office can immediately know whether an applicant has criminal record by utilizing this service. The application addresses for different protocol supports like TCP, HTTP with different network connections.
Responsibilities :
- Requirements capturing and analysing
- Development of Database Design
- Designing and Writing ASPx Pages
- Developing Assemblies
- Writing stored procedures
- Unit Testing.
- Implementation at different client sites.
Confidential
Environment : ASP 3.0, Visual Interdev, Java Script, VB Script, SQL Server 2000, Blue Pay FedEx API.
Description : African renaissance is an online shopping cart depicting ecommerce capabilities and dealing with modules like shopping cart, Shipping, administration and Inventory. This system has online approval for credit card payments with Blue Pay API. This has an external interface with FedEx shipping module to deliver the goods ordered online. Admin has the ability to maintain inventory online.
Responsibilities :
- Involved in development of the webpages using ASP
- Developed DLLs in Visual basic for the business layer
- Developed the component to interact with Bluepay and Fedex APIs for the payment integration.
- Developed Stored Procedures and Functions for data manipulations
- Involved in Unit Testing
- Involved in Code Reviews
- Involved in implementation and Post Production Support
Confidential
Environment : Visual Basic 6.0, Oracle 9i, Power Designer, Crystal Reports and COM
Description : An automated system for AP Police Recruitment. AP Police Recruitment System is aimed to full fill the needs of SLRB State Level Recruitment Board an authorized state-level governing body to recruit police personnel for AP Police Department. The proposed AP Police Recruitment System is intended to automate the selection process of all the 19 cadres that comes under the SLRB in order to reduce the time consuming manual selection process and also to avoid inaccuracy. APPRS is designed keeping in view the changing business rules in recruitment process. APPRS is highly user configurable and the user can change any business rule with least effort.
Responsibilities :
- Involved in Requirements gathering
- Designed the screens to align with customer requirements
- Developed DLLs and managed using the COM for transaction support
- Involved in Unit testing.
- Involved in Deployment of the application at different client sites
Confidential
Environment : ASP, SQL Sever 2000, Screaming Media Editor's Desk and IIS
Description : Confidential is a web portal directed to the tech and the tech business community in the area of Florida referred to as the High Tech Corridor.TechBizFL.com provides news, events, opportunities for networking, timely articles, financial information, skills matching database, links to local sites of interest and much more. The basic aim of TechBizFL.com is to create opportunities to improve the local tech community and to evangelize the tech community to the local general populace.
Responsibilities :
- Involved in development, testing and Deployment.
- Developed the web pages using asp
- Developed the stored procedures to retrieve the data from SQL Server
- Configuration of Screaming media editor to setup the required articles
- Development of the main page which has portlet type functionality which displays different sections from screaming media desk.
- Involved in the implementation of website.
- Involved in Post Production Support
Confidential
Environment : ASP 3.0, Visual Basic 6.0, SQL Server 2000, IIS 5.0, VBScript, Java script, Crystal Reports and COM
Description : Value Added Vacations is a Touring and Travels Portals, which caters to the online booking of accommodations, travels, for the general users. It has basically three types of users one is an administrator, corporate user and a general user. The main Responsibilities of the administrator is for setting various privileges, adding new departments etc. The corporate user has the feature of adding new agents. The general user can utilize this portal in a very effective manner, that is sitting at his home he can do all his booking online by just browsing the portal. The various modules involved in this portal are Accommodations, Car Booking, Tariffs, Cruise Booking, Flight Booking, and Accounting Package etc. Many more new features will be added as this project proceeds further.
Responsibilities :
- Involved in development of the webpages using ASP
- Developed DLLs in Visual basic for the business layer
- Developed the reports using Crystal Reports
- Developed Stored Procedures and Functions for data manipulations
- Involved in Unit Testing
- Involved in Code Reviews
- Involved in implementation and Post Production Support
Confidential
Environment : Visual Basic v6.0, Oracle 8i, Lotus Notes v5.0
Description : Image Selector is an ActiveX control which encompasses all the functionality that we can observe in any traditional Image Editing tools. This provides major aid in designing Imaging/Document Management Systems in Lotus Notes. And this product includes, interacting with scanner independent of Scanner type and Vendor and displaying the scanned documents, opening existing images, saving images into Databases with high compression, Rotating, Mirroring, Editing operations like Cut/Copy/Paste. The most interesting feature that this tool provides is managing multiple images at any point of time.
Responsibilities
- Involved in development using visual basic
- Storing the images to Oracle using clob/blobs.
- Involved in Unit Testing
- Involved in Code Reviews
- Involved in implementation and Post Production Support
Confidential
Environment : Windows 2000 Advanced Server for Application Server, Unix for Database Server, Windows 98 clients, Oracle 8i, VB 6.0 Seagate crystal report.
Description : A completely automated system that incorporates the entire functionality of the Agency Section of the Ministry of Commerce. The system caters to 25 different processes across 2000 diversified lines of businesses. The system has three-tier architecture.
Responsibilities :
- Involved in development of the screens using visual basic
- Involved in Development of the reports using Crystal Report
- Developed Stored procedures to query the data from oracle using parameters
- Involved in Unit Testing
- Involved in Code Reviews
- Involved in implementation and Post Production Support
Confidential
Environment : Oracle 8.0, Crystal Reports, MS VB 6.0, S-Designer
Description : Developed an ERP system comprising of 9 functional areas for a pharmaceutical major with retail outlets all over the Middle East. This product entails the functionality such as Sales and Distribution, Inventory, Financial Accounting Budgeting, Human Resources and System Administration.
Responsibilities :
- Involved in development of the screens using visual basic
- Involved in Unit Testing
- Involved in Code Reviews
- Involved in implementation and Post Production Support