C# .NET, Python, MS SQL Server, Oracle 10g

ANUPRASAD TE

937-***-**** ac3z3f@r.postjobfree.com https://www.linkedin.com/in/anuprasadte

SUMMARY

Over 3+ years of professional experience as Software Developer, along with Masters in Computer Science. A quick learner with excellent logical, analytical skills to solve complex problems and with good knowledge of Data Structures.

Experience in Windows application development using WinForms and WPF and Web application development using ASP.NET, HTML, CSS, JavaScript, and Angular JS. Experience with MVVM and MVC architectures. Web deployment of applications using Internet Information Services(IIS) package.

Expertise in designing, creating, and maintaining database in MS SQL Server, MySQL, and Oracle 10g. Experience creating ad-hoc queries, Stored Procedures, Views, Triggers etc. and perform query optimization and performance tuning.

Experience with scripting languages like Python and Perl. Experience with object-oriented Python. Worked with the Unix Shell Scripting.

Experience with Big data, Apache Hadoop, AWS. Experience with Pig Latin, Apache Spark, and executing job in Map Reduce.

Have good knowledge of software testing and I am a ISTQB certified tester.

EDUCATION AND SKILL SET

Wright State University, Dayton, Ohio Aug 2015 – Apr 2017

Master of Science in Computer Science GPA 3.9/4.0

Visvesvaraya technological university, Karnataka, India June 2007 – July 2011

Bachelor of Engineering in Electronics and Communication CGPA 8.91/10

Programming Languages:

C, C++, C#, Python, Perl, SQL, HTML, XAML, XML, CSS, JavaScript, Angular JS, Shell Scripting, Scheme

RDBMS:

MS SQL Server 2008 R2,2012,2014, Oracle 10g, 11g, 12c, MySQL, T-SQL

Tools and Technologies:

.NET Framework (ASP.NET, ADO.NET, WPF, WCF, WinForms, Design Patterns), MVVM and MVC Architecture,

Visual Studio 2010,2013,2015, Agile Method – Scrum Process, JIRA, MS SQL Server Management Studio, TFS, GIT, Apache Web Server, Hadoop, AWS, Pig, Spark, Putty, QTP Automation Testing tool, Microsoft Office, HP-ALM.

Operating Systems:

Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

I.Peri Software Solutions, Newark, NJ

Project: Wholesale Distribution System Role: Intern

Development of trading and reporting modules in C#. Creation of Database using Oracle 10g. Used ADO.NET and for database interaction.

Report generation using Python, extensively worked with Pandas, Numpy, Scipy, and regex. Database interaction using CX_oracle interface module.

Automated the batch processing of daily reports and database logs using Unix commands. Scheduled jobs using Crontab and at.

Technologies: C#, Python, Oracle 10g, SQL, PL/SQL, Unix Shell.

II. TATA Consultancy Services, Bangalore, India

Project: Employee Timesheet Management Tool Role: Developer and Module Lead Client: Mitsubishi Hitachi Power Systems

Proposed a solution as to how client could keep track of the number of hours the employees are spending for every project. Involved in architecting the web application and its database. Followed Agile-Scrum methodology, MVC architecture and chose MS SQL Server for database.

Developed the views in HTML, CSS, and JavaScript. Created WCF services to get employee office login details from the main application and the employee’s active hours from an application running on individual computer. Implemented controllers in C# and models in C# ADO.NET for database interaction.

Initially loaded employee data using SQL Loader and Import/Export utility. Created Ad-hoc queries, Stored procedures, triggers, LINQ’s, and views to interact with the database. Performed database tuning and query optimization. Generated periodic reports using SQL Server Report Services(SSRS).

Used TFS for version control. Took part in integration and deployment on the client server using IIS. Created test case document and User manual.

Technologies: C#, ADO.NET, MVC3, LINQ, HTML, CSS, JavaScript, MS SQL Server 2012, SQL Server Management Studio, TFS, IIS, SSRS, Visual Studio 2013.

III. TATA Consultancy Services, Bangalore, India

Project: Steam Turbine Design and Analysis Role: Developer Client: Mitsubishi Hitachi Power Systems

Took part in requirement analysis, designing the application which reduces the time for designing a steam turbine by 50%. Adopted Waterfall methodology. Followed MVVM architecture and used WPF for building user interface. Created database in MS SQL Server.

Created user friendly views in XAML. View-Models in C# and Models in C# ADO.NET. Developed logic to interact with MS-Excel. Created input files and logic for FORTRAN server interaction and parsed the output files generated. Also developed Visual C++ scripts to automate the validation of steam turbine design.

Involved in creating ER models and construction of database tables in SQL Server. Created SQL queries, Stored procedures, views, triggers, LINQs.

Created a CHM file user manual. Provided maintenance and production support. Received 100% customer satisfaction and ‘Best Delivery Award of the year’.

Technologies: C#, Visual C++, ADO.NET, WPF, MVVM, LINQ, XAML, MS SQL Server 2008 R2, SQL, TFS, MS SQL Management Studio, Visual Studio 2010, MS Excel.

IV. TATA Consultancy Services, Bangalore, India

Project: Automation Testing Using QTP Role: Test Automation Engineer Client: PNC Bank

Developed VB.NET scripts to capture and validate controls in web pages built on Siebel platform. Verified using QTP record and replay.

Involved in integration of scripts in ALM. Scheduled their execution and tested for their correctness.

Technologies: Visual Basic, Siebel platform, Quick Test Professional (QTP), Application Lifecycle management(HP-ALM).

ACADEMIC PROJECTS

Web Application Development (C#, HTML, MySQL, ASP.NET, ADO.NET, MySQL, Visual Studio 2015, IIS)

Developed a web application for Online Hotel Booking. Which uses HTML, MySQL database and business logic in C#. Hosted the application using IIS package.

Implementation of Gale-Shapley algorithm in C#

Program generates random matches between man and woman and check for stable matching problem between them.

Relational Data Analysis using Pig and PySpark

Developed a program using Spark Python API and Pig to analyze and solve analytical problems for a set of linked tables.

MapReduce Programming to implement K-Means using Python and Hadoop

Python program to find cluster label for data point with current centroids. Recalculate the centroids on updated cluster labels with the data stored in HDFS.

Monitoring Amazon EC2 instances and S3 buckets using Python (BOTO3, Paramiko)

Developed a script to create Amazon EC2 instances and S3 buckets, check their contents. Monitored the CPU usage of instances at regular interval of time.

Geometric Data Perturbation(GDP) using Python

Implementation of GDP algorithm for privacy preserving of outsourced computation and Crypto-index for range query processing.

Contact this candidate