Sr SAS Developer & Analyst
Resume:
Vineet Nanda
Tulare, CA **274
Email: ***********@*****.***
Academic Qualification
1. MSIS (Master of Science in Information System) from Dakota State University, Madison, South Dakota USA Specialization: Advanced Databases
Date degree conferred: 8/26/2005
2. MASE (Masters Diploma in Application Software Engineering) from Uptron ACL, India
3. B.S (Bachelor degree in Science) from Punjab University, India
4. B.Ed (Bachelor degree in Education) from Guru Nanak Dev University, India
Certifications
1. SCJP (Sun Microsystems Certified Java 2 Programmer)
2. MCSE (Microsoft Certified Systems Engineer)
Exams passed: Networking Essentials, Windows NT 4.0 Server, Windows NT 4.0 Workstation, Windows NT 4.0 Server Enterprise, TCP/IP, IIS (Internet Information Server)
3. MCP (Microsoft Certified Professional)
Exam passed: Windows 2000 Professional
Technical Skills
ERP Banner from SunGard, Microsoft Dynamics GP 10
CRM Microsoft Dynamics CRM, Business Portal on SharePoint Sever
Operating Systems Windows NT Server and Workstation 4.0, Windows 2000, 2003, 2008 Active Directory, Windows 98, XP, UNIX, MS-DOS 6.22.
System Programming WMI (Windows Management Instrumentation) scripting, Active Directory Service Interfaces (ADSI) Scripting, UNIX shell scripting
Virtualization Microsoft Virtual Server 2005
Databases Oracle 10g development, MS-Access 2003-2007, MS SQL Server 2005/2008 administration and development, SSIS, SSAS, SSRS
Application Development Languages Sun Java 2,C, C++, C#, COBOL, Visual Basic, Access VBA, Visual Studio .Net
Business Objects Reporting tools Crystal Reports XI, Xcelcius 2008, Web Intelligence
Internet Programming Sun Java 2, AWT, Swings, Servlets, RMI, Java Beans, JDBC, Networking in Java, HTML, JSP, DHTML, CSS, XML, JavaScript, VBScript, ASP, RMI (Remote Method Invocation)
Web Designing Tools MS FrontPage 2003, Dreamweaver CS3
Project Management MS Project 2007
MS Office Suite Word, Excel, PowerPoint, Access, Outlook, Publisher
System Designing Case Tools UML Modeling using Rational Rose and Visio
Professional Experience
ERP System Administrator/DBA at Cervélo Cycles Inc., Toronto, ON since February 15th 2010 for a contract position. Cervélo is the world’s largest manufacturer of time trial and triathlon bikes. Cervélo is the winner of 2010 Manufacturer of the year award in Canada.
Job description:
1. Maintain and support Microsoft Dynamics GP and Dynamics CRM application suite and related software modules, SQL Server Databases, warehouses and BI solutions. Perform the various functions related to database management and administration; interfacing with users in-house and overseas for implementation or problem resolution; and the routine upgrade, maintenance, performance monitoring, security, backup and recovery, etc of all related applications and data sources.
2. Develop and implement technical database solutions enhancements, special data loads or modifications, SSIS, SSRS, SSAS, crystal reports, analyses cubes etc, by system users.
3. Schedule and prioritize all development, support and maintenance work to accommodate technical and functional needs while minimizing impact on current production systems and projects.
4. Manage all upgrades and enhancements; suggest further areas for improvement as applicable.
5. Negotiate service level agreements with both internal and external customers and service providers and monitor service delivery to ensure the agreed targets and standards are met.
6. Research, evaluate and recommend new technologies to enhance the GP/SQL applications and databases.
7. Plan, coordinate and implement security measures to safeguard information in computer files against accidental and unauthorized damage, modification or disclosure.
8. Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems, such as the installation of new databases,
System Analyst/DBA/Developer at Torian Group Inc. Visalia, CA, USA from May 2003 to October 2009.
Job description:
1. Analyzing, designing, programming, testing, tuning, implementing, customer databases and maintaining an assigned set of computer application systems
2. Documenting enterprise data structures, application software solutions, meta data, and processes to support application migration, on-going development, and end-user reporting
3. Writing scripts, programs, and database objects for database administration functions
4. Fine tune the indexes, views, create stored procedures, triggers and user defined functions for various projects in SQL Server Management Studio
5. Administer the services associated with SQL Server, configure the network protocols used by SQL Server, and manage the network connectivity configuration from SQL Server client computers using SQL Server Configuration Manager.
6. Scheduled jobs and alerts using SQL Server Agent.
7. Used DTS (Data Transformation Services) and SSIS (SQL Server Integrated Services) extensively to design highly automated ETL routines to import data from multiple sources into SQL Server.
8. Set security policy and permissions for the users.
9. Use advanced analytical techniques and analytical methods, such as structured system, data and mathematical modeling tools, and information technology, to assist and resolve client systems and technology problems.
10. Diagnose applications and/or systems network problems, recommend solutions, and determine if program requirements have been met. Implement and evaluate applications training program for clients
11. Managed Microsoft licensing, Microsoft financing for the clients, TechNets and MSDNs, benefits and training programs, competencies and Gold Certified Partner program for Torian Group Inc.
IT Advanced Analyst at Pima Community College, Tucson, AZ , USA from February 2008 to August 2008. Extensively used TOAD (Tool for Oracle development) for their ERP system called ‘Banner’ and Crystal Reports as a reporting tool. Worked remotely for Torian Group during this period.
Job description
1. Analyzing, designing, programming, testing, tuning, implementing, customer consultation and maintaining an assigned set of computer application systems
2. Documenting enterprise data structures, application software solutions, meta data, and processes to support application migration, on-going development, and end-user reporting
3. Writing scripts, programs, and database objects for database administration functions
Work with professional development department to provide training to technical services, development services, web services, new hires and other staff.
Projects
Following are some of the projects I managed and successfully completed while working at Cervelo Cycles Inc.:
1. Dynamics GP ERP System migration from SQL SERVER 2005 to new SQL Server 2008 server which includes planning, installing, testing and implementing. Manage the migration of GP users to the new Terminal server.
2. Customized Microsoft Dynamics CRM Forms and transferred customer data from Dynamics GP to Dynamics CRM.
3. Develop alert systems in SQL databases for example: Alert for over receipt in Purchase order Processing, alert for trade discounts, etc
4. Develop procedure for automatic updates from Dealer portal to Dynamics GP databases.
5. Transferred about 2500 parts from one company database to another company database tables with different GL accounts in Dynamics GP.
6. Develop application for Sales Order Processing for automatically update the requested ship dates.
7. Daily support tasks in Dynamics GP and Dynamics CRM.
8. Currently working on the project for merging company databases which includes Customers, Account Receivables, inventory and other modules.
Following are some of the projects I managed and successfully completed while working at Torian Group:
1. Lobue Brothers, Inc. - Fruit processing and packaging company
a. Removed Access locking from the existing database. Created DBLinks from SQL Server 2005 to Access. Maintain their database on MS SQL server 2005 using T-SQL and VBA coding.
b. Create on demand reports based on SQL Server views and stored procedures. Setup backup schedule. Ongoing administration of their SQL Server.
2. Jack Griggs Inc. – Propane and Gasoline company
Administer company’s SQL Server for backup, recovery, performance tuning. Maintain their Routing database on SQL Server 2005. Created DTS package to import MAS900 data to Routing database nightly. Create crystal reports for MAS 900 database.
3. University of California, Davis: Kearney Research and Extension Center, Parlier, CA
a. Developed the Key Management Database
b. Developed the Labor Program database
c. Skills, methodology, and techniques used in the project: MS Source Safe, MS Project 2003, UML Modeling, (SDLC) System Development Life Cycle, Programming in Access VBA and SQL Server 2000, Relational database development, and documentation.
d. Created project plan, project reports, Wrote problem statement and proposed a solution. Designed use case diagrams, set deliverables. Analyze, design and develop the system. Documented the completed project.
4. Torian Group Inc.- This is an in-house project. I developed Content Management System in SQL Server and VB which provides the information about vendors and clients of Torian Group Inc. The system also generates newsletters for the clients every month based on their invoicing.
5. System Programming for Fresno County Office of Education - CyberHigh program - Cyber High program is designed to allow classroom work over the web for high school students, particularly migrant students. Wrote WMI (Windows Management Instrumentation) script for their server upgrade to Windows 2003. Scripting does the following:
a. Creates over 200 domain users picked from the database, in Active Directory along with their passwords and properties set. Assign permissions to user to limit access to domain resources
b. Creates individual virtual web directories for all the users, with Basic Authentication and other properties.
c. Creates FTP folders for all the users with Inheritance set to off and with other user rights and permissions.
d. Skills, methodology, and techniques used in the project: MS Source Safe, MS Project 2003, Cost and Risk Analysis, Programming in WMI, ADSI, Networking (Active Directory and IIS-Internet Information Server), and documentation
e. Created the same virtual test environment as Fresno County Office of Education using Microsoft Virtual Server 2003, used object oriented approach for programming.
6. Visalia Chamber of Commerce: For website www.visaliachamber.org developed member login and password page. Successfully created automatic generation of username and password for new member, automatic logo upload for the businesses, and other updates.
Skills, methodology, and techniques used in the project: ASP, JavaScript, SQL Server 2005.
7. American Cowboy Team Roping Association (ACTRA): Developed membership database. Wrote a script to automatically compile the application, create FTP session and update the application on their website at every midnight. Changed the DNS settings to move the website to a different host.
a. Skills, methodology, and techniques used in the project: MS Source Safe, MS Project 2003, Use Cases, Access 2003 VBA, DBLinks in different Access databases. Visual Basic Programming, Networking (DNS – Domain Name Server, FTP – File Transfer Protocol)
b. Create project plan, define problem statement, proposed a solution, and designed use case diagrams, set deliverables. Designed and developed membership database and supporting databases. Created the membership page on www.actra.org, password protected the page. Wrote VBScript and batch files to automatically update the website with the compiled database every night. Documented the completed project.
8. Develop and maintain website for Fresno County Office of Education – PASS Program/Cyberhigh, www.capassprogram.org . This website is developed in Dreamweaver CS3 and HTML pages are entirely based on CSS. Currently working on building their new content based website using DOTNETNUKE.
9. Pipkin Detective Agency: Created fillable PDF forms for their website. Modified the XML coding in Acrobat for ‘Submit to Email’ button for sending filled PDF form via email to the recipient.
Following are the projects I managed and successfully completed while working at Pima College:
1. Successfully completed JTED (Joint Technological Education District) and Pima Community College interface in Oracle 10g and UNIX platform, frontend Java.
Skills, methodology, and techniques used in the project: MS-Project for project planning, PL/SQL for Oracle 10g, UNIX shell scrcipting for scheduling the job, calling PL/SQL and uploading the csv generated by PL/SQL code to JTED’s FTP server.
2. District Recruitment Online project in Oracle and APEX.
3. Fixed the bookstore channel on Luminis based Web portal. Created required functions and procedure in Oracle 10g using TOAD editor (Tool for Oracle Application Development by Quest Software).
4. Converted few Oracle reports to Crystal Reports.
5. Traced and fixed Time Sheet view for one of the HR supervisors and few other projects for HR
Completed training on Business Object tools like creating Universe R3, Xcelsius, Infoview, and creating Web Intelligence reports from Universe based on Oracle database.
Academic Experience
Computer Information Systems Instructor at West Hills Community College Lemoore, CA, USA from February 2001 to May 2003
Job description: Teach Java, Microsoft Certified System Engineer (MCSE), database development and administration, C++, VB, SSAD and web development.
Contact this candidate