Baskaran R. Email & Phone Number

Las Vegas, Nevada, United States

• Highly motivated IT professional having 15+ year of IT experiences with strong background in Business Intelligence area.
• Having 1+ year of experiences in BigData Analytics using Azure, AWS, Opensource tools, Snowflake, etc
• Microsoft certified Azure Data Engineer, AWS certified Big Data Specialist and Astronomer certified ELT developer.
• Expertise in DataAnalytics life cycle–from Defining Business problem till Providing results (Requirement Gathering, Data Discovery, DataModelling, Delivering Business Solutions using DataMart, Reports, etc)

Las Vegas, Nevada, United States

• Solid proficiency with DataAnalytics using Microsoft BusinessIntelligence Stack (SSIS, SSRS, SSAS, Power BI, SharePoint) and have good exposure in CreditCard domain.
• Involved in every stage of developments life cycle–from Defining Business problem till providing results (Requirement Gathering, Data Discovery, DataModelling, Delivering Business Insights using Visualization).
• Designed various relational/Star schema datamart in SQL server and Business Multidimensional/Semantic model in Analysis servers.
• Demonstrated various POCs in features of SSIS 2016 like AutoAdjustBufferSize, Balanced Data Distributor Transformation, Incremental package deployment, CheckPoint, etc
• Created SSIS Packages by using advance transformations (i.e. Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Data Conversion, Lookup, Merge, Sort, Aggregate) and also used Run-Time Events like.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.

Nashville, Tennessee, United States

• Directly interacting with business users to collect business requirements and created technical specifications.
• Developing ETL solutions using SSIS 2014 to fetch Medi claims related data from various agent source systems.
• Created the Centralized dataware house using SQL 2014 meeting all reporting requirements to re mediate CMS audit.
• Used latest version of SQL server tools 2014 and implemented its features.
• Interacted with multiple groups like Authorization, grievances, Appeals, Claims systems to collect required source data.
• Created various reports using SSRS(tabular) for audit/Compliance team to analyze the data.

Las Vegas, Nevada, United States

• Developing Business Intelligence solutions using Microsoft SSIS, SSRS, SSAS and Power BI tools.
• Involving in performance tuning of complex database solutions like partitioning, archiving of past data.
• Implemented the data cleansing framework for massaging the input data & managed the cube dimensions using Master Data Services.
• Created various reports using SSRS and Power Pivot for business end users to analyze the data.

Chennai Area, India

• Interacted with business users for gathering requirement for implementing Overdraft Analysis reporting system.
• Lead the team for developing BI solutions using SSIS, SSRS, SSAS, PowerPivot.
• Developed and maintained various application ranginging from BackOffice to FrontOffice in EMEA based Equity portfolio.
• Functions of these applications are like Fails Tracking, Matching trades, ClientMoney determination, PnL reporting, Tax operation, etc
• Interacted with business users for collecting business requirement and converted them to technical specifications.
• Attended various Financial domain related training and spread those knowledges to other team members too.

Bengaluru, India

• Written SQL Queries, SQL Stored Procedures, Views, Functions and Cursors and involved in performance tuning.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Involved in updating of the Tariff and Webpage contents using MCMS.
• Involved in developing utility tools using C# for helping the day to day business activiteis.

Chennai

• Created portal for Financial based company for tracking projects efficiency, progress and other documentation.
• Provided the consulting services for Microsoft ISV client based in USA and EMEA regions.
• Migrated the database which are hosted on legacy assets to latest Infrastructure based on technical compliances.

Bachelor Of Engineering (B.E.), Electronics

Activities and Societies: Actively participated in organiziing National level symposium for Electronics & Instrumentation Dept.

Higher Secondary, Biology , Maths

10Th, Matric