Pabitra Phuyal

SQL and BI Developer: Visualization/Data Management

advavi@r.postjobfree.com

402-***-****

With more than seven years of experience, Proficient in gathering requirements, analyzing, consolidating, creating documentation, Planning, implementing, coding from scratch, testing, and creating report or visualization with meaning full format.

Experienced in generating reports or visualization by using SSRS, Power BI and Tableau.

Developed many complex parameterized custom reports and visualizations.

Used tableau and Power BI to create visualization for health care, education institution, and financial institution.

Experienced in developing SSIS packages for data migration between different heterogeneous sources such as flat file, excel, Oracle, DB2, MS access using SQL Server SSIS R2008/2012/2014/2016/2017/2018.

Experienced in Creating, testing, and updating the existing ETL packages.

Experienced in updating and using Star schema and Snowflake data warehouse.

Proficient in Relational Database Management Systems (RDBMS) with Conceptual, Logical and Physical data models.

Created databases, tables, views, Stored procedures on SQL server management studio.

Worked as good team player as well as worked independently on assignments. Provides guidance and tips on advanced issues. Understands performance, tuning and troubleshooting issues.

Always focused data accuracy, by checking data sources, did unit testing, tested all the functions that has been applied, checked any assumption has been applied besides the primary requirements.

Collaborated with users to validate the data in the transactional database.

Expert in using Team foundation server.

Experienced in Agile Software Development Methodologies.

Knowledge of Azure Data Lake, and Teradata.

Excellent written and verbal communication skills.

Strong analytical, problem solving and decision-making skill and always curious to learn new environment with new tools.

Work Experience

System Analyst and SQL Developer

Omaha Public School

Feb 2020 – Present

Omaha Public school is one of the top school districts in the state. There are several Special education services than any other schools in the district.

Gathered and analyzed business requirements into a meaningful requirement documentation.

Have been writing and executing complex queries, interpreting results, and communicating non-technical Users.

Participated in designing logic and reviewed, provided logic for query optimization, and have been doing troubleshooting.

Written SQL queries from scratch and have built more than 50 custom reports including budget and special education services.

Deployed reports to the report server.

Responsible for training and mentoring junior developers.

Experienced in generating reports by using views, Stored procedures, and embedded SQL code.

Created and managed visualizations and analytics reports that turn data into knowledge

Created tables, Views, and stored procedures with comments on the code.

Partner with leadership and subject matter experts to determine project requirements

Have been doing unit testing, QC and peer reviewing the code written by the other developer in the team.

Always focused data accuracy, by checking data sources, function that has been applied, any assumption has been applied besides the primary requirements.

Environment: SSIS, SSRS, Tableau, SQL Server Management Studio, Microsoft SQL Server, Microsoft Office, MS Excel, TFS, and SharePoint.

MS SQL/SSIS Developer

MITS - Omaha, NE

April 2017 to Jan 2020

MITS delivers were a networking services along with Applications services, Infrastructure services, and Business Process Outsourcing (BPO) services. MITS provides integrated communication platform to connect its clients with their customers and conferencing services with a combination of technology know how, domain and process expertise. MITS clients are Banking & Capital Markets, Insurance, Manufacturing, and Healthcare.

Responsibilities:

Created database Tables, Sequences, Views, Procedure, Cursors and Triggers for database development.

Used all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.)

Extensively used advanced features like Object types, Collections and Dynamic SQL.

Analyze, design, Develop, implement and tune SSIS 2014 /SSIS 2016 packages to perform the ETL process.

Responsible for understanding the complex SSIS packages and make understandable to the team.

Strong understanding of data driven business decisions using mapping document and implement in SSIS ETL process.

Used Tableau to customize interactive reports and dashboards with customized parameters.

Involved in Designing, Developing and Testing of the ETL (Extract, Transformation and Load) strategy to populate the data from various sources.

Design ETL packages dealing with different data sources (SQL Server, Flat Files) and loaded the data into target data warehouse by performing different kinds of transformations by using SQL Server

Integration Services (SSIS) used SSIS tester automated tool to test packages, tasks, and precedence constraints.

Created SSRS reports such as tabular, matrix, charts, dashboard, and sub-reports using SSRS 2008R2.

Created stored procedures, Triggers, User-defined Functions, Views for both Online and Batch requests handling business logic and functionality of various modules.

Participated in daily SCRUM meetings and gave the daily status of testing.

Developed data visualizations and dashboards using Power BI and Tableau.

Environment: SSIS, SSRS, SSAS, SQL Server Management Studio, Microsoft SQL Server, Microsoft Office, Tableau, Windows Server, MS Excel, MS Access, Power BI (Power Pivot, Power View using Excel and SharePoint), SRUM Master and Agile methodology.

Jr. SSIS Developer

Alzheimer Association - Omaha, NE

March 2016 to March 2017

Alzheimer is a big non- profit American volunteer health organization. Alzheimer's Association helps with care, support, and research to Alzheimer's patients. Alzheimer is non-curable diseases, and Alzheimer's Association has International Research funds for the investigation to identify new treatment strategies. Alzheimer's Association been pulling data from all over the world for the better investigation and research.

Roles &Responsibilities:

• Conducted database administration, execution estimation and execution tuning for new databases and existing databases by utilizing SQL Profiler, Data Engine Tuning Advisor.

• Developed complex projects in T- SQL, composing Stored Procedures, Triggers and Queries with best execution design.

• Generated occasional reports in view of the factual investigation of the information utilizing SQL Server Reporting Services (SSRS)

• Developed large number of standard and customized reports using SSRS for data feeds and for Reports on server.

• Performed backup/restore, database objects such as tables, procedures, triggers, constraints, indexes, and views.

• Created reports utilizing SSRS, Excel services, Power BI and deployed them on SharePoint Server as per business requirements.

• Used the SSIS Import/Export, relocated the Heterogeneous Database, for example, Oracle and Access database, level documents to SQL server 2008.

• Configured SQL mail operator for sending programmed messages when a SSIS bundle is fizzled or succeed.

• Created questions for creating drill down reports in SSRS 2008. Organized the reports utilizing the Global factors, articulations, and Functions.

• Created Linked Servers to associate OLE DB information sources and suppliers.

• Designed different reports utilizing diverse detailing highlights, for example, amass by and penetrate through and so on.

• Created the Data source connections, Data Source Views, Relationships, Named Query for

customized analysis in SSAS.

Environment: Microsoft SQL Server, Power BI, SSRS, Excel, MSBI tools, MS Excel, MS Access.

Education

MS in Computer Information Systems in Database

Bellevue University - Bellevue, NE – Almost Done.

BS in Computer Information Systems

Bellevue University - Bellevue, NE

March 2017

Associate of Applied Science in Management Information Systems

Metropolitan Community College - Omaha, NE

March 2015

Studied:

Programming languages

Java Script, ASP.NET (CSS, HTML), JAVA, C, C#, C++, Web Scripting, VB.NET, SQL.

Operating Systems

MS-DOS, Microsoft Windows platforms.

Database

SQL Server 2014/2012/2010/2008, MS Access, Oracle, MySQL

Tools

Microsoft Business Intelligence Services (SSIS, SSRS, SSAS), Power Center Informatica, PowerBI, and Tableau.

Training

Scrum Master, Tableau by Aim institute Omaha, MSBI training from Intellipaat, Oracle 12 c Admin training from Net com learning Omaha NE.

Skills

• Ms access

• Sql server

• Business intelligence Tool

Microsoft Business Intelligence tool (SSIS, and SSRS).

Power BI

Tableau

COLLEGIATE ACTIVITIES

Volunteer Contributor: Alzheimer’s association, Omaha Public Library.

Member: Omaha Agile Development Meetup Group (Member and Presenter) https://www.meetup.com/Omaha-Agile-Development/photos/26525339/443803757/

Member: Power BI group Omaha https://www.meetup.com/Omaha-Power-BI-User-Group

Contact this candidate