Sql Server Data
Resume:
Rishitha Reddy
************@*****.***
BI Developer
SSIS/SSRS
Summary
Over 7 years of strong experience in the IT industry as SQL BI Developer.
Experience in client requirement Analysis, Data Modelling, Development, Resource Planning, Coding, Debugging, Testing, Development, Supporting and Maintenance of Business application using SQL server 2012/2008 R2/2005, DB migration, DTS, SQL Server Integration Services (SSIS), and SQL Server Reporting Services (SSRS).
Experienced in designing SSIS packages extracting data from various data sources such as XML, Excel spreadsheet, and flat files into SQL Server 2008 for further Data Analysis and Reporting by using multiple transformations, scheduled, and maintained nightly and weekly loads of data by creating the corresponding job tasks.
Expertise in creating Break Points, Check Points, and use Error Handler in SSIS and automating the ETL process.
Experience in creating Tabular, Parameterized reports, Matrix, Sub-Reports, Drilldown, Drill through reports with thorough knowledge of report serving architecture.
Expert Knowledge of T-SQL in writing Stored Procedures, tables, user defined functions, views, indexes, and relational database models and data integrity.
Experience in generating periodic reports based on the statistical analysis of the data from various time frames and divisions using SQL Server Reporting Services (SSRS).
Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the database schema.
Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
Strong Experience in Creating, Configuring, Deploying SSAS Cubes, Testing SSRS and SSIS Packages.
Good understanding and background in financial services, Health Care, media, and telecom industry.
Good hands on Experience in QlikView 9/10, SQL Server, Oracle, Visual FoxPro (9.0)
Worked extensively on Extraction, Transformation, Loading data from different databases.
Good Team Player, Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment with ability to think outside of the box.
Technical Skills
Database: MS-SQL Server 2012/2008R2/2008/2005/2000, MS Access, MySQL
Operating system: Windows Server2000/2003, Windows 95/98/XP/NT, UNIX.
SQL server technologies: SQL Server Management Studio, Business Intelligence Development Studio (BIDS), SQL Server Data Tools(SSDT), Visual Studio 2005/2008 SQL Profiler, Performance Monitor, SQL, T-SQL, Index Tuning Wizard, SSIS, SSRS
Software: MySQL, Visual Studio, SQL Lite speed, PL/SQL
ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS), Import Export Data, Bulk Insert.
Reporting tools: Power bi, Tableau, Crystal Reports, Informatica
Languages: T-SQL, HTML, XML, ASP.NET, C/C++
Professional Experience
Wells Fargo, NC June 2016 – Present
SSIS/SSRS Developer
Wells Fargo is one of the largest financial services holding companies in the U.S. with headquarters Based in charlotte, N.C., the company operates 2,137 financial centers in many states, and offers a full range of consumer and commercial banking, securities brokerage, asset management, mortgage and insurance products and services. The scope of the project was to analyze the incoming data, which were at different frequencies and various sources. Build SSIS Packages to stage data, cleanse and load them into OLTP and finally into the OLAP database.
Responsibilities:
We, as IT Shared Services team involve in multiple deeds along with monitoring 33 business areas and their instances in SQL Server environment. This also includes Modeling application databases/ data warehouses, project development, leveraging the resources and other assistance needed from the clients.
Interact with new business users for requirement analysis and persuade them to opt SQL Server Suite (or) MSBI Self Service for their Application and Reporting needs.
Monitored storage and instances using Performance and Resource monitors.
Involved in making new technology decisions in space of Microsoft Business Intelligence& SQL Server.
Designed and Created Data mart for operational reporting and lead the development team.
Implemented end-to-end business solutions using full MSBI Stack 08/12, which includes SQL, Performance Tuning, ETL (SSIS), CUBE (SSAS) and Reports development.
Created Coding standards and best practices for the users/ developers using SQL Server and BI Applications.
Took big part in incident/ problem resolutions and request fulfillments.
Major accountability in SQL Server, SharePoint, and Window Server upgrade impact analysis.
Managed SQL Server and SharePoint Business Intelligence center Security.
Environment: SSRS 2008, SSIS 2008, T-SQL, Microsoft Share point, Microsoft SQL Server 2008, Visual Studio 2005, BIDS, Execution Plan, Query Analyzer, Microsoft Word 2010, Microsoft Excel 2010.
Anthem Inc, IN Jan 2015 – May 2016
SSIS/SSRS Developer
WellPoint’s Government Business Division (GBD) will begin loading all regions of active Medicare Advantage(MA) providers currently in EPDSv2 into the GBD Facets System to support member enrollment claims processing and Provider data. This project is specific to the Medicare provider data and involves converting Medicare provider data from EPDSv2 into GBD Facets.
Responsibilities:
Understanding the business requirements and designing applications to meet customer needs.
Expertise in defining the business process flow and gathering business requirements
Developed and maintained technical documentation from source to target load process and ETL development process.
Prepared Mapping Documents for Business rules and validation rules.
Involved in creating and designing packages using SSIS by using the existing tasks and transformations.
Involved in ETL architecture enhancements to increase the performance using query optimizer.
Developed SSIS Package using MS SQL Server Integration Services in such a way it loads Every day data from oracle into SQL Server database to store consistent and durable data.
Created SSIS Packages to integrate data coming from Oracle, Facet databases, Text files and Excel files.
Experience in Tidal Enterprise Solution and SQL server Agent for Job Scheduling.
Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.
Involved in testing different interfaces and web application for FACETS.
Involved in FACETS Implementation, FACETS Providers, billing, enrollment, and Claim Processing and Subscriber/Membership module.
Conducted Business validations for different FACETS modules Providers, Claims, enrollment and Membership.
Created SSIS packages for Data Conversion using data conversion transformation. Configured the loading of data into slowly changing dimensions using Slowly Changing Dimension wizard.
Extensively worked in data Extraction, Transformation and Loading from source to target system.
Implemented Event Handlers and Error Handling in SSIS packages.
Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and Functions to implement the business logic and also created clustered and non-clustered indexes.
Involved in creating high level ETL architecture for overall data transfer to OLTP, ODS with the help of SQLServer2008, 2012 Integration services.
Involved in relational database modeling like, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
Experienced in performance tuning using SQL profiler and Monitored SQL Server Error Logs and Application Logs.
Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub Reports using SQL Server Reporting Services 2014/2012/2008.
Created many complex adhoc reports like Tabular report, parameter report, drill through, and drill down and parameterized reports in SSRS and created reports subscription schedule for managers and clients.
Applied conditional formatting in SSRS to highlight key areas in the report data.
Created report snapshots to improve the performance of SSRS.
Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights by using SSRS.
Deploying SSIS packages to production systems using Deployment manifest files.
Scheduled the ETL Package Using SQL Server 2014/2012/2008R2 Management Studio and Tidal.
Responsible for unit testing, Peer testing and Integration testing of data warehouse jobs.
Prepared Unit Test Cases as per our business logic.
Environment: SQL Server 2008/2012/2014, T-SQL, Oracle11g, FACET Application, Facet Reporting Tool, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, TIDAL Job Scheduling, Erwin, SQL Profiler, MS Excel 2003, Visual Studio 2008-2010, C#, ASP.Net, Visual Team Foundation Server.
State of Michigan, MI Jan 2014 – Nov 2014
BI Developer
Responsibilities:
Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures, and triggers.
Created SSIS packages to load data into SQL Server using various transformations in SSIS.
Proficient in usage of SSIS Control Flow items (For Loop, execute package/SQL tasks, Script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot)
Extract Transform and Load (ETL) source data into respective target tables to build the required data marts.
Created Parameterized reports, Cross-Tab reports, drill down reports & Summary reports by using SSRS and designed reports using Crystal Reports. Developed new objects (i.e. Tables, Views, and Stored Procedures) in SQL server 2012 database and performed tuning and audit analysis on it.
Developed Multi-Dimensional Objects (Cubes, Dimensions) using SSAS 2012.
Experience with Analysis services 2005 and made various cubes based on the reporting requirement.
Migrated database from SQL server 2008 R2 to SQL server 2012 using utilities i.e. exp/imp and attach/detach for SQL servers 2012 features.
Environment: SQL Server 2008 R2/2012 (SSIS, SSAS, SSRS), MDX, T-SQL, Teradata, SQL Server Analysis Services, EDI, SQL Profiler, VSS, MS Excel 2003, MS Word 2003, Power point 2003, Netezza database, Crystal Reports
Brown Greer PLC, VA June 2012 – Dec 2013
BI developer
Brown Greer LLC is set of lawyers, analysts, software programmers and claims reviewers. They have the legal, organizational, and administrative skills needed to help companies, trusts, settlement facilities, attorneys, courts and government entities process and resolve multiple lawsuits or claims.
Responsibilities:
Good hands on Experience in QlikView 9/10, SQL Server, Oracle, Visual FoxPro (9.0)
Experience in ETL dev & tools. Technical & practical problem-solving of Qlikview.
Worked with the finance teams to identify the business reporting needs and studied current reporting practices outside of QlikView through pivot tables.
Participated on business requirement document preparation.
Participated in Scrum stand up meetings.
Extracted data from different database stored into QVD file, wrote load scripts and developed UI according to the requirements.
Designed, created and maintained QlikView applications.
Identified data sources and prepared data for QlikView applications.
Expertise on Administration utilities such as creation of profiles, Publication, groups, users and their security access levels.
Presented QlikView applications to various levels of user.
Having good knowledge on performance techniques and error free reports.
Extensive knowledge on reporting using various kinds of Data.
Enhance existing dashboards with new functionalities and Tune ETL scripts for better performance.
Provide support analyst when internal teams have enquiries and trained business users.
Good hands on experience in optimizing the reports, queries.
Good working knowledge on creation reports using various data providers.
Environment: BI solutions, BI environment, BI Applications, QlikView […] 9i/10g, SQL, Windows XP/2003 server, Visual Fox Pro (9.0)
Avaya Inc, GA June 2010 – May 2012
BI Developer
Responsibilities:
Designed and created SQL Databases, tables, indexes, and views, User Defined Functions, Stored
Procedures, and Triggers to support business applications.
Created Clustered and Non-Clustered indexes on tables to speed up OLTP query performance.
Worked on Exception Handling with @@error and with Try/catch and resolving locking/deadlocks.
Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL Server 2005 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge, and union all.
Involved in moving SSIS packages between various environments including Development, Test, System Test, UAT (User Acceptance Testing) and Production.
Set up jobs to schedule SSIS packages using SQL Agent.
Developed many Tablix Reports, Tabular Reports, Matrix Reports, Drill Down Reports, and Charts using SQL Server Reporting Services (SSRS).
Identified and worked with Parameters for parameterized reports in SSRS 2005.
Generated Reports using Global Variables, Expressions, and Functions for the reports.
Monitored performance and optimize SQL queries for maximum efficiency.
Tuned SQL statements (e.g.: - Using Indexes) and Stored Procedures.
Worked with various business groups while developing their applications, assisting in database design, phasing from development to QA and to Production environment.
Environment: MS SQL Server 2005/2000, SSIS, SSRS, DTS, SQL Management Studio, SQL Server Business Intelligence Tools, Windows 2003, SQL Server Query Analyzer, SQL Profiler
HDFC India Pvt Ltd, India July 2009 – May 2010
BI Developer
HDFC Bank provides different financial services. The scope of the project that I worked on was to facilitate in the maintenance and development of the application, which supported personal banking in wealth management, asset management dealing with different types of accounts and services. Was involved in both frond end and backend tasks.
Responsibilities:
Involved in Web Interface Development using HTML, DHTML and ASP.NET.
Designed DDL and DML for MS SQL Server.
Created and managed schema objects such as Tables, Views, and Indexes.
Involved in writing SQL batch scripts.
Created Stored Procedures and functions.
Created joins and sub-queries for complex queries involving multiple tables.
Created Triggers to enforce data and referential integrity.
Created various stored procedures for data manipulation and database triggers.
Scheduled and maintained routine jobs, tasks, and alerts.
Worked on Application documentation and ER Diagrams.
Involved in building and deploying applications.
Involved in Unit testing of the database objects created.
Environment: Windows NT server/2003/2003R2, C# 2.0, .NET 2.0, ASP.NET, SQL Server 2000, Enterprise Manager.
Education:
Bachelor of Computer Science – Osmania University Oct 2005 - May 2009
Contact this candidate