SUMMARY

• Power BI consultant, AAS and SSRS developer with more TEMPthan 8 years of experience Power BI, Power BI Desktop, SSRS.
• Good knowledge and experience in Power BI and Power BI Desktop.
• Extensive experience in T - SQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS).
• Extensive experience in develop, publish, schedule reports and dashboards to meet business requirements.
• Experience with Snowflake cloud data warehouse and AWS S3 bucket for integrating data from multiple source system.
• Experience in building in Snow pipe.
• Experience in using Snowflake clone and Time Travel
• In-depth knowledge of Snowflake Database, Schema and Table structures
• Experience in developing for large data set analysis using Python.
• Experience in managing dataset using Panda data frames with different databases.
• Experience with python script made py visualizations
• Proficient in SQLite, MySQL and postgres databases with python
• Experienced in Design, Development, Testing, Implementation and Production, support SDLC of Data Warehouse, Client/Server, RDBMS, and Web Based Application.
• Experience in import different source of data like SQL Server, Postgres, Excel, Oracle, Web to Power BI to generate reports.
• Worked on Admin activities like tenant changes, creating pipelines, access to end users, create and update data gateway connections.
• Good Knowledge on Azure Analysis services
• Created Dax queries to generated computed columns in Power BI
• Good Knowledge on cloud storage like AWS, AZURE
• Expertise in Data Extraction, Transforming and Loading (ETL) using SQL Server Integration Services (SSIS), Data Transform Services (DTS), Bulk Insert, BCP.
• Extensive knowledge in Tuning SQL queries and improving the query performance.
• Proficient in creating Index, Views, Complex Stored Procedures, appropriate functions, and effective experienced in implementation of strong referential integrity and auditing using triggers and SQL Scripts.
• Good knowledge PowerCenter workflows and sessions and also extract, transform, and load data
• Expert in creating Chart reports, Drill down and Drill through Reports, Cascading parameter report by passing parameters in SQL Server Reporting Services (SSRS).
• Expert in Database Normalization, Optimization and Tuning Backup/Restore, Data Import/Export, Troubleshooting, and Database Objects authorization.
• Expert in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Experience in creating reports using SSRS (SQL Server Reporting Services), Crystal Reports, and OLAP including Interfaces with BIDS (Business Intelligence Development Studio).
• Experience in designing Database Models using MS Visio and ER-win.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• A well-organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem-solving skills.

TECHNICAL SKILLS

RDBMS / Databases: MS SQL Server 2019/2017/2016/2014/2012/2008 , Oracle 8i, MS-Access, PostgreSQL

Languages: T-SQL, python

Operating Systems: Windows Server 2012/2008/NT/windows 10/7/95/ XP, MS DOS 7.0

Modeling Tools: Microsoft Visio 2003, Erwin 3.x, Snowflake DatawarehouseInformatica Reporting Tools Power BI, Power BI Desktop, SQL Server Reporting Services (SSRS), Tableau

Integration Services: SQL Server Integration Services (SSIS), Snowflake Datawarehouse, Redshift

Database Tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor (DTA)

Cloud Technologies: Azure Analysis services(AAS), ADF( Azure Data Factory, AWS redshift, Snowflake Warehouse

Cloud storages: Azure data lake storage, AWS S3

PROFESSIONAL EXPERIENCE

Confidential

Power BI Engineer

Responsibilities:

• Designed and developed Power BI visualizations based on business requirements and creating Dashboards, apps and shared reports to end users
• Working on design, develop, and support Power BI visualizations.
• Worked with line of business and developers ‘to capture data lineage as well as business and technical definition for elements.
• Worked on Snowflake with Python create databases, views and tables.
• Worked with various python libraries such as Pandas and Matplotlib for analysis and Manipulation
• Performed data quality analysis using advanced SQL skills. Performed Count Validation, dimension analysis, statistical analysis, and data quality validation in data migration.
• Extensive Sql querying on staging, Datawarehouse and data mart.
• Convert reports to EXCEL to Power BI
• Working on resolving technical issues and to provide 24 by 7 support
• Performs modeling of information sources and flows.
• Created Tabular Models using DAX queries in analysis services and deployed it.
• Working on admin activities like tenant changes, user access, update gateway connections.
• Created measures, columns, hierarchies, and tables using Tabular Editor.
• Created scripts to create new tables, views, queries for new enhancement using Snow SQL
• Worked on premise to cloud migration project which involved data from Hadoop to AWS (Snowflake data warehouse)
• Created Indexes for faster retrieval of data enhance performance
• Validated the ETL load between different sources (SQL Server, Oracle, and Flat files) to Hive target tables using HQL and Python
• Created DQ check to identity invalid data coming source systems
• Worked in on Onsite offshore model and managed 4 Database Analysts

Confidential, Los Angeles, CA

Power BI/Data Engineer

Responsibilities:

• Developed custom visuals based on business requirements using Power BI Desktop.
• Developed compelling and interactive analysis reports and dashboards for analysis using advanced DAX queries.
• Creating Row level security with Power BI and integration with Power BI service portal.
• Worked on all types of transformations that are available in Power BI Query Editor.
• Scheduled automatic refresh and scheduling refresh in Power BI service.
• Developed analysis reports and visualizations using DAX functions like table functions aggregating functions
• Created reports using time intelligence calculations and functions.
• Created visualizations import data from CSV files, Text files and Excel Spreadsheets.
• Import the data from MY SQL connect with table or store procedures and visualize the reports
• Used OLEDB Source, Excel Source, Flat File Source, Look-up, Conditional Spit, Merge Join, Multicast, Union All, Derived Column, Pivot, Un-pivot, Data Conversion, OLEDB Destination, Flat file destination in data flow.
• Created, implemented and maintained a reporting standard reports while also customizing many reports to meet individual client needs.
• Developed various operational Drill-through, Drill-down and parameterized reports based on the report’s requirements using SSRS.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Used cascaded parameters to generate a report from two different Data Sets.
• Involved with Query Optimization to increase the performance of the Report.
• Created complex stored procedures to generate reports using SSRS
• Designed Reports in SSRS, using Shared data source and specified data source.
• Identified and defined the Datasets for the report generation.
• Defined the report layouts and formatted the reports using the Global Variables and Expressions
• Deployed and Subscribe Reports using SSRS to generate all daily, weekly, monthly Reports.
• Developed and rendered monthly, weekly and daily reports as per the requirement and gave roles, user access with respect to security in Report Manager.
• Prepared required documentation for system support and end users and provide end-user for the reports and analytical solutions
• Provided technical assistance by responding to inquiries regarding errors, problems, or technical questions; train end users and technical support staff as required
• Interacted in weekly meetings with Team Manager to give status updates on projects.

Environment: MS SQL Server 2017, T- SQL, MS Excel 2016, Power Bi, Power BI Desktop, Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio, C#, .Net, Power BI.

Confidential, Sacramento, CA

Power BI Data Analyst

Responsibilities:

• Worked with a team to analyze, design, develop, deploy, and support Power BI Dashboards.
• Implement row-level security on data and security layer models in Power BI.
• Worked on DAX formulas to meet business requirements.
• Design, publish and maintain Power BI data models with may interrelated tables connected.
• Extensively worked with Business Users gathering their requirements and actively cataloging and supporting various issues and providing their solution.
• Used various transformations like Conditional split, Lookup, multicast, Merge join, derived column while loading the data into Destination.
• Using Informatica Power Center designer analyzed the source data to Extract & transform various source systems.
• Tuned the informatica PowerCenter created mappings and mapplets to transform the according to business rules
• Use ETL to implement the slowly changing Transformation, to maintain Historical Data in Data warehouse.
• Created packages in SSIS with error handling by using precedence constraints so if package gets failed it use to notify us by using emails.
• Worked with different methods of logging in SSIS.
• Designed & supported daily, weekly, monthly batch processes using SQL server agent scheduler
• Deployed the packages using Project deployment model using SQL server management studio and SQL server integration services.
• Responsible for creating database objects like table, views, Store Procedure, Triggers, Functions etc. using T-SQL to provide structure to store data and to maintain database efficiently.
• Extensively used joins and sub queries to simplify complex queries involving multiple tables.
• Optimized the performance of queries with modification in TSQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized table, established joins and created Clustered, Non-Clustered indexes whenever necessary.
• Generated multiple reports using SSRS from SQL Server Database (OLTP) included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Cascading Parameter Reports which consist of report criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Created Subscription of reports in different formats like pdf, excel etc. to be executed automatically on daily, weekly and monthly basis.
• Deployed and configured the reports in the Report Server.
• Provided documentation about database /data warehouse structures and updated functional specification and reports and SSIS Packages.

Environment: MS SQL Server 2016, T- SQL, MS Excel 2016, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio) Power BI.

Confidential

SQL /SSRS/SSIS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Water Fall SDLC model system.
• Perform all SDLC phases related to extract, transform, and load (ETL) processes using SQL Server Integration Services (SSIS) and SQL Server T-SQL stored procedures within MS SQL Server 2014 and 2016 environments.
• Developed T-SQL Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed User Defined Functions for giving Scores and views for the application.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Developed, monitored and deployed SSIS packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Created Stored Procedures for that.
• Developed Parameterized, Drill-through, and Drill-down Reports to get monthly customers opened account details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Recognized the fact and dimension tables in the OLAP database.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future .

Environment: MS SQL Server 2014, T- SQL, MS Excel 2013, Microsoft SQL Server Integration Services (SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Business Intelligence Development Studio, Team Foundation Server (TFS), Visual source safe (VSS).