Lead Salesforce/.net Developer/etl Resume
SUMMARY:
- Visionary and result oriented IT professional with over 15 years of Technical Project Leadership and Solution Architect.
- Experiences in driving and managing the full software development life cycle (SDLC) in waterfall and agile/scrum methodology including Offshore/ Onsite model using SpiraTeam, TFS etc.
- Extensive Experience in working with the Business and Technical teams, managing all the stages of SDLC from Requirement Gathering and Specifications, Business Process Analysis, Application Design, Database Design, Estimation & Scheduling, Resourcing & Conflict Management to Implementation & Support.
- Consulting experience including delivery of large projects covering envisioning, effort estimation, analysis, proposal development, and successful delivery.
- Experienced in working on cloud based CRM Salesforce and Marketing tool Eloqua.
- Solid understanding and experience of Object Oriented Design (OOD), Service Oriented Architecture (SOA), Software Design Patterns and BI Solutions.
- Deep technical experience with architecture, design and hands - on programming on diverse technologies like Microsoft (.NET, ASP.NET, SharePoint), Salesforce, Lightning, Apex, Eloqua etc.
- Strategic and technological thought-leadership in key emerging technologies such as Business Intelligence, Collaboration/Portals/Content Management, Integration/workflow etc.
- Well versed with complete project management life cycle based on PMI methodologies including knowledge areas and management process groups.
- Highly organized with excellent communication, interpersonal, and presentation skills; experience at managing multiple projects simultaneously.
TECHNICAL SKILLS:
Languages: C#, VB.Net, WPF, WCF, .Net Compact Framework, GDI+, Remoting, Patterns & Practices, ADO.NET, Web Services, NHibernate, ActiveRecord, Web Client Software Factory, Java (JDK 1.3), VB 6.0, AppForge (VB for Mobile Technology), J2EE, Servlets, JSP, JAVABEANS, COBOL
Web Technologies: ASP.NET, ASP.NET MVC, ASP, JSP, JavaScript, VBScript, HTML, XML, XAML, XSL, CSS, AJAX, WSDL, ASMX, Web Services, Silverlight, Web 2.0
Databases: SQL Server 2005/2000/CE, MS Access, Oracle 9i, DB2, XML/Flat Files
Web/Application Servers: IIS 6.0, Personal Web Server, Tomcat 3.2, Apache, J2EE Server
Development / Scripting / Testing Tools: Visual Studio 2005/2008, Microsoft Expression Blend, Visual Basic, AppForge (Mobile VB), JDeveloper, JRun Studio, Progress 4GL, Dialog, MF Workbench, Dreamweaver, MS Front Page, WinRunner.
Design / Graphic Tools: Erwin, Visio, Magic, Adobe Photoshop, MS Front Page
Reporting Tools: Crystal Report 4.5 & 8 & 10, SQL Server Reporting Services
Version Control: Visual Source Safe, Subversion
CMS: DotNetNuke, Joomla, Business Edge, BIS.NET, WSS 3.0, MOSS 2007.
PM Tools: MS Project 2007, MS Excel, MS Word, PMP Methodologies
Networking: TCP/IP, Routing and Switching, Installation & Configuration, Cabling, Web Hosting
Operating Systems: Windows XP/Server 2003/CE, AS400
PROFESSIONAL EXPERIENCE:
Confidential
Lead Salesforce/.NET Developer/ETL
Responsibilities:
- Involved in companywide project initiatives to provide the technical guidelines, facilitating in appropriate project planning and execution.
- Drive all Salesforce related projects includes
- Future Roadmap planning and implementation strategies.
- New features Development
- Integration to the external Systems developing .NET Rest API
- Sync process using SSIS, Command line data loader etc.
- Salesforce Marketo Integration
- Developed Sync process of preferred practitioner using SSIS
- Developed .NET REST Webhooks.
- Developed process to delete contact in Marketo using Marketo API through Salesforce
Confidential
Salesforce/.NET/ETL Specialist
Responsibilities:
- Involved in companywide project initiatives to provide the technical guidelines, facilitating in appropriate project planning and execution.
- Managed the Technical and Delivery aspects of projects, enhancements, supporting issues and its development.
- Developed and Managed the Information Management System in SharePoint for team coordination and tracking of different aspects of Projects include scope, time and also project risk, project issues.
- Implemented the change control process by developing the Change Management System using three way state of SharePoint to manage Change Requests.
- Developed process of Business Requirements, Defining Scope, Estimating Resources, Evaluating and Selection of Solution Options in collaboration with Business/Solution Analysts & Infrastructure teams
- Worked closely with the team of developers and testers for the projects task tracking
- Supervised the working sessions of developing and architecting enterprise solutions of cloud based CRM Salesforce and Marketing Automation tool Eloqua collaborating with Sales and Marketing Senior leadership.
- Worked and directed the business and Eloqua Professional Services to adopt Application Life Cycle Management for the success of the project with appropriate deliverables.
- Ensure and maintain data integrity between two systems;
- Troubleshoot and resolve data transfer, import, and export failures
- Conduct root cause analysis and recommend solutions for recurring production data issues
- Development of scripts, SQL queries, data mapping, and configuration of data transformation tools
- Designed and developed the .NET Services for performing the real time updates of Opportunity Split functionality in Salesforce.
- Wrote Apex triggers for the campaign syncing of campaign members from Eloqua to Salesforce.
- Install and configured data.com clean module in Salesforce.and also made relevant changes in the validation rules.
- Designed and performed code changes for the lead conversion process using data.com Search and Match API from DnB.
Environment: Salesforce, Apex, C#, VS 2012, SQL Server 2008, SQL Server BIDS, SSIS, JavaScript, JQuery, Eloqua.
Confidential, Miami FL
Sr. Solution Architect
Responsibilities:
- Responsible for architecting all possible models of enterprise applications in a highly complex yet well structured environment based on smalltalk and Mainframe using EAI layer
- Understanding of Mainframe CIS and Confidential application systems to propose overall SOA based architecture
- Architected and developed processes that worked throughout the system using EAI (Enterprise Application Integration) Framework.
- Worked as a liaison with Confidential, EAI and Mainframe team to provide best technical expert decisions on number of services to be developed for each Confidential application.
- Architected and Developed architectural flows for each application in Confidential .
- Assisted EAI team in the creation of xsd’s for developing Web Services.
- Involved in the design and development of WCF Services
- Development of UML based diagrams like Sequence, Component, and Deployment etc.
- Involved in the unit and system testing for Confidential application release.
- Involved in gathering the requirements and inspecting the data feeds.
- Developed design specifications including mapping details and transformation rules
- Created SQL Scripts of tables, stored procedures and views involved in the data transportation
- Developed and unit tested complete ETL Package using SSIS.
- Assisted QA in running the ETL process and data verification.
- Worked with the Network team in setting up the ETL jobs to be run on schedules in Production.
Environment: VB.Net, TFS 2010, VS 2010, SQL Server 2008, SQL Server BIDS, SSIS, JavaScript, HTML, XML, JQuery, LINQ, Entity Framework, IIS 6, Agile (Scrum).
Confidential
Lead Salesforce/.NET Developer/ETLResponsibilities:
- Managed the entire enhancements project using Scrum methodology in TFS 2010
- Lead the project by providing guidance in understanding the existing code, documenting the requirement and understanding code, development of design document including class, sequence and flow diagram.
- Involved in laying out the Requirements, tasks, their estimates along with the iteration plan and schedule.
- Managed the communication among various stakeholders by providing daily, weekly and monthly status report along with the burndown chart.
- Lead the daily meetings to understand issues and facilitating.
- Hands on coding and guided team fellows for using better coding standards including developing the Test project for unit testing.
Environment: .Net Framework 4.5, C#, Web Services, VisualWorks, Mainframe SOAP UI, WCF, Web Services, EAI Framework,TFS 2010 SQL Server BIDS, Microsoft SQL Server 2008, Flat File, Microsoft Visio, Windows XP, DB2.
Confidential
Lead Salesforce/.NET Developer/ETLResponsibilities:
- Derive the entire project in SCRUM using TFS 2010
- Provide expert guidance in story boarding, Planning Poker, iteration time boxing, iteration planning, build configuration and code management.
- Lead the project by defining the process of requirements definition, prioritization and detail gathering.
- Participated in requirement gathering sessions with business, analyst and technical team understanding business needs and provide expert technical solutions as per requirement.
- Modeled database changes and provide architectural specifications better server the requirement.
- Conducted offshore and on-site entire coordination assisting in development efforts including hands on coding of few features.
- Developed process of branching and merging along with managing the check in and check out of the code across the build and iterations.
- Took active role in the deployment of the solution for each iteration and also for the production, smoke testing and code labeling.
Environment: ASP.NET, C#, WCF, TFS 2010, Crystal Report 2008, MS Report Viewer 2010, SQL Server 2008, JavaScript, HTML, XML, jQuery, LINQ, Entity Framework, IIS 6, Scrum.
Confidential, Orlando
Sr. Technical Lead / Technical Manager
Responsibilities:
- Coordinating projects through agile SDLC methodology from all Management, Technical and Service delivery aspects.
- Plan, lead and coordinate activities of IT Business Solution projects to ensure goals and objectives of projects are accomplished within prescribed time frames
- Participated in Planner Poker game providing Fibonacci sequence number for high level estimation of the requirements under Product Backlog for Budgeting and appropriate planning of future Iterations.
- Manage and develop the build plan for each Iteration (Sprint) within the given time-box working closely with the application manager using SpiraTeam
- Involve in various JAD Sessions with business, analyst and technical team understanding business needs and provide best technical solutions for the enhancements of the application.
- Involved in database modeling, designing and architectural specifications development providing expert judgment to produce best scaled model for optimize application.
- Integrating the application using SOAP based web services with SAP (TIBCO) and Virage Media Bin systems
- Architect and developed the thread based windows utility for bulk update of the material data from SAP system.
- Involved in coding and development of features, web services and class wrappers for new enhancements.
- Provide weekly and monthly task report containing Key Updates, Accomplishments and KPI details, .
- Involved in database modeling and architectural specifications development providing expert judgment to produce best model for optimize application.
- Mentoring the development team to adopt best programming practices using general and technology based guidelines for Microsoft Technologies.
- Conducted code and test cases reviews and technical sessions with the development and testing team.
- Responsible for the deployment of build releases for different sprints and performed smoke testing including production release.
- Responsible of maintaining TFS for code management of Development, Support and Production branches, merging of Development branch into Production after each Production release.
- Conducting offshore and on-site entire coordination assisting in devleopment and requirements task.
- Closely worked with the team for the system performance efficiency by Optimizing SQL Queries and improving application code.
- Also acted as a scrum master in daily stand up (Scrum) call taking lead role of running and managing the meeting, understand issues from business, requirements, technical and testing side and involved in making appropriate decisions.
Confidential
Lead Salesforce/.NET Developer/ETLResponsibilities:
- Legacy Data Extraction
- Fields and Data Mapping process
- Developed data cleansing rules.
- Developed Data Cleansing process
- Developed SSIS Packages and database script for Transformation and Loading into the new System
- Developed Data verification process after data loading into new system.
- Automates the process of Transformation and Loading into migration.
Environment: ASP.NET, C#, VB.Net, Web Services, WCF, WPF, TFS 2010, VS 2008/2010, Crystal Report 2008, MS Report Viewer 2010, Visual Source Safe, SQL Server 2005/2008, SQL Server BIDS, SSIS, MS Access, Javascript,HTML, XML, JQuery, LINQ, Entity Framework, IIS 6, Agile (Scrum), Spira Team, .
Confidential, New Jersey
Sr.Systems Analyst / Technical Manager
Responsibilities:
- Provided leadership assistance in identifying, evaluating and developing procedures that are cost effective and meet user requirements.
- Assessed Business Requirements to develop preliminary scope statement including dependencies, constraints and assumption with timelines and cost.
- Analyzed the business needs to help prioritize requirements, identify business problems and propose solutions.
- Guided organization in software re-engineering both in technology and functional aspects by creating proper conversion strategies.
- Interfaced with business users to prepare and update Business Process Requirements (BPR) and Software System Requirements (SSR). Created test cases and test scripts.
- Applies specific functional and/or business expertise to perform assigned tasks and develop specific project deliverables.
- Documents, tracks, and resolves issues related to data quality.
- Designed and document software solutions.
Confidential
Web Analyst / Supervisor
Responsibilities:
- Involved in business sales activities to understand requirement scope and perform feasibility for project acquisition.
- Performed GAP and Risk analysis of existing content management system and evaluated benefits of new system.
- Gathered requirements during inception phase, documented and delivered functional specification documents, and assisted architecture analysis and design using UML.
- Helped manage risk analysis and mitigation plans, status reports, and client presentations; prepared business process models, defined milestone deliverables, and established critical success factors.
- Provided Weekly Project Status Report and Progress Report (10 websites at one time) to the Administration and Customer
- Identification of Resources per project, task assignment and successful execution with timely project delivery.
- Interaction with offshore clients for assuring their satisfaction by listening to their needs and fulfilling them, by understanding their issues and resolving them.
- Completes project activities on time and within budget, and proactively identifies and communicates issues that may jeopardize milestones or project budget to the Project Manager.
- Guides and advises less-experienced Business Analysts.
- Mentor and coach junior developers, web engineers in adopting best programming practices and, debugging methodologies for quality production.
- Adheres to project management methodology by utilizing internal procedures and tools and identifying areas for methodology improvement.
- Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
- Conducted Joint Application Development (JAD) sessions with stakeholders throughout SDLC to resolve open issues
- Performed several Database activities like installation, created databases, tables, stored procedures, views etc., performed T-SQL, Backup, Restore, DTS etc.
- Involved in many Senior Management (Project Managers, Technical Managers, COO, CEO etc) meetings, activities and decisions like “Employee Retention Program”, “New Business Prospects” etc.
- Actively participated in web hosting activities and provide technical support to hosting issues.
- Developed Standard Templates for Project Plan, Project Status Report and Progress Report using MS Project.
- Configuration Management for proper and secure source versioning and record keeping.
- Standardized Web Development Process Cycle and ensure successful execution for smooth transition of all the phases included Pre-sales, Requirements, Concept (Design), Implementation, Development, Testing, Deployment (hosting) for timely delivery.
- Improved Organizational Chart for successful handling of multiple projects.
- Carried out project based Resource Performance Measurement and their confirmation and annual appraisals.
Environment: BIS.Net, DotNetNuke, Catalook, C#, ASP.NET, VB.NET, XML, XAML, Silverlight, WPF, WCF, WinForms, Enterprise Library, ADO.NET, Web Services, WSDL, UML, Visual Studio 2005/2008, IIS, SQL Server 2005, Oracle, ASP Classic, Visual Source Safe, Windows XP/Server 2003, Project 2007, Microsoft Visio, Microsoft Office 2007, Mantis (Bug Tracking Tool).
Confidential, New Jersey
Consultant (Sr. Programmer Analyst)
Responsibilities:
- Analyzed DB2 Database to convert data into XML format.
- Developed Module for manipulating various XML data formats based on different clients for graph creation.
- Creation of various configuration files containing server, graph and network specs.
- Serialization/Deserialization of configuration file.
- Use COM Interop in order to create graphs.
- Designed and developed complete GUI.
- Developed interface to read Barcode and generate inventory.
- Create Barcodes for distributed products and provide Error log.
- Generates order reports in xml and csv formats.
- Create module that convert orders to promail format and generate error log of invalid orders.
Environment: C#, VB.NET, WinForms, XML Serialization/Deserialization, XSD, XPATH, GDI+, XML, Mail, Socket, Java Library, ADO.NET, Promail, MS Access, MS Visio, Windows XP.
Confidential, Miami
Programmer Analyst
Responsibilities:
- Done entire system analysis.
- Proposed computer solution and generated functional report.
- Developed context diagrams, use cases, sequence diagram, Entity Diagram, component model etc. using Magic.
- Developed classes, interfaces etc. for both web and PDA’s.
- Created custom web controls for web and custom controls for PDA’s.
- Designed the entire GUI for both web and PDA’s using Visual Studio.NET, Dreamweaver, Adobe Photoshop, JavaScript, and CSS.
- Database maintenance, security, backup.
- Created SQL queries, triggers, and stored procedures.
- Actively participated in performing and writing test plans, test cases etc for unit and integrations testing both manual and automatic using Win Runner.
Environment: C#, VB.NET, GDI+, ASP.NET, Web Services, HTML, JavaScript, CSS, XML, XMLHTTP (AJAX), IIS 5.1, Oracle 9i, SQL Server 2000, Magic, UML, ERWin, Adobe Photoshop 7, Dreamweaver, Windows XP, Windows CE, Pocket PC, Win Runner.