Data Sql Server

Highlights of Skills

More than * years of experience on data analysis, creating and managing databases and preparing reports.

Experience in Microsoft data management technologies such as SQL Server 2016/2014/2012 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Experience in writing Ad-hoc query and Scheduled reports like table, matrix, drill down, drill thorough, parameterized, cascaded and sub-reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2016/2014/ 2012 (SSRS). Designed and implemented Parameterized and cascading parameterized reports.

Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for reports.

Experience in designing and developing the SQL Server Integration Services –SSIS packages with different control flow tasks and data flow transformations, and deploying the packages.

Understanding of relational database design principles, dimensional modeling, and other data management concepts.

Ability to write sub queries, triggers, Stored Procedure in SQL. Experience executing SQL in Oracle to perform extraction, analyzing, reporting, and loading of records, experience using Unix/Linux command line interface.

Report writing skill using Crystal Reports. Advanced user of MS Excel (lookup, pivot tables, combining databases, etc), MS Access (building queries, merging databases, etc.) and MS Word.

Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.

Ability to extract and analyze large and small datasets, test hypotheses using statistical programs SPSS, SAS and Stata, and effectively analyze regression results.

Experience working in an Agile/Scrum environment.

Education

Master of Science (MS) in Economics and Finance: Southern Illinois University Edwardsville, (SIUE), Edwardsville, IL, December 2008

Bachelor of Science (BS) in Computer Application: Kathmandu Campus, Purbanchal University, Kathmandu, Nepal, 2005

Experience

Business Analyst, DXC Technology, Tyson, VA October 2018 - Present

(Formerly - Report Analyst, Molina Healthcare Inc., Herndon, VA March 2014 – Oct 2018)

Worked with Business Analysts to understand the requirements.

Responsible for creating datasets using T-SQL, stored procedures and other DB objects.

Actively involved in developing Complex SSRS Reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs.

Generated custom and parameterized reports using SSRS.

Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data,normalized tables, established joins and created indexes whenever necessary.

Created standard and data driven report subscriptions as required.

Configuration and Deployment of all reports (RDL, RDS) across various SDLC environments.

Maintain version of reports and database objects in Team Foundation Server (TFS) and update Technical design specification documents of each reports.

Worked with UC4 team for scheduling of reports by providing runbook of reports.

Involved in creating ETL packages for loading data files into table from heterogeneous data sources and also involved in writing test script.

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

Created Packages on SSIS by using different transformations like derived columns, lookup, conditional split, merge join, sort, execute SQL task and other transformation tools as needed to load data into database. Also created event handler for the packages using Event Handler Tab.

Checked records for errors using error trapping techniques, used framework error log to store error logs and error codes related to interface.

Involved in creating dashboard using SSAS and Power BI Desktop.

Developed power BI reports and dashboards from multiple data sources using data blending.

Generated ad-hoc reports in excel using power pivot and shared them using Power BI to decision makes for strategic planning.

Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs along with slicers and dicers enabling end user to make filters.

Research Specialist, Mental Health Department, County of Riverside, CA Feb 2013 – March 2014

Developed various reports using SSRS, Crystal Reports XI. Create various complex reports using Crystal Reports XI R2. Enhance/modify existing reports by creating new Parameters, Formulas, including sub report/s, Expressions etc

Wrote queries to generate reports for analysis of data using SQL Server Reporting Services, Report Builder.

Designed and created reports in multiple formats such as Excel, PDF and CSV using SQL Server 2008 Reporting Services (SSRS).

Created large enterprise reports, sub reports using charts, report parameters, dropdowns and images using SSRS 2008.

Generated Reports using Variables, Expressions and Functions for the reports.

Identified and worked with Parameters for parameterized reports.

Performed program and project evaluations using advanced statistical methods, including basic process, impact and cost benefit analysis. Use SPSS extensively for statistical data analysis

Conducted project studies which involve design and application of appropriate research and survey methods to solve problems and draw conclusions

Collected and analyzed baseline and administrative data, perform random assignment of study subjects, and periodically post reports to the intranet.

Prepared narrative reports of findings with valid conclusions, projects program impacts, and predicts trends.

Inventory Planner/Analyst, SEARS Holdings, CA May 2011 – Feb 2013

Used Microsoft data management technologies such as SQL Server 2012/2008 R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS).

Designed and implemented Parameterized and cascading parameterized reports using SSRS.

Scheduled Reports to run the reports Hourly, Daily, Monthly According to end user requirements

Involved in report creation using SQL Server Reporting Services (SSRS),Crystal Reports and Excel spreadsheet as per the client Requirement and for the periodic analysis.

Wrote sub queries, triggers, Stored Procedure in SQL. Executed SQL in Oracle to perform extraction, analyzing, reporting, and loading of records, experience using Unix/Linux command line interface.

Scheduled the Reports to run on daily and weekly basis in Report Manager and also email them to director and analysts to review in Excel Sheet.

Gathered analytical/reporting requirements, translated the requirements into BI solutions and design and developed reports and dashboards to meet the requirements.

Responded to customer requests for ad-hoc reporting, including developing custom reports and queries as needed and assisting Data Analysts with their reporting efforts.

Organized and utilized raw data to identify business trends and to support decision-making using spreadsheet and database applications.

Reviewed and analyzed the effectiveness and efficiency of existing systems and developed strategies for improving or further leveraging these systems and supply chain.

Prepared and analyzed yearly and monthly demand and made decision based on that report.

Operation Analyst, University of California Davis-Office of University Registrar May 2009 - Feb 2010

Provided analytical support by performing problem research, extraction and analysis of data using query in SQL.

Worked with Academic Support Unit (ASU) and Technical Unit to understand and communicate the business and technical needs in order to make the system more efficient and up-to-date.

Worked in Unix/Linux command line interface to perform different kinds of operational jobs and to extract data, generate different reports

Involved in testing of new/upgraded programs before moving them to production and communicate the errors to the Technical Unit.

Involved in documentation of system operations, instructions and procedures.

Performed uploading of fees on test database environment, verifying accuracy of the interrelationships of various codes prior to uploading into Banner production database.

Business Analyst, Golden Gate College, Nepal. Apr 2005 -Dec 2006

Interacted with project stakeholders to elicit, analyze and document project requirements.

Gathered and documented client requirements, business needs and project objectives, via feedback sessions and client meetings.

Served as a critical resource and liaison between subject matter experts and technologists throughout the project lifecycle.

Wrote Ad-Hoc queries and Stored Procedures using SQL.

Developed a database, created tables and ran queries to test the functionality

Reported bugs and interacted with the software development team to resolve issues.

Graduate Courses

Statistical Analysis for Business Decisions, Quantitative Methods for Economics & Business Analysis, Econometrics, Empirical research methods, Financial Accounting, Corporate Finance Analysis/Strategy, Financial strategy, management and control

Undergraduate Courses

Database Management System, Numerical Methods and Computation, Operation Research, Hardware and System Installation, System Analysis and Design, E-Commerce, Web Technology, Script Programming

Software Skills

Knowledge of MS SQL Server, MSBI (SSIS, SSAS, SSRS),VS2014/2012/2008, MDX queries, Power BI Desktop,Tableau, Basics of AWS and Python, Oracle, PL/SQL, Crystal Reports, XML, HTML, VB.NET, Drupal, Dream weaver, FrontPage, Photoshop, Flash, Java Script, Visio

Knowledge of Statistical Tool – SPSS, Stata, E-Views, SAS

References: Available upon request

Contact this candidate