Sql Server Software Developer

PRIYANKA BIRAJDAR

**** ***** **** **** *, San Jose CA- 95111 669-***-**** ****************@*****.*** www.linkedin.com/in/priyanka-birajdar

SUMMARY

Around 3.5 years of experience as a Software Developer and Database Engineer in Manufacturing & IT domain.

Proven ability to leverage technology to improve business process with special expertise in requirement analysis and problem solving and in-depth experience in relational database like MS-SQL & Oracle.

Proficient in full project life cycle from software design, development and integration and efficient with analytics tools like visualization dashboards using Tableau.

Strong knowledge of Agile and Waterfall practices & proven team management and project management skills.

EDUCATION

Database & Data Analytics Program: University of California Santa Cruz Silicon Valley Extension - Santa Clara Jan 2017 - Current

Courses: Machine Learning and Data Mining Introduction, Python for Programmers, Dashboards and Data Visualization

Certification: Tableau for Beginners, The Complete SQL Bootcamp, Hadoop Starter Kit, Udemy 2017

Master of Science: Computer Applications, Symbiosis Institute of Computer Studies and Research - Pune, India 2012

Bachelor of Science: Computer Applications, MAEER's MITSOM College, Pune University – Pune, India 2010

TECHNICAL SKILLS

Databases

MS SQL Server, Oracle, MS Access, PostgreSQL

Programming Languages

Data Visualization Tool

ASP.Net, C#, Python, SQL, HTML, CSS, Unix Shell/Bash scripting

Tableau

Tools

SQL Server, Visual Basic, OEM 10g/12c, SharePoint, MS Office

Operating Systems

Windows, Linux, Mac OS X

PROFESSIONAL EXPERIENCE

Assistant Manager (Software Developer), Kirloskar Brothers Limited – Pune, India Aug 2012 - Apr 2015

●Co-ordinated with business clients & on-shore application teams for planning & execution during major releases and involved in migration of data in production environments.

●Developed and automated previously manual, time consuming processes to reduce inaccuracy in data tracking and thereby increasing workgroup efficiency by more than 40%.

●Developed and Implemented websites and applications using ASP.NET, HTML & CSS and maintained existing applications on web and intranet.

●Built databases and table structures following n-tier architecture methodology for web applications.

●Worked in 24*7 production environment and administered SQL Server production and non-production databases.

●Developed & modified database objects, triggers, functions & stored procedures for data conversions.

●Expertise in finding key information, business insights and making predictions on basis of it.

●Modified existing software to fix bugs, adapt to new hardware and improve performance.

●Performed system-level testing to verify software quality and function before release.

●Received Certificates of Excellence for exceptional work in various projects done.

Industrial Trainee (Software Developer Intern), Kirloskar Brothers Limited – Pune, India Jan 2012 - Jun 2012

●Developed & implemented Library Management System for inventory storage and maintenance, transaction summary and reports in C# and ASP.NET. Database maintained in SQL server.

●Consulted regularly with customers on project status, proposals and technical issues.

●Prepared detailed reports concerning project specifications and activities.

PROJECTS

●U.S. CO2 Emissions Report (2017) - Tableau based data visualization project dashboard of CO2 emissions by sector and state using scatter plot and Map of CO2 emissions. Structured the dashboard with a consistent layout with visuals chart at the top and corresponding crosstab data and the bottom

●Superstore Data Report (2017) - Organized dashboards in Tableau to analyze the Monthly Profit, Top Products and Top Customers as bar chart and line chart using calculations, parameters in Tableau. Also implemented Profit by region, sales by shipping mode, discounts by product and region category using line chart, stacked bar chart, box and whisker plots.

●Stock Predictor (2017) - Python based project to fetch historical stock data from yahoo-finance webpage, stored in CSV file and displayed in tabular format using Pandas. Project forecasts stock price using Linear Regression Model based on historical data. The program also presents data through graph using Matplotlib.

●Document Vault System (2015) - Developed a central online repository to upload and store all-important personal documents for each employee. Developed in SharePoint.

●Project Management Tool (2014) - Project to track and record documents and progress of projects of all departments in ASP.Net with C# and SQL Server database.

●e-Warranty Registration (2014) - Portal for customers to register product for warranty and for engineers to update their actions. Developed in ASP.Net with C# and SQL Server database.

●Economic Intelligence System (2013) - Repository of business related data maintained and used for market study to drive organization’s roadmap. Developed in ASP.Net with C# and SQL Server database.

●Helpdesk Application (2013) - Portal to record tickets from users and track progress until resolution. Added ability to create customized reports. Developed in ASP.Net with C# and SQL Server database.

●Employee management System (2012) - System for HR department to store various information related to employee. Developed in ASP.Net with C# and SQL Server database.

●Hotel Management System (2010) - Project integrating three modules of Lodging, Restaurant and Kitchen Inventory System. Developed in Java AWT & Swings (client side) and Oracle.

Contact this candidate