PROFESSIONAL SUMMARY:

• Experience in all the phases of Software Development Life Cycle (SDLC).
• Experience in using Agile scrum project management methodology.
• Experience using Project management tools such as Trello.
• Experience in Data warehouse such as dimensional modeling, Star/Snowflake schemas, Data marts, fact and dimension tables identification and OLAP Cubes.
• Hands of experience on creating ETL processes to populate Type 1, Type 2 and Hybrid slowly changing dimensions (SCD).
• Experience on providing Role based access to end users to SSAS data cubes through Excel Services and Report builder.
• Expert in creating and using Stored Procedures, Views, User Defined Functions, cursors, derived tables, common table expressions (CTEs) to facilitate efficient data manipulation and data consistency.
• Expert in creating Sub - Queries and Joins for complex queries involving multiple tables.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Excellent experience in writing and debugging complex ad hoc SQL Queries, dynamic Stored Procedures and triggers.
• Review SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance.
• Hands on experience on developing Error handling mechanisms for ETL processes.
• Skilled on creating Dynamic SSIS packages using system variable, user variables, parameters, xml configuration and environmental variables.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Excellent on developing interactive SSRS report using parameters, interactive sorting, visibility, row groups and column groups.
• Created reports such as sub reports, matrix reports, charts, drilldown, drill-thru, linked, sub-report, and dashboards using SSRS.
• Experience in designing and managing shared and embedded datasets for dynamic reports.
• Excellent database documentation skills using system stored procedure, Help Studio, MS Visio, Ms Word, MS Excel, Erwin and ER Studio.
• Excellent experience using MS Excel (pivot table) and MS access to analyze and process data's.

SKILLS:

• Attention to detail and excellent analytical and problem-solving skills.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL PROFICIENCY:

Operating Systems: Microsoft windows all versions, Linux, Unix, Solaris 10

Databases: MS Access2013/2007, MS SQL Server 2012/2008/2005 , Oracle 11g/10g, DB2

Languages: T-SQL, CSS, HTML, XML, PL/SQL, ASP.NET, C#, .NET Framework.

Warehouse Tools: SSIS, SSRS, SSAS, BIDS, DTS, Enterprise Manager, SQL Profiler. Tableau, Power BI, Alteryx

Data modeling Tools: Erwin 7.2/4.5/4.0, MS Visio 2007/2003, Rational Rose, ER-Studio.

IDE Tools: Visual Studio 2013/2012/2010 , TFS 2010

WORK EXPERIENCE:

Confidential, Washington, DC

SQL Database\ ETL Developer

Responsibilities:

• Involving in complete Software Development Life Cycle (SDLC) process by analysing business requirements and understanding and translating the functional work flow for implementation.
• Analyzing and performing data mapping which involves identify source data field, identify target entities and their lookup table ID’s, and translation rules.
• Coordinating with front-end for implementing logic in stored procedures, trigger, views and functions.
• Experiencing in writing and debugging complex SQL Queries, dynamic Stored Procedures, Triggers, Views, CTE's, Derived tables, Sub-queries, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic.
• Involving in ETL architecture enhancements to increase the performance using query manager and optimizer.
• Implementing Slowly Changing Dimension (SCD) type 2 to maintain historical data in data warehouse using SSIS.
• Involving in designing parameterized reports for generating Ad-Hoc reports as per the client requirements.
• Reviewing SQL code written by application developers to ensure compliance to coding standards and best practices as well as maximum performance and Involving in thorough code review of current and past development efforts.
• Advising optimization of queries by looking at the Execution Plan for better tuning of the database.
• Creating clustered and non-clustered indexes and using DMV and DMF for performance enhancement of long running queries.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, Excel files and loading into SQL server.
• Extensively using Joins and sub-queries for complex queries involving multiple tables from different databases.
• Implementing database administration (database backups, recovery models, database security and database storage like pages, extents, etc.).
• Implementing SQL Server High Availability and Disaster Recovery including SQL Server and Windows clustering, Database Mirroring and Log Shipping and Transactional Replication.
• Conducting root-cause analysis for various development related problems (bugs in code, performance, and locking/blocking).
• Conducting research on emerging database and data warehouse technologies.
• Involving in Normalization and De-Normalization of existing tables for faster query retrieval and Reverse Engineering the database using different tools like ERWIN and ER Studio for both Physical and Logical Data Modelling.
• Comparing and Synchronizing different versions of the database using user defined stored procedure and different add in tools like Red Gate and KDiff3.
• Coordinating with network administrators, systems analysts, and software engineers to assist in resolving problems and provide issue escalation in a timely fashion.
• Documenting the database using Extended Property Stored Procedures, Document X, MS Visio, MS Excel and MS Word.
• Data extraction and import, assist in data reporting from ACC’s databases
• Fine-tuned SQL queries to improve query performance and to reduce runtime.

Environment: MS Access2013/2007, MS SQL Server 2012/2008/2005 , Oracle 11g/10g, DB2

Confidential, Bethesda, MD

SQL DBA\ Developer

Responsibilities:

• Implemented SQL server high availability solutions such as Log shipping, mirroring, classic clustering and carefully scheduled maintenance tasks to minimize downtime between data center.
• Checked the SQL Server is online and that still have connectivity with the frontend applications and functionality. I have also worked with multiple application owners in different database issues.
• Migrated databases from SQL Server and oracle server using linked server
• Creating Jobs, Alerts, SQL Mail Agent, and create SSIS Packages.
• Extensively write T-SQL codes to create tables, views, triggers, stored procedures and user defined functions.
• Monitor databases for errors and perform problem determination when necessary.
• Tune database objects, Setup traces & Profiler to troubleshoot performance issues.
• Troubleshot and Solved Concurrency problems of blocks, locks, deadlocks, by viewing and tracking them using Activity Monitor and Management Studio summery page and Profiler.
• Create SQL Server database and database objects across production, development and test servers.
• Configuring database mirroring and replication.
• Setting up Log shipping & Replication on Production environment.
• Oversee backup, clustering, mirroring, replication and failover.
• Extensively write T-SQL codes to create tables, views, triggers, stored procedures and user defined functions .
• Performed weekly database maintenance on Production Database Server as Command Center night shift DBA.
• Create clustered and non-clustered indexes for the quick retrieval of the data from the database and Triggers to enforce data and referential integrity
• Developed various T-SQL stored procedures & functions for data validation process.
• Run DBCC statements to check physical and logical consistency of the database and Rebuild indexes.

Environment: SQL Server 2014, 2008\R2, 2005, 2000;

Confidential, Columbia, MD

SQL Server Developer

Responsibilities:

• Wrote Ad-hoc queries for Business Analysts to extract required daily data.
• Fine-tuned SQL queries to improve query performance and to reduce runtime.
• Debugged complex stored procedures, functions and triggers.
• Extensively used Joins and sub-queries for complex queries involving multiple tables from different databases.
• Createdand maintaineddatabase and database objects like Tables, Views, Stored Procedures, Indexes, Triggers, User Defined data types and Functions.
• Conducted performance enhancement and tuning of database objects and queries.
• Performed database administration like Database Backup, Restore and Disaster recovery procedures.
• Performed quality assurance and testing of SQL server environment.
• Documented all requirements and scripts for future references.

Environment: Microsoft windows all versions, Linux, Unix, Solaris 10