Mail Agent Business Analyst

Asmita Parajuli

Email: *****************@*****.***

Contact: 216-***-****

Location: Cleveland, OH 44120 Green Card Holder

SUMMARY

Having more than 5 years of IT experience in Database Development, Administration, Data Analysis, and Mapping, System Analysis, Design, Development and Support of MS SQL Server 2016,2014,2012, in Production, Testing and Development

Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.

Extensive experience in interacting with business users, gathering requirements, data analysis, data mapping, gap analysis and documentation.

Experience in coordinating with users in gathering source data files, defining data elements, business rules, data, and process flow documentation, prepare High level and Low-level design documents.

Proficient in design and development of Relational Database Management Systems, with strong experience on Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers and Cursors.

Proficient in Data Modeling up to 3rd Normalization form and Dimensional Modeling using Star and Snowflake schemas.

Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.

Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.

Experience in creating and managing fragmentation of Indexes to achieve better query performance. Experience in Performance Tuning and Query Optimization.

Experience in Database Backup, Recovery and Disaster Recovery procedures.

Hands on experience in configuring TEMP DB with considerable MEMORY and RAID LEVELS for better performance.

Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace File and 3rd party tools.

Strongly experienced on development, implementation, administration, and support of ETL workflows and processes for large-scale Data Warehouses using SQL Server SSIS.

Expert in developing ETL workflow using SSIS packages- implemented Full, Incremental and Remigration workflows.

Experience in Error and Event Handling: Precedence Constraints, Break Points, Check Points, Logging, Archive data files from different legacy systems using on SQL Server 2016,2014,2012 environment, and deploy the data, Scheduled the jobs to execute these tasks periodically.

Extracted, transformed, and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.

Extensively worked on Creating, Populating, and maintaining Data marts. Thorough knowledge of Features, Structure, Attributes, Hierarchies, Star and Snowflake Schemas of Data Marts.

Good working Knowledge with Facts, Dimensions, Measure Groups, Calculated Members, Hierarchies and Cube Partitions in Multi-Dimensional Cubes. Also developed Cube deployment strategy through XMLA file, Processing through SSIS package and SQL Agent Job.

Intelligence delivery using Microsoft SQL Server Analysis Services (SSAS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).

Extensive experience on delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.

Hands-on in development of Drill down Reports in SSRS and Generated daily, weekly and monthly reports for the manager.

Developed Sub Reports, Matrix Reports, and Charts using SQL Server Reporting Services (SSRS).

Developed and maintaining Cascading, Drill-down, Drill-through, dashboards and parameterized Reports using SSRS. Managed security by defining roles and rights.

Worked on administration tasks such as data loading, batch jobs, data unloading, backup & recovery, user and application table management, upgrades, creating databases / file groups/files/transaction logs.

Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services SSRS in Business intelligence development studios BIDS .

Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.

Good Knowledge of Web development technologies such as HTML, XML, DHTML and Visual Studio 2008/2010.

Highly organized with the ability to manage multiple projects and meet deadlines.

A team player with excellent interpersonal, communication and presentation skills.

TECHNICAL SKILLS:

Languages - C, C++, SQL, T/SQL, HTML, XML, VB.net, ASP.net, MDX, and DAX.

RDBMS - SQL Server 2016/2014/2012, MS-Access, MDM (Master Data Management), MDS (Master Data Services)

Operating Systems - Windows 2012/2012R2/2016 server, UNIX, Linux, Sun Solaris, Windows NT, Windows XP, Vista, Windows 7

Reporting Tools - SQL Server Reporting Services

Analytic Tools – SQL Server Analysis Services (Multidimensional and Tabular)

Other Tools - MS SQL Server Management studio, MS Visual Studio, MS Visio, Team Foundation Server (TFS),SQL Server Profiler, SQL Server Index Tuning Wizard

PROFESSIONAL EXPERIENCES

SQL SSIS/SSRS Developer (Jan 2021- Present)

Client: Care Alliance

Location: Cleveland, OH

Responsibilities:

Involved in complete life cycle of application and processes including design, development, and testing.

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 the jobs.

Good exposure in creating and managing conceptual, physical, and logical data models.

Prepared data mapping and sourcing documents for various sources to NPS New App.

Involved in designing and implementing relational database RDBMS model as per business needs.

Responsible for developing, support and maintenance for the ETL Extract, Transform and Load processes using SQL Server integration services.

Developed and created the new database objects including tables, views, index, stored procedures and functions, Advanced queries and updated statistics using Query Analyzer and Enterprise Manager on the existing servers.

Defined check constraints, rules, indexes, and views based on business requirement.

Programmed User Defined Stored Procedures, Views, User Define Functions and Complex Queries as per complex business scenarios and rules.

Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created Clustered/Non-Clustered indexes wherever necessary.

Created Temporary Table and Common Table Expression (CTE) for query Optimization.

Utilized tools like SQL Profiler, index tuning wizard, windows performance monitor for monitoring and tuning MS SQL Server performance.

Monitored data activities i.e., database status, logs, space utilization, extents, checkpoints, locks, and long transactions.

Developed and maintained scripts, utility jobs or implement needed software for database maintenance.

Extracted data from IMS/DB2, MS Access, SQL Server 2005/2008 for migration and performing various transformations in SSIS ETL per business rules.

Applied various types of Control Flow tasks and Data Flow tasks like For Each Container, execute SQL task, Script task, Transfer for Loop Container, Aggregate, Derived column and Transfer Database Task according to need of Data Transform and Data Cleansing and insert new data into Database using SSIS packages

Migrated XML data files, Flat files into SQL Server staging database. Imported the huge text files, CSV files data from FTP through SSIS to local environment.

Used SSIS script task using vb.net and C# Script to create XML File and Flat File. Utilized ADO.net to connect SQL Server with application.

Worked with SSIS to load data files to SQL Server and the other way. Maintaining the data, database Backups and Restoration, backup strategies, scheduling backups.

Designed and developed Data warehouse environment for OLAP & Data mining in SSAS

Extensively involved in the SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL

Developed Batch File, checkpoint file and Logging file for Data Integrity.

Developed Tablix Reports, Matrix Reports, Parameterized Reports, Sub reports using SQL Server Reporting Services (SSRS).

Designed and maintained variety of SSRS reports such as Parameterized, Drilldown, Ad hoc and Sub-reports using Report

Configured Integration services and Reporting services for developing new environment for NPS systems New Application.

Converted existing DTS packages to SSIS ETL and tune the connections pointing towards new applications.

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

Experience in configuration of report server and report manager scheduling, give permission to different level of users in SQL server reporting services SSRS.

Performs System testing for all the modules and helps business in User Acceptance Testing.

Experience in generating on-demand and scheduled reports for business analysis or management decision using SQL server reporting services.

Environments: MS SQL Server 2016, SQL server integration services, SQL Server Analysis Services, SQL Server Reporting Services, TFS, Microsoft Visual Studio 2019, SQL Server Management Studio, MS Excel, T-SQL, DB2 Mainframe, MS Access, Erwin 9.0, Report Builder 2.0/3.0, Windows Server 2016

MS SQL/BI Developer (Feb 2019- Dec 2020)

Client: Epicor Software Corporation

Location: Louisville, KY

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.

Modified the existing ERD's to insert more tables, columns and constraints using MS Visio 2008 for more refined data models.

Worked in Active passive cluster environment. Used log shipping for synchronization of databases. Update statistics, database integrity check and Backup operations

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

Wrote and debugged Stored Procedures and DDL /DML Triggers, Functions as per client requirements.

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.

Implemented and maintained Database mirroring as a Disaster Recovery Solution.

Used SSIS and T-SQL stored procedures to migrate data from various Claims processing (Mainframe), providers (Oracle), and Members (Access) databases to staging area and finally transfer into data warehouse.

Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.

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.

Fine-tuned various packages for reducing their processing time by using parallel processing approach and using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server.

Developed, monitored, and deployed SSIS packages and user Defined Functions for giving Scores and views for the application. Generated reports from SSRS and SSAS.

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

Migrating databases from legacy system to SQL server and involving in rewrite codes and validate after migration.

Developed T-SQL for maintaining, developing and creating database and fine tune Stored Procedures and Queries to improve performance of system.

Proficient in creating and tuning database, developing views and having good exposure of C and .NET Framework.

Created 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.

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

Responsible for creating reports based on the requirements using SSRS.

Responsible for creating parameterized and drill down reports based on the requirements using SSRS.

Used TFS to store, run, view, edit and revert to different versions of the design in case of a system crash.

Environments: MS SQL Server 2014, SQL server integration services, SQL server Reporting Services, TFS, .NET Framework, Microsoft Visual Studio 2013, SQL Server Management Studio, MS Excel, T-SQL, SCCM 2007 Console, SQL Sentry Power Suite Performance Advisor for SQL, Report Builder 2.0/3.0, Windows Server 2012 R2.

Jr. SQL Developer (Mar 2017- Jan 2019)

Client: PNC Bank

Location: Louisville, KY

Responsibilities:

Interact with clients to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.

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

Responsible for creating schema objects like tables, views, and indexes.

Programmed stored procedures to be used by front end report development.

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.

Involved development of automating Control flow, Data flow, Events and Logging programmatically using Microsoft .NET framework for SSIS packages.

Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse.

Used various SSIS task such as conditional split, derived column, lookup which were used for data scrubbing, data validation checks during staging, before loading the data into the data warehouse.

Created SQL server configurations for SSIS packages and experienced in creating jobs, alerts, and SQL mail agent and schedule SSIS packages.

Developed and maintained ETL packages to extract the data from various sources and Responsible for debugging and upgrading of several ETL structures as per the requirements.

Worked various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file System task, ftp task, send mail task, active script task, Message Queue Task, XML task.

Worked as a team for defining measures and dimensions by creating cubes in SSAS and Responsible for developed MDX queries for faster retrieval historical data from cubes.

Responsible for creating reports based on the requirements using SSRS 2008 and Defined the report layout and identified datasets for the report generation.

Design and created financial report templates, bar graphs and pie charts based on the financial data. Scheduled the monthly /weekly/daily reports to run automatically.

Developed different types of reports including financial reports, cross-tab, conditional, drill-down, sub reports also parameterized reports, ad hoc reports for existing databases.

Worked with DBAs, QA and systems support personnel in elevating and automating successful code to production.

Used TFS for version control.

Created documentation as required for operational support.

Environments: MS SQL Server 2012, SQL server Integration Services, SQL Server Reporting Services, VSS visual source safe, .NET Framework, ASP 3.0, Microsoft Visual Studio 2013, SQL Server Management Studio, MS Excel, T-SQL,ERWIN, Windows Server 2012.

Education: Bachelor’s Degree

Contact this candidate