SHREY MEHTA
PROGRAMMER ANALYST
***** ********, ***#***, *******, TX 77041
PH:917-***-****, E-mail: *************@*****.***
SUMMARY
Bachelor’s degree (currently, pursuing master degree) in computer engineering.
Prior working experience in database management, software engineering, programming, coding and development of applications, supporting vendors, trouble shooting, and networking protocols.
Familiar with object oriented analysis, design, and various stages of software development life cycle (SDLC).
Eager, quick learner with strong team-work spirit, and excellent oral and written communication skills.
Green card holder; not require any immigration benefits.
EDUCATION
Master in Management Information Systems (MIS), University of Houston, Texas Aug 2014 – Cont.
Bachelor in Computer Engineering, Gujarat Technological University, India Aug 2010 - July 2014
WORK PROJECTS
Tax Filling Application – TruSmart Energy
Developed an application that provide files to directly upload inside the Tax software provided by state. These files are generated by counties and amount of tax on each county depending in customer count. So, Finance department does not have to manually enter the number in the software. C#, ASP.Net, MVC, SQL Server, SSIS Packages, Entity Framework were used.
ESIID Extraction – TruSmart Energy
Developed an application for CSR and Marketing team to locate the load zone by zip code by downloading each and everyday data from ERCOT and then comparing it against existing customer and provide different reports to help them out and concentrate on different zip code with new ESIIDs added to it recently. C#, ASP.Net, MVC, SQL Server, SSIS Packages, Entity Framework were used.
Risk System – TruSmart Energy
Developed an application for Risk Department about giving exact numbers for load forecasting and weather forecasting to buy the energy for next day and forecasting whole month. This will help risk officers to buy at cheaper price and sell it to customers on higher note to make profit margin. C#, ASP.Net, MVC, SQL Server, Entity Framework, AJAX, Angular JS, SSIS Packages were used. Used Angular JS to create better response time and load content effectively.
In-House Billing Checking and Customer Information – TruSmart Energy
Developed an application for Operation department to check bills before approving them based on formula provided, so customer did not get incorrect bill and there is less time on queue for customer complaint. Also, provided up-to-date data for customer account on internal website so if billing system working slowly, will not affect CSR to serve customers. VB.Net, ASP.Net, SQL Server, SSIS Packages were used.
EFL (Electricity Facts Label) Generator – TruSmart Energy
Developed an application for generating PDF version of EFL from input given by user and it will generate 2 pdfs in Spanish and English. This application will remove all the manual updating and converting from this process. C#, ASP.Net, SQL Server, SSRS Reporting Tool, LINQ were used.
Managing and updating Company website – TruSmart Energy
Maintained and updated company website, created new pages and updated existing one as required. Also, worked on creating and updating PHP scripts using Dot Net Nuke CMS.
Auction management system (Website and Database Management) – SD DESIGN
Developed time based system for bidding purposes. This system is real time auctioning for an auctioning company. Java (programming language), MS SQL (database), and JDBC (web server) were used.
Attendance Management System with Report Generation (Application Development) – SD DESIGN
Created application which include the client and server modules. It was helpful for generating record of attendance for employees and students for large companies and educational institutes. Java (programming language), MS SQL (database), and Adobe Reader (report generation) were used. Have used Angular JS to load big data and charts more efficiently.
Automobile Website (Website) – SD DESIGN
Developed an Automobile website using ASP.Net, C#, MVC, JavaScript, AJAX, Angular JS, CSS, HTML and Bootstrap.
EXPERIENCE
Sr. Programmer Analyst - TruSmart Energy, Houston, Texas Jan.2015 - Cont.
Developed and updated applications using ASP.Net, MVC, C#, JavaScript, Angular JS, AJAX PHP and deployed it using IIS server.
Worked with SSIS Packages to run Applications and daily jobs scheduling and SSRS to generate Reporting using reporting tools like Crystal Reports and Tableau to find the cash flow and product performance.
Developed Credit Model to calculate credit score for customer using XML, Web API, Angular JS, AJAX and C# also developed internal websites for getting data for customers and view reports using Entity Framework and LINQ to SQL in C#.
Developed Stored Procedures, views and queries for generating reports also published reports to internal website.
Software Engineer - SD DESIGN, INDIA Jan.2013 - June.2014
Worked in website development; using CSS3/HTML5/XHTML/JAVASCRIPT/XML/JSON/Web Services & API /Angular JS/ jQuery Style sheet and Markup Languages and has knowledge of SAML, Active Directory and LDAP.
Provided technical supports to clients, and documented the development of code changes.
Experienced with SEO (Search Engine Optimization) principles and very good in understanding designing.
Assisted into many User Interface (UI) designs and building User Experience (UX) strategies.
TECHNICAL SKILLS
Programming/Languages: C#, ASP.NET, MVC, VB.NET, Java, Angular JS, AJAX, C, PHP, C++
Relational Databases: SQL Server (2008 R2/2012/2014), Oracle (8/9/10/11g), MS Access
Design Tools: UML, Dreamweaver, Photoshop, Fireworks, Illustrators, Visio
Office Tools: MS Word, PowerPoint, Excel, Outlook
Reporting tools: Crystal Reports, Tableau