Sridevi Javvaji

SQL/BI Developer

571-***-****

Herndon, Virginia, 20171

adkvhp@r.postjobfree.com

Experience Summary:

Over 5 years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, SQL SERVER, MSBI and Power BI.

Extensively worked on system analysis, design, development, testing and implementation of projects and capable of handling responsibilities independently as well as a proactive team member.

Excellent knowledge of entire Software Development Life Cycle (SDLC) methodologies like Agile, Scrum, UML, Waterfall and Project Management Methodologies.

Experience in designing Star, Snowflakes schemas and database modeling using Erwin tool.

Experience in OLTP/OLAP environment and Data Warehouse.

Experience in designing, developing and deploying Business Intelligence solutions using SSIS, SSRS, SSAS, Power BI

Expert in creating multiple type of reports using tools like Power BI and SSRS.

Building and publishing POWER BI reports utilizing complex calculated fields, table calculations, filters, parameters.

Designed and developed matrix and tabular reports with drill down, drill through using SSRS.

Experience in writing Complex SQL Queries involving multiple tables inner and outer joins.

Worked as MS SQL Server Developer on enterprise and performance critical applications.

Extensive experience in developing Stored Procedures, Views, Cursors, Triggers and Complex Queries in MS SQL Server.

Involved in migration of legacy data by creating various SSIS packages

Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through and Cascading reports using SSRS.

Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.

Expert in creating Power pivots, power query, Power views and SSRS reports using tabular model

(DAX), Cubes (MDX) and SQL queries.

Enhancing the Reports visually by adding the visual elements like charts, graphs to SSRS reports Involved in Logical and physical Design of the Database using Erwin tool.

Auto-generated analysis reports using SQL Server, ACCESS, Business Objects and Crystal Reports and Excel pivot tables.

Strong knowledge and exposure to creating Jobs, Alerts, SQL Mail Agent and scheduled SSIS Packages

Excellent verbal and written communication skills with a strong focus on customer facing interaction, customer service, and presentation.

Experience in tuning the reports that includes modifying, Testing the required TSQL and MDX queries using DMV's and creating the necessary environment for Deployment.

Test & Deploy code across various SDLC Environments like TEST, UA/UT/Production.

Self-Motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.

Technical Skills:

RDBMS/DBMS: MSSQL Server 2016/2014/2012/2008R2/2008/2005/2000, MySQL, Oracle11g/10g/9i/8i, and MS Access 2003/2000/97

Database

Technologies/Tools:

SQL Server Entreprise Manager, Microsoft Management Console, SQL, T- SQL, Data Transformation Services (DTS), OLTP, BCP, SSIS, OLAP. Microsoft Visio, ER Studio

Reporting Tools: Power BI, SQL Server Reporting Services, Crystal Reports, Tableau, Excel. Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003, Windows Vista, Windows 7 Programming Languages: T-SQL, PL/SQL, HTML, C#.Net, VB.Net, C++, Java, Java script, CSS, Windows Scripts

Design Technologies/Tools: Erwin, MS Visio, Rational Rose Data Warehouse / Business

Intelligence Tools

SQL Server Reporting Services (SSRS), SQL Server Integration Services

(SSIS), Visual Studio 2013/2010/2008, SSAS, Business Intelligence Development Studio (BIDS) 2008, MS Data Tools 2012 / Visual Studio Shell Education:

Sikkim Manipal University JUN 2004 – Aug 2006

Master of Business Administration.

Gangtok, Sikkim.

Professional Experience:

Client: Visa, Littleton, CO Jan 2020 – Present

Role: MS BI /Power BI Developer

Responsibilities:

Involved in planning, defining and designing data base using Erwin on business requirement and provided documentation

Translating business requirements into technical design specifications

Designed SSIS Packages to transfer data from various sources such as Text Files, XML Files, Excel, Flat files to SQL Server2016

Gathered report requirements and determined the best solution to provide the results in either a Reporting Services report or Power BI.

Installed and configured Power BI Desktop.

Created Power BI Visualizations and Dashboards as per the requirements.

Created effective reports using visualizations such as Bar chart, Clustered Column Chart, Waterfall Chart, Gauge, Pie Chart, Tree map etc. in Power BI

Involved in building and maintaining SSIS Packages to import and export data from various data sources using BIDS based the design data models

Installed and configured and maintained Power BI Report Server.

Created Power BI Dashboard and generated reports using the SQL server tables as source. Lock objects on the reports.

Created reports on Power BI Desktop and published on Power BI Report Server.

Created access for users to use the Power BI reports on the web and across mobile devices.

Applied various data transformations such slowly changing the dimensions, aggregates, sorting, multicasting, conditional split, and derived column

Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints

Designed and developed Tabular Model Cubes usingSSAS 2016. Developed calculated columns and measures using DAX

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages to load excel sheets from PC to database

Wrote T-SQL queries, stored procedures and used them to build SSIS packages, SSRS reports and in Tableau.

Created user interface reports using Tableau sheet objects like List Box, Input Box, Buttons, Text Input, Slider, Bookmarks, Charts (Pivot/Straight tables, Pie, Bar, Line etc.)

Created SQL queries and developed Dashboard style of reports as per business needs

Created and schedules tasks for reloading and distribution of Data in Tableau

Designed, developed and deployed reports in MS SQL Server environment using SSRS- 2016

Created reports to retrieve data using Stored Procedures and parameterization

Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored them in the script.

Used SQL Profiler TSQL Duration template for tracking execution time of TSQL Statements

Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software

Created traces using SQL Server profiler to find long running queries and modify those queries as a part of Performance Tuning operations

Performed daily tasks including backup and restore by using SQL Server 2016 tools such as SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor

Environment: SQL Server 2016, SQL BI Suite (SSIS, SSRS, SSAS), T-SQL, DAX, Power Query, SQL* Profiler, TFS, DTS, OLAP, Windows 2008/XP, MS Visio 2010, ALM, Ana plan, Tableau, Power BI Client: GrammaTech Ithaca, NY July2017 – Nov 2019

Role: MSBI Developer

Responsibilities:

Designed and developed SSIS Packages (.dtsx files) to import and export data from MS Excel, SQL Server 2014 and Flat files.

Used various Transformations such as For loop container, For Each loop container, Execute package task, FTP task, Bull Insert task, Script task In SSIS Control Flow and Row sampling, Lookup, aggregate grouping in SSIS Dataflow.

Designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.

Created SSIS packages for File transfer from one location to the other using FTP task with Master SSIS Package to run all other packages.

Created packages using the various control flow task such as data flow task, execute SQL task.

Created SSIS Packages/projects to move data from source to destination programmatic by using Visual Studio 2014.

Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.

Generated monthly reports and budget analysis to drive forecast production plan with SQL Server Reporting Services (SSRS).

Created Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).

Created database objects like tables, users, roles, stored procedures, triggers.

Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.

Administered SQL Server with Client/Server tools including SQL Server Enterprise Manager, Profiler and Query Analyzer.

Worked on Data Warehouse Modeling with SQL Server Analysis Services (SSAS).

Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.

Created SSIS Writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors and User Defined Functions to implement the business logic.

packages to integrate the data coming from flat files

Migrated SSIS Packages from 2012 to 2014 during data migration.

Optimized queries by looking at Execution Plan for better tuning of the database.

Used Temp Tables to reduce the number of rows for joins, to aggregate data from different sources for different reports.

Designed and developed various complex reports such as Drill down, Drill Through, Cross Tabbed using MS Reporting Services.

Created SSIS packages for loading data from SAP BW/BI to SQL Server.

Performed database backup and deployment to the production server.

Involved in modifying existing Data Stage Jobs for better performance.

Created detail Technical documentation of various staging area operations for future reference and guidance.

Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 2012).

Installation and configuration of SQL Server Reporting Services (SSRS) 2014

Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports (SSRS 201).

Involved in Normalization and De-Normalization of existing tables for faster query retrieval

Involved in SIT (System Integration Testing) and UAT testing, bug fixing and documentation for the project.

Designed STAR, SNOW FLAKE Schemas.

Environment: MS SQLServer 2016/2012, MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), Salesforce, Intact, PowerBI Desktop, PowerBI Service, Data Gateway, DAX, T SQL, SQL Profiler, XMLA, MS Excel, Excess, Windows 8. Client: The Irvine Company Oct 2015 – June 2017

New York city, New York

Role: SQL BI Developer

Responsibilities:

Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.

Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.

Experienced in database design process and data modeling process.

Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.

Designed SQL Server Database and Table Design with Schemas, Constraints and Views.

Extracted data from various sources like DB2, VSAM, SQL Server 2012/2008 R2, .CSV, Microsoft Excel and Text file from Client servers.

Analyzed business requirements and implemented data mart solutions for data mining and reporting.

Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.

Created a report model on SSAS cubes.

Designed the data model based on star schema and created the tables and indexes and developed the scripts to load the data mart tables.

Identified issue and developed a procedure for correcting the problem which resulted in the improved quality of critical tables by eliminating the possibility of entering duplicate data in a Data Warehouse.

Developed, Code Reviewed, fixed bugs, tested and deployed SSIS packages using SQL Server 2014/2012/2008 R2 Business Intelligence Development Studio.

Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.

Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.

Developed reports with consistent drill-down functionality including Drilldown report and Summary report.

Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.

Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.

Deployed and Tested (UAT) Reports in Multi User Environment. Created RS Config Files and Ensure Report Security with Keys.

Involved in Installation, Configuration and Deployment of Reports using SSRS with Scale-Out topology.

Worked closely with QA team and helped them come up with test scenarios.

Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings

Environment: MS SQL 2008 R2/2008, SSIS, SSRS XML, T-SQL, DAX, MS Word, MS Excel, MS CRM,VBA (Visual Basic for Applications), Share point, DTS, C#,ASP.NET, Microsoft Visio, Crystal Reports, ER Studio, Performance point Server, Sales force, Team Foundation Server, FTP & SFTP server

Contact this candidate