Sql Server Data
Resume:
Giridhar P
****.*******@*****.***
Professional Summary:
Over 7 years of experience in Microsoft SQL Server and 5+ years extensive experience in Microsoft Business Intelligence Tools – SSIS, SSRS, SSAS, etc. in various domains financial, insurance, healthcare, and banking.
• Hands on in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and Documentation.
• Experienced in developing Logical and Physical data models using data modeling tools such as Erwin and MS Visio.
• Extensive experience with Transact-SQL coding in creating complex stored procedures, functions, views, indexes, user profiles, relational database models, data dictionaries, data integrity and appropriate triggers to assist efficient data manipulation and data consistency.
• Well versed in Normalization/Demoralization techniques for optimum performance in relational and dimensional database environments.
• Experience in managing alerts, operators and jobs through SQL Server Agent.
• Expert in developing Data Marts, Data warehousing, Operational Data Store (ODS), calculation scripts, data matrix, OLAP, Star Schema Modeling, Snow-Flake Modeling, facts, dimensions, partitions, Tables using MS Analysis Services 2008/2005.
• Experienced in Dimensional Data modeling, SSAS Performance Tuning, Cube Partitioning, MDX Scripts and formulas, Refresh Strategy and Planning.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions in SSAS.
• Skilled in building hierarchies and using mining structures in SSAS.
• Proficient in optimizing the cube for better query performance.
• Adept in designing Stylish Report layout and having Proficiency with drill down reports in SSRS 2005/2008.
• Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008.
• Experience in creating dashboards, scorecards and building reports using performance point server 2007.
• Expert in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamic reports and other features of reporting services.
• Experience in integrating the SSRS reports into web applications using Report viewer control, URL methods and creating data driven subscriptions to different users using Report Manager.
• Knowledge on integration of BI suite of products with Microsoft Office range of products like MOSS (SharePoint), Business Scorecard Manager, Dashboards, Performance Point Server.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loading from OLTP systems to ODS and OLAP systems.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS, SSIS, BCP & Bulk Insert utilities.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experienced in handling Slowly Changing Dimensions while loading data into data warehouse. Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Experience in handling Database Consistency Checks using DBCC Utilities, and in using Distributed Queries using Linked Servers.
• Extensive knowledge in database maintenance, SQL query optimization & performance tuning using performance tools like SQL Profiler, Index Tuning Wizard Database Engine Tuning Advisor.
• Experience in source control tools like Visual Source Safe, Team Foundation Server.
Technical Skills:
Databases MS SQL server 7.0/2000/2005/2008, Oracle, Teradata, Mysql, MS Access
SQL Server Tools SQL Server Management Studio, BIDS (SSIS, SSAS, SSRS), SQL Server Query Analyzer, SQL Server mail service , DBCC, BCP , SQL Server profiler
Languages C, Java, C#, VB .net, ASP.net XHTML, XML, SQL, T-SQL, PL/SQL
Operating Systems Windows 95/2000/2003/XP/VISTA, Windows NT, UNIX
ETL Tools Data Transformation Services (DTS),SQL Server Integration Services (SSIS)
OLAP/Reporting Tools SQL Server Analysis Service(SSAS), SQL Server Reporting Service(SSRS), MDX, Crystal Reports 9/10/XI, Business Objects 6.x, Cognos
Scripting Languages Java Script, jQuery, Shell, Perl, VB Script
Other tools Toad, VSS,TFS, Erwin, MS Visio
PROFESSIONAL EXPERIENCE
Wintrust Financial Corporation, Chicago, IL Apr 11 - Present
Sr. SQL Server BI Developer (SSRS/SSIS/SSAS)
Description:
Wintrust Financial Corporation is financial services holding company engages in the business of providing traditional community banking services, wealth management services, commercial insurance premium financing, mortgage origination, short-term accounts receivable financing, and certain administrative services, such as data processing of payrolls, billing and treasury management services. My responsibilities include design and deploy SSIS packages to load Data Warehouse incrementally (ETL), design and deployment of SSRS reports, implement client level security on reports, design and development of OLAP Cube, creating OLAP reports, scorecards and dashboards from the cube
Responsibilities:
• Created complex stored procedures for complex reports developed using SSRS 2008.
• Implemented client level security on the reports using Reporting Services Security extension features.
• Integrating SSRS reports with ASP.net web application and SharePoint server.
• Wrote several stored procedures using Dynamic SQL to implement common filters on all the SSRS reports.
• Created different kinds of Charts using SSRS 2008.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Created Standard Subscriptions and Data Driven Subscriptions using SSRS 2008.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Extensible reporting skills using the new features in SQL Server 2008 Reporting Services R2 (SSRS).
• Migrated reports on SSRS 2005 to SSRS 2008 server by restoring ReportServerDB and encryption key.
• Design and developed a process to disable the applicable subscriptions in case of current ETL load failure and resent them after successful completion of ETL load.
• Created an Application to allow users to run SSIS packages from the front end on demand.
• Created SSIS packages to validate, extract, transform and load the data into Data Warehouse incrementally, and process Analysis Services Cube to store data to OLAP databases.
• Successfully implemented slowly changing dimensions and Inferred members during the Data Warehouse load.
• Created Event Handlers at package level and task level for auditing by logging the events into a table.
• Involved in daily loads (full & incremental) into staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Applied various data transformations like Lookup, merge join, aggregate, multicasting, conditional split, pivot, derived column, etc.
• Created package configurations for dynamic connection string to enhance the ease of package deployment in testing and production servers.
• Configured Dynamic Checkpoints to allow rerunning a package from the point of failure.
• Designed and developed SSIS Packages to import and export data from MS Excel, Oracle, SQL Server, MS Visual FoxPro and Flat files.
• Maintain existing ETL processes and trouble shoot issues as they arise.
• Designed and developed a new data mart and business intelligence using multi-dimensional models - star schema and snow-flake schema.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Designed calculated measures using multi-dimensional expression (MDX), mathematical formulas and user-defined functions.
• Defined Key Performance Indicators (KPIs) in accordance with the requirements using SSAS.
• Created partitions, design aggregations for fact tables.
• Optimized the query performance on cube by following the recommended best practices.
• Experienced in analyzing multidimensional cubes in SSAS by using slicing and dicing, drill down, drill up, and drill through.
• Created score cards and dash boards in using Performance Point Server and deploy them on to SharePoint portal.
• Created data models with Report Builder 2.0 to provide a template for end-users for creating reports by themselves with pre-selected group of relational tables.
• Used Expressions, Functions and wrote custom code using VB.Net for the dynamic sorting, dynamic visibility and dynamic columns using SSRS 2008.
• Extensive testing on the performance of the stored procedures.
• Improved the performance of the cube by creating attribute hierarchies, Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Experienced in writing complex MDX queries for calculated members and measure groups (SSAS).
• Experienced in creating complex OLAP Reports on Analysis Services cubes (SSAS).
• Created Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Performance Point Server 2007, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003/2008.
Rising Medical Solutions, Inc., Chicago, IL Dec 09 – Mar 11
Sr. SQL Server BI Developer (SSAS/SSIS/SSRS)
Description:
Rising Medical Solutions, Inc. is a national medical cost containment and care management organization that services the auto workers compensation, and liability markets.
Responsibilities:
• Worked with Data Modeling and handling OLTP Databases and ability to design databases upon requirements.
• Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
• Created and Configured OLAP Cubes (Star Schema and Snow flake Schema Modeling) using SSAS 2008 and created calculated members using MDX and dimensions design and scaling to large numbers of users.
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Experienced in writing complex MDX queries for calculated members and measure groups (SSAS).
• Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
• Identified Key Performance Indicators (KPI) and Metrics for Business needs in SSAS 2008.
• Designed and implemented Dashboards and Scorecards with business KPIs using Performance Point Server and published them Via Microsoft Office Share point Server (MOSS).
• Developed a High level dashboard using SSRS 2008.
• Created different graphs like Pie charts, Bar charts, line charts.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Created Report Subscription and Data Driven Subscription using SSRS 2008.
• Created Report Snapshots and Report caching to show the data changes over time.
• Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
• Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
• Deployed the generated reports directly on Share Point Server.
• Involved in creating report models and applying row level security filters for report model.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
• Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard. Also implemented checksum SCD method to load the data into date warehouse.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Involved in documentation of the Reports, Database, and SSAS packages.
• Advised optimization of queries by looking at Execution Plan for better tuning of the database.
Environment: SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.
Aviva Insurance, Des Moines, IA Feb 08 - Nov 08
SSAS/SSIS/SQL Developer
Description:
Aviva USA is part of Aviva plc, is the fifth-largest insurance group in the world. One of the fastest-growing U.S. life insurers, Aviva USA offers a competitive portfolio of long-term savings, insurance and retirement income products designed to help customers make the most out of life.
Responsibilities:
• Knowledge in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS) 2005.
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Developed complex SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs.
• Experienced in analyzing multidimensional cubes in SQL Server Analysis Services (SSAS) 2005 by using slicing and dicing, drill down, drill up, and drill through.
• Experienced with writing MDX which multi dimensional queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
• Defines Calculations, Key Performance Indicators (KPIs), Actions, Perspectives, Translations, and Security Roles in SSAS 2005.
• Created Partitions, Calculated Members, Schemas, and File Groups for Fact Tables and Cubes.
• Created several Dashboards and Scorecards with Key Performance Indicators (KPI) in SQL Server 2005 Analysis Services (SSAS) using ProClarity and published via Windows Share Point Services.
• Designed and developed various Reports on SSAS Cubes as the data source.
• Generated specifications for analysis reports by using SQL Server Reporting Services (SSRS) 2005.
• Scheduled report subscriptions, publishing and set up SMTP for automated email generation with report links and schedule jobs and roles using SQL Server Agent.
• Designed SSRS reports with sub reports, expressions and queries, and preparing Ad-Hoc reports through report builders.
• Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS 2005.
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Designed dynamic DTS Packages for Landing-Pad to transfer data between servers, load data into database, and archived data file from different DBMS.
• Migrated objects to SQL Server Integrated Services (SSIS) environment.
• Used Caching (Cache Technology) for fast retrieval of data to generate reports against data warehouse.
• Participated in developing Logical design of database incorporating business logic and user requirement and building entity relationship (ER) diagrams.
• Experienced in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS) 2005.
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Written DDL / DML Triggers as per the requirements.
• Experienced in SQL joins, sub queries, tracing and performance tuning for better running of queries.
• Experience with Data migration utilities (Import & Export, BCP, Bulk Insert) from text to SQL Server.
Environment: MS SQL Server 2005/2000, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, C#, VB, Visual studio2005, Erwin, Windows Server 2003.
Fifth Third Bank, Cincinnati, OH Jul 07 – Jan 08
SQL Server BI Developer
Description:
It is one of the nation's leading financial institutions, lending and investment services to individual consumers, as well as to small businesses. It maintains users checking and saving account information, allows users to make a payment, transfer funds and customize reports for users and bankers. It also consists of web-based application, which was developed, in ASP as a front end and SQL Server as a backend database.
Responsibilities:
• Involved in designing high level dashboards according to business requirement using SSRS 2005.
• Expertise in creating Reports, Sub Reports, drill down reports using various features like Charts, graphs, filters etc.
• Experienced in developing stored procedure driven reports, building custom application on reports, formula writing/editing in reports, Report Administration and performance tuning of reports.
• Created report models for ad-hoc reports using SSRS 2005
• Developed reports from OLAP cubes using ProClarity and SSRS 2005.
• Designed and developed Reports, Sub Reports, Data driven subscriptions, drill down reports and drill through reports using various features like Charts, graphs, filters etc.
• Created Drill-through, Drill-down, Parameterized, Cross Tab, ad-hoc and Sub-Reports using Report Designer and Report Builder based on the requirements.
• Defined report layouts for formatting the report design as per the need.
• Designed and created Report templates, bar graphs and pie charts based on the financial data.
• Formatted the reports using Global variables, Expressions and Functions using SSRS 2005.
• Generated periodic reports based on the statistical analysis of the data using SSRS 2005.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Created data driven subscriptions for different users using Report Manager.
• Configured Snapshot replication for reporting, user acceptance test and development servers.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS.
• Migrated data between different heterogeneous sources such as flat file, Excel and SQL Server 2005 using SSIS, BCP and Bulk Insert.
• Designed DTS/SSIS packages to export and import data from SQL Server to MS Access , Oracle10g, text files and Excel files.
• Used SSIS transformation for Data Cleansing to remove unnecessary columns, eliminated redundant and inconsistent data and Unnecessary Data like removing empty rows.
• Created the automated process for the activities such as database backup processes and SSIS packages run sequentially using SQL Server Agent job.
• Managed up gradation of DTS packages to SSIS packages.
• Responsible for developing, monitoring and deploying SSIS packages.
• Configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Developed and created new database objects including tables, views, indexes, triggers, stored procedures and functions, also updated statistics using Query analyzer and Enterprise Manager on the existing servers.
• Wrote and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.
• Managed index statistics, Tables, Views, cursors and optimizing queries by using execution plan for tuning the database. Implemented different types of constraints on tables.
• Developed backup/restore and recovery procedures, performing weekly backup databases by using SQL Server 2005 and restoring these databases in different server.
Environment: SQL Server 2005/2000 Enterprise Edition, SSRS, SSIS, C#, ASP.NET, ADO.NET, Oracle 9i/ 10g, MS IIS, Windows 2000/2003 Enterprise Server, XML, MS Excel, MS Access, MS Visio 2003, and Visual source safe (VSS).
Satyam Computer Services Ltd, Hyderabad, India Jul 04 – Jun 07
SQL Server Developer/Software Programmer
Description:
Satyam Computer Systems Limited is a provider of information technology (IT) services. The Company delivers a range of IT services through globally integrated onsite and offshore delivery locations primarily in India. It offers its services to customers through industry-focused practices, including insurance, manufacturing, financial services, healthcare and telecommunications, and through technology-focused practices.
Responsibilities:
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
• Wrote database triggers in T-SQL to check the referential integrity of the database.
• Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
• Created reports from database onto excel spread sheet using DTS.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting Services.
• Created subscription for the windows file share and implemented three layer securities for the reports, SSRS website and in the Intranet web application.
• SSIS Packages are created to export and import data from CSV files, text files and Excel files.
• Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
• Involved in creating maintenance plans in SQL Agent to backup the database.
• Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
• Worked with development teams in the design of physical databases and in modification.
• Developed web based ASP.NET internet applications.
• Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.
Environment: SQL Server 2000/2005, Windows Enterprise Server 2003, BizTalk Server 2004, IIS 6.0, MSMQ, C#, ASP.NET, Rational Rose Enterprise, Erwin.
EDUCATION & CERTIFICATIONS
• Bachelor of Technology, JNTU, Hyderabad, India
• Microsoft Certified in Business Intelligence-Implementation & Maintenance using MS SQL server 2005(MCTS 70-445).
Contact this candidate