PROFFESIONAL SUMMARY

• Around 7 years of IT Experience in Database Design, Development and Business Intelligence of Microsoft SQL Server 2000/2005/ 2008/2012/2014 in Development, Test and Production Environments on various business domains like Financial, Insurance and Manufacturing.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2005/2008 R 2/2012/2014.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services (SSAS). Worked Extensively on ETL process using SSIS packages.
• Experience in Creating Tables, Joins, Views, Indexes, Triggers, Stored Procedures, User Defined Functions, synonyms, collections, Exception handling, Query Tuning using query optimizer.
• Experience in developing, monitoring, extracting and transforming data using DTS/SSIS, Import Export Wizard, and Bulk Insert.
• Expertise in Microsoft Integration Services SSIS (Control Flow tasks, Data Flow tasks, Transformations, Database administration tasks).
• Experience in maintenance and Administration of SSIS by creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Very good knowledge in scheduling and deploying reports on report manger
• Strong Knowledge on concepts of Data Modeling Star Schema/Snowflake modeling, FACT & Dimensions tables and Logical & Physical data modeling.
• Experience in Creating cubes using SSAS tool, worked on Tabular Modeling (SSAS Tabular), worked onDAX queriescreated tabular model solutions, worked on tabular model databases, Imported data from multiple sources and enriched the model.
• Skilled in Analysis Services OLAP cube and view development in SSAS 2005/2008/2012.
• Intensive experience in monitoring database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Experienced in strategically implementing the indexes such as Clustered index, Non - clustered index, covering index appropriately on data structure to achieve faster data retrieval.
• Good knowledge in Normalizing and De-normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in data administration activities for database security (creating logins, users, roles and assigning permissions to them)
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Experience in Analyzing Execution Plan and managing indexes and troubleshooting deadlocks.
• Involved on administration tasks such as disaster recovery with Backup and Restore Strategies, Data Loading, Batch Jobs, Data Unloading, Upgrades, Creating Databases, Files, File groups, Transaction logs, Clustering, Replication, Data Mirroring, Linked Servers, SQL Profiler, Log Shipping and Re-Indexing.
• Involved in design, enhancement, and development of applications forOLTP, OLAP, and DSSusing dimension modellingwithTeradata.
• Involved inthe designing, development and maintenance of the tracking tools using.net, C#, Visual.net, VB.net, ADO.net and ASP.net.

TECHNICAL SKILLS:

Databases: MS SQL Server 2014,2012, 2008 R2, 2008/2005/2000 , MS-Access 97-

ETL Tools: SQL Server Integration Services (2005/2008), Informatica, DTS.

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

Reporting Tools: SQL Server Reporting Services (SSRS), Crystal Reports 8/10.

Programming Languages: C#, C, C++, VB.NET, ASP.NET, Visual Basic for Applications (VBA), XML.

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, Profiler Database Engine Tuning Advisor (DTA).

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize and Quality Center (QC).

Version Control Tools: Visual Source Safe 6.0, SVN, Subversion and TFS.

Data Modeling Tools: Erwin, Red gate, Lite Speed

Design Methodologies: Logical and Physical Database Design, UML (Unified Modeling Language), Database Design and Normalization, Data Modeling.

PROFFESIONAL EXPERIENCE:

Confidential, Greensboro, NC

SQL Server Developer/ SSRS Developer

Responsibilities:

• Gather and discuss the requirement from the client and the business team, devise the architecture, process it with the team for on boarding clients.
• Created complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins to load different clients dispenses into ACMS application.
• Worked with different modules of ACMS application like Loading, Assessments, Events and Reports etc.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Created store procedures, views, and tables and generated T-SQL script for application.
• Used Visual Team Foundation server and Visual source safe for version control, source control and reporting.
• Worked with Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE’s for complex queries involving multiple tables from different databases.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler, DTA, DMV’s and DMF’s.
• Wrote optimized SQL queries in SQL Query Analyzer for efficient handling at huge loads of data.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
• Developed standards and guidelines to maintain develop and administrate the SQL Server database.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Created Tabular solutions by using relational modeling constructs such as tables and relationships for modelling data, and in memory analytics engine for storing and calculating data by usingDAX.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Pulling the data from T-SQL stored procedure to make the parameterized reports.
• Formatting the existing reports as well as creating new reports with different sources.
• Responsible for Full Report cycle including Authoring, Managing, Security and Generation of reports.
• Worked on database security, Replication and Log shipping activities.
• Worked on SQL Server Reporting Services (SSRS) and Report Builder Model to generate custom reports.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.

Environment: SQL Server 2008/2012, T-SQL, MS SQL Server Integration Services (SSIS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, VSS, TFS.

Confidential, New York City, NY

SQL Developer & Rave Customer Care Engineer

Responsibilities:

• Gather and discuss the requirement from the client and the business team, devise the architecture, process it with the team for the final output and fixing the issues with Rave.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins for building various applications.
• Worked with complex Stored Procedures, triggers, cursors, tables, and views and other SQL joins as a Production Support Engineer to fix the production issues.
• Worked on many customized report of Rave like SAS On Demand report, Audit trail reports, Subject status recalculation reports, CRF reports.
• Worked with more than fifty server, hundred databases in Production and Auxiliary environments.
• Design and developed Studies without protocol deviation to capture the clinical tail data for many clients (Majors, MID-Market and Sponsors).
• Worked with different modules of Rave application like EDC, Architect, Reports, Configuration, Clinical view, Bach Upload, PDF Generator etc.
• Created coding dictionaries in Rave to populate the different medications from Coder.
• Created new scripts and modified existed scripts to keep and maintain Rave functionalities as expected.
• Developed many CRF of versions in RAVE and created different draft in each study.
• Created SSIS packages (ETL) to migrate data from heterogeneous sources such as MS Excel, Flat Files, .CSV files.
• Created store procedures, views, and tables and generated T-SQL script for application.
• Used Visual Team Foundation server for version control, source control and reporting.
• Wrote Complex Queries, stored procedures, Batch Scripts, Triggers, indexes and Functions using T-SQL for SQL Server 2008R2/2012.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Extensively worked on Views, cursors, CTE’s, schemas, permissions and performance issues with client/server database design.
• Involved in creating Databases, Tables, Views, Cluster/Non-Cluster Index, Unique/Check Constraints, Rules and Defaults.
• Extensively used Joins and sub-queries or CTE’s for complex queries involving multiple tables from different databases.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler, DTA, DMV’s and DMF’s.
• Wrote optimized SQL queries in SQL Query Analyzer for efficient handling at huge loads of data.
• Converted various SQL statements into stored procedures thereby reducing the number of database accesses.
• Developed standards and guidelines to maintain develop and administrate the SQL Server database.
• Optimized queries using SQL Profiler and performance monitors to enhance the performance of database servers.
• Established and documented a complete Disaster Recovery Plan for the Database servers as a proactive team member.
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Created Tabular solutions by using relational modeling constructs such as tables and relationships for modelling data, and in memory analytics engine for storing and calculating data by usingDAX.
• Worked with report parameters and performed Parameterized and cascading parameterized reports using SSRS.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.

Environment: SQL Server 2008/2012, T-SQL, MS SQL Server Integration Services (SSIS), Excel, MS Access, Microsoft BI, Windows Server 2008, Visual Studio, SQL Server Data Tools, Query Analyzer, SQL Server Profiler, SVN version controlling.

Confidential, Richardson, TX

Sr. SQL Server SSRS/SSIS Developer

Responsibilities:

• Designed ETL solution of moving data from MSSQLServer Source Systems to DB2 Destination systems based on the inputs fromBIArchitect.
• Utilized Common Table Expression (CTE) to enhance performance of SQL queries in refresh of materialized views and data retrieval times
• Actively involved in design of a new normalized data store (NDS) based on Data Vault Methodology as well as a DE normalized Data Store (DDS) per Dimensional Model.
• UMLwas used for Visual modeling and a detailed Use Case Specification was developed to describe the design, architecture and dynamic behavior of the system.
• Created SSIS Packages to import the data from Oracle databases, XML, text files, Excel files.
• Used Data Flow task, Execute package task, Execute SQL Task, for each loop container in SSIS for transformation of the data.
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Convert business requirements into actionable technical requirements for the project.
• Created SSIS packages to SQL Server instances in SSIS 2012 using CDC feature.
• Created several SSIS packages for performing ETL operations to transform data from NDS to DDS systems.
• Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) has assigned.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Worked on Tabular Modeling (SSAS Tabular) andDAXqueries, created tabular model solutions, worked on tabular model databases, Imported data from multiple sources and enriched the model.
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2008/2012/2014 Analysis Services (SSAS) and Reporting service (SSRS)
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Worked onSharePoint2010 content types, site columns, managed metadata, KwizcomSharePoint Add-ons like Cascading Lookup plus & Smart Notifications, third party Workflow development tools.
• Used VB script in script components for data transformations and UsedASP.NETGlobalization for the application to work for multiple cultures.
• Involved in migration from SQL Server 2005 to SQL Server 2008, 2012 and 2014.
• Designed and supported ETL for data pull into reporting and downstream apps as one by merging data sets from existing and new data warehouses.
• Designed the ETL for merge operation as migration was to be done in phases with the view of shutting down old processes as transition happens to new data warehouse, old becoming void eventually.
• Challenge being conforming two sets of data with different hierarchy, to be presented to the users as one.
• Generated Reports using datasets or views from NDS directly or DDS for the reports using SSRS 2012.
• Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.
• Performing the tasks of data conversions, adding derived columns in SSIS.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and Build database queries and test cases for the testing team to test the reports.

Environment: SQL Server 2008 R2/2012, Business Intelligence Studio (SSAS, SSIS, SSRS), Tableau, SharePoint 2010, VB.NET, XML, T SQL, Erwin, MS Excel, ASP.NET, ETL, OLAP.

Confidential

MS SQL Server Developer

Responsibilities:

• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Processing the cubes and dimensions on a daily basis using the SSIS tasks.
• Created SSIS packages to Oracle and other SQL Server instances in SSIS 2012.
• Created several SSIS packages for performing ETL operations to transform data from OLTP to OLAP systems.
• Performed the task of data transfer from files in remote server to folders in another server using FTP.
• Created database maintenance plans and deleting of history data using SSIS packages.
• Performing the tasks of data conversions, adding derived columns, sending results in mails is done by making use of various tasks in SSIS.
• Worked with vb.net developers to create reports which can be accessed by portals.
• Deployed SSIS packages and Reports to Production Servers.
• Involved in Migration of SSRS 2008 to SSRS 20012.
• Deployed Reports using SQL Server Reporting Services (SSRS) and ProClarity.
• Created Data warehouse Cubes in SQL Server Analysis Service (SSAS).
• Designed Cubes with Star Schema using SQL Server Analysis Services 2008 (SSAS).
• Created several SSIS packages for performing ETL operations to transform data from a cube using MDX.
• Configured SSRS with MOSS 2010 for directly deploying the report in sharepoint 2010.
• Developed the SQL Server Integration Services (SSIS) packages to transform data from MS SQL 2008 to MS SQL 2012 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Performed maintenance of Stored Procedures to improve Performance of different front end Applications.
• Worked on T-SQL programming, stored procedures, user-defined functions, cursors, views setup and management of linked servers to Non-SQL-Server databases.
• Extracting the data from the different sources (CSV files, oracle, and MS SQL 2012) and stored the data into the intermediate Staging Database using the SSIS tool.
• Transform the data from the staging database and perform the transformation using the Data Flow Tasks.
• Developed T-SQL queries and stored procedures with multiple parameters to created data sets for reports.
• Developed reports in SSRS 2012 and deployed reports into SharePoint Server 2010 (MOSS).
• Experienced in Developing and Extending OLAP Cubes, Dimensions and data source view.
• Developed complex stored procedure using T-SQL to generate Ad hoc reports using SSRS.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.
• Build database queries and test cases for the testing team to test the reports.
• Prepared the reports for the day-to-day as well as weekly/monthly purposes in various formats like MS Excel, PDF, HTML, and XML etc.
• Used SSRS Report Manager to assign roles, permissions and to create report schedules.

Environment: SQL Server 2005,2008, R2, Business Intelligence Studio (SSAS, SSIS, SSRS), Performance Point Server, SharePoint 2007, T-SQL, Erwin, MS Excel, ASP.NET, ETL.