Sql Server Data

Balaji Kamalakannan

312-***-**** ***********@*****.***

Objective To seek a Dynamic and Challenging Position that would utilize my academic knowledge and technical skills effectively and provide opportunity to learn new and emerging trends in Business and Technology. Summary Recent graduate in Information Systems whose academic credentials are reinforced by hands-on programming experience. Strong understanding of Web Technologies, Object oriented programming and Databases. Known as a self-starter, team-player; strive to consistently meet expectations. Able to effectively coordinate tasks to accomplish projects.

Education Master of Science in Information Systems, GPA 3.6 Aug 2015 Col lege of Computing and Digital Media, DePaul University, Chicago, Illinois Bachelors of Engineering in Computer Science, GPA 3.2 Jun 2013 TJS Engineering College, TN, India

Coursework Software Engineering, System Analysis, Database Design, System Design, Implementation and Maintenance, Fundamentals of IT Project Management, Enterprise Systems, Computer Algorithms, Database Programming, Database Administration and Management, Mining Big Data, Data Analysis and Visualization in R, SAS Programming. Technical Skills

Languages: C, C++, C#, JAVA, .NET, SQL, PL/SQL, PROC-SQL, T-SQL, HTML, CSS, JSP, JavaScript, AngularJS, Hadoop, Hive, Pig Tools & IDE: Ecl ipse, Visual Studio, R Studio

SQL Server Tools: SSIS, SSRS, SSAS

DBMS: Oracle 11g, Mongo DB, MS SQL Server 2008

Software Applications: MS Office, MS Vi sio, SQL Developer ERP: Microsoft Dynamic AX CRM

Statistics Analysis Tools: SAS, R, MS Excel

Data Visualization Tools: Tableau

Operating Systems: Windows, Linux

Professional Experience

Calydon Tech, Chennai, India Aug 2012 - Nov 2013

Junior SQL Developer

Col laborated with the Developers in Data Modeling and E-R des ign of the Executive management and Accountability systems

Developed and Implemented web applications using HTML, JavaScript, ASP and SQL Server stored procedures.

Des igned and Developed Database Objects like Tables, Vi ews, synonyms, sequences, Indexes and other database objects, Packages, Stored Procedures, Functions, Analytical functions, Cursors and, Triggers.

Performed Database Normalization and De-normalization tasks to reduce redundancy and maintain accurate data.

Developed cursors and control structures using PL/SQL and Create views for the users according to their roles and granted access.

Created triggers to keep track of changes to the fields of tables when changes are made.

Created GUI Forms and Reports using Oracle Forms 9i and Oracle Reports 9i.

Written various T-SQL Statements for the purpose of application development and used SSRS to generate Reports. IT Certification

Certified Associate in Oracle 11g SQL Fundamentals - I (Candidate ID: OC1095312) May 2011 Academic Projects

Student Information System (Course Registration and Student Networking)

Stati stical Analysis on Social-Media Dataset

Data Analysis on Flight Dataset

Mining Big Data on Chicago City Crime Dataset

Inventory and Rental System for Video Store

POS System for Private Pharmacy

Contact this candidate