B. Rathinakumar

Manager

Total Experience

**+ Years in .Net, BI, Cloud

Qualification

MCA

Work history

InfoCepts Technologies

(July 2019 - Present)

L&T Infotech

(Nov 2016 - Mar 2019)

Cognizant Technology Solutions

(Sep 2012 - Nov 2016)

Nokia Siemens Networks

(May 2008 - Sep 2012)

Shakthi Systems

(May 2002 - May 2008)

Kelnet Communications

(Apr 2000 - Jul 2000)

Work Summary

End to End Project Design, Development and Implementation

Admin Experience in tools like QlikView, Tableau and Spotfire

Awards & Recognitions

Innovation Award from

Nokia Siemens Networks

Best Performer Award from Amgen

Break through Award from Cognizant.

Innovation awards from Nokia Siemens Networks Pvt. Ltd.,

Summary and Accomplishments

Over all 21 + years of experience in IT industry with .Net Coding, BI Analytics and Networking.

15+ Years of delivering analytical and problem-solving skills and ability to follow through with projects from inception to completion.

Proven ability to successfully work for multiple requirements, design, and development approaches and methodologies (agile, iterative, waterfall, etc.)

Strong experience in Full Life-cycle BI and Data warehousing projects inclusive of requirements analysis, proof-of-concepts, design, development, testing and implementation

Performed POCs for complex MicroStrategy solutions and have justified the pros and Cons for the same

Worked as a Developer as well as an Administrator for MicroStrategy

Extensive experience in designing, architecting and implementing DW and BI solutions, Data warehouse design, database data modelling, Dashboard Development and reporting. Expertise in Schema Development and Dashboard and Mobile app

Design and Development in MicroStrategy

Good working knowledge of MicroStrategy 9.x to 10.4 (MicroStrategy Desktop, Architect, Project Design, Dashboards, Visual Insights, Mobile Apps, Object Manager, Integrity maintaining infrastructure for MicroStrategy and databases both in Windows and Linux operating systems

Have experiences on performing MicroStrategy upgrades.

Experience in Windows Server Roles and features configuration like IIS, Terminal Services, DNS, etc.

Good Experience in AWS Cloud.

Worked in Greenplum, Teradata, Sybase IQ, MySQL, MS-SQL and Oracle DB.

Experience in UNIX shell scripting & Windows batch file scripting and .NET programming.

Technical Skills

Business Intelligence Tools

MicroStrategy, QlikView, Tableau, Spotfire

Operating Systems

Windows, Linux

ETL Tool

Informatica

Databases

MS-SQL, Oracle, Green Plum, Sybase IQ, Teradata.

Web Servers

IIS, Apache, Glass Fish

CRM

BMC Remedy, Service Now

Programming Languages

VB.NET, ASP.NET, C #, Perl, Shell Scripts

Citi Group

BCBS 239 Prod Support

Jan 2017 – Mar 2019

Role

Solution Architect

Monitoring Risk Data availability from various sources and proactively act on Cube refresh for daily, weekly, monthly and quarterly MicroStrategy Reports.

Implemented automation of Cube refresh using the AUTO WATCH PORTAL (Citi Proprietary process orchestration automation tool) with the help of Shell scripts based on data arrival.

Meeting Risk Report delivery SLA.

Report DATA Analysis and issue FIX.

SQL query preparation for data sanity check.

Weekly status report submission.

Fine tuning and performance improvements on Reports rendering time.

Providing solutions for data load process which are arriving at different timings

Report bug fix when incompatible source data received.

Developed source data validation (Null check, Unique check, FK Constraints check, Business rule check) scripts to capture issues at the source level before processing incremental cube refresh.

Project Details

Amgen Bio Pharmaceuticals

QlikView Platform Support

Jul 2015 – Oct 2016

Role

Manager - Projects

Responsibilities

New QlikView installation and configuration of Qlik Server, Distribution Server and Web Server.

Implemented data Security at Country level using LOOP and REDUCE TASK.

Automated data load using batch file and windows task scheduler.

Reduced License cost by implementing Dynamic Licensing and deleting unused licenses.

Various Applications hosting at the centralized Qlik server for France, Spain and Greek.

Provided support during data issues.

Enabled LDAP authentication.

Configured Qlik Governance dashboard with Qlik Server Log files.

Generated weekly performance report and utilization report from Qlik Governance dashboard.

Project Details

Amgen Bio Pharmaceuticals

Tableau Platform Support

Aug 2016 –Oct 2016

Role

Manager - Projects

Responsibilities

Installed and configured Tableau new server setup with clustering enabled.

Configured users and user groups.

Hosted applications as per Application onboarding document.

Enabled LDAP Authentication

Project Details

Amgen Bio Pharmaceuticals

Spotfire Upgrade

Apr 2015 –Jun 2015

Responsibilities

Upgraded Spotfire ver 6.5 to 7.5. with new servers configured in AWS Cloud.

Configured the Plugins as per documentation.

Implemented LDAP authentication.

Amgen Bio Pharmaceuticals

Med-Info - MicroStrategy

Jun 2014 – Mar 2015

Role

Senior Developer

Analysed report specifications and prepared use case and design documents

Defined and created MicroStrategy objects including attributes, filters, metrics and reports

Designed and created MicroStrategy reports according to design specifications Developed dashboards with multiple panels and graphs for iPad usage.

Extensively used selectors and widgets to give end users a flexible way to choose the criteria for the report and view information in different perspectives.

Used slider for Month Range selection.

Configured Mobile web for iPads.

Rolled out Enterprise deployment with MDM using Tangoe Provider.

MicroStrategy Cloud I-server integration with on premises Data base Server for data pulling.

Project Details

Bayer Pharmaceuticals

MicroStrategy PROD Support

Jan 2013 – May 2014

Role

MicroStrategy Administrator

Responsibilities

Installed and configured new MicroStrategy servers for DEV, UAT and PROD in Linux OS with I-Server Clustering and Web Servers in Load Balancer.

Automated Oracle Meta data weekly backup using batch file and windows task scheduler.

Configured automated cube refresh using event trigger and shell scripts using Bteq Command line utility of Teradata.

Enabled windows authentication for SSO. Project migration from DEV – UAT – PROD User access provisioning.

Project Details

Bayer Pharmaceuticals

Field Force Reporting - MSTR

Nov 2012 – Dec 2012

Role

Senior Developer

Responsibilities

Analysed report specifications and prepared use case and design documents

Defined and created MicroStrategy objects including attributes, filters, metrics, hierarchies, templates, prompts and reports

Designed and created MicroStrategy reports according to design specifications Extensively worked on Report Services Documents

Developed Graphical reports with multiple selectors.

Used security filters to apply security at Country, Region and Territory level.

Project Details

Nokia Siemens Networks

MicroStrategy Prod Support

Sep 2009 –Sep 2012

Role

MicroStrategy Administrator

Responsibilities

Monitored Cube refresh, data issues and managed user access provisioning.

Enhancements in KPI Reports and fine tuning the performance of the report as the data grow.

Automated data load using command manager scripts.

Weekly server utilization and user adoption report were generated from Enterprise Manager.

Project Details

Nokia Siemens Networks

MicroStrategy Upgrade

Oct 2011 –Nov 2011

Role

MicroStrategy Administrator

Responsibilities

Upgraded MSTR ver 9.0.0 to 9.0.2 for Mobile enhancements

Configured I-Server clustering

Metadata upgrade.

Project Details

Nokia Siemens Networks

GNOC Portal – ASP.NET

Jul 2008 –Sep 2012

Role

OSS/NMS Tools Developer

Responsibilities

Developed and hosted Global Network Operation Centre Portal to maintain centralized repository for report upload by various circle engineers.

Managers and Directors are given access to download highly confidential reports with high Security.

Security audit has been conducted and approved by KPMG for the portal after implementing the required security measures.

Integrated with third party SSO.

Maintained the portal with user access provisioning and fixing bugs.

Project Details

Nokia Siemens Networks

Planned Activity Notifier – C#.NET

Oct 2008 –Sep 2012

Role

OSS/ NMS Tools Developer

Responsibilities

Developed a windows system tray application to notify the Alarm Monitoring team about the planned activity going to be carried out at their Network Elements, so that they won’t create ticket for the Failure signals received at their OSS system.

This has prevented lot of false ticket creation.

The source data has been taken from the GNOC portal.

Updated and enhanced a lot as per Alarm Engineers requirement.

Maintained and supported the Application including Server.

Project Details

Nokia Siemens Networks

MTTR Report - MicroStrategy

Sep 2009 –Dec 2009

Role

MicroStrategy Administrator

Responsibilities

Analysed report specifications and prepared use case and design documents

Defined and created MicroStrategy objects including attributes, filters, metrics, hierarchies, templates, prompts and reports

Designed and created MicroStrategy reports according to design specifications Extensively worked on Report Services Documents Developed Graphical reports with multiple selectors.

Pulled data from BMC Remedy Tool Oracle DB and created Ticket Analysis reports and KPI dashboards with metrics like Mean Time To Resolve MTTR, Mean Time To Acknowledge MTTA, Time hold by each time in min, etc.,

Project Details

Nokia Siemens Networks

HCPT CR Report -

MicroStrategy

Jan 2010 –Mar 2010

Role

OSS/ NMS Tools Developer

Responsibilities

Analyzed report specifications and prepared use case and design documents

Defined and created MicroStrategy objects including attributes, filters, metrics, hierarchies, templates, prompts and reports

Designed and created MicroStrategy reports according to design specifications

Extensively worked on Report Services Documents

Pulled data from BMC Remedy Tool Oracle DB and created Change Ticket Analysis reports with KPI like CR mean time, Open CR, Pending CR, WIP CR.

Project Details

Shakthi Systems

Suitall -Net Accounting

Apr 2007 –Dec 2007

Role

Project Leader

Responsibilities

Enhancements and production support for the Financial Accounting application.

Implemented more security in terms of password policy and encryption.

Bug Fixing on session issues and implemented sliding expiration of session.

Developed age wise analysis report for Payments and Receivables.

Solved Balance sheet tally issues.

Added invoices and delivery challans with static content so as to avoid pre-printed Stationaries.

Implemented multiple company accounts management.

Project Details

Shakthi Systems

Suitall -Net Accounting

Apr 2005 –Mar 2007

Role

Senior Developer

Responsibilities

Code regenerated and developed the Net Accounting Windows Application from VB.NET to ASP.NET Web Application.

All the modules are tested and validated unit by unit.

Used Crystal Decision reports instead of Seagate Crystal Reports.

Used forms authentication for secure login.

Supported and maintained the application by doing enhancements and bug fix.

Project Details

Shakthi Systems

Net Accounting

Apr 2004 –Mar 2005

Role

Programmer

Responsibilities

Developed Financial Accounting application using VB.NET and MS Access.

Created Party Ledger, General Ledger, Sales Invoice, Purchase and Balance Sheet reports using Crystal Reports plugin that comes with Visual Studio.

Supported and maintained the application by doing enhancements and bug fix.

Project Details

Shakthi Systems

Payroll Application

Apr 2003 –Mar 2004

Role

Programmer

Responsibilities

Developed Payroll application using VB.NET and MS Access.

Generated reports like Forms 3A, ESI & PF Forms.

Provided Loan entry module and monthly recovery on salary.

Provided Leave update modules.

Supported and maintained the application by doing enhancements and bug fix.

Project Details

Shakthi Systems

Financial Accounting

Jun 2002 –Mar 2003

Role

Programmer

Responsibilities

Developed Financial Accounting application using VB and MS Access.

Used Seagate Crystal reports for report generation.

Supported and maintained the application by doing enhancements and bug fix.

Contact this candidate