PROFESSIONAL SUMMARY

• 5+ 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

Confidential, Seattle, WA

Developer

Responsibilities:

• Designing, Developing reports in MS SQL Server environment using Confidential .
• 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, Confidential .
• 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

Confidential, Des Moines, Iowa

Developer

Responsibilities:

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

Confidential - Des Moines, IA

Developer

Responsibilities:

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

Confidential - Des Moines, IA

Developer

Responsibilities:

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