SUMMARY

• Over 7+ Years of IT experience as SQL BI Developer using MS SQL Server 2012/2008R2/2008.
• Extensive experience in implementing SSIS, SSRS using Microsoft Business Intelligence development studio (MSBI) and SQL Server data tools (SSDT).
• 2 years of Experience as a QA Analyst.
• Expertise in writing T - SQL queries using Joins, Sub queries, Stored Procedures, Views etc. in T-SQL in SQL Server.
• Expertise in writing DML DDL and Transaction queries in T-SQL for MS SQL Server database.
• Experience in checking data quality using SQL/Integration Services, identifying errors and error patterns, and suggesting some data cleansing mechanisms.
• Experience working with large and or complex data sets for business operations.
• Experience in deploying SSIS packages to multiple environments using different methodologies.
• Good knowledge of SSRS architecture and Hands on experience in developing deploying and managing Parameterized reports and Linked reports, Sub reports, drilldown reports, drill through reports, ad-hoc reports and Crystal Reports with thorough knowledge of report service architecture. (Table, chart and matrix report) using SSRS.
• Experience in configuring, scheduling reports for subscriptions on timely basis using SSRS report manager.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSISsuch asData Conversion,Conditional Split,Merge, Sort, union all etc.
• Transformed data from one server to other servers using tools likeBulk Copy Program(BCP),Data Transformation Services(DTS) andSQL Server Integration Services(SSIS)
• Experience in creating packages to transfer data between Oracle, MS Access and Flat Files to Sql Server using DTS/SSIS.
• Knowledge /Experience of Integration Services (SSIS), Reporting Services (SSRS).
• Extensive experience with Database Backups, Recovery Procedures, Backup strategies and scheduling.
• Expert knowledge in creating complex SSRS reports, deploying, scheduling, fine tuning, maintain and by flowing best practices in SQL 2012 and 2008R2.
• Experience working in Agile and Waterfall model working methodologies.
• Working knowledge in various testing levels such as Functional Testing, Regression Testing, Smoke Testing, Integrated Testing, System Testing, and Black Box Testing
• Involved back-end testing for SQL Server database using SQL Server management studio and Aqua studio,DB2
• Strong analytical and problem-solving skills coupled with excellent written, verbal and inter-personnel communication skills.

TECHNICAL SKILLS

Databases: SQL Server 2012/2008R2/2008, MS Access, My SQL

ETL Tools: SSIS, SSDT

Reporting Tools: SSRS, Crystal Reports, QlikView

Languages: C#.Net, Visual Basic

.NET Technologies: ASP.NET, ADO.NET, .Net 4.0/3.5/3.0/2.0, Web Services, Windows Services

Web Servers: Microsoft IIS

Scripting Languages: JavaScript, HTML, XML, CSS, T-SQL

Methodologies/Tools: MS Visio, MS Project

IDEs/CMS/Tools: TFS, MS Visual SourceSafe (VSS), Visual Studio 2013/2010/2008, SVN, Report Builder

Operating Systems: Windows Server 2008/2003/2000, Windows 8/7/XP

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server BI Developer

Responsibilities:

• Involved in requirement gathering and providing high-level design solutions in designing database architecture.
• Responsible for Scheduling reports to run daily, weekly and monthly basis using Report Manager.
• Experience in working on different kinds of reports such as Parameterized Reports, Linked Reports and Ad hoc reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Experience in querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email
• Experience in working with SSIS Packages for applying various business rules, using various control flow tasks, dataflow components and event handling techniques.
• Developed and Tested complex Stored Procedures and Views to generate various Ad hoc reports, Parameterized Reports and Linked Reports using SSRS.
• Automated all the existing applications and enhanced to run faster and enhancing error handling structure for better support.
• Developed dashboard reports usingReporting Services, Report Model and ad-hoc reporting usingReport Builder.
• Involved in migration from SQL Server 2008to SQL Server 2012.
• Experience in creatingParameterized reportsandLinked reportswith thorough knowledge of report serving architecture. (Table,chartandmatrix report).
• Extract Transform Load(ETL) development Using SQL server 2008,SQL 2008 Integration Services(SSIS)
• Generated several drill down and drill through reports usingSSRS.
• Created Reports and integrated reports into ASP.Net Application.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Cleaning and loading the data to SQL server side in a most flexible way and building cubes.
• Created complex based reports.
• Designed and developed RDBMS, created tables and implemented relationships between tables.
• Scheduled and ran extraction and load process and monitored sessions using SSIS.
• Modified the facts, used calculations and query designer in order to modify queries and developed reports using SSRS.
• Tested Complex level type reports in SSRS.
• Knowledge & Hands on experience with Cosmos
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSISsuch asData Conversion,Conditional Split,Merge, Sort, union all etc.
• Experience in working with SSIS Packages for applying various business rules, using various control flow tasks, dataflow components and event handling techniques.
• Created Few Decent and complex level type reports in SSRS.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Actively participated in interacted with users,team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment: MS-SQL Server 2012/2008 R2/2008 Enterprise Manager, MS Business intelligence (BIDS) SSIS, SSRS, MS Visual Studio 2010\2008, MS-Office 2010, XML, Windows Server 2008.

Confidential, Augusta, GA

SQL Server BI Developer(SSRS,SSIS)

Responsibilities:

• Responsible for identifying the requirements of business users.
• Developed SQL ETL packages according to the requirements of business users.
• Understanding the end user requirements and developing the Reports using SSRS 2008.
• Created reports in SSRS with different type of properties likechartcontrols, filters, Interactive Sorting, SQL parametersetc.
• Created SQL server Reports using SSRS 2008.
• Identified the data source and defined them to build the data source views
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS)
• Experience in creating complex SSIS packages using proper control and data flow elements with error handling.
• Designed Data flows, Workflows and jobs to load data from source to target.
• Enhancing and deploying the SSIS packages from development server to production server.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Created Packages in SSIS with error handling.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables and views to other databases or files with proper mapping.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc
• Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL 2008 to MS SQL 2014 as well as Created interface stored procedures used in SSIS to load/transform data to the database.
• Extensively used T-SQL in constructing User defined Functions, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries, and Data Integrity.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Created complex Stored Procedures, Views, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Worked with Technical Architects and Database analysts for the Design of Summary tables required for efficient Report Design
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Excellent in High Level Design ofETL DTSPackages& SSISPackages for integrating data usingOLE DBconnection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSISsuch asData Conversion,Conditional Split,Merge, Sort, union all etc.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Created and executed the Test plan, Test Cases and Test Steps for all the modules and stored in HP mercury Quality Center(QC).
• Developed Test Plan, Test Cases, and Test Procedures, expected results using QC and testing of end-to-end scenarios.
• Created complex SSIS packages using proper Control and Data flow elements.
• Used System Tables, System Stored Procedure, DBCC commands for Database maintenance.
• Migrated DTS packages from SQL Server 2008 to SQL Server 2012 as SSIS Packages.
• Involved in migration from SQL Server 2008 to SQL Server 2012.

Environment: MS SQL Server 20012 /2008, T-SQL, SSRS, SSIS Packages, SSRS,ETL, ODBC, ASP.Net 3.0, Ado.Net 3.0, C#.Net, Excel, SSDT,SSMS,BIDS,DB2, Access, Windows 2003 Server, IIS 6.0.

Confidential, LA 

BI Developer/QA Analyst

Responsibilities:

• Analyzed system requirement specifications and developed test plans, test cases to cover overall QA System Testing.
• Involved in requirement gathering and providing high-level design solutions in designing database architecture.
• Responsible for Scheduling reports to run daily, weekly and monthly basis using Report Manager.
• Experience in working on different kinds of reports such as Parameterized Reports, Linked Reports and Ad hoc reports.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status.
• Experience in querying data for Creating On-demand Reports using Report Builder in SSRS and send the reports via email
• Experience in working with SSIS Packages for applying various business rules, using various control flow tasks, dataflow components and event handling techniques.
• Developed and Tested complex Stored Procedures and Views to generate various Ad hoc reports, Parameterized Reports and Linked Reports using SSRS.
• Automated all the existing applications and enhanced to run faster and enhancing error handling structure for better support.
• Created matrix report using SSRS.
• Created input parameters in SSRS report.
• Created dynamic parameters in SSRS.
• Brining in data from various sources like Excel, CVS, Teradata and DB2 and vice versa.
• Cleaning and loading the data to SQL server side in a most flexible way and building cubes.
• Created complex based reports.
• Designed and developed RDBMS, created tables and implemented relationships between tables.
• Scheduled and ran extraction and load process and monitored sessions using SSIS.
• Modified the facts, used calculations and query designer in order to modify queries and developed reports using SSRS.
• Tested Complex level type reports in SSRS.
• Experience in working with SSIS Packages for applying various business rules, using various control flow tasks, dataflow components and event handling techniques.
• Created Few Decent and complex level type reports in SSRS.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Performed Functional and regression testing using SOAP UI.
• Developed Test Plan, Test Cases, and Test Procedures, expected results using QC and testing of end-to-end scenarios.
• Identified the high-risk points and the priorities of the application.
• Performed Sanity tests on the application.
• Performed various Boundary Tests as well as data validation to ensure record retrieval and search engine tests. Performed Tests via navigation and workflow of the application.
• Manually checked the important features (Smoke Testing) of the application.
• Responsible for creating and maintaining Traceability Matrix.
• Created and executed Test cases for Positive, Negative Testing.
• Crested scenarios as per the business process.
• Involved in maintenance of the Application and in the bug fixing of the issues.
• Interacted with End Users to obtain specific system requirements.
• Reported defects using QC and interacted with developers to resolve defects/issues.
• Created web service test cases using SOAPUI.
• Created Test cases to Test Suite for automated test cases.
• Created Data sets using SOAPUI.
• Created and used Shared Object Repository for QTP tests.
• Created Standard Check points, Text check points, bitmap checkpoint, Image Checkpoints.
• Created and executed the Test plan, Test Cases and Test Steps for all the modules and stored in HP mercury Quality Center(QC).

Environment: MS-SQL Server 2008 Enterprise Manager, TOAD, XML, MS Excel, Windows Server 2008, QTP, Soap UI, QC, ITE, Splunk, Putty(Unix), QC, XML SPY, Gems Tool, Post Xml, Webtrax, Remedy Tool, MS-SQL Server 2008 R2/2008 Enterprise Manager, MS Business intelligence (BIDS) SSIS, SSRS, MS Visual Studio 2008.