SUMMARY

• Over 8.5 years of strong experience in teh IT industry as a MS SQL Server 2014/2012/2008R2/2008/2005 Developer/BI Development, Client Analysis, Database Design, and Presentation using SQL Server 2014/2012/2008R2/2008/2005.
• Good noledge of Normalization/De - normalization, data design methodology and building Referential Integrity.
• Expert noledge of all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Experienced in T-SQL (DDL,DML), documenting, coding, programming, modifying and Implementing Business Intelligence
• Experienced in designing high level ETL architecture, creating, configuring and fine tuning workflows designed in DTS for data transfer from teh OLTP to OLAP with teh halp of SSIS.
• Experience in SQL Server Analysis Services (SSAS) OLAP Cubes, and Mining, Implemented Snow Flakes Schema and Star Schema.
• Experience in Importing/Exporting Data from various Heterogeneous source like MS Access, Excel, Oracle, DB2, and Flat file using SSIS.
• Highly proficient in teh use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational DB models and Data integrity, and SQL joins.
• Creation and maintenance of Databases, creating Roles and managing user permissions, resolving deadlocks.
• Experienced in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views, and Transformation services.
• Experienced in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools like SSRS, SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, Defining Data Source and subtotals for teh reports using SSRS 2014/2012/2008/2008R2/2005.
• Expert in developing Drill through/Drill down reports, Cross-Tab, Cascading parameterized reports using MS SQL Server Reporting Services (SSRS) and deploying onto Dashboards, SharePoint server, web applications and web servers.
• Worked with MDX to query cube's data.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008/2012/2014.
• Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
• Expertise in creating Cell Level Security in cubes using SSAS.
• Specialized in Data Loss prevention and mediation of SQL Injections.
• General noledge of security technical implementation guidelines regarding security of databases.
• Involved in all phases of software development life cycle: design, implementation and testing.
• Hands on experience in production/staging/test/development database administrative, Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
• In-depth noledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports 8.5/9.0/10 to XI.
• Strong understanding of project life cycle and SDLC methodologies including RUP, RAD, Waterfall and Agile
• Tuning SQL query for better performance using SQL Profiler and Normalization and De-Normalization of existing tables for faster query retrieval.

TECHNICAL SKILLS

Business Intelligence Tools: Microsoft BI (SSAS, SSRS), SSAS Tabular, Self-service BI (Power Pivot, Power View, Power Map, Power Query), Cognos 10, 8 (Report Studio, Query Studio, Analysis Studio, Metric Studio, Cognos Connection, Transformer),BIDS, Tableau

ETL Tools: SSIS, Informatica Power Center 7.x, Ascential Data Stage 7.5, SAP - Business Warehouse, Power Query

Database Systems: MS-SQL Server 2000/2005/2008/2008 R2/2012, 2014, Oracle 10g/11g, DB2,MS Access

Programming Languages: T-SQL, PL/SQL, .Net, MDX, DAX, HTML,CSS,XML

Operating Systems: Windows NT/XP/2003/2008,2010, 2012, MS DOS, Linux, IIS 5, 6

Project Management/ Database Design: Microsoft Project/Office 2003, 2007, 2010, 2013, Microsoft Visio.

PROFESSIONAL EXPERIENCE

Confidential, Herndon, VA

Sr. SQL Server/ BI Developer

Responsibilities:

• Created SQL server database objects like user defined tables with primary keys and foreign keys to add data codes for look ups to generate integration with other tables in teh database all case related codes and made available to teh entire Developer and DBA Teams.
• Created different Business logic user defined Stored Procedures includes input parameterized, user defined functionalized procedures, Views, providing login id security procedures, navigation levels security procedures, error handling- try/catch block SQL server stored procedures.
• Created T-SQL stored procedures testing teh data dat including different SQL server actual and estimated execution plans from SELECT statement with complex joins against huge tables.
• Monitor teh events and trace teh result, load, execution of stored Procedure of user login and logout traces with SQL Server Profiler tool.
• Crated different SSIS packages for extracting data from flat files, xml, and csv/excel files and transform and load them into teh database tables.
• Migrating and restored teh SSIS integration services packages with bulk insert task tool from 2012 to SQL Server 2014 and made them running and created a SQL server Agent job and scheduled a one time and nightly bases data load jobs.
• Expert in automating process bycreating jobs and error reportingusing Alerts,SQL Mail Agent, FTP and SMTP.
• FTP task, Master-Child packages, Data conversion from 2012 to 2014 by using SSIS packages and scheduled daily bases SQL Server Agent jobs with on success and on failure email alerts job creation.
• Created teh SSRS Reports in 2012 based on teh Business Court Users discussions and created teh request document Business rules, case plans and create teh tasks in teh TFS Sprint and trace/tie them with BI logic and build/code teh Complex SQL queries, SQL procedures and Datasets.
• Designed teh different types of reports like tabular, matrix, multi-parameterized, cascading, drilldown, drill through, Sub reports, and linked reports.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.
• Migrated reports from SSRS 2012 to 2014 and ensure them running by adding related data sources and datasets.
• Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on teh OLAP reporting needs.
• Performed performance tuning of teh dashboard in Tableau desktop.
• Maintain reporting server folder structure by using Report Sync tool as from 2012 to 2014 environment and restored report related data sources and make connections with datasets in teh SSRS Reporting Server and make them available to teh entire users, reporting team with Team Foundation Server.
• Deploy teh reports to teh different reporting servers and maintain and make them similar by checking, branching and merging teh reports from development to UAT and tan Production server through TFS services.

Environment: Microsoft SQL Server 2012/2014, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Tableau MS Excel, Team Foundation Server, Business Intelligence Sprint, BI Scrum, Team Explorer, Cognos.

Confidential, Richmond, VA

SQL Server/ BI ETL Developer

Responsibilities:

• Designed Database to integrate centralized SQL Server to manage all teh clients’ Personal information and architected in simplified manner and made available to teh entire Teams like QA Team, Web Server Team.
• Developed and executed SSIS packages to populate data from teh various data sources like Oracle, created packages for different data loading operations for many applications.
• Created complex Stored Procedures, Functions, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts using SSIS, guided team for teh transformations.
• Developed Master Child package using variables and Execute Package Task in SSIS, executing with bat files and deployed in different servers.
• Created different user-defined functions using T-SQL Query for teh creating Datasets and Data Adapters to use them in SSRS 2012/2008R2 and SSIS 2012/2008R2.
• Organized Error and Event Handling by giving Precedence Constraints, Break Points, Check Points, Logging to send teh result files to teh clients and vendors.
• Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc., to generate underlying data for teh reports and to export cleaned data from Excel, Text file, and MS Access to different data Marts.
• Data ETL making changes to existing ETLsand building some new ETL processes.
• Created different forms of Tablix, dropdown, parameterized reports and integrated with front ends like C#.net and SharePoint.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Configured Connection Manager Files and CMD files for SSIS packages to dynamically execute on QA Server and Production server
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services (SSRS).
• Successfully tested all task in staging and stored all versions using team foundation server (TFS).
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.

Environment: Microsoft SQL Server 2012/2008R2, SQL Server Integration Services (SSIS) 2012/2008R2, SQL Server Reporting Services (SSRS), MS Excel, Team Foundation Server, Team Explorer, Scheduler, T-SQL, MS SharePoint.

Confidential, FL

SQL Server/BI Developer (SSIS, SSRS)

Responsibilities:

• Involved in upgrading teh instance of development environment of SQL Server 2008R2 service to SQL Server 2012 with latest service pack.
• Wrote several scripts such as finding long running queries, blocking sessions, archiving data from production server to archive server and populating reporting.
• Created indexes to tuning stored procedures and extensively used Execution plan, Query Analyzer, SQL Profiler.
• Implemented ASP.NET Validation controls and Client-side Validation Scripts to validate teh Regional Division Manager’s Input Data in replication server.
• Implemented Business logic for Service Manual and Employee Remittance Review module using C#.NET.
• Used ADO.NET extensively, for Database Interactions to get Employee Review, Remittance and Service Manual Data from OLAP.
• Created named query in SSAS Data Source View to get appropriate hierarchical summarize data for two dimensions.
• Wrote stored procedures in SQL Server 2008R2, 2012 to access Employee’s and Manager’s Data. Setting up SQL Database Mirroring on teh development server.
• Maintained reliability and availability of existing MS SQL environments.
• Suggested Cost saving Techniques. Designing/ Implementing Backup policies for databases.
• Managed Login and User: adding logins, roles, groups to teh Window NT and MS SQL Server and maintaining proper security procedures.
• Responsible for Full Report Cycle including Authoring, Managing, Security and generation of reports.
• Created many Cascaded parameters in teh reports using MDX and T-SQL
• Involved in Designing and deploying cubes using Snowflake and Star Schema Designs for teh operational data.
• Created reports with other reporting tools like Tableau, Qlikview and dashboard.
• Involved in designing teh user interfaces and writing and implementing client validation scripts.
• Developed Query for generating drill down reports in SSRS 2008. Prepared AD HOC reports through report builders.

Environment: Microsoft SQL Server 2012\2008R2 Enterprise Edition, T-SQL, SQL Server Reporting Services, SQL Server Integration Services, Visual Source Safe.

Confidential, Boston, MA

MS SQL Server DBA\ BI ETL Developer (SSRS, SSIS)

Responsibilities:

• Developed and executed SSIS packages to populate data from teh various clients like PHP, Molina, and Amerigroup created packages for different data loading operations for many Customer Relationship Management (CRM) applications.
• Created complex Stored Procedures, Functions, SSIS packages, tables, and views and other SQL joins and statements for optimizing.
• Created and supported different types of packages using variables, master child packages and Execute Package Task in SSIS, executing with bat files and moving along with different servers like QA Testing, Development servers and productions servers.
• Discussed with teh clients for teh new requirement for teh ganges5.0 version in order to make teh ETL process optimization.
• Worked directly with teh client to resolve teh issues regarding teh asp.net and SQL server with ETL transformation and teh decision for teh packages changes will be discussed with teh management and start working on teh ETL packages.
• Designed high level ETL architecture for overall data transfer from teh source server to teh Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
• Using SQL server reporting services (SSRS) delivering enterprise, Web-enabled reporting to create reports dat draw content from a variety of data sources.
• Extensively used SSIS Import/Export Wizard for performing teh ETL operations and various containers to do teh loop generating.
• Involved with teh testing teams for teh unit testing and integration testing, for teh process to release teh new versions to teh client.
• Built advanced reports using query parameters, report parameters, filters, interactive sorts to compare teh rates among teh 4 major regions, to generate teh alerts in active reports.
• Developed Templates for teh reports for teh managerial cadet so dat they need to drag and drop teh fields which they need exclusively for Non-technical person in SQL Server Reporting Services (SSRS).

Environment: Microsoft SQL Server 2008R2/2008, SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS), MS Excel, Team Foundation Server, VSS 2005, Team Explorer, ASP.net.

Confidential

MS SQL Server Developer/SSIS/SSRS/DBA

Responsibilities:

• Designed Data warehouse to integrate SQL Server to manage all teh clients’ health information and architected in simplified manner and used by DQ Teams like Web extracts and Reports, Extracts and Interface and Web Portal.
• Developed SQL scripts to Insert, Update and Delete data in MSSQL database tables in OLTP environment.
• Created complex Stored Procedures, Functions, triggers, cursors, tables, and views and other SQL joins and statements for optimizing and SSIS packages.
• Successfully managed Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using DTS, BCP in staging database from MS Access, Sybase, excel.
• Creating different types of (SSIS) SQL Server Integration Services Packages optimize and tune data flow task in SSIS using Profile and SSIS performance. Monthly load processing/automation using SSIS.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified teh package according to teh advanced feature of SQL Server Integration Services.
• Deploying and scheduling SSIS Packages using SQL server Agent, windows scheduler, batch files, .dtsx utility to generate data as per current status.
• Troubleshooting Database performance issues and implementing necessary database changes.
• Created monitoring scripts to error alert for database issues.
• Fine-tuned Stored Procedures using Execution Plan for better performance.
• Implement and maintain database audit and server security.
• Writing queries to generate reports for analysis of data using (SSRS) SQL Server Reporting Services, Report Builder.
• Created monitoring scripts to error alert for database issues.
• Fine-tuned Stored Procedures using Execution Plan for better performance.
• Migrated Database from SQL Server 2005 to 2008.
• Designed and created SSRS Report templates, bar graphs and pie charts based on teh financial data.
• Deploying and scheduling Reports using SSRS to generate all timely like hourly, weekly, monthly and yearly Reports including previously run status.

Environment: Microsoft SQL Server 2008/2000, SQL Server Integration Services (SSIS) 2005/2008, SQL Server Reporting Services (SSRS), MS Excel, Team Foundation Server, VSS 2005, Team Explorer, TWS Scheduler.