PROFESSIONAL SUMMARY

*+ Years of experience in IT, Financial and Healthcare environments with primary skill on the Analysis, Design, Development and Support of Client/Server application using Microsoft SQL Server 2012,2008, 2005, and BI suite.

Experience in the IT industry with the .NET Framework using C#, ASP.NET, ADO.NET.

Experience with Microsoft TEAM Foundation Server for Code Repository, Deployment and Version control

Worked on retrieving and manipulating data with Teradata Structured Query Language using ANSI Standard conventions and Teradata extensions on Teradata SQL Assistant.

Worked on Data Analysis Expressions (DAX) functions, operators, and constants that can be combined to build formulas and expressions in Power Pivot for Excel.

Hand on experience in designing complex reports using Cascading parameters, Drill-Through Reports, Parameterized Reports, Sub reports and Ad-hoc reports using Power BI

Expertise in use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Data Cleaning, Relational Database models and Data integrity, and SQL joins.

Extensively Monitored Performance with multiple tools like SQL Profiler, Event Viewer to achieve

Experience in ADO.NET components such as Data Connection, Data Command, Data Readers, Datasets and Data Adapter

Highly Experience in MS SQL Server 2005/2008, Business Intelligence in MS SQL server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS)

Hands on experience in working with XML, CSS, HTML and DHTML.

Experience in UML Use Case Diagrams, Class Diagrams and ER-Diagrams using Rational Rose.

Hands on experience in Creating advanced UI layout, polishing the UI with styles, templates and custom UI.

Experience in designing and branding Master Pages utilizing Server Controls, User Controls, Data Grid control, Form Validation controls, Custom controls and CSS.

Strong exposure in Database Design, and Database Programming (Views, Stored Procedures,) using SQL Server

TECHNICAL SKILLS

Databases: SQL Server 2000/2005/2008/2012, Teradata 14.0, Oracle 11g/10g

Database Utilities: Query Analyzer, SQL Server Configuration Manager, Business Intelligence Development Studio, Database Engine Tuning Profiler, SQL Server Data Tools

Tools: UML, Export & Import (DTS), SQL Server Data Tools, SSIS (Integration Services), SSAS (SQL Server Analysis Services), SSRS (SQL Server Reporting Services),Power BI

Languages: SQL, PL/SQL, C/C++, C#, T-SQL, XML, HTML, ASP.Net, .Net Framework 4.0

Operating System: Windows Server 2000/2003, Windows NT/98?XP/Vista, UNIX, Power Pivot

PROFESSIONAL EXPERIENCE

Community Health Plan of WA, Seattle, WA Mar 2018–Present

Developer

Responsibilities:

JIVA Project – JIVA population Health management solutions referred as JIVA is an integrated population health management solution that helps to improve care quality, lower cost, provide individualized care. JIVA supports portal services that connect stakeholders such as provider, members and clients together for a collaborative process.

Roles and Responsibilities:

Designing, Developing reports in MS SQL Server environment using Microsoft visual studio 2008.

Developing SSIS packages to load the data from tables to Text files, Excel files and CSV file.

Using SSRS to create Sub-reports, drill-down, drill-through and parameterized reports.

Working with T-SQL to create Tables, Functions and Stored Procedure.

Migrating data from Heterogeneous data sources (Excel, Flat file, CSV file) to centralized SQL server database using SQL server integration services (SSIS) to overcome transformation constraints

Creating packages to transfer data between OLTP and OLAP database using Lookups, Derived columns, Condition Split, Execute SQL Task, Data Flow task, Execute package task etc.

Working on Extracts, transforms and loading data (ETL) between Homogenous and Heterogeneous System using SQL tools (SSIS).

Extensively working on sub-query, correlated sub-query, complex stored procedure and encapsulated Ad-hoc TSQL statements into store procedures for optimization

Creating SSIS log files and configuration files to store configuration and to log execution of packages

Developing SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS).

Migrating data from transfer database objects and Created SSRS/ reports .

Technical Environment: MS SQL Server 2008, T-SQL, SQL Query Analyzer, Visual Studio 2008, Windows 7, SQL Reporting Services (SSRS) 2008, SQL Integration Services (SSIS) 2008, MS Office 2003/2007.

Wells Fargo, Des Moines, Iowa. September 2016 – Feb 2018

Developer

Created Technical and functional document for a user to understand the full functionality of the application.

Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) and then translating into functional

Migrated data from transfer database objects and Created POWER BI/ reports in Business Intelligence Development Studio (BIDS).

Worked on retrieving and manipulating data with Teradata Structured Query Language using ANSI Standard conventions and Teradata extensions on Teradata SQL Assistant.

Created trace in SQL profiler for performance tuning on stored procedure and then created testing scripts for staging validation

Migrated data from transfer database objects and Created SSRS reports in Business Intelligence Development Studio (BIDS).

Worked with T-SQL to create Tables, Functions and Stored Procedure.

Created different kind of reports like drill down reports, Drill through Reports, Parameterized reports in Visual studio 2008/2012.

Responsible for maintaining all the code in TFS module and helped in deployment of end to end application using Microsoft Visual studio 2010.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data from different Data sources worked on linked server open query to connect to DB2 data source

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008R2/2012.

Used SQL Reporting Services (SSRS) 2008/2012 to develop reports and deployed them to SharePoint site

Modified existing database to fit new business requirement by adding tables and relationship.

Environment: SQL Server 2012, Visual studio 2012, MS Office 2003/2007, Windows 7, Visual studio 2010, Reporting Services, JIRA.

Principal Financial Group – Des Moines, IA May 2016 – August 2016

Developer

Working at PGI (Principal group Investors) on Real Estates operating Management Reports.

Implemented extreme programming by using fast paced agile methodology, involving in task completion, user stories, and iterations.

Responsible for maintaining all the code in TFS for my module and helped in deployment of end to end application.

Worked on Yardi system Reporting and generated custom reports for Yardi systems.

Visual studio 2015 to generate POWER BI reports and upload them to Yardi system interface by Remote login.

Used JIRA life cycle workflow management tool primarily catered towards agile development projects.

Worked on Table Adapters to provide additional queries that share a common schema with the associated typed Data Table.

Table Adapter loads the returned data into its associated data table or returns new data tables already populated with data.

Responsible for end to end application testing, Unit Testing and performance testing.

Created Technical and functional document for a user to understand the full functionality of the application.

Environment: MS SQL Server 2014, Visual studio 2015, MS Office 2003/2007, MS Access, Windows 7, Studio VB.NET, TFS, Reporting Services, JIRA.

Wells Fargo – Des Moines, IA Aug 2014 – Feb 2016

Developer

Involved in import and export of data between various sources and destinations using SSIS, Scheduled SSIS jobs.

Responsible for designing the ASP.NET Win Forms using .NET Framework in C#.

Used Ajax to messaging and data management capabilities of Data Services directly from the Java Script.

Used Session Management with SQL session state for maintaining data retrieved from database.

Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.

Monitoring & Analysis of SQL Log Perform counters and Performance Tuning for all development and staging environment.

Responsible for maintaining all the code in TFS for my module and helped in deployment of end to end application.

Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents (BRD) and then translating into functional

Migrated data from transfer database objects and Created POWER BI/ reports in Business Intelligence Development Studio (BIDS).

Analyzes, design, and codes web applications and maintains entire software cycle and Creates models for new database development and modifies existing

Responsible for performance tuning and optimization of SQL queries and indexes

Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.

Used SQL Reporting Services and Report Builder Model to generate custom reports.

Modified existing database to fit new business requirement by adding tables and relationship.

Environment: MS SQL Server 2008, POWER BI, Teradata SQL Assistant, MS Office 2003/2007,MS Access, IWAR, 2010, Windows 7, Visual Studio 2013.

Contact this candidate