SUMMARY:

• Over 5+ years of experience in the field of Business Intelligence Solutions with Microsoft SQL.
• Knowledge of complete software development life cycle (SDLC) including Requirement Analysis, Requirement Gathering, Design, Development, Implementation and Testing and Development experience and principles like Agile and Scrum
• Experience in High Level Design of ETL SSIS Packages - for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split Insert, merge and union all
• Worked on various Transformations in SSIS in Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups
• Extract data from, excel, flat file, and different data base and load in SQL data base using SSIS packages.
• Extensive knowledge of using Package Configuration wizard to configure SSIS packages.
• Good experience with SQL server and in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes
• Skilled in writing advanced T-SQL queries (DDL, DML), Stored Procedures to improve the database performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling, error handling, stored procedures and performing other maintenance tasks.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created multiple kind of Power BI Reports and Dashboards
• Expertise in writing different DAX functions in Power BI to create columns, measures and tables
• Extensive work experience creating various types of visualizations and features for visualizations
• An excellent team member and individual contributor

TECHNICAL SKILLS:

Programming Languages: T-SQL, PL-SQL, C, Java

Databases: SQL Server, SQL Developer, Teradata Studio Express

Tools: SSMS, SSRS, SSIS, SSAS, SQL Developer, Power BI, Excel

Operating System: Windows, Unix and Linux

PROFESSIONAL EXPERIENCE:

Confidential, Dallas, Texas

MSBI Developer

Responsibilities:

• Worked closely with business users in gathering the requirements and finalizing the requirements.
• Created ETL packages with different Heterogeneous data sources (SQL developer, Flat Files, CSV, Excel source files, and XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Used for Each Loop container, Sequence Container and For Loop container as per the requirement
• Audited each data load.
• Used File System task to Archive the loaded files
• Applying various data transformations like Data Conversion, Multicasting, Conditional Split, and Derived column in SSIS.
• Deployed SSIS package to different environments and scheduled the packages using SQL Server agent job and monitored the deployed packages on the production server
• Scheduled SQL Server Agent Jobs to monitor data transformation and database updates.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams.
• Document internal and external data sources and data integrations and provide operating support or data Integration solutions.
• Involved in database Schema design and development.
• Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
• Created efficient Queries, Indexes, Views and Functions.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.
• Enforced Security requirements using triggers to prevent unauthorized access to the database.
• Identified Fact tables and Dimension tables and created data marts for various subject areas as required.
• Created Cubes using SSAS that are used by business users
• Defined KPI's, Actions and Calculations in SSAS using MDX
• Created SSAS Tabular Model & Multidimensional Cubes. And deployed into SQL SERVER ANALYSIS SERVER 2016.
• Developed and Extended OLAP Cubes, Dimensions and data source view.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created Excel Reports, Power BI by connecting to various SQL server databases and improved the efficiency of these large reports.
• Validating data from source and dashboard
• Expertise in writing complex DAX expressions for creating new measures and new columns
• Designed various practical data visualizations, charts, dashboards, prototypes and demos
• Creating dashboards using various visuals such as slicers, bar charts, table, clustered column charts etc. with drill through and drill down features
• Generating context filters and data source filters while handling large volume of data
• Combining and shaping data as per requirements
• Establishing and editing relationships among different tables and editing visual interactions
• Publishing reports created in Power BI Desktop to Power BI Service
• Worked on scheduling power Bi Reports.
• Validating data from source and dashboard
• Responsible for setting up the Workspace and Providing access to the Users
• Troubleshoots data issues, validates result sets, recommends and implements process improvements.
• Experienced solving issues raised by QA, UA for database.

ENVIRONMENT: Microsoft SQL Server 2016, Microsoft Visual Studio 2015, Power BI, MS Excel, Oracle, VSTS,SVN, JIRA, ALM, TopTeam.

Confidential - Dallas, Texas

SQL Power BI Developer

Responsibilities:

• Involved in analysis of Report design requirements and actively participated and interacted with Team Lead, Technical Manager and Lead Business Analyst to understand the Business requirements.
• Create and maintain clearly written technical, user, and system documentation.
• Created Database Objects like tables, views, Store Procedures, User Defined Functions, Triggers, index and roles.
• Developed Complex Stored Procedures, Views Functions as per the requirement.
• Created joins and sub-queries for complex queries involving multiple tables.
• Identified Fact tables and Dimension tables and created data marts for various subject areas as required.
• Worked on different levels of ETL Loads like Extract Data from Source System to Staging and then from Staging to load data in Database Tables.
• Staying up to date with Power BI monthly updates and participating actively in Power BI Community
• Created Excel Reports, Power BI by connecting to various SQL server databases and improved the efficiency of these large reports.

Environment: Microsoft SQL Server 2014, Microsoft Visual Studio 2015, Power BI, MS Excel, Oracle, Confluence.

Confidential

SSIS/SSRS/SQL Developer

Responsibilities:

• Requirement gathering, Functional & technical specifications for end user and end client applications, Re-Engineering and capacity planning.
• Created ETL packages with different Heterogeneous data sources (SQL Server, Flat Files, CSV, Excel source files, and XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Created packages using Error handling mechanism and used Break points, Toggle switches and variables to handle package dynamically in SSIS.
• Analysis, Design and data modeling of Logical and Physical database using E-R diagrams. Document internal and external data sources and data integrations and provide operating support or data Integration solutions.
• Involved in database Schema design and development.
• Designed tables, constraints, necessary stored procedures, functions, triggers and packages using T-SQL.
• Created efficient Queries, Indexes, Views and Functions.
• Developed complex programs in T-SQL, writing Stored Procedures, Triggers, Functions and Queries with best execution plan.
• Created, Maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports using SQL Server Reporting Services SSRS.

Environment: Microsoft SQL Server 2012 R2, Microsoft Visual Studio 2012,, MS ExcelEducation