PROFESSIONAL SUMMARY:

• 8 years of professional experience in MS SQL Server Database Design, Development and Analysis related to Finance, Retail, Telecom and Health Care domains.
• Experience in data analysis, design and development of databases for business applications in a client/server and Data warehouse environments in SQL 2014/2

  Expertise in scripting T - SQL (DDL, DML) queries, complex Stored Procedures, User-defined Functions, designing and implementing Database Triggers, designing and implementing Views, designing and implementing Indexes.

• Well versed in normalization/de-normalization techniques for optimum performance in relational and dimensional database environments and building Referential Integrity Constraints.
• Efficient, in creating Sub-Queries and Joins for complex queries involving multiple tables, using Exception Handlers
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Very strong in creating and maintaining database objects like Indexes, Views, Stored Procedure, User Defined Functions, Triggers in SQL Server 2008.
• Experience in Change Data Capture (CDC), Change Tracking (CT) in SQL server 2008.
• Efficient in building recursive queries using CTEs (Common Table Expressions)
• Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
• Worked with Exception handling with @@error and with Try/catch
• Efficient in Implementing Transactions in Stored Procedures
• Created temporary tables and table variables while creating complex queries in SQL Server
• Created Partition Tables based upon Partition Functions and Partition Schemas
• Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
• Worked extensively with Dynamic Management views and Functions (DMV) to resolve performance based issues on the server.
• Thorough knowledge of addressing Performance Issues and Involved in Index tuning, Data profiling and other database related activities.
• Resolved issues with Indexes, Blocking and locking issues to remove the performance bottlenecks and used Profiler to solve Dead Locks.
• Good Knowledge of Bookmark Lookup Operator, Clustered Index seek, RID Lookup
• Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases
• Very Strong in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Expert with SQL Server 2014/2012/2008 server side development including SSIS
• Expertise in Merging data from various Heterogeneous Data sources (Oracle, SQL Server, Access, Excel, Flat Files and XML), Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS.
• Developed SSIS packages for processing fact and dimension tables with complex transforms and Slowly Changing Dimensions type 1 and type 2 changes.
• VB.Net and other .NET languages C# used for Script task. Script task is primarily to control the flow of SSIS package.
• Designed high level ETL architecture for data transfer from the OLTP to OLAP Using SSIS.
• Experience in developing, configuring and deploying SSIS packages and providing security.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Expertise in Debugging, Error logging, Error Handling and Production support for SSIS.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Proficient in usage of SSIS Control Flow items(For Each Loop, Execute package/SQL tasks, Script task, send mail task)and SSIS Data Flow items(Conditional Split, Data Conversion, Fuzzy lookup, Fuzzy Grouping, Pivot).
• Experienced in Maintenance and Admission of SSIS by creating Job Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.
• Experience in Different types of Connection Managers in SSIS OLEDB, ADO.NET, Flat File, Multi Flat File. ODBC
• Generated Parameterized/dropdown SSRS Reports
• Hands on experience in designing complex reports using SQL Server Reporting Services (SSRS) and Crystal Reports.
• Expertise in creating Report Models for building Ad hoc reports using SSRS.
• Proficiency in creating different types of reports such as Crosstabs, Conditional, Pie Chart Reports, Drill-Down, Drill-Through, Top N, Summary and Sub reports and formatting them.
• Expert in handling parameterized reports and Cascade Parameterized Reports in SSRS 2008.
• Worked on building a Data Warehouse and implementing an ETL solution for loading Data warehouse.
• Proficient in building Star schema and Snow Flake schema depending on requirements.
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions, mining structures, roles and creating hierarchies with SSAS.
• Monitored project status to meet milestones and resolved issues that might impact on quality or the ability to deliver to timescales or estimates. Worked in AGILE methodology using SQL Server.
• Implemented cell level security in cubes using MDX expressions to restrict users of one region viewing data of another region using SSAS.

TECHNICAL SKILLS:

Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Server Profiler, Data Base Engine Tuning Advisor, Data Transformation Services, Power BI, ASP.NET,Visual Studio, Red gate, Source Control, Team Foundation Server.

Data warehousing Tools

: SQL Server 2014/2 /2000, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), SSMS, Micro Strategy, DTS Packages, MDX Queries, ETL, OLAP, OLTP, Tableau, Visual Studio.

Data Modeling: Visio 2007 and Erwin 4.1

Programming Language: T-SQL, PL/SQL, C, C++,VBScript, Power Shell C#, HTML, Java Script, XML,.NET 3.5,Perl,Ruby,Python, MVC, JQuery, Visual FoxPro 5.0.

Operating Systems: Windows Vista/XP/ 2008/2007/2003

Windows Server 2000/2003/2008/2012: Linux

Relational Databases: SQL Server 2014/2012/2008 R2/2008/2005, MS Access,DB2,Oracle 10g,11g

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. SSIS/SSRS Developer

Responsibilities:

• Collected business requirements from users and translated them as technical specs and design docs for development.
• Create data verification methods and comply with standard system procedures.
• Created Full backup’s, Differential backup’s, Transactional Log back up’s
• Have done Restores of databases using Full backups and Differential backups.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Performance tuning, query optimization and execution plan of queries for better performance.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints on various database objects to obtain the required results.
• Migrated Data from Post Gre SQL and Oracle Databases to MS SQL 2008 and Bulk data migration using SSIS from flat files.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created SSIS packages and scheduled them as jobs to run automatically to Process the cube, load data etc.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Experience in Different types of Connection Managers in SSIS, ADO.NET, Flat File, Multi Flat File. ODBC
• Developed Unit Tests for the .NET Framework with the Microsoft Unit Test Framework for Managed Code
• Created Data Driven Unit Test
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink)
• Created reports by using SSRS 2008 and 2012.

Environment: MSSQL Server 2012/2008, Visual Studio 2010. Integration Services (SSIS 2005/2008/2012 ),SQL Profiler, Reporting Services(2005,2008,2012) Business Intelligence Development Studio (BIDS), Crystal Reports,.NET 3.5, VB,C#,MVC, JQuery, Oracle, Pl/Sql Office 2007, MS Access, ETL, MS Excel, TFS(Team Foundation Server 2010).

Confidential, Irving, TX

Sr. SQL/SSIS/SSRS Developer

Responsibilities:

• Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules.
• Running DBCC consistency checks, and fixing data corruption in databases.
• Created packages and scheduled them in SQL Agent jobs to get data from OLTP.
• Created SSIS package to get data from different sources, consolidate and merge into one.
• Well versed in creating Dynamic SSIS packages, using containers & variables, configuring and scheduling the packages.
• Experience in Precedence Constraints, Break Points, Check Points, Logging.
• Implemented error handling and roll back process in ETL load.
• Performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Experience in N Unit and Cs unit Testing Framework
• Created custom reports which had cascaded parameters using SSRS/SQL Server BI studio.
• Created Ad hoc reports using SSRS.
• Created reports that call Sub reports in SSRS.
• Created datasets for reports using T-SQL and stored procedures

Environment: MSSQL Server 2012/2008, Visual Studio 2010. Integration Services (SSIS 2005/2008/2012 ) Business Intelligence Development Studio (BIDS), Crystal Reports,.NET 3.5, VB,C#, Python,Pl/sql, MVC, Unix shell Scripting, Office 2007, MS Access, ETL, MS Excel, TFS(Team Foundation Server 2010).

Confidential, Grapevine, T X

SSIS/SSRS/SSAS Developer

Responsibilities:

• Created Custom Measure groups (Calculated Members) in cube to implement business logic
• Created Scopes in the cube to provide flexibility for users to see revenue in their local currencies.
• Created dimensions in the performance point server. Imported data into Performance point server from SQL database through csv files
• Consolidated data from OLTP databases in to OLAP using SSIS as ETL.
• Created parameterized stored procedures to implement business logic.
• Rebuilding Indexes and Tables as part of performance tuning exercise.
• Monitor SQL Error Logs /Schedule Tasks/database activity/eliminate Blocking & deadlocks /user counts and connections/locks etc.

Environment: Microsoft SQL Server 2005, SSIS 2005, SSRS 2005, SSAS 2005, Visual Studio 2005/2008, Microsoft Office Performance Point Server, Planning Business Modeler, Microsoft Office share point 2007, Targit,MVC,Oracle windows 2003/XP/vista,, .NET Framework, Python, C#, VB, ASP.NET, ADO.NET.

Confidential

SQL Server Developer/DBA

Responsibilities:

• Install, Update, Configure and Maintain the MS SQL Server.
• Created new database objects like StoredProcedures, Functions, Packages, Triggers, IndexesandViewsusingT-SQLinSQL Server 2000
• Optimized the performance of queries by modifying the existing index system and rebuilding indexes again with respect to the I/O
• Experienced on Database creation, database tuning, and performance planning, backup planning and database administration.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Creation and maintenance of Users security permissions and Migrating the entire database objects from one server to another server and database to another database.