SUMMARY

• Versatile IT Professional Experience in Azure Cloud over 3 years as Azure data Engineer and over all 15 Years in IT Experience in Database Design, Development, Implementation and Support using various Database technologies in both OLTP, OLAP and data warehousing environments.
• Design and develop data architecture for scalable technical solutions in the areas of data optimization, data management, performance and efficiency while handling data volume and velocity.
• Strong development knowledge in creating pipelines, data flows and complex data transformations and manipulations using ADF with Databricks and Azure Storage Explorer.
• Experience in Azure Cloud, Azure Data Factory, Data bricks, Azure Data Lake Storage.
• Experience in creating different types of Tabular, Matrix, Drill - Down, Chart report, Sub reports and Cross Tab Reports in multiple formats by using SSRS.
• Experience in Performance Tuning and Optimization of stored procedures and Queries.
• Performed Data Cleansing to perform duplication and validation for redundant data elimination.
• Experience in Writing Dax functions scripts and creating Quick measure and creating Bookmarks and parameters in Power BI.
• Visualizations filters, page level filters and report level filters in Power BI and creating groups and Content package and in Power BI and scheduling refresh using Power BI gateways
• Created reports using Power BI Desktop, Power BI mobile, Power BI Service, and Creating Power Bi reports & dashboards with SQL Server/Tabular SSAS, Excel, web, csv, Azure (Azure Data Lake Store, Azure Data Lake Analytics) and other sources and DAX Queries.
• Strong technical knowledge inSQL Server BI suite (ETL, Reporting, Analytics, Dashboards) using SSIS, SSAS, SSRS andvarious 3rd party tools
• Review business requirements and technical design documents to develop effective database solutions
• Experience in MS SQL Server development and Microsoft Business Intelligence tools DTS, SSIS, SSAS and SSRS.
• Excellent T-SQL Developer skills including Stored Procedures, Indexes, Views, User Defined Functions, Triggers, Cursors and complex queries.
• Expertise in handling RDBMS.
• Experience in Analyzing, mapping, transforming and transferring data using SSIS packages.
• Experience in performance monitoring SQL server by using SQL Profilers, Performance monitor.
• Highly experienced in Creating, Configuring and Fine-tuning ETL workflows designed between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008R2, MS SQL Server 2008 and MS SQL Server 2005 respectively.

TECHNICAL SKILLS

Database: MS-SQL Server 2000/2005/2008/2012/2017 , Microsoft Access 2003

Azure Tools: Azure Data factory, Azure SQL database, Azure data bricks.

SQL Server Tools: SQL Server Management Studio, Enterprise, Query Analyzer, SQL Profiler, Import and Export Data wizard, SSIS, Azure data studio, Enterprise Manager.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Data Transformation Services, Azure data Factory

Reporting Tools: SQL Server Reporting Services, Power BI, MS Excel

Programming Language: SQL Spark, SQL, T-SQL, DAX, MDX, C#, VB.NET, Azure CLI

Web Development: ASP.Net (1.1/2.0), Web Services, HTML, CSS

Application Server: IIS 5.1/6.0

Analytics Tools: Power BI, SQL Server Analysis Services (SSAS) & Tabular Cube with MDX

Version Control Management: Vss, TFS, Github

Business Tools: Jira, Kanban, ClearCase

Operating System: WINDOWS XP, Windows Server 2003, 2008, 2012

PROFESSIONAL EXPERIENCE

Confidential, Princeton, NJ

Lead Programmer Analyst

Responsibilities:

• Building the pipelines to copy the data from source to destination in Azure Data Factory (ADF V2)
• Responsible for to develop ETL pipelines to meet business use cases by using data flows, Azure Data Factory (ADF), Data Lake and Azure Datawarehouse.
• Created automated workflows with the help of triggers and Scheduled Jobs in Flows and ADF Pipelines
• Responsible to manage data coming from different sources and loading of structured and unstructured data
• Worked on different files like CSV, JSON, Flat, Parquet to load the data from source to raw tables
• Implemented Triggers to schedule pipelines.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards
• Successfully creating the Linked Services on the source and as well for the destination servers
• Worked on providing row level securities using power bi to restrict data access for various users.
• Develop customized calculated Columns and measure using DAX Formula language in Power BI to satisfy business needs.
• Design and develop data schema, data models, data representation, and application objects
• Involved in migrating all the DTS packages to SQL wrapper procs implementing the same functionality to satisfy the business needs.
• Developed advanced queries to retrieve, analyze and update data and evaluated SQL statements for performance tuning.
• Improved performance of Script to move contents of 100gb to reducing 32hrs to 4hrs of script execution time.
• Over 5mil records are handled to migration from source to target to split the data into batchwise implementation in providing control to stored procedure to adjust record counts.
• Maintaining database dictionary recording all the metadata of a database on regular basis and documenting.
• Conduct data model reviews with developers, architects, business analysts and subject matter experts to collaborate and gain consensus.
• Coordinate with cross-functional teams in different locations for quality data analysis
• Analysis and development of new Change controls involving creating stored procedures, SSIS packages creating, Job creation and scheduling etc.
• Perform data integration from multiple sources such as Excel, MS Access, flat and csv files to extract, transform, and load data into the SQL Server database.
• Implemented performance fixes to SQL objects like stored procedures, functions and views and Indexes.
• Estimate LOEs for new requirements based on the complexity and number of resources
• Created SSIS packages to Extract, Transformation and Load (ETL) user data and other data from OLTP to OLAP.
• Configured and deployed the new Project based deployment in SSIS 2012. Deployed the Projects to Integration Services Catalog and managed the security and created SQL Server Agent Jobs to schedule daily data transformation.

Environment: MS-SQL Server 2008/2017, SQL Server Integration Services (SSIS), Power BI, Import and Export Data wizard Visual Studio 2005/2010, SQL Profiler, VSS, TFS

Confidential, Piscataway, NJ

MS BI/ SQL developer

Responsibilities:

• Involved in data base design and guiding team on database design and performance factors.
• Loaded data from multiple data sources SQL server 2005, flat file sources and Microsoft access databases (SSIS).
• Configured end to end SSRS reports using report server.
• Generated Drill down, Drill through, Matrix Reports, parameterized reports using SSRS.
• Created standard and data driven subscription in SSRS reports.
• Configured reporting manager URL’s and providing necessary security permission to users.
• Created Ad-hoc and sub reports using SSRS and subscribed them based on user requirements.
• Improved the performance of slow running reports.
• Created report snapshots to improve the performance of SSRS
• Performance Tuning and Optimization of stored procedures and Queries.
• Performed Data Cleansing to correct the Junk data and corrupt data all over the data base.
• Created Jobs and scheduled Packages using SQL Server Management Studio for the Daily Load.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Maintaining database dictionary recording all the metadata of a database on regular basis and documenting.
• Created Maintenance Plans to database backups.
• Upgradeddatabases from SQL Server 2005 to SQL Server 2012.
• Identified compatibility and new requirements for several business applications to work with SQL Server 2012.
• Created complex reports such as Gauges, Matrix, Charts, Cascading Parameters, Sub reports and Dashboards using SSRS 2008R2.
• Scheduled and monitored SSRS report subscription and deliveries such as Email Delivery and File Share Delivery as required.
• Preparing the Weekly status report to the client on the progress.
• Task monitoring and delivery.

Environment: MS-SQL Server 2005/2012, SQL Server Integration Services (SSIS), Import and Export Data wizard Visual Studio 2005/2010, VSS, TFS, SQL Server Reporting Services, Power BI, SQL Server Analysis Services (SSAS),SQL Profiler.

Confidential, Baltimore, MD

BI Developer

Responsibilities:

• Used SSIS to extract data from Oracle, DB2 Data base, Flat files, XML Files, Excel files added multiple transformations to transform the data and loaded Enterprise data warehouse.
• Used SSIS to extract data from Oracle, DB2 used different transformations to transform the data and finally loading into the Enterprise Data warehouse
• Developed Transact-SQL (T-SQL) Queries, Stored Procedures, Triggers, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains and Rules.
• Involved in Error Analysis for tracking error files records and for analyze the data.
• Monitoring the Daily/Weekly/Monthly scheduled jobs in SSIS.
• Involved in ETL testing for various data files.
• Involved in reviews of SSIS Packages, Test Specifications and another deliverable.

Environment: MS-SQL Server 2005, SQL Server Integration Services (SSIS), Import and Export Data wizardVisual Studio 2005, TFS,SQL Server Reporting Services, SQL Server Analysis Services (SSAS)

Confidential

BI Developer

Responsibilities:

• Migrated the SSIS packages from .
• Involved in migrating the packages using the upgrade wizard.
• Involved in fixing the bugs form the migrated packages with configurations.
• Validating the data for the migrated packages in large volumes.
• Involved in ETL testing for various data files.
• Involved in reviews of SSIS Packages, Test Specifications, and another deliverable.

Environment: MS-SQL Server 2012, SQL Server Integration Services (SSIS), Import and Export Data wizard

Confidential

Software Developer

Responsibilities:

• Created complex stored procedures to fetch data from sql server for reports developed in Cognos
• Implemented dynamic logic to capture the error data for reporting purpose.
• Creating the SSIS packages to transfer the data from Ms Access to Sql server 2005
• Designed SSIS Packages to load data into database; Scheduled the jobs to do these tasks periodically
• Implemented the logic to execute the packages from SSMS using stored procedures.
• Designing database using SQL Server2005.
• Improved the performance of slow running reports.
• Performance Tuning and Optimization of stored procedures and Queries.
• Worked in agile process in implementing the project.

Environment: SQL Server 2005, MSBI, MS Access 2003

Confidential

Software Developer

Responsibilities:

• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Designing SSIS Packages using several transformations to perform Data Cleansing and Data Transformation.
• Utilized several Transformations like Lookup, Aggregate transformations for implementing the Transformation Logic in the Packages.
• Created Dynamic Stored Procedures and implemented in packages which improves the re-usage of packages for different data migration.
• Created Stored Procedures which eliminated the duplication in data while the data is loaded.
• Utilized T-SQL extensively in order to replace SSIS transformations in order to improve the performance of packages.
• Implemented the logic to execute the packages from SSMS using stored procedures.
• Performance Tuning and Optimization of stored procedures and Queries.
• Worked in agile process in implementing the project

Environment: SQL Server 2005, MSBI, MS Access 2003

Confidential

Software Engineer

Responsibilities:

• Involved in data base design
• Created Maintenance Plans and setup log files to monitor jobs.
• Created report from OLAP, sub reports and matrix reports using SSRS.
• Used report builder to do ad-hoc reporting.
• Creation of Web User Controls
• Perform the validations using Validation controls.

Environment: ASP.Net, C#.Net, SQL Server 2005, IIS, Windows2000

Confidential

Responsibilities:

• Involved in Merchant module for updating of books catalog.
• Involved in data base design
• Developed the database connectivity to access the database using ADO.NET.
• Performed Unit Testing

Environment: ASP.Net, C#.Net, SQL Server, IIS, Windows2000

Confidential

Responsibilities:

• Involved in Design and Development
• Involved in data base design
• Developed the database connectivity to access the database using ADO.NET
• Performed Unit Testing
• Attending in team meeting

Environment: ASP.Net, C#.Net, SQL Server, IIS, WindowsXP

Confidential

Team member

Responsibilities:

• Design, Development
• Performed Unit Testing
• Developed the database connectivity to access the database using ADO.NET

Environment: SQL Server 2000, ASP.Net c#, JavaScript, ADO.Net