Pooja Verma

*** * **** ******, ******* IL, *****

872-***-**** ac4vzf@r.postjobfree.com

EDUCATION

DeVry University Chicago, Illinois

BS Computer Information Systems May 2017

• GPA: 3.5/4.0

WORK EXPERIENCE

Kairosteq Chicago, Illinois

BI Application Developer/ SSRS Developer May 2017 – Current

• Create SSIS Packages to fetch data from BI platform with zip folders with unique portfolio IDs

• Participate in daily meeting and provide status on reports and SharePoint deployment

• Design reports using SQL Server Reporting Services (SSRS) and identify the database tables for defining the queries and datasets for report generation

• Write complex PL SQL and SQL queries used by SSRS Reports

• Gather business requirements and translate them into technical specifications

• Create data quality audit reports to assist performance team with daily workflow

• Resolve defects raised by testing team and discuss scope of report

• Use Erwin to develop logical and physical database models

• Create and manage schema objects such as tables, views, and indexes Ajastra Media Noida, India

SQL BI Intern/ QA Analyst April 2013 – December 2014

• Partitioned table and indexes for performance improvement and manageability

• Identified, tested, and resolved database performance issues through monitoring and tuning to ensure database optimization

• Generated SSRS reports to send data to primary vendors, clients, and managers

• Collaborated with offshore team to help them better understand functional requirements and execute test cases

• Analyzed, tested, and logged defects on HP Quality Centre SKILLS, COURSES, & PROJECTS

• TECHNICAL SKILLS:

General: Microsoft Office Suite

Databases: SQL Server, Teradata, Oracle, DB2, Access

Business Intelligence Tools: SAS, MS SQL Server Management Studio (SSRS, SSIS, SSAS), Tableau, SQL Server Agent, MS Import/Export Wizard, Visual Studio

Front End Tools: MS VISIO, MS Project, MS Office Suite (Word, Excel, PowerPoint), TOAD, JIRA, HP Quality Centre, MS Visio, XML Reader

Document Management Tools: SharePoint, Documentum, Ultra Edit, Visual Source Surface

Defect Management Tools: HP Quality Center, Test Director, SharePoint

Methodologies: Kimball/Inmon Data Modeling, Star/Snow Flake Schema, Waterfall, Agile

Scripting Languages: SQL, PLSQL, OLTP, TSQL, XML, C#, VB, ASP, .NET, HTML

• COURSES: Web Development, Logic and Design, Architecture and Operating Systems Information Systems Security, Structured Analysis and Design, Business Applications Programming, Data Administration, Data Privacy and Security, Database Management

• PROJECTS:

Senior Computer Information System Project:

Integral part of five-member team that created a hotel reservation system that enabled customers to book hotels and cars on holidays

Analyzed functional requirements, developed code, and tested and created complex SQL queries

Web Designing Course Project:

Designed and developed server database applications

Maintained and updated HTML/CSS templates

Assisted in planning and implementing dynamic and online electronic commerce applications

Conducted layout design and construct for website

Facilitated and lead team to complete and present final website product

Contact this candidate