SUMMARY

• 6 years of IT Experiencein Database Design, Development, and business intelligence of MicrosoftSQL Server 2019/2 /2008 (R2) in Development, Test and Production Environments.
• Active participation in Software Development Life Cycle (SDLC)specifically waterfall and Agile development methodologies.
• Created SSIS/SSDT Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet toSQL Server 2019/2016/2012
• Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and automation with SSIS.
• Excellent Knowledge on Various SSIS Objects such as Data Flow Components, Control Flow Elements, Connections Managers, Run - time Events, Log Provider etc.
• Worked on creating client reports and custom reports (On demand,Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Crosstab, graphical, aging reports etc.) using SQL Server Reporting Services 2014/2012/2008.
• Experience in creating and managing database objects like Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and functions.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling SSIS Packages.
• Experienced using in FTP and SFTP servers to upload files.
• Experience with SQL Performance tuning andtransactions analysis, thorough understanding ofindexes and statistics.
• Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them).
• ExcellentT-SQL Programming skills. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities.
• Thorough Knowledge of Various SSIS Objects such as Data Flow Components, Control Flow Elements, Connections Managers, Run-time Events, Log Providers etc.
• Created complex SSIS Packages for Data Migration and Transformation.
• Experience in developing and monitoring SSIS Packages.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
• Good Knowledge inPhysical and Logical Data Modeling.
• Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player.
• Skilled at assessing client needs, working in groups, suggesting ideas that enhance efficiency and performance, implementing technology solutions, and training end users.
• Develop Tableau data visualization using Cross tabs, Heat maps, Box and Whisker charts, Scatter Plots, Geographic Map, Pie Charts and Bar Charts and Density Chart.
• Expert level capability in Tableau calculations and applying complex, compound calculations to large, complex data sets.
• Wrote calculated columns and measures in Power Bi Desktop using good data analysis techniques.
• Design, build, and maintain dashboards visualizations using Tableau/Power BI application and ensure dashboards are creatively designed and tell a story behind the data.
• Worked on different types of transformations that are available in Power Bi Query Editor.
• Worked on different types of transformations that are available in Power Bi Query Editor.
• Worked on Cloud Azure Data Factory, Pipelines and Azure Key Vaults.
• Worked on Creating External tables to load data on Cloud Azure Data Warehouse.

TECHNICAL SKILLS

Languages: C, SQL, T-SQL

RDBMS: MS SQL Server / 2016/2014/2012/2008/2008 R2MS-Access

Web Technologies: Productivity Applications

HTML, XML: MS Word, MS Excel, MS Access, MS FrontPage.

SQL Server Tools: Enterprise Manager, SQL Profiler, Query AnalyzerSQL Server Management Studio, SSIS, SSRS

Operating System: Windows 2000/XP/10, MS Dos and UNIX

Tools: Microsoft Visual Studio 2019/2017/2013/2012, MS Office

Reporting Tools: SSRS (SQL Server Reporting Services), Power BI, Tableau

ETL Tools: SSIS (SQL Server Integration Services)

PROFESSIONAL EXPERIENCE

Database Developer

Confidential, Arlington, Virginia

Responsibilities:

• Designed advanced SQL queries, stored procedures, triggers, scripts, cursors.
• Leading/assisting in data conversion and data migration projects.
• Assisting business analysts and end-users with reporting needs.
• Collaborating with applications developers to ensure correct data and data structure to support evolving development.
• Understood Full Development Life Cycle & RDBMS.
• Developing processes for nightly builds and deployment.
• Optimizing and improving SQL code for better performance.
• Developing programming specifications through interaction with business unit subject matter experts.
• Working closely with the Team Lead and Analysts throughout the change request process to insure the delivery of an accurate solution.
• Processing change requests through JIRA ticket system, including application wide data changes.
• Estimating the level of effort required to complete a project or change request.
• Experienced in developing the SSDT packages depends on the Business needs.
• Experienced inExtracting, Transforming and Loading (ETL) datafrom Excel, Flat file, XML to MS SQL Server by using SSIS 2013/2017/2019.
• Loaded data into Fact and Dimension tables from different sources using SSIS 2013.
• Created packages in SSIS with error handling using Event Handlers.
• Implemented custom logging in SSIS using Variables, Execute SQL Task and Event Handlers.
• Extensively designed the packages and data mapping using Data flow task,for each Loop Container, Execute SQL Task, File System task and Script Taskin SSIS Designer.
• Have deployed packages on different servers by using Project Deployment in SSIS using Project and Package Parameters.
• Created different type of reports includingCrosstab, Conditional, and Drill-down, Sub reports.
• Good understanding of Microsoft Reporting Services (SSRS) with Report authoring, Report management, Report delivery and Report security.
• Experience in integrating Share Point Server with SSRS and deploying SSRS reports on to Share Point Server.
• Working closely with the Team Lead and Analysts throughout the change request process to insure the delivery of an accurate solution
• Working on processing change requests through JIRA ticket system, including application wide data changes.
• Experienced in preparing and updating technical documentation.
• Used various sources to pull the data into Power BI such as Sql Server.
• Wrote calculated columns and measures in power bi Desktop using good data analysis techniques.
• Scheduled Automatic refresh and scheduling refresh in power bi service
• Design, build, and maintain dashboards visualizations using Tableau/Power BI application and ensure dashboards are creatively designed and tell a story behind the data.
• Worked on Cloud Azure Data Factory, Pipelines and Azure Key Vaults.
• Worked on Creating External tables to load data on Cloud Azure Data Warehouse.

Environment: SQL Server 2016/2014/2012/2008 R2 Enterprise Edition, T-SQL, SQL Server Integration Services, SQL Server Analysis Services, SQL Server Reporting Services, Windows Server 2005, MS Excel and ASP/VB.NET

Software Developer

Confidential

Responsibilities:

• Interacted with Team and involved in Analysis, Design and Developing databases usingER Diagram, Normalization, and relational database concepts.
• Involved in Design, Development, and testing of the system.
• DevelopedSQL Server Stored Procedures, Tuned SQL Queries (using Indexes and Execution Plan)
• Applied Normalization rulesin designing the database.
• CreatedEntity relationship diagrams, Function relationship diagrams, data flow diagrams and enforced all referential integrity constraints.
• Developed database objects likeTables, views, stored procedures, indexes etc.
• Tuned SQL statements usingviews and Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance.
• Wrote various stored procedures for application development.
• Wrote SQL Scripts to select the data from the source. Designed and implemented data accessstored procedures and triggers for automating tasks.
• Extensively usedJoins and sub-Queriesto simplify complex queries involving multiple tables.
• ImplementedExceptional Handling.
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler.
• RebuildingIndexes and Tablesas part of Performance Tuning Exercise.
• Involved inperforming database Backup and Recovery.
• Worked on Documentation using MS word.

Environment: SQL Server 2012/2008R (2)/2005, SQL, T-SQL, BCP and ASP/VB.NET, Microsoft Visual Basic 6.0 and Windows 2000