Post Job Free

Resume

Sign in

Sql Server Data

Location:
Bentonville, AR, 72716
Posted:
March 11, 2019

Contact this candidate

Resume:

Sandeep Reddy

571-***-****

ac8qxo@r.postjobfree.com

Sr. MSBI/SQL Developer

PROFESSIONAL SUMMARY:

A result driven software professional with 8 years of progressively responsible experience in DataAnalysis, Design, Implementation, Administration and Support of BusinessIntelligenceOLTP(BatchProcessing,OnlineProcessing), OLAP,ETL,Datawarehousing,Datamining,DBMS

and DataModeling usingconfidential SQLServer2016/2014/2012/2008R2/2008/2005, SSIS,

SSRS and SSAS.

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

Skillful in ETL - Extraction Transformation Loading, Operations Data Store concepts, data marts and OLAP-Online Analytical Processing technologies.

Proficient knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes schemas, ETL processes, dimensional modeling and reporting tools.

Experience in creating Views, Constraints, Triggers, Joins, Cursors, Temp Table, Table Variable, Functions, Batch Scripts and numerous stored procedure consumed at various stages of migration/cleansing process, reports or data validation.

Proficient in writing complex T-SQL (DDL, DML), new features like CTE, Ranking Functions, TOP(n), PIVOT, XML PATH,SQL, Physical, logical database design and Performance tuning.

Excellent hands-on experience with data modeling tool like Erwin and strong knowledge of Relational and Dimensional database modeling concepts with star schema and snowflake schema’s design and implementation.

Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.

Created SSIS packages to Extract, Transform and load (ETL) data from Excel, Database, XML File and Flat file source by using different SSIS transformations such as Lookup, Derived Columns, Condition Split, Aggregate, Pivot Transformation, and Slowly Changing Dimension, Merge Join and Union all.

Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.

Experience in OLTP/OLAP environment and Data Warehouse.

Expert in creating various types of reports like reports using Cascading parameters, Complex drill down and drill through reports and charts using SQL Server Reporting Services (SSRS) based on relational and OLTP databases

Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2005/2008 Analysis Services.

Expertise in using Microsoft Reporting Service(SSRS) with Report authoring, Report management, Report delivery and Report security.

Strong ability in defining query for generating drill through, drill down reports, canned and cache reports with drop down menu option, sorting the data, defining subtotals and handling parameterized reports and creating report layouts using SSRS 2005/2008.

Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Proficient in creating Data Mapping Document for providing source and destination mappings. Deployed reports on report server.

Developed reports using global variables, expressions and functions.

Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, DB2 8.0/7.0, UDB, MS Access and Teradata.

TECHNICAL SKILLS:

Databases

Confidential SQL Server (2005/2008/2008 R2/2012), Oracle 8i/9i, Oracle 10g/9i DB2, Postgre MS Access, NoSQL Databases(HBase).

Database Tools

MS SQL Server (2005/2008/2008 R2/2012), MS-Access, SQL Server Integration Services(SSIS), Data Transformation Services(DTS), SQL Server Reporting Services(SSRS)

Development skills

T-SQL, PL/SQL, SSIS/SSRS, SQL PLUS, Power BI

Languages

VB.net, Linux, UNIX

ETL Tools

DTS, SSIS (SQL Server Integration Services), Informatica

Reporting Packages

SQL Server Reporting Services, MS Excel.

Tools/Methodologies

MS Project, SQL Profiler, Toad, TFS 2010, Agile, Jira, Waterfall.

Windows XP, Windows 7, Windows 8, Win 2003/2008/2008 R2

Professional Experience

Wal-Mart, Bentonville, AR May 2018-Present MSBI/SSIS/SSRS/SSAS Developer

Responsibilities:

Prepares performance Dashboard, Jobs Failure stats, Data Volume check using SSRS, SSIS, SQL and Excel and gives PPT presentation near client for this on a daily basis.

Creating and managing schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements.

Troubleshooting reports issues, ETL job failures, optimizing query performances.

Design and implement the ETL processes using SSIS which involves collection of data from sources like SQL Server 2008 R2/2012/2014/2016.

Develop SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.

Developing and maintaining/modifying complex T-SQL queries, stored procedures and SSIS packages to load the data into warehouse.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Responsible for debug, performance checks and performed index tuning and query optimization.

Solid knowledge of Relational Database Management System (RDMS), Data Warehouse Concepts, PL SQL, DAX, OLAP and OLTP.

Designed and deployed report with Drill Down, Drill Through, Dropdown menu option, Parameterized and Linked reports.

Migrated Packages of SQL Server 2012 to SQL Server 2016 as per business requirement.

Coordinated with on introducing SQL Server PDW data warehouse appliance, that involved hardware configuration, table partitioning and dimension mapping to distributed and replicated inventory.

Installed, maintained and patched the MS-SQL software - created, moved, upgraded, and deleted databases. Monitored and tuned databases using Performance Monitor, SQL Server Profiler and Dynamic Management Views.

Created Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Created Store Procedure to move data from old structure to new structure.

Involved in creating Indexes for faster retrieval of data.

Using SQL to query database performing various validation and mapping activities.

Worked on deploying and scheduling Reports using SSRS and Tableau as well as triggers to generate all daily, weekly, monthly and quarterly Reports including current status.

Prepared the Layouts by placing the fields to the appropriate place according to the requirement of the final Report.

Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team.

Developed database objects such as Stored Procedures, CTE, Functions, Tables, Triggers and Indexes using T-SQL.

Implemented Triggers for checking complex business conditions, providing security for the tables.

Created Materialized Views and Indexes for better performance of summary tables, Autonomous Transactions, Coding Dynamic SQL Statements

Involved in merging existing databases and designed new data models to meet the requirements.

Used Index Tuning Wizard, SQL Profiler and SQL Query analyzer for Performance Tuning.

Environment: MS SQL Server 2016/2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), DAX, Agile, C#.NET, T SQL, SQL Profiler, XML, Team Foundation Server (TFS), MS Excel, Excess, Windows 8.

PNC Bank, Pittsburgh, PA Jan 2017- Apr 2018

Role: Senior SQL BI Developer

Responsibilities:

Involved in the performance of data consistency and tuning effectively with SQL Profiler, Index Tuning Wizard.

Involved in creating and maintaining database objects, Stored Procedures, Functions, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications.

Installed SQL Server 2012/2014 and all necessary tools in Development, Staging and Production environments.

Upgraded SQL Server 2000 and 2005 to the SQL Server 2014 and troubleshoot the compatibility issues.

Created all types of database objects like Tables, Views, Triggers, Stored Procedures, Indexes, and User Defined Functions according to Business logic.

Responsible for Creating and Monitoring SQL Agent jobs and Scheduled Tasks on all environments.

Created SSIS packages by using various Transformations, Containers to import and export data.

Developed many Tabular Reports, Matrix Reports, Drill down Reports, and Dropdown Reports, Sub Reports, Bar Graph Reports, and Cascading Parameters Reports using SQL SSRS 2010/2012.

Worked with different business users in setting up data marts based on their Analysis/Reporting needs.

Experience in creating Multidimensional cubes using SSAS and designing DW schemas.

Converted complicated Crystal Reports to Standard SSRS reports by creating stored procedures and mapping parameters thus by enabling Business Users easy access to one stop Reporting Solution via SSRS.

Used SSIS to implement the Slowly Changing TransfFormation, to maintain Historical Data in Data warehouse

Involved in lot of installations/upgrades/deployments of new/updated tools and applications.

Documented all the procedures for Crystal Reports Conversions, SSRS Onboarding and other Application updates.

Worked on different packages with various types of transformation tool like: Lookup, fuzzy Lookup, derived column, join, merge join, conditional split and slowly changing dimension.

Created packages in SSIS with error handling as well as created complex SSIS packages using various data transformations like conditional split, Cache, for each loop, multi cast, Derived column, Data conversions, Merge, OLEDB Command, script task components.

Experience with on-site / off-shore coordination by attending daily sync-ups and ensuring the deadlines are met.

Created relationships between tables in Power BI using Star and Snowflake schemas.

Created several Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.

Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.

Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: SQL Server 2014/2012/2008/2005, SSIS-2012, SSRS-2012, Power BI, Crystal Reports, Periscope Data, Tableau Server.

Fifth Third Bank, OH Jun 2014 –Aug 2016

Role: MSBI/SQL Developer

Responsibilities:

Developed various T-SQL stored procedures, views, and adding/changing tables for data load and transformation, and data extraction.

Created Database Objects like Tables, Stored Procedures, Views.

Worked in production support to optimize the stored procedures and scheduled many jobs.

Created complex queries involving Sub-queries and Joins.

Created Indexes for fast retrieval of the data. Involved in Performance tuning and Query Optimization using execution plan.

Installed, Configured, Managed and Monitored SQL Server 2012/2008/2005.

Creating tables, indexes and designing constraints.

Created Backend validations using Insert/ Update and Delete triggers.

Creating Indexes and used Scan and Seeks for performance tuning.

Developed and deployed SSIS packages in Production Server.

Managed the entire ETL process involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to end users.

Created logging, custom logging and error handling packages.

Involved in supporting more than 80+ Users for various Reporting and Analytics requirements across multiple Business Units and departments.

Used Aggregate awareness function of Business Objects to route the query objects through the appropriate path while selecting from multiple contexts.

Identified Dimensions and Facts, Used MDX to extract data from cubes and created MDX script for representing Cube Calculation.

Created usage based aggregations in cube to minimize time for query retrieval from client tool.

Generated Reports using Global Variables, Expressions and Functions for the reports.

Created many Complex Queries using MDX Expressions.

Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Reviewed the SQL Server Error Logs and Application Logs to resolve the issues.

Develop the reports for business users using Crystal Reports.

Tested the reports and fixed bugs in the stored procedures.

Maintained the physical database by monitoring performance, integrity and optimized SQL queries for Maximum efficiency using SQL Profiler.

Provided 24x7 on call support for various projects and ensure that all critical database problems are resolved in timely manner.

Interacted with developers on various aspects ranging from usage of utilities to SQL performance, test data and general troubleshooting

Environment: SQL Server 2012/2008/2005, SSRS 2012/2008, SSIS 2012, C#, ASP.NET, DB2, Oracle 9i/10g, Visual Studio 2012, XML, XSLT, MS Office and Visual source safe, Business Objects XI 3.1/3.0, XI R1/R2, Power BI, Power Map, Power Pivot, Power View.

Community Health Plan, WA Mar 2012- May 2014

SQL Developer

Responsibilities:

Created tables, temporary tables, table variables, indexes, procedures, views and triggers for automating various tasks in TSQL.

Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard and SQL Sentry plan explorer.

Worked on internal project to develop a performance Data warehouse.

Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.

Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.

Participated in creating reports that deliver data based on stored procedures.

Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost.

Developed Multi-dimensional Objects using MS Analysis Services.

Developed the SQL programs and Involved in optimize stored procedures and queries for faster retrieval and Server efficiency.

Designed and deployed various complex reports using MS Reporting Services.

Created Tabular reports, Cross Tab Reports, Matrix, Sub Reports and Parameterized reports.

Analyzed reports and fixed bugs in stored procedures.

Designed and implemented stored procedures and triggers for automating tasks.

Involved in Trouble Shooting Complex Reports.

Created Large Number of Report Models for users to create their own reports.

Fine-tuned SQL queries for maximum efficiency and performance.

Configured the report viewing security for various users at various levels using Report Manager.

Monitoring and Releasing reports in a timely manner to ensure the correct reports are reached to end users without data discrepancy.

Environment: Microsoft SQL Server 2012, Microsoft Excel 2010, Power Pivot, Team Foundation Server (TFS), Windows 2008.

HDFC Bank, Hyderabad, India. Jan 2011- Feb 2012

SQL Developer

Responsibilities:

Analyzed business requirements and build logical data models that describe all the data and relationships between the data.

Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005.

Validated change requests and made appropriate recommendations. Standardized the implementation of data.

Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.

Created the DTS Package through ETL Process to vendors in which records were extracts from Flat file and Excel sources and loaded daily at the server.

Involved in the development of a normalized database using Data Definition Language (DDL) in T-SQL.

Performed job scheduling in the SQL Server Environment.

Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.

Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.

Managed user access. Created and managed new security accounts.

Backup and restore databases.

Developed and implemented database and coding standards, involved in improving performance and maintainability of corporate databases.

Environment: SQL Server 2000/2005/2008, T-SQL, DTS Designer, MS-Office, Ms-Excel, VSS

Education:

Bachelor’s in Electronics and Communications at Sri K.S Raju Institute of Technology and Sciences

-2011



Contact this candidate