Technical Architect/sfdc Developer/business Analyst Resume
Mclean -, VA
SUMMARY
- Over 11 years of experience in Management, Design, Implementation, Upgrading, Deployment and Testing of Enterprise Applications/projects in Siebel and Salesforce.com
- Extensively worked as a Techno - Functional analyst in CRM business enterprise and ERP domain and have vast experience in Finance, Hospitality, Product Manufacturing & Pharma industry applications, Call Center, Sales and Marketing applications and Sales Force Automation
- Strong experience and knowledge in Siebel and Salesforce.com Data Model
- Significant experience in Siebel EIM, Data Load for SFDC Standard objects and Custom objects
- Experience in Business Intelligence Applications and knowledge in generating Reports, Dashboards, customize reports and analyzing the data in Salesforce
- Experience in Data Modeling design, analysis and implementation - conceptual, logical and physical data model, Data conversion, Data integration in the area of Data Warehouse and Business Intelligence
- Experience in Object Oriented Analysis / Design / Development / Testing and Implementation, Client/Server Architecture
- Participated in managing projects through various Software Development Life Cycle phases
- Extensive experience and exposure wif Solution Design Teams, BAs, Business Users group and QA teams and worked wif the Project Management Teams implementing new business processes
- Proficient at software quality stages such as code review, defect prevention, change management etc. at CMM Level 5
- Experience in managing team members and inter-team co-ordination
PROFESSIONAL EXPERIENCE
Confidential, McLean - VA
Technical Architect/SFDC Developer/Business Analyst
Responsibilities:
- Solicit and analyze the business requirements and design to in corporate integration points as required
- Develop detailed technical requirements and present them for review/feedback
- Evaluate and suggest various open-source or commercial small to mid-scale CRM platforms for use of development of HCM - Salesforce, MS Dynamics, Siebel by conducting presentations and demos
- Prototype Salesforce.com module for Sales Lead and Opportunity Management, Account and Contact Management, Approvals and Workflow
- 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
Environment: Salesforce.com, Eclipse IDE, Import Wizard, Apex, Controllers, Visual Force Pages, Workflows, Email Updates, Siebel Data model, Rational Rose and MS Office for detail documentation
Confidential, Bethesda - MD
Technical Architect/Integration Analyst
Responsibilities:
- Solicited the business requirements and implemented Order, Account, Contact, Service Request and Activity management modules, Reports and Dashboards
- Involved in all stages from high level analysis to coding, final testing and deployment
- Implemented best EIM practices in mapping Siebel data wif external data - worked wif data import/export/delete along wif integration of legacy systems, wrote complex SQL queries, configured and optimized config (IFB) files to run EIM jobs for imports and updates, data mappings, Data Conversion
- Configured and customized the Applets, Views, Screens, Business Components, Business Objects though Joins, MVLs, Links and MVGs; configured Picklists(Static and Dynamic), LOVs, Toggles and Drilldowns
- Extended the Siebel tables through Custom tables - columns and created User keys and Indexes
- Implemented the Declarative Config Alternatives using Data Validations, User Properties, Workflows and Run-Time events, customized the application using Siebel VBScript and eScript for functionality extension
- Implemented SalesForce.com to provide customer feedback results; integrated the hotel's reservation management system wif their SalesForce CRM
- Designed SFDC workflow rules and nightly APEX job to email patrons, reminders of their reservation, as well as a survey-3 days after checkout
- Developed SFDC reports and dashboards to provide strategic planning for better customer service and help make data driven decisions
- Co-ordinated and implemented various Change/Work requests and enhancements
- Supported User Acceptance as well as Beta Testing for various production releases and upgrades
Environment: Siebel 8.x, Siebel 7.x (Sales, Public Sector, Service & Marketing, Finance) - Workflows, Siebel VB scripts and eScripts, EAI, EIM, Siebel Tools and configuration, Siebel Local database; SalesForce.com; Visual Force Pages; Custom Tabs and Page Layouts; Oracle 11g, PL/SQL, UNIX
Confidential - DC
Sr. Siebel Developer / Integration Specialist & OBIEE reporting
Responsibilities:
- Implemented best EIM practices in mapping Siebel data wif external data - worked wif data import/export/delete along wif integration of legacy systems such as CATS,TIGER
- Designed and developed reports and statistical information sheets using OBIEE tool; Experience in creating entity relational & dimensional relational data models wif Dr. Ralph Kimball Methodology i.e., Star schema and Snowflake schema
- Wrote complex SQL scripts and procedures to generate reports essential to the business users
- Involved in all stages from high level analysis to coding, final testing and deployment
- Configured and customized the Applets, Views,Screens,Business Components, Business Objects though Joins, MVLs, Links and MVGs
- Extended the Siebel tables through Custom tables - columns and created User keys and Indexes
- Coordinated and implemented various Change/Work requests and enhancements
- Supported User Acceptance as well as Beta Testing for various production releases and upgrades
Environment: Siebel 8.x, EIM, Siebel Tools and configuration; SQL Server 2005; MS-SQL, Informatica Power Center 8.x/7.x/6.x, OBIEE 10.1.3.2, Clear case, Visual Source Safe
Confidential, Bethesda - MD
Siebel Architect
Responsibilities:
- Solicited the business requirements and implemented Opportunity, Account, Contact and Activity management modules in SFA
- Involved in all stages from high level analysis to coding, final testing and deployment
- Implemented best EIM practices in mapping Siebel data wif external data - worked wif data import/export/delete along wif integration of legacy systems, wrote complex SQL queries, configured and optimized config (IFB) files to run EIM jobs
- Built custom Business services,Siebel EAI, integration objects, Data Mapper,XML converter, external COM and DCOM for Opportunity and Billing credit reservation system in SFA
- Integrated Siebel through IBM MQ series middleware using integration objects and XML
- Configured and customized the Applets, Views,Screens,Business Components, Business Objects though Joins, MVLs, Links and MVGs
- Configured Picklists(Static and Dynamic), LOVs,Toggles and Drilldowns
- Extended the Siebel tables through Custom tables - columns and created User keys and Indexes
- Implemented the Declarative Config Alternatives using Data Validations, User Properties, Workflows and Run-Time events, customized the application using Siebel VBScript and eScript for functionality extension
- Designed and built Actuate and Access Reports
- Built various UNIX shell scripts for implementing reports to send out SFA data to business users
- Co-ordinated and implemented various Change/Work requests and enhancements
Environment: Siebel 6, Siebel 7 - Workflows, Siebel VB scripts and eScripts, EIM, Siebel Tools and configuration; Oracle 9i, PL/SQL, CTL file, Batch command file, Unix
Confidential, Tempe - AZ
Team Lead/Siebel Analyst
Responsibilities:
- Managed and lead a development team dat handled day to day change requests / business needs; involved in direct interaction wif customers/end users for requirements
- Provided assistance to the project management and QA teams on effort estimation, schedule planning, creating project plans, high-end analysis, milestone reports, test cases ; performed interfacing role wif various client-site groups, other development groups, Business groups and end-users
- Followed CMM Level 5 activities during the project execution
- Practiced SLA rules wif end-users and client to ensure minimal turn around time
- Co-ordinated efficient Onsite-Offshore tech development teams, its interaction and communication
- Managed Code Review and Code Optimization processes for various developmental units
- Participated as a key member in designing, developing and integrating Third Party Model - Miller Hieman (TAS) using Siebel EAI wif workflow adapters, transport scripts, integration objects and XML
- Involved in Admin activities of successfully migrating the repository from development to testing and tan to Production environment
- Built scalable solutions for many interfaces exchanging data wif SAP, Mainframes and other legacy systems using Siebel EIM and EAI practices
Environment: DTS (defect tracking system), Microsoft Project Control (MPC); Siebel 7.7.2, Siebel 7.5 - Workflows, eScripts, EAI, EIM, Siebel Tools and configuration; Oracle 9i, PL/SQL; CVS; Unix, Windows 2000/XP; LoadRunner, QTP
Confidential, Tempe - AZ
Sr. Software Engineer
Responsibilities:
- Implemented the Siebel 6 to Siebel 7 Upgrade project and the GIBC project; performed high-level analysis TEMPeffective design solutions, methods and gatheird detailed business requirements
- Designed and executed the integration of legacy applications so as to decommission certain legacy functionality
- Redesigned entities like Opportunity, Service Requests, Activity, Product and Campaigns
- Involved in writing complex SQL queries, stored procedures and Shell scripts for Data Extraction and Migration and wrote Siebel EIM files and batch jobs
- Built various interface implementations (developed externally managed VBCOM Interfaces - out of box functionality) ; actively involved in inter-team co-ordination and technical discussions
- Successfully executed various pre and post Upgrade tasks involving Siebel concepts like EAI, Workflows, Workflow policies/triggers
- Prepared excellent technical specifications and test case documents / results
- Provided post production support for the application and addressed the issues/defects
- Utilized VSS and CVS for managing software configuration and tracking of documents
Environment: Siebel 7.7, Siebel 6x– Workflows, EIM, configuration, scripting, Assignment Manager, Siebel Tools; Oracle 9i, PL/SQL, SQL Plus; VB 6 ; Unix; CVS, VSS; DTS(defect tracking system)
Confidential, Tempe - AZ
Software Engineer
Responsibilities:
- Developed and designed several PL/SQL Stored procedures to integrate outside systems wifin Siebel Data Framework; Optimized complex queries and stored procedures so as to reduce the network traffic between database server and the Application server
- Prototyped modules in Siebel 7.5 on Oracle 8i, like Product management, Opportunity, Activity, CTI, Campaigns, Responses
- Designed the UML diagrams for the system requirements
- Participated in software processes like Code Review and Defect Prevention
- Prepared detailed design and technical documents for various components of the Siebel 7.5 application
- Configured and customized the Applets, Views,Screens,Business Components, Business Objects though Joins, MVLs, Links and MVGs and custom configuration through Siebel VBScripts
- Worked wif the project manager/lead in tandem wif other team-members
Environment: Siebel 6.0, Siebel 7.5, Oracle 8i, Rational Rose, CVS, VSS, Windows 2000/XP, UNIX
Confidential
Intern
Responsibilities:
- Researched and designed the entire architecture combining the features of Gnutella and Napster to develop a new file sharing protocol; Directly responsible for code generation, review and testing
- Programmed various modules/entities for the project; Participated in the demo at the end of the assignment
- Documented the project specification and code, pseudo-code
Environment: Linux; Java, InterDev; Rational Rose; Microsoft Office