We provide IT Staff Augmentation Services!

Senior Software Developer Resume

Chicago, IL

SUMMARY

  • Around 6+ years of professional IT experience which includes working as MS SQL Server developer, BI & Data Visualization developer and Software developer.
  • Extensive experience of around 6 years in MS SQL Server development - analysis, design, development, implementing and testing.
  • Strong technical knowledge in MS SQL Server development and extensive expertise in Microsoft Business Intelligence (MSBI) tools - SSRS, SSIS and SSAS (2005, 2008 and 2012).
  • Maintained and handled large databases by creating & developing database objects such as Tables, Stored Procedures, Views and Triggers etc.
  • Experienced in data loads, database integration/conversions, performance tuning and optimization.
  • Hands on experience in Software development with emphasis on software analysis, design, development, implementation, documentation, maintenance and support of various web and client/server applications using .NET Framework and Utilities, ASP.NET, C# and MS SQL Server.
  • Expert in achieving data security by handling database roles, user access and granting database access and permissions.
  • Experience working on Tableau desktop as part of BI/Data Visualization development.
  • Excellent communication skills, both oral & written and a very good team player.

TECHNICAL SKILLS

Databases: MS SQL Server 2005, 2008, 2010, 2012, Oracle 9i

Programming Languages: TSQL, PLSQL, C#, VB.NET, CSS.

.NET Frameworks: 3.0, 3.5, 4.0, 4.5

Operating Systems: Windows 2000/XP, Windows 2003 Server, Windows 2008 Server, Windows 7,Windows 8

Tools: & Utilities: SQL Server Management Studio 2005/2008/2012 , SQL Server Reporting Services, SQL Server Integration Services, SQL Server Analysis Services, Business Intelligent Development Studio, Visual Studio 2008/2010/2013 , Tableau 7x, Crystal Reports, Erwin, MS Visio, GitHub Client, Smart Git HG, FileZilla, WinSCP, Smartsheet, Slack, Trello.

Version Controls: GitHub, Subversion, Visual Studio Online, TFS.

Application Server: IIS 4.0, 6.0

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior Software Developer

Responsibilities:

  • Involved in gathering business requirements and performing analysis.
  • Created, maintained and handled large databases by creating & developing database objects such as Tables, Views and Stored Procedures.
  • Created different kinds of reports based on business requirements using SQL Server Reporting Services (SSRS).
  • Created SSIS packages for transforming data, to import data from source systems or transfer data from one server to another.
  • Software development by implementing Agile Software Development methodologies.
  • Played an active role in all phases of System Development Life Cycle (SDLC) such as strategy and analyzing, designing, building (coding), testing and documentation.
  • Created business reports out of databases by creating stored procedures and developing Report Definition Language (RDL) files to generate the report in the desired format.
  • Developed new enhancements, for the web-sites hosted, that are put forward by the business team using .NET Framework and Utilities, C#, ASP.NET.
  • Developed test-cases and test-scenarios and perform End-to-End & Regression testing on the enhancements made.
  • Developed several console applications using latest .NET Framework (4.0 & 4.5) to automate regular manual tasks and to import data from flat files into databases.
  • Deployed code; create & schedule windows scheduled tasks on web servers to execute the console applications built.
  • Involved in troubleshooting and bug fixing.
  • Deployed DB scripts, objects and other application code in various environments like Dev, Staging and Production.
  • Involved in taking database backups and restoring it in different environments, as per need.
  • Used Smartsheet and Visual Studio Online (VSO) for daily work management and analysis of performance.
  • Maintained Source Code version control using GitHub & Visual Studio Online, based on the applications.

Environment: / Technologies/ Tools: SQL Server 2003/2008, SQL Server Management Studio 2005/2008, SQL Server Reporting Services, .NET Framework 3.0/4.0/4.5, SQL Server Integration Services, C#, ASP.NET, Visual Studio 2008/2010/2013 , IIS 4.0/6.0, GitHub, Visual Studio Online, LINQPad, FileZilla, WinSCP.

Confidential, Chicago, IL

Sr. Database & BI Developer

Responsibilities:

  • Designed, created and maintained Database objects like tables, stored procedures, functions, views, etc.
  • Database optimization (including queries and indices), tuning, and troubleshooting.
  • Advanced TSQL programming involving ad hoc queries, triggers, procedures, functions, etc.
  • Performed data integrity check and analyzed anomalies in data.
  • Generated Reports based on the requirements put forward by the business team using SQL Server Reporting Services (SSRS) for different subjects.
  • Designed SSIS packages to extract, transfer and load (ETL) existing data into SQL Server from different environments.
  • Performed manual scrubbing of data, whenever needed.
  • Configured SQL Server Agent mail for sending Automatic emails on Errors.
  • Development and production support for various large databases and SSIS packages.
  • Designed and developed analytical reports from multiple data sources by blending data on worksheets inTableauDesktop.
  • Utilized advanced features ofTableausoftware like linking data from different data sources on dashboard to filtering it.
  • Optimized SQL queries for improving performance and efficiency using SQL profiler and tuning advisor.
  • Involved in deploying packages, DB objects and other code to different environments.
  • Involved in migration of the database objects from one server to another.
  • Used Visual Studio Online (TFS) for tracking of project/daily work.
  • Involved in database migration of SQL Server 2005 to SQL Server 2008.
  • Imported data from various data sources such as MS Excel, Flat files, CSV files into SQL Server.
  • Involved in data extraction, transformation and loading (ETL) using SQL Server Integration Services (SSIS), Bulk Insert, BCP etc.
  • Performed regular maintenance duties like performance tuning and optimization of queries, stored procedures, functions etc.
  • Generated and maintained business reports based on the needs and requirements using SQL Server Reporting Services (SSRS) which were used for budget analysis and to design future production plans.
  • Involved in deploying the reports in various environments such as Dev, Test and Production.
  • Created and maintained several stored procedures which in turn are used as data sources for reports generation.
  • Created and managed OLAP cubes using SSAS.
  • Automated daily administrative tasks such as database backup and recovery and involved in database maintenance plans by setting up SQL Server Agent jobs for periodic backups and recovery.
  • Wrote SQL queries to perform Data Integrity testing on SQL Server Database to validate and test data using SQL Server Management Studio (SSMS).
  • Implemented user roles and security to restrict the access of database objects to appropriate users.
  • Created technical documentation which can be used as references in future by other developers and the business team.
  • Actively participated in designing database schema, maintain and document them for future references.
  • Involved in writing complex T-SQL queries, stored procedures and other database objects that were useful for application functionality.
  • Designed and developed ETL loads as per business requirements in SSIS.
  • Optimized the performance by modifying existing SQL queries, eliminate redundant and inconsistent code, creating indices wherever necessary, etc.
  • Created reports using SSRS and integrated them to be accessed through front end.
  • Gathered end user feedback and improved the runtime of certain reports by tuning and optimizing the stored procedures/queries that act as the data sources for the reports.
  • Used SSIS to extract and load data from existing systems and other data sources and perform transformations.
  • Involved in analysis, design, development and testing of OLAP cubes with SQL Server Analysis Services (SSAS).
  • Generated simple ad hoc MS Excel reports by writing queries/stored procedures to pull data from multiple relational databases.
  • Created and maintained DB User’s security permissions.
  • Created new logical and physical design of databases to fit new business requirement and implemented new design into SQL Server database.
  • Created/Updated databases, tables and procedures while updating and cleaning the old data.
  • Data validation and cleansing while migrating from flat files to a SQL server destination.
  • Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Advisor.
  • Configured SQL mail Agent for sending Automatic emails on Errors.
  • Generated business reports using Reporting tools.
  • Created SSIS Packages to import and export data from Excel, Xml and Text files.
  • Involved in project planning of web portal development by gathering and analyzing user requirements.
  • Involved in designing and creating database as per the project requirement.
  • Create, manage and analyze the data and perform data clean-ups as needed.
  • Performance tuning of queries and stored procedures.
  • Involved in planning and taking database backups and recovery.
  • Maintain database security by implementing access levels for users.
  • Prepared specific technical documentation as per the project need.

Hire Now