We provide IT Staff Augmentation Services!

Ssis/ssrs/ssas Sql Developer Resume

0/5 (Submit Your Rating)

Austin, TexaS

SUMMARY

  • Total 7 years of experience in Development, Administration, Implementation Technology Solutions that includes 3 Years in Salesforce.com and Force.com.
  • 3 years of experience in Customization, Administration, Development and Data Migration of CRM application SalesForce.com (SFDC) and Force.com Platform.
  • Functional Expertise in Sales Force Automation (SFA), Marketing Automation and Case Management.
  • Extensive experience with developing Force.com Apex Classes, Apex Triggers, Visual force, Force.com API and Salesforce.com S - Controls.
  • Experienced in Administration setup like manage Users, Security Controls and Data Management.
  • Experienced in Salesforce.com CRM integration, developing and deploying custom integration solutions.
  • Expertise in Planning and executing all phases of software life cycle starting with requirement study, analysis, design, development, testing, implementation and production support.
  • Integrated customer activities with Salesforce web services.
  • Implemented complex business processes using Apex and Visual force Pages.
  • Used Data loader for data management in force.com platform.
  • Extensive experience using Salesforce.com Administration and Creating Roles, Profiles, Page Layouts, Workflow Alerts and Actions, and ApprovalWorkflows.
  • Involved in sandbox data loading, implementation and execution of System logs and data logs.
  • Extensive work experience in developing database objects such as DTS Packages, Procedures, Functions, Tables, Triggers, and Indexes using SQL Programming, SQL Analyzer, Enterprise Manager, SQL Advantage and SQL Server Management studio (SSMS),SQL 7.0 Replication services.
  • Proficient in implementing business logic and batch process in backend using Stored Procedures and Functions.
  • Have performed page layout customization, page layout assignment based on profiles and created custom links based on user requirement.
  • Excellent experience in using Oracle 8i/9i, SQL Server 2000 and SQL databases and Familiar with Stored procedures Triggers and Functions using PL/SQL and AJAX.
  • Ability to write complex SOQL, SOSL queries across multiple objects within the SFDC database.
  • Experienced in report generation using Table, Matrix and List Controls in SQL Report Services.
  • Experienced in using Excel to create Pivot tables, and accessing multidimensional cubes from Excel.
  • Export the data to Excel Files and Text Files from database.
  • A well-organized, goal-oriented, highly-motivated effective team member with excellent analytical, reasoning and problem solving Skills.
  • Excellent Interpersonal and Communication skills, fast learner, hardworking and good team player.

TECHNICAL SKILLS

Operating Systems: Windows 98/2000/XP/2003/vista.

Languages: T-SQL, SQL, PL/SQL, Java Script, java, C, C++,Visual Basic

Salesforce.com Development: Apex Language, Apex Trigger, Apex Class & Apex Web Services, Visual Force (Page, Component & Controllers), S-Control, Data Loader, SFDC data Management, Java, J2EE, Servlets, JSP, Web services, HTML, XML

Tools: /Utilities: En Manager, SQL Server Management Studio (SSMS),Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SQL Advantage, SQL * Plus, Toad, Erwin, Eclipse.

Databases: SQL Server 2005, Oracle9i, MS Access

Software: MS Office, Adobe Photoshop, Adobe Acrobat, MS Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects

Java/J2EE: Core Java, Servlets, JSP, EJB, JDBC, JNDI, JMS, struts, Hibernate, Java web services, Eclipse, Apache Tomcat, weblogic server, JBoss

SFDC Technologies: SFDC Design, S-Control, Sales force, application Integration, Explorer8.0, Apex Data Loader, Eclipse 3.4 and exact target.

PROFESSIONAL EXPERIENCE

Confidential, South San Francisco, CA

Salesforce Consultant

Responsibilities:

  • Review, prepare and deploy/execute configuration and codes to controlled environments: SFDC, Aprimo, Force.com.
  • Provide troubleshoot/analyses for resolution for Tier 3 for Production and post-production deployment/support.
  • Providing consultative product and solution for expertise application specific projects
  • Responsible for successful execution or rollback of the software changes if required
  • Review; provide impact assessment for all deployment-related documentation including deployment and rollback plans
  • Ensure deployments follow established processes to meet quality, repeatability, efficiency and meet compliance standards
  • Collaborating with the application development team to identify and realize technical improvements to the solution.

Confidential, San Francisco, CA

Salesforce Consultant

Responsibilities:

  • Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports and Dashboards.
  • Developed various Custom Objects like Answer submission, Answer verification, BHS consult, BHS Action taken, BHS contacts
  • Question choice, Question choice text, Relation code, Family history, Health condition, string answer, choice answer, date answer, invitation
  • Created Tabs like Appointments, Invitations, Family Histories, Reports, etc, Visual Force tabs like Confidential Id.
  • Entity-Relationship data model, validation rules on the objects and tabs, Components and Visual Force Pages.
  • Added custom links like import questionnaire, export questionnaire, questionnaire definition report.
  • Worked with Questionnaire (Participant, invitation and appointment management) and Questionnaire Admin ( questionnaire designer) apps.
  • Integration of Breast health decisions network with the Confidential programs for risk models by capturing risk information, threshold and risk label in BHD and Force.com
  • Built web service that can integrate BHD.org to a particular questionnaire system.
  • Risk scores and risk labels captured on the invitation tab of the admin portal in force.com, patient risk reports and export out of force.com.
  • Worked with webservice endpoint written in salesforce that provides a list of participants and a participant’s questionnaire answers to authorized users.
  • Worked on CRM functionality in order to capture patient information
  • Involved in setting up of reminder emails and triggers in Confidential environments.
  • Used Data Loader for Data Management in Salesforce.com platform.

Environment: Force.com, Apex, Data loader, Jira, Eclipse with SVN.

Confidential, Burbank, CA

Salesforce Consultant

Responsibilities:

  • Designed Business processes that included User interfaces, Reports, Data Objects, Screen Flows, Interfaces, Conversions and Business Rules.
  • Implementation of planned enhancement of Prospect Prioritization changes to Accounts, Opportunities, Activities, Scoring, Grading, distribution calculations and Prospect Entries.
  • Manage different page layouts for each type of contract assist pages.
  • Responsible for the maintenance of data validation and integrity issues.
  • Generate the reports for different target segment areas of prioritization.
  • Implemented the requirements on Salesforce.com and Force.com using plugin Eclipse.
  • Implemented complex business processes using Apex (Batch Apex). Batch Apex included logic to implement segregation of prospects based on the decile set for each segment.
  • Created Visual Force pages to kick start the periodic distribution process, act as checkpoint for verification of data before loading the records as Activity to Sales Professional.
  • Used Data Loader for Data Management in Salesforce.com platform.
  • Involved in creating parameters for custom settings and managing them as per the requirements.
  • Performed the responsibility of unit and system testing for verifying the test specifications apart from the UAT.

Environment: Force.com, Apex, Data Loader, Import Wizard, Force.com IDE.

Confidential, San Francisco, CA

Salesforce Consultant

Responsibilities:

  • Involved in Salesforce.com Application Setup activities and customized the apps to match the functional needs of the organization.
  • Interacted with various business team members to gather the requirements and documented the requirements.
  • Used Sales Force Automation (SFA) for Sales Lead Management, Opportunity Management, Account and Contact Management, Data Quality Management, and Approvals and Workflow.
  • Worked with various salesforce.com objects like Accounts, Contacts, Leads, Campaigns, Reports and Dashboards.
  • Developed various Custom Objects, Tabs, Entity-Relationship data model, validation rules on the objects and tabs, Components and Visual Force Pages.
  • Created page layouts, search layouts to organize fields, custom links, related lists, and other components on a record detail and edit pages.
  • Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.
  • Created templates, approval processes, approval page layouts and defined approval actions on them to automate the processes.
  • Developed and configured various 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.

Environment: - Controls, Import Wizard, Sharing Rules, Workflows, Email Updates.

Confidential, Austin, Texas

Salesforce consultant

Responsibilities:

  • Developed Salesforce.com approval workflow for Account, Rate Change, Order and Price objects
  • Developed Salesforce.com S-controls using flex builder and Action Script for new account provisioning custom workflow.
  • Created reports using combination of custom objects and standard objects.
  • Used Data Loader for Data Management in force.com platform.
  • Perform administration tasks as needed, behind the scenes system admin managing custom fields, integration, and data clean up.
  • Involved in security levels and privileges by customizing Salesforce.com Profiles and Roles.
  • Integrated Salesforce.com with external systems using Salesforce Partner Web Services for approval and custom workflow solution.
  • Developed Salesforce.com sites and customer portal for various organizational units and partners.
  • Developed custom Apex triggers for approval and custom workflow solution.
  • Migrated Accounts, Lead, and Contact Opportunities sales data from external systems into Salesforce.com.
  • Developed Salesforce.com triggers for custom objects as part of workflow rules.

Environment: Salesforce.com, Sharing Rules, Workflows, Email Updates.

Confidential, Red Bank, NJ

Sales force Administrator

Responsibilities:

  • Created detailed data mapping document for integrating various systems with Salesforce.com.
  • Worked as Salesforce admin support governing user account creation, personal information setup, password reset, Roles & Profile creation, user group creation, updating company profile, Network access setup.
  • Involved in setting up field level access for each custom object created based on the user’s role within the organization.
  • Worked with field & page layout customization for the standard objects like Account, contact, Leads.
  • Involved in customizing custom objects, tabs, fields, page layout as per the business need.
  • Defined lookup and master-detail relationships on the objects and created junction objects to establish connectivity among objects.
  • Created the workflows for automated lead routing, lead escalation, alerts and custom coaching plans.
  • Created workflow rules and defined related tasks, time triggered tasks, email alerts, filed updates to implement business logic.
  • Involved in security levels and privileges by customizing Salesforce.com Profiles and Roles.
  • Integrated Email with Salesforce.com for mass E-mail management and designed various custom E-mail templates.

Environment: Force.com, Apex, Data Loader, Import Wizard, Eclipse IDE, Triggers, Security Controls.

Confidential

SSIS/SSRS/SSAS SQL Developer

Responsibilities:

  • Interacted with business analysts to understand the business requirements.
  • Created logical and physical database design using Erwin.
  • Wrote complex T-SQL/PL-SQL queries for data extraction.
  • Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
  • Created T-SQL triggers and Stored Procedures encompassing business rules.
  • Wrote DTS packages to move data between production, staging and QA environment.
  • Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
  • Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
  • Created database objects for improving the performance.
  • Fine-tuned Procedures, Functions and Triggers for optimum performance.
  • Involved in creating SQL Reports. Deployed SSRS Reports in SharePoint Environment and Worked with end users in troubleshooting and replicating the bugs.
  • Involved in the SQL Query Performance Tuning.

Environment: SQL Server 2005/2000, SSRS, SSAS, SSIS, SQL server 2005 Management Studio, Query Analyzer, MS Project, MS Access 2000, MS EXCEL 2000, Windows 2000, Enterprise Manager, Erwin, Data Transformation Services (DTS).

Confidential

Programmer/Designing

Responsibilities:

  • Responsible for testing of application on various levels like integration and component testing by utilizing various methodologies
  • Interfacing LCD with the chip component unit
  • Programming timers and counters using Visual Basic and C++ languages
  • Analyzing the architecture of components and displays.

Environment: Visual Basic, Matlab, MS Access 2000, Windows 2000

Confidential

Java Developer

Responsibilities:

  • Part of the team which was responsible for designing and developing the application in n-tier fashion as per struts based MVC architecture standards
  • Responsible for developing the Registration modules of the wholesale application
  • Utilize the various Java Design patterns to develop the Business modules based on the required functionality
  • Responsible for developing the application level flow by utilizing Java, JSP, Struts, Servlets, Hibernate, EJB, JNDI, JDBC and JMS
  • Responsible for developing the OS specific scripts (Shell Scripts) for automating the closing doc Process
  • Used java Script front end Validations

We'd love your feedback!