SUMMARY:

• Over 8 years of IT experience in the use and development, design, support and migration of Microsoft SQL Server 2014/2012/2008/2005 databases.
• Involved in various phases of Software Development Life Cycle (SDLC) including analysis, design, testing, implementation and maintenance.
• Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Highly proficient in the use of T - SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Extensively wrote SQL Queries (Sub queries, correlated sub queries and Join conditions) for Data Accuracy, Data Analysis and Data Extraction needs.
• Experienced in Logical and Physical Database design, development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Performed the Data Accuracy, Data Analysis, Data Quality checks before and after loading the data.
• Involved in creating the data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Experience in extracting and transforming (ETL process) data using DTS/SSIS Import Export Data from various sources, Bulk Insert, Log Shipping, BCP and DTS/SSIS Packages.
• Worked on SSIS 2012 Package deployments and Dreamweaver.
• Extensive working knowledge on Migration from SQL 2008 to SQL 2012.
• Worked on Server side development according to the business requirements.
• Used Data Quality Services within SSIS 2012 for data Cleansing and data profiling.
• Used Power view within SSRS 2012 for statistical analysis.
• Worked on full and differential packages
• Extensive working on Performance Optimization and Database Tuning
• Worked on Database Participations for Improvement in Query Performance.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like MS SQL Server 2012, Excel and Flat file to Microsoft SQL Server by using SSIS and DTS utility of SQL server 2014/2012/2008.
• Extensive experience with SQL Server Reporting services (SSRS) in design, development and deployment of different kinds of reports: simple, parameterized, drill-down, ad hoc, linked, snapshot, Cross-tab, sub reports etc.
• Extensive experience in designing, developing and publishing the reports using Business Intelligence Development Studio (BIDS).
• Hands on experience in scheduling the reports and subscriptions using report manager in SSRS.
• Experience in generating Ad-Hoc, Drill down, Drill Through reports using local and Global variables, Expressions and Filters in SSRS.
• Experience on healthcare claims processing.
• Knowledge on HEDIS, QSI, QSHR.
• Experience on EDI Data components, custom development and operations support.
• Experience in testing Electronic Data Interchange (EDI) per HIPPA Compliance.
• Created standard operating procedure documents outlining EDI best practices for the EDI production system that handles interactive and batch 5010 HIPPA standard transactions.
• Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILL:

MS SQL Server 2014/2012/2008/2005, MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), T-SQL, HTML, XML, MS Access 2010, Excel, SQL Query Analyzer, SQL Enterprise Manager, Management Studio, SQL Server 2005 Query Editor, Business Objects, Solution Explorer, Analysis Manager, Reporting Server, Data Transformation Services (DTS), Parallel Data Warehouse(PWD), Business Analysis, Object-Oriented (Use Case) Analysis, VBA (Visual Basic for Applications), Database Design and Normalization, Data Modeling, Database designer, E-Commerce, Cognos, Microsoft Visio, MS Office 2007

PROFESSIONAL EXPERIENCE:

Confidential, Fort Lauderdale, FL

SQL Developer/Data Analyst

Responsibilities:

• Involved in interacting with the end-user (client) to gather business requirements.
• Participated in analyzing and modeling the requirements for the logical and physical design of the database using star schema and normalization techniques.
• Involved in Data Mining, Profiling and Data Modelling.
• Designed and developed the star schema Data model, Fact Tables to load the Data into Data Warehouse.
• Migrated stored procedures from oracle to SQL server.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Design, develop, implement, and assist in validating ETL processes - full ETL development lifecycle and maintain existing ETL processes and trouble shoot issues if they arise.
• Development of mappings according to the ETL specifications for the staging area data load using SQL Server.
• Experience in designing the packages and data mapping (ETL) using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task, Derived Column Task and Script Task in SSIS Designer using visual studio.
• Designed and developed packages for data warehouse using Integration Services (SSIS) SQL Server 2014.
• Involved in providing ETL support for the production server.
• Experience in the design, development and deployment of databases and automation initiatives using the SQL Server 2014 platforms.
• Identifying and resolving source data issues.
• Working on Database Development and Data Conversion.
• Design store proc, view, index, function for data ware housing.
• Experience on creating Data Mart, Data Modeling and Performance Tuning.
• Experience in Data Migration from Oracle to SQL Server
• Experience on ad hoc queries and customize report writing.
• Working on Tableau Dashboard to create and support Report/Chart/Graph.
• Experience on developing and deploying of different kinds of reports: simple, parameterized, drill-down, ad hoc, linked, snapshot, Cross-tab, sub reports etc using SSRS and Report Builder 3.0.
• Perform Unit Testing of ETL Programs to support QA on End-to-End testing.
• Data Analysis and Modeling including data quality, source systems analysis, business rules validation, source target, mapping design, performance tuning and high volume data loads including automation process.

Environment: MS SQL Server 2012/2012, MS SQL Server Reporting Services 2014, MS SQL Server Integration Services 2014, XML, MS Access 2010, MS Excel 2010, Share point (MOSS), VBA (Visual Basic for Applications), Business Object, Oracle 12c.

Confidential, MD

Sr. SQL Developer-SSRS/SSIS

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Designed star schema with dimensional modeling, created fact tables and dimensional tables
• Designed and developed the star schema Data model, Fact Tables to load the Data into Data Warehouse
• Prepared the complete data mapping for all the migrated jobs using ETL.
• Experienced in designing the packages and data mapping (ETL) using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task, Derived Column Task and Script Task in SSIS Designer.
• Experienced on ad hoc queries and customize report writing.
• Experienced in Model, build and test systems in accordance with the agile development methodology.
• Created reports using graphs, charts (bar, area, pie) for business and marketing analysis and also worked on weekly, monthly parameterized reports.
• Converting Crystal Reports to SQL Server Reporting Services .
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
• Experienced on HEDIS reporting and HEDIS Monthly Load including QSI and QSHR tools.
• Experienced with Medicaid/Medicare date and their implications on data transformation and interchange with third party vendors.
• Experienced with the various Medicaid payment processes including capitation payment, 1099 and member premium payments.
• Worked on analyzing, design, develop, test, troubleshoot, optimize, enhance and maintain data integration and EDI applications in various formats that include HIPAA standard formats (e.g. 837, 834), other regulatory formats, and custom file layouts using a combination of SQL and data mapping tools.
• Experienced with Medicaid member eligibility and enrollment processes.
• Experienced on ICD Conversion, Medicare and Medicaid data.
• Experienced working on Team Foundation Server.

Environment: MS SQL Server 2008/2012/2014, MS SQL Server Reporting Services 2008/2012, MS SQL Server Integration Services 2012, XML, MS Access 2010, Excel, Business Objects, VBA (Visual Basic for Applications), Share point (MOSS), .Net

Confidential, Long Beach, CA

Sr. SSRS/SSIS Developer/Data Analyst

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) including analysis, design, testing, implementation and maintenance
• Experienced on creating different types of SSRS reports such as Cross-Tab, Conditional, Pie Chart Reports, Drill-down, Top N, Summary and Sub reports, ad-hoc reports and formatting them using SSRS and report builder 3.0.
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required.
• Reviewed high-level design specification, ETL coding and mapping standards.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse.
• Designing Developing and Deploying SSIS Packages.
• Configuring and Migrating SSIS Packages from SQL Server 2008 to SQL Server 2012.
• Experienced in designing the packages and data mapping using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task, Derived Column Task and Script Task in SSIS Designer.
• Experienced on STARS Ratings, HEDIS reporting.
• Managed, updated and manipulated report orientation and structures with the use of advanced Excel functions including Pivot Tables and V-Lookups.
• Experience working on QSI, QSHR tools to validate HEDIS dada and monthly project.
• Experienced on CAHP, Medicare and Medicaid data.
• Experienced on EDI Data components, custom development and operations support.
• Experienced with Medicaid/Medicare date and their implications on data transformation and interchange with third party vendors.
• Experienced in the design, development and deployment of databases and automation initiatives using the SQL Server 2008 and 2012 platforms.

Environment: MS SQL Server 2012/2014, MS SQL Server Reporting Services 2014, MS SQL Server Integration Services 2014, XML, MS Access 2010, .Net, MS Excel 2010, Share point (MOSS), Business Objects, VBA (Visual Basic for Applications).

Confidential, Bowie, MD

Data Analyst-SSRS/SSIS

Responsibilities:

• Experience in the design, development and deployment of databases and automation initiatives using the SQL Server 2008 and 2012 platforms.
• Involved in various phases of Software Development Life Cycle (SDLC) including analysis, design, testing, implementation and maintenance.
• Experience in Model, build and test systems in accordance with the agile development methodology.
• Maintained system protocols by writing and updating procedures.
• Performed code inspections and refactor code to best practice standards.
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Experience on ad hoc queries and customize report writing.
• Developed Report Models using report builder 3.0 and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS)
• Developed customs reports and deployed then on server using (SSRS).
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.
• Knowledge on HEDIS, QSI, QSHR.

Environment: MS SQL Server 2008/2012, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2012, MS Access 2010, Excel, VBA (Visual Basic for Applications), Share point (MOSS)

Confidential, New Town Square, PA

MS SQL Server/SSRS Developer

Responsibilities:

• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Deployed reports onto the production report server through various ways
• Developed Report Models using report builder 3.0 and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports, KPI Reports.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2012, XML, MS Access 2010, Excel, VBA (Visual Basic for Applications), Share point (MOSS), ER Studio, Performance point Server, Parallel Data Warehouse(PWD)

Confidential, Brentwood, TN

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Created script to migrate SQL server object from one environment to other environment.
• Used the SQL Server profiler to capture and store the execution plan. Created necessary indexes.
• Modified the queries to achieve better performance.
• Used SQL SERVER AGENT to automate the process of rebuilding indexes at regular interval for better performance.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Use different control flow control like for each loop container, sequence container, execute SQL task, send email task.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Responsible for creating and designing SSIS package.
• Designed Extraction Transformation and Loading (ETL) process using SSIS to extracted data from flat files, excel files and SQL server database.
• Added intelligent system in SSIS to identify actual change and new change in dimension
• Use package configuration to migrate SSIS package from one environment to other
• Deployed reports onto the production report server through various ways
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS 2012.
• Set up SQL Profiler to trace various Database activities, Application Responses and their Performance in order to tune them.
• Worked on migration of SSIS 2008 packages to SSIS 2012.
• Excellent report creation skills using Microsoft Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Based on the requirements developed and provided weekly, monthly, yearly quality control reports for work orders, service requests etc.
• Represented reports in different forms using graphs, charts, tabular, area and pie charts as required.
• Responsible for uploading and organizing the reports in report manager folders. Also, providing security and roles for those reports.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created report model projects as per the requirements using Report builder in SSRS and provided for end users.
• Promoted RDLs to Reporting Service Server (SSRS).
• Worked on scheduling the reports as required using normal and data driven subscriptions.
• Created and deployed the reports in web portals and also in share point sites as required.

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2012, XML, MS Access 2010, Excel, VBA (Visual Basic for Applications), Share point (MOSS), C#, ASP .Net, Crystal Reports, ER Studio, Performance point Server, Parallel Data Warehouse(PWD)

Confidential, Tampa FL

MS SQL Data Analyst/SSIS/SSRS Developer

Responsibilities:

• Analyzed business requirements and build logical and physical data models that describe all the data and relationships between the data using Erwin.
• Based on business requirement, developed the Complex SQL queries with Joins and T-SQL, Stored procedure, Views, Trigger to implementing the business rules and transformations.
• Used ETL SSIS to develop jobs for extracting, cleaning, transforming and loading data into data warehouse.
• Involved in designing, reviewing, and creating primary objects like Views, Indexes, Stored procedure, Functions, Triggers based on logical design models, user requirements and physical constraints.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Developed SSIS Packages to perform Data loads from various types of sources files (Excel, HML, Flat files).
• Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
• Performed daily tasks including backup and restore from disaster recovery by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler.
• Prepared the complete data mapping for all the migrated jobs using SSIS.
• Worked on migration of SSIS 2008 packages to SSIS 2012.
• Experience in working on different kinds of reports Parameterized Reports, Linked Reports and Drill-through reports.
• Developed custom reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Created report model projects as per the requirements using Report builder in SSRS and provided for end users.
• Scheduled and monitored the daily, weekly, monthly reports in the report manager and also worked on the subscriptions.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)

Environment: MS SQL Server 2005/2008/2012, MS SQL Server Reporting Services 2008, MS SQL Server Integration Services 2008, XML, MS Access, Excel, Share point (MOSS), ER Studio, Performance point Server, Parallel Data Warehouse(PWD)

Confidential, Pittsburgh, PA

MS SQL Server/BI Developer

Responsibilities:

• Involved in all phases of System Development Life Cycle (SDLC).
• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase).
• Worked on parameters to generate cascaded parameterized reports along with that extensively used global variables, expressions and functions.
• Created Views to reduce database complexities for the end users.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2008R2.
• Developed SSIS Packages using Derived Columns, Condition Split, Aggregate, Execute SQL Task, Data Flow Task, Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created reports using graphs, charts (bar, area, pie) for business and marketing analysis and also worked on weekly, monthly parameterized reports.
• Deployed the reports in report manager and organized.
• Created Sub Reports and Drill down Reports as per the client requirements using SSRS.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Extensively designed the packages and data mapping using Data Profiling Task, Control Flow Task, Sequence Container Task, Dataflow Task, Execute SQL Task, Data Conversion Task, Derived Column Task and Script Task in SSIS Designer.
• Experienced on creating tables to save dirty records.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).

Environment: SQL Server 2008R2, Integration Services 2008R2, Visual SourceSafe, TSQL, MS Access.

Confidential, Seattle WA

MS SQL Server / SSRS /SSIS Developer

Responsibilities:

• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Authored performance based reports for the managers to show sales against various measures like Time, Area, and Price-Range.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations.
• Actively supported business users for change requests.
• Monitored performance and optimized SQL queries for maximum efficiency.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Identified and added the report parameters.
• Formatted the reports using the Global variables and expressions.
• Responsible for creating the reports based on the requirements using SSRS 2008.

Environment: SQL Server 2000/2005/2008 Enterprise Edition, Visual Studio, SQL, T-SQL, MS Access 2003, MS Excel, & Windows 2003 server, Business Intelligent technologies like SSIS, SSRS, SSAS.

Confidential, West Chester, PA

MS SQL Server Developer/BI Developer

Responsibilities:

• Involved in the designing, development, modification and enhancing the database structures and database objects.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2005.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases.
• Wrote several complex stored procedures for efficient handling of the application.
• Debugged and optimized several complex stored procedures.
• Constructed cubes based on data volumes mostly adhering to Star Schema.
• Identified and worked with parameters for parameterized reports in SSRS 2005.
• Created reports using graphs, charts (bar, area, pie) for business and marketing analysis and also worked on weekly, monthly parameterized reports.
• Created and deployed Linked and sub reports as per the requirement using SSRS.

Environment: MS SQL Server 2005, MS SQL Reporting Services 2005, XML, MS Access, Excel