Tech Lead
FIS
Total years of experience :9 years, 2 Months
Managing the Data Migration Project and Leading the Data Warehouse Team. Also interacting with Product and Client Team
Technologies & Tools Used: BI Tools: SSRS 2008 and SSIS 2008.
RDBMS: SQL Server 2005 & 2008
Framework: .NET 3.5/.NET 2.0
Development Tools: Visual Studio 2008
Operating Systems: Window Server 2003/Window XP
AMEX ODS Project: - American Express Business to improve their sales in various sectors, comparing their market growth with other competitors, helping the marketing team to come up with the forecast values and expected product growth values for the upcoming financial year, Helps the Business team to come with the new offers & Plan to be maintained for the next six months in the inventory and guiding the finance team to come up with the Budget and projection values.
Technologies & Tools Used: BI Tools: MSBI (SSRS, SSIS & SSAS) & Active Report Server
Data-Modeling Tool: Oracle-SQL Data Modeler
Scripting Language: MDX
RDBMS: SQL Server 2005 & 2008
Framework: .NET 3.5/.NET 2.0
Web Server: IIS 6.0
Development Tools: Visual Studio 2005/2008
Operating Systems: Window Server 2003/Window XP
Card Inventory Management System (CIMS) - is web based application being used by our clients like American Express, BHN and Westpac this application is designed for the user to place bulk prepaid card orders, set reorder levels for automatic reordering, track inventory status, reassign cards from one location to another and destroy cards in the inventory. The system also allows a bank branch to acknowledge the receipt of shipped prepaid cards along with different online reporting capabilities.
Technologies & Tools Used: Languages: C#.NET 2.0, ASP.NET 3.5, JAVA Script, HTML, Web services and AJAX.
Zeetaa Business Solutions Private Limited, Chennai, India
Developer Aug 2006 -Jan 2007
Seldom Technologies, Chennai, India
Developer Apr 2006 -Aug 2006
Project Details
FIS - Fidelity Information Services, Chennai, India
Statement Re-write - is multi-threading package used to improve the performance of the Statement Generation process. This application is designed to completely change the statement generation approach by Daily Population Process and Monthly Summarization process. So that Statement Generation will get completed within SLA Timings.
Technologies & Tools Used: BI Tools: SSIS
RDBMS: SQL Server 2005 & 2008
Development Tools: Visual Studio 2005/2008
Operating Systems: Window Server 2003/Window XP
Prepaid Data Solutions (PDS) - is web based Reporting application being used by our clients like American Express, US Bank, PSCU and Blackhawk. This application is designed for the user to analyze the business results through Cubes. The System also provides the ability to save the User Parameters as Favorites, so that user can select the favorite option to generate the results. Administrator module will help the user to provide the access to the Reports for Report Users. Based on Use Cases, we have created the Report Models using Active Report Server and made it available for Dynamics Reporting. We have analyzed our database schema and generated the Dimensional Modeling for Analytics purpose. Our cubes uses this dimensional modeling for OLAP Systems.
Technologies & Tools Used: BI Tools: MSBI (SSRS, SSIS & SSAS) & Active Report Server
Data-Modeling Tool: Oracle-SQL Data Modeler
Scripting Language: MDX
RDBMS: SQL Server 2005 & 2008
Framework: .NET 3.5/.NET 2.0
Web Server: IIS 6.0
Development Tools: Visual Studio 2005/2008
Operating Systems: Window Server 2003/Window XP
Card Data Migration (CDM) - is ETL Process used to migrate the Data from American Express Legacy System into FIS System. Using this ETL Process, we have migrated 100 million cards and its related Transaction details into our system.
BI Tools: SSRS 2005 and SSIS 2005.
RDBMS: SQL Server 2005
Framework: .NET 2.0
Web Server: IIS 6.0
Development Tools: Visual Studio 2005/2008
Operating Systems: Window Server 2003/Window XP
Roles & Responsibilities: • Estimating work requests, analysis, design, coding, unit testing, debugging, migration activities and production release.
• Performed Dimensional Modeling to meet the Reporting Requirements.
• Accommodated SCD Changes in the dimensional Model.
• Actively involved in gathering requirements, designing BI report requirement templates and implementing standard, procedural and change control guidelines
• Designed and implemented a reporting data model to meet existing and future anticipated reporting requirements.
• The data model was designed as a star & snowflake schema and had fact tables to support the Client Requirements
• Designing the Cubes, Attribute Relationships, Partitions, KPI, Processing the Cubes & Automating the Cube Processing using XMLA.
• Implemented User Security rights by creating Roles & Provide the necessary permissions.
• Clarifying client requirements, business needs and project objectives, via feedback sessions and client meetings, in collaboration with all the stakeholders.
• Creating the Packages using Most of Control Flow, Data Flow Components to achieve the requirements.
• Designed the packages in such a way that, if issues happened Package will resume where it gets failed using Checkpoint option in SSIS.
• Creating the Standard Error Handling SSIS Packages, this will be used in Other SSIS Others.
• Provided the Solution for Dynamic DB Connection Creating Using Registry Entry in SSIS.
• Provided the SSIS Deployment Procedure to the DBA Team to handle the Migration Process.
• Creating the Dashboard Reports, MATRIX Reports Using SSRS 2008
• Provided the Standard Report Design Templates for On-Demand & Subscriptions Reports.
• Creating a Roles & Group for Accessing the Reports.
• Worked with Microsoft SSRS Team to Solve the Excel Rendering & Performance Issues.
• Provided the Solution for Load Balancing Using SQL Server Session State and Report Viewer R2.
• Work along with senior architects to design large scale technical works.
• Creating the web pages based on FIS Standards using AJAX, Query and Integrated the SSRS Using Report Viewer.
• Creating the Web services along with required business and back end layer codes such like business library using C# and SQL server stored procedures.
• Creating the Report Models based on Use Cases and provided the samples Reports to the User.
• Designing back end tables, writing stored procedures and triggers.
• Environment Set-Up - Including Web-Site Creation, SSRS Server Set up (Includes Execution Account, Data Driven Subscriptions and Application Pool Settings)
• Acting as Off - Shore Team Leader for the Prepaid Data Solutions Project.
• Providing production support and addressing high severity issues in timely manner, fine-tuning the surviving code and improving the performance.
• Analyzing existing .Net applications to fix bugs, enhancing and leveraging to support business requirement.
• Working on out of hours production support for prepaid card system on roster basis.
B.E in Computer Science (Honors) Anna University, Chennai, India 2002 - 2005
Diploma in Electrical & Electronics Engineering (Honors) Madras University, Chennai, India 1998 - 2001 Personal Memorandum Name: Ganesh Kothandaraman E-Mail: mailtoganeshk@gmail.com Address: 378/B, Netaji Boss 9th Cross Street, Vallalar, Vellore Tamil Nadu Pin Code - 632 009 Mobile: +91 9994126348 Passport Number: G7897651 Passport Expiry Date: 9/4/2018 US Visa Type: B1