Priya

Email: adwgot@r.postjobfree.com

Ph#: 904-***-****

Professional Summary:

●Over 6+ Years of experience in analyzing, designing, tuning and developing Client/Server Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using SQL Server Integration, Reporting & Analysis Services.

●Experience in installation, Upgrade and configuration of MS SQL Server database and Postgresql.

●Experience in Transform and Load (ETL) Solutions for Data warehousing using DTS/SSIS packages from SQL Server etc., and loading them into target databases.

●Hands on experience in Scheduling Jobs and Alerts in MS SQL Server Integration Services (SSIS).

●Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.

●Experience in developing User Reports and Management Reports using MS SQL Server Reporting Services (SSRS).

●Experience in developing, maintaining and supporting operational reports, dashboards and scorecards using Microsoft Power BI.

●Hands-on experience in creating ADF Pipelines and Scheduling Triggers.

●Experience in migration of data from legacy systems to Modern Databases.

●Implemented Copy activity, Custom Azure data Factory Pipeline Activities for on-Cloud ETL Processing

●Designing and Developing Azure Data Factory(ADF) extensively for ingesting data from different source systems like relational and Non relational to meet Business Functional requirements.

●Extensive knowledge in T-SQL queries (DDL and DML) and construction of complex queries involving multiple tables to create and maintain database objects like Stored Procedures, User Defined Functions, Triggers, Views, and Indexes.

●Good knowledge in developing Custom Report and different types of Tabular Reports, Matrix Reports, Ad hoc Reports and Distributed Reports in multiple formats using SQL Server Reporting Services (SSRS).

●Expert in creating databases and various SQL server objects like schemas, tables, indexes, indexed view as per the specifications and requirements to meet the business functionality.

●Expertise in creating complex Stored Procedures (Dynamic and static), effective User-Defined functions, and appropriate triggers to facilitate efficient data manipulation and data consistency.

●Experience in creating package configurations like XML, SQL Server Configurations and Logging using text, XML and Windows event log.

●Experience in Migration using SSIS/DTS Packages and Metadata Management, migrating DTS Packages to SSIS using Packages Migration Wizard and knowledge on Storage Management.

●Experience in logging, Error Handling, Check Points, and Package Configuration to provide the dynamic flow of data to load data warehouses.

●Knowledge of Relational Database management systems (RDMS), Schema and Data Modeling.

●Excellent communication and interpersonal skills, self motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and teamwork skills.

●Certified in Microsoft Azure Fundamentals (AZ900).

Technical Skills:

SQL Server Tools

SSMS, Enterprise Manager, DTS, Profiler, Upgrade Advisor

ETL & Reporting Tools

Azure DataFactory,Qlik Replicate,SSIS, SSRS, SSAS, BIDS, DTS, Business Objects, Power BI

Databases

Postgresql,SQL Server 2008/2008R2/2012/2014, Oracle

Programming Languages

SQL,T-SQL, PL/SQL

Scripting

JavaScript, VB.NET

Tools

Visual Studio 2010, Report Builder, Erwin

Operating System

Windows XP/2003/2007/2010, Windows Server 2008 R2, Windows Server 2012

Education:

Bachelor of Technology in Computer Science & Engineering 2010, JNTU, Hyderabad, India.

Professional Experience:

Client: Nolan Transportation Group July 2021-Till Date

Organization: Cognizant Technology Solutions Pvt ltd

Role: Azure Data Engineer/SQL Developer

Nolan Transportation Group (NTG) is a third-party logistics company. It offers full truckload, expedited, refrigerated, partial, less than truckload (LTL), drayage, intermodal, air cargo, and warehousing services.

Responsibilities:

● Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are

delivered in a timely manner.

● Understand the functional requirement specifications and prepare design documentation.

● Designed and created different ETL pipelines using AZURE ADF and transferred data from SQL SERVER Source

to PostgreSQL destination.

● Designed and Created tasks using Qlik Replicate and transferred the CDC data to control tables.

● Created Linked Services, data sources, connection strings and defined the datasets for creating pipelines.

● Designed and wrote the queries in the query builder for retrieving the data.

● Data masking scripts created during data refresh Production to lower regions.

● Data refresh has been done at target tables for many of the ad hoc change requests.

● Designed and wrote the stored procedures to have incremental data load for run time calculated columns.

● Designed and wrote the queries in the query builder for retrieving the data.

● Data masking scripts created during data refresh Production to lower regions.

● Involved in production deployment activities for each release and supported the team for successful deployments.

Client: Bank of New York Mellon, New York, NY. Mar 2020 – June 2021

Role: SSIS /Power BI Developer

The Bank of New York Mellon Corporation, commonly known as BNY Mellon, is an American investment banking services. NY Mellon was formed from the merger of The Bank of New York and the Mellon Financial Corporation. It is the world's largest custodian bank and asset servicing company.

Responsibilities:

●Interface with users, project manager to ensure that implemented solutions satisfy business requirements and are delivered in a timely manner.

●Understand the functional requirement specifications and preparing design documentation.

●Installed, configured and maintained SQL Server Integration Services (SSIS).

●Deployed packages to SQL Server and file system in 2012 and also used the new Project based Deployment introduced in SQL Server Data Tools (SSDT) to deploy the 2014 packages.

●Maintained the SSIS projects and users accessing the Catalog and SSISDB.

●Scheduled and monitored the SQL Agent jobs to run these packages periodically.

●Deployed the SSIS Packages and created jobs for efficient running of the packages.

●Created ETL packages using SSIS to extract data from heterogeneous database and then transform and load into the data mart.

●Wrote complex SQL Queries using multiple joins for creating adhoc reports using Report builder based on the requirements.

●Designed SSRS reports with sub reports, dynamic sorting, defining data source and subtotals for the report.

●Deployed SSRS reports to Report Manager and created linked reports, snapshots and subscriptions for the reports and worked on scheduling of the reports.

●Scheduled Cube Processing from Staging Database Tables using SQL Server Agent using SSAS. Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.

●Used package variables and configuration files to run the packages manually mapping through environment variables in case of job failure.

●Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL Server destination.

●Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.

●Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL.

●Worked on developing Power BI reports and dashboards from multiple sources.

●Used Power BI Power Pivot to develop data analysis prototype and used Power View and Power Map to visualize reports.

●Defined data sets with joins and sub-queries for complex queries involving multiple tables in Power BI.

●Used different types of visualizations Like (Stacked bar Chart, Clustered bar Chart, Scatter Chart, Pie Chart, Donut Chart, Line & Clustered Column Chart, Map, Slicer etc.) in Power BI according to the requirements.

●Published dashboard, reports to online Power BI could service for the use of report consumers.

●Used business object tools to develop reports and accessed, formatted, and delivered information to large populations of users.

●Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).

●Performing Unit testing and internal QA for the developed application.

●Working closely with the users supporting the existing reports and creating new reports.

Environment: MS SQL Server, SSIS, SSRS, SSAS, Power BI, MS Access, Visual Studio 2010/2008/2005, HTML, Windows XP.

Client: The Northwestern Mutual Life Insurance, WI. Aug 2018 – Dec 2019

Role: SSIS/Power BI Developer

The Northwestern Mutual Life Insurance Company is an American financial services mutual organization based in Milwaukee. The financial security company provides consultation on wealth and asset income protection, education planning, retirement planning, investment advisory services, trust and private client services, estate planning and business planning. Its products include life insurance, disability income, and long-term care insurance; annuities; investments; and investment advisory products and services.

Responsibilities:

●Collected business requirements from users and translated them as technical specs and design docs for development.

●Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.

●Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc on various database objects to obtain the required results.

●Done Bulk data migration using SSIS from flat files.

●Created checkpoints and configuration files in SSIS packages. Performed incremental data load packages in SSIS.

●Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.

●Created data sources, connection strings and defined the datasets for generating the report.

●Designed and written the queries in the query builder for retrieving the data.

●Processed and maintained the cubes on a schedule directly in SQL Agent using XMLA or through SSIS process task.

●Performance Tuning the Stored Procedures used in SSIS Packages and SSRS Reports.

●Created multiple reports using Tableau and Power BI.

●Implemented Power BI gateway different source to matching analysis criteria and further modeling.

●Utilized Power BI to create various analytical dashboards that depicts critical KPI's along with slicers and dicers enabling end-user to make filters.

●Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.

●Created SQL Agent Jobs and scheduled the SSIS Package to run overnight. Resolved the issues associated with the job failure.

●Used SQL Profiler for troubleshooting, monitoring, optimization of SQL Server and SQL code.

●Created numerous sub reports, drill down reports as part of the project according to business requirements using Reporting Services (SSRS).

●Prepare documentation related to database design, objects security and rules.

●Involved in Performance Tuning of SSIS Packages, reports, Views, Stored procedures using SQL Profiler and Tuning Advisor improving performance and scalability.

●Created Alerts for successful or unsuccessful completion of Scheduled Jobs.

●Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.

●Created SSIS packages to extract data from OLTP and transformed to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.

●Developed SSIS packages for File Transfer from one location to the other using FTP task.

●Wrote complex Stored Procedure, Queries, Triggers, Functions, Indexes, User-defined functions and Cursors for the application.

Environment: MS SQL Server, SSIS, SSRS, SSAS, DB2, Power BI, MS Access, HTML, XML, Windows XP.

Client: AT&T Dallas, TX. Feb 2011– Aug 2013

Tech Mahindra Hyderabad India

Role: SQL Server Developer

Responsibilities:

●Involved in troubleshooting, enhancing and creating new ones of claims retro report templates.

●Gather requirements from users and business analysts and created requirement documents.

●Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually

●Involved in writing stored procedures for both Online and Batch requests handling business logic and functionality of various revenue modules

●Involved in writing various DB Objects like User defined functions, Instead of triggers, Usage of Indexes for accomplishing various tasks

●Worked on analyzing and Performance tuning queries by looking at the Indexes, appropriate joins, Query Statistics and Execution plans using SQL Profiler /Query Analyzer/SSMS.

●Used SQL joins, sub queries, tracing, usage of Table Variables, Temp tables etc.

●Involved in Event Logging, error handling & logging Log files, File and File Groups, Security, Backup and Recovery

●Created stored procedures to use as the datasets for the Report Design.

●Involved in generating reports for Forecasting Revenues based on the historical data and used various delivery mechanisms and formats to deliver the reports.

●Configured Subscriptions and Security for all critical reports.

●Handled the database components (Code migration, Change control) for application releases.

●Creates technical specifications, test plans and test data to support ETL processes.

●Involved in Database Administration activities like Back up, Security, Migrations in the Development servers.

Environment: MS SQL Server, SQL server Analysis Services (SSAS), Reporting Services (SSRS), SSIS, Microsoft Visual Studio 2005, BIDS, MSOffice, HTML.

Contact this candidate