Data Analyst

BI ANALYST

PRAGNYA GENGITY *********@*****.***

+1-603-***-****

Tampa, FL

www.linkedin.com/in/pragnyaG

https://github.com/PragnyaG

EDUCATION

Fitchburg State University

Master’s in Computer Science

JNTU

Bachelor’s in Electronics & Communications

SUMMARY

A Computer Science Graduate around 2 years of IT experience as Business Intelligence Analyst, SQL Developer with a proven track record in business analysis, system analysis, requirements gathering, risk management, data management & modelling, and project coordination. Excellent communication and interpersonal skills with strong relationship building, analytical, team building, problem-solving and organizational abilities. PROGRAMMING: C, C++, JAVA, R, Python, UNIX shell

FRONT-END:: HTML5, CSS3, JavaScript, JQuery

TOOLS: MATLAB, Xilinx, NetBeans, Eclipse, Visual Studio 2010/2015, Autosys DATABASE: SQL, MySQL, Oracle, PL/SQL

REPORTING: Power BI, Tableau, SSRS, Excel

OTHER: VHDL, Micro Controller (ATMEL,8051) Programming VERSION CONTROL: Git

SKILLS

EMPLOYMENT

CITI GROUP BI ANALYST Tampa, FL

Oracle PL\SQL, UNIX, Power BI Oct. 2018 to Current

• Working on multiple data requests from various users using SQL queries, based on the criteria provided by them.

• Extracting the input data from csv, excel, text, SQL database and created reports based on their requirement using Power BI.

• Responsible to monitor the performance of daily/monthly batch jobs and optimize SQL queries for maximum efficiency.

• Created views, Stored Procedures in order to send out the user data to multiple applications through outbound SQL batch jobs.

• Handling production release work and implementing the same through RLM for .NET and JAVA services and Database changes as well.

• Understanding of log files, modifying the Stored Procedures in order to minimize the execution time to extract the user data.

• Participating closely with the end users / business analysts to gather the requirements of the project and was responsible for the delivery of technical design document and implementation. QUADRANT RESOURCES LLC BI ANALYST Seattle, WA

SQL, Excel, Power BI. Aug. 2018 to Oct. 2018

• Design and develop Power BI reports, dashboard and data models to support Data Analysis engineering team operations.

• Perform detailed analysis of source systems and source system data and model that data.

• Design, develop, and test scripts to import data from source systems and dashboards to meet customer requirements.

• Design, create and tune physical database objects (tables, views, indexes) to support logical and dimensional models.

• Creating various reports like scorecards, KPI reports & dashboards. QUADRANT RESOURCES LLC BI ANALYST Seattle,WA

JavaScript, Python, SQL, Power BI Jan. 2018 to May 2018

• Design and develop technical solutions using HTML, JavaScript, CSS, jQuery, python and SQL Server databases for Finance budgeting and forecasting project for forecast finance budgets.

• Development of front-end web screens and implementing client-side validations.

• Participating in meetings with end users in analyzing and designing client's requirements.

• Building enhancements (including new product features) and resolve bugs.

• Performing unit and integration testing.

• Created reports as per the requirement using Excel and Power BI. LENORA IT SOLUTIONS SQL DEVELOPER India

HTML5, CSS, JavaScript, SQL. Jan. 2016 to June 2016

• Built Rich Prototypes and Applications using HTML5, CSS3, JavaScript, Pseudo Classes, Pseudo Elements and CSS Behaviors in CSS.

• Participated in system analysis and data modeling, which included T-SQL queries, creating tables, views, triggers, functions, procedures.

• Worked with testing team to fix the reported bugs and defects.

• Experience in working with Version Control System like Git. PROJECTS

HANGMAN GAME PYTHON, HTML 5, CSS, JAVASCRIPT(JQUERY), MYSQL Developed a classic hangman game of guessing words using python(back-end) and HTML 5, CSS, JavaScript, jQuery (front-end) for web designing. Different time limit was set for corresponding difficulty level, hint for each word that needs to be guesses by the player and also saving few words to database. DREAM SCOOPS PORTAL PYTHON, HTML 5, CSS, JAVASCRIPT(JQUERY), SQL Built an E-Commerce web-application for Ice Creams using Python, HTML 5, CSS, JavaScript, jQuery, SQL. In this Project, I have learned to save and import data from SQL, Styling the HTML page using CSS and validation forms using JavaScript and also added few features like Online Ordering, Live Tracking, Reviews. ONLINE CHESS PORTAL PHP, HTML 5, CSS, JAVASCRIPT(JQUERY), MYSQL Developed an online chess game using PHP(Server-side), HTML, CSS, Bootstrap, jQuery. In this Project, I learned to develop a user-friendly chess game web application using HTML and CSS for basic game design, Responsive Web Design using Bootstrap, Validations using JavaScript and used jQuery plugins for integration. GLOBAL POSITIONING SYSTEM TRAJECTORIES DATA SCIENCE The interaction between human activity and landscape pattern is analyzed. From this project, I have learned to classify the data of a particular vehicle during different conditions, performed map matching between raw GPS and trajectories. Using a correlation analysis, the interaction between human activity and landscape is determined. MICRO CONTROLLER BASED AUTOMATIC ENGINE LOCKING SYSTEM FOR DRUNK & DRIVE EMBEDDED C Developed an embedded system which detects the alcohol content. Connected the hardware circuitry consisting of a microcontroller, alcohol detection sensor, buzzer, regulator, bridge rectifier. Developed a software program for Atmega8 controller using Xilinx. Debugged the entire equipment for errors and testing the model.

Contact this candidate