OBJECTIVE:

Good experience in Database Design, Development and Business Intelligence Tools of Microsoft SQL Server 2014/2 with various verticals such as Finance, Healthcare, IT System and Engineering Services and Insurance Industry.

PROFESSIONAL SUMMARY:

• Experience in installing and configuring SQL Server 2014/2012/2008 r2 including upgrading service packs.
• Good knowledge and experience in developing Relational Database Management Systems (RDBMS), including Normalization, ER Diagrams, Constraints, Querying, Joins, Stored Procedures, Views, Indexes, Data Import/Export, Triggers, Cursors
• Strong Knowledge in writing Transact - SQL (DDL/DML) queries.
• Worked extensively in creating SSIS packages using control and data flow elements.
• Sound knowledge in Extracting, Transforming and Loading data using SSIS, SQL Server Import Export, Bulk Insert and BCP.
• Extensively used SSIS transformations such as Lookup, Fuzzy Lookup, Derived Column, Data Conversion, Aggregate, Conditional Split, SQL Task, Script Task and Send Mail Task.
• Experience in Developing SSIS Packages to Extract, Transform and Load (ETL) data into the Data warehouse from heterogeneous databases such as Oracle 11g and 9i, DB2
• Worked on Performance tuning, Indexes to facilitate efficient data manipulation and data consistency.
• Sound knowledge of Star and Snow Flake, Schemas, PostgreSQL Index and Functions.
• Experience in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2014/2012/2008 r2.Created Table, Matrix, Chart, Graph, Gauge, Indicator reports, generating Cascaded, Drill-through, Drill-down, Linked, Sub-Reports and Ad- hoc Reports in SSRS.
• Experience in deployment and scheduling of reports using Configuration Manager.
• Experienced in Conceptual, Logical and Physical Database design and development, Normalization and Data modeling using Erwin
• Scheduled jobs and alerts using SQL Server Agent and troubleshoot any failures or alert problems.
• Worked extensively on taking Back-up of new data and Recovery of old data when needed.
• Maintained positive communications and working relationships at all business levels
• Self-motivated and able to work independently as well as in a team.

TECHNICAL SKILLS:

• MS SQL Server 2014/2012/2008 r2
• SSIS 2012, 2008r2
• SSRS 2012, 2008r2
• MS SQL Profiler
• Query Analyzer
• Erwin 8.0/7.2
• C, C++
• HTML
• CSS
• ASP.Net Maker 10
• Oracle 11g
• Oracle 9i
• Microsoft Visual Studio 2008/2010
• Windows 2008/2003 Server
• Index Tuning Wizard
• Microsoft Office
• Word press
• QA knowledge on automation(QTP) manual testing (QC)

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, Ohio

MS SQL/SSIS Developer/SSRS Developer

Project Environment: Microsoft SQL server 2014/2012, BIDS/SSDT - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).

Responsibilities:

• Involved in implementing different types of reports & schedule them for reporting purposes using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis or management decision using SQL Server Reporting Services (SSRS).
• Developed and deployed Table, Chart, Matrix, Parameterized report and Sub-Reports.
• Populated dimension and Fact tables of Data Warehouse which were later used to SSAS Cube.
• Design, develop, configured & test the ETL processes according to industries best practices using SSIS.
• Interaction with clients regarding business requirements, design & implementation phases.
• Involved in writing T-SQL, stored procedures, views, triggers, cursors. Used indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager and on SQL Server environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Worked on performance tuning and used execution plan to optimize the query.
• Used Dynamic Management View and SQL profiler to tune and identify locking.
• Used Agile to Identify and act to improve team knowledge of new business processes and technologies.

Confidential, Vienna, Virginia

MS SQL Developer /BI Developer

Project Environment: Microsoft SQL server2008/ 2012, BIDS - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ASP.Net Maker 10

Responsibilities:

• Streamline and maintain the Database for the daily operations.
• Created SSIS Packages to extract data from multi formatted Flat files, Excel in Business
• Intelligence Development Studio, SQL Server Data Tools Designed, developed and deployed reports in MS SQL Server environment using SSRS
• • Scheduled and automated reports using SQL Server Reporting Services (SSRS) created SSRS reports such as tabular, matrix, pie chart reports, sub reports and dashboard reports using the BI tool.
• Created stored procedures and complex T-SQL query for ad-hoc reports, PostgreSQL Insert, Update and Delete.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases
• Also worked on Data Conversion and loading the data into SQL server database
• Created new web pages and updated existing web pages using ASP Maker
• Created weekly, monthly, quarterly and annual reports by writing code based on the requirement
• Used Bulk Insert to load data from different data sources to SQL Server.
• Developed SSIS packages and used Aggregate, Conditional split, Multicast, Derived column, Lookup and Fuzzy Lookup transformations.
• Created SSIS Packages for Data Migration and Transformation
• Involved in configured the report viewing security for various users at various levels using Report Manager.
• Used Facets for processing healthcare claim.
• Maintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension

Confidential, Hartford, CT

MS SQL Developer/SSIS/SSRS Developer

Project Environment: Microsoft SQL Server 2012, SQL Server Management Studio, BIDS - SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Agent, SQL Profiler, T- SQL, Windows 2003 server, Oracle 11g, Erwin8.

Responsibilities:

• Designed and developed data modeling for the data marts for teams with specific operations.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart databases. Migrated data from various sources such as Oracle and Access database, flat files to centralized destination.
• Transformed data from one server to other servers using various transformations in SQL Server Integration Services (SSIS).
• Created SSIS Packages to extract data from multi formatted Flat files, Excel.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS and SSIS in Business Intelligence Development Studio, SQL Server Data Tools.
• Responsible for performance tuning and query optimization using inbuilt SQL tools.
• Created various SSRS expressions for reports and Parameterized, Cascaded, Gauge, Indicator Reports.
• Created complex Excel reports and Ad-hoc reports based on the requirements.
• Scheduled and automated reports using SQL Server Reporting Services (SSRS).
• Produced operational reports in SSRS 2012 i.e. Drill-Down, Drill-through, Dashboard, Sub-Report, and Matrix reports containing operations, sales and manufacturing data.
• Attained legacy data to use as a source to develop new reports previously compiled and maintained manually.
• Created SSRS Data Model projects using Microsoft Visual Studio 2010/2008 and using Report Builder for report server to create reports.
• Maintained Backup of the data, created Job failure alerts using SQL Server Agent and restore data from the backup on request.
• Worked to create complex by weekly, quarterly and annual report by writing code based on the requirement.

Confidential, Cleveland, Ohio

MS SQL /BI Developer

Project Environment: Microsoft SQL Server 2008r2/2008, BIDS - SQL Server Integration Services (SSIS), SQL, Server Reporting Services (SSRS), SQL Profiler, Oracle 9i, Erwin 8.0

Responsibilities:

• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager and on SQL Server environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used Bulk Insert to load data from different data sources to SQL Server.
• Used SQL Server Reporting Services (SSRS) for creating and generating reports using Table, Charts, Matrix, List and Gauge.
• Developed T-SQL scripts to generate reports based on user requests. Also some PostgreSQL Indexing and Function.
• Automated weekly and monthly Database Backup jobs using SQL Server Agents.
• Supported designing of various E-R diagrams for different modules by using Erwin Created various database objects like Tables, Indexes, Stored Procedures and Views.
• Worked on SQL Profiler and Execution Plan.
• Created SSRS Data Model projects using Microsoft Visual Studio 2008 and using Report Builder for report server to create reports.