EXPERIENCE SUMMARY:

• 9+ years of experience in Microsoft Technologies in Data Design and Development onMicrosoft SQL Server, T - SQL, Performance Tuning, Troubleshooting,SSIS/DTSPackage Development,SSRS, SSAS(OLAP Cubes & Snowflake \ Star schema) and Data-warehousing.
• Expertise in MSBI -Microsoft Business Intelligence in SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS), DTS, ETL Developer to support a variety of business needs and often communicate with end-client on required specifications on data (6+ years onsite in USA).
• 9+ years of experience in SQL & PL\SQL Server Database Querying & Data warehousing Concepts, in writing T-SQL & PL\SQL Indexing, Stored Procedures, Dynamic Queries, Views, Experience in Supporting Enterprise level Databases, Troubleshooting the problems and documenting.
• 9+ years of Versatile experience as Database Development in MS SQL Server focus on Database Support, Monitoring, Automation and Optimization. Experienced in monitoring Performance, Activity using tools/utilities: SQL Server profiler.
• Quickly adaptability client complex Oracle & MSSQL stored procedures, functions and triggers and views with minimal supervision. 7+ Years of detailed working experience in Oracle & MSSQL RDBMS Normalization, Replication, Data Transformation, Distributed Transaction, Distributed Queries, Automated Jobs, End to End Troubleshooting to mitigate performance issues caused by deadlocks.
• 7+ years of Experience in developing Web, Windows, Cloud, API Applications. Solid software design, implementation & debugging skills using MSBI Framework using SQL Server, C#, Asp.net & VB.NET as scripting language.
• 7+ years of strong experience in reporting and visualizations using SQL SERVER REPORTING SERVICES (SSRS), Tableau. Strong experience in design and development of dashboards and reports, including the development of detailed design specifications.
• Expert in dimensional data modeling using SSAS and OLAP, cube partitioning, optimization, creating aggregations Knowledge in designing and developing data warehouses, data marts and business intelligence using multi-dimensional models such as star schemas and snow flake schema for developing cubes using MDX.
• 3+ years of Knowledge in MS Azure SQL, Knowledge ofAzure SQL, and other Azure offerings centered around data and Analytics.

SOFTWARE WORKING EXPERIENCE:

Operating Systems: Windows WIN NT, WIN 95/98, WIN 2000 Professional, Windows 7, Linux, Unix.

Microsoft Business Intelligence in: SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS), DTS

Internet/ Intranet servers: IIS, COM, & .Net Framework.

RDBMS: SQL Server 2000, 2005, 2008,2012.

Microsoft Technologies: ASP.NET, VB.NET, ADO.NET, C#.net

Other Utilities: IIS 6.0, Visual Source Safe (VSS), SVN, VS.Net 2005/ 2008., SQL agent, SharePoint

Scripting Languages: Java Script, VB Script

Systems: Languages C, C++, Vb.net, C# & XML

PROFESSIONAL EXPERIENCE DETAILS:

Confidential, Norfolk, VA

Data Analyst Lead

Responsibilities:

• Drafting & requirements analytical approach to the client’s request in direct client location and working with minimal Supervision in Client SharePoint Portal. Support and maintenance Client Architecture from the Implementation phase to code Deployment in Production.
• Develop and maintain databases for use in data analysis and tracking and migrating SQL SERVER INTEGRATION SERVICES (SSIS) packages to Oracle data warehouse. Complete ETL processes handled both on-shore and off-shore support.
• Involved in automation of Inbound and Outbound Feeds W.R.T the client’s data Requests.
• Extract and transfer and load (ETL Process) Raw HCP’s, Customer, Speaker data Text files from Client to AHM SQL Data warehouse model.
• Performance improvements and Validating SQL Stored procedures used in Front end all reporting tools Troubleshooting issues and providing the client with a technical solution Sending the Data on high priority requests from legal queries arise by US-Government W.R. T the client.
• Deal with complex Hcp’s sensitive customer client data to load into AHM SQL Data warehouse model on every month. Involved in Data optimization on complex problems.
• Production Support to handle the Designed SSISPackagesto transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008andSSIS in Business Intelligence Development Studio (BIDS).
• Used SSRS to develop different kinds of reports like canned, ad-hoc reports for the Healthcare clients. Createdparameterized reports, Drill downandDrill throughreports using SSRS.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Used Execution Plan,SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases. Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T-SQL code for applications.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.
• Designed and developed data models for the data warehouse using star and snowflake schema.
• Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Designed OLAP cubes with star schema and multiple partitions using SSAS & complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups, Created SSAS Cubes for analysis, Handled SharePoint, data mining and OLAP for online analytical processing create cubes using data from data marts / data warehouse for deeper and faster data analysis.
• Managed SQL Server Agent Jobs

Technologies Used: Microsoft SQL Server Management Studio, TSQL, Microsoft Business Intelligence in SQL Server Reporting Services(SSRS), SQL Server Analysis Services (SSAS) and SQL Server Integration Services (SSIS), DTS, ASP.NET, Jira Tool, SVN, Clarity, Citrix, C#, Tableau, MS Azure SQL, SQL Agent, Oracle, Mango DB.

Confidential

Senior Software Engineer

Responsibilities:

• Perform data cleaning, loading, extraction, processing, storage and manipulation (ETL Process).
• Support to client in Production Deployments
• Main core developed and designed SQL SERVER INTEGRATION SERVICES (SSIS) Packages.
• Involved in automation to for the extracts (ETL Process).
• Writing scripts to solve the customer queries.
• Analyze data with statistical methods, customizing existing Reports using Microsoft SQL Server Reporting Services Report Builder to Tableau and salesforce.
• Changed the SQL SERVER 2000 existing Business required Stored Procedures to Latest advance high performance running Stored Procedures
• Handled SharePoint, data mining and OLAP for online analytical processing create cubes using data from data marts / data warehouse for deeper and faster data analysis.
• Involved in Complete Frontend coding using .net, C#, Asp.net.
• Worked as Database Programmer with the Data Base Developer.
• Analyzed the requirement and Database schema designing.
• Wrote stored procedures, functions and triggers and views using SQL Server 2008 R2.
• Testing the Data and giving the error checks to validate the data.
• Handled with protocol specification for exchanging structured information in the implementation web services
• Created SSRS report model projects in bi studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Designed OLAP cubes with star schema and multiple partitions using SSAS & complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups, Created SSAS Cubes for analysis, Handled SharePoint, data mining and OLAP for online analytical processing create cubes using data from data marts / data warehouse for deeper and faster data analysis.

Technologies Used: SQL Server 2012,2008, TSQL, SQL SERVER INTEGRATION SERVICES (SSIS), ASP.NET, Jira Tool, SVN, SQL SERVER REPORTING SERVICES (SSRS), SSAS, Clarity, Citrix, Informatica 9.0, C#, Tableau, MS Azure SQL, SQL Agent, Oracle.

Confidential

Senior Software Engineer

Responsibilities:

• Worked as Database Programmer with the Data Base Developer.
• Analyzed the requirement and Database schema designing.
• Wrote stored procedures, functions and triggers and views using SQL Server 2008 R2.
• Testing the Data and giving the error checks to validate the data.
• Handled with protocol specification for exchanging structured information in the implementation web services
• Worked on analyzing and increasing the performance for the Database Queries with T-SQL, Query Reviews
• Alone developed the complete Automated report generation website.
• Graphical representation of reports using .net charting into Word documents.
• Understand the complete report requirements to generate a reports parallelly downloading.
• Spyder tool implemented to gather all the data from all listed websites & webservice’s new information.
• Handling the last updated data displaying in website in case of webservices are not responding.

Technologies Used: C#, ASP. Net2.0, ADO.Net, Web Services, SQLServer2008 R2, .Net Charting, SQL Server 2012,2008, TSQL, SQL SERVER INTEGRATION SERVICES (SSIS), ASP.NET, Jira Tool, SVN, SQL SERVER REPORTING SERVICES (SSRS), Clarity, Citrix, Informatica 9.0, C#, Tableau, MS Azure SQL, SQL Agent, Oracle.

Confidential

Responsibilities:

• Analyzed the requirements and designing.
• Wrote stored procedures, functions and triggers and views using SQL Server 2008 R2.
• Single handled the coding, importing, validation, testing New and Update Data from different Databases (Syncing Process).
• Testing the Data and giving the error checks to validate the data respectively.
• Automated Mailing system after the syncing process.
• Involved in increasing the performance for the Database Queries with T-SQL.
• Developed the own web service for syncing the data into GLB database.
• Handled with Representational State Transfer stateless, client-server, cacheable communications protocol and in virtually all cases, the HTTP protocol is used
• Data Taken from different client sources like PDF, XML files and load into Informa Data ware house.
• Giving web site to remove the Duplicate customer data make a golden record.

Technologies Used: C#, ASP.Net2.0, ADO.Net, SQLServer2008 R2, .Net Charting, DTS packages, Rest.

Confidential

Responsibilities:

• Maintaining and Enhancement for new requests.
• Complete 5 years singly Maintaining code and enhancements on client Change Requests.
• Programming in ADO.Net to handle the databases Data to show on Website
• Involved in Code Optimization and Performance Tuning of the Stored Procedures Queries.
• Involved in system defect tracking, bug fixing and maintenance.
• Wrote complex Standard Financial deal related stored procedures in Sql server 2005.
• Given new Object-oriented solutions to resolve the Production unresolved site issues.
• Alone coded the tree representation of Hierarchy Territory display popup windows.
• First time implemented the SQL CTE program to resolve the recursive calling data issues.

Technologies Used: ASP.Net 2.0, C#.net and SQL Server 2008 R2, DTS Packages, Web services, SQL Server 2012,2008, TSQL, SQL SERVER INTEGRATION SERVICES (SSIS), ASP.NET, Jira Tool, SVN, SQL SERVER REPORTING SERVICES (SSRS), Clarity, Citrix, Informatica 9.0, C#, Tableau, MS Azure SQL, SQL Agent, Oracle.

Confidential

Software Engineer

Responsibilities:

• Requirement analysis and design.
• Development and Unit testing.
• Wrote new SQL queries and MS SQL server stored procedures from scratch.
• Understanding of drug development business processes
• Understand complete Life cycle of client Sample and Certificate of Analysis process.
• .Net website designing and coding in VB.net, C#.
• Maintaining Visual source safe to get latest code Daily basis.

Technologies Used: ASP.Net 2.0, C#.net and SQL Server 2000, DTS Packages, Crystal reports.