SUMMARY

• 9 years of MS SQL Server Development experience in Pharmaceuticals, Healthcare, Finance domains with expertise in MS SQL Server 2005/20 suite of products like SSIS, SSMS, and SSRS.
• Proficiency in using SQL Server to create complex T - SQL statements, such as Store Procedures, Triggers, Tables, User Defined Functions, Views, SQL Joins, CTE, Relational Database models and Data integrity and performance based query writing.
• Thorough noledge of C# programming concepts, testing and debugging methods, system design, and implementation, export data into Excel file followed by generating email with that excel attachment.
• Highly noledgeable of SDLC principles: Agile and Waterfall methodology.
• Steady noledge in normalizing and de-normalizing tables to maintain referential integrity by using primary and foreign keys.
• Expertise in database management techniques including backup/restore, import/export and script generation.
• Daily proficient experience in creating complex ETL packages using functions such as Try/Catch, assigning dynamic parameter values, Email notifications, Foreach loops, and etc.
• Expertise in creating and scheduling complex SSIS packages for transferring data from multiple sources into SQL Server, Access and Excel by using SSIS and DTS of SQL Server.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server 2005/20 respectively.
• Leading skills in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2012 (SSRS).
• Efficiently load, combine, refine, and clean data from various sources through Power Query. Created relationships, measures, calculated columns, filters, charts in QlikView and Delivering user friendly and informative business intelligent solutions.
• Adapt in writing Parameterized Queries for generating Tableau reports and Sub reports using Global variables, Expressions, and Functions, Sorting teh data, Defining Data sources and Subtotals for teh reports using SSRS 2005/2008/2012 .
• Strong understanding in Logical and Physical Database design & development, Data Conversion.
• Quantified noledge in Data modeling using ERwin and SQL Server Enterprise manager.
• Superb skill set experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server 2005/20, MS Access databases.
• Highly skillful with Scrum methodology and well versed in writing user stories.
• Involve in all phases of software development life cycle: design, implementation and testing.
• Comprehensive noledge of implementation performance tuning of Databases and SQL queries.
• Exceptional understanding in database creation, maintenance, monitoring, backups and recoveries.
• Specialize in analyzing, coding, implementing and creating complex query reports using Oracle 8i/ 9i/ 10g, SQL Server 2005/2008/2012 , Sybase and DB2.
• Outstanding interpersonal communication, problem solving and business analytical skills and Experience with documenting teh work done for future reference and Ability to quickly learn new technologies and use them
• Experience in migrating systems to another interface engine.
• Experienced in efficiently working with cross-functional team as a liaison to connect technique team and functional team. Highly skilled working as an individual as well as in a team.

TECHNICAL SKILLS

Relational Databases: SQL Server 2014/2012/2008 R2 / 2008/2005, Oracle 10g/9i/8.0, MS Access, DB2, MS Excel, DB2, Teradata, Sybase.

Tools: and Packages: SQL Server Management studio, Enterprise Manager, Profiler, SSIS, SSRS, SSMS, DTS, Crystal Reports9.0 Visual Studio .Net

Language: T-SQL, PL/SQL, V.B6.0, C, C# (expert level) ASP.Net, VB.Net. Matlab, Java, Android (Primary level)

Operating Systems: Windows XP/ 2007/2008/2010

Web Technologies: HTML, XML, ASP.NET

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: Qlikview, SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007, Tableau

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Server Developer (SSIS/SSMS/SSRS)

Responsibilities:

• Analyze and review business requirements and interact with Business System Analyst for SQL Server Management Studio.
• Work with Project Manager in estimating teh Project delivery.
• Work with Enterprise Architect in technical design and review.
• Design and Implementation of Classes, Interface, and Web Service Components using C#.NET.
• Develop Data Access objects using ADO.Net.
• Developing Web Application using ASP.NET Webforms, ASP.NET MVC technologies.
• Implementing Stored Procedures, User defined functions, Indexes, Triggers, Views for on SQL Server Management Studio.
• Involve in Code Review activity.
• Implementation of Unit testing code.
• Involve in testing teh application in Development Phase followed by User Access Test Environment.
• Involve in Application build and documenting deployment Activities.
• Work with Deployment of Applications and tools to production.
• Monitoring performance and identify bottlenecks on Application.

Environment: MS SQL Server 2008/2012/2014 , SSIS, SSRS, Oracle10g, Visual Studio 2012, VSS 2012, Windows 2007/2008/2010 , asp.net, MS Access.

Confidential, Plymouth Meeting, PA

MS SQL Developer/ BI Developer

Responsibilities:

• Using Confidential own Datatool: Dataview 7
• Design and refine teh layout of a report
• Build and save a worksheet
• Add market share and growth statistics
• Create, save and use a template
• Make new data elements by Redefining and Grouping
• Export teh report to Excel
• Created SSIS packages for loading tables from heterogeneous sources and types (local data, retail data, and hospital data) of files to SQL server using an OLEDB driver.
• Wrote functions to validate data such as invalid ATC(Anatomical Therapeutic Chemical-Classification System), NFC (New Form Code), ISO codes and Constant Check with Exchange rate.
• Used lookup tables and fuzzy lookup tables in order to store teh data correctly.
• Wrote Stored procedures, used functions in them and separated teh clean and error data into two different tables (for each table in SQL server)
• Created SSRS reports for teh errors and submitted them to teh WRS (teh business people). So that they clean teh data and give teh whole data again in teh form of TPS.
• Created a Target Staging Database (TSD) which only contains teh clean data from all teh tables and is relational (TEMPhas all teh constraints like primary keys, foreign keys, correct data types, etc).
• Scheduled jobs to call SSIS packages and stored procedures. Created alerts for successful and unsuccessful completion of schedule jobs (Quarterly, Monthly, Weekly Report). Send email task for success informing transformation count based info.
• Performed unit testing on reports, and monitoring teh performance of teh report.
• Performed backups/restore, created database object such as tables, procedures, triggers, constraints, indexes and views.
• Involved in performance tuning, index tuning, analysis and optimization.

Environment: SQL Server 2008, SSRS, SSIS, SSAS, SQL, Windows 7/XP, MS Excel, MS Office -2003/2007.

Confidential

MS SQL Developer/ BI Developer

Responsibilities:

• Worked on IMS data, Parallel Trade Data in MIDAS (IMS internal data warehouse), Internationalization feature on MIDAS, market segmentation, licensing data available on MIDAS, local data and Hospital Data in MIDAS.
• Maintained data integrity by performing validation checks with in SQL server and Dataview ( Confidential own Datatool)
• Optimized queries tuned and monitored server performance.
• Involved in Fine tuning of database objects and server to ensure efficient data retrieval.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Imported data from various sources into a staging area, merges teh data into teh OLTP data model, and presents it to all levels of teh over-600 users.
• Developed, monitored and deployed SSIS packages.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
• Responsible for creating teh reports basing on teh requirements using SSRS 2008.
• Identified teh database tables for defining teh queries for teh reports.
• Gatheird business requirements, definition and design of teh data sourcing and data flows, data quality analysis, working in conjunction with teh data warehouse architect on teh development of logical data models.
• Deployed teh generated reports on to teh server.

Environment: MS SQL Server 2005/2000, SSAS, SSIS, SSRS, SQL Profiler/Analyzer, Management Studio, Import/Export Wizard, Excel.