Data Sql Server

Venkatesh Aasoori Varadharajan

* ***** *******, ***** ******, NY 10601

********@*****.***, 469-***-****

ACADEMIC PROFILE

• Master of Science in Management Information Systems

The University of Texas at Dallas, GPA 3.89 May 2010

• Bachelor of Engineering in Electronics and Communication Engineering

Anna University, India, GPA 3.70 May 2007

PROFESSIONAL EXPERIENCE

ARGUS INFORMATION & ADVISORY SERVICES White Plains, NY June 2010 Onwards

Worked as an Analyst in the Data Operations Team and was responsible for delivering quality data from banks and report on their performance against the industry benchmarks. Roles and strengths include:

• Work with Financial Institutions and provide in-depth knowledge of the competitive environment by offering multiple studies that can assist financial institutions with understanding the context in which their customer management decisions are made.

• Opportunity to work with top banks in US, UK and Canada.

• Exposure to 95% of the US credit card market.

• Clients include Chase, AMEX, Citibank & Bank of America.

• Analyze more than 1 billion transactions of more than a 100 million accounts each month and validate the quality of data.

• Data Mining – Understand the data and provide supportive explanations to changes in the data.

• Excel in measuring the event loss rate and loan loss provisions – Track defaulters/charge off accounts and build models to predict future trends/losses.

COGNIZANT TECHNOLOGY SOLUTIONS Chennai, India June 2007 to July 2008

• Project in Cognizant Technology Solutions Academy - Developed a networking site where users can register themselves, add threads, post comments, view other users and their comments. This involved coding in Java, J2EE, JSP and XML.

• Project For Wal-Mart Inc. - Developed an application named Global Logistics System. The application was designed using Informix 4gl as the Database tool and Embedded SQL in C as the programming tool.

Analyzed the business process of Wal-Mart Warehouse Management System (WMS) and created menus and reports as per the client requirement.

Develop reports using Informix 4GL and SQL.

Sample reports include list of appointments for the day, list of trailers scheduled to arrive at any particular gate in a warehouse, list of shipments in each trailer and purchase orders and purchase lines in an appointment.

As a part of the Joint Application Development (JAD) Team, analyzed business processes of the client and provide solutions in the form of enhancements and upgrades.

Investigate Use Cases and create Design Specification Documents and User Interface documents.

As a part of the off-shore review and coding standards team, reviewed design documents and made sure the coding standards were followed as per the client requirements.

Performed DB Schema migration by changing the SQLs and the code in the existing system to correspond to the new Relational Database that was created. The process included changing of SQLs, running them in the new DB and analyze if they worked in accordance with the functional flow of the system.

MEDUSIND SOLUTIONS Chennai, India Jan 2007 to May 2007

• Dental One – Was part of the team that would process dental insurance claims for provides in America. Qualifications include knowledge of Current Procedural Terminology for dental practices and verification of patient coverage with insurance companies.

TECHNICAL SKILLS

Web-development : Java, J2EE, JSP, HTML, XML

Database Tools : SQL Server 2008, Informix 4gl, Embedded SQL in C

Data mining : SAS, Weka, XL-Miner

ERP Tools : SAP S&D

Programming : C, C++

Office tools : Word, PowerPoint, Visio, Excel

Operating Systems : Windows XP, Linux Fedora Core, UNIX

ACADEMIC PROJECTS

Business Intelligence Software:

• Import the data from any source into SAS/Weka software.

• Performed data processing using SAS and Weka. The process included identification of outliers and noises, filling missing values manually or by imputation and sorting/filtering data with respect to the business problem.

• Performed methods like feature selection to find the attributes that influence an output with a higher confidence so that data reduction is attained.

• Use the reduced data to build models using XL Miner and SAS Enterprise Miner.

• Mixed multiple models by Stacking, Boosting and Bagging and thereby predicting the outputs with higher accuracy.

• Analyzed the performance of models by comparing the testing data and training data by means of confusion matrix, lift curve and prediction accuracy.

Data Mining and Market Analysis:

• Used the clean data to group customers using methods such as K means clustering to form customer groups and analyze each group by comparing their spending pattern with the group characteristics.

• Performed Market Basket Analysis by means of Association rules and found purchasing patterns by customers. To provide a quantitative decision, parameters such as Support, Confidence and Lift were used.

• Developed a marketing scheme using models such as Neural Network, Naïve Bayes and Decision Tree so that maximum profit can be achieved by minimal expenditure towards the advertising campaign.

• Predict which customer is more probable to respond to an ad and how much would his dollar purchase would be.

• Analysis of recommendation algorithms to suggest customers about the products they might be interested in.

Report Generation

• Generated reports using MS Excel and SQL.

• Covert data in numbers into meaningful information for analysis.

Statistical Analysis:

• Analyzed mathematical problems and match them to a particular solution. The solutions included Poisson, Normal, Binomial, Exponential, Geometric and Uniform Distributions.

• Excellent understanding of what each distribution signifies, how they work and where they should be used.

• Gained knowledge on conditional probabilities and Bayes Rule to study related/dependent events.

• Solved problems on different types of probabilities such as Prior Probability, Conditional Probability, Joint Probability and Posterior Probability.

Retailer Database System:

Designed and implemented a database for the appointment scheduling process of a retailer using SQL Server 2008. Also created forms and menus to add, modify, delete and view reports.

System analysis and design:

Analysis and system design of a vendor similar to Wal-mart using system analysis methodologies such as Process Diagram, Sequence Diagram, Class Diagram and Data dictionary.

COURSES COMPLETED/TAKEN

- Advanced Business Intelligence - Information Technology Security

- Enterprise Resource Planning - Quantitative Introduction to Risk & Uncertainty in Business

- Business Data warehousing using SAP - Database Management Systems

- Object Oriented Systems - ERP : Sales & Distribution

ACHIVEMENTS

• Awarded School of Management’s Dean’s Excellence Scholarship at UTD.

• Awarded Gem of the Team in Wal-Mart project at Cognizant Technology Solutions.

OTHER SKILLS: Excellent skills set in Mathematics and analytically sound.

Contact this candidate