Sql Server Data

MADHAVI KARRA

678-***-**** ext ** / ********.***@*****.***

PROFESSIONAL SUMMARY

Dynamic Professional with 9+ years of experience in Project Design, Analysis, Development & Management using Microsoft SQL 2012/2008(R2)/2008/2005.

Hands on experience in managing, upgrading and migrating, monitoring and troubleshooting SQL Server 2012/2008(R2)/2008/2005.

Expert Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

Experience in Database Development, Modeling, Data Warehousing, Design and Technical Management.

Extensive experience with data modeling techniques, logical and physical database design.

Experience in Creating Database objects – tables, views, functions and developing procedures for implementing application functionality at the database side for performance improvement.

Created and scheduled jobs to run on a daily and weekly basis including maintenance of the jobs.

Experience in Managing Alerts, Operators and Jobs through SQL Server Agent.

Proven ability in Performance Tuning, Query Optimization.

Expert at Dimensional Modeling and ETL design. Worked extensively on ETL process using SSIS packages.

Experience in creating packages to extract data from DB2 (AS/400), ORACLE, MS ACCESS and FLAT FILES and load it to SQL SERVER using DTS/SSIS and implemented Incremental load in SSIS packages.

Very good experience in creating, deploying SSIS Packages using Team Foundation Server 2012 and migrating SSIS packages from 2005 to 2008 and 2008 to 2012.

Developing reports in SSRS. Sound Experience and understanding of SSAS, OLAP cube and Architecture.

Experience in creating snapshots of reports to reduce the load on the server.

Tailored and managed subscriptions to provide reports timely to the end users.

Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like Drill Down, Parameterized, Cascading, Conditional, Table, Matrix, Chart, Adhoc and Sub Reports.

Experience in Dimensional Modeling, Designing of STAR and SNOW FLAKE Schemas.

Experience in using Data Modeling Tools like Erwin, MS access and Microsoft Visio.

Good understanding of (SDLC) software development life cycle process methodologies and principles.

Experience in managing off-shore team.

Excellent communication and interpersonal skills, self-motivated, quick learner and determination to learn new technologies, strong team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Languages SQL, T-SQL, PL/SQL, C, XML, HTML, ASP.Net

Operating Systems UNIX, Windows 2008/2003/2000/NT, Windows 7/Vista/XP

Data Bases SQL Server 2012/2008(R2)/2008/2005, Oracle 8i/9i/10g, MS Access, DB2

DB Tools SQL Server Management Studio,

SQL Server Data Tools/SQL Server Business Intelligence

Development Studio, SQL Enterprise Manager, Query Analyzer, SQL Profiler

ETL Tools DTS, SSIS

Data Modeling Tools Erwin, VISIO 2010

Reporting Tools MS SQL Reporting services (SSRS), Crystal Reports, Microsoft Excel, Cognos,

Tableau.

PROFESSIONAL EXPERIENCES

Blue Shield of California, San Francisco, CA Sep’17 – Present

Data Developer

Working as a Data Developer on Claims Book of Record and Member Book of Record DataMart’s

Environment: MS SQL Server 2016, T-SQL, SQL Server Data Tools (SSDT), Aginity Work Bench for Netezza, JIRA.

Responsibilities:

Working on scripts to load data into COVERAGE_ELIGILBILITY_PRODUCT, PHARMACY, HEALTH_CARE_CLAIM, HEALTH_CARE_DIAGNOSIS_CLAIM, PLAN_MEMBER tables.

Understand requirements related to Start and End Dates for COVERAGE, PLAN, PRODUCT, GROUP, SUB GROUP.

Execute and update SQL scripts in Netezza environment.

Create user stories and maintain tasks in JIRA.

First Republic Bank, San Francisco, CA Jun’ 15 – Aug’17

SSIS/SSRS Developer

Worked as a SSIS/SSRS developer on Risk DataMart Project. Analyzing data related to Loans, Deposits. Created Reports and Cubes for Users based on Deposits and Loans data using SSRS/SSAS.

Environment: MS SQL Server 2012, T-SQL, SQL Server Data Tools (SSDT), Visual Studio 2010, Team Foundation Server (2012).

Responsibilities:

Worked on Data Profiling dash board, done profiling to check the Counts, Min & Max values, null values and distinct values.

Worked on Data Quality dash board to set up some business rules and if the data doesn’t meet those criteria then the erred out data will be shown in the report.

Worked on creating Alco Report which shows the sum of balances and number of accounts for Deposits based on each product across different Regions/Area. The products include Now Checking, Business Checking, Business MMA Checking, Business Savings, Money Market Checking, Money Market Savings, Passbook, Liquid CD's, Certificate of Deposits.

Created GL Variance Reports for Loans and Deposits.

Created drill through, drill down reports, parameterized reports.

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Created subscriptions/data driven subscriptions to provide timely reports to the clients and end users and deployed the reports on share point.

Worked on DataMart’s for Deposits and Loans data.

Worked on different sources for Loans like Automated Financial Systems (AFS), Installment Loans (IL), and Mortgage Loans (ML).

Worked on different sources for Deposits like Direct Deposits (DD), Checking’s (CD), Savings (SV), SunGard, Pershing, and Spectrum.

This data is available in Flat File, Excel, and Tables, integrated the data and loaded into staging tables.

Loaded the transformed data from Staging to Dimension. Performed SCD (TYPE-2) to preserve the history. Handled the TYPE-2 with Current_Flag, Effective dates.

Created bridge table to handle many to many Scenario with respect to Loans and Collateral.

Worked on multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all.

Extensively worked with different control flow tasks such as Execute SQL Task, Data Flow, Execute Package, Execute Process Task, File System Task, Script Task, Send Mail Task, Data Profiling Task and different containers like For Each Loop, For Loop and Sequence Container.

Created Package Configurations to deploy the packages from DEV/TEST/PROD and load data into different environments. Setting the Configuration files which is done in the specified tables.

Created Data Quality (DQ) Checks for Deposits/Loans.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Involved in Performance tuning and Query Optimization.

Actively designed the database to fasten certain daily jobs, stored procedures.

Created Views for different Business Units.

Supported Month end processing where the data needs to be corrected through Write back’s. The data can be a Fact record or Dimensional Record, created a WB process to implement this.

Supported Quarter end processing for 10Q/K Regions validations.

Analyzed database growth, space requirement and created User/Login Roles changing the roles of the users. Created database Backup/Restore

Created and managed the databases in development environment.

Created cubes for Month end data and Rolling 12 month’s data for Business Users/Quantitative Analyst to pull the aggregated balances and view the data in multi-dimensional format across different Product Categories/Regions/Sources.

Estes Express Lines, Richmond, VA Mar’ 13 – Apr’15

ETL/SSRS Developer

Worked as an ETL developer in Data Warehouse Project. Analyzing data related to Shipment, Manifest, Customer, Sales, Operations & Delivery and Claims. Working closely with Data Warehouse Architect, Data Modelers, Data Analysts and BI Developers to understand the Requirements. Worked on migrating the Cognos reports to SSRS.

Environment: MS SQL Server 2008R2/2012, T-SQL, SQL Server Integration Services, Visual Studio 2010, Team Foundation Server (2012).

Responsibilities:

Designed transformation rules and processes to derive the correct data from the extracted data and transform into the required format and structure to support the business requirements.

Loading the transformed data into the target database and the associated metadata into the enterprise metadata repository.

Designed various schemas which are used for Landing the data, staging for transforming the data and PROD in MS SQL SERVER 2012.

Extensively worked with Team Foundation Server 2012.

Experience in creating complex SSIS packages using proper control and data flow elements.

Created joins and sub-queries for complex queries involving multiple tables.

Used DDL and DML for writing triggers, stored procedures, and data manipulation.

Created tables, views, clustered & non-clustered indexes, user defined data types, user defined functions and CTE’s.

Worked with different sources to extract the data like Flat File, Excel, OLE DB, Raw File and loaded the data into different destinations like OLE DB, Flat File, Excel and Recordset Destination.

Worked on multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Merge Join, Derived Column, Lookup, Cache Transform and Union all.

Extensively worked with different control flow tasks such as Execute SQL Task, Data Flow, Execute Package, File System Task, Script Task, Send Mail Task and different containers like For Each Loop and Sequence Container.

Created about 25 Dimensions and 5 Facts

Pulling data on a daily basis from AS/400(DB2) using the SSIS packages.

Processing the Facts and dimensions on a daily basis using the SSIS tasks.

Partitioned Fact and Dimension data on Year and Month. Designed partition techniques to swap out latest 4 months data to load fresh data in daily run.

Performed the task of data transfer from files in remote server to folders in another server using FTP.

Created Variables, Expressions for Connection String, Project Parameters, Package Configuration, Parent package variables. Worked on Project level deployment in TFS 2012.

Worked on Slowly Changing Dimensions (Type-1 & Type-2) and Change Data Capture.

Created Junk Dimensions, Conformed Dimensions and Fact less Fact.

Created database maintenance plans and deleting of history data using SSIS packages.

Worked on migrating data from SQL Server 2008(R2) to 2012.

Actively designed the database to fasten certain daily jobs, stored procedures.

Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources.

Created packages in SSIS with error handling.

Worked with different methods of logging in SSIS.

Worked on Analysis Document, Design Document and Data Profiling.

Responsible for ETL operation using SQL Server Integration Services (SSIS) and worked with users in training and support.

Worked with HP Quality Center for writing and testing the test cases.

Worked on migrating the Cognos reports to SSRS. Worked with different tasks in SSRS like tables, charts, sub reports, List, Image and Textbox.

Created drill through, drill down reports, parameterized reports. Deployed reports to Report server.

Ellucian (HCL America), Malvern, PA Oct’ 11 – Feb’ 13

SSIS Developer

Datatel and SunGard's Higher Education group merged together to form as one company Ellucian. SunGard is a multinational company which provides software and services to education, financial services, and public sector organizations. This Project is an integration between Sales Force to SAP Financial system. In this project I worked as an SSIS developer for Sales Force to SAP Integration Project. The main task is to extract the source data from Sales Force make all the transformations in SSIS and push the transformed data into SAP IDocs.

Environment: MS SQL Server 2008R2, SSIS, Task Factory, BizTalk Adapters, Visual Studio 2008

Responsibilities:

Involved in requirements gathering, analysis, data mapping, design, development and deployment.

Established Sales Force to SSIS connection using Task Factory and worked with the tool to extract the data from Sales Force.

Established SSIS to SAP IDocs connection using BizTalk Adapters through SSIS Script Component.

Created complex Stored Procedures, Triggers, Cursors, Views and SQL Joins for various applications, maintained referential integrity and implemented complex business logic.

Extensively involved in designing the SSIS packages to extract data from Sales Force Source and push into SAP IDocs.

Constructed SSIS packages for high performance data integration solutions, including extraction, transformation and loading (ETL).

Performed mandatory field check, data validation, data transformation.

Experienced in creating SSIS packages using Script Task with Error Handling.

Experienced in enhancing and deploying the SSIS Packages from development server to production server.

Experienced in using different transformations like fuzzy lookup, conditional split, derived column transformations etc in SSIS packages.

Extensively designed the packages as per data mapping using Control flow task, Sequence container task, For Loop Container, For Each Loop Container, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

Created error handling and auditing for integrated data entities. Performed incremental loading.

Supported during the UAT phase

Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including DEV, UAT and PROD, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.

Involved in Performance tuning, query optimization and execution plan of queries for better performance.

Prepared data mapping specifications, including data flow diagrams, field level mappings and rules for multiple applications

Experience with data cleansing and resolving data quality issues

Experience working with large data repositories and/or relational databases

Support and extend existing data warehouse and business intelligence system.

Identify, analyze and interpret trends or patterns in complex data sets.

Capability to use Microsoft Access, Excel, and SQL Server for data management, data mining and data analysis.

Experience in all aspects of small to medium database design and management, including data modeling and design, data population, normalization, data mining, data validation, reporting and visualization

True Process Inc. Milwaukee, WI Aug’ 09 – Sep ‘11

SQL BI Developer

True Process Inc has a distinguished record of helping healthcare suppliers and end-users, enhance workflow, build efficiencies, cut costs and improve products. The major role was to implement, integrate and manage software and hardware solutions.

Environment: MS SQL Server 2008/2008(R2), Windows 2008 Server, TSQL, ASP.NET, MS Visual Studio.NET, UNIX.

Responsibilities:

Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for data warehousing.

Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.

Extracted the data from Oracle, Flat Files, Transformed (Implemented required Business Logic) and Loaded into the target Data warehouse using SSIS (SQL Server 2008).

Experience in enhancing and deploying the SSIS Packages from development server to production server.

Experience in using different transformations like fuzzy lookup, derived column transformations etc in SSIS packages

Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including DEV, UAT and Prod.

Experience in developing Complex cubes from scratch.

Designed cubes with star schema modeling using SQL Server Analysis Services (SSAS).

Worked on existing cubes to improve the performance.

Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.

Querying and manipulating multidimensional cube data through MDX Scripting (SSAS).

Experienced in writing MDX queries to add calculated members and measure groups.

Worked on Multidimensional Expressions (MDX) to query multidimensional data or to create MDX expressions for use within a cube.

Involved in partitioning of cubes in order to increase the performance of cubes (SSAS).

Ability to analyze and interpret data through complex analysis.

Experienced in writing complex Stored Procedures, nested cursors, CTE's.

Done lot of performance tuning for the stored procedures and SQL queries with various query optimization techniques.

Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).

Developed Queries for generating drill down, drill through reports in SSRS 2008.

Experience in creating Ad-hoc and static reports using SSRS (SQL Server Reporting Services) from BIDS.

Good understanding of Microsoft Reporting Service (SSRS) with Report authoring, Report management, Report delivery and Report security.

Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.

Migrated the existing DTS packages to the SSIS Batch jobs and enhanced the packages with monitoring features so that audit information of the packages and their execution results are loaded in to the audit table.

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.

Adeptech Systems Inc., Hyderabad, India May’ 08 – Jul’ 09

SQL Developer

Environment: MS SQL Server 2005/2008, Windows NT platform, Crystal Reports.

Adeptech Systems Pvt Ltd Off-shore development center in India is a division of Competent Systems, Inc and provides a broad range of Information Technology (IT) solutions for corporations, business and individuals in USA and India. Adeptech is specialized in Consulting, Development and Staff Augmentation.

Responsibilities:

Requirement gathering – Solution design

Actively involved in Normalization of database.

Designed DDL and DML for MS SQL Server 2005.

Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.

Created Triggers to enforce data and referential integrity

Actively designed the database to fasten certain daily jobs, stored procedures.

Optimize query performance by creating indexes.

Involved in writing SQL batch scripts.

Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL Queries and Stored Procedures.

Create joins and sub-queries for complex queries involving multiple tables.

Use DDL and DML for writing triggers, stored procedures, and data manipulation.

Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.

Involved in the migration from SQL server 2000 to 2005.

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

Perform daily database backup & restoration and monitor the performance of Database Server.

Installed and Configured SQL Server 2005 on development server for designing and testing.

Contact this candidate