We provide IT Staff Augmentation Services!

Systems Analyst Resume

SUMMARY

  • Over 14 years of IT experience and 5 years as a Certified Salesforce.com Developer and excellent experience as Salesforce Admin as well.
  • Salesforce App Builder and Salesforce Administrator certifications
  • 14+ years of experience in Requirement gathering, Design, Development, Implementation and Testing of Client/Server & Web Applications using Microsoft Technologies and over 6 years of experience in enterprise CRM applications.
  • Extensive experience with the Salesforce.com development life cycle, application design patterns, integration patterns and deployment planning.
  • Experienced working in Cross - functional teams, identifying business requirements and supporting sales/marketing efforts.
  • Experience in SFDC Development implementing the APEX Classes, APEX Triggers,
  • Good insight in to the Health and Service Domain.
  • Experience working in Agile methodology, Scrum methodology, Waterfall model and Test-driven development.
  • Created test scenarios on Sandbox and production environment and migrated code to deployment upon successful testing.
  • Extensive exposure to Smoke testing, Usability testing, End-to-End testing, System testing, Regression testing and User Acceptance testing(UAT).
  • Created customized UI as per the client and application requirements using Visualforce.
  • Review/Adjust/Write Apex and Visual Force page builds to ensure we keep code coverage at a high percentage as well as meet business needs.
  • Expertise in creating different email templates and inbound emails using Visualforce for the clients and customers.
  • Competent in analyzing and creating narrative Use Cases, Use Case Diagrams, Activity diagrams, class diagrams, Data/Flow/Navigational flow Diagram using UML Tools like MS Visio.
  • Expertise in customizing standard Objects like Accounts, Contacts, Opportunities, Products, Cases, Leads, Campaigns, Reports (Summary reports, tabular reports, Pie charts)and Dashboards and Report folders for different user profiles as per the requirements.
  • Created lookup and master-detail relationships on the objects and created junction objects and various advanced fields like Pick-list, Field Dependencies, Custom Formula, Approval Process, Sharing rules for automated alerts, field updates and Email generation.
  • Implemented Security and Sharing rules at Object Field and Record levels for different users in the organization.
  • Developed Lightning Component Framework and also built Lightning component using aura framework.
  • Knowledge on Salesforce Lightning Process Builder, Lightning UI/UX, app builder and creating Visual Workflows, salesforce support communities and Chatter groups.
  • Built reusable UI/UX components with lightning component framework.
  • Excellent architectural, analytical and problem-solving skills.
  • Extensive experience in Enterprise applications: Siebel CRM
  • Designed and developed scalable Internet/Intranet MVC, ASP.NET 4.5/C# Applications.
  • Over 5 years’ experience in building complex reports using Microsoft Reporting Services (SSRS).
  • Expertise in Visual Studio.NET 2015, 2013, 2010, JQuery HTML, DHTML, JAVASCRIPT, AJAX, XML, XSL, XSLT, CSS, VSS, TFS, Tomcat and IIS.
  • Extensive experience in database analysis, design, normalization, and data manipulation processes using MS Access and SQL Server and Oracle.
  • Experience in various phases of Software Development Life Cycle.
  • Self motivated with ability to work independently and in a team environment.

TECHNICAL SKILLS

CRM TOOLS: Salesforce.com, Oracle Siebel IP 17

SALESFORCE TECHNOLOGIES: Apex Classes, Test Classes, SOQL, SOSL, Visual Force, Lightning pages (Pages, Component & Controllers), ETL, Triggers, Custom Objects, Web services, Validation Rules, Work Flows, Dashboards, Reports, Sandbox development and Testing

SALESFORCE API TOOLS: Eclipse, App Exchange, Data Loader

LANGUAGES: C, C++, Java, PL/SQL, Apex, Ajax, C#

OPERATING SYSTEMS: Windows NT / 2000 / XP Pro / Vista, Windows Server 2000 / 2003 / 2008, Macintosh, Linux, Unix

WEB TECHNOLOGIES: Web Services, XML, HTML, XHTML, CSS Dreamweaver, Java Script, PHP, Servlet, Bootstrap, JQuery, OOD

Version Control Tools: TFS, VSS

Web services: SOAP, Cast Iron, WSDL, XML, JSON, REST

Databases: MS SQL Server 7.0, Oracle 10g/9i/8i, MS Access

PROFESSIONAL EXPERIENCE

Systems Analyst

Confidential

Responsibilities:

  • Lead Developer for Halton’s CRM application supporting 350+ users and 25 applications. Halton’s Siebel CRM Enterprise application is used by Access Halton (311), Health department and Chairs’ Office.
  • Performed the role of Salesforce Developer in the Organization.
  • Created Custom objects, formula fields and design validation rules page layouts, workflow rules.
  • Maintenance of CRM functionality implementing SFDC.
  • Creating SFDC reports (functional and technical documents).
  • Create profiles, roles and configure permissions according to organizational hierarchy requirement.
  • Developed applications using Agile methodology.
  • Created Workflows for automated lead routing and lead escalation.
  • Developed Apex classes and Triggers and linked them to manage the workflows.
  • Developed custom UI suing CSS, HTML, Visualforce components and used JQuery, JavaScript for front-end validation.
  • Designed salesforce service cloud console to enhance productivity with dashboard like interface.
  • Planned community rollout framework as four steps - cyclic process (Establish, Manage, Engage and measure)
  • Responsible for writing SOQL and SOSL queries.
  • Used Sandbox for testing. created, managed packages and migrated them between Sandboxes and Production environments for final implementation
  • Very good experience of using Data loader
  • Involved in full cycle upgrade of Halton’s Siebel CRM application from 8.1.1.10 to Innovation Pack 2018.
  • Managed all aspects of solution delivery including requirements capturing, creating functional User Cases, designing modules, supporting application and transferring knowledge to customers.
  • Worked extensively in configuring Siebel CRM applications as per business needs.
  • Developed and provided support to ASP.NET 4.5, MVC applications that integrate with Siebel CRM application using web services.
  • Worked on building complex SSRS reports for various departments.
  • Lead a team of junior developers providing technical guidance and overseeing day to day tasks.
  • Responsible for resolving various end user tickets and communicating and coordinating with users as well as management on a timely and efficient manner.
  • Actively worked with team members on a day to day basis to help them in addressing several Technical/Design problems.
  • Developed Code Best Practices and Guidelines documentation.
  • Responsible for conducting knowledge transition/training sessions to the end users to help them understand the features built over the period.
  • Implemented Source Code Management System and practice within our Group.
  • Goal-oriented team leader adept at building strong relationships with coworkers and clientele.

Senior Programmer Analyst

Confidential

Responsibilities:

  • Implementing new enhancements in the Price Management System written in V6 and related Crystal reports. Provided 24/7 on-call support for the same.
  • Created plan for new intranet portal for Cash Reconciliation application to replace the existing thick client application.
  • Managed functional portion of Cash Reconciliation application, including requirement specification gathering, process flow documentation, testing and training the user.
  • Researched and documented existing business process for legacy Price Management System.
  • Developed user documentation as well as scripts for functional usability testing and system training.
  • Managed a two member team of .NET consultants
  • Created KPI’s, SharePoint Dashboard’s and SSRS reports for Supply Chain. Used Excel Services and PowerPivot to do data analysis and generated KPI’s. Deployed SSRS reports on SharePoint 2010.
  • Worked on rewriting Incident report application from traditional ASP to ASP.NET 4.0 and migrated relevant reports to SSRS.
  • Worked with a team of three developers in creating Health and Safety training database system.
  • Responsible for Evaluation of various product suites best fit for the organization (Long term and Short Term).
  • Created POC to migrate existing Investigative Case Management system using Microsoft Silverlight 4.0 for Resource Protection team and created SSRS reports for data analysis.
  • Created and executed test scripts and worked closely with various testing teams (Integration Testing team, User Acceptance Testing team).
  • Responsible for participating in Requirement analysis and design exercises and creating Low Level Design documentation.
  • Provided 24/7 on call support on various products managed by our Group. As part of 24/7 on-call support, managed various legacy applications and resolved user issues on a timely fashion.
  • Worked with various management and compliance teams to facilitate their decision making by creating several SSRS report modules.
  • Created Product User manual to help users in navigating/using thru the newly built Application.
  • Built a documentation repository being used by the team on a regular basis as FAQs/GOTO documentation while addressing the tickets.
  • Responsible for participating in Requirement analysis and design exercises and creating various Design and Architecture Artifacts (SAD/High Level Design/Low Level Design/Requirement Traceability Matrix/Product Acceptance Criteria)
  • Responsible for doing project estimates and helping Project Management in building Project timelines.
  • Augmented Management in building Product Road Map for Incident Reporting System.
  • Responsible for Evaluation of various product suites best fit for the organization (Long term and Short Term).
  • Enhanced the Production system by identifying gaps within the system and proposing/implementing business/technical solutions around those.
  • Responsible for reviewing and documenting Team’s code.
  • Responsible for participating in Requirement analysis and design exercises and creating various design and Architectural artifacts including (Architecture Documents (SAD)/High Level Design/Requirements traceability Matrix/Product Acceptance Criteria)

Sr. Programmer Analyst

Confidential

Responsibilities:

  • Worked extensively on Oracle BI Discoverer 11g as a reporting and analysis tool to provide information to business users at all levels of the organization from data marts, ware houses and Oracle E-Business Suite.
  • Provided 24/7 (Weekday and Weekend) on call support for legacy applications written in VB6.
  • Supported highly Transactional, Mission Critical, Financial and Food supply Routing and ERP (RMS (AS/400 system)).
  • Responsible for resolving various end user tickets and communicating and coordinating with users as well as management on a timely and efficient manner.
  • Fine-tuned several age old application modules by redesigning and deprecating older technologies during support.
  • Build Integration enhancements as well as support for Microsoft Dynamics CRM based applications.
  • Effectively reduced the overall Production issues by 25% within 1 years by doing root cause analysis and fixing the problems.
  • Built an in-house documentation repository for End Users as well as Call Center team to self-serve for non-System/Data issues.
  • Worked on Crystal Reports to develop Route Revenue Analysis and Stale/Freshness Management reports. These reports provides various customers about the stale and sales information for different timeframes across Canada.
  • Worked on migrating Seagate reports to SSRS.
  • Integrated the SSRS reports to run on MOSS 2010. This allows the A/R and Sales users to schedule reports themselves rather than depending on IT.
  • Created an automated process for creating 750 document libraries on Extranet (SharePoint 2007 application) to handle security issues. Also automated permission handling (which is driven from AS/400) using SQL tables to reduce administration activity on Extranet.
  • Created an end-to-end process for uploading Handheld End of Day paperwork (approx. 750 text documents) to Extranet SharePoint application based on security and file name daily.
  • Worked on migration of the existing Intranet application from WSS to SharePoint 2010.
  • Created custom web parts and site templates for reusability in SharePoint 2010.
  • Created SharePoint groups and custom department sites based on requirements and trained users (Trained Marketing/Sales/File Maintenance users in using SharePoint 2010).
  • Developed an ASP.NET point of sale (LCL POS) application for Sales team that facilitated the sales team to maintain the Vendor, Banner, Store and Product master data.
  • Created Health and Safety MOSS 2010 team site as per business requirements.
  • Worked on Weston foods Web Order application built on ASP.NET 3.5. Also created Usage and Quality feedback reports for Business to analyze the new application usage. Completely and independently involved in requirement gatherings from users.
  • Developed Email Management intranet Application to train users about company’s email policies which is an ASP.NET 2.0 web application with SQL 2005 as back end.
  • Created custom content types, workflows and web parts using SharePoint Designer 2007 and 2010.

Confidential

Sr. Programmer Analyst

Responsibilities:

  • Responsible for the entire activities of Web Administrator module which include creation of new users, editing existing users, searching for an existing user, maintaining sites and file paths of a company, updating company and admin passwords, emailing users etc. key responsibilities are database design, preparation of class and sequence diagrams and coding part of the web admin module.
  • Used Master Pages for consistent Layout and ease of maintenance.
  • Used Themes to provide users personalized Look & Feel.
  • Utilized Sitemap feature for web application navigation and Sitemap Path for breadcrumb navigation.
  • Extensively Used GridView, Data List, Repeater Details View, SqlDataSource and ObjectDataSource.
  • Used SQL Server 2005 Management Studio for database design and maintenance.
  • Implemented Form Validations using ASP.NET Validation controls for better data accuracy and integrity.
  • Involved in various testing procedures like Unit Testing, User Testing, System Acceptance Testing and Integration Testing during the testing phase of the project life cycle.

Confidential

Sr. Programmer Analyst

Responsibilities:

  • been core member in enhancing the existing application functionality.
  • Handled key initiatives: Implementing Triggers, Zip codes, Tasks and Activities screens functionality.
  • Created SQL Stored Procedures for data manipulations in SQL Server 2005 database.
  • Web User controls are extensively used in the application.
  • Created master pages to display the logo and copy right information on every page of application.
  • GridView web control is extensively used in this application in order to maintain the data. Paging and sorting the data in the GridView is implemented.
  • Used both windows authentication and form authentication as it has both internal and external users.
  • Session state (session variables and session arrays) is used to roll on the data from page to page with in the session.
  • analyzing the requirements.
  • Preparation of design documents and test cases.
  • Design and develop Proof of Concept for implementing Microsoft Office SharePoint Server for Enterprise Content Management.
  • extensively involved in Coding of various modules as required during implementation.

Hire Now