Sql Server Management

POOJITHA PASHAM

317-***-**** *************@*****.*** 857,Spiros Ct 103,DeKalb,IL 60115

PROFESSIONAL SUMMARY

Graduate student in Management and Information Systems with database management experience. An enthusiastic self-starter with strong leadership and communication skills. Possess the right technical and soft skills required to propel in an organization to achieve its goals and objectives.

EDUCATION

Northern Illinois University (NIU), DeKalb, IL Jan 2016-May2017

Master of Science in Management and Information Systems Final GPA: 3.7/4.0

Osmania University, Hyderabad, India August 2011-May2015

Bachelor of Engineering: Electronics and Communication Engineering Final GPA: 3.4/4.

TECHNICAL SKILLS

Database management systems: RDBMS, MySQL, MS SQL server, T-SQL

Programming and scripting languages: C, C++, C#, MATLAB, SQL,VBA

Web: HTML5, CSS3, Bootstrap

Business Tools: Microsoft Visio, SAP ERP, Visual Studio, Power BI, Tableau, Microsoft Excel, Microsoft Access, Microsoft Word, SSAS, Microsoft Outlook, MS SharePoint

PROFESSIONAL EXPERIENCE

Junior Business Consultant, Abbott, Experiential Learning Center, College of Business Jan2017-May2017

Worked with a team of six to improve product sales using Big Data.

Developed ideas related IoT to implement RFID from item level for efficient supply chain management.Also for warehouse management and we suggested the implementation of Samsung Artik Technology along with Amazon Kinesis.

Database Administrator-Intern, Open Ark InfoTech Pvt.Ltd, Hyderabad, India June2015-December2015

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Created star schema in SSAS and developed SSRS reports based on the cube.

Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS).

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non- production database code as well as T-SQL

Developed stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.

Involved in writing queries for Stored Procedures, clustered and non-clustered indexes.

Created List reports, cross tab reports, charts, sectional reports, & Drill through reports by using Report studio.

Intern, Defense Electronics Research Lab, Hyderabad, India: 3 months Jan 2015- March 2015

Designed and developed a Micro Strip Patch Antenna for GPS applications

Worked on High-Frequency Structural Simulator (HFSS) software to optimize the antenna.

Tested the antenna in anechoic chambers

ACADEMIC PROJECTS

NIU division of Information (DoIT) Microsoft Power BI: Analyzed DoIT dataset that had two fiscal years data and reduced total number of IT tickets throughout the University by applying the Business Intelligence and Business Analytics concepts which included in creating Power BI datasets and models.

System Analysis and Design Project: Developed applications using various technical platforms to help companies maintain and support those applications for the company’s growth.This involved using Context Level Diagrams, Structure Diagrams, Class Diagrams, Data Flow Diagrams, Use Cases and Process Flows.

Hotel Management Website: Designed a hotel management website using ASP.net which used c# as backend processing language.Also used Bootstrap,HTML,JSP,CSS and SQL server database for developing this website.

SAP BI: Designed and built reports on Public Datasets and analyzed the data and visualized the results in the form of charts that indicates the best information match.Supported my project team in reporting, querying and analysis applications.

Microsoft Business Intelligence: Handled large sets of data stored it in MS SQL Server Management Studio, loaded it into SSAS and implemented different MS SSAS and SSRS algorithms on the data. Developed OLAP cubes and used MDX query language. Loaded the organized data into MS Excel Power Pivot to analyze data in the cube

Database Management Systems: Critical examination of the design, implementation and management of database systems. Created relational database model, entity relationship modeling, normalization, distributed databases, object-oriented databases, client/server systems, data warehousing, database administration

CERTIFICATIONS:

Software Processes and Agile Practices-CourseEra Certifications

Certificate of Graduate Study in Business Analytics Using SAP Software

Contact this candidate