SUMMARY

• 6 years of overall experience in analysis, design, development, testing and maintenance of enterprise applications leveraging Microsoft SQL Server, Power BI and CRM Siebel.
• Extensive expertise in all areas of the data life cycle from ingestion to consumption.
• Experience in full life cycle software development process including system analysis, design, coding, testing.
• Excellent RDBMS skills. Very good experience in SQL Server, T - SQL, Stored Procedures, Triggers, Oracle, PL/SQL and Data Modelling using Normalization techniques.
• Worked with Stored Procedures, Database triggers and Views in SQL Server 2008, 2016, Oracle Databases
• Experienced in Data Warehouse Modeling with SQL Server Analysis Service (SSAS).
• Expert in using tools like Bulk Copy (BCP), Data Transformation Services (DTS) and SSIS.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• In - depth noledge of Transact-SQL (DDL, DML, DCL), Design and normalization of the database tables and Relational Database Management Systems.
• Proficient noledge of writing, modifying and implementing Tables, Stored Procedures, Functions, Views, Indexes, Triggers, Cursors, Joins&User Defined data types.
• Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Drill-Up, Drill-through, Top N, Summary, Form, Lists, Sub reports, Matrix Reports and formatting them.
• Experienced in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Experienced in migration of Data from Excel, Flat file, Oracle to MS SQL Server using MSSQL Server DTS and SSIS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS Packages.
• Experienced in Cube designing to create shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Experienced in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server 2005/2008 Analysis Services Business Intelligence (SSAS, SSRS)
• Experienced in Logical Data Modeling, ER Modeling, Data warehouse design concepts, Dimensional Modeling using Star/ Snowflake Schemas, Normalized and De-normalized Schemas with respect to query and analysis requirements.
• Experienced with working on Power BI and related reporting tools to produce variety of Dashboards.
• Experience in using Version controlling tool Visual Source Safe, TFS
• Experience in working with geographically dispersed team and in providing 24/7 technical and end user support to BI solutions.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, Python.

Databases: SQL Server, Oracle.

IDEs: Visual Studio 2012 IDE, Visual Studio 2015, SQL Server Data Tools, Business Intelligence Development Studio, SQL Management Studio, Power BI

CRM: Siebel 7.X, Siebel 8.X, Siebel Sales, Tools, Configuration, eScript, VB script, Workflows, Task Based User Interface

Siebel Skills: EAI (VB/COM, VBC), EIM, eScript, Siebel VB, Actuate, Siebel Tools

Operating Systems: Windows 98/ 2000/ XP/ Vista/7/8, MS-DOS, Windows 2003/2008/2012 Server.

SQL Server Tools: SQL Server Tools: SQL Service Analysis Services (SSAS), Integration Services (SSIS), Reporting Services (SSRS), SQL Profiler, Query Analyzer, Export & Import

PROFESSIONAL EXPERIENCE

Confidential

SQL BI Developer

Responsibilities:

• Participated in requirement gathering and analysis working with the business analysts and the PM team.
• Developed PowerBI reports on Sales analytics for the org as requested by peer engineering teams.
• Organized Demos & training sessions to the team about the learning.
• Responsible to create detailed design and technical specification documents.
• Involved in the Migration from Oracle 10g to SQL Server Environment.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Created SSIS packages by using various Transformations,Containers to import and export data.
• Developed many Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports, Bar Graph Reports, and Cascading Parameters Reportsusing SQL SSRS 2010/2012.
• Worked on Developing and Publishing Power BI Dashboards in Power BI site.
• Created relationships between tables in Power BI using Star and Snowflake schemas.
• Created Power BI Dashboards using different type of Slicers and different Visualizations like Bar Charts, Line Charts, Graphs, and Pie Charts etc.
• Actively developed and deployed a variety of dashboards in Periscope Data using different types of charts and various levels of granular aggregations.
• Converted complicated Crystal Reportsto Standard SSRS reports by creating stored procedures and mapping parameters thus by enabling Business Users easy access to one stop Reporting Solution via SSRS.
• Performed typical Database Maintenance tasks such as back up, restore, monitoring files, file groups and ensuring overall good health of the systems.
• Provided On-call support for multiple applications.
• Responsible for backend testing of SQL objects.
• Involved in post-production issue triages and debugging.

Confidential

CRM Siebel Support

Responsibilities:

• Responsible for Incident resolution within SLA’s.
• Worked as Point of Contact to two Countries.
• Involved in configuration related development tasks.
• Responsible for preparation of Unit Test cases.
• Prepared Technical design documents for the business requirements and involved in Technical Review meeting.
• Configured Pick lists, MVG, links, joins, Drilldowns, PDQs and defining several other object definitions & linking them to each of the objects defined in the user interface.
• Configured Screen, Views, Applets, Business Components and Business Objects based on business requirements.
• Worked on upgrade from Siebel 8.1.1.7 to Siebel Innovation Pack 2013
• Worked on JavaScript API with Siebel Open UI framework.
• Customize Siebel Open UI using JavaScript.
• Involved in manual testing, Regression testing, Integration testing and system testing.
• Involved in analyzing and fixing the bugs.
• Responsible for handling Interactions with Clients.

Confidential

Siebel Developer

Responsibilities:

• Participated in requirement gathering and analysis working with the business analysts team.
• Involved in design, development and implementation of Maxim Application.
• Responsible to create High Level Design Documents and Detailed Level Design Documents.
• Developed TBUI for various requirements.
• Involved in the study and analysis of the Business Interface requirements and Technical Discussions for the Integration Strategy.
• Prepared Technical design documents for the business requirements and involved in Technical Review meeting.
• Configured Pick lists, MVG, links, joins, Drilldowns, PDQs and defining several other object definitions & linking them to each of the objects defined in the user interface.
• Created Inbound/Outbound Workflow process for the requirements.
• Used the EAI Siebel Adapter and EAI XML Converter business services.
• Used the Process simulator to test the workflow process, Used Business Service Simulator to test the Business Services.
• Configured RCR’s to Invoke Outbound Workflows, created an SR with Siebel Support and had Technical discussions with Metalink team
• Configured Report object in tools designed Actuate Report and deployed it on Report Server.
• Written Custom Business Service using escript to handle Business functionality.
• Extended the base tables to accommodate the additional Fields.
• Configured Screen, Views, Applets, Business Components and Business Objects based on business requirements.
• Customized Applets, Views and Screens according to Client requirements.
• Involved in Daily Smoke Test for the Test Environment and Unit testing the Development Requirements
• Involved in customization of various entities and Siebel Web Templates.
• Provided necessary support during system integration and performance testing.