SUMMARY

• A Qualified IT Professional with 8 years of experience in various IT implementation frameworks.
• Over 3 years of experience in ITSM frameworks Service Now Development and Administration, BMC Remedy, HP Service Desk
• Working experience of various phases of SDLC such as Requirement Analysis, Design, Code Construction and Test.
• Strong skill set in the Service Now suite development including SOAP/REST integration, Web services, Discovery, Workflow, and CMDB.
• Hands on experience on various IT Services of Service - Now tool like Service Catalog Requests, Asset Management, Configuration Management, Service-Now Administration, Incident and Problem Management, Knowledge Management, Content management system(CMS), Reporting, Integration with Web Services
• Expertise on creation of workflows for Service Catalog items in Service-Now. Created web applications
• Service-Now Administration and Production support including maintenance of lower life cycle instances. Familiar with versions Eureka, Dublin, Berlin.
• Functional knowledge and implementation experience of ITSM frameworks.
• Experience in Application Architecture, Analysis, Technical Design, Development, Implementation, Performance Tuning, Testing, Configuration Management.
• Expert on Service Now Discovery module, comfortable deploying discoveries in a multi-datacenter environment. Proven Service Now implementation experience. Multi-domain/service provider model experience within a SNOW platform.
• Understanding of IT service management (ITSM) and the ITIL business process. Maintain service level agreement (SLA) and monitor an SLA workflow. Expertise from Berlin through Eureka versions.
• Create, monitor, modify, and publish service catalog workflows with approvals. maintain Single Sign-On integration
• Create an access control rule (ACL).Use of scripting tools and Service Now functionality to create script to automate routine tasks being done in Service Now.
• Loads, manipulates and maintains data between Service Now and other systems.
• Familiar with Service Now Content Management System (CMS)
• Configuration Development and development of Requirement Integration components (SSO, LDAP).
• Strong team player, ability to work independently and in a team as well, ability to adapt to a rapidly changing environment, commitment towards learning, Possess excellent communication, project management, documentation, interpersonal skills.
• Experience in Integrating App Exchange Applications with Eclipse IDE in Sandbox and Production Environments.
• Involved in database designing by creating database objects such as Tables, Views, and Indexes and developed code in the mid-tier server integrating Service Now with other IT systems.
• Experience on LDAP Integrations using SAML2.0
• Configure Service-Now tool for the defined processes. Design and develop scripts for any customization required. Supporting Power shell scripting in workflows.

TECHNICAL SKILLS

ITSM Tools: Service-Now, ITSM Suite, HP Service Manager, HP Asset Manager

Operating Systems: Windows Server (NT, 2000, 2003, 2008), Windows Client (7, Vista, XP-Pro, 2000, etc)

Scripting Libraries: JQuery, Java Script, Apache Jelly, Angular, Knockout, Hadoop, Sqoop, Flume.

Databases: MS SQL Server 2012/2008 R 2/2008/2005/2000/7.0 , MS SQL Server 2005/2008/2008 R2/2012 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS),, Business Intelligence Development Studio (BIDS), Oracle 11g, XML, XSL, VB script.

Scripting: Visual Basic, Windows PowerShell, HTML, and JavaScript, Perl.

Web Technologies: HTML 5, CSS, ASP.NET, Web Services, WCF, MVC, REST Web API

DB scripting: SQL, SSIS, ETL.

Reporting: SSRS

PROFESSIONAL EXPERIENCE

Confidential - Phoenix, AZ

Service Now Developer / Administrator

Responsibilities:

• Development of Service catalog which includes creating new catalog items, designing workflows and execution plans.
• Created functional and technical specifications documents for various Service Now modules
• Implementation, Customization and Maintenance of ITIL modules such as Incident, Change, Problem, Knowledge, Service Catalog, CMDB in Service Now
• Coordinating the instance upgrade activities.
• Involved in cloning activities like raising the request for cloning and excluding some tables to not come under cloning.
• Worked on change management module by enhancing the tool to the stakeholders and made it easy to understand.
• Configured multiple Catalog Items Front-end web / GUI components using JavaScript, Soap, web services, CSS, HTML5.
• Worked on UI Macros to create pages as templates on requirement from the stake holders
• Configured multiple forms for Asset module using Configuration Management Database.
• Resolving typical Users access and roles issues by checking active directory and users table.
• Created database views to pull the reports on variables which are being used by catalog items.
• Writing Catalog client scripts and UI policies to make client side changes.
• Creating the UI pages to use them in catalog items, Implemented using UI scripts.
• Creating Knowledge articles to document the steps in creating the catalog items.
• Working on different kinds of variables and variable sets.
• Worked on Calgary, Berlin Patch, Eureka versions.
• Working on order guides, to arrange them in sequential order to make the user comfortable while raising a request.
• Re-designed workflows using workflow editor, Reconciled complicated workflows to simpler form.
• Writing script includes invoking them in reference qualifiers or variable scripting.

Environment: Service Now (Eureka), ITIL, JavaScript, Jellybeans, Web Services, XML, DHTML, JQuery, JSON.

Confidential, San Francisco, CA

Service Now Developer / Administrator

Responsibilities:

• Development of Service catalog which includes creating new catalog items, designing workflows and execution plans.
• Created functional and technical specifications documents for various Service Now modules
• Implementation, Customization and Maintenance of ITIL modules such as Incident, Change, Problem, Knowledge, Service Catalog, CMDB in Service Now
• Coordinating the instance upgrade activities.
• Worked on change management module by enhancing the tool to the stakeholders and made it easy to understand.
• Worked on creating Client Scripts, Business Rules, Script Includes, UI Policies, UI Actions, Email Notifications, and Email Templates.
• Glide AJAX, UI Macros, Email Scripts and UI Pages.
• Worked on domain separation.
• Worked on DISCOVERY and set up mid servers and check for the connectivity, Became an expert in troubleshooting Discovery tool.
• Configured multiple Catalog Items Front-end web / GUI components using JavaScript, Soap, web services, CSS, HTML5.
• Experience with successfully building a widely adopted CMDB.
• Worked on UI Macros to create pages as templates on requirement from the stake holders
• Configured multiple forms for Asset module using Configuration Management Database.
• Resolving typical Users access and roles issues by checking active directory and users table.
• Created database views to pull the reports on variables which are being used by catalog items.
• Writing Catalog client scripts and UI policies to make client side changes.
• Creating the UI pages to use them in catalog items, Implemented using UI scripts.
• I have experience a repackaging of thought bot'sBourbonas a Compass extension
• Creating Knowledge articles to document the steps in creating the catalog items.
• Working on different kinds of variables and variable sets.
• Re-designed workflows using workflow editor, Reconciled complicated workflows to simpler form.
• Writing script includes invoking them in reference qualifiers or variable scripting.

Environment: Service Now (Eureka), ITIL, JavaScript, Jellybeans, Web Services, XML, DHTML, JQuery, JSON.

Confidential -San Francisco, CA

Service Now Developer/ Administrator

Responsibilities:

• Assisting client implementing the MSP (Managed Service Provider) instance for Service-Now and Domain separation for Service-Now Instances.
• Working with client and functional requirements within Service Now.
• Facilitating rollout of new applications and modules.
• Design and implement new functionality using Business Rules, UI Policies, and Access Lists etc.
• Service Catalog and Request Workflow Design and Configuration.
• Experience with Nebula/Service Watch a plus.
• Created various workflows for Incident Management, Change Management, Service Requests and SLA's.
• The service we also provide to clients is a semi managed service for administering their Service desks that has been implemented. This includes various administration tasks within Service desk software.
• Created Buttons and context menus both on form and lists using UI actions
• Designed many email templates by using html and jelly scripting and used them in notifications
• Worked with windows team, network team and Asset team in order to check for the data collected through discovery is accurate.
• Written script includes and invoked them in business rules and client scripts
• Imported many ci's using import set tables
• Imported Active Directory to Service now using data sources.
• Created data sources and loaded the Service-Now tables with different data formats
• Created transform maps both automatic field mapping and scripting.
• Worked on Fuji Version.
• Also worked on Asset Management and loaded the data into it.
• Integrated Fire eye tool with Service-Now using Email integration i.e. inbound actions scripting.
• Worked on the integration of Service Now with Siebel, integrated Service Catalog and Incident module.
• Used JMS integration to fulfill this requirement, worked on Scheduled Jobs and Mid Server Script Includes to fulfill the requirements.

Environment: Service Now (FUJI), ITIL, JavaScript, Web Services, XML, DHTML, JQuery, JSON, SCRUM

Confidential - Rockville-MD

Service Now Developer

Responsibilities:

• Use & Administration of common platform applications: Knowledge Base, Service Catalog, Workflows, SLA's, Reporting etc.
• Core Application Administration: Policies & Interactions, Application Security, Events & Notifications.
• Managing client scripts, UI policies, UI actions and Data policies.
• Moving data in and out of an instance using import sets and transform maps and also auto import of data into service now.
• Defining Service Level Agreements (SLAs), notifications, and reports.
• Develops new applications from beginning to end.
• Worked with windows team, network team and Asset team in order to check for the data collected through discovery is accurate
• Written script includes and invoked them in business rules and client scripts
• Imported many CI's using import set tables
• Created data sources and loaded the Service-Now tables with different data formats
• Created transform maps both automatic field mapping and scripting
• Also worked on Asset Management and loaded the data into it.
• Maintains existing applications. Creates code that meets system standards.
• Integration of service now with LDAP for authentication.
• Integration of Service Now with BMC Remedy for ticket creation on change submits.
• Subject Matter expert on Incident Management, Change Management Process and Knowledge article.
• Recommends appropriate design alternatives to be implemented based on customer constraints.
• Develops conversion plans and procedures.
• Develops and executes plans and procedures for data conversion, customer acceptance criteria and installation strategy.
• Migration of customizations from one instance to other instance.

Environment: Service Now, ITIL, JavaScript, Jellybeans, Web Services, XML, DHTML, JQuery, JSON

Confidential - Virginia Beach, VA

SQL/SSRS/SSIS Developer

Responsibilities:

• Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
• Scheduled Jobs to run SSIS package in night feed to ODW for fresh day data.
• Load data form ODW database to Data warehouse using SSIS packages.
• Created sub report and linked reports using MS SSRS 2008 as well as managed the subscription of the reports.
• Developed ETL process using SSIS with Various Control Flow, Data Flow task and Store Procedures for Work Order Validation process.
• Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
• Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
• Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
• Implemented different transformation tools in ETL packages as project requirements, such as slowly changing dimension, lookup, fuzzy lookup, conditional split etc.
• Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.
• Generated daily, weekly and monthly reports for the managers.
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Great ability to create and manage various database objects liketables, views.
• Worked Extensively on ETL process using SSIS package.
• Experience in Data Conversion and Data Migration using SSIS and DTS services across different databases like Oracle, MS access and flat files.
• Experience working with scheduling tools in Tidal.

Environment: MS SQL Server, SSAS 2008, SSRS 2008,2012 SSIS 2008,2012 ProClarity, T-SQL,XML, ETL, Power BI, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Win SQL, SQL Server2000, SQL, Tidal.

Confidential - Virginia Beach, VA

SQL/SSRS/SSIS Developer

Responsibilities:

• As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Responsible for the design, development and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) following company standards and conventions.
• Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.
• Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.
• Strong knowledge of scheduling and atomizing ETL package execution.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Designed and developed enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Involved in the overall SDLC including inception, elaboration, construction and deployment.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Extensively usedtidal in setting up DTS packages, DM Express tasks and jobs, FTP jobs to run daily, weekly and monthly.
• Filter and Sorting Data usingPower BI in Excel 2013.
• Experience in creating ad-hoc reports Using Report Builder 1.0 and Report Builder 2.0.
• Created SSIS packages and transferred them to the appropriate destinations.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• CreatedSSISpackagesfordata Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
• Involved in performance tuning of the database and T-SQL queries using Explain Plan.
• Created SQL server configurationsforSSISpackages.
• Responsible for creating reports based on the requirements using SSRS 2008.

Environment: MS SQL Server, SSAS 2008, SSRS 2008,2012 SSIS 2008,2012 ProClarity, T-SQL,XML, ETL, Power BI, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Win SQL, SQL Server2000, SQL, Tidal.

Confidential, PA

MS SQL Server Developer

Responsibilities:

• Developed complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
• Migration of the data from various sources using DTS.
• Designed, built and implemented a new SQL Server Integration Services package to automate the whole process without any manual intervention.
• Enhanced Data Consistency of System using various types of constraints.
• Involved in the creation of various Integration packages to implement business workflows.
• Developed various stored procedures and functions using T-SQL per business requirement.
• Designed and developed various Service Management Reports and sub-reports.
• Performed SQL Server 2005 database development, data modeling and T-SQL programming.
• Created parameterized reports and ad-hoc reports.
• Responsible for Monitoring and tuning reports.
• Planned the complete back-up of databases for disaster recovery scenarios.
• Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.

Environment: MS SQL Server 2000 Enterprise Edition, MS Access, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, IIS, ASP.NET, Erwin 4.0, Crystal Reports 10