Summary
Overview
Work History
Education
Skills
Certification
Personal Information
Timeline
Generic

Kalyan Ganesan

Irving

Summary

A seasoned Business Intelligence and Data Analysis expert, I excel in transforming complex data into actionable insights, as demonstrated at ARCH MI. With a strong foundation in Oracle, SQL, and Crystal Reports, my analytical prowess and strategic thinking have significantly enhanced data governance and reporting efficiency. My collaborative approach and problem-solving skills have consistently driven project success, achieving over 30% improvement in data quality and operational efficiency.

Overview

25
25
years of professional experience
1
1
Certification

Work History

Tata Consultancy Service
11.2018 - 02.2023
  • Worked for the following clients of TCS and performed the below tasks
  • Most recent client mentioned n the top of the below list.

Business Intelligence

ARCH MI
04.2023 - 01.2023
  • Implementations for the following clients:

Senior Data Analyst

Employer Tek Systems, American Airlines, SAP
Ft Worth
01.2018 - 04.2018
  • Sharp Legacy System Data Validation, Analysis and Data Conversion
  • Performed the Auditing and Data validation for Pre Load and Post Load files from HRIS and Back Office Associates files from derived from the Legacy System, data validation includes validating for the Counts, Data Type, Sorting, Filters, Conditional Formatting and what if Analysis
  • Create tables for Preload(HRIS) and Post load(BOA) in the MS Access Database, the queries to do the comparisons for the Downloaded file from the DSP DEV site for Delta File Preload and Post load file
  • Worked in the SAP Sharp System to map the Tables and columns that are specified in the mapping document to validate and verify the logic is correct for the data that is returned from the Preload and Post Load files
  • Used VLOOKUP , Match and Count if Function to do the Data Analysis for the Excel File that was derived using the Comparison Query created in MS Access
  • Created Basic Modules, Class Modules, Forms ,Procedures, Functions using VBA for the Basic User, Legacy, Employee Hire, Address, Email, Dependents Modules in MS Access
  • Successfully interpreted data to draw conclusions for managerial action and strategy
  • Used statistical techniques for hypothesis testing to validate data and interpretations
  • Presented findings and data to team to improve strategies and operations
  • Creates and implements the Data Governance framework that meets data objectives for the organization
  • Establishes and executes the Data Quality Governance Framework, which includes endtoend process and data quality framework for assessing decisions that ensure the suitability of data for its intended purpose
  • Executes enterprise data governance strategies in line with the organization`s strategic plan and objectives
  • Establishes the Data Quality Governance Council, its vision and direction
  • Oversees the creation of data governance policies and standards
  • Defines and implements Data Governance Management tools.

JP Morgan Chase Lewisville
04.2017 - 12.2017
  • Switchboard Upgrade and QC Validation Process
  • Senior MS Access, VBA, Oracle PL SQL Developer
  • Designed and developed Stored Procedures, Packages in Oracle 11g PL SQL for QC Validation
  • Columns for the cursor for QC Validation were taken from mapping the SAS Program files along with their Oracle Columns from the database
  • Upgraded the existing Switchboard Application to implement the Archiving feature in MS Access 2013 using VBA
  • Switchboard Application consists of Linked Tables in BUSDEV,BUSUAT and BUSPROD databases that connects to oracle tables, established the connection suing DAO, created queries in MS Access to extract the data from production Database from Oracle and populate into the Tables in MS Access
  • Created Forms, Sub Forms in MS Access to implement the Archiving feature in the Switchboard, the forms were using the Dyna set Record sets with inconsistent Updates, used the queries created in MS Access to populate the forms and update the datasets dynamically
  • Provided Production support and resolved Issues with the Customers on the Switchboard Application and its related databases
  • Created a new module in the existing MS Access app to search by master form by multiple combo boxes and populated the sub forms with their detail records using Filter properties, Link Master fields ,Link Child fields options and also updating the record sets dynamically, this module supports large volumes of Loan Numbers and their associated Notes, Status Logs etc.
  • Designed and developed a package in PL SQL to extract over 30000 rows of Loans in MS Excel file to update the existing Loan Numbers in Main table and Loan VLS table
  • Performed GAP analysis of business rules, business and system process flows, user administration, and requirements
  • Data Mining and Modeling: Collected, cleansed and provided modeling and analyses of structured and unstructured data used for major business initiatives
  • Outcomes
  • Data Quality:- Automated data reconciliation checks from Source to Reporting systems, data scrubbing and enhancement using Dun Brad Street, Conformed Dimensions leveraged by data marts across the organization for data consistency in reporting, regression testing, coaching business users to perform UAT accurately through training and writing Test Cases and ensuring business users and IT sign off on the BRD and Technical Design document for new project releases
  • MS Access 2013,DAO, ADO, Oracle 11g SQL,PL SQL, SAS

Senior Crystal Reports, Oracle Programmer

Atmos Energy Dallas
01.2017 - 03.2017
  • Made changes to the formulas and groups to generate the correct data for the
  • Align Reports namely Contract Storage, Pool Imbalance Charges, Upstream Downstream 5-Day ,Pgas to Align Monthly Volume and Energy Difference and FERC549D Reports in Crystal Enterprise
  • Made changes to the Align Reports Business Objects reports namely Pool Imbalance charges, 3rd Party Storage Nominations using Webi to generate the data per the user requirements
  • Modified the Stored Procedures in Oracle using PL SQL to fix the logic, the stored procedures were used using ref cursors for the Reports
  • Modified the Stored Procedures in SQL Server using TSQL to fix the logic, the stored
  • Procedures were used using ref cursors for the Reports
  • Crystal Reports 2016 Business Objects Webi 4.1,SQL Server 2013,Oracle 12,Functional Analysis

SQL Server Crystal Reports Programmer

Universal American Mortgage Company
Miami
06.2016 - 11.2016
  • Modified Existing Reports using Crystal Reports 2013
  • Modified existing Stored Procedures using SQL Server 2013
  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS)
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture
  • (Table, chart and matrix report)
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes
  • Crystal Reports 2013, SQL Server 2013

Business Objects, Oracle Developer

Hyatt Vacation Ownership
Tampa
02.2016 - 05.2016
  • Converted the existing Web Reports in Business Objects 3.1 to 4.1
  • Scheduled the Web and Deski Reports in version 4.1
  • Converted the PL SQL Scripts to PL SQL Packages ,Procedures and Functions
  • Modified the existing Universes to add Measures, Dimensions and Details, Formulas
  • Created new Reports in Webi 4.1 for the 10 Stations in Florida reflecting the Monthly Yearly and Sales forecasts, Financial Forecasting
  • Using SQL Performed Data Analysis
  • Business Objects 3.1,4.1 Deski and Webi, Oracle 12

Sr Oracle Reports, Financial Consultant

ETCC
Richardson
09.2015 - 01.2016
  • HCTRA(Harris County Toll Road Authority) Reports Development and defects resolution
  • Designed and developed Bank Deposits, Inventory, Reconciliation, Shifts, Shortages, Treasure, Bankruptcy, Collections, Customer Service, Finance, Fulfillment, Vehicles Reports ,Payment Plan Reports using Crystal Reports 2013, these are multiple section Reports that implements Master Detail functionality for each and Account ID, the detail sections include Vehicle and owner information, Installment details and Actual Payment Excusal sections, Account History, Accounts Payments, Case History, Fulfillment Performance, Manned Booth transactions ,Transponder Types, Warehouse and Transponder Agencies, listings etc.
  • Used suppression formulas to show the detail section based on criteria’s, used sub reports for Report Criteria(Parameters entered in UI), No Data Found section(when there is no data), Report Title and User , Run time information, all of these are extracted from base tables from the HCTRA Database
  • Designed and developed the Packages for all the reports and used Ref Cursors to have the result sets called from the Crystal Reports, the ODBC connections included databases for HCTRA Inventory, Customer Service Reports and data marts for IOP,RRS reports
  • Provided Oracle-based design and testing services for the HCTRA Oracle applications
  • Devised data integration strategies inclusive of mapping, extraction and loading techniques
  • Environment: Oracle PL, g), PL SQL Developer.HTML, Java, .Net, SQL Windows XP, Oracle 11i, Clear Case Crystal Reports 2013, Oracle Data Integrator

Senior VBA, Oracle .Net Developer

JP Morgan Chase
Lewisville
03.2015 - 08.2015
  • Upgraded the existing MS Access Databases consisting of MS Access Forms, Macros and tables to MS Access version 2013
  • Designed ,developed and maintained a tool that simulates any ETL tool, this is for internal use to export Excel files(all formats CSV,XLS,XLSX) to Oracle, SQL Server ,database using OLEDB, ORACLEDB Connections, SQL Bulk copy, Oracle Bulk copy objects in VB.net and C#
  • Modified existing accdb to create a export utility that exports to Excel files based on dates
  • Created PL SQL Scripts to create tables, triggers for WMF Database using Oracle 11g
  • Modified APR MS Access Database to add new features for updating back end tables in both MS Access and Oracle Database
  • Involved in day to day table maintenance and database functions that emails the users after everyday transactions
  • Created a SSIS package to export data from Excel files to Oracle Database
  • Used Dimensional data modeling methodologies to come up with a model for data mart
  • Created a Report in Crystal Reports 2008 to display in Charts the Mortgage data available in MS Excel
  • Architected and Implemented ETL routines using ODI
  • Installed and configured (Master and Work Repositories, ODI agents)
  • Created Excel based application to move/format data between sheets based on selection criteria using the Excel Object Model, VBA, Events, Right Click Events, Combo boxes, and Double click events
  • Created custom SQL for data retrieving and sending
  • Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
  • Created charts and pivot tables in Excel
  • Normalized the tables, generated the SQL Scripts to Load the tables
  • Environment: Oracle PL SQL(11g),SQL Developer, SQL Server 2008,SSRS,Power Pivot ,TOAD, VB.net, C# .net, MS Access 2010/13,MS Excel 2010,VBA Visual Studio 2012,Crystal Reports 2008,SSIS

Senior SQL Server/MS Access VBA Consultant

Blue Cross Blue Shield
Richardson
05.2014 - 09.2014
  • FRED and Nerv Project for Health Care Services Consultants
  • FRED is a MS Access 2013 based AD Hoc Reporting Project that is used by the users for the Business functions of Blue Cross Blue Shield for all Divisions namely OK,IL,TX,NM,MT
  • All reports were created in MS Access
  • Techniques such as SQL, Macros and VBA methodology were used
  • MS Access 2013 was used
  • Created a Stored procedure in SQL Server for Average Turn-around Time by Issue Type Reports and Average Turn-around Time by Division in the Management Reports Section
  • We are currently in the process of migrating over 100 apps to Access 2013
  • Created a Sub Procedure using VBA that uses the stored procedures for the Average Turn-around Time by Issue Type Reports and Average Turn-around Time by Division and populates using Query and also using MS Excel objects in DAO and populates into Excel using the Result sets
  • Developed SQL Queries in Teradata for the Ad Hoc Reports for State Farm Georgia Insurance
  • Created a Stored Procedure using SQL Server TSQL for Recertification daily updates which was a manual process that executes the Updates and Inserts into the FRED2_ADHC_ROUTINE_TEST and FRED2_ADHC_ROUTINE_TEST_ARCHIVE Table
  • Designed and developed a Stored Procedure FRED2_GetEmpolyeeDirectoryDetail that returns Record set for Employee Directory table that is refreshed every day
  • Developed test cases and tested several complex MS Access 2003 applications for migration to MS Access 2013
  • Created a Module for the FRED MDB in MS Access using Forms and Sub forms to display the Employee Directory Module, that was searched thru User Id First Name and Last name using VBA(DAO)
  • Designed and developed a Stored Procedure that Spools output to Excel file for the August News Letter Production Metrics Report that groups on Month, Opportunity , Actual, Target and Prod Goal (in percentage), the procedure has complex query that has Unions to wrap the logic of generating Metrics Report
  • Created a function that will split the input string into multiple values that is used in the procedure FREDW_ Attach Recipients_ Test to insert the Recipients Email addresses in the FREDW_ Attach Recipients_ Tbl_ Test based on first and last names
  • Created an SSIS package to export data from Excel files to Teradata Database
  • Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
  • Generated several drill down and drill through reports using SSRS
  • Created charts and pivot tables in Excel
  • Used Dimensional data modeling methodologies to come up with a model for data mart
  • Worked on Data mappings in excel as well to deliver the application level specific rules to the developers
  • Worked with complex Join rules to maintain the integrity between the older versions of the data to the distributed environment
  • Involved in creating the Data Flow Diagrams (DFD) in Visio based on the architecture diagram of the application
  • Worked on Erwin Data modeler tool to keep track of all changes from ETL
  • Automated several manual data processes of collection of data to FRED MS Access databases by the use of VBA MS Access
  • Forms and SQL inserts, updates and queries to make the databases more efficient and protected by data integrity
  • Designed and developed MS Access Reports using queries and Reports for Service Center Reports using Docmd Object
  • Environment: SQL Server 2008,SSRS,Power Pivot, SSIS, VB Script, MS Access 2013(ADO,DAO),Teradata, Excel VBA, TFS, VB.net, C# .net, TSQL

Lead Financial Reporting Consultant

National Cash Register, NCR
Fort Worth
09.2013 - 03.2014
  • NCR Aloha Insight has been designed, developed and maintains the POS System for their clients along with maintenance and upgrade of the Database in SQL Server , Reports using Active Reports, Crystal Reports that are accessed thru the NCR Insight Portal
  • Modified reports in Active Reports in Visual Studio 2005
  • Backed up and Restored Development and Production Databases in SQL Server 2008
  • Installed and configured SQL Server 2008 in Production and Development servers
  • Designed and developed a tool to run thru the Text files(AAE)files extracted from command center and update the date columns into current date using C# and VB.net
  • Checked in and checked out source code using TFS in Visual Studio 2010
  • Created Stored Procedures, Triggers, Views and Functions using SQL Server 2008
  • Created the Reports using SQL Server Reporting Services (2005)
  • Created and Modified Stored procedures using TSQL in SSMS
  • Ran scripts in Command Center to extract the polling files, polling is the process to get the Database up to date in the client environment, FTP the files that include DBF Files, AEE files (extract files), Debout.old, txt files
  • Building/Maintenance/Execution of Excel daily reports focusing on daily profit/loss (use of VBA, Excel Object Model, Access Object Model, Outlook Object Model, ADO and DOM)
  • Created reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries
  • Generated several drill down and drill through reports using SSRS
  • Created charts and pivot tables in Excel
  • Created report snapshots to improve the performance of SSRS
  • Created front end spreadsheet to link data via ADO to Access database for proprietary beverage market data
  • Use of Access/Excel Object Model, VBA and ADO
  • Environment: HTML.VB Net, , VB Script ,Active-X, FLEX, C # , VBA,SQL Server 2008,Windows 7, SQL Server 2008,SSRS, ,SAP Crystal Server 2013

Access/Crystal Reports Developer

Neiman Marcus
Irving
02.2012 - 12.2012
  • Pacman Reporting Maintenance and upgrade
  • Pacman Reporting Maintenance and upgrade project consisted of Installing and configuring the SAP Crystal Reports 2011 Server, Tomcat Server, Oracle Client (32 bit and 64 bit) and Crystal Reports Developer to upgrade and publish the existing Reports developed and published in Crystal Reports XI
  • Upgraded the existing Pacman Reports in Crystal Reports XI into using the new database schema, views and stored procedures for Development, Test and Production servers
  • Modified the Stored Procedures using SQL Developer of Oracle 11gs Database in Development, Test and Production databases to use the new views instead of the tables for the schemas and upgraded them to Oracle 11g
  • Maintained the Pacman Reports in Crystal Reports 10 using command objects and calls to the Stored Procedures returning the data using Ref Cursor
  • The data for these reports were developed using Command objects in Crystal Reports 2011 and Stored Procedures created in Oracle 11g
  • Created 50 folders in Crystal Management Console for all stations and published the respective reports into each folder, this process was done for all environments and all servers for Development, Testing and Production
  • Maintained the Stored Procedures and Packages returning the Ref Cursor for the queries to build the Data sets for the Reports in SQL Developer using Oracle 11g PL/SQL Cursors, Variables
  • Scheduled the Report in Crystal Management Console and exported it in Acrobat format and Excel Formats
  • Created 50 new users in Crystal Management Console for all stations and published the respective reports for each user to use in Portfolio, this process was done for all environments and all servers for Development (pmudevn), testing (pmutstn) and Production (pmuprdn)
  • Enhanced the existing Pacman Reports namely Option 7 Pick Ticket Reports
  • Modified the Command objects Queries of the Reports in Development, Test and Production databases to point to the Tables and Views for new users and schemas Stored Procedures in Development, Test and Production databases to use the new views instead of the tables for the schemas
  • Installed the SAP Crystal Reports Server 2011, Tomcat Server and Oracle client 32 bit and 64 bit in the Wintel Production, Development and Testing servers
  • Designed and developed an Alert Procedure in Oracle 11g that sends out emails from the mailing list (table driven) using SMPT utility
  • The stored procedure and the SQL are updated using the base table and the Alert Procedure reads thru the tables to send out emails
  • Recompiled the existing Pro C programs that were pointing to the Oracle 9i database to point to Oracle 11g database
  • Prepared documentation for the Database design and the Reporting structure and architecture of the Report Server and Report Client software
  • Recreated the command objects for the reports by removing the views and replacing them with the base tables in the new database for 1 month data and 15 months data and tested the queries and data mining them in DEV TEST and PROD databases
  • Worked with the off shore team in Bangalore to create the reports, modify and maintain the reports, built queries from the specifications gathered from the off shore team and also packaged the work to them for building reports and modifying the queries

Sr Oracle Reports, Financial Consultant

ETCC, Electronic Transactions Consultants
Richardson
01.2011 - 11.2011
  • MDX(Miami Dade Expressway Toll Processing System) Reporting Portal
  • MDX Reporting Portal consists of Reports Designed and Developed using Oracle Reports and Crystal Reports (XI and 2008) for the MDX (Miami Dade Expressway) Client for Electronic Transactions Consultants
  • C#, C++, Active Dashboard Build, Web FOCUS, Business Objects, SQL Windows XP, Oracle 11i, Oracle Reports Builder 6i, Crystal Reports XI, Crystal Reports 2008,FileZilla, CVS, JavaBean, Net Beans IDE, Java Script, SQL, PL/SQL,ETL Oracle Data Integrator.

Sr. Crystal Reports Consultant / Financial

SAP
12.2009 - 05.2010
  • Sharp, MS Access 2010, MS Excel 2010,HPQC Defect Tracking System, VBA, Kewill Reporting System Upgrade
  • Upgraded the existing Pacman Reports in Crystal Reports 10 into using the new database schema, views and stored procedures for Development, Test and Production servers.

Sr. Oracle Crystal Reports Developer / Reporting Specialist

PACMAN Reporting System, Neiman Marcus
Irving
07.2008 - 11.2008
  • PACMAN Shipping, Sales, Stores and Item reports consists of Reports of Items that are Sold Not Shipped, Fraudulent Address Reports, ending and selling store overdue reports consisting of both Inbound and Outbound data, Sales based on Association or Address, Pick Tickets, Inter State Transfer reports for Worksheet, Manifest Locations for all and each locations Report, Pacman Shipment Validation Report
  • Developed the 12 Reports in Crystal Reports 2008 using command objects and calls to the Stored Procedures returning the data using Ref Cursor
  • The data for these reports were developed using Command objects in Crystal Reports 2008 and Stored Procedures created in Oracle 9i
  • Created the Formulas, Groups and Suppression formula for the Reports in Crystal Reports 2008
  • Developed the Stored Procedures and Packages returning the Ref Cursor for the queries to build the Data sets for the Reports in SQL Developer using Oracle 9i PL/SQL Cursors, Variables
  • Scheduled the Report in Crystal Management Console and exported it in Acrobat format and Excel Formats
  • Created the PL/SQL Procedures, Packages, Functions and Triggers for Oracle 11i Database using TOAD
  • Updated the reports created using command objects with Stored Procedures and tested them in all three environments
  • Created inline Sub Reports for the Pick Tickets Report to display the data for Pick Ticket File Copy, Sends and Customer data
  • Led research initiatives and analyses and resolutions of issues; focused upon process improvement
  • Managed individual-participant cases to ensure timely closure and conducted appropriate trend analysis on escalations
  • Reported development, creations, and resolutions to meet client and internal needs; employed applications, such as SQL and data-manipulation applications and tools
  • Constructed tests and implemented portions of business solutions through the application of appropriate software
  • Researched business environment and technical content
  • Investigated and resolved problems with appropriate software and standard systems
  • Analyzed, identified, and resolved technical problems
  • Environment: HTML, Java, .Net, Active-X, FLEX, C#, C++, Active Dashboard Build, Web FOCUS, Business Objects, SQL Windows 7, Wintel Server, Unix Shell Scripts, Oracle 11g,Pro
  • C,AIX,SAP Crystal Server 2011,Tomcat Server, SAP Crystal Reports 2011

Sr. Crystal Reports Consultant

Hughes Network Inc
Germantown
03.2004 - 07.2004
  • Enterprise 9.0, UNIX Shell Scripting, Crystal Publish Toolkit, SQL Server 2000, DTS, VBA, Windows 2000.

Sr. Crystal Reports Developer

Excel Energy Corporation
Minneapolis
05.2003 - 07.2003
  • The administration tool is used to Create, manage and export the allocations of the Budget, Forecast and Actuals based on the Period and the Version
  • The data is exported to Excel
  • The populate module populates the Grids for the Fiscal year with the current and Previous years
  • The reporting was done on a Monthly basis and yearly basis for Actuals, Forecast and Budgets based on the Clients Allocations and the General Ledger.

Sr. Crystal Reports Consultant

South Florida Water Management District
West Palm Beach
04.2002 - 04.2003
  • QMEAS, Flow Program and related Forms (5.0) applications Collect, Maintain, reproduce data on the water levels in the different stations and sites throughout South Florida and compute the Flow levels of water with different structures and pumps in the Stations
  • 9i, MS Access 2000, PL/SQL, Pro
  • C, Forms 4.5,5.0, 6i, 9i, (Developer 2000), Forms 6i, Reports 2.5,6i,9i, Designer 2000,9i Java, JDeveloper, XML, Oracle Discoverer 3.1,SQL, Unix Shell Scripting, Software (Chameleon), Citrix, Sun Solaris, Visual Basic 6.0.SQL Server Projects , Visual Basic (6.0, 4.0), ASP 3.0, COM, COM+, ADO, SQL Server (7.0, 6.5), ACTIVE X, JavaScript, Windows NT /

Crystal Reports Consultant

UPS Logistics
Atlanta
02.2002 - 03.2002
  • The Intranet and Internet application for UPS Logistics was developed using Visual Basic and ORACLE 8i .There was also a FTP Engine developed using Visual Basic and the components were created using C and C++.The reports of the Flat Files was generated using Crystal Reports 8.0 and implemented in the Web for the intranet applications using Crystal Enterprise.

Crystal Reports Consultant

Ticket Order Integration, Destination Disney
Orlando
10.2001 - 02.2002
  • Ticket order Integration is an Enterprise Access; VB Crystal Reports based application that is also a Middleware for the legacy Mainframe systems
  • It is used to Book Tickets for the Disney Travel Itinerary.

Crystal Reports Programmer

Master Minds Inc
Atlanta
02.2001 - 10.2001
  • MasterMinds.Com is a website that is used to Maintain, Add and Manipulate the company information and consultant information for the Consulting Group
  • It has information about Hotlist, Jobs and other consulting services of master Minds.

Programmer/Analyst

Lucent Technologies
Holmdel
06.2000 - 02.2001
  • Any Media Graphical Access System is a Telephony Interface that connects the Ports and Packs with the Telephone Networks
  • The Shelf and Sub-shelf views form the interface for the Telephony
  • It supports both traditional narrowband and the broadband services so that both voice and data services

Programmer/Analyst

Social Services of the State
Pierre
11.1999 - 06.2000
  • A maintenance and information tracking system, for Family and Child Care system
  • This is used to determine the Amount owed by the Foster parents to the abused or neglected child
  • Also tracks information about Client, Family, and RFS.

Medallion Property, Programmer/Analyst

Eltrax Systems Inc
Phoenix
01.1999 - 10.1999
  • Medallion PMS is an integrated Hotel Management System which includes reservation, guest services, registration, back office, housekeeping, groups, packages, night audit and other hotel functions for domestic and international properties
  • Enterprise wide 3-tier architecture was used to implement this.

Revelwood Consulting Services, NewYork City Ny
09.1998 - 12.1998
  • Microsoft Visual Basic 5.0,SQL Server 2000

Microsoft
04.1998 - 07.1998
  • Visual Basic 5.0,SQL Server 2000, Visual Basic 4.0,SQL Server 2000

DOT Foods Inc

Sirius Computer Solutions

Capital Contractors
New York

Merkle Inc
Columbia
  • A Customer Relationship Marketing Agency

Kronos Worldwide
Cranbury
  • Played the role of a Tableau architect/developer and providing Business Intelligence and EPM
  • Solutions using Tableau for financial, manufacturing, pharmaceutical and retail companies
  • Offshore service delivery of Tableau Reports and various solutions
  • Developed ETL processes using SSIS, DataStage and Teradata
  • Developed Sales and Retail data marts for ReETL tail clients
  • Built efficient and accurate data warehousing solutions
  • Implemented key solutions in different areas of the companies
  • Setup new Tableau test and production server environments
  • Design and development of framework manager model and transformer models to facilitate
  • Development of reports, multidimensional reports and dashboards
  • Creation of executive dashboards using all the latest features in different Tableau versions and Power BI
  • Developed complex report studio reports with cube as the data source
  • Provided assistance and support to the IT users to develop reports
  • Deploy, configure,maintain on Azure Cloud and also trouble shoot azure relatd issues
  • Involved in managing to stored import export data and operate Azure backup
  • Designed and implemented Azure virtual machine
  • Tableau, Sql Server, SSIS, Azure

Business Objects Reports developer

Prudential Insurance Edison NJ
Dallas
  • Using the internal tool Amplify worked on the support tickets on a daily basis using DB2,SQL Server, Oracle stored procedures, modified and recreated Unix shell scripts to Run the queries and email the users and customers
  • Performed release management using GITHUB and Jenkins
  • Upgraded the.120 existing crystal reports to Crystal Reports 2020
  • Created crystal reports using Command objects and stored procedures using Ref cursor
  • Oracle SQL,PL/SQL, SQL Server 2016 TSQL,DB2,Webi, Deski, Crystal Reports 2020, Unix, GitHub, Jenkins
  • Starr Insurance
  • Created Documents using Ghost draft
  • American Insurance Group
  • Created Stored Procedures in DB2 and created Reports using MicroStrategy and created stored procedures using Oracle PL SQL
  • DB2, MicroStrategy, Oracle SQL, PL/SQL

The Hartford
  • Integrated Triangle Reporting System
  • Modified the existing Package in Cores Database to enable the addition of new columns in the Master tables for Prem Sel and Premsel History, Generated SQL Scripts to modify the New Columns for Premsel and History tables
  • Designed, developed ,published and Tested the reports using Crystal reports for the Premsel logic using command objects and Stored procedures
  • Oracle, TOAD 12.13,Cryatal Reports 2018

Business Analyst Database Developer

Toyota
  • EDC Payment Rule Engine and Consumer Website and Consumer App
  • To track, evaluate and manage the Amount owed by the Toyota Customer for the Vehicle purchased or Leased
  • Mapped the Data Elements with the following Rule Channels Click2Pay,AutoCheque,PayOnline,PayByPhone,WalkInWU
  • WalkInCFP ,Debit Payment ,CSC ,Lockbox ,TTPS
  • Designed and worked with the Micro Services built to support the data requirements for the Rule Services
  • Data Services will collect the rule evaluation data from various sources and populate the rule facts
  • Data Services can be standard re-usable enterprise data services
  • Worked with Rule Data Mapping ,Data Catalog and Process Catalog for the Enterprise Asset .\
  • Used POSTMAN API for PUT and GET Api queries to test the APIs
  • Designed and developed a Package CUSTOMER_MINI_REGISTRATION with Stored Procedures using Types, Ref Cursors and Custom Exceptions that take Full Lastname, SSN and Account number To support the new forgot username and password flows
  • This Procedure is called by the API developed using Java Spring and interfaced using Angular JS part of the Consumer Website and Consumer App
  • Oracle PL SQL,SQL Developer, Sales Force, Postman API,MS Excel, Power Point

Senior Data Analyst

Tenet Healthcare
  • The Legacy system is maintained in AS 400 and the querying was thru Netezza for Data Analysis
  • The Reports were developed using Cognos and Tableau
  • Used Data stage for all the ETL Tasks
  • IBM Netezza, IBM Data Stage, Python, Cognos, Tableau, AS 400

Production Support Technical Engineer

Home Care Home Base
  • Interface Engine and Database Production Support Project involves fixing Tickets that have issues raised by the customers regarding the Medical Billing and Patient care team
  • Using the Ensemble Interface Engine analyzed and traced the services, processes and operations to get to the classes and Stored procedures that are being called in the interfaces for the health care related functions
  • Wrote TSQL Queries to update, insert and delete rows in the base tables to fix the issues in the tickets
  • Used JAMS Client to run Scheduled jobs that call Stored Procedures
  • Executed Batch files in SQL Server Power Shell in the Remote desktop server to transfer data for the months from the Vendors to the Customers
  • SQL Server 2014, TSQL, Oracle Service Cloud, Ensemble Interface Engines, JAMS Client and Health Share Studio (C# Classes), Microsoft Power Shell

Business and Programmer

Kaiser Permanente
  • Pasadena CA partial onsite and working remotely from Dallas, Analyst working with Medicare business Engine
  • Writing Stored Procedures using SQL and PL SQL Code to generate the business logic and enable the programmers to create
  • Accessed the database from Cloud and migrated it to Oracle
  • Oracle 12g,PL SQL, PaaS (Platform-as-a-Service), Cloud, AWS

Education

B.S. - Computer Science

Bharathiar University
India
01.1997

Skills

  • Oracle (7x, 8x, 9i, 10g, 11i)
  • DAO/RDO/ADO 20
  • SQL
  • PL/SQL
  • TSQL
  • SQL Server
  • Crystal Reports 2020
  • Crystal Reports 2008
  • Crystal Reports 2011
  • Crystal Reports XI
  • Crystal Reports 90
  • Crystal Reports 85
  • Crystal Reports 60
  • Crystal Reports 50
  • Crystal Reports 30
  • Crystal Enterprise Server
  • MS-Access
  • Developer 2000
  • Oracle Forms
  • Oracle Reports 6i
  • Seibel (2000, 70)
  • Peoplesoft
  • Web FOCUS
  • GITHUB
  • Jenkins
  • CVS
  • Visual Sourcesafe
  • TOAD
  • Plus
  • PL/SQL Developer
  • Workflow Builder
  • Loader
  • Visual Basic
  • C
  • HTML
  • XML
  • JSON
  • CSS
  • JAVA
  • Javascript
  • AngularJS
  • ADONET
  • BI Tools Tableau
  • Cognos
  • Power BI
  • Business Objects
  • Microstrategy

Certification

  • MCP (Microsoft Certified Professional – Visual Basic – 4.0)
  • Diploma in RDBMS & Oracle 7.1, Developer 2000 Software

Personal Information

Citizenship: US Citizen

Timeline

Business Intelligence

ARCH MI
04.2023 - 01.2023

Tata Consultancy Service
11.2018 - 02.2023

Senior Data Analyst

Employer Tek Systems, American Airlines, SAP
01.2018 - 04.2018

JP Morgan Chase Lewisville
04.2017 - 12.2017

Senior Crystal Reports, Oracle Programmer

Atmos Energy Dallas
01.2017 - 03.2017

SQL Server Crystal Reports Programmer

Universal American Mortgage Company
06.2016 - 11.2016

Business Objects, Oracle Developer

Hyatt Vacation Ownership
02.2016 - 05.2016

Sr Oracle Reports, Financial Consultant

ETCC
09.2015 - 01.2016

Senior VBA, Oracle .Net Developer

JP Morgan Chase
03.2015 - 08.2015

Senior SQL Server/MS Access VBA Consultant

Blue Cross Blue Shield
05.2014 - 09.2014

Lead Financial Reporting Consultant

National Cash Register, NCR
09.2013 - 03.2014

Access/Crystal Reports Developer

Neiman Marcus
02.2012 - 12.2012

Sr Oracle Reports, Financial Consultant

ETCC, Electronic Transactions Consultants
01.2011 - 11.2011

Sr. Crystal Reports Consultant / Financial

SAP
12.2009 - 05.2010

Sr. Oracle Crystal Reports Developer / Reporting Specialist

PACMAN Reporting System, Neiman Marcus
07.2008 - 11.2008

Sr. Crystal Reports Consultant

Hughes Network Inc
03.2004 - 07.2004

Sr. Crystal Reports Developer

Excel Energy Corporation
05.2003 - 07.2003

Sr. Crystal Reports Consultant

South Florida Water Management District
04.2002 - 04.2003

Crystal Reports Consultant

UPS Logistics
02.2002 - 03.2002

Crystal Reports Consultant

Ticket Order Integration, Destination Disney
10.2001 - 02.2002

Crystal Reports Programmer

Master Minds Inc
02.2001 - 10.2001

Programmer/Analyst

Lucent Technologies
06.2000 - 02.2001

Programmer/Analyst

Social Services of the State
11.1999 - 06.2000

Medallion Property, Programmer/Analyst

Eltrax Systems Inc
01.1999 - 10.1999

Revelwood Consulting Services, NewYork City Ny
09.1998 - 12.1998

Microsoft
04.1998 - 07.1998

DOT Foods Inc

Sirius Computer Solutions

Capital Contractors

Merkle Inc

Kronos Worldwide

Business Objects Reports developer

Prudential Insurance Edison NJ

The Hartford

Business Analyst Database Developer

Toyota

Senior Data Analyst

Tenet Healthcare

Production Support Technical Engineer

Home Care Home Base

Business and Programmer

Kaiser Permanente

B.S. - Computer Science

Bharathiar University

Similar Profiles

CREATE PROFILE
Kalyan Ganesan