PROFESSIONAL SUMMARY:

●Over * years of in-depth experience in database design, development, administration and maintenance of ETL, SQL Server 2014/2012/2008/2008R2 large scale databases.

●Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.

●Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.

●Extensive experience in Microsoft stack of BI solutions - SSRS, SSAS, and SSIS with MS SQL 2016/2014/2012/2008/2005.

●Proficiency in creating different types of Reports such as Crosstab, Drill-down, Summary, Parameterized, Sub reports and formatting them using SSRS.

●Strong Knowledge in Enhancing and Deploying the SSIS Packages from Development Server to Production Server.

●Excellent experience in Designing, Maintaining and tuning various RDBMS like T-SQL & MS SQL Server.

●Tuned the performance of mappings by following Informatica best practices

●Experience in Extraction & Migration of Data from heterogeneous data sources like Excel, MS Access, Oracle, DB2 to MS SQL Server by using Import Export Wizard, DTS SSIS, BCP & Bulk Insert utilities

●Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Data conversion, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.

●Used change data capture (CDC) control task that makes efficient data loading (incremental load after initial loading of data).

●Created SSIS packages using package logging, Breakpoints, Checkpoints and Event handling to fix the errors.

●Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).

●Knowledge in migrating DTS packages, reports and analysis services projects from SQL Server 2000/2008/2012 to SQL Server 2005/2008/2012/2014.

●Highly experienced in database server performance tuning and optimization of Complex SQL queries.

●Launching the report builder for adhoc reports.

●Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance.

●Analyzing and validating Source Data vs Target data using PL/SQL, SQL, and Excel

●Performed DBA tasks using Enterprise Manager and Query Analyzer.

●Accomplished in creating Packages, scheduling Jobs and sending Alerts using SQL Mail.

●Experience on publishing Power BI reports of dashboards in Power BI server and Scheduling the dataset to refresh for upcoming data in power BI server.

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

●Extensive experience in Capacity Planning, Disaster Recovery, Troubleshooting, Backup and Restore procedures.

●Worked closely with development and Technical Support team to resolve quality issues.

●An excellent team player& technically strong person who has capability to work with business users, project managers, team leads and architects, thus maintaining healthy environment in the project

PROFESSIONAL EXPERIENCE

United States Postal Services, Merrifield, VA 06/2018—Present

Database Developer

●Created SSIS packages to migrate data from different data sources to data warehouse.

●Successfully extracted transformed and load data into data warehouse.

●Created packages by testing and cleaning the Standardized Data by using tools in Data Flow Transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split and more) for existing/new packages and huge CSV file import from different data sources and other ongoing tasks for mapping.

●Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer.

●Scheduled SSIS packages for running monthly and weekly feeds from various guarantors and multiple servers and resources.

●Extensive SQL Programming to analyze and validate Source Data vs Target data.

●Conducted test case peer reviews to ensure test cases accurately capture functionality identified in user acceptance criteria

●Created test data using existing Enrollment and Claims applications

●Generated Excel output of Data Validation results with Expected and Actual results

●Involved in enhancing and deploying the SSIS Packages from development server to production server.

●Designed, deployed, and maintained of various SSRS Reports in SQL Server 2016.

●Wrote Parameterized Queries for generating Tabular reports and Sub reports using Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS 2012.

●Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2012.

●Developed complex reports using multiple data providers, user defined objects, aggregate aware objects, charts, and synchronized queries.

●Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2012.

●Responsible for the Performance tuning of the SQL Commands with the use of the SQL Profiler and Database Engine Tuning Wizard

●Installed and Configured SQL Server Active/Active and Active/Passive clusters. Monitored Scheduled jobs and alerts.

● Performed database transfers and queries tune-up, integrity verification, data cleansing, analysis and interpretation.

●Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.

Environment: Informatica Power Center 8.6, SQL Server 2016, SQL Server BI Development Studio (BIDS) 2012/14, SQL Lite Speed, Visual SourceSafe, T-SQL, Autosys, MS Access, Windows XP/2007 Server.

Client: VABC, Alexandria, VA 06/2017- 06/2018

BI Developer

●Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.

●Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.

●Responsible for performance tuning, optimizing the queries, removing redundant and inconsistent data, joins from the database tables and normalizing them.

●Developed stored procedures to transform the data from enterprise data warehouse to data mart to build dimensions and load data to fact tables.

●Used Execution Plan and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

●Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.

●Tuning Queries and Database performance using tools Database Tuning Advisor, SQL Server Profiler.

●Created SSIS Packages using Lookup, Merge, Sort, Derived Columns, Condition Split, Aggregate, Execute SQL Task, and Data Flow Task, Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel, Text file, XML file to different data Marts.

●Made use of SQL joins, sub queries, tracing and performance tuning for better running of DTS packages.

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

●Made Master Child package using variables and Execute package task in SSIS.

●Performed the physical database analysis and feasibility requirements. This involves the performance, security, archival, maintenance, and recovery requirements

●Wrote VB.NET code for Script task to perform functions that are not available in the built-in tasks and transformations that SSIS provides.

●Deployed, Tested and Scheduled SSIS packages.

●Extracted data from heterogeneous sources and transferred to OLAP using SSIS 2012.

●Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task, send mail task, active script task, xml task and various transformations

●Integrated SSIS packages with the windows batch to trigger the package.

● Developed rich data analytics pipeline in Cosmos, that correlated multiple data points from devices and provided a collective aggregated view of device information.

Environment: Informatica Power Center 8.6SQL Server 2005/2008/ R2/2012/2014, BIDS, Visual Studio 2010/2013, T-SQL, Autosys, MS Access, MS- Excel, SSIS, SSRS, SSAS, Windows Server 2008R2, TFS.

Client: ANAHCAR System, Baltimore, MD 05/2016—06/2017

SQL BI/ETL Developer

●Interact with Business Analysts and Developers in identifying the requirements, designing strategies and to implement a reusable Database Schema.

●Develop and maintain stored procedures, functions, views, triggers, SSIS packages, SQL Server Agent jobs.

●Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.

●Tuned the performance of mappings by following Informatica best practices

●Experienced in slowly changing dimension in SSIS packages.

●Performed incremental data load packages in SSIS.

●Developed, monitored and deployed SSIS packages.

●Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.

●Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.

●Responsible for fine tuning of the database, troubleshooting, memory management.

●Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)

●Created reports based on database usage and perform capacity planning.

●Optimized stored procedures and indexed query using Index Tuning Wizard.

●Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.

●Identified and Defined Fact relationships in SSAS.

●Responsible for debugging applications using the tools provided by the Visual Studio 2008.

●Created OLAP models based on dimension and facts for efficient loads of data based on star and snowflake schema structures.

●Provided technical assistance for all phases and support service of .NET projects.

●Published reports to Azure based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps)

●Created customized reports using various chart types like, text tables, bar, pie, tree maps, heat maps, line charts, pivot tables, combination charts in excel and Tableau

●Developed Informatica Mappings/Workflows to refresh data from SQL Server Database into Teradata.

●Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.

Environment: Informatica Power Center 8.6 MS SQL Server 2008 R2, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Visual Studio 2008

Client: Lumbini Bank, Narayanghat, Nepal 02/2014—03/2016

Role: SQL Server DWH/BI Developer/Data analyst

●Involved in Agile methodology by analyzing business requirements and understanding the functional workflow of information from source systems to destination systems, completed work through Sprints.

●Interacted with Development Teams and Managers to analyze business needs and developed technical specifications.

●Interacted with Business team to collect data for the conceptual design of the system.

●Coordinated with business users to understand business needs and expectations.

Involved in requirement gathering, feasibility studies and organizing the software requirements.

●Involved in analysis and review of software and business requirement documents.

●Involved in defining the source to target data mappings, business rules and data definitions that are used as source by ETL developers.

●Created data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and validating them with data present in Source systems.

●Revisiting created Data Mapping documents in case of any Mappings or Transformation logic changes.

●Helped Data Architect by providing the artifacts that are needed to consider while designing the EDW.

●Conducted sessions and worked alongside with the Business analysts to create technical specifications and mappings for Business Data Glossary and reports.

●Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.

●Generating Corporate Reports for Management Committee using SQL Server Reporting Services (SSRS) and Excel.

●Created tables using T-SQL queries to store the data and also creating database objects like functions, stored procedure, Clustered and Non-clustered Indexes using MS SQL Server.

●Experience in Data Analysis and Data Profiling using SQL and Excel on large volume of data sets like Teradata, Oracle, Flat files, SQL Server.

●Experience in creating data profiling reports with valid values, data quality, Null ratio, Column Value Distribution, Column Statistics etc. and comparing them with source Data Profiling Results.

Environment: SQL Server 2008, T-SQL, SQL Server Management Studio, Visio, Excel Reports, Outlook, Service Center

TOOLS AND TECHNOLOGY

RDMS: SQL Server 2005/ 2008/2008R2/ 2012/2014/2016, DB2, Oracle 9i/8i

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS).

Reporting Tools: SQL Server Reporting Services, MS Excel, Crystal Reports, Power BI, Power BI.

Programming Languages :T-SQL, PL-SQL, C#

Web Technologies : HTML, DHTML, XML, XSL, Java Script (Validation), CSS

Operating Systems :Windows Server 2012/2008, Windows XP, Windows Vista

Other Tools :MS Office Suite (Microsoft Word, Power Point, MS Visio), OLAP & OLTP, Adobe Photoshop, Abode Flash, Microsoft .NET, Team Foundation Server, Visual Studio 2008.

Methodologies: AGILE, SCRUM, Waterfall

EDUCATION

●Master’s Degree in Business Administration from Purbanchal University (2015)

VISA TYPE

●Permanent Resident

Contact this candidate