Resume

Sign in

TSQL, SSIS, SSRS, Data Analyst.

Location:
Seattle, WA
Salary:
100K
Posted:
October 24, 2019

Contact this candidate

Resume:

SQL BI Developer

Shailaja Guduri adan61@r.postjobfree.com

360-***-****

Professional Experience:

Over all 5+ years of experience in Programming, Development and Implementation of Client-Server Applications & Database systems using TSQL 2012/2008/2005/2000.

Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.

Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.

Expert in creating and using Stored Procedures, Views, User Defined Functions.

Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.

Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.

Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).

Experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.

Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.

Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.

Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.

Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

Technology Summary

Operating Systems: Windows NT/98/2000/XP/2003 Server, Unix, Linux.

Languages: T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, C.

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

Databases: MS Access, MS SQL Server 2000/2005/2008/2012,Oracle 8i/9i/10g.

Tools/Utility, Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler.

Reporting Tools: Excel, SQL Server Reporting Services 2012, 2008, 2005.

Other Tools: MS Office, Visio, MS Excel, MS-Project 2000.

Work Experience

SQL BI Developer April 2019 to till date

Client: Altria

Richmond, VA.

Responsibilities:

Designed and develop SSIS packages to Extract transform and load data from various data sources into SQL server.

Automating SSIS Execution using Windows Scheduler using DTExec Command.

Created logging, custom logging and error handling packages.

Grouping, aggregating, and splitting data using SSIS.

Scripting using SSIS for data cleansing, encrypting, decrypting sensitive information.

Creating Various Reports Using SSRS for analysis and managing claim processing.

Developing SSIS packages to automate different FTP’s files and emailing to different clients.

Creating Tabular reports, Matrix reports, List & Chart reports, Sub reports, Ad-hoc reports, Drill down reports according to business requirements in time restricted environment.

Creating several Complex Reports (sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarized and conditional formatting) using SSRS.

Developing, maintaining, troubleshooting and updating Reports using Ms Access.

Data Specialist,

Company: Kelly Services. May 2017 to June 2018

Client: BCBS

Chicago, IL.

Responsibilities:

Perform extracting, importing, and exporting of data in various database applications.

Performed backend research using Microsoft Access to verify providers had updated contracts with no errors

Responsible for maintaining Premier Provider database with updated Medicaid numbers

Corrected missing and invalid comp grids based on exception error that kicked out

Created scripts indicating if new Medicaid number or comp grid value needed to be added to the database and terminate old ones.

Updated the Medicaid IDs in PPW Applications with NPI Number.

Environment: T-SQL, SQL Server, MS Access, Excel, Word, DB2, PPW.

Programmer Analyst,

Company: Technumen Inc. Oct 2015 to April 2016

Piscatway, NJ.

Responsibilities:

Developed and designed the business logic based on the requirement using SQL server.

Used joins and sub-Queries for Complex queries using multiple tables from different databases.

Implemented the complex Business Logic using the stored procedures, User Defined Functions, Views, TSQL Scripting

Designed and implemented the SSRS tabbed reports based on the state templates.

Created reports on SQL server reporting services 2008.

Built reports through Report Builder 3.0 and Report Designer.

Created data driven subscriptions and managed subscriptions for anural reports for Medicaid and Medicare product.

Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database

Created several SQL reports to display data in a summary and a detailed level using stored Procedures

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.

Optimized existing stored procedures to achieve improved performance

Tuning of SQL Server Configuration (Locks, and Indexes).

Fine tuned SQL Queries for maximum efficiency and performance.

Generated necessary documentation through MS Word and Flow charts with MS Visio.

Environment: TSQL, SQL Server 2008/2012 Enterprise Edition, .NET, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML and Windows Server 2003/2008.

Programmer Analyst/ SQL BI Developer

Company: Technumen Inc. March 2015 to Sep 2015

Client: ATT.

Seattle, WA.

Responsibilities:

Interacted with business users in collecting the requirements, solving issues and making changes as required.

Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers.

Managed indexes and optimized queries using execution plan.

Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.

Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.

Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).

Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.

Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.

Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.

Upgraded SSIS 2005 packages to 2008 packages.

Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.

Created data flow tasks for logging the audit data of the packages.

Used Event Handlers to handle errors in the packages.

Deployed the SSIS Packages from development server to production server.

Used script task to produce HTML reports and mail using SSIS.

Created SSRS reports by Report designer for the users and deployed onto the report server.

Supported multiple projects at a time.

Environment: SQL Server 2008/2012 Enterprise Edition, .NET, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML and Windows Server 2003/2008.

Programmer Analyst,

Company: Technumen Inc. Oct 2014 - Feb 2015

Piscatway, NJ.

Responsibilities:

Involved in database development and creating SQL scripts. Also experience writing complex T-SQL queries to support needs from business.

Involved in Requirement Study, Development, Implementation, code Review, Validation & Testing, Deployment and client interactions.

Worked closely with customers and IT management and staff to provide application development and production support.

Responsible for Data Migration of health insurance (Action) from SQL Server 2000 to 2005 using SSIS via Microsoft management studio 2005 and writing some reports using Microsoft SQL Server business intelligence studio.

Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.

Analyzing SQL data, identifying issues, and modifying the SQL scripts to fix the issues.

Review every day applications and make sure they are accepted.

Tuned and Optimized SQL Queries using execution plan and profiler.

Environment: T-SQL, MS SQL server 2012, MS Power BI, 2008R2, EXCEL

SSIS\SSRS Developer,

Company: SRM Soft LLC. Nov 2013 - Sep 2014

Client: Anthem Inc,

Virginia Beach, VA.

Amerigroup together with well point's affiliated health plans manages funded health insurance programs we serve more than 4.5 million beneficiaries of state sponsored health plans in 19 states and we are Medicaid specialists. More than 70% of our members and CHIP plans we manage.

Developed and designed the business logic based on the requirement using SQL server.

Used joins and sub-Queries for Complex queries using multiple tables from different databases.

Implemented the complex Business Logic using the stored procedures, User Defined Functions, Views, TSQL Scripting

Designed and implemented the SSRS tabbed reports based on the state templates.

Created reports on SQL server reporting services 2008.

Built reports through Report Builder and Report Designer.

Deployed SSIS packages and Scheduled Jobs with Tidal job.

Created data driven subscriptions and managed subscriptions for anural reports for Medicaid and Medicare product.

Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.

Created several SQL reports to display data in a summary and a detailed level using stored Procedures.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.

Optimized existing stored procedures to achieve improved performance.

Environment: MS SQL Server 2000/2005/2008, MS SQL Server 2008 R2, Visual studio 2008, SSIS, SSRS, JIRA MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS),T-SQL, PL/SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.

Junior Programmer Analyst/SQL Developer

Company: Cquent Systems. Jan 2013 – Oct 2013

Fairfax, Virginia.

Responsibilities:

Performed the Creation, manipulation and supporting the SQL Server databases.

Involved in Creation of tables, indexes, sequences, constraints, functions, triggers, views and joins.

Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.

Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.

Written complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of TSQL queries.

According to the business requirements made the documentation of the performed tasks.

Extensively 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.

Managing the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.

Education

Masters in Computer Science from Virginia International University 2011 - 2012

Bachelor Degree in Information Technology from JNTU, India - 2010



Contact this candidate