SUMMARY:

• Strong MS SQL Database and BI developer with more than six years of experience. In addition to the technical skills, I have the ability to multitask, identify trends and propose solutions to problems. A willing team player, with the ability to learn and absorb new technical topics quickly. Evidenced ability in working with business teams (technical and non - technical) to read, understand and translate requirement documents to code and design.
• Installing, upgrading and configuring Microsoft SQL server 2008 - 2014, SSIS, SSRS, and data migration from SQL Server 2008 to SQL2012
• Worked with RDBMS concepts, physical and logical database designs, data mapping, normalization, data modeling and ER diagrams.
• T-SQL: Views, Stored Procedures, Cursors and Triggers, and creating tables, indexes, constraints, views, synonyms and procedures.
• Review of SQL code written by application developers to ensure compliance of coding standards and best practices to maximize performance.
• SSIS: Expert in design and development of packages and using various control flow task and data flow transformations.
• SSIS: Extracted, transformed, and loaded data from various heterogeneous data sources and destinations such as Access, Excel, CSV, Oracle, and Flat Files using connectors, tasks and transformations provided by SSIS.
• Security / Authentication: database tuning, server logins and database permissions. Practical experience with active directory.
• SSRS: writing and updating reports using SSRS.
• Designed Subscriptions and Security for Reports.

TECHNICAL SKILLS:

Operating Systems: Microsoft windows all Version, Linux.

Languages: T-SQL, PL/SQL, ASP.NET, .NET Framework, VB, VBA,C++,C#, WPF.

Warehouse Tools: SSIS, SSRS, SSAS, Informatica, Business Objects, (SAP), PWS framework. ETL Tools SSIS, SAS Data Management, OWB, IBM Infosphere Information Server .

Database: MS SQL Server 2016/2014, 2012/2008/2005, Oracle 11g/10g, DB2,MS Access, DTS, TFS server.

PROFESSIONAL EXPERIENCE:

Confidential, Washington DC

SQL Database Developer

• Involved in complete Software Development Life Cycle (SDLC) process by analysing business requirements and understanding the functional work flow of information from database designing to deployment the production environment.
• Involved in Setting up Developmental environment by installing source tree, creating repository and cloning the source code to local repository.
• Good Knowledge in Analyzing, designing, building & testing of SQL 2008-SQL 2014
• Involved in conceptual, logical and physical database modelling for a WPF desktop application.
• Normalized tables by going through the basic principles of normal forms for redundant data’s in the database.
• Extensively worked on Microsoft SQL Server 2005/2008/2012/2014 and ASP.NET 3.5, 4.0, 4.5 C#,MVC, SSRS, SSIS, Agile methodology, Java script.
• Defined constraints, rules and indexes (clustered and non-clustered) based on business requirements.
• Experienced in developing and debugging complex SQL Queries, Dynamic Stored Procedures, User Defined Functions, Triggers, Views, Cursors, Joins, Sub-queries, CTE’s, Constraints, DDL and DML to implement the business logics.
• Experienced in writing upgrade scripts using Merge statements for database and application versioning.
• Involved in ETL architecture and analysing business requirements for data migration project into the data warehouse. prepared detailed documentation of all the Business objects Reports and Universes which were created newly. worked extensive with database design team and development team for database design, and implementation, used Erwin and Visio for database design and SQL 2012 for development implementation the data partitioning for large tables in SQL server 2012.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and scheduling the packages using SQL Server Agent.
• Analyze and perform data mapping which involves identify source data field and target entities.
• Experienced in using different transformations tools like derived column, data conversion, merge, sort, union all, union, SCD, lookup, fuzzy lookup etc.
• Experienced in using different control flow tasks like data flow task, execute SQL task, file system task, FTP task, for each loop container, for loop container, sequence container etc.
• Experienced in using different data source and destinations like Access, Excel, CSV, Oracle, flat files, SQL Server etc.
• Implemented Event Handlers, Error Handling, Logging and package configuration for deployment to test and production environment.
• Involved in complete SSRS life cycle in creating SSRS packages, building and deploying to report server.
• Involved in designing parameterized reports for generating Ad-Hoc reports.
• Experienced in using data source and data sets to build embedded and parameterized reports.
• Experienced in using and designing different dashboards for reports like matrix, table, bar and charts.
• Involved in granting permission and access to users for reports in SQL Report Server.
• Handled various technical aspects like product documentation, software design, coding of modules, monitoring critical paths and taking appropriate actions.
• Designed, automated and scheduled database backup, recovery and restore plan using stored procedures and SQL Server Agent.
• Implemented database replication and mirroring as of High availability options to cloud database.
• Granted, revoked and denied user’s permission and access to SQL server through the desktop application.
• Experienced in using SQL Server Profiler and Database tuning advisor to identify long running TSQL queries and stored procedures for better performance tuning.
• Strong working experience with Business Objects Enterprise Architecture, including deploying reports Universes to server, scheduling reports, migration wizard, and central management console (CMC), Creation of user groups, implementing access restrictions Migration using Life Cycle management, Central Management server (CMS), Disaster recovery etc.

Environment: SQL Server 2016/2014/2012/, SSIS,SSRS,SSAS, Business Objects, (SAP), PWS framework, Oracle, VB,VBA,ASP.net, C++,C#,TP SERVER, AJAX, Sheerpoint.Oracle,DB2,MS, Access, Iformatica, Agile methodology.

Confidential, Springfield, VA

SQL and BI developer

• Experience in creating Index, Views, complex Stored Procedures, appropriate user defined functions (UDF) and effective Triggers to facilitate efficient data manipulation and data consistency on Microsoft SQL Server database platform.
• Responsible for gathering business requirements, documents and delivered functional specification documents to the project team. assisted the project Manager to develop both high-level and detailed database architecture to meet user requests and business needs.
• Actively participated in interaction with users, team lead, DBA and technical manager to fully understand the requirements of the system.
• Responsible for Analysis, Design and Development of database using ER Diagram, Normalization, and relation database concept.
• Knowledge of the Data Modeling( Dimensional and Relational) concepts like Star-schema Modeling, Snowflake Schema modeling, fact and Dimension tables.
• Developed logical and physical data model using ERWIN and mapped the data into database objects.
• Written different T-SQL scripts for automated execution of the tasks.
• Experience writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, and cursor. worked closely with client managers/ business Analysts of the back to drive technical solutions, design and provide development estimates for schedule and effort.
• Worked very closely with product owners, projects managers and vendors to satisfy all the business needs
• Database development experience with Microsoft SQL Server in OLTP/OLAP environments using integration services (SSIS) for ETL (Extraction, Transformation and Loading).
• Created ETL Projects using SSIS 2008R2 in package Deployment Model as well as project Deployment Model, also efficiently used SSIS catalog for ETL monitoring.
• Developed SSIS packages that fetches files from FTP, did transformation on those database on business need before loaded to destination.
• Provide back-end support for online application and review system in SQL server 2008 standard and SQL server 2012 Enterprise, making extensive use of advanced T-SQL and XPaths statements.
• Continuous improvement to overall database performance, cleanup of stored procedures and function.
• Expertise in creating Metadata tables to log the activity of the packages, errors and change of the variable. Various techniques such as CDC, SCD and hash bytes were used to capture the change of the data and execute incremental loading of the dimension tables.
• Responsible for Deploying, Scheduling job, Alerting and maintaining SSIS packages.
• Implementing and managing Event Handlers, Package Configuration, Logging System and User- defined Variables, Check points and Expressions for SSIS packages.
• 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.
• Extensively used SSIS to move data from heterogeneous data sources to SQL Server.
• Extensively used Proc SQL for highly advanced matching and merging between large datasets.
• Experience in SQL Server DTS and SSIS (Integration Service) package design, constructing, and deployment.
• Created complex DTS Packages for Data Migration and Transformation from Oracle/Access/Excel Sheets using SSIS and Visual C#
• Experienced in using SQL Server Agent to schedule SSIS packages.
• Designed and developed matrix, tabular, drill down reports.
• Designed various SSRS reports as requested by the client
• Created and developed Sub-Reports, Drill down reports, Drill though reports and Parameterized reports using SSRS.
• Based on the required reports, identified various data sources and established the connections using SSIS and constructed data source view during extraction of data
• Created many complex database code object such as Stored Procedures/ views/ function and used them in Report directly to generate reports on the fly.
• Report design and Coding for Standard tabular type reports, including Drill down and Drill through functionality, Charts and Dashboard type metrics.
• Developed report Models using report builder and distributed reports in multiple formats using SQL Server reporting Services(SSRS) in Business intelligence development studio (BIDS)
• Extensive Knowledge in SSAS storage, partitions and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Good Knowledge in Analyzing, designing, building & testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Expert in Designing and deploying cubes in SSAS environment using Snowflake and Star Schema Designs for the operational data.

Environment: SQL 2005,SQL 2008R2, SQL 2012, BI (SSIS, SSRS, SSAS)ASP.net, VB, C#, C, java script, Orange scrum, Bit bucket server, Agile methodology.