SUMMARY

• 10+ years of experience in Microsoft Technologies projects. Experience in understanding requirements, designing, application development, enhancement, implementation & deployment of console/ Windows/ Web Applications
• 6+ years of experience in MSBI (SSIS, SSRS, SSAS), DTS, SAS ETL Developer to support a variety of business needs and often communicate with end - client on required specifications on data (onsite in USA).
• Exceptional knowledge of SQL SAS and a range of other data analysis and extraction applications
• Good understanding of SQL Server Internals, Database fundamentals, Data Warehousing concepts, RDBMS, concepts, Reporting, High Availability, Disaster Recovery & Optimization techniques.
• 6+ years of strong experience in reporting and visualizations using SSRS, Tableau.
• Expertise in data cleaning, loading, extraction, processing, validating using SQL, SSIS, SSRS Packages & SSIS package deployments & creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Strong experience in design and development of dashboards and reports, including the development of detailed design specifications.
• Very strong experience inSSRS, Dashboards, Security Setups.
• Experience in XML related technologies Data loading.
• Web application build & maintain program (coding) source code experience in n-Tier architectures using C#.Net, ADO.Net, ASP.Net
• More than 10+ years’ experience in Software Development, application, environment and production support.
• Versatile experience as Database Development in MS SQL Server focus on Database Support, Monitoring, Automation and Optimization.
• Good knowledge of Software Development Life Cycle (SDLC), including requirements gathering, technical specifications, implementation, operations of large-scale enterprise wide applications.
• Expertise in database programming in writing stored procedures, functions, triggers & views using SQL Server 2000/ 2005/ 2008 RS/ 2012.
• Proficient in RDBMS including MS-SQL Server 2012 & Oracle querying databases using SQL, PL/SQL & T-SQL, writing stored procedures & Triggers.
• Solid software design, implementation & debugging skills using MSBI Framework using SQL Server 2008R2, C#, Asp.net & VB.NET as scripting language. Experience in delivering enterprise level Web/Windows, SQL, ETL, Business Process Automation, Business Intelligence & SOA solutions under traditional & agile project management methodologies. Proven experience in application/platform upgrade & migration
• Proficient in End to End Troubleshooting to mitigate performance issues caused by deadlocks.
• Experienced in monitoring Performance, Activity using tools/utilities: SQL Server profiler.
• Production support Experience in administering MS SQL SERVER 2008/2005.
• Experience in MS SQL server indexing, Database Migrations, New Enhancements.
• Detailed working experience on Database related activities Including but not limited to Normalization, Replication, Data Transformation, Distributed Transaction, Distributed Queries, Automated Jobs, T-SQL, Indexing, Stored Procedures, Triggers and Views.
• Hands on experience with maintenance of Business Intelligence applications using SQL Server 2008 Integration Services.
• Experience with the Production Application support / development with teams for database upgrades and releases.
• Experience in Supporting Enterprise level Databases, Troubleshooting the problems and documenting.
• Quickly adaptability client complex stored procedures, functions and triggers and views with minimal supervision.
• Having 2+ years of experience in Cloud computing services and network like salesforce and MS Azure.
• 5+ years of strong front-end development & design experience like JavaScript, VB Script, XML, XSL, XSLT, & CSS.

TECHNICAL SKILLS

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

ETL Tools: MSBI SSIS SSRS SSAS 2008R2.

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

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

Scripting Languages: Java Script, VB Script

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., AutoSys, SQL agent, SharePoint.

Data visualization & cloud computing products: Tableau, Saeforce, MS AZURE.

PROFESSIONAL EXPERIENCE

Confidential, VA

Data Analyst Lead

Responsibilities:

• Wrote SAS programs to performed ad-hoc analysis and data manipulation & Created various SAS Reports, Tables, Graphs and Summary analysis on PMS systems being used in these properties &Transferred data from Oracle database as well as MS Excel into SAS for analysis and used filters based on the analysis, IN addition to that I Used SAS Import/Export Wizard as well as SAS Programming techniques to extract data from Excel.& Used SAS Base programming as well as SAS Enterprise Guide 4.0 to produce various reports, charts and graphs.
• 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 SSIS packages to other 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 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 text file like .txt,.csv data was incorrectly send by client that stops the loading and extracts process scheduled Sql Jobs.
• Participated in AHM Clients decisions on-call meetings regarding study design, data collection, and data analysis new enhancements.
• Customizing existing Reports using Microsoft SSRS SQL Server Reporting Services Report Builder to Data marts for tableau reports.
• Changed the SQL SERVER 2000 existing Business Requirements Stored Procedures to Latest advance high performance running Stored Procedures.
• Pulling data from APIS.
• Handled the data in cloud storage using Cloud computing tools like salesforce, MS AZURE for Client Centris Direct, Centris events, Centris connect, Centris Services.
• Handled Web services data to maintain the Events and attendance data for all HCP clients.
• On-site working with Direct Client stakeholders (Astrazenica Canada, Astrazenica US, Pfizer, Teva, Jazz, Gilead, Novo Nordisk) to AHM.
• Followed complete SDLC Process in new Implementations and Migrations.
• Involved in Data integration and complete conversion processes using SSIS.
• Involved in automated job control system for scheduling, monitoring, and reporting. These jobs can reside on any AutoSys-configured machine that is attached to a network. Using the AutoSys Job Information Language (JIL) through a command-line interface.

Confidential

Senior Consultant

Responsibilities:

• Perform data cleaning, loading, extraction, processing, storage and manipulation
• Support to client in Production Deployments
• Main core developed and designed SSIS Packages.
• Involved in automation to for the extracts.
• 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
• Hand SharePoint SharePoint, led 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 Front end coding using .net, C#, Asp.net.
• Wrote SAS programs to perform ad-hoc analysis and data manipulation
• SAS programming for auditing data, developing data, performing data validation QA and improve efficiency of SAS programs

Confidential

Senior Software Engineer

Responsibilities:

• Involved in Requirement Analysis.
• Involved in Stored procedures.
• Involved in Designing and coding offline reports.
• Implemented the sync process on monthly bases for generating the each company report.
• Generated MS Word files using third party control aspose.
• Produce tables, graphs, and charts for reports and presentations in MS word.

Confidential

Responsibilities:

• Involved in Requirement Analysis.
• Involved in Database designing and performance tunings.
• Involved in Designing and coding with the web pages.
• Working with the dynamic reports, Crystal reports.
• Given the Web Services to ex tract the data.
• Implemented the sync process on daily bases for importing data from different databases.
• Worked as Database Programmer with the Data Base Administrator.

Confidential

Responsibilities:

• Worked as Database Programmer with the Data Base Administrator.
• Analyzed the requirement and designing.
• Wrote stored procedures, functions and triggers and views using SQL Server 2005.
• Involved in Database designing
• Imported Data from different Databases.
• Testing the Data and giving the error checks to validate the data respectively.
• 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

Confidential

Responsibilities:

• Analyzed the requirement and designing.
• Wrote stored procedures, functions and triggers and views using SQL Server 2000.
• 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

Confidential

Responsibilities:

• Involved in designing the pages.
• Analyzing the requirement and designing.
• Developed the tool for the generating the reports.
• Involved in the Unit testing.
• Individually handle the project.
• Database programming for the project.
• Lead developer for the project.
• Writing stored procedures, functions and triggers and views using SQL Server 2000.