SUMMARY

• Over 5+ years of strong experience MS SQL Server 2012/20014/2016 , SSIS (SQL Server Integration Service), SSAS (SQL Server Analysis Service with tabular model).
• Strong experience in SQL database design & development, architecture, data modeling (conceptual, logical, and physical) using SQL server enterprise manager.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling, reporting tools (SSIS, SSRS, SSAS, Power BI and tableau).
• In - depth understanding of database management systems, online analytical processing (OLAP) and ETL (Extract, transform, load) framework.
• Strong background in developing reports from complex financial data mart and cubes using SharePoint, MDX queries, power BI and tableau.
• Proficient in business scope definition, cost/benefit analysis, conceptual design analysis.
• Proficient in data analysis at levels of inspecting, cleansing, transforming, and modeling data for decision making and business forecasting
• Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
• Efficient in upgrade and migration from SQL Server 2012/2014 to SQL Server 2016.
• Ability and willingness to learn new technology and deliver results in a timely manner.

TECHNICAL SKILLS

Data Warehouse Tools: MS SQL Server 2012/2014/2016 Analysis Services, Data Mining Tools, Integration Services

Business Intelligence Tools: SQL Server 2012/20014/2016 Business Intelligence Development Studio, (BIDS)

MS Data ToolsLanguages: T-SQL, C#, ASP.NET, XML, HTML, XHTML, CSS, JavaScript, MVC, PHP, Python

Reporting Tools: MS-Access, SQL Server 2012/20014/2016 Reporting Services, MS-Excel 2010/2013, Power BI, Tableau

Development Environment: Visual Studio.Net 2013/12/10, TFS

Data Modeling Tools: Microsoft Visio 2010/2013

Operating Systems: Windows/ 10/ 8/7, Mac

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

BI Analyst

Responsibilities:

• extensive experience is using DAX for formula creation, data set ingestion and transformation, dashboard creation, and the ability to build out tool integration .
• Developing models, dashboards, and reports for customers . making DAX queries in Power BI desktop.
• Data preparation, data gateway, data warehousing, and validation
• Worked with Microsoft Business Intelligence Stack having Power BI, SSAS, SSRS, SSIS.
• Experienced with agile processes and methodologies
• Identifying and gathering business requirements & business concepts
• Utilize strong Microsoft Excel, SQL and other programming language skills to provide high-quality data analysis and support to clients, internal stakeholders and select media outlets
• Worked closely with research analysts to identify unique data points to support research, while also identifying unique tables and graphs to clearly illustrate that information
• Managing and completing time-sensitive custom research requests for subscribing clients.
• Contributing to and provide data support to broader editorial teams as they develop content for blog posts, data-graphics, and newsletter stories
• Develop and implement databases, data collection systems, data analytic and other strategies that optimize statistical efficiency and quality.

Confidential, Seattle, WA

BI developer

Responsibilities:

• T-SOL Development (queries, stored procedures, views, triggers, functions CTE and indexes)
• Build and maintain ETL packages using SSIS and work effectively with team members.
• Develop reports using power BI, tableau or other reporting tools based on client’s choice.
• Building Power BI dashboards and doing ad hoc reporting
• Building KPIs as needed
• Periodic reports for all on-boarding activity and continuous improvement efforts as requested
• Develop and work with transnational databases, data warehouses, internal tools, and external integration s .
• Specifies, analyzes, designs, implements, and tests BI solutions to meet business needs.
• Generating Revenue by procuring new customers through prospecting and face-to-face meetings with C-Level Executives (Business owners, CEO's, etc.)
• Controlling Revenue by maximizing profits through custom application pricing strategies, margin control, and mitigating customer loss
• Administering consultative sales initiatives from proposal stage through customer acceptance and implementation
• Worked closely with customer support groups to enhance customer satisfaction
• Achieved defined project goals and development standards.
• Enforced standardized data definitions, working closely with Data Operation Analysts to maintain consistency in associated applications
• Managed multiple BI initiatives and providing regular status updates to management.

Confidential

BI DEVELOPER

Responsibilities:

• Expertly performed requirement gathering and analysis, analyzed and documented the system specifications, business requirements.
• Designed, developed, modified, and enhanced the database structures and database objects.
• Developing models, dashboards, and reports, based on users’ requirements making DAX queries in Power BI desktop.
• Developed logical and physical data models, design data access strategies and write SQL code to access and manipulate data stored in databases
• Created, developed, and managed schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
• Developed Query for generating drill down/drill through reports in SSRS 20012/14/16
• Created ETL packages to validate, extract, transform and load data to data warehouse databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Adding alerts in the pipelines for notification.
• Scheduling and monitoring the jobs.
• Have also worked on Azure Cosmos DB with SQL API for storing No SQL data.
• Have worked on data modeling part and used start schema and created tables.
• Copying the data from blob to synapse analytics using PolyBase.
• Migrate and deploy customer workloads to azure.
• Azure security and monitoring solutions implementation, including automated responses.
• Developing spark jobs using python.
• Create and maintain existing spark jobs.
• Establishing data lakes and collaborated with the teams to populate data and pull data from various automated business objects data services (BODS).
• Migrated data from on premises data sources to cloud.