Sowjanya K

Email: ac7jzf@r.postjobfree.com

Ph#: 850-***-****

Professional Summary:

Having 5+ Years of IT experience in design, development, testing, presentation, implementation and analysis of SQL Server and SQL Server Business Intelligence tools (BIDS) - SSIS and SSRS.

Hands-on working experience in Installing, configuring, upgrading and managing SQL Server 2014/2012/2008 and required Service Packs.

Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server.

Expertise in developing SSIS Packages and using data transformations and deploying them on various production servers.

Deployed a SSIS package Using XML file configuration and Environmental Variable.

Working experience on cross functional agile team consisting of backend database developers, front end application developers and quality assurance.

Proficient in creating sub reports and defining query for generating drill down reports using MS SQL Server (SSRS).

Experience in writing and tuning complex sub queries, SQL, PL/SQL, stored procedures, functions and triggers.

Expert knowledge and experience authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).

Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.

Hands on experience in designing the database model and maintain referenced relationships for the data integrity.

Expertise in creating complex Stored Procedures (Dynamic and static), effective User-Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.

Hands on experience with analyzing query plans, extended Stored Procedures, managing indexes to provide quick results for Applications.

Experience in designing SSIS Packages to extract data from various data sources such as Oracle, SQL Server, Access database, Excel spreadsheet, xml files and flat files into SQL Server 2014 for further Data Analysis and Reporting.

Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages Migration Wizard and knowledge on Storage Management.

Excellent work experience on creating packages to handle Incremental loads and slowly changing dimensions to update data in data warehouse using SSIS.

Experience in logging, Error Handling, Check Points, and Package Configuration to provide the dynamic flow off data to load data warehouse.

Knowledge of Relational Database management systems (RDMS), Schema and Data Modeling.

Experience in optimizing the queries by creating various clustered, non-clustered indexes and Indexed views.

Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.

Technical Skills:

SQL Server Tools

SSMS, Enterprise Manager, DTS, Profiler, DTA, Upgrade Advisor

ETL & Reporting Tools

SSIS, SSRS, SSAS, BIDS, DTS, Business Objects

Databases

SQL Server 2005/2008/2008R2/2012/2014, Oracle

Programming Languages

SQL,T-SQL, PL/SQL

Scripting

JavaScript, VB.NET

Tools

Visual Studio 2010 and Report Builder 1.0/2.0/ 3.0

Operating System

Windows XP/2003/2007/2010, Windows Server 2008 R2, Windows Server 2012

Professional Experience:

Client: Rent A Center, Plano, TX. Sep 17 – Till Date

Role: MS SQL Server SSIS /SSRS Developer

Responsibilities:

Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

Understand the functional requirement specifications and preparing design documentation.

Installed, configured and maintained SQL Server Integration Services (SSIS).

Deployed packages to SQL Server and file system in 2012 and also used the new Project based Deployment introduced in 2014 SQL Server Data Tools (SSDT) to deploy the 2014 packages.

Configured and deployed the SSIS 2012 projects to the new Integration Services Catalog. Set the Environment and managed configurations using the Package and Project variables.

Maintained the SSIS projects and users accessing the Catalog and SSISDB.

Scheduled and monitored the SQL Agent jobs to run these packages periodically.

Created SSIS packages to Extract, Transformation and Load (ETL) inventory and other sales data from Flat Files, Excel Files, Access, Oracle etc.

Created cascade parameterized, adhoc, drillthrough, drilldown, Graph, Chart, KPIs, linked, snapshot, sub reports, canned reports etc. using SSRS.

Integrated SSRS and Crystal Reports with .net application automatically passing the report parameters from the application and defaulting to the desired output to a certain format if required.

Created SQL Server Analysis Services (SSAS) cubes and migrated some of the existing cubes. Also created SSRS reports out of these cubes writing MDX queries to pull the data.

Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.

Implemented SQL Server SSIS packages for ETL methodologies involved in the migration from SQL Server 2008 to 2012 and 2014 and created new SSIS packages for the legacy DTS packages and scheduled and monitored the execution of the jobs.

Migrated, recreated and maintained the Legacy packages, cubes and reports.

Supported Style Sheets that contain drill down parameters and links to arbitrary URLs and embedded GIF images in report headings and footings.

Involved in building and maintaining dimensional cubes with SQL Server Analysis Services (SSAS) and used MDX script for querying the data.

Developed Business views, Report objects, Cubes for the users to analyze the data and help them in decision making.

Deployed SSRS reports to Report Manager and made a call to those reports through a URL from .Net API.

Performing Unit testing and internal QA for the developed application.

Working closely with the users supporting the existing reports and creating new reports.

Environment: MS SQL Server 2014/2012/2008R2, SSIS, SSRS, SSAS, MS Access, ETL, Visual Studio, HTML, Windows XP.

Client: PNC Bank, Tampa, FL. May 16 – Aug 17

Role: SQL Server/SSIS/SSRS Developer

Responsibilities:

Developed system standards, architecture, scenarios, detailed screen specifications and documented logical and physical data model.

Design/Build Extract Transform Load procedures in SQL Server 2014 to import/export data feeds to/from data warehouse and claim systems.

Worked on Stored Procedures and Database Triggers.

Worked Extensively with SSIS to import, export and transform the data between the linked servers.

Developed custom selection of reports ordering using SQL Server Reporting Services (SSRS).

Created multiple cubes in a database solution with multiple facts in a single cube with shared dimensions.

Created hierarchies, partitions and perspectives as and when required based on the complexity of the cube.

Processed and maintained the cubes on a schedule directly in SQL Agent using XMLA or through SSIS process task.

Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.

Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.

Created SQL Agent Jobs and scheduled the SSIS Package to run overnight. Resolved the issues associated with the job failure.

Worked with SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.

Involved in generating Drill through and Drill down reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008/2012/2014.

Prepare documentation related to database design, objects security and rules.

Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.

Defined production support document with recovery process.

Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

Hands on experience in designing SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert etc.

Used various control flow tasks like FTP, Bulk insert task, Transfer job task etc and different data flow tasks.

Create and Modify User Defined Functions, Stored Procedures, Triggers, Views according to the business requirements.

Environment: MS SQL Server 2014/12/8, SSIS, SSRS, SSAS, DB2, MS Access, HTML, XML, Windows XP.

Client: CVS Health Care, Scottsdale, AZ. Sep 15 – Apr 16

Role: SQL Server/SSIS/SSRS Developer

Responsibilities:

Designed and created SSIS packages to extract, transform and load data from Excel and Text to SQL Server destination using various complicated transformations like conditional split, derived column, and data conversion for fee schedules from the existing QNTX database.

Modified the existing packages by making changes in the stored procedures according to the requirement.

Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Implemented data mart, facts, dimensions, snowflake schema and OLAP cubes.

Generated and consolidated monthly reports and budget analysis to drive forecast production plan with SQL report services (SSRS).

Used various data flow transformations like conditional split, look up, derived column etc.

Worked with T-SQL to create tables, stored procedures and user defined functions for complex business logic.

Created and maintained databases, tables, views, users, logins, indexes, check constraints, and business rules using T-SQL.

Worked with SSIS tool suite like Conditional Split, Lookup, Multicast and Derived Column.

Used script task in SSIS to design complex SSIS packages using Java.

Involved in performance tuning for new databases and existing databases by using SQL profiler.

Created Database Objects – Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.

Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.

Created automated system in handling orders, product uploads, batch processing using Postgres RDBMS.

Connected to Postgre SQL database to create customized interface for Tableau workbooks to provide native intranet style navigation.

Used Event handlers to run send mail tasks in the background upon success or failure of a package in SSIS.

Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.

Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

Environment: MS SQL Server 2012/2008R2, SQL Server Integration Services (SSIS), SSAS, SSRS, T SQL, SQL Excel, Java, PostGres SQL, Windows XP.

Company: PENNYWISE SOLUTIONS PVT LTD, Hyderabad, India. Sep 13 – Dec 14

Role: SQL Server Developer

Responsibilities:

Designed and created different ETL packages using SSIS from Oracle source, Excel, CSV Files, Text files, MS Access to SQL server as destination.

Designed and provided Ad-hoc and Parameterized clinical reports using SSRS in SQL Server Data Tools for the internal use and client presentation.

Created Subscriptions for the users to deliver the reports in a timely manner.

Implemented Power view for the visualization of reports.

Added custom rows using Java script component transformation in the data flow task.

Built Java Scripts scripts to download the Email from the Outlook, flipped the attachments and body into separate folders and dynamically called child packages to load the data from the attachment.

Data conversions and data loads from various databases and file structures.

Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server. Used SQL Server System Tables to retrieve metadata.

Wrote many stored procedures and Triggers as per clients requirements.

Created Pivot tables in excel using data from various sources like SSRS and MS Access.

Collaborated with fellow team members through Team Foundation Server for effective project management which includes work issues and track on the update of versions.

Diagnosing and tuning the server and query optimal performance using SQL Server Profiler and Database Tuning Wizard.

Created indexes on selective columns of patient records for the faster retrieval of data in SQL Server Management Studio.

Environment: MS SQL Server 2008, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Data Tools, SQL Server Migration Assistant, SQL Server, SQL Server, Java Scripts, ETL, Windows XP.

Education:

Bachelors in Electronics and Communication Engineering Gudlavalleru Engineering College (JNTU - K) 2012 April.

Reference: Will be provided upon Request.

Contact this candidate