PROFESSIONAL SUMMARY:

• I am highly motivated, and dedicated professional with over 6 years of IT experience in Finance and Insurance domains. I am technically sophisticated and analytical professional with extensive experience in automating and optimizing business processes to facilitate organizations with data - centric decision making, while leveraging Power BI and SQL servers. I am skilled in devising robust plans, allocating/utilizing resources, and mitigating potential risk to ensure completion of large-scale projects within timeline and budgetary constraints.
• My expertise lies in developing Power BI dashboard, monitoring business process cycle, conducting root cause analysis, testing vulnerabilities, and hardening business-critical systems, currently working as Power BI Developer for a Finance industry with a scrum-based Team using Agile Methodology as their main framework
• I am an influential interpersonal and communication skills, able to communicate highly complex technical information to non-technical users/stakeholders to drive strategic cohesive functions.
• Experienced in Data modeling, Database Design, Data warehousing, Database Development during the Extract, Transform and Load process (ETL)
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Proficient in writing DAX queries in Power BI desktop.
• Experience in Reporting Services, Power BI (Dashboard Reports), Crystal Reports, SSRS using MS SQL Server and in supporting services MDX technology of the analysis services.
• Strong experience in ETL methodology for data transformation from different sources to Data staging Tables and Enterprises Data warehouse systems
• Excellent knowledge and experience in data warehouse development life cycle, dimensional modeling, implementation of STAR, SNOWFLAKE schemas and Slowly Changing Dimensions.
• Knowledge in Azure Stream Analytics
• Knowledge in Data Modeling (Logical, Physical, Star Schemas)
• Experience in Creating Packages in SSIS using Microsoft Visual Studio for ETL process.environments
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Experienced in implementing Power BI gateway different source to matching analysis criteria and further modeling for Power Pivot and Power View

TECHNICAL SKILLS:

Operating System: Windows, Linux

Components/ Environment: MS SQL Server 2016/2014/2012, SQL Server Management studio, Microsoft Visual Studio, PBI Desktop, Power BI Service, SSIS, SQL Server, Oracle SQL Developer, SSIS.

Languages: T-SQL, PL/SQL, Linux shells scripting, Azure

Database: MS SQL Server, Oracle, Flat files

Tools: SSIS, SQL Server, Oracle SQL Developer, SSIS

WORK EXPERIENCE:

Confidential (Plano, TX)

Power BI Developer

Responsibilities:

• Translate business logic into dashboards, charts, reports, and presentations in support of Sales & Marketing department.
• Imported data from SQL Server DB, Azure SQL DB to Power BI to generate reports.

  Designing Microsoft power BI dashboards and managing the power BI gateways with a focus on usability, performance, flexibility, testability, and standardization.

• Designing OTLP, OLAP databases and creating ETL packages, tabular models, and dashboards.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.
• Using Power BI, Power Pivot to develop data analysis prototype, and used Power View a Power Map to visualize reports available in Web clients and mobile apps.
• Utilizing Power BI (Power Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Designed SSAS Cube and developed MDX queries for Analysis.
• Document steps needed to migrate database objects between environments including Development, UAT, Staging and production
• Meet with business for defined requirements of the project.
• Provide production support of existing ETL process and develop cross validation rules to ensure mapping accuracy for newly added business rules.
• Developing SQL queries or use available data profiling applications to perform data analysis based on the business requirement and created data profiling report for data discovery.
• Developing new data integration and support existing dataset for BI teams.
• Creating SSIS jobs and scheduled packages using SQL Server management studio
• Supporting Maintenance of ETL process
• Applying common transformations such as aggregate, data conversion, conditional split, lookup, merge, and sorter transformations
• Responsible for migrating folders or mappings and sessions from development server to test environment.
• Working with Data Architects, DBAs, and Business Intelligence teams in designing and support end-to-end data solutions across multiple platforms.
• Improving ETL performance applying best practices

Environment: MS SQL Server 2016/2014/2012, SSIS,Shell Scripting, SQL, T-SQL, PL/SQL, Oracle, MS Word, MS, Excel, UNIX, Windows OS, Azure

Confidential

Business Intelligence Developer

Responsibilities:

• Develop, design, and analyze data architecture and data warehouses using SQL, SSIS, SSRS and Power BI
• Optimizing existing data models including changing load scripts to load data in an optimized way to achieve a reduction of loading time, simplifying complex expressions in the front-end, improving layout structure.
• Working with the business to document and develop KPIs for the calculations in the Power BI and SSRS apps.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User-Defined Functions.
• Experience in using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks, and handling the Isolation Levels.
• Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL.
• Identified and worked with multi-value parameters for parameterized reports in SSRS and Power BI.
• Scheduled, maintained, and supported the distribution and access to reports at the Server level.
• Configured and maintained Report Manager and Report Server for Power BI Gateway and SSRS.