PROFESSIONAL SUMMARY:

• 7+ years of strong MS SQL Server, MSBI Development experience with various verticals such as Health Care, Finance, Retail and Technology with expertise in MS SQL Server 2016/ 2014/2012/2008/2005 suite of products like SSIS, SSRS and SSAS.
• Expert in planning, modeling, designing, developing, implementing, administering, and maintaining Microsoft SQL Server 2016/ 2014/2012/2008/2005, Visual Studio 2015/2013/2010 Microsoft Access, SQL Databases.
• Strong knowledge in the use of T - SQL and PL/SQL for developing complex Stored Procedures, indexes, Tables, Views, User Defined Functions, Relational Database models, Data integrity and SQL joins.
• Experience in Microsoft SharePoint, MS Project, MS Visio, Erwin 9.2, Data Modeling , Visual Basic Analysis (VBA), MS Office , ALM for QA testing and Software Development Life Cycle ( SDLC ).
• Responsible for data quality testing and leading a team that performs data reconciliation to identify data anomalies.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflakes Modeling, fact and dimension tables, Pivot Tables, modeling of data at all the three levels: view, logical & physical.
• Extracted data using SSIS from OLTP(Tabular) to OLAP. Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view.
• Expertise in creating databases, users, tables, triggers, views, stored procedures, functions, Packages, joins and indexes in database.
• Expert in designing complex reports writing like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and adhoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Expertise in developing and extending MS SQL Server Analysis Services (SSAS) cubes, data mining models, deploying and processing SSAS objects.
• Expertise in working on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Bulk Copy Process (BCP), Data Transformation Services (DTS).
• Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using SSIS and Informatica Power Center (Designer, Workflow Manager, Workflow Monitor, Repository Manger) with Strong understanding of OLAP and OLTP Concepts.
• Demonstrated experience seamlessly learning new technologies in a short span of time, integrating well into any environment, and working well under pressure independently as well as in team-oriented environments.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler, SQL Server Analysis Service (SSAS)

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS), Informatica power center 9x,8x, Visual Studio 2010,2014

Reporting Tools: SQL Server Reporting Services (2005/2008 R2,2012,2014), MS Access, MS Excel

Database: MS SQL Server 2014/2012/2008/2005, MS Access, Oracle 11g,12c

Modeling Tools: Microsoft Visio, SQL Diagrams, ERWIN 4.1Programming: T-SQL, PL/SQL, VB.Net, Python, XML, HTML, C#, C, Java, C++

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

Operating Systems: Windows 2012/2008 R2/2003/2000 Server (64/32 Bit), Windows 2000 Professional, Windows NT 4.0/3.5. Unix, Linux

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, ERWIN, TriZetto Facet, Citrix, Diagnostic Manager, IBM WebSphere (One Run, CMU), TWS, Service Now, Ultra Edit, One Note, MS Outlook, SOAP UI.

PROFESSIONAL EXPERIENCE:

Confidential, Silver Spring, MD

Sr SQL Server/BI Developer

Responsibilities:

• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors using SQL Server Management Studio.
• Created User Defined Functions, Views to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updates to improve the query performance.
• Tune SQL queries and database performance by improving overall table design, indexing, query plan analysis and refactoring. Create database design documentation at architectural and functional level.
• Review database objects for data integrity, quality, security, recoverability, scalability, maintenance and capacity recommend changes as necessary.
• Recommend new strategies and architecture to enhance efficiency of data systems.
• Plan manage and track database and SQL procedures system changes.
• Create tasks, sessions etc. in the workflow manager and monitored them in the workflow monitor.
• Performed data domain discovery and Identified data standardization, validation, de-duplication in source data.
• Identified and eliminated duplicate datasets and performed Columns, Primary Key, Foreign Key profiling using IDQ 9.5.1. for MDM.
• Extensively Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Worked with mappings to dynamically generate parameter files used by other mappings.
• Involved in performance tuning of the ETL process by addressing various performance issues at the extraction and transformation stages.
• Documented the mappings used in ETL processes including the Unit testing and Technical document of the mappings for future reference.
• Designed developed the SSIS packages to extract, transform, load the data into target.
• Scheduled the Informatica Workflows to start running at specified date and time repetitively forever. Participated in unit testing to validate the data in the flat files that are generated by the ETL Process.
• Involved in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the Tabular, OLAP and Operational data.
• Used Repository Manager to Import/Export Metadata and promote Incremental changes between the DEV/QA/PRD environments.
• Experience using Metadata Manager for data lineage and Business Glossary to define business terms.
• Define the roles and access privileges for developer/administrator/data steward/requestor etc. on requirement basis.
• Create the test cases and Test plan for each scenario, perform sanity checks in Dev/SIT and UAT boxes as need basis for Vendor domain.

Project Environment: MS SQL Server 2014, Visual Studio 2013, SQL Server Integration Services (SSIS), Data Warehouse, Informatica Power Center 9.5.1, Oracle 11g, PL/SQL, Unix, Windows 10, MS Office, MS Visio, C#, Erwin 9.2 Data Modeling, Share Point, Team Foundation Server (TFS), ERP, CRM software, Widows server 2012, Linux server.

Confidential, Newport News, VA

SQL Server/BI Developer

Responsibilities:

• Interaction with clients while business requirements, design & implementation phases.
• Created different types of reports such as drill down, drill through, parameterize and dash board reports and schedule them according to business requirement using SSRS.
• Generating on-demand, ad-hoc, custom reports for business analysis and management decision using SSRS.
• Migrated data to the staging server and then that data were later populated to the OLAP (Online Analytical Processing) Server to use with SSAS for analysis purpose.
• Design develop & test the ETL processes according to industries best practices using SSIS.
• Extensively used various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers & import/export wizard while developing packages.
• Wrote complex T-SQL and PL/SQL queries, stored procedures, views, triggers, functions, table variables, and cursors as per business requirement.
• Made indexes, constraints & business rules wherever applicable.
• Used SQL profiler for performance tuning & debugging issue whenever necessary.
• Involved in creating Tabular Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services 2008 and Created ad-hoc reports Using Report Builder.
• Built the SSRS reports from Different Databases like Oracle and SQL Server. Configured and deployed SSRS reports.
• Scheduled and maintained Backups, defined user roles and maintained Log Shipping and Replication.
• Involved in performance tuning of complex T-SQL and PL/SQL quires using SQL Profiler and Execution Plan.

Project Environment: MS SQL Server 2008, SSIS 2008, SSRS 2008, Excel, Oracle 10g, T-SQL, Microsoft Office, C#, VB.NET.

Confidential, Silver Spring, MD

Sr SQL Developer

Responsibilities:

• Created Stored Procedures, Triggers, and Functions, Indexes, Tables, Views, T-SQL code and SQL Joins for applications.
• Designed SSIS packages to transfer data from various sources like XML files, Excel, MS SQL Server 2008R2/2008 to and from Oracle 10g.
• Extracted data using SSIS packages (ETL) from different server locations and data sources like Excel, CSV, flat file, and Text Format Data, and load data using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse databases.
• Analyzed and designed the business rules for Data Cleansing using various transformations such as Lookup, Fuzzy Lookup and Derived Column that are required by the staging OLAP and OLTP databases.
• Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
• Involved in the migration of MS SQL Server .
• Migrated packages from development server to production server using package configuration.
• Worked with application developers and production teams across functional units to identify business needs and discussed solution options.
• Defined the browsing perspectives and browsing translations since most transactions were online.

Project Environment: MS SQL Server 2012/2008R2/2008/2005, SSIS, SSRS, Microsoft Performance Point Server 2010, T-SQL, Visual studio 2013, MSBI tools, Citrix, ServiceNow, Java, Microsoft Office, Erwin 7.3, and Report Builder 3.0.

Confidential

SQL Server BI Developer and MSSQL DBA

Responsibilities:

• Developed Tables, Views, and Stored Procedures using SQL Server Management Studio.
• Used the SSIS to migrate databases such as Excel files, flat files and SQL Server database to centralized IT destination.
• Created many complex database code objects such as Stored Procedures/ views/ Functions and used them to generate reports and created indexes to the tables that have least updates to improve the query performance.
• Developed Tabular Reports, Sub Reports, Matrix Reports, Drill-down Reports and Charts using SQL Server Reporting Services (SSRS).
• Created various SSIS packages to transfer data from OLTP (Tabular) databases to staging area and then into data warehouse.
• Deployed the packages to the appropriate destinations using SSIS and successfully created dynamic package configuration in SSIS.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Have good business analytical and technical knowledge in Healthcare Membership, Benefits and Provider Modules in FACETS.
• Support Batch and Online processes involving development, enhancement and support of T-SQL procedures, views, triggers and query tuning.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages.
• Used different types of Transformations for Data Conversion, Sorting and data cleansing from different Sources into Company Formats.
• Created XML Package Configurations, Error Handling using Event Handlers for On Error, On Warning, and On-Task Failed Event Types.
• Provided 24 X 7 DBA supports for development, testing and production SQL Servers environment
• Installation of SQL Server 2008R2,2012 and 2014 with specific requirements, performed hardening and post provisioning to ensure standard and security
• Configuring HA and DR solution including Replication, mirroring, and log shipping, Always-On Availability groups and Failover Clustering installation and Configuration SQL 2012 and SQL 2014
• Extensive experience in database backup and restoring in testing production environment
• Experience creating and rebuilding indexes.
• Experience creating scheduled jobs and maintenance plan
• Updated statistics with full scan on a weekly basis to make sure that the query optimizer uses the most recent statistics
• Used SQL Profiler (Tracing), Execution Plan, Performance Monitor and DBCC Commands to find the slow running queries to get the performance metrics and performance tuning.

Project Environment: MS SQL Server 2014/2012, Visual Studio 2013/2010, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS) Microsoft SharePoint, MS Project, VBA, MS Office, Erwin 9.2 Data Modeling, ALM for QA testing and Software Development Life Cycle (SDLC)