PROFESSIONAL SUMMARY:

• 8+ years of IT experience as a MS SQL Server Developer 2014/2012/2008/2005/2000 in various Industry verticals like Health Care, Finance and Insurance.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2014/2012/2008/2005/2000, Business Intelligence in MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), and MS SQL Server Analysis Services(SSAS).

TECHNICAL SKILLS:

SQL Server Tools: Enterprise Manager, SQL Profiler, Query Analyzer, SQL Server Management Studio, DTS, SSIS, SSRS, SSAS

Database Application Software: MS SQL Server 2012, 2008 R2,2005, 2000, MS - Access,DB2

Programming Languages: C, C++, Confidential -SQL, C#. .Net

Operating System: Windows 2000 Advanced Server, Windows 2000 data center, Windows NT, Windows 95/98/2000 XP

Reporting Tools: Crystal Reports, SQL Server Reporting services (2012,2008 R2,2005, 2000)

Architecture: Relational DBMS, Client-Server Architecture, OLAP, OLTP

Data warehouse Tools: Informatica

Web Technologies: HTML, XML

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

SQL/SSIS Developer

Responsibilites:

• Create Tables, stored procedure, views and functions on sql server.
• Create SSIS Packages as required to implement the expected data integration.
• Load the data from Teradata, Excel and csv files to sql tables.
• Automated SSIS Package to retrieve multiple CSV/EXCEL files and loaded into tables.
• Create and schedule weekly SSIS package jobs to pull the file from shared location and moving to archive folder.
• Create Tables which act as staging and landing.
• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.
• SQL Server 2012 OLAP database development including KPIs, Data mining, working with slow changing dimensions
• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.

Environment: SQL Server 2008R2/2012/2014,TSQL, SQL Server Management Studio, SSIS 2012, Import Export Data, BIDS Studio, Microsoft Excel,TeraData.

Confidential, Charlotte, NC

SQL/SSIS/SSRS Developer and Hyperion Dev/Admin

Responsibilities:

• Worked on Confidential -SQL to create tables, views and stored producers
• Handled large data and responsible for cleansing, maintaining and finding issues and fixing accordingly.
• Optimizing the data base design to enhance performance and efficiency associated with data retrieval and manipulation.
• Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.
• Developed and scheduled Hyperion reports in daily, weekly and monthly basis.
• Used SVN repository as source control.
• Created Indexes and involved in Performance tuning
• Assisting in SQL Server optimization including indexing and query optimization.
• Resolved deadlocks and blocking issues using Performance Monitor, SQL Server Profiler.
• Worked as Hyperion admin like providing access for reports and folders to business users.
• Provided to the Hyperion users in running the reports and consolidations and also to analyze the call history data using Hyperion Visual Analyzer and showed how to export reports to various formats.
• Led a Hyperion team of six, responsible for migrating and converting the older version Hyperion Brio reports and Business Objects to the Hyperion Interactive Reporting and Sign on Signoff Reporting. And Based on Requirements converted the Hyperion reports to EDI reports.

Environment: SQL Server 2008R2/2012,Transact SQL, XML, SQL Server Management Studio, SSIS 2012, Import Export Data, BIDS Studio, Microsoft Excel, Hyperion Web Client.

Confidential, JUNO Beach, FL

MSBI Developer

Responsibilities:

• Understand client business requirements and analyze the doable and technical challenges involved.
• Create SSIS Packages as required to implement the expected data integration.
• Extensively worked with SSIS tool suite, designed and created mappings using various SSIS transformations like OLEDB Command, Conditional Split, Lookup, Aggregator, Multicast and Derived Column.
• Performance tuning of sql queries and stored procedures using sql profiler.
• Pull data from Informatica and loading into SSMS
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cubes.
• Enhanced the query performance using Clusterd and Non - Clustered Indexes.
• Maintained and scheduled Auto jobs with batch scripts.
• Designed dynamic SSIS to transfer data crossing different platforms, validate data during transferring, and archived data files for different RDBMS.
• Wrote stored procedures and User Define scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Designed and implemented Data Integration and ETL processes with SSIS packages.
• Developed code for Script tasks to handle explicit functionalities that SSIS do not provide in tools.
• Created few intermediate tables to handle data flow from source to destination.

Environment: SQL Server 2008R2/2012,Transact SQL, XML, Web Services, SQL Server Management Studio, SSIS 2012, Import Export Data, BIDS Studio, Microsoft Excel,Teradata.

Confidential, Fort Lauderdale, FL

SQL Server SSIS/SSRS Developer

Responsibilities:

• Develop SQL (or/and) Salesforce queries that required to get data from Data sources.
• Design required tables that may act as Staging.
• Using Microsoft Business Intelligence (MSBI) technology and develop ETL packages using Visual Studio Business Intelligence Studio.
• Provided extensive testing on the performances of Stored Procedures.
• Experience using tfs for code check in and check out.
• Perform unit testing of the packages and make sure the functionality is as expected.
• Designed and created SQL Databases, tables and views based on user requirements.
• Created SSIS packages to load data into target database using Various SSIS Tasks.
• Involved in scrum calls to gather Business requirements from Business people.
• Scheduled Packages using SQL Server Agent Jobs.
• Used MDS and DQS to importing and exporting data from source to destination.
• Experience in using of powepivot in Excel.
• Responsible for creating reports based on the requirements using SSRS.
• Deployed the generated reports on the server.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

Environment: SQL Server 2012, Transact SQL, SQL Server Management Studio, SSIS 2012, Import Export Data, BIDS Studio, Microsoft Excel, tfs.

Confidential, Rhode Island

SQL Server SSIS/SSRS Developer

Responsibilities:

• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Created joins and sub-queries for complex queries involving multiple tables.
• Worked with the application developers and provide necessary SQL Scripts using Confidential -SQL.
• Optimized the queries by running the Execution Plans and creating indexes as required in SQL Server Management Studio.
• Implemented the Error handling in the Stored Procedures and SQL Objects and also modified already existing stored procedures, views.
• Developed packages for loading various CSV files, MS Excel, MS Access etc into SQL Server using SSIS 2012.
• Create SQL or MS Access queries to pull data from QNXT for validation purposes.
• Scheduled Packages using SQL Server Agent Jobs.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Bulk Insert task, Data flow task, File system task, Send mail task, script task etc.
• Collected data from various data sources like excel, flat file etc and used different types of transformations and loaded into their destinations.
• Designed various Tablix and Matrix reports with Drill Down and Drill Through capabilities.
• Deployed and scheduled Report subscriptions on daily/monthly basis using Report Manager in SSRS.

Environment: SQL Server 2012, MS-Access, Transact SQL, Query Analyzer, SQL Server Management Studio, SSIS/SSRS 2012, Import Export Data, BIDS Studio, Microsoft Excel, QNXT.

Confidential, Grand Rapids, MI

Data Analyst/SQL Server SSIS/SSRS Developer

Responsibilities:

• Creating application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and UDF (User Defined Functions) according to the requirements of the project.
• Developed User-Defined Functions to implement the Custom Business Logic.
• Wrote test conditions and test scripts for all the stored procedures.
• Responsible for Code debugging or syntactic issue resolution.
• Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
• Created SSAS OLAP cubes and partitioning cubes, monitored and full and incremental load using cube wizard.
• Used Inner joins, Outer joins and other Complex joins for data retrieval from complex tables.
• Enhanced the Query performance using Cluster and Non Clustered indexes.
• Created Stored Procedures, Triggers, Views and Functions for the Application.
• Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML files to SQL Server using Business Intelligence Development Studio Used in multiple transformations in SSIS to meet the business requirements by collecting data from various sources.

Environment: MS SQL Server 2012/2008,ASP.NET,C#,ADO.NET,Web Services-SQL, SQL Server Integration Services (SSIS), SSRS, SharePoint 2010, DTS, MS Excel, MS Access, XML, Windows XP.

Confidential, Jacksonville, FL

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Automation of creating Accounting code module for each bill.
• Creating dashboards for different departments.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Created pages in the reports to display depend on Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server 2005/2008, Windows 2000/2003,Excel, TSQ, Microsoft Visual Studio 2005, SQL Reporting Services, SQL integration services.

Confidential, Atlanta, GA

SQL Server Developer / BI Developer

Responsibilities:

• Followed the Microsoft recommended best practices in designing, developing, and implementing and testing of the ETL using SQL Server Integration Services.
• Used in multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Analysis using (SSAS) and produced ad-hoc, standard and super user reports using (SSRS).
• Created OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Generated reports using SSRS, Excel (Pivot) that could be used to send information to a diverse group of users like VP, AVP, CD, Coach, Lead, SA, SR, Office Clerk.
• Responsible for creating reports based on the requirements using SSRS 2005.
• Deployed the generated reports on the server.
• Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.
• Created Stored Procedures, Triggers, Views and Functions for the Application. Provided extensive testing on the Performance of the Stored Procedures.
• Performance tuning of SQL queries and stored procedures using SQL.

Environment: SQL Server 2005, MS SQL Server Reporting/Analysis Services/Integration Services, Erwin, Windows Server 2003