PROFESSIONAL SUMMARY:

• 5+ Years of extensive work experience in Software Development Life Cycle and Software Testing Life Cycle (STLC) principles.
• Proven experience in SQL Server database design & development and data modeling.
• Solid experience and outstanding knowledge in troubleshooting.
• Experience in Database Design and development for both OLTP (Batch Processing, Online Processing); OLAP Systems (SSRS and SSAS) using SSDT.
• Experience in integration of various data sources or basic ETL
• 6+ years of experience in writing T - SQL, Performance tuning, trouble Shooting and identifying and solving concurrency issues to enhance Performance.
• Define Data source and dataset from wide range of Systems in the cloud and on premises to create, report and interactive visualizations that give insight for better decisions.
• Experience working collaboratively using agile software development process.
• Excellent analytical and co-ordination skills and an outstanding team player with an aptitude to learn from and share new skills.
• Self-starter highly motivated, have a very good problem solving and good communication skills.
• Have worked in industries like Utility, Finance, HR, Education, Sales and Health Environmental across a wide variety of systems and companies from small to large size.

TECHNICAL SKILLS:

BI Tools: SQL Server 2016,2014, 2012/ 2008R2/ 2008/ 2005, SSIS (ETL), SSRS, Tableau SSDT, Report Builder 3.0, OBIEE, BIDS, Visual Studio, Power BI DesktopPower Bi Premium, MicroStrategy, Tableau and Excel Power View

Databases: SQL Server (2005, 2008, 2008R2, 2012, 2014), ORACLE, MS Access and Azure SQL Database, Azure SQL Data warehouse, Azure Analysis service database

Language to interact with Data: T-SQL, DAX

Data Access Technology: OLE DB, ODBC, ADO.NET

Programming Languages: C#, VB.Net

Platforms: Windows NT/XP/7/8/10, Windows Server 2000/2003/2008 , SharePoint 2010, Visual Studio .Net 2010/12/13/15

Source Controls: Team Foundation Server (TFS), VSO & GitHub

Clientside Technology: HTML, CSS, JavaScript

Data Modeler: Visio, Erwin

MSOffice: Word, Excel, Access, Power point, Outlook, InfoPath, SharePoint

PROFESSIONAL EXPERIENCE:

Confidential, Redmond, WA

Power BI report Developer

Responsibility:

• Gathering requirements document and identify the metrics and dimensions that helps to build Power BI solution.
• Transforming Data using Power BI Desktop
• Write complex calculated measures using DAX functions, then Data Modelling
• Create different visualization using key metrics and dimensions on the top of the model
• Presenting domo for team and who are working on application and experts registering and embedding power bi contents into apps.
• Discuss on the comment proposed and take the feedback to modify the report.
• Import some visuals when required from visual gallery.
• Publish the report to power Bi Services and sharing on the dashboard.

Technical Environment: SQL Server 2014/2016, (2012/2008R2), Visual studio 2017, MVSC version 1.32.3, git version 2:20.1

Confidential, Bellevue, WA

SQL /MSBI Developer

Responsibilities:

• Contribute in gathering and documenting requirements
• Working with data sources and establish connection string to pull to SSDT / Report builder 3.0.
• Excel or power bi desktop
• Build visualizations based on datasets after proper cleansing, aggregating, merging, modeling.
• Involved in design, development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization and other sources.
• Set up power Bi environment.
• Identify data sources, get data from Various sources such as SQL, SQL DW,SSAS DB, Azure SQL DB, Azure SQL DW, Azure analysis service DB, CSV, other, and transform by cleansing, merging, splitting, aggregating, grouping and maintaining table relationship for majority of the sources.
• Write complex calculated measures for power bi report data visualization using Data Analysis Expression language (DAX).
• Design and Develop multiple analytical reports, apply KPI, and interactive reports that give insight for accurate and best decision.
• Work with users in order to ensure that Power Bi solutions meet business requirements.
• Import some custom visuals when required from gallery.
• Publish the report to power Bi Services and sharing on the dashboard.

Technical Environment: SQL Server 2014/2016, SQL Server 2012/2008R2, SSRS (2012/2008R2), SSIS (2012/2008R2), SSDT 2014, C#, Power BI, Visual studio 2013/15, Excel 2013,16, VSTFS, VSO

Confidential, Mt Vernon, WA

SQL Developer

Responsibilities:

• Configuring and maintaining databases
• Create Data Model using ERWIN by adhering to the client requirement and business process.
• Writing Stored Procedures to evaluate organization, System, Failure Mode and maintenance information from dealers in PACCAR partners.
• Writing Scalar Functions that figure out time taken to solve claims, number of claims and expense to resolve issues in these issues.
• Create triggers to capture auditing actions (DML) in the database in the process of claim disposition.
• Perform import and export data using graphical wizard by maintaining required mapping and filtering.
• Perform troubleshooting and identify and resolve concurrency issues

Technical Environment: SQL Server 2012, SSDT 2014, C#, Visual studio 2013/15, Excel 2013, VSTFS, VSO