SUMMARY

• Overall 7+ years of experience in Business Intelligence & Data Warehousing.
• Analysis, Design, Development, and Implementation of operational database systems (OLTP) and data warehouse systems (OLAP) using MSBI such as SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Worked on different projects with best industry standard experience implementation (SDLC), troubleshooting, presentation abilities and issue resolution capabilities.
• SSRS reports and SSAS models are presented to Decision Support Systems (DSS) for top management.
• Quick understanding of business and domain with source and target systems.
• Expertise in understanding Fact Tables, Dimension Tables and Summary Tables.
• Expertise knowledge and experience in deploying SSIS packages, SSRS reports and SSAS Cubes to DEV, TEST and PROD Server.
• Worked on performance improvement, ETL migration, Environment setup and admin activities.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Experienced in enhancing data warehouse with extensive knowledge of Data mapping, Data Modelling, Snowflake, Star Schemas, ETL jobs and OLAP operations.
• Created interactive dashboards in Power BI reports that were presented to Business users, Program managers and End users.
• Expertise in What - If Analysis using Excel, Power Pivot Reports and Drill Through Dashboards using Warehouses and OLTP Connections
• Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRow Generator, tSetGlobalVar, tHashInput&tHashOutput and many more).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports.
• Created many Drill through and Drill Down reports using SSRS and Power BI.
• DAX query language used in Power BI SME and Portal Development, Tabular Model of SSAS and MDX query language used in multidimensional model of SSAS.
• Master in performing administrative tasks: database files management, backup/restore, data integration and synchronization.
• Created complex mappings by using different transformations like Filter, Router, lookups, Stored procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Experience in creating Jobs, Alerts, SQL Mail Agent and scheduled DTS/SSIS Packages.
• Experience in SQL tuning using Hints, Materialized Views.
• Extensive experience in System Analysis, Design, Development, Implementation, Production Support and Maintenance of Data Warehouse Business Applications in Healthcare and Finance industries.
• Expertise inFunctional testing, Manual Testing and Automated Testing, Regression testing, User Acceptance testing (UAT), System testing and Integration testing.
• Experience in Agile and waterfall models to deliver the projects and used JIRA tool for Sprint planning and tracking the project status.
• Excellent communication, interpersonal skills, self-starter, enthusiastic, eager to meet challenges and quickly assimilate latest technologies concepts and ideas.

TECHNICAL SKILLS

Database Tools: MSBI Data Tools(SSIS, SSRS, SSAS), Tableau, Power BI, Power Excel, Power Pivot, Data Transformation Services (DTS)- Import/ Export Data, Bulk Copy Program (BCP)

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, Fact and Dimension tables, Physical and Logical Data Modeling.

RDBMS: Oracle 11g/10g/9i, Teradata, MS SQL Server 2014/2008/2005/2000 , DB2, MySQL, MS Access.

Programming Skills: SQL, Oracle PL/SQL, DAX, HTML, XAML, .Net.

Tools: JIRA, Git and TFS.

PROFESSIONAL EXPERIENCE

Confidential | San Antonio, TX

Power BI/ MSBI Developer

Responsibilities:

• Worked closely with Business Analysts to review the business specifications of the project and to gather the ETL requirement.
• Closely worked with Data Architects in designing of tables and even involved in modifying technical Specifications.
• Participated in Requirement gathering, Business Analysis, User meetings and translating user inputs into ETL mapping documents.
• Created various database objects as for business logic demands like Stored Procedures, Tables, Views, Indexes etc. based on user requirements.
• CreatedSSISpackages to extract, transform and load data into data warehouse.
• Createdtransformations to manipulate data using Lookup, Derived Columns, Conditional Split, Term extraction, Aggregate, SCD, Script component, Pivot, Unpivot, Merge etc.
• Used many Tasks like Execute SQL Task, Data Flow Task, Execute Package Task and Script Task etc.
• Create Generic Reports and Dash boards in Power BI.
• Error Handling and Logging done to control and prevent data leakage.
• Responsible for Deploying the SSIS packages.
• Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
• Auto scheduled the package through Jobs in SQL Server Agent.
• Experience in optimizing Microsoft Power BI dashboards, Power BI SME, Power BI apps with a focus on usability, performance, flexibility, testability, and standardization.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar, and density charts.
• Created reports in Power BI preview portal utilizing the SSAS tabular via Analysis connector.
• Developed Tableau data visualizations using cross tabs, heat maps, box and whisker charts, scatter plots, geographical maps, pie charts and bar charts.
• Report refresh and publish are auto scheduled in Power BI SME report server on daily, weekly and monthly basis.
• Used the Bulk Copy Program (BCP) to load the large volumes of data from files into tables.
• 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 enabling end-user to make filters.
• Mail Task used to send mails to client and admins about the scheduled package auto run status.
• The reports are generated on various Business Needs, Categories and demographics using SQL Server Reporting services (SSRS).
• Created Table, Matrix, Tablix, Chart, Drilldown reports, Parameterized and Cascaded reports according to business requirement.
• Wrote efficient MDX queries to retrieve data from Tabular cube by eliminating MDX Sub Cubes SSRS Query designer generates for improved performance and better user experience.
• Created SSAS cubes with KPIs and aggregation for the front-end analysis team.
• Experience in Tabular Modelling, DAX and Worked on Data modelling, creating star schemas in SSAS.
• Created the KPI to show the difference between actual and forecast data.
• Used Execution Plan, SQL Profiler and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.
• Designed complex reports like dynamically driven parameterized reports, reports with sub reports, drill through reports using SQL Server reporting services.
• Extensively worked on Data Cleansing, Data Analysis and Monitoring Using Data Quality Services.
• Involved in production, deployment activities, creation of the deployment guide for migration of the code to production.

Environment: MS SQL Server, MS Business Intelligence (MSBI), MS Excel, Oracle, Azure Devops, Azure Data Factory, Power BI.

Confidential | Long Beach, CA

MSBI (SSIS, SSRS)/Power BI Developer

Responsibilities:

• Participated in all phases of development life cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Created and managed Source to Target mapping documents for all Facts and Dimension tables
• Created and deployed physical objects including custom tables, custom views, stored procedures, and Indexes to SQL Server for Staging and Data-Mart environment.
• Design and Implemented ETL for data load from heterogeneous Sources to SQL Server and Oracle as target databases and for Fact and Slowly Changing Dimensions SCD-Type1and SCD-Type2.
• Worked in implementation life cycle of both Agile and Waterfall Methodologies.
• Experience in transformations and validating data using SSIS transformations like Conditional Split, Lookup, Merge Join, Sort and Derived Column.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Unit Testing, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Created different visualization in the reports using custom visuals like Bar Charts, Pie Charts, Line Charts, Slicer etc. using different types of transformations inside power query editor to clean-up the data.
• Experience in creating KPI’s and Score cards for measuring the company growth.
• Developed Power BI reports and dashboards from multiple sources such as Azure Data Lake storage Gen1 and Gen2, Excel File, text file, MS SQL Server, SharePoint Folder and Power BI dataflows.
• Performed different types of transformation such as Creating Bins, Change the Data type of a Column, Combine Multiple Tables, Creating Clusters, Format Dates, Creating Groups and Hierarchies, Joins, Pivot Tables, Query groups, Unpivot Tables and Split Columns.
• Knowledge on Azure data Factory Pipeline creations and storing in BLOB containers.
• Worked with different types of Filters and Slicers such as Basic Filters, Advanced Filters Top N Filters, Page-Level Filters, Report Level Filters and Drill through Filters.
• Created Calculated Columns, Calculated Measures, Calculated Tables and Custom Columns by using DAX functions.
• Experience on DAX Functions such as Aggregate, Date, Logical, Math, String and Trigonometric Functions.
• Experience in Managing roles by applying Row Level security.
• Experience in Publishing and Scheduling the Power BI Reports in Power BI Service.
• Experience in Creating Data Flows in Power BI Service.
• Experience in Sharing Power BI Reports to the assigned users and enabled Subscriptions on a required format in a desired time frame.
• Granting Report Permissions to the desired people in the organization.
• Worked with Incremental and Full Load Refreshes.

Environment: MS SQL Server, MS Business Intelligence (MSBI), MS Excel, Oracle, Azure Devops, Azure Data Factory, Power BI.

Power BI/ MSBI Developer

Responsibilities:

• Perform technical analysis, ETL design, development, testing, and deployment of IT solutions as needed by business or IT.
• Expertise in Data Modeling concepts including Dimensional Modeling, Star and Snowflake schema, Experience in CDC and daily load strategies of Data.
• Involved in Software Development Life Cycle (SDLC) including analysis, design, development and testing of the project.
• Installed and administered Microsoft SQL Server, SQL Server Integration Services, SQL Server Reporting Services.
• Designed and develop Dashboards and Reports using Power BI and SSRS.
• Solid knowledge of Data Warehousing, strategies for ETL, identifying Metrics, Dimensions, Hierarchies, and design dimensional schemas (Star, Snowflake).
• Involved in managing slowly changing dimensions (SCD), De-Normalization, Cleansing, Conversion and Aggregation.
• Importing data to Power BI from various sources.
• Worked on Key performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS).
• Creating source and target table definitions using SSIS. Source data was extracted from Flat files, SQL Server, Oracle and DB2 Databases.
• Experience object-oriented programming (OOP) concepts usingC#.
• Responsible for cleansing up database for maintenance of the database.
• VB.Net and other .NET languages C# used in Script task to control the flow of SSIS packages.
• Designed SSAS cube objects such as KPIs, aggregations, perspectives, and translations.
• Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Excellent Knowledge in analyzing Data warehouse by building cubes using SQL Server Analysis Services SSAS.
• Implemented Event Handlers and Error Handling in SSIS packages.
• Experience in developing scripts in SSIS to synchronize stored procedures, email output and log messages.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Unit Testing, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Implemented Performance Tuning at various levels and created indexes (cluster and non-cluster index).
• Designed, Developed, Tested, Published and maintained Power BI Functional reports, Dashboards.
• Formatted dashboards, multiple chart types, trends, and KPIs with Power View to support analyses.
• Participated in design of Staging Databases and Data Warehouse/Data marts using Star Schema/Snowflakes schema in data modelling.
• Provided production support to various manuals and deployment.
• Experienced working in the Agile methodology.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures in the Power BI.

Environment: MS SQL Server, MS Business Intelligence (MSBI), MS Excel, Oracle, Azure Devops, Azure Data Factory, Power BI and .Net.

Confidential |Kansas, MO

Talend/ ETL/ Power BI Developer

Responsibilities:

• Worked on SSAS in creating data sources, data source views, named queries, calculated columns, cubes, dimensions, roles and deploying of analysis services projects.
• SSAS Cube Analysis using MS-Excel and PowerPivot.
• Converted some of the existing integration jobs from SSIS and Informatica to Talend 6.3 and documented the process.
• Implemented SQL Server Analysis Services (SSAS) OLAP Cubes with Dimensional Data Modeling Star and Snowflake Schema.
• Knowledge of analytical and reporting including data query design, analysis and validation techniques using SQL, Tableau, etc.
• Developed standards for ETL framework for the ease of reusing similar logic across the board.
• Analyze requirements, create design and deliver documented solutions that adhere to prescribed Agile development methodology and tools.
• Experience in creating KPI’s and Score cards for measuring the company growth.
• Developed Power BI reports and dashboards from multiple sources such as Azure Data Lake storage Gen1 and Gen2, Excel File, text file, MS SQL Server, SharePoint Folder and Power BI dataflows.
• Performed different types of transformation such as Creating Bins, Change the Data type of a Column, Combine Multiple Tables, Creating Clusters, Format Dates, Creating Groups and Hierarchies, Joins, Pivot Tables, Query groups, Unpivot Tables and Split Columns.
• Responsible for creating fact, lookup, dimension, staging tables and other database objects like views, stored procedure, function, indexes and constraints.
• Monitoring the Data Quality, generating weekly/monthly/yearly statistics reports on production processes - success / failure rates for causal analysis as maintenance part and enhancing exiting production ETL Process
• Developed complex Talend ETL jobs to migrate the data from flat files to database.
• Implemented custom error handling in Talend jobs and worked on different methods of logging.
• Followed the organization defined Naming conventions for naming the Flat file structure, Talend Jobs and daily batches for executing the Talend Jobs.
• Knowledge on Azure data Factory Pipeline creations and storing in BLOB containers.
• Worked with different types of Filters and Slicers such as Basic Filters, Advanced Filters Top N Filters, Page-Level Filters, Report Level Filters and Drill through Filters.
• Created Calculated Columns, Calculated Measures, Calculated Tables and Custom Columns by using DAX functions.
• Experience on DAX Functions such as Aggregate, Date, Logical, Math, String and Trigonometric Functions.
• Experience in Managing roles by applying Row Level security.
• Experience in Publishing and Scheduling the Power BI Reports in Power BI Service.
• Responsible for develop the jobs using ESB components like tESBConsumer, tESBProviderFault, tESBProviderRequest, tESBProviderResponse, tRESTClient, tRESTRequest, tRESTResponse to get the service calls for customers DUNS numbers..
• Exposure of ETL methodology for supporting Data Extraction, Transformation and Loading process in a corporate-wide ETL solution using Talend Open Source for Data Integration 5.6. worked on real time Big Data Integration projects leveraging Talend Data integration components.
• Analyzed and performed data integration using Talend open integration suite.
• Wrote complex SQL queries to inject data from various sources and integrated it with Talend.
• Worked on Talend Administration Console (TAC) for scheduling jobs and adding users.
• Worked on Context variables and defined contexts for database connections, file paths for easily migrating to different environments in a project.
• Developed mappings to extract data from different sources like DB2, XML files are loaded into Data Mart.
• Created complex mappings by using different transformations like Filter, Router, lookups, Stored procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Mart.
• Involved in designing Logical/Physical Data Models, reverse engineering for the entire subject across the schema.
• Developed Talend ESB services and deployed them on ESB servers on different instances.
• Created WSDL data services using Talend ESB.
• Created Rest Services using tRESTRequest and tRESTResponse components.
• Used tESBConsumer component to call a method from invoked Web Service.
• Scheduling and Automation of ETL processes with scheduling tool in Autosys and TAC.
• Scheduled the workflows using Shell script.
• Used Talend most used components (tMap, tDie, tConvertType, tFlowMeter, tLogCatcher, tRowGenerator, tSetGlobalVar, tHashInput & tHashOutput and many more)
• Created many complex ETL jobs for data exchange from and to Database Server and various other systems including RDBMS, XML, CSV, and Flat file structures.
• Developed stored procedure to automate the testing process to ease QA efforts and reduced the test timelines for data comparison on tables.
• Automated SFTP process by exchanging SSH keys between UNIX servers.
• Worked Extensively on Talend Admin Console and Schedule Jobs in Job Conductor.
• Involved in production n deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books.
• Creating Talend Development Standards. This document describes the general guidelines for Talend developers, the naming conventions to be used in the Transformations and development and production environment structures.

Environment: Talend, XML files, DB2, Oracle 11g, SQL server 2008, SQL, MS Excel, MS Access, UNIX Shell Scripts, TOAD, Autosys.

Confidential

ETL Developer

Responsibilities:

• Worked closely with Business Analysts to review the business specifications of the project and also to gather the ETL requirements.
• Developed jobs, components & Joblets in Talend. Designed ETL Jobs/Packages using Talend Integration Suite.
• Created complex mappings in Talend using tHash, tDenormalize, tMap, tPivot To Columns Delimited, tUniqueRow as well as custom component such as tUnpivotRow.
• Used tStatsCatcher, tDie, tLogRow to create a generic joblet to store processing stats into a Database table to record job history.
• Created Talend Mappings to populate the data into dimensions and fact tables. Frequently used Talend Administrative Console (TAC)
• Implemented new users, projects, tasks within multiple different environments of TAC (Dev, Test, Prod, DR).
• Developed complex Talend ETL jobs to migrate the data from flat files to database. Implemented custom error handling in Talend jobs and also worked on different methods of logging. Created ETL/Talend jobs both design and code to process data to target databases.
• Created Talend jobs to load data into various Oracle tables. Utilized Oracle stored procedures and wrote Java code to capture global map variables and use them in the job.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, DB2, Flat files, XML files etc into the Staging table and then to the target database.
• Troubleshot long running jobs and fixing the issues.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.

Environment: Talend Open Studio, UNIX, Oracle, SQL Server, TOAD, AutoSys, Windows 2008.