Sql Server Data
Resume:
SHIVA MEDI
*********@********.***
PROFESSIONAL SUMMARY:
Extensive experience developing and working with diverse collection of applications and 8+ years of professional experience as Microsoft SQL server database BI Developer.
Highly experienced in MS SQL Server 2014/2012/2008R2/2008/2005 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS).
Extensively performed database administration tasks: Installing, Configuring, Managing, Monitoring and Troubleshooting MS SQL Server 2014/2012/2008R2/2008/2005 on Windows 2003/2003R2/2008/2008 R2/2012 servers.
Experienced in designing reports to support Power Pivot Data feeds.
Change Data Capture (CDC) is a set of software design patterns used to determine (and track) the data that has changed so that action can be taken using the changed data.
Wrote business logic code in C# code behind files to read data from database stored procedures.
Possessed Excellent T-SQL Programming skills and effectively used Advanced Programming concepts like CTE’s, Windows Functions, Table Partitioning, Apply Operators, Table Valued Parameters, Output Clause, Merge Statement, Pivot, XML, Dynamic SQL, Table Valued Functions etc.
Highly experienced in creating complex Views, Stored Procedures, Power BI, DDL/DML Triggers and User-Defined Functions (UDF) to implement Business Logic and Data Protection.
Experienced with SQL Server and T-SQL in constructing triggers, tables, user defined functions (UDF), views, indexes, user profiles and relational database models with data integrity.
Used SQL Profiler, QlikView, Web FOCUS, Execution Plans, DMV’s, TFS 2010, Database Engine Tuning Advisor (DTA) and Created Suitable Indexes for Query Performance Tuning and Optimization.
Implemented Stored Procedures with TRY-CATCH Blocks, Database E-mail for Error Handling and Effectively Used Join Hints, Isolation Levels to reduce Locking and Blocking.
Used DMV’s and Locking Queries to find out Locks, Deadlocks and Long Running Queries or Transactions.
Written Scripts for deploying the code across various SDLC Environments like TEST, UAT and Production.
Experience in implementing different types of Replication models like Snapshot, Transactional and Merge.
Involved in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
Involved in monitoring database maintenance plans for checking database Integrity, Rebuilding, Reorganizing Indexes, Shrinking Databases, updating statistics, Creating and Scheduling SQL Server Agent Jobs.
Used Some of T-SQL 2012 New Features like Sequencer, Throw Statement, FetchandOffsetandFunctionsLikeLead,Format,Concat,First_Value,Last_Value,EOMonth,TRY_Convert etc.
SSIS Experience (ETL):
Designed ETL packages dealing with different data sources (SQL Server, Oracle, Flat Files, Excel Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
Developed SSIS Packages with Custom error handling, Logging using event handlers, Send E-mail Task and Used Checkpoints to rerun Packages from Point of Failure.
Experienced in working with different data sources like OLE-DB, flat files and Excel to source data in SSIS and proficient in creating SSIS packages from scratch and deploying them.
Designed SSIS Packages with Dynamic Tasks and Connections Using Variables, Expressions and Packages Configurations and followed best practices to maintain Optimized performance.
Loaded Data Warehouse Fact Tables and Dimension tables of type 1 and type 2 attributes Using Transformations Lookup, Merge Join, Conditional Split and also Using T-SQL 2008 Merge Statement
Debugged the Packages Using Break Points, Data Viewers, and Script Task, Deployed the Packages Using DTUtil Commands, Deployment Utility and Scheduled Packages with DTExec Commands.
SSRS Experience:
Designed and Deployed several SSRS reports such as Drill down reports, Drill through reports, Parameterized reports, Cascaded reports, Cached reports, Snapshot Reports, linked reports, Sub reports.
Used Report Manager to assign roles, permissions and Created report schedules and Subscriptions.
Expert in creating traditional as well as Web-based interactive reports using SSRS.
Experienced in creating reports using SQL Server Reporting Services sourcing OLAP cubes and data warehouse, data marts as well as transactional systems.
SSAS Experience (OLAP):
Experienced in building Star schema and Snow Flake schema depending on business requirements.
Defined Relationships between Dimensions and Measure Groups like Fact Relationship, Many-to-Many Relationship, and Defined Dimension Granularity within a Measure Group.
Experienced in developing and modifying cubes and dimensions in cubes using SSAS.
Skilled in developing Data Warehouses, Data marts using Star Schemas and Snow Flake Schema.
Experienced in Developing, Deploying and Processing SSAS Cubes and writing MDX queries.
TECHNICAL SKILL SET
EDUCATION QUALIFICATIONS:
B Tech in Computer Science (Bachelors of Technology), INDIA.
Professional Experiences:
AT&T, Atlanta, GA
Sr. MS SQL Server SSIS/SSRS Developer July2017- Present
AT&T Inc. is an American multinational conglomerate holding company, headquartered at Whitacre Tower in downtown Dallas, Texas. AT&T is the world's largest telecommunications company. It is the second largest provider of mobile telephone services and the largest provider of fixed telephone services.
Responsibilities:
Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
Created cube structure for the analysis of business condition and for creation of report using SSAS.
Created drill down and sub reports from SSAS cubes that can be browsed on web.
Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.
Environment: MS SQL Server 2008/2008R2, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, QlikView, Windows 7.
Assurant Field Services, Austin, TX Feb 2016 – June2017
Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)
Headquartered in Austin, Texas, Assurant Field Services has regional coverage nationwide. Our teams are dedicated to changing the way field services are delivered. We think outside the box to give our clients an advantage – reducing your risk, from first notice of default through REO disposition. Assurant Field Services focuses on reducing exposure to risk and preserving the value of homes for clients while maintaining healthy, stable neighborhoods in communities nationwide.
Responsibilities:
Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
Connected various applications to the database.
Created databases and schema objects including tables, indexes, views and applied constraints.
Wrote business logic code in C# code behind files to read data from database stored procedures.
Created reports from complex SQL queries and MDX queries.
Created and implemented the staging database prior to the final data warehouse.
Involved in Migration of different DTS packages to SSIS packages.
Expert in FTP task, ETL script task, look up transformation and data flow tasks to load staging databases.
Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
Worked with SharePoint Server 2007 while deploying SSRS reports.
Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.
Responsible for maintaining UAT (User Acceptance Testing) and Production environment.
Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services (SSRS) 2008, MS SQL Server Integration Services (SSIS) 2008, SQL Server Analysis Services (SSAS) 2008,
Power BI, Web FOCUS, QlikView, TFS 2010, Windows XP, Excel, Acrobat Reader, Microsoft Office SharePoint Server.
UnitedParcelService, Inc (UPS), GA Jan 2015 – Feb 2016
Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)
United Parcel Service, Inc. (UPS) is the world's largest package delivery company and a provider of supply chain management solutions. The global logistics company is headquartered in Sandy Springs, Georgia, which is part of the Greater Atlanta metropolitan area.
Responsibilities:
Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement.
Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
Extensively used transformations, control flow tasks, containers and event handlers.
Experienced in designing reports to support Power Pivot Data feeds.
Used checkpoints to implement the restart ability of the packages in SSIS.
Implemented custom logging in SSIS using event handlers and execute SQL task.
Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
Wrote business logic code in C# code behind files to read data from database stored procedures.
Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio (MSVS).
Created dynamic Package Configuration of type SQL Server table.
Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes.
Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan.
Environment: Erwin, SQL Server 2008 R2/2012, Business Intelligence Development Studio (BIDS 2008 R2), SSIS, SSRS, SSAS, Visual Studio 2012/2010, Team Foundation Server 20012/2010, BI Xpress V4.0.0, .NET Framework, T-SQL, Power BI, Web FOCUS, TFS 2010, AS400, MS-Excel, XML, Window 2007 Server, Crystal Reports, Share Point Server 2010.
Guideone Insurance, IA July 2014 – Dec 2014
Sr. MS SQL Database Developer (SSIS/SSRS/SSAS)
Guideone Insurance is a health service company, dedicated to helping the people we serve improve their health, well-being and sense of security. We make this happen through a broad range of integrated health care and related plans and services, and proven health and well-being programs that are targeted to the unique needs of our customers, clients and partners.
Responsibilities:
Based on business requirements, developed the complex SQL queries with Joins and T-SQL, Stored Procedure, Views, Trigger to implement the business rules and transformations.
Designed, Developed and Deployed reports in MS SQL Server environment using SSRS.
Created Subscription of Reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly or monthly basis using MOSS (Microsoft Office SharePoint Server) tool.
Connected various applications to the database.
Created databases and schema objects including tables, indexes, views and applied constraints.
Wrote business logic code in C# code behind files to read data from database stored procedures.
Created reports from complex SQL queries and MDX queries.
Created and implemented the staging database prior to the final data warehouse.
Involved in Migration of different DTS packages to SSIS packages.
Expert in FTP task, ETL script task, look up transformation and data flow tasks to load staging databases.
Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services.
Designed the SSIS Package for the Scheduling the task for the different operations like extracting the data, to perform appropriate transformation and Loading purposes.
Worked with SharePoint Server 2007 while deploying SSRS reports.
Performed daily tasks including backup and restore by using SQL server 2005/2008 tools.
Responsible for maintaining UAT (User Acceptance Testing) and Production environment.
Environment: MS SQL Server 2005/2008, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, SQL Server Analysis Services 2008, Power BI, AS400, Windows XP, Excel, Acrobat Reader, Microsoft Office SharePoint Server.
Ernst & Young, Atlanta, GA. Mar2012-June2014
Sr. SQL SSIS/SSRS/SSAS Developer
Ernst and Young has managed to remain on the top ten lists of audit companies in the fourth position for two years in a row. With current market fluctuating every now and then, Ernst and Young strive hard to provide the best and the most effective means of advisory and the best audit, tax, strategic growth service available to its clients in several industries like consumer product, government and public sector, financial services, technology, telecommunication, private equity and other industry sectors.
Responsibilities:
Interacted with Business Users and Analyzed user requirements and built reporting solutions such as relational database reports, OLAP reporting, dashboards and scorecards.
Involved in the dimensional modeling of Data warehouse using Erwin tool.
Created complex T-SQL Queries, Stored Procedures, Indexes, Functions and Views to support efficient data storage and manipulation in SQL server management studio (SSMS).
Created appropriate Triggers to assist efficient data manipulation and data consistency.
Migrated DTS Packages of SQL Server 2005 to SQL Server 2008 as per business requirement.
Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS).
Extensively used transformations, control flow tasks, containers and event handlers.
Used checkpoints to implement the restart ability of the packages in SSIS.
Implemented custom logging in SSIS using event handlers and execute SQL task.
Developed Dynamic packages using SSIS and Implemented Incremental Data Loading.
Implemented Error Logging using Event Handlers and also implemented logging in SSIS Packages in visual studio (MSVS).
Created dynamic Package Configuration of type SQL Server table.
Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
Good understanding in Data Marts and data warehousing concepts (OLTP & OLAP). Worked with Data mining and slowly changing dimensions.
Experience with logical and physical data modeling, FACT and Dimensional tables and database design using Data Modeling Tools like Erwin, MS access and Microsoft Visio.
Experience in Dimensional Modeling, Designing of STAR, SNOW FLAKE Schemas.
Involved in Analyzing, designing, building of OLAP cubes with SSAS 2008(R2) Identified and defined Fact relationships in SSAS.
Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
Worked on PERFORMANCE POINT SERVER to build advanced KPI’s for the cubes.
Involved in Troubleshooting system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
Involved in Optimization and Performance of queries and stored procedures using SQL Execution Plan.
Environment: Erwin, SQL Server 2008 R2/2012, Business Intelligence Development Studio (BIDS 2008 R2), SSIS, SSRS, SSAS, Visual Studio 2012/2010, Team Foundation Server 20012/2010, BI Xpress V4.0.0, .NET Framework, T-SQL, MS-Excel, XML, Window 2007 Server, Crystal Reports, Share Point Server 2010.
New Edge LLC, Chicago, IL
Sr. MS SQL Server SSIS/SSRS Developer Jan 2010- Feb2012
New Edge is a leading provider of enterprise manufacturing execution and quality systems. The answer was yes, no problem. Customers now have the option of doing a confident migration to SQL Server when growth and technological obsolescence of hardware forces a reexamination of IT strategy.
Responsibilities:
Created SQL Server Reports for Management using SSRS. Tasks included defining requirements, design, develop, test, implement and maintain reports using SSRS.
Developed several reports with consistent drill-down functionality including Drilldown reports, Summary reports and Master Detail reports.
Developed Custom Functions, Manual Running Totals and Complex Formulas for reports.
Used breaks, calculations, sorts, filters and sections to enhance data presentation in reports.
Created SSIS package in which records were loaded daily, also from other data resources such as Excel, Access, flat file, Oracle and XML in order to create and maintain a centralized data warehouse.
Created cube structure for the analysis of business condition and for creation of report using SSAS.
Created drill down and sub reports from SSAS cubes that can be browsed on web.
Worked on with Report Manager, Report Builder, and Reporting Security and Reporting Services Configuration manager.
Environment: MS SQL Server 2008/2008R2, SSRS, SSIS, SSAS, T-SQL, MS-Excel, XML, QlikView, Windows 7.
HDFC Bank, Hyderabad, INDIA June 2007- Mar2009
MS SQL Developer/BI developer
Housing Development Finance Corporation Limited (HDFC Ltd.) was established in 1977 with the primary objective of meeting a social need of encouraging home ownership by providing long-term finance to households. Over the last three decades, HDFC was a pioneer in leading in housing finance in India, since inception.
Responsibilities:
Created Logical and Physical data models using Erwin 4.0 data modeling tool.
Developed complex Stored Procedures, Functions, DTS (Data Transformation Service) packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
Migrated the data from various sources using DTS.
Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
Compressed data files by removing empty database pages and updating index statistics.
Developed and edited many complex reports with Crystal Reports 10.0.
Designed and implemented user log in and security.
Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
Planned the complete back-up of databases for disaster recovery (DR) scenarios.
Reorganized database structures as needed, automated procedures at regular intervals.
Optimized long running Stored Procedures and Queries for effective data retrieval.
Involved in project planning, scheduling for database module with project managers.
Environment: MS SQL Server 2000 Enterprise Edition, MS Access 2003, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2003 Server, Crystal Reports.
Contact this candidate