SUMMARY

• Highly motivated SQL Server/BI developer with 7+ years of IT experience in Database and Business Intelligence Technologies with expertise on ETL Process and Reporting using SQL Server 2005/2008 R2/2012, SSIS and SSRS.
• Extensive experience in Oracle 10g/9i and DB2.
• Experience in client requirement Analysis, Physical, Logical design, Development, Resource Planning, Coding, Debugging, Testing, Development, Support and Maintenance of Business application using SQL server 2012/2008 R2/2005,DTS, SSIS, SSAS, SSRS.
• Experience in writing complex SQL queries involving multiple table inner & outer joins.
• Experience in creating Tables, Views, Stored Procedures, Triggers, User defined Function and Other T - SQL statements for various applications.
• In-depth knowledge of T-SQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Experience in Data Migrating /data integration using SSIS
• Experience in data validation and cleaning, data mapping using SSIS/SSRS.
• Expert in Data Extraction, transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Copy (BCP).
• Excellent in creating SSIS Package for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transactions provide by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Union All.
• Expert in creating various type of reports such as Complex drill down & drill through reports, Matrix reports, Sub reports and Charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Expert in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Extensive experience in OLTP/OLAP environment and Experience in OLAP Cubes.
• Experienced in data loads, database integration/conversions, performance tuning, optimization, SQL Replication models (like Snapshot, Merge and Transactional), Locking and Analysis services.
• CreatedDashboards,Score CardsandKPIsfor SharePoint 2010 and 2013.
• Implemented Business Intelligence dashboards andSharepoint Excel Services producing different summary results based on user view.
• Excellent analytical, problem solving skills with excellent inter-personal skills. Demonstrated ability as a team player and a self-starter.

TECHNICAL SKILLS

SharePoint: 2013, 2010, 2007

.Net Technologies: WCF, ASP.NET, ADO.NET, Ajax, InfoPath 2013

Programming Languages: C#, XML

Scripting Languages: JavaScript, JQuery

Databases: SQL Server 2012/2008 R2

Reporting Technologies: SSRS, SSIS

Reporting Tools: Report Builder, BIDS

Source Code Control: CQ/CC, TFS

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

SQL Developer/ BI Developer

Responsibilities:

• Actively participated in interaction with users, Team Lead, DBA's and technical managers to fully understand the requirements of the system.
• Performed Migration of data from SQL Server .
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.
• Implemented Functions, views, triggers, stored procedures and enforced business rules via checks and constraints. Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.
• Worked with Inbuilt Transformations in SSIS ETL/SSIS like Persistent Lookups to enhance performance for lookups and more utilization of I/O resources.
• Efficiently utilized the Merge Join in SSIS and Merge statement to populate the data warehouse from a source database, which provides efficient and granular level of control.
• Used SSRS to create reports, customized Reports, on-demand reports, and involved in analyzing multi-dimensional reports in SSRS.
• Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
• Deployed reports in to Report Manager. Created Ad-Hoc reports using Report Builder.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Created report in SQL Server 2005 and deployed them on local-host for remote access.
• Developed Multi-dimensional Objects Cubes, Dimensions using SSAS.
• Hands on experience in implementing Key Performance Indicator (KPI) Objects in SSAS and Calculated measures and dimension member in MOLAP cube using MDX in SSAS. Wrote MDX queries to access data from OLAP cubes.
• Ran DBCC and fixed data corruption in application databases.
• Used Execution Plan, SQL Profiler, tuning SQL query and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Created PerformancePoint Reports, Power View in Excel in SharePoint 2013.
• Implemented Business Intelligence dashboards and Excel Services producing different summary results based on user view.

Environment: MS SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, Visual Studio 2008, T- SQL, Visual Source Safe 2008 (VSS), XML, ADO.NET, ERWIN 7.1, PL/SQL, MS-Access, SharePoint 2013, MS-Exce

Confidential, Irving, TX

Sr.SQL Developer/BI Developer

Responsibilities:

• Involved in all phases of SDLC from requirements gathering from Business users to perform technical design, development, testing and production support.
• Worked extensively in writing and debugging complex T-SQL stored procedures, views, triggers and user-defined functions in SQL Server 2012/2008.
• Designed the data warehouse and done the mappings from Source to the Target tables.
• Involved in designing, developing and testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Built-in user defined functions to manipulate dates, strings and other data-mining tools.
• Worked extensively on SSIS packages to implement the data load strategy.
• CreatedSSISPackages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task 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.
• Deployed SSIS packages into various Environments (Development, Test and PROD) using Deployment Utility.
• Managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages in ASP.NET.
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Responsible for dimensional modeling and designed the dimension, fact tables and the Data-Mart using Star schema.
• Involved in Dimensional Data Modeling and Cube partitioning in SSAS.
• Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, KPI’s & MDX Queries using SQL Server 2012 Analysis Services.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs
• Wrote T-SQL queries, Stored Procedures, Views and Functions in SQL Server 2012/2008.
• Responsible for Import and export data from various data sources like SQL Server Databases, Flat Files, MS Access, MS Excel and other OLE DB providers achieved through Import and Export Wizard in SSIS.
• Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat Files, CSV files into SQL Server 2012 using SSIS packages.
• Involved in Report Design and Coding for Ad-hoc, canned and Standard Tabular type reports, including Drill down/Drill through functionality and Graphical presentations such as Charts and Dashboard type metrics using SSRS.
• Generated multi parameterized reports in MS SSRS 2012 allowing users the ability to make selections before executing reports thus making them user friendly.
• Worked on several complex drilldown, parameterized reports and on reports that call sub reports using SSRS.
• Scheduled reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs.
• Optimized the queries by creating various clustered, non-clustered indexes and indexed views
• Performance Tuning of Stored Procedures and SQL queries using SQL Profiler and Index Tuning Wizard in SSIS.
• Provided Production support to the user team as well as technical team for system wide tasks including monitoring, alerting and problem resolution
• Involved in testing, bug fixing and documenting the work for the project at each and every phase
• CreatedDashboards,Score CardsandKPIsfor SharePoint 2010 and 2013.
• Created reports from various migrated data sources into dashboards, scorecards and KPI’s for easy reviewing.

Environment: MS SQL Server 2012/2008, DTS, MS Visual Studio 2012/2010/2008 , SQL Server Management Studio, SSIS, SSRS, SSAS, SQL Server Business Intelligence Development Studio(BIDS), T-SQL, PL/SQL, MS-Access, MicrosoftSharePoint 2010, Microsoft SharePoint 2013, SQL Server Query Analyzer, Erwin, Toad, ASP.NET 4.5/4.0/3.5, C#.NET.

Confidential, Rochester, MN

SQL DBA/ Developer

Responsibilities:

• Installed, Configured and Maintained SQL Server 2008 in multiple database environments, namely development, QA and Staging. Applied Service Packs assisted Infrastructure Engineering team to install and configure SQL Server 2008 in a Clustered (Failover) Environment.
• Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008, 2005).
• Upgrades to SQL Server 2008 and guiding the development and application team to fully 2008 enhancements.
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
• Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements that better result in efficient SQL statements processing.
• Used SQL Server Profiler to monitor the server by running traces on various events like User connections, stored procedure execution time etc.
• Database Performance of Index tuning with using Database Engine Tuning Advisor to resolve Performance issues.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Creating and enforcing SQL Server designed standards to allow for efficient and audit compliant SQL environment.
• Upgrades to SQL Server 2008 and guiding the development and application team to fully utilize SQL Server 2008 enhancements.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting Ad hoc reporting.
• Creating and enforcing SQL Server designed standards to allow for efficient and audit compliant SQL environment.
• Extracted data from various sources like SQL Server, Oracle, Teradata, .CSV, Excel &Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Extensive experience in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server with .NET, Import Export data, Bulk insert and BCP.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Creating Excel Services report in SharePoint 2010.
• Worked with Dashboards utilizing the dashboard drill down capabilities.

Environment: SQL Server, DTS, SSIS, SSRS, SSAS (MS-BI ), Query Analyzer, SQL Profiler, Import Export tools, SQL Server Agent, MS Access, T-SQL, Windows 2003 Advanced Server, Microsoft SharePoint 2010, Erwin Data Modeler r7, MS Visio 2003 Enterprise Architect, Microsoft Windows Share Point Services 2.0, Visual Source Safe 2008

Confidential, Hagerstown, MD

SQL DBA/ Developer

Responsibilities:

• InstalledSQLServer2008, 2012 on hundreds of machines/clusters.
• Monitoring and TroubleshootingSQLServerPerformance using Query Tuning,SQLServerProfiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Implemented Always on High availability and Disaster recovery on all migrated instances.
• Working on production Break fix issues which include performance, blocking and space related issues.
• Scheduling Jobs and Alerts using DB Mail.
• Using Foglight to monitor/Test theSQLServerDatabases alerts.
• Implemented table and index partitioning.
• Database Migrations fromSQL &2012.
• Configuring SSRS, Deploying and Migrating SSRS reports.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Maintaining USER PERMISSIONS, LOGINS and SECURITY Issues. Monitoring Event Viewers, SQLError logs and Log Files Viewer for S/W and H/W errors.
• Monitoringserversthru Foglight alerts.
• Installing drivers for DB2, Teradata, Oracle, MySQL for Configuring linkedserversand Data migration as per line of business requirement.
• Database refreshes on Lower environments.Creating and scheduling maintenance routines.
• Configuring CLUSTERING, LOG-SHIPPING, MIRRORING, REPLICATION.
• Resolving all high availability Issues.
• Working with development teams to resolve ETL packages errors and deployments.
• Create and Modify of the database objects according to the requirement.
• Resolving Database Failures, PhysicalServerFailures andSQLServerService Failures.
• Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files) and loadedthedata into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Responsible for coding SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests.
• Responsible for Database and Log Backups & Restoration, Backup Strategies and Scheduling Backups.
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: Windows 2012/2008/2003/2000/ NT4.0, VMware, MSSQL Server2012/2008R 2/ 2008/2005/2000 , SSIS, SSRS, System Monitor / Performance Monitor, Foglight, Visual Studio 2010/2012, SQL Server Profiler, Oracle 10g, Dashboard, SQL Server Management StudioSQL Server Business Intelligence Development Studio (BIDS).

Confidential

Jr Test Analyst

Responsibilities:

• Worked closely with Business Analysts to understand the requirements.
• Analyzed the BRS and SRS documents and designed Test Scenarios and Test Cases for creation and management of Purchase Orders, Invoices, Quotes and Appointments.
• Worked with project team to define & create overall strategy and ensure that it is being achieved
• Communicated the test strategy to the Project Manager and Development Team regularly andAlso effectively updating the management team of any changes.
• Define test process including required test activities and deliverables
• Identified test resources, estimates test effort and defines test schedule and milestones
• Ensured technical resources are organized for effective support of testing
• Conducted walk-through of Test Strategy
• Developed Test Plan, Test Scenario, Test Strategy, and test data according to the specifications.
• Performed Black Box Manual Testing using Agile (Scrum) methodology.
• Performed Functional Testing, Compatibility Testing, System Testing and Regression Testing.
• Developed, Enhanced, and Maintained automated testing scripts with Quick Test Pro (QTP) forData Driven Tests.
• Verified the navigation of links through integrated testing.
• Verified the test results and also used SQL queries to validate data stored in the databases.
• Used JIRA for Test case management, and Defect Management purposes.
• Assisted the team lead with daily QA tasks. Attended project meetings, release meetings, and QA status meetings.
• Ensured Quality through technical competency and provided technical support to the team.

Environment: C#.Net, SQL Server 2005, IIS Web Server, Manual Testing.