PROFESSIONAL SUMMARY:

• Over 8+ years of in - depth experience in database design, development, administration and maintenance of SQL Server 2014/2012/2008/2008 R2 large scale databases.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, and SSIS with MS SQL 2012/2008/2005.
• Proficiency in creating different types of Reports such as Cross-Tab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.
• Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.
• Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server.
• Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Data conversion, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data).
• Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.
• Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000/2008/2012 to SQL Server 2005/2008/2012/2014.
• Highly experienced in database server performance tuning and optimization of Complex SQL queries.
• Launching the report builder for adhoc reports.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.
• Performed DBA tasks using Enterprise Manager and Query Analyzer.
• Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.
• Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.
• Good operating knowledge in third party tools such as NetBackup, Lite Speed Pervasive ETL, SQL Assistant ERWIN, Red-Gate and Spotlight
• Worked closely with development and Technical Support team to resolve quality issues.
• An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project
• 24x7 Production Database on Call Support.

TECHNICAL SKILLS:

RDMS: SQL Server 2005/ 2008/2008 R2/ 2012/2014, DB2, Oracle 9i/8i

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS),Informatics cloud, Informatica Power Center 9.6, Workato, Mulesoft Any Point Platform

Reporting Tools: SQL Server Reporting Services, MS Excel, Crystal Reports, Power BI, Power BI, Tableau Desktop10.0, Tableau Server

Programming Languages: T-SQL, PL-SQL, C#

Web Technologies: HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems: Windows Server 2012/2008, Windows XP, Windows Vista

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, Adobe Photoshop, Abode Flash, Microsoft .NET, Team Foundation Server, Visual Studio 2008,Salesforce

Methodologies: AGILE, SCRUM, Waterfall, Extreme Programming, LEAN Manufacturing, Software Development Life-Cycle

PROFESSIONAL EXPERIENCE:

Confidential, Owning Mills, MD

MS SQL Server/ETL/SSIS Developer

Responsibilities:

• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.
• Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.
• 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 the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Made Master Child package using variables and Execute package task in SSIS.
• Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements
• Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.
• Deployed, Tested and Scheduled SSIS packages.
• Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012.
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations
• Integrated SSIS packages with the windows batch to trigger the package.
• Migrated projects from CVS to TFS (Team Foundation Server)
• Designed and deployed Azure cloud solutions that meet product needs for scalability, reliability, and performance.
• Managed Salesforce to Active Directory integration using Workato and Mulesoft Anypoint Platform
• Expert in Implement deploy and configure Azure websites, configure diagnostics, monitoring and analytics on Azure Platform along with scale and resilience for Azure Web sites.

Environment: SQL Server 2005/2008/ R2/2012/2014, BIDS, Visual Studio 20102013,T-SQL,Autosys, MS Access, MS- Excel, SSIS,SSRS,SSAS, Windows Server 2008R2, TFS, Microsoft Azure, Workato, Mulesoft Anypoint Platform

Confidential, Glen Allen, VA

SQL Server BI/ETL Developer

Responsibilities:

• Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs, C# and VB code as required
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Experienced in slowly changing dimension in SSIS packages.
• Performed incremental data load packages in SSIS.
• Developed, monitored and deployed SSIS packages.
• 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 etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Identified and Defined Fact relationships in SSAS.
• Responsible for debugging applications using the tools provided by the Visual Studio 2008.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.
• Provided technical assistance for all phases and support service of .NET projects.
• Published reports to Azure based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps)
• Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau
• Developed Informatica Mappings/Workflows to refresh data from SQL Server Database into Teradata.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.

Environment: MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP,.Net, Visual Studio 2008, Power BI, Tableau Desktop10.0, Tableau Server, Informatica Power Center 9.6

Confidential, Newark, DE

Senior SQL Server DWH/BI Developer/Data analyst

Responsibilities:

• Involved in Agile methodology by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems, completed work through Sprints.
• Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.
• Interacted with Business team to collect data for the conceptual design of the system.
• Coordinated with business users to understand business needs and expectations.
• Involved in requirement gathering, feasibility studies and organizing the software requirements.
• Involved in analysis and review of software and business requirement documents.
• Involved in defining the source to target data mappings, business rules and data definitions that are used as source by ETL developers.
• Created data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and validating them with data present in Source systems.
• Revisiting created Data Mapping documents in case of any Mappings or Transformation logic changes.
• Helped Data Architect by providing the artifacts that are needed to consider while designing the EDW.
• Conducted sessions and worked alongside with the Business analysts to create technical specifications and mappings for Business Data Glossary and reports.
• Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.
• Created tables using T-SQL queries to store the data and also creating database objects like functions, stored procedure, Clustered and Non-clustered Indexes using MS SQL Server.
• Experience in Data Analysis and Data Profiling using SQL and Excel on large volume of data sets like Teradata, Oracle, Flat files, SQL Server.
• Experience in creating data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and comparing them with source Data Profiling Results.

Environment: SQL Server 2008, T-SQL, SQL Server Management Studio, Visio, Excel Reports, Outlook, Service Center

Confidential, Camp Hill, PA

MS SQL Server Developer

Responsibilities:

• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (Cluster Index, Non-Cluster index) tables.
• Experienced in ETL from various heterogeneous data sources like Access, Excel, and CSV, flat files using connectors, tasks and transformations provided by SSIS.
• Proficient in creating dynamic SSIS packages for Incremental Loads and used change data capture (CDC) control task that makes efficient data loading.
• Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS.
• Experienced in designing Star, Snow flake Schemas and OLAP cubes.
• Experienced in migrating data from one SQL Server version to another.

Environment: MS SQL Server 2000, T-SQL, DTS, Microsoft Visual Source Safe 6.0, Visual Basic 6.0, Crystal Reports 8.0 and windows 2000.