Vijetha Popuri
Dublin,CA
Summary
About 16+ years of experience in IT with Master’s degree in Computer Science and specialization in Databases and Software Engineering. Development and Support of Business Intelligence using Power BI, SQL Server, SSAS, SSIS, SSRS and Tableau. Performed Data Cleaning, Data Validation, and Data Analysis using Data Analysis Expressions (DAX), MDX, Power Query and Power Pivot. Experience in generating Drill through and Drill down Power BI reports with Drop down menu option, sorting the data, defining subtotals in SSRS. Expertise in Extraction, Transformation, Loading data from Oracle, SQL Server, Access, Excel, Flat Files and XML using DTS, SSIS packages. Worked in OLTP & OLAP environments that include QA, Production, and development, implement maintain database schema and Entity relationship diagrams from business requirements. Skilled tuning SQL Server Performance using tools like Index Tuning Wizard, SQL Profiler and Database Engine Tuning Advisor. Hands on experience in all phases of SDLC (software development life cycle) involving Requirement Analysis, Software Design, Development, Implementation, Testing, Maintenance. Excellent analytical, communication and interpersonal skills. Proficient in technical writing and presentations and a good team player. Experience working on Payroll, Financial and Health care Databases. Ability to work independently or as part of a team to accomplish critical business objectives and to make decisions under pressure.
Overview
18
18
years of professional experience
6
6
years of post-secondary education
2
2
Certifications
Work History
Senior BI Developer
UKG (REMOTE)
11.2020 - Current
- Actively led projects that includes analyzing Business needs and system specifications
- Created data modeling
- Designed database structures using SQL Server Integration Services (SSIS), which supported users through out company
- Built Business Intelligence reporting tools for leadership team using Microsoft Excel and Power BI
- Designed and deployed interactive Power BI dashboards that effectively visualized KPIs for multiple departments
- Incorporated DAX in SQL server and agile methodologies , optimizing data models and contributing to improvement in reporting quality
- Served as lead architect for data mart and database management system, which is used to store revenue information
- Assisted in implementing tools for data validation and testing ETL process for different data sources
- Generated complex T-SQL queries, enhancing accuracy of reporting process and saving 15 hours per week
- Developed OLAP processes for changing and maintaining Data Warehouse, optimizing dimensions, and adding new aggregations in Cube
- Collaborated with cross-functional teams to gather requirements, identify business trends using SQL Server Reporting Services, and recommend optimal business solutions
- ENVIRONMENT: SQL Server, SQL Profiler, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI, Sales Force, Citrix, C#, PowerShell, Azure, JIRA, Atlassian.
Senior BI Developer
Spartan Solutions
Palo Alto, CA
05.2016 - 09.2020
- Developed cubes using Partitions, KPI's, and Perspectives, slow changing dimensions SCD etc and wrote MDX queries to pull data from Cubes
- Build insights and analysis from streams that were extracted to excel and create visualizations on top of it
- Developed complex stored procedures, functions, and ad hoc T-SQL queries for data transformation
- Performance analysis of existing systems and pipelines to scale up to higher volumes of data
- Perform data quality and profiling activities, and advice on data quality issues
- Identify and fix data issues and understand vast amounts of data
- Utilize SQL server integration services to create jobs for transforming raw data feed into structured data feeds
- Maintain dashboard and reports using latest technologies like Power Bi and SharePoint online
- Review code and use tools like Code Look and Code Flow for code review management
- Develop mappings, define workflows & tasks, monitor sessions, export and import mappings & workflows, and perform backup & recovery
- Developed Tableau visualizations and dashboards using Tableau Desktop
- Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server
- Incorporating Business logic in SSIS packages while converting from Oracle, MS Access and Text to SQL Server
- Creating new database/tables to put in extracted data and rebuilding relationship
- Application processed bid solicitations, distribution and vendor contracts and handled importing/exporting of data from SQL Server
- ENVIRONMENT: SQL Server, T-SQL, SQL Server Analysis Services (SSAS), Power BI, SQL Profiler, ETL, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS)
MSBI Developer
InsideTrack
San Francisco, CA
04.2014 - 04.2016
- Develop Power BI reports and dashboards by mapping various sources, transforming, and loading data
- Extracting and Loading data into SQL Server Database
- Created SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for SSAS cubes Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
- Designed data model and stored procedure to support business intelligence process and dataflow
- Developed complex and detailed reporting models to analyze business performance and trends
- Design and create report models based on users’ requirements, explain and train users to use report builder to generate their own personalized reports
- Worked very closely with Business Customers, End Users and resolved any business process related issues
- Participated in creating Jobs for various packages that run at specific schedule every day based on some dependencies
- Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
- Performed development support, document reviews, test plan, integration of system
- Maintained web service for sending vendor notifications
- ENVIRONMENT: SQL Server 2012, Document DB, SSIS, Power BI, SSAS, Visual Studio, Jitterbit, Atlassian, Visual Source Safe
Team Lead of SQL Development
Equator
Los Angeles, CA
06.2008 - 04.2014
- Created and automated SSIS packages to migrate data from legacy systems to customized data warehouse
- Lead team of 8 developers for complex projects in migrating millions of records from multiple data sources to On-Prem
- Developed data models and reports for Business Analysts to analyze and improve efficiency of business operations
- Develop stored procedures and create SQL Server objects based on business logic and requirements
- Develop logic for integrating different tabular cubes
- Design Databases and Schema for different requirements
- Integrate different types of Data in to existing tables and create tabular cubes
- Analyze and report existing procedures and optimize performance
- Document reports/dashboards creation and demo it to client on how to use them
- Design and develop test cases for project
- Document test reports and coordinate with other developers with potential cause of bugs
- Actively involved in gathering functional requirements and participate in team meetings
- ENVIRONMENT: C#, SQL Server 2012, Visual Studio, Task Factory, Cold Fusion, Sales Force, Red Gate, Lite Speed, TFS
SQL Developer
Kaiser Permanente
Pasadena, CA
02.2008 - 06.2008
- Created new tables, written stored procedures using T-SQL for Application Developers and some user defined functions
- Scheduled Reports to run on daily and weekly basis in Report Manager Expertise in developing advanced reports with functions, formulae, parameterized reports, sub reports, summary reports, cross tabs, ranking and conditional formatting
- Create Store Procedure using T-SQL to evaluate result for reports to implement using Management studio
- Scheduling & publishing reports using Crystal reports server
- Export Crystal report in Excel and PDF formats and migration from Crystal Reports to SSRS
- Generate graphs & Pie Charts using Crystal reports and SSRS show revenue of business
- Responsible for deploying reports to Report Manager and Troubleshooting for any error occurs in execution
- Created and managed users, roles and groups and handled database security
- Defined Check constraints, Business Rules, Indexes, and Views
- Perform T-SQL tuning and optimizing queries for Reports which take longer time in execution SQL Server 2012
- ENVIRONMENT: SQL Server 2005/2008, MS Excel 2003-2007, C#, Visual Source Safe
SQL Database Administrator
Mayo Clinic
Rochester, MN
08.2007 - 02.2008
- Involved in writing complex SQL Queries, Stored procedures, views, triggers, cursors, User Defined functions to implement business logic
- Involved in translation of business requirements into technical design specification
- Extensively worked on all activities related to development, implementation and support of ETL (Extract, Transform and Load) processes for large-scale data warehouses using SQL Server SSIS
- Scheduled SQL jobs using SQL agent to automate all DTS packages
- Monitored daily jobs and resolved issues that caused by production data by modifying DTS packages
- Worked on Data Flow Transformations like Aggregate, Audit, Conditional Split, Data Conversion, Derived Column, Lookup, Slowly Changing Dimension and Script Component etc
- Modified existing reports according to requirements of end users
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server
- ENVIRONMENT: SQL Server 2000 and SQL Server 2005, MS Access, DTS
SQL Database Administrator
Rohm and Haas
Philadelphia, PA
11.2006 - 07.2007
- Performed requirements analysis and researches toward problem resolution Participated in design and code review sessions
- Database design: extended logical and physical database design
- Created documentation, database schema and data models
- Performed systems integration testing and release deployments Used T-SQL for automating backend processes
- ENVIRONMENT: SQL Server 7/2000, Enterprise Manager, Windows NT, DTS, SQL Profiler
SQL Database Administrator
Comcast
Philadelphia, PA
05.2006 - 11.2006
- Involved with Backups and Recovery, Log shipping and Replication Configuring SQL Enterprise Manager, maintenance of database, backups, job scheduling, generating reports and resolving issues
- Create users, roles and profiles, privilege management with role-based security of databases, table spaces, indexing, data maintenance, user management and maintenance
- Created Database Maintenance plans for performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing
- ENVIRONMENT: MS SQL Server 2000, Windows 2000, Windows NT 4.0, Enterprise Manager, SQL Query Analyzer, SQL
Education
Masters of Science in Computer Science -
Fairleigh Dickinson University
Teaneck, NJ 08.2005 - 05.2007
Bachelor of Technology -
Jawaharlal Nehru Technological University
Hyderabad, AP 06.2001 - 05.2005
Skills
C#undefined
Certification
MCSA Querying Microsoft SQL Server 2012/2014, 12/2015
Timeline
Senior BI Developer
UKG (REMOTE)
11.2020 - Current
Senior BI Developer
Spartan Solutions
05.2016 - 09.2020
MSBI Developer
InsideTrack
04.2014 - 04.2016
Team Lead of SQL Development
Equator
06.2008 - 04.2014
SQL Developer
Kaiser Permanente
02.2008 - 06.2008
SQL Database Administrator
Mayo Clinic
08.2007 - 02.2008
SQL Database Administrator
Rohm and Haas
11.2006 - 07.2007
SQL Database Administrator
Comcast
05.2006 - 11.2006
Masters of Science in Computer Science -
Fairleigh Dickinson University
08.2005 - 05.2007
Bachelor of Technology -
Jawaharlal Nehru Technological University
06.2001 - 05.2005
Similar Profiles
Arihant JainArihant Jain
Integration Consultant II at UKGIntegration Consultant II at UKG
CHANDRA MOYECHANDRA MOYE
Lead Release Manager at UKGLead Release Manager at UKG
Adam GillAdam Gill
Solution Consultant II at UKGSolution Consultant II at UKG
Shion PattishallShion Pattishall
Head of Legal Operations Manager and Chief of Staff to CLO at Box, Inc.Head of Legal Operations Manager and Chief of Staff to CLO at Box, Inc.
Sridurga MandepudiSridurga Mandepudi
Para Educator at The Steppingstones GroupPara Educator at The Steppingstones Group