Project Sql Server
Resume:
Vasanthi Natarajan
***********@*****.**.**
PROFESSIONAL SUMMARY:
Technical Lead with 11 years of IT experience in designing, developing and integration of complex Windows and Web-based Applications using Microsoft Technologies.
Extensive Experience in Digital Marketing, Cable communication and Healthcare domain.
Extensive working knowledge in MVC.NET and Site core application development and support.
Extensive knowledge in Site core Multilingual and Personalization implementation.
Very Strong knowledge in using Agile methodology for software development and good knowledge in different SDLC (Software Development life cycle) phases.
Expertise Experience in end to end Development of web Applications using MVC, C#.NET, ASP.NET, ADO.NET, XML, Visual Studio.NET 2005/2008/2013 and Site core 7.2/8.1
Experience in design and development of packages using SQL server Integration Services.
Expertise experience in multi-vendor and multi stakeholders projects.
Expertise Experience in Trouble shooting, Debugging and Strong analytical problem solving skills.
Strong leadership, Interpersonal and Technical presentation skills. Highly motivated, works well independently, and in a team environment.
COMPETENCIES:
.NET Technologies MVC,VB.NET,ASP.NET,C#, ADO.NET, VisulaStudio.NET 2003/2005/2013, LINQ and Win Forms
Web Technology HTML, DHTML, CSS, XML and Java Script Content Management
System
Sitecore 7.2, Sitecore 8.1 and FCK Editor
Analytical Tool DTM and Web Trend
RDBMS/DBMS/OLAP SQL Server 2000/05/08 and MS Access Frame Work .NET Framework 1.1/2.0/3.5/4.5
Web Servers Internet Information Server (IIS 6.0 & 7.0) Reporting Tools Crystal Reports 2008
OS Windows 98/2k/2003/NT
Project Management Tool Microsoft Office project 2007 Modeling Tools Microsoft Visio
Version Controller Visual Source Safe (VSS) and Team Foundation Server 2005/2008 Agile project tracking tool JIRA and Rally
CERTIFICATION
1. Completed Microsoft Certified Technology Specialist for .Net Framework 2.0 Web Application. 2. Completed Cognizant Certified Architect program. 3. Cognizant certified in Communication Level 0.
4. Cognizant certified Innovation Idea Champion for the year of 2013. EDUCATION
Master of Computer Application Madurai Kamaraj University, Madurai. Bachelor in Computer Science Govt. Arts College for Women, Sivaganga. EMPLOYMENT HISTORY:
Employer From To Designation
Cognizant Technology Solutions
US Corp
Dec’ 14 Till Date Technical Project Manager
Cognizant Technology Solutions Feb’ 08 Dec’ 14 Senior Associate Projects Insoft.Com Pvt. Ltd Aug’ 07 Feb’ 08 Programmer
SpectraSoft Technologies Pvt Ltd. Jun’ 06 Aug’ 07 Programmer PROFESSIONAL EXPERIENCE:
Client: Kimberly-Clark March 2017 to Till Date
Project: Pull-ups, GoodNites, CAMP Innovation, CO-LAB, KC-Way, Disney & GSMI Location: Wisconsin, USA.
Role: Technical Lead.
Technologies: MVC.NET, JQuery, JavaScript, Site core 7.2 & 8.1, WEB API, Coveo, DTM, Web Trend and Knockout.
Team Size: 15
Sprint Teams: 5
Project Summary:
Pull-Ups and GoodNites are the Kimberly Clark brand of disposable training pants and bedwetting products made under the Huggies brand of baby products. CO-LAB, KCP, Disney and GSMI projects are Kimberly Clark corporate websites which is the corporate collaboration websites.
This website has the multiple functionalities like customer registration, customer survey, customer quiz, and newsletter subscription, buy online products with various categories, Articles, coupons, special promotional, ratings & reviews and campaigns. It’s designed in Sitecore component based architecture to provide the personalized web user experience. These websites are updated on a regular basis with new offers, products campaigns and have all the latest Social Networking tools. So these websites are fully designed in component based site core architecture along with multilingual and personalization to provide the enhanced digital user experience and meet the company marketing business strategy. ROLES & RESPONSIBILITIES:
Playing Technical & Functional Analyst for all the brands and single point of contact in onsite.
Gather requirements related to these brands and provide requirement walkthrough to offshore team.
Developing technical story in JIRA and monitoring the status.
Design & Develop the application using MVC.NET, C#, WEB API, Sitecore and Javascript.
Design the technical implementation approach for each promotional campaign & commercial programs.
Design & Develop the site core components which includes layout, templates and contents, etc.,
Design & Develop the Multilingual and personalization Sitecore component.
Design, develop & enhance the Sitecore workflow.
Develop the site core package and publish in other environments.
Performing code review to ensure all client specific standards are met.
Working with Analytical team to get the tagging requirement and metrics like frequently visited page & browser, most popular product and provide the same input to business to come-up with the new strategies.
Perform test case review.
Provide User Acceptance demo to business team and other stakeholders.
Providing end to end application development & support.
Perform Unit Testing,Integration Testing Support, bug fixing etc.,
Perform Cutover, Go live preparation activities & support etc.,
Perform Post deployment end to end validation (Dev, QA, Prod) Client: Comcast Dec 2014 to March 2017
Project: Business Class Portal.
Location: Philadelphia, USA.
Role: Technical and Delivery Lead.
Technologies: MVC.NET, Site core 7.2 & 8.1, WEB API, SOAP, DTM and Knockout. Team Size: 30.
Sprint Teams: 3.
Project Summary:
The Business Class Portal (BCP) is the commercial counterpart of Comcast’s residential portal, ‘My Account’. The BCP is designed to have a fresh, more modern aesthetic than compared to its legacy application. BCP allows business customers a wide array of functionalities to manage their business while offering three specific services from Comcast SMB customers Internet, Phone, and TV and Enterprise customers PRI and Ethernet.
The major areas of testing fall in the scenarios of the customers being able to perform workflows of paying their bills, manage and create users, register domains and create websites, as well adding and assigning email boxes, manage TV etc. The Comcast Business Class Portal is the future for managing businesses.
ROLES & RESPONSIBILITIES:
Managed the team as Technical & Delivery Manager for 3 sprint teams which includes onsite & offshore with multi skill set of people with total team size 30.
Gather requirements related to the Business Class Portal Component and provide requirement walkthrough to offshore team.
Design & Develop the application using MVC.NET, C#, WEB API, Sitecore and Javascript.
Design the technical implementation approach for each feature.
Design & Develop the site core content trees which includes layout, templates and contents.
Performing design and code review to ensure all client specific standards are met.
Technical co-ordination with offshore team to make sure project is going on-track.
Providing end to end application support for the Business Class Portal Application.
Perform Unit Testing,Integration Testing Support, bug fixing etc.,
Perform Cutover, Go live preparation activities & support etc.,
Perform Post deployment end to end validation (Dev, QA, Prod) Client: AT&T Inc., Feb 2013 to Dec 2014
Project: TV Account Manager.
Location: Chennai.
Role: Technical & Delivery Lead.
Technologies: NET framework 4.0, WCF, REST, Razor, JQuery, ASP.NET, ADO.NET, C#, XML, DHTML, HTML5 and Mediaroom.
Team Size: 5.
Sprint Teams: 1.
Project Summary:
IPTV Account Manager is an IPTV application which provides a rich TV front end for the customers to view their AT&T U-verse account summary over the TV. It allows the users to browse through the upgrading options for TV services, Wireless receivers, High Speed Internet Access (HSIA) services and Voice-Over Internet Protocol (VOIP) services. ROLES & RESPONSIBILITIES:
Managed the team in offshore and coordinated with Onsite team.
Being new to this IPTV applications development, was able to understand all the Mediaroom features and controls and became a master in implementing and testing the same.
Extensively worked on .NET framework 4.0 with WCF.
Developed and consumed WCF Service and REST services as part of development.
Proposed POC for rewriting ASP.NET to MVC4 with Razor & JQuery website and rewriting upon getting approval from Client.
Proposed and developed a POC for re-designing the UI with HTML5 which can be single source application across all the three platforms [Set-Top-Box/Desktop/Mobile].
Involved in application architectural design and setup.
Designed & Developed Web Forms using ASP.NET, ADO.NET, C#, XML, DHTML, HTML5 and Java Script.
Developed ASP.NET applications that are not contagious by Web Security Threats.
Responsible for Configuration Management and creating installers using Teamcity.
Involved in maintaining code with Team Foundation Server (TFS).
Worked on Agile Methodology.
Developed and tested the application to have uniform look and feel across all TV resolutions
(SD/HD/HD WIDE).
Client: Cognizant, Oct 2011 to Feb 2013
Project: Cognizant 2.0 - IDE [Integrated Delivery Excellence]. Location: Chennai.
Role: Project Lead.
Technologies: C#.NET, ASP.NET 2.0, SSIS 2008, Fusion charts JavaScript, JQuery, and SQL Server 2008.
Team Size: 7.
Project Summary:
IDE is the dashboard which aims to consolidate all the individual scores from different modules and provide the Delivery excellence score .Delivery excellence score will compute based on the maturity and delivery performance score which will compute at project level and rolling it up to practice, account, vertical and sub-vertical level. Maturity score is computing based on the parameter such as Planning and tracking effectiveness and Metrics submission. Delivery performance score is computing based on the metrics such as Effort variation, Schedule variation, Defect removal Efficiency and etc.
This project provides Cognizant Management team with the ability to generate metrics dashboard using C2.0 and to analysis the project performance. It is used by above PM, SPM and most senior management people in the cognizant to analysis the project performance under respective Practice, Vertical, Account and Main Project level.
Contribution / Highlights:
Managed the team and monitored project activities.
Involved in the complete High level and low level design of data model.
Designed and development of staging and data mart tables.
Studied and Analyzed Requirement Specification.
Analyzed the impact for CR’s.
Attended project quality/delivery audit.
Task allocation to the resources.
Coordinated with requirement team, testing team, build team, user documentation team, etc.,
Designed and developed on line transaction SSIS packages for staging and Reporting tables.
Developed business objects in C# for implementation of business logic to implement the Validation for the interface data.
Designed new multi select control which will overcome the load issues. Involved in Unit Testing and Integration Testing.
Client: Cognizant Mar 2011 to Oct 2011
Project: Cognizant 2.0 – Project Demographics.
Location: Chennai.
Technologies: C#, ASP.NET 2.0, SSIS 2008, Fusion charts, JavaScript, JQuery and SQL Server 2008. Role: Project Lead.
Team Size: 5.
Project Summary:
Project demographics is the dashboard, would provide the project insights at practice and Engagement level by various dimensions like solution Type, Technology, process model, client/delivery partner, PM and location compared with FTE. It will comprise three dashboards such as Project demographics dashboard, New project arrival trend and Active and Closed project count trend. These dashboards are available in Project Demographics dashboards with three different levels such as Organization, Practice and Engagement. This project provides Cognizant Management team with the ability to generate project dashboard using C2.0 and to analysis the project details and count. It is used by above PM, SPM and most senior management people in the cognizant to analysis the project count under respective Practice and Account.
Contribution / Highlights:
Managed the team and monitored project activities.
Involved in the complete High level and low level design of data model.
Designed and development of staging and data mart tables.
Studied and Analyzed Requirement Specification.
Analyzed the impact for CR’s.
Attended project quality/delivery audit.
Task allocation to the resources.
Coordinated with requirement team, testing team, build team, user documentation team, etc.,
Designed and developed on line transaction SSIS packages for staging and Reporting tables.
Developed business objects in C# for implementation of business logic to implement the Validation for the interface data.
Involved in Unit Testing and Integration Testing. Client: Cognizant, Dec 2009 to Mar 2011
Project: Cognizant 2.0 – Metrics.
Location: Chennai.
Role: Team Lead.
Technologies: C#.NET, ASP.NET 2.0, JavaScript, JQuery and SQL Server 2008. Team Size: 5
Project Summary:
Metrics is a program which aims to connect these platforms so that - process and knowledge seamlessly flows across the systems improving the productivity and Quality of our deliverables. Also this program aims to provide a Unified environment, where processes are seamlessly enacted and guidance is made available based on the context of the work. The Tracking project automatically calculates the metrics based on granular tracking details like Task and requests. Metrics are also calculated based on various categories like effort, Schedule, Size and defects. This project provides Cognizant Management team with the ability to generate metrics dashboard using C2.0 and to analysis the project performance. It is used by above PM, SPM and most senior management people in the cognizant to analysis the project performance under respective Practice. Contribution / Highlights:
Managed the team and monitored project activities.
Involved in complete requirement gathering, analysis and estimation.
Involved in the complete design of DB model.
Involved in designing, coding, unit and integrated testing.
Analyzed the impact for CR’s.
Task allocation to the resources.
Coordinated with requirement team, testing team, build team, user documentation team, etc.,
Designed and developed on line transaction SSIS packages for staging and Reporting tables.
Developed business objects in C# for implementation of business logic to implement the Validation for the interface data.
Involved in Unit Testing and Integration Testing. Client: Cognizant Feb 2008 to Dec 2009
Project: Cognizant 2.0 - AKG (Active Knowledge Guidance). Location: Chennai.
Technologies: WCF, ASP.NET 2.0, SQL Server 2005, JavaScript and Log4Net. Role: Developer.
Project Summary:
AKG (Active Knowledge Guidance) is a search engine. It’s used to search the things
(keywords) from different server such as C20, Channel One, and Rainbow Portal. Here we are providing lot of features for searching the keywords based on user input it will take the argument and search the keyword. For example if the users select My Account it will search only from his/her Account or it will search from all accounts from organization. Contribution / Highlights:
Involved in the High level and low level design of data model
Studied and Analyzed Requirement Specification
Have done the coding.
Involved in Unit Testing and Integration Testing. Client: Insoft.Com Nov 2007 to Feb 2008
Project: Chios Online.
Location: Chennai.
Technologies: ASP.NET 2.0, AJAX, SQL Server 2005, JavaScript and FCK Editor. Role: Developer.
Project Summary:
Chios Online is a Content Management System to develop the webpage by using FCK Editor. For creating the content of the web page, we are using one third party control that is called FCK Editor. Web pages are creating based on category. For Page creation we need images, variables and templates.
Contribution / Highlights:
Developed User Interface for the same
Studied and Analyzed Requirement Specification
Closely worked with users and other developers for database design. Understanding Active Directory
Client: Insoft.Com Jun 2007 to Nov 2007
Project: FitClassOnline.
Location: Chennai.
Technologies: ASP.NET 2.0, SQL Server 2005 and JAVASCRIPT. Role: Developer.
Project Summary:
This project is used to store and fetch the customers (Member/Student) information from the Central Database and show the information to customers through Online and give the provision for online payment. The Offline Application is used to create and update the Member/Student information about personal and following test information such as Medical test, Cardio bike test, Cardio group test, Heartrate test, strength test and Body Composition test also done in Offline Application and store the detailed information to relevant tables. Online Application is used to fetch information from central database and show to customers through online. In Online Application mainly focused on Payment. Contribution / Highlights:
Involved in Design phase of the User Interface.
Understanding and implementing Requirement.
Developed User Interface for the same. Maintenance of the Application. Client: SpectraSoft Apr 2007 to Jun 2007
Project: Automation.
Location: Chennai.
Technologies: VB.Net, SQL Server 2005 and JAVASCRIPT. Role: Developer.
Project Summary:
The project is developed to automate the development for Data Layer and Presentation Layer. But it’s only focused on Master Screens; it will support Transaction screens partially. The main screen name is called Table Creation. It’s used to create the tables dynamically. While creating tables we have the option to select the type of columns, it will fetch from Control Type master tables. The Control Type table contains the type of control whatever is avail in .Net
(Textbox-Dropdown List, C-Checkbox, etc.).So after creating the tables we will click the Generate Data Layer Button. So it’ll generate the DL for every table in separate class files. This class files only contains the general things like Insert, Update, Delete and select, etc. If we need some other specific function we need to create manually in the relevant class files. After creating the DL creation we have to create menus in PL .Every menu linked to the relevant tables. While clicking the menu it will generate the controls. This is how the Automation will work. The main advantage of this product is time consumption for master screens and if we want to change anything in screen levels that it will be very easy to do. If we change the table structure it will automatically reflect the screen appearance.
Contribution / Highlights:
Developed User Interface for the same
Studied and Analyzed Requirement Specification
Closely worked with users and other developers for database design.
Involved in Unit Testing and Integration Testing Client: SpectraSoft Nov 2006 to Apr 2007
Project: SHE (Safety Healthy Environment).
Location: Chennai.
Technologies: ASP.Net 2005, SQL Server2005 and JAVASCRIPT. Role: Developer.
Project Summary:
This product is developed to focus the MSDS (Material Safety Data Sheet).MSDS contains the properties and behaviors of the chemical. This main focus of MSDS is each and every person should know about the MSDS of chemical whoever is going to handle the chemical. So we can avoid the Accidents and make Safety Environment. And also it contains Safety Internal Audit and Incident Management System records. This product contains three modules. Such that Master, Transaction and Reports.
Contribution / Highlights:
Developed User Interface for the same
Studied and Analyzed Requirement Specification
Closely worked with users and other developers for database design.
Understanding Active Directory
Client: SpectraSoft Jun 2006 to Nov 2006
Project: eCTD (Electronic Common Technical Document). Location: Chennai.
Technologies: VB.NET 2003 and XML.
Role: Developer.
Project Summary:
The product is used to submit the CTD to the Regulatory Bodies Electronically. The main feature of the product is that we can submit the CTD by Electronically, So no need to maintain the bulk of papers. Resubmission is also very easy because we have previous submitted documents. So we can modify and submit. The Regulatory Authorities also can verify the previous submission and current submission. The backbone of the eCTD is XML, so memory space also very less only. This is folder based product. There are five folders, such as M1, M2, M3, M4, M5.Here M2-M5 called Master document, it is common for all Regions.M1 called the Regional Documents, and it will differ Region to Region.
Contribution / Highlights:
Developed User Interface for the same
Involved in Design phase of the User Interface.
Handling entire data flow as an Xml.
Studied and Analyzed Requirement Specification
ACCOMPLISHMENT:
Got Outstanding Delivery Excellence Kudos for successful sprint delivery from Cognizant on Q1 2016.
Got multiple Kudos for successful sprint delivery from Comcast on 2015.
Got “Pat on the Back” SPOT award for the technical support to complete the new proposal and got the appreciation from customer on 2014.
Got Kudos award for the Proactive exploration in MPF on 2013.
Got Appreciation Awards for the smoother release on 2008.
Got Appreciation Awards for the smoother release on 2008.
Have provided the virtual training for “Fundamentals of .NET Framework” on 2011 as part of Cognizant Academy.
Personal Details:
Nationality
: Indian
Date of Birth
: 04-06-1982
Sex
: Female
Marital Status : Married
Contact Address : 740 E Shady LN, Apt # 1,
Neenah,
Wisconsin – 54956
Contact this candidate