Sql Server Data

SRINAGAHARSHINI CHAVA

614-***-****

***@*******-******.***

PROFESSIONAL SUMMARY:

IT Professional with extensive experience in Data Warehousing, Data architecture, design and programming experienced with multiple computing environments and a variety of project types and sizes (small to large, multi-year efforts), from business requirements to post implementation support and reviews, the complete system design life cycle (SDLC). Also extensive experience of review techniques as well as a broad knowledge of requirements definition, design, testing and implementation in the IT Development area.

OBJECTIVE:

Seeking a position to work as Lead SQL BI Developer/SQL Developer/Data Warehouse Architect for a reputable organization and to be able to exercise any skills and further enhance my career leading to greater accomplishments in the implementation of high quality software using good project management, quality processes and tools.

SUMMARY:

Around 9+ years of experience in Database Design, Development and maintenance of database applications on SQL Server 2005/2008/2012 in OLTP/OLAP environment.

As part of the team, extensively involved through the Software Development Life Cycle(SDLC) from initial planning through implementation of the projects.

Extensive hands on working experience of relational database architecture, data warehousing stages from conceptual to logical and physical design, with proficiency in data definition and data manipulation languages. Knowledge on Fact and Dimension tables.

Hands on expertise in concept to completion of business intelligence, data mart and enterprise data warehousing applications/solutions.

Experience in Performance Tuning of Data Warehouses including the creation of materialized views, bitmapped indexes and partitions.

Well versed in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Slowly Changing Dimensions(Type 1, Type 2, and Type 3) and Surrogate keys while implementing Decision Support Systems.

Expert in writing T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.

Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries, & Dynamic-queries.

Experience in developing complex stored procedures, efficient triggers, required functions, creating indexes and indexed views for performance.

Excellent experience in monitoring SQL Server Performance tuning in SQL Server 2000/2005/2008/2012 using SQL Profiler, Query Analyzer, Enterprise Manager, Index Tuning Wizard, and Windows Performance Monitor.

Expert in designing ETL data flows using SSIS, creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS.

Transformed data from one server to other servers using tools like Bulk Cop Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).

Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.

Implemented various SSIS Transformations and tasks such as Slowly Changing Dimension, Aggregate, Data Conversion, Lookup, Derived Column, Fuzzy Group and Multicast, FTP, file system, for-each loop, execute package, data flow task, custom script task, analysis services task and data mining task.

Expert in implementing and planning Server Security and authentication, Database Normalization, designing and creating indexes, Develop queries and T-SQL Scripts in MS SQL.

Expert in database activities like database creation and maintenance, Performance Monitoring, Tuning and Troubleshooting, Disaster recovery, Backup/Restore and Migration.

Experience in creating jobs, SQL Mail Agent, Alerts and schedule SSIS Packages.

Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration Wizard, and Storage Management.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Extensively worked on the ETL mappings, analysis and documentation of OLAP Cube requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.

Experience in Cube designing in Business Intelligence Development Studio (SSAS) to edit various properties of a cube, including the measure groups and measures, cube dimensions and dimension relationships, calculations.

Experience in performance tuning in large volume data and data partition.

Generated multi-dimensional cubes using MS SQL Server 2005 Analysis Services and performed drill-up, drill-down, and drill-through. Wrote multidimensional expression (MDX) queries to extract data from cubes.

Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Report using SSRS to develop Drill-down, Drill-through and Cascading parametric reports.

Administered report execution based on Caching and Snapshot as well as managed report delivery using standard and data driven subscriptions.

Capable of handling all phases of a project cycle, from planning and design through deployment and support.

Good knowledge on Power BI and SQL Azure.

Knowledge in UAT and Integration Testing.

Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

Accustomed to working in a fast paced time-frame goal oriented environment and able to deliver under pressure and time constraints.

TECHNICAL SKILLS:

Languages

SQL, T-SQL, PL/SQL. C, C++, VB 6.0,VB.net,C#.net, HTML, XML

Databases

SQL Server 2008/2005/2000/7.0, Oracle 9i/8.x, DB2 MS Access

Reporting Tools

SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9

ETL Tools

SSIS(SQL Server Integration Services), SSAS(SQL Server Analysis Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software

MS Office- 2007/2003/2000, Adobe Professional.

Operating Systems

Windows /98/2000/2003/XP/Vista, Unix.

Database Tools

SQL Query Analyzer, SWIFT Tool, ERWIN, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server

Methodologies

Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

EDUCATION DETAILS:

Bachelor’s Degree in Electronics and Communication Engineering, JNTU University (2002-2006).

PROFESSIONAL EXPERIENCE:

Oregon Mutual Insurance, McMinnville, Oregon May.2015 – Apr.2016

Sr. BI Developer

A regional insurance company that specializes in automobile, homeowner, manufactured home and liability insurance plans.

Extensively involved in business and functionality requirement analysis, understanding source systems thoroughly by preparing the design flow documentation, development and implementation.

Worked extensively with the end users team in understanding the business rules and writing technical specs and mapping documents from staging to data mart, cubes and reporting needs.

Designed and developed the logical and physical data models using ER-Studio. Created entity relationship diagrams and multidimensional data models, reports and diagrams for marketing. Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

Wrote T-SQL Queries, Dynamic Queries, Sub-Queries and complex joins for generating complex stored procedures, user-defined functions, views and cursors.

Modified stored procedures, triggers, tables and views. Re wrote processes to get data from one server and database to another databases.

Developed complex queries and database objects like stored procedures and indexed views.

Performance Tuning Database Queries, Stored Procedures, View to improve performance and scalability.

Designed and architecting end-to-end ETL process including data extraction, transformation and loading from source systems using SSIS.

Designed processes for Extract, Transform and Load (ETL) of data from legacy system to SQL Server using SSIS.

Importing Flat file (with different delimiters like comma, tab etc.) into the SQL Server 2008 Database tables using BIDS.

Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, Data Validation Checks during staging, before loading the data into the data warehouse.

Developed SSIS packages with various tasks like - FTP, file system, for each loop, execute package, data flow task, execute SQL task, custom script task, data mining task. Optimized SSIS packages by using various techniques such as use of non-blocking, synchronous communication nature transformations, optimizing sources as well executing packages in parallel.

Experience in using SSIS tools like Import and Export wizard, package installation and SSIS package designer. Transformed data from one server to another server using Bulk Copy Program (BCP), and SQL Server Integration Service (SSIS) 2008/2012.

Highly efficient with writing parameterized queries, drill through reports and SQL Server Reports in SSRS.

Proficient and efficient with the Visual Studio 2015 team Foundation Server Tool (TFS).

Created spreadsheet reports using Power query tool, pulling data from different data sources for the senior level management.

Created components, tools, techniques, methods and procedures used in an on On-Line Analytical Processing (OLAP) environment for accessing and translating data into understandable and usable business information using SSAS.

Migrated and recreated existing Dimensions and Cubes using Star schema on server to achieve the efficiency of SSAS.

Created reports with Analysis Services Cube as the data source using SQL Server 2005/2008 reporting services.

Extensive knowledge in SSAS storage and partitions, and aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.

Designed and developed SSAS databases and OLAP cubes used in ad hoc analytic research and automated reporting.

Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.

Involved in developing and modifying VB and XML reports for exporting the reports to web application.

Created new XML tags in order to execute new business rules.

Created SQL Agent jobs to run at a specific time to carryout different purposes e.g. populating a table for report purposes, generate reports for the management etc.

Detected bottlenecks, trouble shooting and tuning of mappings, queries, sessions for better performance and efficiency.

Perform Unit tests, Integration testing and validated results with Functional lead and providing technical guidance to ETL team.

Created expressions in SSRS to provide flexibility to users by providing them with variety of options for seeing the business information in tables/charts etc.

Creating data sources and subscriptions for SSRS reports.

Environment : SQL Server 2012/2008R2, BIDS, SSIS, SSAS, SSRS, Erwin, Power Pivot.

Bank of America, Agoura Hills, LA,CA Sep.2014 – Apr. 2015

BI Developer

The Artificial Intelligence department of Bank of America Home Loans specializes intelligent middle tier services such as automated underwriting, property valuations, business rules, access to credit report ordering and retrieval.

Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Modeling SQL Server database Entity Relationship diagram using the E/R Studio which serves as the central repository for information.

Analyzed and reorganized several complex stored procedures spanning over a thousand lines to reduce complexity and improve performance.

Creating and managing schema objects such as tables, views, joins, clusters, indexes, functions, procedures, triggers and maintaining Referential Integrity.

Diagnosed SQL performance issues by reviewing the execution plan. Then making changes such as updating statistics, incorporating new indexes, using temp tables, CTE and breaking joins into smaller components.

Highly proficient and efficient with the Team Foundation Server Tool (TFS), Element Tool (ET) and code delivery process to client.

Analyzed different heterogeneous sources like DB2, Excel, Flat Files and SQL Server for ETL strategy that needs to be implemented with the help of SSIS packages.

Involved with data cleansing operations using SSIS transformations and T-SQL scripts to normalize the data and remove and identify potential problem points when moving information into a data warehouse.

Implemented proper package configuration features and finally securing the packages by using password and encryption methods.

Responsible for the management and migration of SSIS packages in the staging and pre-production environments.

Converted Data transformation Services(DTS) application to SSIS as assigned.

Managed very large reports that return a large volume of records and optimized their performance using techniques like cascading parameters and filters.

Used SSIS using slowly changing dimension (type I, type 2 and type 3) for updating and inserting of records into data warehouse dimension tables.

Used Fuzzy Lookup transformation to perform data cleaning tasks such as standardizing data, correcting data, and providing missing values.

Experience of Data Marts, Data Warehousing, Operational Data Store (ODS), OLAP, Star Schema Modeling, Snow-Flake Modeling, Fact and Dimension Tables using MS Analysis Services.

Involved in Analyzing, designing, building and testing of OLAP cubes with SSAS and in adding calculations using MDX.

Worked with SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models.

Used SQL Server Analysis Services to create cubes for multidimensional features and involved in designing CUBE and wrote MDX queries.

Created Drill-through targets to another report using SSAS and defined data source, data source views, dimensions, measures, hierarchies, attributes, calculations, KPIs, actions, perspectives, translation, and security roles.

Defined calculations which involve calculated members, named sets, and other script commands to extend the capabilities of a Microsoft SSAS Cube.

Automatically created groupings of attribute members based on the distribution of the members within the attribute hierarchy.

Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical and free form reports from multiple data sources (relational and multidimensional) using SSRS.

Scheduled the delivery of reports in different formats such as PDF, Excel, using standard and data driven subscriptions in SSRS to generate all daily, weekly, monthly and quarterly reports including current status.

Created Sub-Reports, Drilldown-Reports, Summary reports, parameterized reports, cascaded reports in SSRS by linking aggregate data to support summarized view as well as detailed view.

Used different layout such as Matrix, tabular, chart, tablix to display data in a grid format, with layout possibilities ranging from simple tables to advanced matrices.

Enhanced the old Excel files and Crystal Reports to new SQL Server Reports to fit new business requirement and implemented into SQL Server.

Created different schedules for report delivery to e-mails and shared directories; enabled snapshots, subscriptions, caching to improve the response times and reduce traffic to the report server.

Designed and created Report templates, bar graphs and pie charts based on the financial data.

Generated reports using SSRS which were send to different Primary Vendors, Clients, and managers.

Used Power Query to combine and refine data within the interface for better visualization.

Created reports using Global Variables, Expressions and Functions using MS SQL Server Reporting Services.

Used Report Manager for setting up roles and security on the reports.

Maintained user/groups access and security permissions in accordance to policies and procedures.

Involved in performance tuning SQL statement and Query optimization and performed SQL queries extensively to test the data warehouse.

Performed daily tasks including backup and restore by using SQL Server tools like SSMS, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Designed Test cases and implemented Unit and Integration Test Cases using Team System and Custom Test Classes.

Coordinating post-implementation events such as Deployments, testing and validation of Scripts.

Worked closely with the Application team to understand business requirement and develop Database objects or Procedures to meet the new requirements.

Environment : SQL Server 2008R2, BIDS, SSIS, SSAS, SSRS, Erwin, DB2, Flat Files, Excel, Power Query, DTA, SharePoint.

Bupa (Depoel), Liverpool, UK Mar.2012 - Jun.2014

Lead/BI Developer

International medical insurance plan designed for local healthcare system providing various options with prompt access to diagnosis, treatment and specialist support services depending on the chosen coverage.

Worked as a lead database and SQL developer, did extensive work on creating partitions on tables, creating relational databases.

Created SQL server jobs on SSIS packages to automate the execution of the packages at a particular time depending on requirements.

Worked closely with the client to analyze the business requirements in the user stories and advise accordingly from database perspective.

Worked extensively with the Business Analyst using the Rally to create user stories bases on the business requirements.

Reengineered data models and database design, wrote backend SQL scripts for table/view creation/alteration, stored-procedures/functions, and sequences.

Created logical and physical database design, data structures and maintained it by using SQL tools like Stored Procedures, User Defined Functions, Views, T-SQL Scripting for complex business logic.

Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.

Optimized the database by creating various clustered, non-clustered indexes and indexed views.

Created and modified stored procedures, Triggers, Tables, Views and also making use of Merge statements instead of cursors in T-SQL.

Designed and created packages using Business Intelligence Design Studio, organized them in Solutions and Projects. Created packages mapping data from various sources like MS SQL Server, Flat Files, MS Access, and Excel, to load and integrate the details to warehouse

Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, recovery and Disaster recovery procedures. Planned the complete Back-up of various databases for disaster recovery scenarios.

Developed Analysis services project. Responsible for identifying and defining data source and data source views. Created cubes and defined the dimensions.

Defined attribute properties in a parent child dimensions. Responsible for hiding and disabling attributes hierarchies.

Defined relationships between dimensions and measure groups. Involved in the design and development of the cubes and MDX queries.

Designed cubes with star schema using SSAS.

Involved in Analyzing, Designing, building and Testing of OLAP cubes with SSAS and in adding calculations using MDX.

Installed/upgraded and configured applications within a Microsoft Server IIS environment.

Create reports in Power BI preview portal utilizing the SSAS Tabular via Analysis connector.

Used DBCC to check database conditions, fix database corruption, rebuild indexes and stability.

Worked with SQL Server Management Studio to manage storage and execution of deployed packages and used the packages as direct data sources for Reporting Services.

Created report using SQL Server 2005 Reporting services and defined data source, data source views, security roles

Designing packages, organizing them in Solutions and Projects, debugging them, and managing source and version control for multi-user projects using the SQL Server Business Intelligence Design Studio.

Built Ad hoc reports and added drill through functionality using report builder, and created tabular, matrix, graphical and free form reports from multiple data sources (relational and multidimensional) using SQL Server 2005 Reporting Services.

Created reports using Report Model Project, Report Server Project, and Report Server Project Wizard.

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 (SSRS).

Managed and created different reports in HTML, PDF, Excel, CSV formats and aggregated and summarized data using controls and expressions

Generated reports using SSRS which were send to different primary vendors, clients, and managers.

Diagnosed inefficient processes using SQL Profiler to monitor the Database engine and implemented indexes and rewrote SQL code to improve performance.

Environment : MS SQL Server 2005/2008, SSIS, SSAS, SSRS, BIDS, TFS, SQL Profiler, Windows Server, Microsoft Access, Power BI, SQL azure.

Danni (QBE UK), Manchester,UK Jul.2010 – Feb.2012

BI Developer

Danni is one of the world’s advanced web enabled extended warranty administration systems. It is the QBE’s online insurance portal.

Worked as a lead developer and also worked extensively on SSIS packages for extracting the data of the file system and transformed that data and load it into OLAP.

Gathered system requirements through end-user collaboration.

Created functional specification of the requirements as listed in the product requirement documents.

Developed and created Logical and Physical database architecture using Erwin Data Modeler.

Facilitated data retrieval and manipulation through implementation of views, procedures, triggers and cursors.

Created database objects like User Defined Stored Procedures, Triggers and UDFs to be used for ETL, Audit and Maintenance tasks.

Analyzed and tuned complex queries/stored procedures in SQL Server 2008 for faster execution and developed database structures.

Designed, developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server 2008.

Imported data from MS Access, MS Excel and Text Files to SQL Server 2008 using SSIS.

Provided back-end support for functional testing and performance testing.

Created several dashboards and scorecards with key performance indicators in SSAS.

Created time dimensions on OLAP cubes.

Designed SSIS Packages to extract, transfer, load(ETL) existing data into SQL Server from different environments for the SSAS cubes.

Understanding OLAP process for changing and maintaining the warehouse, optimizing dimensions, hierarchies and adding the aggregations to the cube.

Performed documentation for all kinds of reports and DTS and SSIS packages.

Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.

Worked on Database administration and schema design for PostgreSQL and MS SQL Server.

Enhanced the performance of the cubes by creating perspectives, KPI's, Translations and Calculated members.

Involved in writing MDX scripts for the OLAP cubes.

Creating static reports using MDX queries and creating MDX base report definition.

Designed and developed OLAP cubes and worked on storage and partitions, and aggregations, calculation of queries.

Scheduled delivery of several reports to multiple users through the use of subscriptions in several different formats like Excel, PDF and Text.

Accountable for data quality & analysis using & excel data parsing using macros, lookup functions and pivot tables.

Environment : SQL Server 2005/2008, SSIS, SSAS, BIDS, Erwin, Visual Studio 2008, Profiler, Excel, Power Pivot.

Cardinal Health Group, Hyderabad Jan.2009-Jun.2010

India

BI Developer

Cardinal Health is a leader in technologies and services that help hospitals manage all medications from the moment they arrive until they are administered to the patient; store and track specialty supplies; and identify and prevent hospital-acquired infections. The scope of the project was a CRM based inventory-management service and application provided by cardinal health which enables customers to track their orders and manage the inventory by reports provided based on business. The project requires Extract and loading data to data warehouse, creating reports.

Implemented triggers and stored procedures and enforced business rules via checks and constraints.

Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.

Built efficient SSIS packages for processing fact and dimension tables with complex transformations and type 1 and type 2 changes.

Defined the logging process for all the packages, populated it with entries like inserted records, updated record and error record.

Created SSIS packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Conditional Split, Term Extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.

Performed data transfers using BCP and BULK INSERT utilities.

Designed dimensional modeling using SSAS packages for end user and creates hierarchies in dimensional modeling.

Enhanced the performance of the cubes by creating perspectives, KPI's, Translations and Calculated members.

Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, data mining models, developing reports using MDX and SQL.

Worked on querying data and creating on-demand reports using Report Builder in SSRS reports and send the reports via email.

Developed complex stored procedures and views to generate various Drill-through reports, Parameterized reports and linked reports using SSRS.

Created Cross-Tab, Drill-down and Sub-Reports using RDL. Promoted RDLs to reporting service server.

Environment : SQL Server, BIDS, SSIS, T-SQL, SSRS.

Hill Dickinson LLP. Apr.2007-Dec.2008

Hyderabad,India

SQL/Report Developer

An in-house developed HD to replace the Arista Case Management system which currently holds case detail information for clients and matters managed by the firm across all business units.

Created complex Stored Procedure, Triggers, and Cursors, Tables, Views and other T-SQL JOIN techniques.

Developed complex SQL code using complex Joins, Group By, Having, Sub Queries, Correlated Sub Queries, Functions, User Defined Functions.

Involved in creating the constraints, rules, defaults, and triggers to maintain the data and referential integrity.

Created database objects - tables, indexes, views, user defined functions, cursors, triggers and indexes.

Extensively involved in knowledge transfer for the documentation team for the development activities carried out by team.

Responsible for SSIS activities to move data from text files to SQL Server.

Scheduled SSIS packages daily and weekly basis.

Generated Daily, Weekly, and Monthly reports as per the customer requirements using subscriptions and created Tabular Reports, Cross Tab Reports, Sub Reports.

Created drill down and drill through reports.

Created AD-Hoc reports using report builder and maintained report manager for SSRS.

Extensively involved with the development team in carrying out the Unit testing of the applications and tuning of complex procedures.

Involved in Planning, Development, and Testing of disaster recovery strategies and procedures to restore the production environment to a production state.

Environment: SQL Server 2000/2005, windows XP/2000, Excel, SSIS, SSRS.

Contact this candidate