|
|
Title: |
Database Migration
|
Location: |
US-California-Los Angeles
|
Work History: |
MANIKANDAN SACHIDANANDAN
332 N Ogden Drive,
Los Angeles,
CA - 90036
Email: mani.sachidanandan@gmail.com
Cell: 817-946-8233
Experience Summary:
--------------------
**More than 6 years of work experience in IT industry in client/server applications
**Microsoft Certified Solution Developer in .NET
**Experience in complete Software Development Life Cycle, Agile methodologies and SCRUM processes
**Experience in Media (Social Networking), Financial, Healthcare, Airline & Large National Membership domains
**Good hands-on experience in design and development of Large Scale Web and Windows applications using ASP.NET 2.0, C# 1.1, 2.0, VB.NET, ADO.NET, ASP, VB(6.0), VBScript, JavaScript, XML and XML Schema
**Good experience in database design and development using SQL Server 2000/2005 and Oracle
**Extensively worked with T-SQL/PL-SQL queries, Stored Procedures and Views
**Supported, administered and maintained production and development MS SQL Server database environments running on the Windows platform.
**Created and managed tables, constraints, indexes, grants and sequences.
**Performed backup and restore of database/schema
**Good experience with Object-Oriented programming (and concepts) usage in N-Tier Enterprise applications
**Sound understanding of .NET frameworks 1.1, 2.0 and 3.0
**Excellent verbal and written communication skills with ability to interact with business end users and comprehend and communicate project details
**Very good team player and ability to work under tight project schedules
PROJECTS
==========
COMPANY: MYSPACE.COM (Social Network), USA,
ROLE: Senior Developer
OCT 2007-PRESENT
----------------------------------------------------
Media Upload Service
Mar 2008-PRESENT
Collection of services, components to track the updates and multiple uploads of video, audio and image files.
Responsibilities:
**Analyzed and documented project requirements and specifications
**Created the backend database for media upload
**Managed tables, constraints, indexes, grants and sequences
**Maintained backup and restore of database/schema
**Handled database server tuning, application tuning
**Maintained documentation, capacity planning and database security
**Implemented ADO.NET components to process the incoming files and upload them to a LARGE SCALE Windows 2003 server farm
**Played the role of a scrum master and participated in daily StandUp and ScrumOfScrum meetings
Environment: ASP.NET 2.0, ADO.NET, C# 2.0, SQL Server 2005, Visual Studio.NET 2008, Win Server 2003, Team Size: 7
Music Services and Media Tracker
Oct 2007-Feb 2008
These projects involve MySpace in its recent joint venture of its clients. These are enterprise level reporting applications (web and windows), used to identify invalid media items and process flash application parameters
Responsibilities:
**Involved in Tuning TSQL queries for accessing flash parameters
**Altered databases/schema by creating and altering of tables, constraints, indexes, grants, and sequences
**Used SQL Profiler and Query Analyzer to identify performance issues
**Wrote complex T-SQLs and Views for stored procedures and functions
**Normalized the database for better performance
**Wrote ADO.NET C# components utilizing MySpace architecture to compare millions of xml nodes across source and target and store the results in the database in terms of additions, deletions and updates done to the source XML file.
Environment: ASP.NET 2.0, Win Forms, C# 2.0, SQL Server 2000, Visual Studio.NET 2008, Win Server 2003, Team Size: 5
COMPANY: SOLUTIONS DEVELOPERS, USA,
ROLE: Dot Net Developer
JUN 2006-SEP 2007
-----------------------------------------------------
Online Claims Portal, Client: Healthways (Healthcare Industry), Sterling, VA
Apr 07-Sep 07
A secure web tool which allows customers to view both in-process and historical claims improving research timeframes Responsibilities:
**Involved in creating the design documentation for the database
**Designed the Database using ERWIN tool for Microsoft SQL Server 2005.
**Created Stored Procedures and Views to implement logical business transactions.
**Performed a data conversion from excel file to SQL Server 2005 database
**Wrote complex T-SQL queries against the SQL Server 2005 database to access claims information
Environment: C#, ASP.NET 2.0, Infragistics 6.3, ERWIN, SQL Server 2005, VS.NET 2005, Win Server 2003, Team Size: 4
Web Service and Data Synchronization, Client: Colgan Air (Airline Industry), Manassas, VA
Dec 06-Mar 07
A web based system which provides employee information and cockpit access verification for requests made by CASS
(Cockpit Access Security System) for this airline company
Responsibilities:
Implemented the back end design for the capturing employee data and access verification
**Involved in code reviews and acceptance testing of the application.
**Wrote stored procedures for data synchronization process
**Developed user functions for the manual update web application
Environment: C#, ASP.NET 2.0, SQL Server 2005, Visual Studio.NET 2005, Win Server 2003, TFS Team Size: 3
Quality Assurance Profile Emailer, Client: Mortgage Electronic Registration System (Finance), VA
Oct 06-Dec 06
Windows Forms based application for emailing, a Quality Assurance (QA) Profile document to its member organizations.
Responsibilities:
**Integrated data access through Microsoft Windows Application Blocks for Data Access 2.0
**Designed the back end for storing user documents in BLOBS for the emailer application
**Implemented C# components to generate word document(s), send email(s) and log error(s) in event viewer
**Involved in code review, regression testing and maintenance of the application.
Environment: C#, SQL Server 2000, Visual Studio.NET 2005, Windows Server 2003, TFS Team Size: 3
Survey Data Collection and Chagas Reports, Client: American Association of Blood Banks, MD
Jun 06-Sep 06
A web application which accepts an excel survey data file, processes, stores and reports survey responses
Responsibilities:
**Created SQL Server database to responsively handle complex TSQL queries (stored procedures, functions, and optimization) and .NET data access components.
**Designed and implemented C# components which used ADO.NET to export survey data from an excel file to DB Server
**Wrote code for data access and manipulation using XML and ADO.NET.
**Developed middle-tier to access data from various databases
**Implemented reports (.rpt files) using SQL Reporting Services 2005 Reporting services
Environment: C#, ASP.NET 1.1, Visual Studio.NET 2003, SQL Reporting Services 2005, MCMS 2002, Team Size: 4
COMPANY: SYAPPS, USA,
ROLE: Dot Net Software Engineer
JUL 2005-MAY 2006
---------------------------------------------------------
File Transfer and Payroll Batch Import Tools, Client: International Labor Organization, DC Feb 06-May 06
Responsibilities:
**Provided technical development, maintenance and production support for the tools
**Written stored procedures for accessing the data from SQL 2000.
**Designed and implemented data file transfer using Win Forms and later implemented as a C# windows service
**Wrote C# components to process a payroll batch file and store in the Solomon Dynamics system database
Environment: C#, SQL Server 2000, MS Visual Studio.NET 2005, Solomon Dynamics 6.5, Win 2000, VSS Team Size: 4
Healthy School Report Card, Client: Association for Supervision and Curriculum Development, VA
Jul 05-Jan 06
Responsibilities:
**Developed and implemented best practices to ensure a consistent approach for database design.
**Assessed and optimized the efficiency and performance of existing SQL Server database structure and schema
**Created and managed tables, constraints, indexes, grants and sequences.
**Supported QA team through testing and validation.
**Used Crystal Reports to display schools across different groups and hierarchical display of groups and schools
Environment: C#, ASP.NET 2.0, SQL Server 2000, Infragistics 5.3, Crystal Reports 10.0, Win Server 2003, Team Size: 4
COMPANY: HCL TECHNOLOGIES, INDIA,
ROLE: Member Technical Staff
JUL 2000-JUL 2003
----------------------------------------------------------
Web Author, Client: Thomson Financial, NY
Mar 03-Jul 03
Production and authoring application that allows the analysts to send their research to Thomson Financial for posting
Responsibilities:
**Headed a team consisting of 3 members and developed ASP web pages for the quantitative data section
**Responsible for Oracle 9i logical and physical databases design, implementation, and maintenance
**Written PL-SQL queries for the back end using Oracle9i
Environment: IIS/ASP, VBScript, ORACLE9i, Windows2000, Visual Source Safe, Team Size: 5
Virtual Finance Database (VFDB) and Entitlement Server 1.0, Client: Thomson Financial, NY, MD
Aug 01-Feb 03
Web-based editor (create/modify/delete) meant for Metadata (data about data) entry for the Virtual Finance database
Responsibilities:
**Designed the database and wrote Stored Procedures/Triggers using SQLServer2000 for job initiation module
**Reorganized databases and sized database objects to meet standards and improved performance by 30%
**Developed triggers for user permissions display and creation and deletion of users
Environment: IIS/ASP, VBScript, VC++ (COM), SQLServer2000, Windows2000, PVCS tracker, Team Size: 7
Global Access Production and Project Navigator, Client: Thomson Financial, MD
Jul 00-Jul 01
GA desktop application is the front end for document filing searches, fulfilment requests, print requests and downloads
Responsibilities:
**Involved in all phases of database development, from needs assessment to Quality Assurance/Quality Control, design, and support
**Managed internal databases, from planning and testing stages through implementation and support
**Involved in designing and implementing interfaces for the filings search and print request modules
**Added new database functions to list alerts on delays, missed deadlines, and cost problems for projects
**Acted as a liaison between end user for GAPRO and project offshore team to capture the requirements.
Environment: IIS/ASP, JavaScript, VBScript, SQLServer2000, Windows2000, Solaris, Team Size: 6
|
Skills: |
Computer Skills:
----------------
Application Languages:
C# 1.1 & 2.0, VB.NET, VB 6.0, C++
Web Languages:
ASP.NET 1.1 & 2.0, ASP, VBScript, JavaScript, XML, XML Schema, XSL, DHTML
Visual & Source Control Tools:
ERWIN, MS Visio, Query Analyzer, SQL Server Management Studio, Enterprise Manager, Visual Studio .NET 2003-2008, Rational Rose Suite, Team Foundation Server, Team Explorer, MS Visual Source Safe, PVCS Tracker
Databases:
SQL Server 2000/2005, Oracle9i/10g, MS Access
Operating Systems:
Windows 95/98/NT/2000/XP, Windows Server 2003, Linux (Ver 8.0 & 9.0)
Web Servers:
IIS 5.x, 6.0
Enterprise Applications:
MOSS 2007, Windows Sharepoint Services 3.0, Microsoft Sharepoint Portal Server 2003, Microsoft Content Management Server 2002, Solomon Dynamics 6.5
Reporting:
SQL Reporting Services 2005, Crystal Reports 10.0
Server Control Sets:
Infragistics NETAdvantage CLR 1 and CLR 2
Technologies:
Web Services, Web Handlers
|
Education: |
EDUCATION
==========
Master of Science (Computer Science & Engineering) , 2005, University of Texas at Arlington, USA, CGPA: 3.93
Bachelor of Technology (Electronics Engineering), 2000, Anna University, India, CGPA: 3.75
|
Endorsements
|
 |
Manikandan has received 1 endorsement.
|
Manikandan has endorsed 0 Members.
|
|
|
| |
Rank |
Title |
Location |
Status |
Actions |
|
9.873 |
Network Engineer |
US-Mississippi-Central |
 |
Details
|
|
|
|
|
|
|
|
