Resume

Sign in

Sql Server Windows

Location:
Suwanee, Georgia, 30024, United States
Posted:
October 26, 2016

Contact this candidate

Rajeesh Kuthuparakkal

acw86p@r.postjobfree.com

+* 404-***-****

Alpharetta, GA

EXPERIENCE SUMMARY

Proven ability to collaborate with business team to help in identifying, analyzing, inconsistencies and proposing solutions/fixes for business problems.

Extensive experience in leading small teams and as individual contributor in solution architecture, design, development and deployment of Business Intelligence solutions utilizing agile methodologies across the entire Microsoft BI technology stack.

10+ years of experience in constructing, automating and maintaining data warehousing solutions with world class ETL framework (using SSIS, SQL and C#), OLAP cubes (SSAS), dimensions and maintenance procedures.

Works in technical leadership role, works independently, serves as technical mentor and provides guidance to other technical resources in development of complex solutions across entire Microsoft BI stack.

Designs and administers solution test scripts, leads code reviews and approves MTP request for less experienced developers.

Ability to prioritize and multitask the deliverables within time constraints.

Maintains Operational and Developer documentation for solutions.

Designs, builds and shares complex code components with WW developer code sharing site. Recipient of five star rating on submissions and postings.

SKILLS

Solution architecture, design, implementation and leadership of small teams utilizing agile methodologies in the Microsoft Business Intelligence technology stack.

Microsoft SQL Server Analysis Services (2005, 2008 and 2014)

oAnalysis Services Cube design and development.

oAutomation of AS cube updates and dimensional maintenance.

oAbility to create solutions that extend SSAS beyond baseline functionality such as cube processing and drill-through capabilities.

oSecurity design and implementation.

oInformation architecture and diagraming representing Multidimensional data objects with Visio ADAPT stencils.

oStrong MDX skills to support complex BI requirements.

Microsoft SQL Server Integration Services (2005, 2008 and 2014)

oDesigner and developer of complex data warehousing and integration solutions with self-configuring packages.

oDeveloper of components that extend SSIS beyond base functionality such as dynamic file handling, dynamic loading of variable file formats, customized SharePoint data retrieval and publishing, logging and messaging framework, customized SSIS file deployment utility.

oDesigner and developer of SQL Server Agent Job streams automating data acquisition and storage, data transformation and modeling, and information publication.

Microsoft SQL Server 2005, 2008 and 2014

oAdvanced SQL Server skills for data transformation, modeling and optimization for big data problems on micro BI platform.

oAbility to create performance tuned assemblies to extend SQL Server. E.g.; Component to obtain Disk Space of all drives.

oAbility to create automated database maintenance solutions.

Source Control Management

oStrong Team Foundation Server (TFS) and Visual SourceSafe (VSS) skills.

Microsoft SQL Server Reporting Services (2005 and 2008)

oDeveloper of custom components for SSRS complex reports.

oGood overall knowledge and troubleshooting skills for SSRS reports.

Microsoft .NET Technologies

oWorld class developer of C#.NET object oriented libraries and tools that extend BI tools beyond base functionality.

oAdvanced programming skills using ADO.NET, SharePoint Web Services, Windows Management Instructions, etc.

Web Technologies

o ASP.NET, ASP, HTML

Programming Languages

oC#.NET, VB.NET, VB, C, C++, JavaScript, VBScript

Microsoft Performance Point Server 2007

oAbility to design and implement PPS models with complex dimensionality, metrics and business rules.

oAbility to automate load and processing of models and dimensions.

WORK EXPERIENCE SUMMARY

Employer: Hewlett Packard Enterprise (Nov-2006 to current)

Employment Type: Regular, Full Time

Location: Alpharetta, GA, USA (since 2014 June)

Bangalore/India (2006 Nov – 2014 May)

EDUCATIONAL EXPERIENCE

Bachelor of Technology from Kannur University, Kerala, India

PROFESSIONAL ACHIEVEMENTS AND AWARDS

Top rated performer (SE) for last five consecutive years (2011 - 2016)

Have been on a state side (Alpharetta, GA, USA) since 2014 June.

Traveled to United States numerous times for extended stays for state side project work.

Recipient of many Hewlett Packard rewards and recognitions for excellence in leadership, meaningful innovation, significant contributions and achievements.

PROJECT EXPERIENCE SUMMARY

ES ABS Business Analytics & Performance Management and Best Shore Operations– As a Service Information Developer III Rajeesh is responsible for leading, designing and developing many business intelligence solutions that align with business strategy, organization initiatives and objectives to delivery accurate and actionable information to improve financial and operational execution, labor optimization and utilization, and customer satisfaction. Rajeesh also fulfills analytics information request from senior management and executives.

Rajeesh’s roles have included designer, developer and team leader on many projects and few are described below.

Company: Hewlett Packard Enterprise

Stake Holder: ES ABS Business Operations Aug 2010-Till Date

Project: Analytics Framework

Role: Business Intelligence Lead

Location: Alpharetta, GA (since June 2014)

Bangalore/India (Aug 2010 - May 2014)

Design and implement an Analytics Framework to cater each and every aspect of BI Solutions. The framework consists of different components like ETL Framework, ETL Deployment Tools, SSAS Custom SQL Server Drill Through Assembly, SSAS Cube Processing with XMLA, Information Delivery/Publication System, SQL Server Assembly for Disk space Reports, AD/SharePoint Security Group Management Tool, Windows File Share Migrator Tool etc. I was/am responsible for architecting, designing, implementing these components. Most of these components/tools are not even exist in Microsoft space or outside world. They are unique.

Component/Responsibilities:

ETL Framework: Architect, Design and implement SSIS Package Template with Transaction, Parallel Processing, Logging (Database and File System) and Messaging capabilities. These templates also have the self-configuring “settings” for easy MTP and reduce latency when migrating to new server/location.

Designed many re-usable SSIS Package Templates with all standard functionalities (messaging, logging, transaction etc) that address various scenarios like download feed from SharePoint/website, load data from Text/CSV/XML/Excel/Access/SharePoint List, Exchange Mailboxes etc. Also for the scenarios like unzipping compressed files, decrypting files etc.

Automated Data Read From Excel: Designed re-usable Excel data load package template. The package can search excel files using pattern, identify the Worksheet containing data with data location (row/column). The package identifies the driver (JET, ACE, Macro, Binary) required to read data from Excel file based on the file type (.xls, .xlsx, .xlsm, .xlsb). The package can also report out missing/new fields compared to expected format with an option to load data even if the columns are missing. The package also accepts threshold levels to proceed with missing column data load (i.e. load only 90% or more columns are not missing).

ETL Deployment Tools: Architect, Design and implement SSIS File System Deployment Utility. This helps in deploying packages and configurations to new environment without manually editing them. This also supports package deployment in bulk with modifying all configuration values (eg: Destination SQL Server Conn) with one click.

SSAS Custom SQL Drill Through Assembly: Architect, Design and implement custom drill through assembly that sits on SSAS Server and fetch raw data corresponding to cube numbers from any SQL Server database. This minimize Cube size since we do not want to keep each and everything in Cube to help with drill through.

SSAS Cube Processing with XMLA: This is a generic SSIS package template that can process dimensions and cubes in an AS Catalog. The dimensions and cubes/measure groups are fetched at real time and dynamically generates XMLA for each dimensions and measure groups. Rajeesh has architected, designed and implemented this template.

Information Delivery/Publication System: This is an ASP.NET Webservice that takes files from File System and published to SharePoint Document Library. Also helps to modify the SharePoint fields (eg: Report Title, Report Type etc) dynamically. Rajeesh has architected, designed and implemented this solution.

SQL Server CLR Assembly for Disk space Reports: Rajeesh has architected, designed and implemented this component and the component is a CLR Assembly that can create Disk Space Analytics for each and every server under consideration. The Assembly is able to access all servers with SQL Services running under the Service Account where the assembly is installed.

AD/SharePoint Security Group Management Tool: This tool helps in modifying Active Directory Groups and SharePoint Security Groups. It can search group in entire active directory with little or less information, show the details of the group and add/delete members. Rajeesh has architected, designed and implemented this tool.

Windows File Share Migrator Tool: Rajeesh has architected, designed and implemented this tool. The tool helps you copy a File Share with permissions and security to another location (even to another machine) with the option to copy sub-folders and/or files.

Environment:

Visual Studio 2008/2010/2013, SQL Server 2008/2014, C# 2.0 – 4.5, SSAS, SSIS, ASP.NET, HTML, Windows Server 2008/2012, XML

Company: Hewlett Packard Enterprise

Stake Holder: ES ABS Business Operations Aug 2010-Till Date

Project: Requisitions Model

Role: Business Intelligence Lead

Location: Alpharetta, GA (since June 2014)

Bangalore/India (Aug 2010 - May 2014)

The Requisitions Cube integrates data from Taleo, HR, and Labor Location Strategy to provide a flexible reporting solution that supports the ABS Strategic Hiring Process and Requisitions reporting. The cube has the capability to fetch raw data from SQL Server without using any additional interface/components other than MS Excel.

This helped increased hiring into strategic locations from 55% to 78% in 2014

Responsibilities:

Collaborate with business to identify the requirements.

Analyze requirements.

Create high level and detailed level design documents.

Build prototype and obtain sign-off.

Design automated DW solution for Taleo data acquisition and transformation.

Design and construct views/tables/procedures to load facts and dimensions.

Design and implement SSAS Cubes and Dimensions.

Design and implement measures.

Enable drill through to communicate with the custom drill through assembly.

Design SSIS packages for dimension update, fact load and cube processing.

Create SQL Server Agent Jobs for production run.

Testing, validation and MTP.

Create operations and support guides.

Conduct production run and communicate results to business.

Stabilize operations.

Handover repeatable process to low cost centers for regular operations

Environment:

Visual Studio 2008/2010/2013, SQL Server 2008/2014, C# 2.0 – 4.5, SSIS, XML, SSAS, Windows Server 2008/2012

Company: Hewlett Packard Enterprise

Stake Holder: ES ABS Business Operations Aug 2010-Till Date

Project: Workforce Analytics Model

Role: Business Intelligence Lead

Location: Alpharetta, GA (since June 2014)

Bangalore/India (Aug 2010 - May 2014)

The Workforce Analytics Model pulls data from multiple HPE gold source systems into a data warehouse and produces an analytics model that supports all reporting requirements through multiple cubes and dimensional hierarchies.

Responsibilities:

Collaborate with business to identify the requirements.

Analyze requirements.

Create high level and detailed level design documents.

Build prototype and obtain sign-off.

Design automated DW solutions for HR Data, GRE Site Information, Compass Time Tracking Data, MRU data, and Polaris Data acquisition and their transformation(s).

Design and construct views/tables/procedures to load facts and dimensions.

Design and implement SSAS Cubes and Dimensions.

Design and implement complex MDX calculated measures like “rolling 12 month headcount/attrition” with non-standard time (calendar) etc.

Enable drill through to communicate with the custom drill through assembly.

Design SSIS packages for dimension update, fact load and cube processing.

Create SQL Server Agent Jobs for production run.

Testing, validation and MTP.

Create operations and support guides.

Conduct production run and communicate results to business.

Stabilize operations.

Handover repeatable process to low cost centers for regular operations.

Environment:

Visual Studio 2008/2010/2013, SQL Server 2008/2014, C# 2.0 – 4.5, SSIS, XML, SSAS, Windows Server 2008/2012

Company: Hewlett Packard Enterprise

Stake Holder: ES ABS Business Operations Aug 2010-Till Date

Project: Robotic Email Notification System

Role: Business Intelligence Lead

Location: Alpharetta, GA (since June 2014)

Bangalore/India (Aug 2010 - May 2014)

To emphasize compliance in different areas like Time Tracking, Bench Head Count etc. These systems created high impacts to business by improving Time Tracking from 50% to 95%, reduction in Bench Head count by 50% etc. The solution is implemented as an SSIS Package with C#, XML and HTML coding.

Responsibilities:

Collaborate with business to identify the requirements.

Analyze requirements.

Create high level and detailed level design documents.

Build prototype and obtain sign-off.

Implement the solution.

Develop operational reports and measure current compliance.

Design automated DW solution for data acquisition and transformation from various sources.

Design SSIS package to send emails using SMTP with parallel processing.

Create SQL Server Agent Jobs for production run.

Testing, validation and MTP.

Create operations and support guide.

Conduct production run and communicate results to business.

Measure the impact (progress) of the solution and communicate to business.

Stabilize operations.

Handover repeatable process to less experienced resources.

Environment:

Visual Studio 2008/2010/2013, SQL Server 2008/2014, C# 2.0 – 4.5, SSIS, XML, HTML, Windows Server 2008/2012

Technology Services - As a Business Planning Analyst Rajeesh was responsible for technical leadership and implementation of numerous business intelligence projects/solutions, few projects are described below.

Company: Hewlett Packard Enterprise

Stake Holder: TS Delivery Operations May 2008-Aug 2010

Project: Factory Scorecard

Role: Business Intelligence Lead Developer

Location: Bangalore/India

Worldwide solution for root cause analysis and corrective action planning for missed metrics for both off-site, logistics and on-site engineers. The solution is with Performance Point as backend and SSRS as frontend.

Responsibilities:

Analyze the requirements.

Create high level and detailed level design documents.

Design SSIS packages to harvest data into DW

Design and construct views/tables/procedures to load facts and dimensions.

Design SSIS packages for dimension update, fact load.

Design SSIS packages to call Performance Point routines for validate, data staging and model processing.

Create SQL Server Agent Jobs for production run.

Testing and validation.

Create operations and support guides.

Environment:

Visual Studio 2008, SQL Server 2003, C# 2.0 – 3.0, SSIS, Windows Server 2003, Performance Point Server 2007

Company: Hewlett Packard Enterprise

Stake Holder: TS Delivery Operations May 2008-Aug 2010

Project: Incident Volume Analytics

Role: Business Intelligence Developer

Location: Bangalore/India

The solution identifies the unusual patterns in the volume of incident (support cases) and tie out the pattern to a valid event like new product introduction, patches and fix of software components and their impact.

Responsibilities:

Understand the requirements.

Create high level and detailed level design documents.

Design SSIS packages to feed data into DW

Design and construct views/tables/procedures to load facts and dimensions.

Design SSIS packages for dimension update, fact load.

Develop Excel Reports for Trending and Volume Analysis.

Create SQL Server Agent Jobs for production run.

Testing and validation.

Create operations and support guides.

Environment:

Visual Studio 2008, SQL Server 2003, C# 2.0 – 3.0, SSIS, SSAS, Windows Server 2003

Stake Holder: TS Consumer Support Operations Nov 2006-Aug 2010

Project: eRevGen

Role: Business Intelligence Developer

Location: Bangalore/India

Up-selling opportunity monitoring mechanism reduces opportunity miss. e-Support (6J) was able to hit their revenue generation target for the first time after rolling out the solution.

Responsibilities:

Understand the requirements.

Create high level and detailed level design documents.

Design and code ASP.NET web application.

Design and construct database views/tables/procedures.

Design backend process to poll sales pitches and store into database.

Design logic to prioritize and evenly distribute sales pitch queue with available callback SPOC.

Design web user interface for Callback SPOCs and admins

Testing and validation.

Create operations and support guides.

Environment:

Visual Studio 2008, SQL Server 2003, C# 2.0, ASP.NET, Windows Server 2003, HTML, JavaScript, VBScript

REFERENCES

Available upon request



Contact this candidate