SUMMARY:

• Around 8 years of IT experience in Database development, design, analysis, Data Analytics, and support in development, testing and production environments with various business domains like Health care, Manufacturing.
• Expertise in scripting T - SQL queries, Complex Stored Procedures, User Defined Functions (UDF), Database Triggers, using tools like SQL Profiler.
• Experience in Monitoring, Job Scheduling, Troubleshooting, Back Up, Recovery and Restoration in SQL.
• Strong experience with analyzing query plans, managing indexes, Performance tuning of complex SQL queries, Normalization and Replication.
• Expert in creating stored procedures for generating reports using SQL Server Reporting Services (SSRS) and expertise in creating complex reports using SSRS.
• Experience in creating parameterized, cascading parameterized, drill-down, drill-through and sub-reports using SSRS.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into MSSQL Server
• Experience in working with .NET technologies such as C#, ASP.Net, JavaScript, ADO.Net, WCF, Silverlight and Involved in implementing client side functionalities using java script, CSS and HTML .
• Experience in data blending using Alteryx and creating Dashboards using QlikView.
• Experience in writing Python scripts and scheduling jobs using Oozie.
• Experience in creating reports using Tableau.
• Experience in building Data Model using Star and Snow-Flake schemas.
• Involved in creating Technical documents and analyzing Functional specification documents.
• Experienced in working with Microsoft Visual Source Safe (VSS) and Team Foundation Server (TFS).
• Effective in working independently and collaboratively in teams. A proactive learner with a flair for adopting emerging trends and addressing industry requirements to achieve organizational objectives.

TECHNICAL SKILLS:

Programming Languages: SQL, C#, ASP.NET, Python

.NET Technologies: C#, ASP.NET 2.0/ 3.5 / 4.0, Web Services, WCF, Silverlight

Clients Side Programming: JavaScript, HTML, CSS

Database Programming: SQL Server 2005/2008/2012, Hive

Tools: SQL Developer, SSRS, SSIS, Alteryx, QlikView, Tableau, Anaconda, Rally, Octopus

Framework: .NET 2.0/ 3.5

Version Control: VSS(Visual Source Safe), TFS(Team Foundation server)

Operating Systems: Windows 7, Windows 8, Windows 10, Windows XP

PROFESSIONAL EXPERIENCE:

Confidential, Dearborn, MI

Software Engineer

Responsibilities:

• Experience in writing complex SQL scripts/ queries to perform End-to-End ETL validations and support Ad-hoc business requests.
• Monitoring system performance and suggest for system upgrade like disk, processor, and memory.
• Experience gathering customer requirements, writing test cases and partnering with developers to ensure full understanding of internal/external customer needs.
• Proficient in data blending using Alteryx.
• Experience in creating Dashboards using QlikView.
• Responsible for developing Reports using Tableau.
• Scheduled jobs using Oozie workflow.
• Written Python scripts for testing various system components on Hadoop clusters such as connectivity to Teradata, Oracle, DB2 and SQL Server
• Outstanding Data analysis skills including Data mapping from source to target database schemas, Data Cleansing and processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Involved in building Data Model using Star schema and Snow Flake schema depending on business requirements.
• The ability to interact professionally with a diverse group, including executives, managers, and LOB.
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and also assisted in Post Production support.

Environment: Microsoft SQL SERVER, Anaconda, Python, Hive, Tableau, Alteryx, QlikView, MS Access 2010, Team Foundation Server (TFS)

Confidential, Miami, FL

Sr SQL Server/ SQL BI Developer

Responsibilities:

• Involved in design, development, testing and implementation of the process systems with agile methodology.
• Worked with business analysts to review, understand the business requirements and functional specifications and Involved in preparing Technical Documents.
• Created database tables, complex stored procedures and Triggers.
• Performed Database Normalization, Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Developed Jobs for maintenance in terms of updating statistics, rebuilding indexes, scheduled full/diff backups, refreshing database environments periodically or on demand. Also set up notifications for failure of jobs.
• Involved in Replication environment (Transactional & Snapshot method used) to replicate data to other servers.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Experience in troubleshooting SQL Server configuration issues.
• Performed tasks including backup and restore by using tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Worked on SSRS extensively to create and design reports. Used complex expressions to calculate, group, filter, parameterize, and format the contents of a report.
• Involved in Report server set up and deploying, configuring and managing reports using Report Manager and Report Builder.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files and Access) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Experience in creating crystal reports.

Environment: Microsoft SQL SERVER, SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), Crystal reports, Team Foundation Server (TFS), Internet Information Server( IIS) 6.0, MS Visio 2010

Confidential, Redmond

Sr SQL Server/ BI Developer

Responsibilities:

• Involved in design, development, testing and implementation of the process systems with agile methodology.
• Worked with business analysts to review, understand the business requirements and functional specifications and Involved in preparing Technical Documents.
• Writing Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), Create and maintain Physical Structures.
• Involved in Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Involved in creating parameterized reports, Drill down and Drill through reports using SSRS
• Deployed and uploaded the SSRS reports to Report Server for the end users and involved in enhancements and modifications
• Migrated data from Heterogeneous data Sources (Excel, Flat file, CSV file) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Created packages in SSIS with custom error handling and worked with different methods of logging in SSIS.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, using SQL Server Reporting Services (SSRS).

Environment: Microsoft SQL SERVER, SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), Team Foundation Server (TFS), Internet Information Server( IIS) 6.0, MS Visio 2010

Confidential

SQL Server/BI Developer

Responsibilities:

• Analyzed business requirements, participated in technical design, development and testing of various modules assigned.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application. Used SQL Profiler and Index Tuning Wizard for tracing slow running queries and stored procedures.
• Involved in performing Database Backups & Restoration and scheduling Backups.
• Strong experience with analyzing query plans, managing indexes and locks, troubleshooting deadlocks.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Created views to restrict access to data in a table for security.
• Developed various operational Drill-through and Drill - down reports using SSRS.
• Involved with Query Optimization to increase the performance of the Report.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and Excel files .

Environment: Microsoft SQL SERVER, SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS),Internet Information Server( IIS) 6.0, TFS

Confidential

SQL /SSRS/.NET Developer

Responsibilities:

• Involved in requirements gathering and created Technical specification documents.
• Have written complex SQL queries, stored procedure and triggers. Worked closely with the application DBA in the development of a new schema, tables and appropriate views.
• Involved in creating, deploying reports using SSRS.
• Involved in Configuring IIS web server, deployed project on the web server and handled server configuration issues.
• Migrated data from Oracle to SQL Server databases using SQL Server Integration Services (SSIS) .
• Designed, Developed extensive dynamic Web pages using ASP.NET Server controls, HTML Controls, jQuery and CSS. Involved in creating.NET builds and making sure the builds are migrated all the way up to the Production Environment.

Environment: ASP.NET, C#, Java script, HTML, CSS, XML, WebServices, WCF, Silverlight, SQL SERVER 2005 / 2008, SQL Server Reporting Services (SSRS), VSS

Confidential

SQL/ SSRS/ .NET Developer

Responsibilities:

• Analyzed the business requirements, designed and developed the Web site.
• Developed Web pages using ASP.NET Server controls, HTML Controls, jQuery and CSS.
• Used PL/SQL to create and manage the database to store the data.
• Rebuilding Indexes and Tables as part of performance tuning exercise
• Involved in database object creation like tables, indexes, triggers and stored procedures
• Designed Reports in SSRS, using Shared data source and specified data source.
• Involved in peer review and peer testing.

Environment: ASP.NET, C#, Java script, HTML, CSS, XML, WebServices, WCF, SQL SERVER, SQL Server Reporting Services (SSRS), MS Visual Source safe(VSS)