SUMMARY

• Professional experience around 3 years in the field of Business Intelligence applications as an ETL Developer with expertise in SQL Server Integration services, Analysis and Reporting Services and using SQL Server, Power BI, Mdx, Dax queries and functions in TFS environment.
• Good Experience and understanding on Database Development, Data warehousing, modeling, Design and Data Management and Star schema and Snowflake schemas and DataMart’s, Operational Data Store
• Experience working in Agile methodology and completing tasks with in Sprints.
• Experience to read, analyze, interpret, and prepare technical documents
• Good understanding of Kimball methodology of data warehouse.
• Experience in installing, coding, implementation, upgrading, configuring of MS SQL Server … in Windows Environment.
• Good Experience in Power BI for Data Visualization and Interactive drill down reports using slicers and dicers in Power BI and Excel, PowerPivot.
• Exposure to cloud based solutions such as AWS.
• Launching EC2 instances on amazon cloud service and creating Rds data bases like oracle Sql 11g.
• Used s3 buckets to save files on AWS cloud and create snapshots of AMI and send it to other regions to launch the instances over there.
• Key Performance Indicators (KPI's) Understand Key Performance Indicators that drive company measurement.
• Created and maintained complex SSAS multidimensional cubes used MDX queries to retrieve the aggregated data from the cubes.
• Extensive experience on T - SQL and SQL Server on creating tables, triggers, user profiles, relational database model, data dictionaries, user defined functions, views, and data integrity.
• Extensive experience in developing Power BI reports and data visualization from various data sources using Data Blending.
• Extensive experience in data migration from different sources including flat files, My SQL, MS Access, Oracle 11g, and OLE DB sources to various Destinations by using SSIS 2008.
• Experience in SQL Server and T-SQL (DDL and DML Commands) in Constructing Tables, Normalization Technique on Database table.
• Created Efficient T-SQL queries, Stored Procedures, Database Triggers and Exception Handlers.
• Experience in OLTP and OLAP environment that include Production, development and implementation at maintain database schema from business requirements.
• Expert in SSRS reports using Drill Down, Drill Through reports, Tabular reports, Matrix reports, Custom reports, Sub reports, Parameterized reports in multiple formats using multiple Data Sets.

TECHNICAL SKILLS:

DATABASES: MS SQL 2012/2014, Oracle 10/11G, My SQL, MS Access

Programming: T-SQL, PL/SQL

ETL TOOLS: SSIS and Knowledge on Informatica

Reporting Tools: SSRS and Power BI, Excel knowledge on Tableau

Analytics tools: SSAS with Mdx

Data tools: SQL plus, TOAD, SQL server

Version control: Team foundation server (TFS), GIT.

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, TX

Environment: Sql server 2016, Power BI, Dax functions. Aws cloud ec2, s3, tableau, T-SQL, SSMS

BI Developer

Responsibilities:

• Wrote complex SQL queries using all kinds of joins, sub queries to retrieve data from the database.
• Used SSIS to create ETL Packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Extensively worked on error handling at different levels of SSIS packages like control flow level and data flow level.
• Generated packages using different Transformations like Lookups, Derived Column, Merge Join, Fuzzy Lookup, For Loop, For Each Loop, Conditional Split, Union all.
• Deployed the created SSIS packages in Development and Testing environments and executing ssis packages using C#/.Net scripting.
• Developed custom reports and deployed them on server using Power BI
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in Installation, configuration and setting of Database servers for various test and development environments including SSRS Installation configuration and administration.
• Created partitions and designed aggregations in Cubes.
• Created perspectives in SSAS and configured security levels for the Cubes.
• Designed KPI's in SSAS and imported them to Excel.
• Responsible for Query optimization and Performance tuning.
• Responsible for debugging and troubleshooting issues, as well as production support.
• Interact with Business users, collect requirements and perform documentation.
• Created Queries in T - SQL, Stored Procedures, and Views to store the data of clients, advisors.

Confidential

Environment: T-SQL, SSIS, SSAS, SSRS, MS Sql Server 2012/2014, Power BI, tableau, Mdx, Dax, Excel, Power pivot, Power view, C#/.Net framework, TFS.

Database Engineer Intern

Responsibilities:

• Responsible for providing technical support for database environment, assessing and implementing new technologies.
• Assisted development team with data issues.
• Designing and implementing database warehouse schema and OLAP operations. Developed various database objects (stored procedures, tables, triggers, etc.).
• Worked on tools like SQL Server, MySQL.