PROFESSIONAL SUMMARY:

• Over 7 years of experience in database design, development, administration and maintenance of SQL Server 2014/2012/2008/2008 R2 mid to 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 developing in Microsoft BI stack - SSRS, SSAS, SSIS with MS SQL 2012/2008/2005.
• Proficient 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.
• 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 and s
• 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.

PROFESSIONAL EXPERIENCE:

Confidential, Owning Mills, MD

MS SQL Server/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.
• Creating, Scheduling and monitoring SQL Server Agent jobs
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS/SSIS 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.

Environment: SQL Server 2008/ R2/2012/2016, BIDS, Visual Studio 2010/2013 Data Tools, T-SQL, Autosys, MS Access, MS- Excel, SSIS, SSRS, Windows Server 2008R2

Confidential, Vienna, VA

SQL Server BI/ETL Developer

Responsibilities:

• Interacted with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.
• Developed and maintained 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.
• Migrated and upgraded SQL Server 2008 to SQL Server 2012
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Built Adhoc reports using report builder.
• 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.
• Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

Environment: MS SQL Server 2008 R2/2012, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Data Tools, MS Office Suit(Access, Excel, Word), Visio 2016, Windows Server 2008/2012, Windows XP/7/10

Confidential, Camp Hill, PA

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\\\\ \ l 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, SSIS, SSRS, SSAS, T-SQL, SQL Server Management Studio, Oracle 9i/8i, Service Center, MS office Suit (MS Access, MS Excel, MS Word, PowerPoint), Crystal Reports, Business Objects4.0, Visio, ERWIN, Windows Server 2008/2012, Windows 7/10

Confidential

Architect and Data Analyst/DBA

Responsibilities:

• Converted unorganized business on customers and building project from Excel spreadsheets into a SQL server relational database.
• Involved in the design of database for an in-house CRM and Construction project Management application.
• Designed multiple SSRS statistical and summary reports on Customer and project status.
• Preparation of Architectural design drawings using various design software, and coordination of electrical, sanitary and structural drawings, preparation of bill of quantities.

Environment: SQL Server 2005, SSIS 2005, SSRS 2005, T-SQL, SQL Server Management Studio, Visio for Enterprise Architects, MS Office suit, AutoCAD, ArchiCAD, Artlantis, Sketchup, Photoshop, Adobe Illustrator, Windows Server 2008, Windows XP/7