Resume

Sign in

Sql Server Data

Location:
Dallas, Texas, United States
Salary:
$60/hr on C2C
Posted:
April 03, 2018

Contact this candidate

Resume:

RAVI TEJA VENKATA DUGGISETTY

SQL / MS POWER BI SSIS/SSRS/SSAS DEVELOPER

Email: ac40pq@r.postjobfree.com

Mobile: +1-203-***-****

PROFESSIONAL SUMMARY:

A result driven software professional with 8+ years of progressively responsible experience in Data Analysis,Design, Data Modeling, Development, Implementation andMaintenance of SQL Server Databases (2012/2008R2/2008/2005) And Business Intelligence Applications – SQL Server Integration services(SSIS), SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) And PowerBI.

Ability to work with various types and stages of Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation

Expert in all fields of SQL Server development including tables, user functions, views, indexes, Stored procedures, functions, triggers, clustering, T-SQL, relational database models and data integrity.

Efficient, in creating Sub-Queries and Joins, CTE, Ranking Functions, TOP(n) for complex queries involving multiple tables, using Exception Handlers.

Manipulated large datasets and interpret results using data aggregation functions.

Skillful in ETL – Extraction Transform Loading,Operation Data Store concepts,Data marts and OLAP-Online Analytical Processing technologies.

Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.

Experience in developing Teradata Databases, manipulating data, and making change to dimensions in databases using Teradata Utilities.

Expertise in PowerBI Desktop, PowerBIServer,PowerBI Mobile.

Expert in creating Workbooks andDashboards using PowerBI/Tableau Desktop, Server, and Reader with various versions.

Experience in developing dashboards with different chart types like heatmaps, pie charts, Geo maps, Parameters, Extracts, Context Filters, Sets, Aggregate measures.

Experience in creating Measures and Calculated Columns using DAX in PowerBI.

Strong ability in defining query for generating drill down reports, handling parameterized reports, and creating stylish report layouts in SSRS.

Experience in generatingDrill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS.

Generated reports using SSRS, Excel (Pivot) that could be used to send information to diverse group of users.

Very good experience in writing expressions in SSRS.

Extensive knowledge of using System Variables and creating User-Defined Variables for SSIS Packages.

Expert in creating PropertyExpressions, Script Tasks for SSIS packages.

Extensive knowledge of using Package Configuration wizard to configure SSIS packages.

Experience with Database Backup, disaster recovery and Disaster recovery drill.

Proficient in designing and developing cubes using SQL Server Analysis Services(SSAS) and leveraging the advanced BI functionality of SQL Server 2005.

Expert in implementing star and snowflake schema methodologies for design cubes and applying dimensional modeling using SSAS.

Good team player, strong interpersonal and communication skills combined with self-motivation, initiative, and the ability to think creatively.

EDUCATIONAL DETAILS:

Completed Bachelor’s in Mechanical Engineering (ME) in Anna University.

TECHNICAL SKILLS:

Operating Systems

Windows (All Versions)Unix, Linux, Mac

Databases

MS SQL Server 2014/2012/2008R2/2008/2005/2000, MS Access, Oracle 8i & 9i, Sybase, MS Access 97/2000/2003/2007, MYSQL.

Database Design Tools and Data Modeling

Ralph-Kimball Methodology, Bill-Inmon Methodology, Star Schema, Snow Flake Schema, Extended Star Schema, Physical And Logical Modelling, Dimension Data Modelling, Fact Tables, Dimension Tables, Normalization, Denormalization, MS Visio.

Modelling Techniques/Tools

Flow Charts, Sequence Diagrams, Activity Diagrams, Use case diagrams, Data Modelling, ER Diagrams

BI Tools

SQL, SQL Server Integration Services (SSIS 2005/2008/2012), SQL Server Reporting Services (SSRS 2005/2008/2012) SQL Server Analytical Services (SSAS 2005/2008/2012), Data Transformation Services (DTS), Visual Studio, BIDS, Power BI, Tableau.

Tools/Database Utilities

SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Business Intelligence Development Studio (BIDS), Toad, IIS 6.0/7.0,Business Objects, Crystal Reports 9.0, Web Services, XML, SOAP, WSDL, UDDI, Clear Case, Clear Quest, Visual Source Safe 6.0/2005, Visual Studio Team Foundation Server (TFS), ERWIN 7.3/7.2.

Languages

C, C++, HTML, XML/XSLT/.Net/C#,Core Java, Python,VB.NET

PROFESSIONAL EXPERIENCE:

Fidelity Investments,Boston,MA

Aug 2016-till date

Role:Sr.SQL/BI/ Power BI Developer

Responsibilities:

Involved in gathering User Requirements and System Specifications.

Developed Stored Procedures, functions and database triggers and maintained referential integrity and implemented complex business logic.

Implemented and executed SQL Server Integration Service packages to populate data from the various data sources, Developed packages for different data loading operations for many applications.

Created SSIS Packages using SSIS Designer for exporting heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server.

Migrated DTS packages to SSIS packages and modified the packages with new features of SQL SSIS.

ETL packages dealing with different data sources were designed (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services were developed.

Created Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

Created multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and chart.

Design, deployment, and maintenance of various SSRS Reports in SQL Server.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.

Backing up, restoring system & other databases as per requirements, and scheduled those backups.

Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.

Building SSRS Reports and Dashboards pointing to the Data Warehouse for reporting summarized data.

Build Reports in Power BI from scratch.

Used various sources to pull data into power BI such as SQL Server, SQL Azure, Oracle.

Created Power BI report Such as 'Daily Sales and order Report', 'Invoiced Sales Report', 'Daily Sales Report' and ‘Territory Performance Report'

Involved in Installation of Power BI Report Server.

Created Different Graphs and Charts for analyzing related Information using Power BI Features. (Power Query, PowerPivot, and Power view).

Designed and developed matrix and tabular reports for each serial number related data across different tables with drill down, drill through and drop-down menu option using SSRS.

Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.

Created action filters, parameters, and calculated sets for preparing dashboards and worksheets in Tableau.

Environment: SQL Server 2012 Enterprise Edition, SSIS, SSRS, SSAS, Informatica 7.1.2, Oracle 9i, Teradata,PowerBI, Tableau,Microsoft Visual Basic, VBScript, XML, Microsoft Visio, Windows 2003, IIS 5.0, MOSS, Microsoft Reporting Service, BO XI R2.

Wells Fargo, Fremont, San Francisco, CA.

April2015-July2016

Role:MS SQL BI/ Power BI Developer

Responsibilities:

Involved in gathering the requirements, conducted meetings with clients and documented the requirements and ITIL assessment & implementation of project

Expertise in designing, developing and implementation of mappings/transformations based on source-to-target specifications, defining ETL (extract, transform, load) and ETL development standards and conventions

Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements

Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures

Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.

Designed different type of reports including: Tabular forms, Matrix (cross Tab report) form, List items, Charts and Linked reports.

Analyzed & designed the business rules for data cleansing that are required by the staging & OLAP and OLTP databases

Designed Data Mart using Star Schema. Reviewed the Current Data Mart and OLAP Cubes and Implemented Corrections and enhancements.

ETL document developed for best practices and Reporting systems.

Modified current database by adding tables, altering referential integrity and relationships to support online system.

SSIS Look Up/Aggregation transformations is used to develop new mappings to match the needs of the business case.

By using various Transformations data was extracted for Informatica Power center 7.1.2.

Ran Informatica sessions and batches using UNIX Shell script.

Performed Pre and Post session shell commands.

Designed slowly changing dimension transformations (SCD) and customized the existing mappings.

Used ETL (Extraction, Transformation, Loading) from heterogeneous source systems. Assisted DBA in using the repository manager to give permissions to users to create new users and repositories.

Created DTS Packages and converted DTS packages to SSIS 2005

To import and export data from Excel Spreadsheets DTSX Packages were created, People Soft, Text files and CSV files.

DTS Exec Command is used for execution of DTSX Packages.

Converted data using Derived Column, Data conversion transformation and Script task.

Used SSAS MDX to extract data from cubes and Created MDX script for representing Cube Calculation.

To reduce apparent database complexity, created views for end users and preventing sensitive columns from being selected.

Created the indexes on columns having high selectivity and low density to speed up the execution of data retrieval queries and stored procedures.

Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.

Created Ad-hoc reports, Tabular reports, Drill down and Drill up reports.

Used SSRS Report Catalog to store the Configuration, Security and Caching Information for the Operation of the Report Server.

Delivered the final SSRS Report using the Request Handler.

Environment: SQL Server 2012 Enterprise Edition, Informatica 7.1.2, Oracle 9i, Teradata,Power BI, Microsoft Visual Basic,SSIS,SSRS,SSAS, VBScript, XML, Microsoft Visio, Windows 2012, IIS 5.0, MOSS, Microsoft Reporting Service, BO XI R2.

Choice Hotels-Phoenix, AZ

Jan 2014-March 2015

Role:MS SQL/MSBI Developer

Responsibilities:

Understanding Customer requirement via interaction and writing functional specification.

MadeSSAS model for Analytic detailing administrations.

Used data modeling tool ERWIN to configure tables and define relationships.

Knowledge in creating calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.

Worked in tabular models using SQL Server Analysis Services.

Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Involved in SCRUM meetings to keep track of the ongoing project status issues. Involved in waterfall-based approach to UI development.

Designed SSIS packages to transfer data from Heterogeneous database and different files format to SQL server.

Migration of database from SQL Server 2000 to SQL Server 2005.

Developed, deployed, and monitored SSIS packages including upgrading DTS to SSIS.

Responsible for creating dimensional and fact tables and building cubes using SSAS.

Worked with planning team to forecast the business requirements.

Created drill through and various cross tabbed reports using SSRS.

Developed various kinds of Tabular, Matrix, Drill-down, Charts and web receiving reports using SSRS.

Analyzed the project database requirement from the user.

Create and alter put away techniques and T-SQL contents because of approval exemptions.

Wrote complex Stored Procedures, Queries, Triggers, Functions, Indexes, User-defined Functions, and cursors for application.

Testing and Tuning SQL Queries for better performance.

Create Indexes and proper re-indexing for intensive OLTP system to ensure best performance.

Environment:

MS SQL Server 2005, Crystal Reports, PowerBI, SSIS, SSRS, SSAS, MDX, MS-Excel, DTS, Visual Studio.Net 2012,Windows XP Professional.

Sprint, Overland Park, KS

March 2013-Dec 2013

Role: MS SQL Server Developer/SSIS/SSRS

Responsibilities:

Functional and Business requirements were gathered and written the technical specifications for developing the Global Enterprise Data warehouse.

Worked closely with end users in designing and creating the Global Enterprise Data warehouse.

Created member properties, virtual dimension, dimension custom rollups, write back, action and drill through.

High Level Design of ETL DTS Package for integrating data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).

Periodic reports based on the statistical analysis of the data are generated using SQL Server Reporting Services (SSRS).

Created Drill-through, Drill-down, Cross-Tab Reports and Sub-Reports using RDL.

A multi-dimensional database (MDDB) was developed and OLAP cube using SQL Server 2000 that used to store and maintained the data.

Implemented MS Analysis Services SSAS setup, tuning, cube partitioning, and dimension designing including hierarchical and slowly changing dimensions.

Managed Up gradation of DTS packages to SSIS packages.

Responsible for transferring the data using SSIS packages.

Analyzed old reports designed in crystal reports and transform those reports into SSRS report with proper mapping and error handing.

Involved in the complete data warehouse development life cycle and solely responsible for the design, development, and maintenance of 8 cubes.

Transactional replication among different servers were created.

Provided technical guidance and support to end-users by developing documentations required.

Accomplished application and database code production pushes, following production release procedures.

Consummate production SQL release final verification procedure to production.

Acknowledged all database changes and follow and enforce change and release management processes.

Audited and enforced database security, code, and procedural standards.

Environment:

MS SQL Server 2012, MS Analysis Services SSIS, SSRS,SSAS, 2012, MS-Excel, DTS, Visual Studio.Net 2012

Corning Inc., NC.

June 2011-Jan 2013

Role : SQL Database Developer/DBA

Responsibilities:

Installed and configured MS SQL Server 2000 Enterprise Edition in the main office at MD.

Collected requirements from users and managers to better understand the business logic of the company and developed database that fits their needs

Developed and created logical and physical database architecture for servers at main office and warehouses. All tables in database were normalized up to third normal form.

Data from text files and Excel spreadsheets is transferred to SQL Server databases using DTS

Successfully transferred data to new location using Snapshot Replication and developed Merge Replication to support up to date record of Inventory Information.

Views created to replace old tables and new tables with triggers to support new business needs.

Improved the current stored procedures using Visual Source Safe 6.0 to meet current design.

Database performance issues were identified, tested, and resolved to ensure database optimization.

Automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into production SQL Server databases.

Developed custom stored procedures and function to support various new operations.

Established backup and recovery procedures for remodeled databases and implemented automated jobs for database backup.

Created Jobs, Alerts and scheduled DTS to generate Reports.

Environment: SQL Server 2005/2008, SSRS, SSIS, T-SQL, Script, JavaScript, ASP, Microsoft Office, Windows 2005/XP.

Humasoft Software, Hyderabad,India

April 2010-June 2011

Role:MS SQL Server Developer/ SSRS/SSIS

Responsibilities:

Responsible for creating Databases, Tables, Cluster&Non-Clustered Index, Unique/ Check Constraint Views, Stored Procedures & Triggers.

Was Involved in writing triggers and stored procedures.

Hands on experience in Designing and creating of Database Tables and Views.

Actively Involved in Normalization & De-Normalization of Database.

Was Involved in performance tuning of the database.

Used SQL Profiler and Database engine tuning advisor to performance tune the database.

Indexes were created to improve the performance of database.

Scheduling Jobs and Alerting using SQL Server Agent.

Created user logins at server level.

Involved in database Backup and Restore.

Developed custom Reports using Microsoft Reporting services.

Enhancing and deploying the SSIS Packages from development server to production server.

Created stepped and block reports using Microsoft reporting services.

Created drill through and cross tabbed reports using SSRS.

Environment:

MS project, VB, and C#, ASP.NET, ADO.NET, DTS, T-SQL, SQL Server 2008, COM/COM+, UML,SSIS SSRS, Windows 2008 Advance Server.

Dhanush Info Tech-Hyderabad, India

Jan2009-April 2010

Role:SQL Server Developer

Responsibilities:

Involved with end users to acquire Requirements. Created technical, user documentation.

Good understanding on the system.

Installation and Administration of MS SQL Server 2005.

Database objects like tables, views, indexes, stored-procedures, triggers, and user define functions were created.

Create Temp tables in the stored Procedure for different application.

Created Index to increase performance of stored procedures.

T-SQL queries for the retrieval of the data.

Created a report interface using Visual Basic 6.0, which allowed users to select reports and dynamically filter reports.

Written Various ASP codes for user interactions.

Tuning front-end applications like Visual Basic, which query the SQL Server databases.

Used SQL Statements to Present Query responses.

Good SQL reporting skills with the ability to create SQL Views and write SQL Queries.

Environment:

SQL Server 2005, T-SQL, VB Script, JavaScript, ASP, Microsoft Excel, DTS.



Contact this candidate