TECHNICAL SKILLS

Databases: MS SQL server 2016/2 R2/2008, Oracle 9i/10g, PL - SQL,MS Access

Database Design Tool and Data Modeling: Oracle SQL developer, Visio, Erwin, Star Schema/Snowflake Schema modeling, FACT & Dimensions tables, Physical & logical data modeling and De-normalization

BI Tools: SQL Server Reporting Services (SSRS), Tableau, Power BI, SQL Server Integration Services (SSIS), SQL Server Business Intelligence Development Studio (BIDS), SQL Server DTS, Visual Studio, SSAS, FullstackMSBI.

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console

Microsoft tools: MS Office, Management studio, Visual studio

PROFESSIONAL EXPERIENCE

Confidential

DATA ENGENER

Responsibilities:

• SSIS- Creating new package, modify existing ETL packages
• SQL- Writing stored Procedure & generate DB conceptual knowledge
• Create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse
• Providing support, guidance and collaboration with application developers to implement database architectures in support of enhancements to existing systems
• Assist with schema design, code review and SQL query tuning
• Coordinate with team members to ensure releases are deployed correctly and that all application processes are followed as per the defined standard operating procedure
• Worked on TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Used various transformations in the ETL packages while transferring the data from OLTP source to destination using SSIS 2016
• Creating Stage table to Load quality data for dim table based business requirement
• Deploying Package from Development environment to UAT environment
• Perform root cause analysis on BI processes, resolve production issues, validate data, perform routine tests on database, and provide support to assigned ETL applications.

Confidential

DATA ENGENER

Responsibilities:

• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS)
• Developed various operational Drill-through and Drill-down reports using SSRS
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports. Developed Reports for business end users using Report Builder with updating Statistics.
• Updated functional specification and technical design documents.
• Developed reports using complex formulas and to query the database to generate different types of ad-hoc reports using SSRS. Expert in designing complex reports 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.
• Supporting Production Environment
• Monitoring weekly deployment confirming all branch is Deployed according to the plan
• Wrote complex stored procedure, views using T SQL in Management Studio 2019
• Optimized the queries for efficient data retrieval by implementing indexes on the tables

Confidential, Fairfax VA

MS SQL Server Developer

Responsibilities:

• Gathered business requirements related to data and business intelligence needs, HLD design for the ETL and Reporting requirements.
• Responsible for software development life cycle, database design, RDBMS, data warehousing and data modeling concepts.
• Liaise with business subject matter experts in analyzing Business Requirement Document(BRD)and translating them into conceptual data models and schema development to be implemented with T-SQL, ETL and Reporting to develop a solution.
• Created and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Automate SSAS tabular model cube processing using XMLA queries
• Optimized the database by creating new tables, various clustered, non-clustered indexes.
• Developed Stored Procedures, User Defined Functions, Views, TSQL Scripting for complex business logic.
• Responsible to created views with multiple Facts and dimension tables inTeradatafor building cubes.
• Map source system data elements to target system and develop, test, and support extraction, transformation, load processes, data profiling, data quality and clean ups for SSIS packages.
• Used various SSIS tasks such as Data flow task, Fuzzy lookup, Conditional Split, Derived Column and Union All which were used for Data Scrubbing, data validation checks during Staging.
• Used SSIS to implement the Slowly Changing Transformation, to maintain Historical Data in Data base.
• Created SSIS packages to load data into Data base using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task.
• Designed and developed matrix and tabular reports with drill down, drill through and drop down menu option using SSRS.
• Created Summary Reports, Sub Reports, and Drill-down Reports using Power BI
• Planned to schedule reports for daily, weekly, monthly reports for executives, Business analyst and customer representatives for various categories based on business needs using SQL Server Reporting services (SSRS).
• Designed for Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Extensively usedReport Managerto configure Web URLs, E-mail and Databases to prepare reports and make reports visually appealing by adding different report formatting options and also provided back-end support for functional testing and performance testing.

Environment: SQL Server 2016/2014/2012 , SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Teradata, Database Tuning wizard and Visual Source Safe.

Confidential, Washington DC

SQL Developer/ SSIS/SSRS Developer

Responsibilities:

• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of database, ETL and different reports.
• Worked on developing Tables, Indexes, Views, Complex Stored Procedures, Triggers, Functions, SQL joins and other T-SQL code to implement business rules in SQL Server 2012/2014.
• Wrote T-SQL, designed and modified database objects such as Tables, Stored Procedures, and UDF for SSRS report requirement.
• Extensively utilizedSQL server/Teradatautilities for loading the data in to CPM DWH system.
• UsedSQLto query the databases and do as much crunching as possible inTeradata, using very complicatedSQL.
• Defined Check constraints, Business Rule, Indexes and Views.
• Worked with data modeling product support team on tool features, functionality and maintenance.
• Designed develop SSIS (ETL) packages for loading data from OLTP system, DSR (Staging Database) to AMS database.
• Responsible for creating database objects like table, Views, Store Procedure, Triggers, Functions and more using T-SQL to provide structure to store data and to maintain database efficiently.
• Created SSIS Packages to perform filtering operations and to import the data on daily basis from the OLTP system, DSR to SQL server.
• Developed Tabular, Chart, Matrix, Drill down and Drill through reports using SSRS as well as managed the Subscriptions of the reports.
• Generated Multi Parameterized reports in SSRS allowing users the ability to make selections before executing reports; thus making them user friendly.
• Experience in deployment of the generated SSRS reports through report manager.
• Designed and developed corporate performance management solutions including Dashboards, Score cards and analysis of SSRS reports using the data from SQL Server 2008.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively used SSRS for creating reports like Sub-reports, Linked reports, Cascaded Parameterized reports, Matrix reports and different types of Graph reports.
• Created official Templates, Mailing Subscriptions and created shared data sources that can be used across different processes.
• Subscribed many of reports useful for the clients through scheduled Email subscriptions.
• Environment: SQL Server 2008, SQL Server Reporting Services (SSRS), Microsoft Visio, SQL Profiler, Database Engine Tuning Advisor and Visual Source Safe.

Confidential, Owings Mills, MD

SQL / BI Developer

Responsibilities:

• Involved in the analysis, design, created process flow diagram, coding and publication of customer facing reports.
• Created Complex Stored procedures, Triggers, Indexes, Rules, Integrity constraints, Cursors, Views and ad hoc queries using SQL 2005/2008for the business logic.
• Designed index and optimized queries by using execution plan for performance tuning of the database.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Developed various reports which include Drill down reports, Drill through repots, Cascaded Parameterized reports, Linked Reports, Sub Reports and Matrix reports using SSRS and integrated with Microsoft office Share Point portal. The SharePoint page also contains parameters for enabling the end-users to make filter selections.
• Created reports, metrics, KPIs and scorecard to the customers using SSRS.
• Experience in generating reports like Tabular, Chart, Graph, Parameterized reports using SSRS and deployed the same through report manager.
• Worked on designing and developing Executive Reports like Customer Monthly Report, Reporting Services Integration, Internal Customer facing reports and Internal Managed Security Services Reports.
• New Initiatives to automate many of the Metrics reports useful for the management and delivering it through Scheduled email subscriptions.
• Managed documents in SharePoint portal.
• Involved in the revamp of the existing database, which was primarily aimed at performance enhancement and as a step to streamline the reporting process.
• Defined a streamlined process for the entire development and testing life cycles.
• Arranging a knowledge sharing sessions and bringing up the best practices among the team.
• Environment: SQL Server 2005, 2008, SQL Server Reporting Services(SSRS), Microsoft InfoPath, Microsoft SharePoint, MS Visio, Managed HPSD (Internal Tool), SQL Profiler, Database Engine Tuning Advisor, Visual Source Safe and Share Point.

Confidential, Richmond VA

SQL Developer

Responsibilities:

• Provided database administration support on production and development servers
• Migrated the entire database objects from oneServerto anotherServer
• Created and managed database objects, store procedures, triggers, views and functions
• Created and monitored automated scheduling Jobs and Alerting using SQL Server Agent
• Scheduled jobs for backups and set notifications for job failures and disk issues
• Created new SQL Server Instance, Installation configuration, Managing server and security, move or copy database to multiple location
• Evaluated database performance and maintenance duties such as tuning, backup and disaster recovery
• Followed proper backup retention policy, keep copy of databases backup in remote location in case of disaster
• Implemented Database Maintenance Plan for Database Integrity checks, Reorganize and Rebuild Index and update statistics