Mail Agent Data Entry

SUNITA PANDEY

Contact: 253-***-**** Email: adwod8@r.postjobfree.com Location: Auburn, Washington, 98092

SUMMARY OF QUALIFICATIONS

Have more than 5 years of experience in diverse business and technical environments with main area of focus in design, development, implementation and support of relational databases, data analysis, business intelligence, ETL, and data visualization using RDBMS databases and various reporting and visualization tools.

Strongly experienced on SQL Server as a Developer, experience includes Database Design and Development, Confidential BI Solutions, ETL Development, Data warehouse Implementation, Report Development using SSAS, SSIS, SSRS and TSQL.

Well versed in all Software Development Life Cycle (SDLC) phases of specifically waterfall and Agile Scrum methodology.

Experienced in executing activities related to end - to-end project management, including project plans and estimates, scoping and requirements through implementation, Requirement Gathering, Requirement analysis, Application environment Setup, Preparing Test Scripts, Project Status reporting, bug fixing and deployment.

Highly experienced in Data modelling, Entity relationships and Database normalization (up to 3rd normalization form).

Translated business requirements to physical data models, designed data element & created quality sets of metadata to achieve strategic goals.

Strong experience in T-SQL programming proven, scalable code using stored procedures, various types of joins, subqueries, user defined function, analytical functions, aggregate function, cross/outer apply, group by, over partition by, cursors, merge, try/catch, dynamically generated scripts, triggers, common table expressions, scalar/table valued functions, create/alter tables/columns, views, primary/foreign key constraints, and indexes.

Have excellent command writing ad hoc queries utilizing dynamic SQL. Strong Transact-SQL query writing skills (DDL, DML, TCL, DQL and DCL).

Experienced in developing complex store procedures, efficient triggers, required functions, creating indexes and indexed views for performance.

Excellent Experienced in monitoring SQL Server Performance tuning in SQL Server

Expert in designing ETL data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Access/Excel Sheets using SQL Server SSIS.

Experienced in creating jobs, SQL Mail Agent, Alerts and schedule DTS/SSIS Packages.

Experienced in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging.

Experienced in Building Cubes and Dimensions with different Architectures and Data Sources for Business Intelligence and writing MDX Scripting.

Experienced in managing security of SQL Server 2016/2014/2012 databases by creating OLTP database users and roles and assigning proper permissions according to business requirements.

Expert in SQL Server Business Intelligence suite of products like SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and SQL Server Analysis Services (SSAS).

Highly experienced in Dimension modelling using star and snowflake schemas, handling Slowly changing dimension using different techniques like row hash (MD5 and SHA), Slowly changing dimension wizard and Lookup, especially in incremental load of data.

Implemented Full, Incremental and Remigration ETL workflow and data pipelines for Staging, Data mart and Data Warehouse databases.

Experienced in handling late arriving dimension and late arriving facts scenarios in a Data Warehouse.

Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.

Good working knowledge on Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models and Deploying and Processing SSAS objects.

Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.

Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using Drill-down, Drill-through And Cascading reports using SSRS.

Having experience in developing end-to-end Business Intelligence solutions in accordance with Standard OLAP Methodologies using Tableau.

Proficient with SQL Server, BI Stack (SSIS, SSAS, and SSRS), Power BI, and Tableau within large and complex environments. Expertise in Power BI, Power Pivot and Tabular Model, DAX, MDX queries.

Designed and developed ETL SSIS process design, architecting the flow of data from various sources to target.

Experienced in SSIS utilities like Import/Export Wizard, Package ISPAC Installation ISDEPLOYMENT Wizard, and SSIS Package Designer.

Good Knowledge in design and implementation processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Server Reporting Services (SSRS)/Power BI.

Experienced in Agile Methodology.

Working knowledge on data modelling techniques towards building enterprise data warehouse.

Worked on SQL Server Analysis Services (SSAS) including in building cubes and writing MDX queries.

Worked on SQL Server Reporting Services in generating parameterized, linked, drilldown and sub reports.

Intermediate expertise in ASP.NET, C#.NET

Very good communication, analytical, interpersonal, presentation skills and Team skills combined with self-motivation, initiative and the ability to think out of the box and worked as lead to carry out deliverables.

Responsible for the Deliverables, Scheduling, Resource allocation and requirement gathering for the project.

Code Reviews, Client Meetings, and skill development of the team members

Strong Project management experience from various applications. Key activities include Delivery Excellence, Capacity Planning, Team/Resource Management, Project Tracking & Change Management, Risk analysis, Contingency Planning, Project Scheduling & Resource levelling, and Requirement Analysis.

Technical Skills:

Operating System: Windows Server 2008/2012/2026, Windows NT, UNIX, Windows 9/10

Databases: MS SQL Server 2016/2014/2012, Oracle 9i/10g, MS Access

ETL Tools: SQL Server Integration Services SSIS, SQL Server Reporting Services SSRS, SQL Server Analysis Services SSAS.

Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio, Redgate SQL Test, SQL Dependency, SQL Prompt. Bulk Insert and BCP, Export & Import

Languages: Visual Basic 6, VB Script, JavaScript, VB.NET, C, C#, XML, HTML, MDX, and DAX.

Data Modeling: MS Visio, CA ERWIN

Other Tools: TFS (Team Foundation Server), Visual Studio 2013, GitHub, and JIRA (JQL queries)

Professional Experiences:

SQL/ETL Developer MultiCare Auburn Medical Center, Auburn, WA

May 2022 to present

Responsibilities:

Involved in Planning, Defining and Designing database based on business requirements and provided documentation.

Interacted with Business Analyst, Subject Matter Experts and Stakeholders to understand the business needs and documented the complex business requirement into simpler one and automate the process by writing complex scripts and scheduling on the jobs.

Gathered end user requirements, Developed Logical Model, and created physical models. Documented and maintained database system specifications, diagrams, and connectivity charts.

Programmed T-SQL to create database objects such as tables, stored procedures, views, and triggers and to generate reports in SSRS and Power BI.

Developed T-SQL programs to create database, programmed queries, sub-queries, ranking functions, derived tables, common table expressions, stored procedures, views, user defined functions, constrains and database triggers using T-SQL.

Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables.

Gathered information for heavy, slow-running, and poorly performing T-SQL in SQL Sentry Performance advisor to provide a record of all plan changes and optimizing query based on results.

Developed SQL source view scripts for full and incremental loads into production of all the tables.

Implemented standard development process in creating, documenting and deploying ETL packages to Integration Service Server under both Package Deployment Model and Project Deployment Model to load data from homogenous and heterogeneous data sources into data warehouses and data marts.

Involved in Developing and maintaining the ETL packages SSIS Packages to extract the data from various sources and involved in debugging and upgrading of several ETL structures as per the requirements.

Implemented the Master Child Package Model in the EDW and Data-Mart for easier maintenance and better performance of SSIS Packages review.

Worked on Data transfer from a Text file to SQL Server by using bulk insert task in SSIS.

Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries also trimming lengthy queries by replacing sub queries with JOINS to enhance the performance of Databases.

Conduct database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler and SQL Analyzer.

Utilized various Transformations in SSIS Control Flow and Dataflow using for loop Containers and Fuzzy Lookups etc.

Developed SSIS packages, Store Procedures, XML configuration files, tables, views, functions and to implement best practices to maintain optimal performance.

Design packages which utilize tasks and transformations such as Execute SQL Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate and Derived Column.

Involved in migration of large amount of data from OLTP to OLAP by using ETL Packages.

Improved the performance of SSIS packages by enabling Parallelism in the Control and Data Flows, usage of synchronous transformations.

Created shared dimension tables, measures, hierarchies, levels, cubes, and aggregations on MS OLAP/ Analysis Server (SSAS).

Developed a cube using multiple dimensions and modified the relationship between a measure group and a dimension in Dimension Usage tab, created calculated members and KPI’s, using SSAS.

Designed, developed, and deployed OLAP cubes and SSIS packages to process OLAP cubes through source views having dimension and fact tables listed. Utilized XMLA file for deployment of cube.

Programmed MDX queries to retrieve data from the multidimensional cube and to use as source for multiple SSRS reports.

Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.

Scheduling Daily, Weekly and Monthly SSIS package execution process using SQL Server Agent jobs.

Developed SQL Server reports using SSRS and exported them to Excel format for managers and QA team for easy validation.

Responsible for the ad-hoc reporting, modification and regenerating on request.

Building scorecards and dashboards using the Performance Point Services 2010 with BI application.

Schedule the reports to run daily, weekly, and monthly and automatically emailed reports to department directors and analyst to review it.

Actively participated in daily calls with Client and Client Team.

Environment: SQL Server 2016, SSIS, SSRS, Report Builder, SQL Profiler, .Net C#, SSAS, Microsoft Visual studio 2013, OLAP, XML

SQL Developer (SSIS/SSRS) Movement Mortgage, Charlotte, NC

Nov 2021- Apr 2022

Responsibilities:

●Involved in the Requirement Analysis, Design phase and Development phase of agile model system.

●Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.

●Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.

●Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),

●Participated in the analysis of Actuarial Data Mart (ADM), Reference DB according to the user requirements.

●Exported the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users.

●Analyzed the Legacy Data, Import the data into Reference DB that was verified and published by DMRB (Data Management Review Board)

●Involved in Developing, Administering, and Managing corresponding databases: Consolidated Data Store, Reference Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart.

●Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.

●Developed complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, and other database objects as per the business requirements

●Assisted on the Ad hoc-Query Requests based on the requirement by using Joins, Sub Queries and Co-related Sub Queries.

●Developed stored procedures, triggers and functions to account for some automated insertion of records in tables for wholesale lending to different merchant banks Developing Power BI report using Power Apps Entity data and other Databases.

●Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs. Performed Performance Tuning of the Stored Procedures and Experience in trouble shooting database issues.

●Created SSIS packages for ETL flow to validate, extract, transform and load data into database. Involved in performing migration of DTS packages to SSIS packages.

●Developed SSIS packages to Push and Pull data using Rest APIs and other different sources and vendors.

●Used different type of Transformations for Data Conversion, Sorting, and cleaning the data from different sources into Company format.

●Created Package Configurations, Event Handlers for On Error/Warning/Task Events.

●Designed Complex Packages with Error Handling and Package Logging that stores the Logging results in SQL table and flat files.

●Troubleshooted and monitored daily execution and implementing enhancement on existing SSIS packges.

●Maintained the physical reports by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.

●Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS

●Provide support to junior co-workers and work with offshore resources for knowledge share.

●.Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2014.

●Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.

●Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.

●Created and updated data into CRM and providing support.

●Worked on Upgrading and automating manual jobs and scripts into SSIS and scheduled in sql agent.

●Used diffetnt types of files like XML, JSON to load the data into SQL database using ZappySys.

●Developing test strategies, test plans based on functional specifications, use cases, and business requirements

●Documenting and analyzing workflows & use cases, business rules, prototyping, data mapping & data modelling

Environment: Windows Server 2016, MS SQL Server 2014 -SSMS, SSRS, SSIS, SSDT, MySQL, MS Office Suite, MS Excel, ZappySys.

SQL/BI Developer Cotiviti Nepal, Kathmandu, Nepal

Nov 2019 to Oct 2021

Responsibilities:

Involved in the Requirement Analysis, Design phase and Development phase of agile model system.

Closely worked with Business analyst for gathering requirement and Architects. Involved in providing presentation to clients and conducting group meeting with team members.

Involved in design and development of Data Warehouses, Data marts and Business Intelligence reports using multi-dimensional models.

Worked in Agile Scrum Methodology with daily stand-up meetings, great knowledge working with Visual SourceSafe for Visual studio 2010 and tracking the projects using Trello.

Worked extensively on development of T-SQL programs to create Tables, Views, and triggers and stored Procedures.

Developed stored procedures and triggers to facilitate consistent data entry into the database.

Developed complex SQL Queries using multiple joins for Ad hoc reports using Report builder based on the business requirements

Performed maintenance duties like performance tuning and optimization of queries, functions, and stored procedures.

Created and maintained database for Server Inventory, Performance Inventory.

Utilized Datawarehouse for developing Data Mart which for feeding downstream reports, development of User Access Tool using which users can create ad-hoc reports and run queries to analyze data in the proposed Cube.

Developed SSIS ETL packages to extract data from heterogeneous database and sources and then transform and load into the data mart, heterogeneous databases and sources include ORACLE, MS ACCESS, FLAT FILES, Excel Files etc.

Configured and Deployed the SSIS Packages and developed jobs for efficient running of the packages. Also involved in creating SSIS jobs to process the multidimension cube. Earned Expertise in Deploying SSIS Package to Production and used different types of Package configurations to export various package properties to make package environment independent.

Review, resolve and edit data to ensure accuracy and then convert non-Excel files to Excel format, sort, filter, and create pivot tables using Excel.

Data cleaning and data manipulation such as Concatenation, LEN, Find & Replace, Filter & Sort, Conditional Formatting, Index Match, Remove Duplicates, Logic Functions, and Short-Cut functions were done using Microsoft Excel.

Generated Drill through and Drill down reports with Drop down menu option, sorting the data, and defining subtotals in Power BI.

Shared data outside using Snowflake to quickly set up to share data without transferring or developing pipelines.

Used Snowflake to set up an Insights-as-a-Service platform.

Developed different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.

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.

Worked in all environments – Development, Testing, and Production environments.

Environment: SQL Server 2014, Microsoft Business Intelligence Development Studio, T-SQL, SSIS, SSAS, SSRS, Visio, VSS.

Jr. SQL Developer ANS Soft Inc, Kathmandu, Nepal

Nov 2017 to Oct 2019

Responsibilities:

Involved in complete Software Development Lifecycle (SDLC).

Programmed complex SQL Queries, Stored Procedure, Triggers, Views & Indexes using DML, DDL commands and user defined functions to implement the business logic.

Worked as SQL Server Analyst / Developer / DBA using SQL Server.

Developed jobs, SQL Mail Agent, Alerts, and schedule DTS/SSIS Packages.

Manage and update the Erwin models - Logical/Physical Data Modeling for Consolidated Data Store (CDS),

Participated in the analysis of Data Mart, Reference DB according to the user requirements.

Exported the current Data Models into PDF out of Erwin and publish them on to SharePoint for various users.

Analyzed the Legacy Data, Import the data into Reference DB that was verified and published by DMRB (Data Management Review Board)

Involved in Developing, Administering, and Managing corresponding databases: Consolidated Data Store, Reference Database (Source for the Code/Values of the Legacy Source Systems), and Actuarial Data Mart

Programmed Triggers, Stored Procedures, Functions, Coding using Transact-SQL (TSQL), create and maintain Physical Structures.

Utilized Dynamic Management Views, System Views for Indexing and other Performance Problems

Liaison with ETL Team to convert ETL requirements as Standard Database solutions to boost the performance.

Created ETL mappings using Excel, MS Visio and Database Diagram feature in SSMS.

Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server.

Performed Full load & Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.

Developed SSIS package to Export and Import data from SQL Server to Access, Text and Excel files and Configured SQL mail agent for sending automatic mails.

Involved in Source Controlling, environment specific script deployment tracking using TFS

Participated in Day-to-Day maintenance of databases, Staging, Backup / Restores of databases.

Responsible for Deployment of Scripts in different environments according to Configuration Management, Playbook requirements.

Participated in Create / Manage Files/File group – Table/Index association.

Also responsible for below activities during later stage of project,

oQuery Tuning, Performance Tuning.

oDefect tracking and closing by using Quality Center

oMaintain Users / Roles / Permissions.

oCapacity Planning, Disk Requirements

oCreating Range and Hash (by using MOD function) Table Partitioning, Index management

oCreate and maintain Change Log to track the state of the each environment

Environment: SQL Server 2012, C#, Windows Server 2012, VSS, SQL profiler, T-SQL, SQL, SSIS, SSRS, Toad, MS Visio, SQL Test.

Education:

Masters

Bachelors

Contact this candidate