Siva B

add7bn@r.postjobfree.com Ph: 510-***-****

SUMMARY

15+ Years of IT experience, in leading & developing Enterprise wide applications using cutting edge technologies, C#.Net, ASP.NET,ASP.Net Core, MVC, WEB API, REST, SQL Server, Java Script, XML, Angular,JSON, Business Intelligence and SharePoint.

Experience with complete SDLC life cycle, which includes requirement gathering, analysis, design, development, maintenance and implementation.

Exceptional hands-on experience with Microsoft SQL Server Business Intelligence suite which includes SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS)

Extensively worked on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

Expert level skills with SQL Server DDL/DML Commands and T-SQL in creating Tables, Complex Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Common Table Expressions (CTE's), Sub Queries, Joins, Relational Database Models and Data Integrity in observing Business Rules.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables and established relationships between tables using Primary Key & Foreign Key Constraints.

Extensive experience in Performance Monitoring and Tuning of SQL Server database using tools such as SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor and Enterprise Manager.

Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/Analysis Server - SQL Server Analysis Services (SSAS).

Experience in Multi-Dimensional Expressions (MDX) to query SSAS Cubes, identifying Key Performance Indicators (KPI's) and creating Dashboards/Score-Cards to support operational & strategic reporting requirements.

Hands-on experience with Dimensional Modeling, ER Modeling, Star Schema/Snowflake Schema, Fact and Dimensional tables and operational Data Store (ODS).

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.

Knowledge of developing reports from Cubes using the KPI's for decision-making, also debugged data connections, data sources and Data Source Views.

Expertise in designing complex enterprise reports like Cross-Tab, Drill-Down Reports, Drill-Through Reports, Sub Reports, Charts & Parameterized Reports using SQL Server Reporting Services (SSRS) based on client requirement and deployed across various formats such as Web Browsers, XML, SharePoint and PDF.

Expertise in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

Familiar with Database Administration (DBA) activities in Development/Test environments including Backups, Restores, Security, User management, Troubleshooting and Performance Tuning.

Experience and proficiency in Microsoft Business Intelligence Tools such as Power BI

(PowerPivot, PowerQuery, PowerView), Power BI Desktop tool, Power BI Cloud, SQL Server

Reporting Services (SSRS), Tableau, and ETL tools like SQL Server Integration

Services (SSIS).

●EDUCATION SUMMARY

Master of Computer Applications (Andhra University, India) 1996 - 1999.

Bachelor of Science in Electronics (Andhra Loyola, India) 1993-1996.

Skills

Design Methodologies:

OOP, OOA/OOD, Agile, Scrum.

JQuery Libraries

JQuery, Angular JS, JSON

Integration Servers:

SSIS, SSAS

Databases / Modeling:

MS SQL Server 2019,2016/12/08, Oracle 9i/ 10g and My SQL, E-R-win tools, MS Vision.

Reporting Tools:

Crystal Report 9.0,SSRS, Power BI, Tableau Dashboard, SharePoint Business Intelligence.

Development Environments and Tools:

Microsoft Visual Studio 2010/12/15, .NET, MS VSS. TFS, GIT, SVN

Operating Systems:

Win 7, Windows NT work station, Windows 2005/2012, Windows 10

Design Tools:

MS Visio and ER-Win

PROFESSIONAL EXPERIENCE

Client: AMBARELLA Inc Nov2016–Till Date

Responsibilities:

●Responsible for architecting, design, develop and implement mission critical applications using the .NET Framework and SQL technologies.

●Responsible for write server-side code for web-based applications, create robust high-volume production applications, and develop prototypes quickly.

●Responsible for Coordinate with business user, Requirement gathering and analyzing the business cases.

●Designed and developed applications using ASP.NET MVC, WEB API, Web forms and C#.Net and Sql Server.

●Responsible for application support and enhancements existing web Applications.

●Responsible for Development and conversion of ASP.Net applications into MVC application.

●Responsible for Business requirement analysis and design.

●Involved in design and development of new modules.

●Responsible for Database changes and creation of new tables and stored procedures.

●Responsible for deployment and testing.

Environment: C#.Net, ASP.Net, ASP.Net MVC, WEB API, Angular JS, Entity framework, SQL server 2016/2012, XML, Java Script, HTML, CSS, MS Visual Studio .Net 2015/2012

Nisum, Fremont, CA May 2016–Nov 2016

Sr. Technical Lead

Projects:

ShopifyGateway

MiraklGateway

Responsibilities:

●Responsible for development of wrapper classes for ShopifyGateway.

●Designed and developed user interface to display Shopify products, order information, order details, images and customer information.

●Created data objects and consumed Web services provided by Shopify.

●Responsible for development of wrapper classes for MiraklGateway.

●Created user interface and consumed Web services provided by Mirakl Web services.

●Designed and developed user interface to display Mirakl products, order information, order details, images and customer information.

●Created data objects and consumed Web services provided by Mirakl.

Environment: C#.Net, ASP.Net, ADO.Net, ASP.Net MVC, Angular JS, WEB API, Entity framework, MY SQL,

XML, Java Script, HTML, CSS, MS Visual Studio .Net 2015, ShopifyGateway, MiraklGateway Web Services.

Client: Palo Alto Networks, Santa Clara, CA May 2015–May 2016

NTT Data Inc

Projects:

https://support.paloaltonetworks.com

https://adminsite.paloaltonetworks.com

Responsibilities:

●Responsible for application support and enhancements of Palo Alto Networks Admin and CSP web site.

●Responsible for Development and conversion of ASP.Net applications into MVC application.

●Responsible for Business requirement analysis and design.

●Involved in design and development of new modules.

●Responsible for Database changes and creation of new tables and stored procedures.

●Responsible for deployment and testing.

Environment: C#.Net, ASP.Net, ADO.Net, ASP.Net MVC, WEB API, Angular JS, Entity framework, MY SQL,

XML, Java Script, HTML, CSS, MS Visual Studio .Net 2012

Client:INSZoom, San Ramon, CA Oct 2014–April 2015

Dew Software inc

Projects: INSZoom Website and Zoom Integration

Responsibilities:

●Involved in development and enhancements of INSZOOM Application.

●Involved in design and development of new modules in INSZOOM Application.

●Design and development of INSZOOM Integration Services using WEB API and SSIS.

●Creating WBS and mentoring offshore development team.

●Quick books integration with INSZOOM.

●Creating SQL Server integration services

●Developing SSRS reports.

●Extensive hands on experience in Microsoft Windows Azure.

Environment: C#.Net, ASP.Net, ADO.Net, WCF,ASP.Net MVC,WEB API, Entity framework, Angular JS,SON,SQL Server 2012, XML, Java Script, HTML,CSS, MS Visual Studio .Net 2012/2013, SSIS and SSRS, Windows Azure

Corsair Inc, Fremont, CA Jun 2013– Oct 2014

Corsair is a global company bringing innovative, high-performance components to the PC gaming market. Specializing in very high performance memory, ultra-efficient power supplies, and other key system components, our products are the choice of overclockers, enthusiasts, and gamers everywhere.

Projects:

●Request for Quote

●IR Management

●Data warehouse (Business intelligence)

Responsibilities:

●Responsible for Coordinate with business user, Requirement gathering and analyzing the business cases.

●Designed and developed applications using ASP.NET, Web forms and C#.Net, Vb.Net.

●Responsible for Testing applications, creating executables and publishing to IIS Server.

●Developed SSAS Cubes with Star Schema.

●Designed SSAS cube to hold summary data for Tableau dashboards.

●Created aggregations, partitions, KPI's and perspectives for a cube as per business requirements.

●Created roles using SSAS to restrict cube properties.

●Was involved in developing Tableau Dashboards using both relational and Multidimensional data.

●Improved the performance of calculated measures in cube by modifying MDX queries in an efficient manner.

●Also developed rolling averages using MDX calculated measures in the cube for analysis.

●Developed Aggregations, advanced aggregations and also usage based aggregation in order to improve the query time performance.

●Created bottom count, top count, cross join and log MDX queries for creating Calculations and KPI's on a cube.

●Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

●Created parallel period, filter, ancestors and cross join MDX queries.

●Developed Aggregations, partitions and calculated members for cube as per business requirements.

●Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

●Developed Aggregations, advanced aggregations and also usage based aggregation in order to improve the query time performance.

●Created bottom count, top count, cross join and log MDX queries for creating Calculations and KPI's on a cube.

●Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

●Defined relationships between Measure groups and Dimensions.

●Defined granularity with in a measure group and drill through actions.

●Implemented the calculations to aggregate physical measures.

●Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.

●SharePoint Business intelligence site creation and configuration. Key performance indictor, charts, reports and Dashboards development and Custom web part development.

●Development of custom features, custom site templates, custom site definitions, web parts, event handlers, feature stapling, delegate controls, document sets, InfoPath forms, custom workflows, solution packages.

● SharePoint 2010 Web services, branding using master pages, page layouts, themes, CSS, Service Application Groups, reporting using Excel Services, Performance Point Services, Visio services, SSRS, OLAP cubes, business intelligence using KPI lists, Dashboard pages, Analytical Charts, integration with Office Web Apps

Environment: C#.Net, VB.Net, VB 6.0,ASP.Net, ADO.Net,ASP.NET MVC,WEB API, WCF,SQL Server 2012, IIS 6.0, AJAX,XML,CSS, Java Script, Angular JS, MS Visual Studio .Net 2012,2010, Oracle, Toad, SSIS, SSAS and SSRS, Share point 2010 and 2013, share point designer, dashboard designer, windows server 2008, Windows Azure.

Neophotonics Inc, Sanjose, CA Jun 2010– June 2013

Current company is a leading developer and vertically integrated manufacturer of photonic integrated circuit (PIC) based components, modules and subsystems for use in telecommunications networks. Our products include active semiconductor, passive PIC and MEMS multi-dimensional switching functions in a single product.

Projects:

●MES

●Forecast

●BI (Business intelligence) and Sharepoint

Responsibilities:

●Responsible for Business requirement gathering.

●Involved in Analysis, Design, development and enhancement of MES System.

●Developed business layer components using C#.NET, VB.Net, VB 6.0.

●Developed SSAS Cubes with Star Schema.

●Designed SSAS cube to hold summary data for Tableau dashboards.

●Created aggregations, partitions, KPI's and perspectives for a cube as per business requirements.

●Created roles using SSAS to restrict cube properties.

●Was involved in developing Tableau Dashboards using both relational and Multidimensional data.

●Improved the performance of calculated measures in cube by modifying MDX queries in an efficient manner.

●Also developed rolling averages using MDX calculated measures in the cube for analysis.

●Developed Aggregations, advanced aggregations and also usage based aggregation in order to improve the query time performance.

●Created bottom count, top count, cross join and log MDX queries for creating Calculations and KPI's on a cube.

●Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

●Created parallel period, filter, ancestors and cross join MDX queries.

●Developed Aggregations, partitions and calculated members for cube as per business requirements.

●Involved in analyzing and designing disaster recovery / replication strategies with business managers to meet the business requirements.

●Developed Aggregations, advanced aggregations and also usage based aggregation in order to improve the query time performance.

●Created bottom count, top count, cross join and log MDX queries for creating Calculations and KPI's on a cube.

●Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

●Defined relationships between Measure groups and Dimensions.

●Defined granularity with in a measure group and drill through actions.

●Implemented the calculations to aggregate physical measures.

●Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculations.

●Involved in installation and configuration of SharePoint 2010 server. Web application creation, continent management and workflow creation.

●SharePoint Business intelligence site creation and configuration. Key performance indictor, charts, reports and Dashboards development and Custom web part development.

Environment: C#.Net, VB.Net, VB 6.0,ASP.Net, ADO.Net, WCF,SQL Server 2008, IIS 6.0, AJAX,XML, Java Script, DHTML, HTML, MS Visual Studio .Net 2010, 2008, Oracle, Toad, SSIS, SSAS and SSRS, Share point 2010, share point designer, Info Path, SharePoint BI, Performance Point Services, dashboard designer windows server 2008.

JDSU, Milpitas,CA Dec 2007 – Jun 2010

Sr Software Engineer

A leading provider of optical products and test and measurement solutions for the communications industry, the JDSU technology portfolio is a key enabler for optical solutions in industries such as broadband communications, semiconductor manufacturing, document authentication, brand protection, and biotechnology

Projects:

●Manufacturing execution system (Camstar Insite)

●Live Connect. (MES and ERP integration)

●MES Data marts.

●EQDB Data mart.

●MDSS and Test Data Base.

●Support for custom applications.

Responsibilities:

●Involved in maintenance and enhancement of MES Functionalities.

●Involved in configuration and maintenance of web modeler and win modeler.

●Involved in developing Custom WEB GUI for Insite.

●Responsible for Production support activities, build and deployments of MESiNET to both test and production servers.

●Involved in Camstar designer maintenance.

●Involved in DB Reset (MDB to SQL Server).

●Creating SSIS package ( DTS ) Jobs and building data mart for generating SQL Reports

●Maintenance and support for Liveconnect interface for MES to ERP(oracle).

●Involved in installation and configuration of camstar Insite and database setup.

●Reports were generated using SSRS (SQL Server Reporting Services).

●Created Datamart using SSIS(SQL Server Integration Services) on SQL Server 2008 and Oracle 11i

Environment: C#.Net, Vb.Net, VB 6.0,.Net, VB 6.0,ASP.Net, ADO.Net, SQL Server 2005, IIS 6.0, AJAX,XML, Java Script, DHTML, HTML,VBA, MS Visual Studio .Net 2005, 2008,, Oracle, Toad, SSIS,SSAS and SSRS.

Client: Santur Corp, Fremont CA Jan 2007 – Nov 2007

HCL, Project Lead.

Santur Corporation, the leading manufacturer of reliable tunable active products for the global telecommunications industry, recently announced its inclusion among the Inc 500 Fastest Growing Private Companies and ranked #12.

Project:

●Manufacturing execution system (FIS)

●MES AND ERP Integration.

●eData Generator

Responsibilities:

●Involved in Analysis, Design and development of MES system, MES and ERP Integration and eData generator.

●Involved in development of Service-oriented architecture (SOA).

●Also involved in Component design, database design and GUI design.

●Business requirement gathering.

●Developed business layer components using C#.NET.

●Developed assemblies (dll’s) to retrieve data from the middle tier and format data and store it in the database.

●Created stored procedures for manipulating the database tables.

●Implemented the Data Access Application Block, which contains all of the functionality necessary to perform the data access for SQL Server 2005 database.

●Creating SSIS package ( DTS ) Jobs in SQL Server 2005 for integration of FIS with ERP.

●Developed reports using SQL Server Reports.

●Development of WIP tracking, MES and ERP Integration and eData generator. .

●Development of User interface for Lot Transactions.

●Used .NET web setup project to make deployment project.

●Creation of windows services.

●Uploading Equipment Test data to customer ftp folder after shipment happened.

Environment: C#.Net, ASP.Net, Win Forms, ADO.Net, SQL Server 2005, IIS, MS Visual Studio 2005, .Net Framework 2.0, XML, SOA, DHTML, HTML, Web Services, Windows services, SQL Server Reports, Oracle, Toad, SSIS package ( DTS) and SSRS.

Client: MAXIM Integrated Products, Portland Oregon, April 2006- Dec 2006

HCL, Lead Engineer.

Maxim is a worldwide leader in the design, development, and manufacture of the analog, mixed-signal, high-frequency, and digital circuits that enable all four of these key interactions. Maxim leverages its proprietary wafer fab technologies and world-class engineering team to develop innovative solutions for rapidly growing markets.

Project:

●Wafer fab Tool Automation.

●

Responsibilities:

●Involved in Analysis design and development of Wafer fab Tools Automation.

●Also involved in development of gold recipe check sum implementation for all wafer fab tools.

●Implementation of equipment constant gold check.

●Created stored procedures for manipulating the database tables.

●Developed business layer components.

●Creation of windows services.

●Developed user interface screens with extensive use of Win Forms using .NET Framework.

●Simulation Testing and installation at wafer fab.

●Implemented the Data Access application block.

Environment: .Net, C#.Net, Vb.Net, VB 6.0,,Oracle, Windows 2000, MS Visual Studio 2005, SSIS and SSRS.

Client: Wyse Technology Inc, San Jose, CA Dec 2005- Mar 2006

HCL, Sr Software Engineer

Wyse is the #1 vendor the world's largest businesses and institutions trust for scalable thin computing solutions.

WSM License Generator consists of a Secure Web site (Login and Password required), which can be accessible via HTTPS. The web site will act as a wrapper to Wyse’s License Generation Command Line Utility. It will invoke the utility with the parameters (query string) supplied by Oracle Apps. The web site will capture the results of the invocation and return the results to Oracle Apps. The web site will also email the newly created license file to the email id parameter. It will audit all requests, invocations, successes and failures to tables in an Oracle database. All information including input parameters, license file, error file etc will be stored to the database.

Project:

●WSM License Generator

Responsibilities:

●Involved in Analysis design and development of WSM License Generator.

●Logging license information and sending emails to customer.

●Developed business layer components using C#.NET.

●Developed assemblies (dll’s) to retrieve data from the middle tier and format data and store it in the database.

●Created stored procedures for manipulating the database tables.

●Involved in Writing Reporting.

Environment: C#.Net, ASP.net, Oracle, Windows XP, Stored Procedures.

Client: Renesas Semiconductor (Malaysia) Sdn. Bhd. May 2005 – Nov 2005

HCL, Sr Software Engineer

Renesas Technology Corp., a result of the merger of the semiconductor divisions of Hitachi Ltd. and Mitsubishi Electric Corporation.

IStar is a customization and enhanced version of Camstar InSite MES system. Camstar is the leading provider of e-manufacturing solutions. By linking customer orders to real-time production information, Camstar's InSite solution is designed to meet the challenges of the most demanding manufacturing environments, offering a common, flexible, Internet-based platform for managing customer orders through multiple plants and processes. Manufacturers use InSite to speed the production of customized products, and provide stakeholders throughout the supply chain with up-to-the-second information and order status. It will have the functionality of Plant-Level Management, Multi-Plant Standardization and Supply Chain Collaboration.

Project:

●Camstar Insite (Manufacture Execution System)

Responsibilities:

●Involved in development of iStar.

●Requirements Study and Analysis

●Involved in implementing and customization of iStar.

●Developed user interface screens with extensive use of Web forms using .NET Framework.

●Created stored procedures for manipulating the database tables.

●CAMSTAR Insite Designer

●Involved in Writing SQL Reporting.

Environment: VB.Net, ASP.net, SQL Server 2005, SSIS and SSRS, Windows XP.

Client: INFINENON TECHNOLOGIES AG, GERMANY. Aug 2004 – April 2005

HCL, Sr Software Engineer

Infineon’s Communication Solutions business group develops, manufactures and markets end-to-end leading edge semiconductor products and solutions for cellular, wireless and wired communications enabling smooth transmission of voice and high speed data from the backbone of the telecommunication network infrastructure to the end user’s equipment.

This is a real-time system. One of the major requirements from the client is dispatching, which basically responds to “what’s next for machine” and “what’s next for material/lot” requests. It takes into account the current status of the materials and resources, and provides an immediate assessment of priorities. The major goal of this product is to achieve very high performance to allow complex dispatching rules to be executed within a sub second. Involved in various activities including data retrieval from Oracle and work stream database and maintaining same in local repository.

Project:

●Port of Fast Dispatcher

Responsibilities:

●Involved in Analysis design and development of Fast Dispatcher

●Involved in Unit Testing and Integration testing.

●Used PVCS for version control

Environment: C#.Net, Remoting, MS Application blocks, Oracle, Windows XP, UNIX,

Custom tools (Tibco, YODA library, WorkStreamDB and IFXConfig etc)

iSoft R & D Private Ltd, UK Dec 2003 – Jul 2004

Sr Software Engineer

The objective of this service is to provide a middle layer caching service for .NET objects, which are frequently used by the Lorenzo application. This service improves performance and availability of the Lorenzo application, by avoiding the memory and processing intensive methods of creating these objects every time they need to be used.

The service has been designed with the deployment considerations in mind and hence supports distributed caching across app. servers.

Project:

●Lorenzo Distributed application Cache and Broadcaster

Responsibilities:

●Involved in Analysis design and development of Cache and Broadcaster

●Involved in Unit Testing and Integration testing.

Environment: C#.Net, Remoting, MS Application blocks, SQL server 2000, Windows XP,

Client: Falco Electronics, Xiamen China July 2003 – Nov 2003

System Analyst

Project:

FALCO ERP SYSTEM

Environment: C#.Net, ASP.net, SQL server 2000, Windows XP,

Client: KOCHI REFINERIES Ltd, Ernakulam, India April 2003 – June 2003

Sr Software Engineer

Project:

●Employee Self Service Portal system

Role:

●Involved in Requirement Analysis design of Employee Self Service Portal system.

Environment: C#.Net, ASP.Net, SQL server 2000, Windows XP, Seagate Crystal Reports

Client: Paradigm Technology Solutions, FL Aug 2002 – Mar 2003

Sr Software Engineer

Environment: C#.Net, ASP.Net, SQL server 2000, Windows XP, Seagate Crystal Reports

Geneva Finepunch Enclosures Ltd., Bangalore, India April 1999 – July 2002

Sr Software Engineer

Environment: ASP, SQL sever 7, Windows XP, Seagate Crystal Reports

Contact this candidate