PROFESSIONAL SUMMARY:

• Over 8+ years of experience in the IT industry as a SQL server developer in high transaction and multi - server production environment .
• Experience in Confidential Business Intelligence technologies like SQLServerIntegrationServices(SSIS) , SQLServer Reporting Services(SSRS) and SQLServer Analysis Services(SSAS) .
• Extensive experience with T-SQL in constructing Triggers, Tables, implementing stored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity .
• Strong experienceof Data Warehousing methodologies and concepts , including star schemas , snowflakes , ETL processes , dimensionalmodeling and reporting tools .
• Excellent experience in migration of data from Excel , Flatfile , Oracle to MicrosoftSQLServer .
• In-depth knowledge of T-SQL, SQL ( DDL, DML and DCL ), PL/SQL.
• Experience with logical and physical data modeling and database design using Erwin.
• Extensive experience in installation , Upgrades and configuration of MSSQLServer2014,2012,008 , 2005 and 2000 versions on both Standalone and Cluster Environments .
• Experience in Extracting, Transforming and Loading ( ETL ) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Data Loading Experience in SQL Server 2008/2012 using SSIS/SQL Server Data Tools ETL and Experience in developing packages in SSIS and DTS according to task.
• Experience in different reporting tools like Sql Server Reporting Service (SSRS), Jasper Soft Studio Professional and Cognos .
• Experience in creating various reports like drilldown , subreports , parameterized , multi-valued and various adhoc reports through Report model creation .Experience in creating data driven and standard subscription of report using SSRS .
• Experience in Designing and Building the Dimensions and cubes with star schema and Snowflake schema using SQL Server Analysis Services ( SSAS ).
• Experience in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.
• Vast knowledge and experience in Health Care industry, experienced in working with different healthcare ERP solutions such as FACETS, MedPlus, EPIC and other claim processing solutions.
• Experience in Database Backup Recovery and Disaster Recovery procedures (Logshipping, Mirroring,Clustering and Replication).
• Experience in extracting and transforming transactional information using DTSImport/Export wizard , BCP(BulkCopy Program), DTS(DataTransformationServices) and SSIS Packages from SQLServer .
• Defined and administered database standards , controls , procedures and documented the same.
• Highly experienced in investigating and applying necessary SQL Server database Servicepacks , hotfixes and SecurityPatches .

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, C, C++, VB.Net, C#.Net,VSS, HTML, UNIXShellscripting.

Tools: MSSQL Server Integration Service (SSIS), MSSQL Reporting Services (SSRS), MS SQL Server Integration Service (SSMS), MSSQL Server Index Tuning Wizard, Erwin Data Modeler, SQL Server Business Intelligence Development Studio (BIDS),SQL SERVER Data Tools(SSDT),MS SQLProfiler,Query Analyzer,Export&Import(DTS), Performancepoint

ETL Technologies: SQL Server Integration Service (SSIS), SQL Server Data Tools (SSDT), JasperSoft ETL 5.6.2

Reporting Services: SSRS, Cognos, Jaspersoft 6.2.1

Database: MS SQL Server 2014/2012/2008/2005/2000, Oracle 10g, MicrosoftAccess2007/2003

Operating System: Windows (XP, Vista, 7, 8), Linux

PROFESSIONAL EXPERIEN CE:

Confidential, Somerset, NJ

SQL/JAVA Developer

Responsibilities:

• Work within an Agile methodology to design, develop, test, and implement reporting features and functions.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Involve in gathering report requirements and making FRD (Functional Requirement Documents).
• Designed and develop various reports like chart, HTML5, Cross tab, Table and bubble report using JasperSoft studio.
• Design, develop, and support reports and dashboards using Jaspersoft reporting platform and related tools
• Used various expression and custom API in order to format tooltip and other properties of charts.
• Import and export reports from DEV to QA Server.
• Used SVN for updating, branch management and merging file.
• Generated different FRS (Functional Requirement Document) for various ETL jobs.
• Created jobs using JETL for data extraction from Flat Files, Excel Files to SQL Server.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using Jasper Soft.
• Create queries to provide ad hoc reports, analysis, and datasets based on business needs.
• Troubleshoot data issues, validate result sets, recommend and implement process improvements.
• Create report mockups and templates from business requirements when necessary.

Environment: JasperSoft 6.2.1, Jasper ETL 5.6.1, MS SQL Server 2014, SVN, SQL Server profiler

Confidential, Dayton, OH

Senior SQL Server Developer

Responsibilities:

• Involved in installing and maintaining MS SQL Server 2008/2012/2014.
• Design and develop various SSIS package, using script task, data flow task, conditional split, execute sql task.
• Developed SSIS packages which has header and footer with increment sequence number.
• Design and developed ssis package to extract data for members and providers from SQL server to flat files.
• Modified packages from old version .
• Developed various stored procedure, functions, views in order to load data from FACET system.
• Modified SSIS package to load millions of rows by breaking one flat file into multiple small flat file.
• Defined logging and dynamic configuration of the package using sql server 2012 data tools.
• Create various SSIS catalog and sql server agent job script in order to deploy package into SQL server 2012 SSIS server.
• Develop SSRS reports and configure SSRS subscriptions per specifications provided by internal and external clients.
• Extensively created SSRS reports (Executive Summary report for Annual and Quarterly) and Configured Report Server on all the environments. Also automate deployment for SSRS reports for all the environments.
• Implemented multiple grouping into several reports using visibility and toggle options.
• Design and develop History table in order to get daily extract.
• Created numerous ordinary to complex queries involving multi-table joins, Union, Correlated, Subqueries,CTE's,views from diverse business requirement.
• Tuned and optimized queries by altering database design, analyzing different query options and Indexing strategies.
• Created databases and schema objects including tables , indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Developed, deployed, and monitored SSIS Packages.

Environment: SQL server 2014, SQL server 2012, SQL server data tools 2010, SQL Server Management Studio

Confidential, Richmond, VA

SeniorSQLServerTSQL/SSIS/SSRS Developer

Responsibilities:

• Involved in complete Software development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Created Databases, Tables, Cluster / Non-Cluster Index, Unique / Check Constraints, Views, Stored Procedures, Triggers.
• Wrote efficient stored procedures for the optimal performance of the system. Monitored performance and optimized SQL queries for maximum efficiency.
• Responsible for Creating and Modifying T-SQL stored procedures / triggers for validating the integrity of the data.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2008 and Flat files.
• Involved in Report Design and Coding for Standard Tabular type reports, including Drill down and Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Created Cross-Tab and Sub-Report using RDL and promoted RDLs to Reporting Service Server.
• Scheduled the monthly/weekly/daily reports to run automatically.
• Created different kind of stored procedure, function, trigger and views.
• Responsible for performance tuning of stored procedure using sql server analyzer and sql profiling task.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages. Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Implemented Event Handlers and Error Handling in SSIS packages. Created SSIS packages forData Conversion using data conversion transformation.
• Worked on various tasks and transformations like Execute SQL Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.

Environment: MS SQL Server 2008, T-SQL, SQL server Integration service 2008, SQL Erwin, Query Analyzer, Index Tuning wizard, SQL Profiler, Confidential Visual Studio 2010,Team Foundation Server 2010, Visual Source safe, SQL server reporting service.

Confidential, Charleston, WV

Senior SQLServer TSQL/SSIS/SSRS Developer

Responsibilities:

• Developed Logical and physical data model using Erwin and mapped the data into database objects.
• Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different Database.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views .
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and optimizing indexes. Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Created SSIS packages to load data from NDC, DEA AND NPI files using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task.
• Created SSIS Packages to export and import data from CSV files, Text files and Excel Spreadsheets.
• Scheduled SSIS package to run based business requirements.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Ad-Hoc Reports, Summary Reports, Sub Reports and Drill-down Reports using SSRS.
• Taking Database full Backup, Transaction log backup & differential backup in daily Routine.
• Created Alerts for successful or unsuccessful completion of scheduled Jobs.
• Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and database Engine Tuning Wizards.

Environment: MS SQL Server 2012, T-SQL, SQL server Integration service 2012, SQL server reporting service 2012Confidential, New York, NY

Senior SQL Server TSQL/SSRS Developer

Responsibilities:

• Planned , Defined and Designed database based on business requirement and provided documentation .Developed various views and stored procedure in order to update the data using another database .
• Generated heavy-duties TSQL in order to join data from various views and function like left join, inner join and outer join .Developed different kinds of report like parameterized report, tabular, matrix, chart and custom reports .
• Designed and develop various types report for example performance report by security , performance report by asset class , portfolio overview , portfolio subreport .Created various labels and add them into portfolio group using APX system and use that label into queries in order to get values.
• Designed ad- hoc report using report builder 2.0 and maintained security on this reports.
• Development and maintenance of custom reports and queries in a multi-platform environments .
• Developed various reports SQLServer Reporting Services(SSRS) from both relational databases and OLAPcubes .
• Involved in report tuning for the report that are slowly running and fits long reports in one page. Create data- driven and standard subscription for the report delivery and secure reports by assigning system and item level security .
• Evaluated database performance and performed maintenance duties such as Tuning, Backup , Restoration and DisasterRecovery .
• Created Reports in SSRS with different type of properties like Chart controls,filters,Interactive sorting , SQL parameters etc.
• Created Datasets in T-SQL , stored procedures for SSRS .

Environment: MSSQLServer2008R2,SQLserverReportingservice(SSRS),SQLservermanagement studio (SSMS),T-SQL, MS Office 2010, Advent4.0

Confidential, Somerset,NJ

SeniorSQL Server SSIS/SSRS Developer

Responsibilities:

• Involvedin gathering user requirements , application design and analysis of hardware requirements to meet business needs.Responsible for Data Modeling and involved in designing logical and physical data model using Erwin tool .
• Developed various T-SQL stored procedures , triggers , views and adding/changing tables for data load , transformation and extraction .
• Developed ETL packages with different data sources ( SQLServer , Flat files , Excel source files , Oracle ) and loaded the data into target tables by performing different kinds of transformations using SSIS .
• Applied various data transformations like Slowly Changing Dimension(SCD), Aggregate , sort Multicasting , Conditional Split , Derived column etc. Experience in Production support and troubleshooting .
• Created Packages by testing and Cleaning the Standardized Data by using tools in DataFlow Transformations(Data Conversion,Export Column,Merge join,Sort,Union all,Conditional Split and more)for existing/newpackages .
• Createdand scheduled SSIS packages for running AM and PM feeds from various departments and multiple servers and resources to Development Servers . Logged various packages as well as individual tasks using SQL server log providers like textfile , SQL server database , trace file , xml file .
• Identifying the source of error/issue reported and carrying out the preliminary resolution steps using various troubleshooting tools / Knowledgebase .
• Implemented OLAP Cubes , Facts and Dimensions for providing summarized and aggregate views of Large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways-hierarchically and using custom groupings that the company will use to analyze performance .
• Implemented perspectives , partitions , aggregations, roles , calculated members , calculated measures .
• Generated SQLServer Drilldown , Drillthrough , Adhoc , Crosstab report using SSRS to fit business requirements .
• Reports parameters included single valued parameters , multi-value parameters which also consisted of different parameter like hidden,default,internal .
• Responsible for database tuning using normalization and applicationtuning . Documentation for all kinds of reports and SSIS packages .

Environment: SQL Server 2008,T-SQL,SQL server Integration service 2008,SQL server reporting service 2008,SQL server Analysis service 2008, Erwin,Query Analyzer,Index Tuning wizard, SQL Profiler,Windows server2003

Confidential

SQL Server Developer/DBA

Responsibilities:

• Actively Participated in developing logical model and implementing requirements on SQLServer2000 .
• Implemented complex conceptual database design into SQL Server 2000 using various Constraint and Triggers .
• Implemented complex business requirement in back end using efficient stored procedure and flexible function and facilitated easy implementation to the Front end application .
• Prepared Reports using MSAccess to highlight discrepancies between customer expectations and customer service efforts .
• Involved in development of automated daily,weekly and monthly system maintenance tasks such as Database backup,Replication Verification and Database integrity verification and Indexing updates .
• Worked on Linked servers to run Distributed queries between SQLServers .
• Scheduled Jobs and Alerts using SQL Server Agent .
• ManagedLogin and UserAddingLogins, Roles andGroupsto the WindowNT and MS SQLServer and Maintainingpropersecurity procedures .
• Creating and managing schema objects such as Tables , Views , Clusters , Indexes , Procedures , Triggers and Maintained Referential Integrity .
• Developed DTS Packages together Reports, routinely, in the Excel sheets, required bythe managers for analysis.
• Expert in planning and implementing MS SQL Server Security and Database Permissions .
• Performance Tuning of SQL queries and stored procedures using SQLProfiler and IndexTuning Wizard .
• Use DTS and T-SQL Stored procedures to transfer data fromDifferent data sources to Staging area and finally transfer into Data warehouse . Backingup master & system databases and restoring them when necessary.
• Migrated data from Excel to SQLServer .

Environment: MSSQLServer2000,T-SQL,DTS,Oracle8i/9i,TOAD,WindowsXP,2000,Micro strategy7.x Confidential

SQL Server Developer/DBA

Responsibilities:

• Actively Participated in developing logical model and implementing requirements on SQLServer2000.
• Implemented complex conceptual database design into SQL Server 2000 using various Constraintand Triggers.
• Implemented complex business requirement in back end using efficient stored procedure and flexible function and facilitated easy implementation to the Front end application.
• Prepared Reports using MSAccess to highlight discrepancies between customer expectations and customer service efforts.
• Involved in development of automated daily,weekly and monthly system maintenance tasks such as Database backup,Replication Verification and Database integrity verification and Indexing updates.
• Worked on Linked servers to run Distributed queries between SQLServers.
• Scheduled Jobs and Alerts using SQL Server Agent.
• ManagedLoginandUserAddingLogins, RolesandGroupsto the WindowNTandMS SQLServerand Maintainingpropersecurity procedures.
• Creating and managing schema objects such as Tables, Views, Clusters, Indexes, Procedures, Triggersand Maintained Referential Integrity.
• Developed DTS Packages together Reports, routinely, in the Excel sheets,required bythe managers for analysis.
• Expert in planning and implementing MS SQL Server Security and Database Permissions.
• Performance Tuning of SQL queries and stored procedures using SQLProfiler and IndexTuning Wizard.
• Use DTS and T-SQL Stored procedures to transfer data fromDifferent data sources to Staging area and finally transfer into Data warehouse.Backingup master & system databases and restoring them when necessary.
• Migrated data from Excel to SQLServer.

Environment: MSSQLServer2000,T-SQL,DTS,Oracle8i/9i,TOAD,WindowsXP,2000,Micro strategy7.x,