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 OnError , OnTaskFailed ,OnVariableValueChanged, Custom Email Task and Statistics Logging in MSDB catalog.• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.• Created different type of SSRS reports like: Matrix, Conditional, Sub report, Drill-down and Parameterized and deployed and scheduled Reports in Report Manager using SSRS to generate all daily, weekly, monthly and quarterly Reports based on Relational and OLAP databases.• Have good understanding of Agile process of Program Increments, Scrum methodology, Ceremonies and prioritizing PBI items.• Proven ability to deliver results by actively participating in the Daily standup meeting and collaborating well with team to resolve open challenges.• Currently doing POC in process of migrating legacy data platform ( MSBI based ) to Cloud based Big data plarform using Hadoop components , Spark , Kafka , Airflow , S3 buckets , Python , PIG , SQOOP , Hive , HBase

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.• Managed Overnight job monitoring and escalating to managements if there are SLA breaching.• Trained across team about the usage of various reports and its parameter.

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