Poorani Ganesan
19,Omsakthi Nagar, Mobile: 9840394680
Kondur PO, Cuddalore – 607006 Email: poorani_gs@yahoo.co.in
Experien...
Poorani Ganesan
This is the key application used by RadioShack for avoiding theft and loss prevention of
store items there...
Poorani Ganesan
Price Change Report project purpose is to create pricing reports that fits the requirements
of a retail st...
Poorani Ganesan
 Effectively used SharePoint Designer workflows for task creation and mail sending
functionalities
 Effi...
of 4

PooraniGanesan_Resume

Published on: Mar 4, 2016
Source: www.slideshare.net


Transcripts - PooraniGanesan_Resume

  • 1. Poorani Ganesan 19,Omsakthi Nagar, Mobile: 9840394680 Kondur PO, Cuddalore – 607006 Email: poorani_gs@yahoo.co.in Experience Summary Cognizant Technology Solutions India Pvt. Ltd (2009 Onwards) • Proven Technical Expertise in Application Development for 5 years in core IT (3 years in Retail Domain) • Skillful in Design, Coding and Unit Testing of Windows, Console and Web Applications using .NET 2.0/3.5 • Expertise in package creation using SSIS 2005/2008 and reports creation using SSRS 2005/2008R2 • Significant experience in creation of Web Applications using SharePoint MOSS 2007 • Microsoft Certified for .NET Web Application Development Technical Skills Technology : .NET Framework, ASP.NET, ADO.NET, Microsoft SharePoint (MOSS 2007) Programming Languages : C, C++,C#.NET Databases : MS SQL Server Scripting Languages : JavaScript, HTML, JQuery, Ajax Other Utilities : Microsoft Office 2007, Microsoft Visio Tools : SSIS 2005, SSRS 2005/2008, Active Batch V9 Microsoft Certified for .NET Framework 2.0 Application Development Foundation (70-536) Project Profile KEY PROJECTS UNDERTAKEN  Cycle Count Certifications
  • 2. Poorani Ganesan This is the key application used by RadioShack for avoiding theft and loss prevention of store items there by increasing the profit margin. Stores will be instructed to take physical inventory twice or thrice a year which didn’t cover many valuable items loss/ missing items in the store. So to overcome that RadioShack came up with cycle count which will take inventory of subset of items in the store on a periodic basis like once in a week to keep track of all the high valued items. RadioShack stores will be intimated to take cycle count on a date and a list of items to be taken will be sent via email and also the store DB will be updated. Store associates will make use of a windows application to feed in the inventory details which will be sent to store center via FTP. Stores users can see a report of mismatching items count between on hand quantity and store center quantity in the windows application. Web services will be used to fetch the store center quantity. Environment: ASP.NET, C#, SQL Server 2008, WCF, LINQ.  Daily Sales Report Automation Daily Sales Report Automation project purpose is to automate the process of report generation for daily sales figures which was initially generated manually every day morning using the previous day sales figures and comparisons of the figures against plan, previous days, weeks, months and years. The data for these reports will be loaded from different interfaces into SQL server 2008 using SSIS packages and reports are generated using SSRS 2008 and mail messages will be sent to business persons after reports generation with a mail summary of the report and the path for the reports to view where it will be stored in the excel format. • Designed the Database structure and created TDD • Developed the packages using SSIS 2008 • Created the complex stored procedures for the reports using SQL server 2008R2 • Single handedly created reports (7 normal reports and 2 parameterized reports) using SSRS 2008 and handled reports access restrictions through Report Manager • Implemented data validations before report generation and send mail alerts regarding the exceptions using SSIS • Automated report generation after data validation part in SSIS by using SSRS web services  Price Change Report : Provide a pricing report for a retail store Page 2 of 4
  • 3. Poorani Ganesan Price Change Report project purpose is to create pricing reports that fits the requirements of a retail store. Reports are generated for price changes made in the market. Developed using SSRS 2008R2 and SQL Server 2005  Single handedly developed the entire project by directly interacting with the clients  Created the backend stored procedures for each report  Developed the reports using SSRS Tabular and Matrix reports  Was responsible for deploying the reports in the server  Created Unit Test Cases and done the unit testing  Delivered the project on time without any major defects  Delivery Excellence – Knowledge Management An initiative of the Cognizant Testing Practice to manage and share knowledge artifacts across Testing Practice / Individual accounts in testing Practice A. Testing Business Development Zone : A Website to host business development artifacts A web application development project which holds the different kinds of artifacts required for business development. Developed using MOSS 2007 and SQL Server 2005  Was responsible for designing the program flow for enhancements in the application  Designing and Customizing SharePoint websites (master pages, default pages, custom pages) using SharePoint Designer  Created custom web parts, custom event handlers for handling the default events in a customized way  Developed bulk upload functionality for uploading more documents to the SharePoint library at a time  Creation of complex SQL queries for querying SharePoint Content Databases and effective use of CAML Queries to fetch data from SharePoint document libraries  Creation and Maintenance of different site collections to address space and performance issues  Developed Scheduled jobs that will access SharePoint document libraries and update the custom tables  Played a major role in debugging and defect fixes  Single handed contribution for the migration of production server from old environment to new server  Interacted with other teams for getting data from them and managed the external dependency effectively. B. Action Item Tracker : A Website for tracking action items under various categories A web application project developed for recording and tracking action items. The action items created as a result of various surveys (CSS, BES, PMR, Engagement Plan and Others) and audits are assigned to the account managers. The status of those action items are tracked using this action item tracker. Developed using MOSS 2007, SQL server 2005 and SSRS 2008  Single handed contribution for design and creation of the portal Page 3 of 4
  • 4. Poorani Ganesan  Effectively used SharePoint Designer workflows for task creation and mail sending functionalities  Efficiently handled the user interface requirements by creating customized views  Customized the default SharePoint views using jquery  Implemented access restrictions efficiently using the SharePoint Groups and Access levels.  Created complex SQL queries for creating views of SharePoint Content Databases and used SSRS 2008 for creating various graphs  Interacted with other teams for support activities  Created the design document for the application C. Delivery Dashboard : A Dashboard for Testing Accounts A web application developed for comparing top 35 accounts across the Testing Practice by using key metric values. Users can view the performances of various verticals within Testing BU. Developed using .NET Framework and SQL Server 2005  As a developer, involved in the development activities like User Interface design, database design and unit testing  Contributed effectively for debugging and defect fixing  Used SSIS for input data porting to the backend tables Page 4 of 4

Related Documents