SUMMARY:

• 14 years of total IT industry exposure in Microsoft technologies. Experience on Microsoft SQL Server, MSBI, Power BI with Good experience in Database designing.
• Experience in writing complex Stored Procedures, Confidential - SQL, Functions, creating Views, Triggers, Joins, Cursors, Temp Table, Deduping, CTE’s.
• Implemented Change Tracking (CT) for POC.
• Installed and Maintained Power BI Report Server in all environments(Dev/UAT/Prod)
• Developing Power BI Dashboards for companywide asset management using data visualization like Matrix, Bar, Donut, Card, Text Filter.
• Experience in writing DAX function & creating measures using DAX.
• Developing SSIS Packages to Transform and Load (ETL)/DTS data into the Data warehouse from Heterogeneous data sources.
• Experience in creating SQL jobs And Scheduling
• Extensive experience in using Confidential -SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Defined Functions.
• Experience in Creating, Deploying and scheduling SSIS packages.
• Experience in Creating Reports and Deploying in SSRS, created Tabular, Matrix, Drill-Down and Sub Reports.
• Experience with scheduling email subscription reports to various teams.
• Experience in Web Programming using ASP.NET, C#, ADO.NET, JavaScript, CSS, JQuery.
• Worked with Version Control tools like Visual Source Safe, Source OffSite, SVN Sub Version.
• Knowledge on Agile Scrum Methodology.
• Good interpersonal skills. Can work efficiently in Confidential team environment as well as individually.
• Ability to upgrade with new technologies and flexible enough to adapt new environments.

TECHNICAL SKILLS:

Database: MS SQL Server 2016/2014/2012/2008 R 2/2008/2005/2000/7.0 , Postgre 9.6, Oracle, Firebird

BI Tools: Power BI, SSRS, SSIS, SSAS, SSMS, SSDT, Crystal Reports

.NET Technologies: ASP.Net, MVC, Entity Framework, ADO.NET, Win Forms, Web forms, Web Services, Windows Services, Asp.net Ajax, MVP, Visual Studio.NET 2003/2005/2010/2013/2015/2017

Programming Languages: C#, VB.NET

Web Technologies: HTML, CSS, Themes, JavaScript, XML, JQuery, Bootstrap

Web Server: IIS

Office Tools: Excel, Word, PowerPoint, Outlook, GSuite

Version Control Tools: Visual Source Safe, CVS, SVN subversion

WORK EXPERIENCE:

SQL Developer

Confidential, Alpharetta, GA

Responsibilities:

• Created Asset Management Power BI Dashboards for Hardware, Software, Operating Systems & by Business Units.
• Installed and Managed Power BI Report Server on SQL Server 2016.
• Schedule Power BI Report Refresh.
• DAX used to create new measures.
• Implemented Change Tracking for POC.
• Developed dashboard for Report usage and stats from reportDB.
• Creating Datasets for SSRS, Power BI and .Net App using Stored Procedures.
• Creating calculated columns, Measure in Power BI Desktop.
• Designed SSIS packages to pull Patch & Vulnerability data from Postgres DB.
• Responsible for gathering project requirements from the clients
• Responsible for database design, creating Tables, Views, Stored Procedures and User Defined Functions.
• Developed Patch & Vulnerability dashboard by Criticality, by Business Units, by Location.
• Created Upsert Stored Procedures for data merge.
• Loading daily reports to SharePoint server using SSIS Package.
• Bulk import Asset Inventory data from ASP.Net page.

Environment: SQL Server 2012/2014/2016 , Postgres 9.6, SSRS, SSIS, Confidential -SQL, DAX, PowerBI Report Server May 2019, JIRA, Service NOW, HPE Asset Manager 9.60, ASP.Net.

Software Engineer

Confidential, Alpharetta, GA

Responsibilities:

• Responsible for gathering project requirements from the clients
• Responsible for database design, creating Tables, Views, Stored Procedures, Triggers and User Defined Functions.
• Created SSIS Package to load data from text file and Oracle DB to SQL Server.
• Package to Import and Export Files from File System to SQL Server
• Package to loading Text files to FTP and SharePoint server.
• Deploying SSIS packages from Dev to QA and Production SSIS Server.
• Scheduling SQL Jobs for SSIS packages using SQL Server Agent.
• Created Alerts to report successful or unsuccessful completion of Jobs.
• Designed, deployed, and maintained various SSRS Reports in SQL Server2008R2
• Deploying SSRS reports in Report Server using Report Manager and created Email Subscriptions for various teams.
• Created Matrix and Drill down reports using SSRS.
• Created Sub Reports to show multiple reports.
• Performed Data Analysis and DB design.
• Created validation report, to validate all approvers approved Confidential Sid.
• Providing Statistical Analysis with reports and charts rdlc .
• Generated the QA reports for the Analyst to validate the plans, which involves in connecting to 33 Diff oracle servers using linked server in Confidential single SP.
• Prepared migration scripts to migrate the data from the old SQL server database to this new SQL Server database. This involved analyzing the existing database schema & its data and mapping the old schema to the new schema.
• Implemented Bulk QA report, where we can QA Confidential bulk of Codes one time, which saves lot of time for the Analyst.
• Developed internal website using Asp.net, c#, implemented the project with MVP Design Pattern, requirement gathering from the users and analyze the system.
• Created Ad-hoc reports as needed and carry out report projects as required.
• Giving training for users.
• Used SVN subversion as project repository.
• Writing Stored Procedure, Functions and Triggers using SQL Server Management studio.
• Handling Client escalation, Production issues - Debug and fixing the issue in minimal time.

Environment: SQL Server 2008/2005, SSRS, SSIS, Oracle and Visual Studio 2010/2005, ASP.Net 4.0/2.0, C#, Ado.Net, AquaDataStudio, Ajax, XML, JQuery, Themes

Confidential

Software Engineer

Responsibilities:

• Developed using C#, ASP.NET
• Created Drill down and Matrix reports using SSRS.
• Created Ad-hoc reports as needed and carry out project reports as required.
• Generate Metrics Reports.
• Involved in Database design.
• Writing Technical Specification Document.
• Implemented Form-based authentication.
• Unit Testing.
• Giving training on Usage of application.
• Writing Stored Procedure using SQL Server Management studio for project specific reports.

Environment: Visual Studio 2005, ASP.Net, C#, SQL Server 2005, SSRS, Confidential -SQL, JavaScript, CSS

Confidential

Software Engineer

Responsibilities:

• Understanding the existing architecture of SDP
• Developed Webservices with WSE 2.0.
• Developed database layer using ADO.net to access database procedures and functions.
• Used ACA.Net which is built on Microsoft Enterprise Library
• Migration of services from WSE 2.0 to WSE 3.0
• Unit Test developed component.
• Constant Interaction with the onsite team.
• Used Visual Source Safe Tool for version control.

Environment: VSTS, C#, Web Services Enhancements, MS Connected Services Framework, SQL Server 2005, Confidential -SQL, ADO.Net

Confidential

Software Engineer

Responsibilities:

• Understanding Functional Specification for the Component
• Writing Technical Specification Document.
• Designing the UI.
• Used ADO.Net and stored procedure for data access.
• Developing the Windows Custom Control Components
• Unit Test the Component

Environment: Visual Studio 2003, C#- Win Forms, SQL Server 2000, Confidential -SQL, XML

Confidential

Developer

Responsibilities:

• Implemented with VB.net, ASP.NET and SQL Server
• Design and development of the web service, and application front-end screens.
• Developed database layer using ADO.net to access database.
• Interacted with the client during requirements gathering sessions.
• Involved in understanding the existing system
• Developed user-controls for Header and Footer.
• Designed the database structure using Relational database modeling techniques.
• Used ADO.NET objects and Wrote Stored Procedure.
• Direct and Constant Interaction with the Client while developing the project.
• Sending daily status report to the Client

Environment: Visual Studio, ASP.Net, VB.Net, SQL Server 2000, Web Services, JavaScript and XML

Confidential

Developer

Responsibilities:

• Development of the Windows Service.
• Created Notify Icon with context menu to control the Windows Service.
• Created Confidential deployment package for the windows services.
• Created Data access layer using ADO.Net.
• Designed the database structure using Relational database modeling techniques.
• Developed good business knowledge about the company’s services and developed applications to cater to the needs
• Direct and Constant Interaction with the Client while developing the project to suit their needs.
• Sending daily status report to the Client

Environment: Visual Studio, VB.Net, SQL Server 2000, Firebird DB, and Windows Services, XML