Candidates About

                                                                        

  Swetha Nagireddy

                                                      

 

PROFILE

 

Hands-on experience creating Business Objects Reports, developing and designing Qlikview & Tableau dashboards. Has extensive skills in Data warehouse Design, Data Mapping and worked in AGILE methodology coordinating with geographically distributed teams in NAM, EMEA and APAC regions. Strong understanding of Dimensional Modeling technique, Multi-Dimensional Database Schemas like Star, Snowflake Schemas. Expertise in ETL (Data Extraction, Transformation & Loading), Data modelling, Report designing and Performance Tuning using QlikView. Proficient in creating QV data models, QV objects, reports, graphical interactive UI and dashboard using different data sources like Oracle, SQL Server, QVD files, Access, text files, excel documents etc. as per the user requirement.

 

 

CORE COMPETENCIES

•          QlikView /QlikSense                                                                

•          Data Analysis

•          Advanced MS Excel

•          Software Development

•          Tableau

•          Project Management                                                                 

 

 

 

 

TECHNICAL SKILLS

Databases	Oracle 11g, Oracle 10g,Oracle 9i, Oracle 8i
Operating systems	UNIX, Linux, Sun Solaris 5.8/5.6, Windows Vista/XP/NT/2000/98
Utilities	SQL*Loader, Export / Import, RMAN, AWR
Languages	SQL, PL/SQL, Shell Programming, C
Tools	Putty, SQL Developer, SQL Plus, TOAD 8.5/9.0, SQL*Loader, Oracle Enterprise Manager, Qlikview, Tableau.
Languages	SQL, PL/SQL, C, Unix Shell Scripting (Bourne, Korn)

 

 

 

PROFESSIONAL EXPERIENCE

 

 

Infozone Intelligence, Research Triangle Park, NC                                                       2015 – Current

Business Analyst/Qlikview Developer

 

Responsibilities:

 

·         Interacted with Business Users and gathered report specifications as well as business process to deliver better robust reporting solutions on day to day basis.

·         Participated in the design, development, deployment and production support of reporting solutions that meet requirements of business users. This includes documenting the processes to ensure standards and compliance

·         Participated in project planning, documentation, budgeting, and requirement analysis.

·         Applied Scrum methodology in the system development process.

·         Designed and developed QlikView software applications and server-based QlikView dashboards from scratch to support BI initiatives.

·         Worked with business clients about business logic and for validation of data.

·         Identified data sources and targets for data modeling and solution architecture..

·         Worked closely with the development team to understand functionality, resolve issues and provided feedback for the UML diagrams.

·         Extracted data from multiple complex hierarchies from cross table flat files and websites.

Tools:  Qlikview 11

 

 

GlaxoSmith Kline, Research Triangle Park, NC                                                       2014 – 2015

Business Analyst (Americas TS: Strategy & Business Planning)

 

Responsibilities:

 

·         Responsible for analyzing the Business Process and database and developing applications using QlikView.

·         Develop and implement data model for the required application.

·         Designed sophisticated reports as per the necessary Key Measures, Key Performance

·         Indicators(KPIs), Dimensions, Trends and Selection filters

·         Develop dashboards to view the summarized data.

·         Developed complex QlikView Dashboards from scratch using different Chart types (Drill Down, Cyclic Groups, and Fast change) as per the client and business requirement.

·         Developed QlikView Dashboards using Various Chart types like Line, Bar, Combo, Trellis and Gauge charts

·         Created Objects like List boxes, Multiboxes, slider, buttons, charts, text objects, bookmarks, etc.

·         Developed many QlikView applications by creating expressions using set analysis and aggregation functions.

·         Optimized QlikView performance by creating QVD’s from data warehouse and setting up incremental reload which reduced load on Database Server.

 

 

Tools:  Qlikview, Tableau 8.2

 

 

 

 

 

 

Cisco Systems, Inc., Research Triangle Park, NC                                                       2012 – 2014

Business Analyst (Americas TS: Strategy & Business Planning)

 

As a Business Analyst of the Strategy & Business planning team of the Americas I am responsible for data reporting, analysis, trending, forecasting, dashboarding and internal business consulting.

 

Responsibilities:

 

 

·         Conducted research into operational, financial and industry data.

·         Retrieved data and ran reports from Business Objects, FinBI, and other Cisco data sources.

·         Analyzed data to form observations, developed and tested hypotheses, discovered trends and created forecasts.

·         Presented findings across Cisco to various audiences (from IC to executives) and tailored presentation accordingly.

·         Constructed dashboards to enable recurring self-serve access to data.

·         Responded to business intelligence needs of the business and field related questions.

·         Discovered and pursued opportunities to improve the business

·         Once proven, documented how successful analyses are done, so that others may replicate.

·         Automated recurring manual tasks

 

Tools:  Qlikview, Tableau 8.2

 

 

American Family Insurance, Madison, WI                                                                    2010 – 2012

Global Metrics Dashboard

Business Analyst

 

The Global Metrics Dashboard is an automated Portal and Data Warehouse application which aims to track and manage metrics, over time and in many dimensions.

 

Responsibilities:

 

 

·         Gathering requirements from Performance Analytical Users, identifying functional requirements and documenting them into a Business Requirement Document (BRD)

·         Created Narrative Use Cases, Use Case diagrams, Work flow diagrams, flow diagrams using MS Visio

·         Worked with Business Owners, IT Group, QA Team to scope and prioritize development releases

·         Developed Process flows, Use Cases and System requirement specifications and analyzed the Business requirements and the site specifications

·         Analyzed System and Functional Specification documents

·         Worked on writing functional specifications for different modules

·         Developed T-SQL Scripts and SSIS packages for loading the DataWarehouse dimension and fact tables on a daily and incremental basis.

·         Constructed SQL database queries and performed Data Analysis and data mapping

·         Extract, transform and load data from databases and excel into QlikView applications

·         Created Qlikview dashboards for the users to track budgets, resources and goal progress

·         Created reports using Business Objects functionality’s like Queries, Slice and Dice, Drill Down, Cross Tab, Master Detail and Formulae’s etc

·         Extensive interactions with the client and the management teams to understand the requirements and report the status of the testing effort on their applications

·         Assisted in performing functional and GUI testing

 

Environment: SQL, PL/SQL, Qlikview, Business Objects, Oracle 10g, Oracle9i, UNIX, SQL Developer

 

INTERN EXPERIENCE

 

Drilling Info Inc, Austin, TX                                                                                      2009 – 2010

Intern, PL/SQL Developer

 

Drilling Info, Inc. provides online data and tools to the oil and gas industry in the United States. It offers Drilling Info Network Architecture, a Web-based knowledge and project management platform that is used to capture the knowledge acquired by employees, catalog that knowledge in an organized way, and collaborate with on-site and off-site teams.

                         

 The goal of the project is to load data from Flat files, SQL Server, Oracle and Excel files into Oracle. All the sources in different formats were centralized in Oracle database.

 

Responsibilities:

 

·         Involved in System Analysis, Design, Coding, Data conversion and Database Maintenance tasks.

·         Physical designing and development of Database.

·         Created users and roles, and maintained system security.

·         Wrote complex SQL queries.

·         Helping Development Team in deploying and testing the application, which uses Oracle as a database.

·         Planning Backup/Restoration Strategy: Planning and scheduling Backups, taking Logical Backup (with Export / Import utilities).

·         Created both locally managed and dictionary managed table spaces.

·         Created b-tree and bitmap index and used them for better performance.

·         Killed sessions requested by users and/or jobs running much longer than expected time.

·         Involved in SQL tuning.

·         Created system design document and requirement document.

·         Worked with Development team to fulfill the requirements of applications with Database design

·         Involved in configuring load balancing, ,TAF failover, testing scripts, migration documentation.

 

Environment: SQL, PL/SQL, Oracle 10g, Oracle9i, RMAN, SQL Trace, TKPROF, Toad, Putty, FTP, SFTP, UNIX (Sun Solaris 2.8)

 

 

ENGINEERING EXPERIENCE

 

Chilton Hall, University of North Texas                                                                  2009

Systems Administrator

 

My main responsibilities were to perform professional-level administrative support functions for an academic department and provide technical assistance in the day-to-day operation of computer lab.

 

Responsibilities:

 

·         Maintenance of the server and the systems.

·         Troubleshoot network hardware and software related problems.

·         Acquired Experience in working with various Operating Systems

·         Gained experience in working as a Team.

 

 

 

College of Engineering, University of North Texas                                                      2008

Graduate Technical Assistant/Systems Administrator

               

Responsibilities:

 

• Supervise a computer laboratory.
• Troubleshoot system and printer problems, assist faculty and students with desktop and server issues.
• Install software as requested and document all systems changes.
• Direct and manage the daily operation of computing labs.

 

 

Coign Technologies, Hyderabad, India                                                                  2007 – 2008

PL/SQL Developer

 

Coign Technologies is a provider of integrated business, technology and process solutions on a global delivery platform.

My main tasks includes installation, monitoring, backup/recovery, Performance tuning, applying patches, problem resolution, space management, Creating Databases, Creating table spaces with storage parameters, Creating Database objects, Users, Roles, Profiles for the databases.

 

 

Responsibilities:

 

·         Involved with Maintenance and Support processes.

·         Analyzed the software requirements of the project by studying the Software Requirement Specification document.

·         Created various database objects like table, indexes, sequence and views

·         Involved in creating, debugging and modifying stored procedures, functions and packages using SQL Developer and TOAD.

·         Creating SQL Loader Control Files for moving data from Flat Files (Fixed Record Length) to Staging Area Tables.

·         Maintaining a Test Database for testing and research.

·         Involved in unit testing, integration testing, system testing

 

Environment: SQL, PL/SQL, SQL*Loader, Oracle 10g,

 

EDUCATION

 

§  Masters of Computer Science, University of North Texas, Denton, TX.            

§  Bachelor of Technology in Computer Science & Engineering, JNTU, India.