Balakrishnan K S

Seeking to work with leading organization that provides me ample opportunities to use my technical knowledge, communication, and analytical skills. A quick learner and easily adaptable to any new technology. Looking forward to undertaking new challenges to learn and grow as a unit.

• Having total 8+ years of working experience out of which and 5.8 Years in Microsoft Business Intelligence tools like SQL Server 2014/ 2016/2017/2019 (SQL, T-SQL), SSIS, SSRS, SSAS, BIDS/SSDT – SSMS, Power BI and 2+ years as Quality Analyst in BPO domain and 1+ years in Logistics domain to work in a dynamic professional environment with a growing organization and utilize my creativity and innovative thinking for benefit of the organization and myself.
• Confident Lead Developer Skilled at accurately defining and acquiring resources to complete projects at any scale. Committed to strict development lifecycle management planning and methodological adherence. Practiced administrator of forecasting and planning techniques that eliminate waste and shorten development times.

• Allucent, Sep 2023 to Till Date, Customer Analytics, Associate Lead Developer, 3, Allucent Clinical Research Organization is on a mission to help bring new therapies to light by solving the distinct challenges of small and mid-sized biotech companies. It is a global provider of comprehensive drug development solutions, including consulting, clinical operations, biometrics, and clinical pharmacology across a variety of therapeutic areas. With more than 30 years of experience in over 60 countries. Allucent nurtures a high-performance culture also It provide lean project management to accomplish operational excellence in terms of timelines, quality, and costs., Integrated and analysed data from multiple heterogeneous sources (CSV, XML, Excel, and SQL), Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Slowly Changing Dimension, Merge Join and Union all., Developed T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, auditing., Developed Full/Incremental Loads using SSIS and scheduled via SQL server job Agent tool., Worked in error and event handling: precedence Constraints, Break Points, Check points and Logging., Developed & deployed Power BI reports to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,, Created DAX Queries to generated computed columns in Power BI, Expertise in creation and deployment of dimensions, partitions, aggregation, and cubes on SSAS., Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS ., Provided TRAINING/UAT/Production support.
• Ashley, Jan 2020 to Aug 2023, Customer Analytics, Associate Lead Developer, 8, Ashley Furniture Industries, Inc. is an American home furnishings manufacturer and retailer, headquartered in Arcadia, Wisconsin. Ashley Furniture manufactures and distributes home furniture products throughout the world. Asley contains different layers like Retail, Ecommerce Sales sections. It divides into 4 group like Corporate, Ecommerce, Stories and Licensee. All the sections sales calculated based on the Dim and Fact tables which used to store the data, which was loaded from Source systems like AS400, Homes, D365 & Pervasive systems. The process of data load flow will be from External/Source to Stage/Enh tables and then the SQL Jobs used to move the data into DW tables (Dim & Fact). Once the cleaned data extracted into DW then the same will be used to process the cube (Retail/Ecommerce OLAP) and generate the SSRS/Power BI Reports., Integrated and analysed data from multiple heterogeneous sources (CSV, XML, Excel, and SQL), Created SSIS packages to Extract, Transform and load data using different transformations such as Lookup, Derived Columns, Condition Split, Slowly Changing Dimension, Merge Join and Union all., Developed T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers, auditing., Developed Full/Incremental Loads using SSIS and scheduled via SQL server job Agent tool., Worked in error and event handling: precedence Constraints, Break Points, Check points and Logging., Developed & deployed Power BI reports to import data from various sources such as SQL Server, Azure SQL DB, SQL Server Analysis Services (Tabular Model), MS Excel etc.,, Created DAX Queries to generated computed columns in Power BI, Expertise in creation and deployment of dimensions, partitions, aggregation, and cubes on SSAS., Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS ., Provided TRAINING/UAT/Production support.
• UNWOMEN, Jan 2019 to Dec 2019, Datamatics Global Services Limited, Associate Consultant, 3, This application is country-based result management system. I have worked on two modules 1. RMS and 2.SG. By using this application user can produce result based on set of outcomes and outputs. User can set ups the annual plans and associate budgets for them. As per plan, possible outcomes and outputs are designed and fixed. Accordingly, to possible outputs and outcomes results are created. All state of plans is managed by workflows. All the Dimension Packages are created using SCD1 logic. Using this methodology, we can Insert new Records and Update Existing records if there is a match. The flow of the data will check if the is new record or existing record using lookup transformation. Conditional split transformation is used to split records, If the record is new, we are inserting directly into destination else loading into temporary table to update the existing records based on business keys., Developing T-SQL queries, triggers, functions, and stored procedures in SQL server database., Creating Dynamic procedures for variable operations., Developed SSIS packages to extract, transform and load into campaign database from OLTP database., Used SSIS control flow task, analysis service processing task to individually process partitions and dimensions and updating cube as changes occurs in underlying Data Warehouse, Designed ETL data flows using SSIS and created mappings/workflows to extract data from SQL Server and data migration and transformation from Excel Sheets using SSIS., Responsible for logical and physical design of SQL Server databases., Analysing and improving the performance of databases and its objects., Performing the ETL operations to support the incremental, historical data loads and transformations using SSIS., Involved in building and maintaining SSIS Packages to import and export the data from various data sources using BIDS based on the design data models.
• UNV, April 2018 to Dec 2018, Datamatics Global Services Limited, Associate Consultant, 5, The data will be extracted from UN Entities and excel files and loaded into the HR Staging schema. The data from here will be processed and cleansed with ETL processes and loaded into the UNVDWH data warehouse using jobs. UNVDWH DataMart stores the data about employment, Recruitment, and timesheet for UNV. The data is extracted from ATLAS and Spreadsheets. The common data related to master’s will be stored in the shared schema., Ensured project requirement and delivery with active interactions with end users., Redesigned and tuned Stored Procedures, Triggers, Tables, UDF, Views, CTE and Indexes and able to increase performance of queries., Developed SSIS packages to extract, transform and load into campaign database from OLTP database., Used SSIS control flow task, analysis service processing task to individually process partitions and dimensions and updating cube as changes occurs in underlying Data Warehouse., Designed ETL data flows using SSIS and created mappings/workflows to extract data from SQL Server and data migration and transformation from Oracle/Access/Excel Sheets using SSIS., Involved in all phases of report life cycle (authoring, managing, and delivering)., Created a cube using multiple dimensions and modified relationship between a measure group and a dimension, created calculated members and KPI’s, using SSAS., Analysed, designed, built and tested OLAP cubes with SSAS and in adding calculations.
• ATLAS, April 2015 to June 2016, ATLAS, Junior Executive, 3, Handling the Import/Export Process. Handled Air/Sea Rate Conversion process. Also Involved into the process of planning, implementing, and controlling the efficient, cost-effective flow of raw materials, in-process inventory, finished goods and related information from the point of consumption to the point of origin for the purpose of recapturing value or proper disposal., Sourcing rates from different lines for analysis and comparison., To Negotiate Procure Ocean Export / Import Freight Rates with Master Carriers., To have Monthly rates filing quotations in place for Outside vendors such as Transporters, CFS, Customs Brokers, Fumigating Agencies other parties rendering services for DSV, To Agree Upon Finalize the Terms Conditions of Contract to ensure smooth Invoicing from the carriers., Coordinating with OPS dept for proper disbursement of Invoices Debit note raised by Carriers Outside Vendors after thoroughly Check., Assisting Export Manager / Import Manager in day-to-day activities if required with regard to managing inventories and space with carriers / co-loaders., Coordination with ports operations daily to ensure shipments are handled within the stipulated time frame., To keep a Robust Chart in place reflecting Complete Database required for smooth Co-ordination with Master Carriers, Monitoring day to day activities maintaining various reports., Create and maintain procedures for price desk workflow., Decision making on work execution except for the financial aspects, depending on the urgency and importance, keeping the line manager informed formally.
• SBI, Feb 2013 to May 2015, Serco, Quality Analyst, 22, SBI Inbound Voice process. Handled SBI Outbound. SBI Inbound: Providing services to customer and assisting on Q/R/C. SBI Outbound: Credit Card Sales. (End to End) SBI D-sat (Survey), Auditing the number of calls given by the client daily., Record feedback shared with the Customer service rep to know about his/her areas of improvement., Bring in necessary changes to the process and constant updating of core process., Identify process-level issues impacting the performance., Drive the quality Initiatives., Create quality conscious environment in the organization., Maintain the database of quality., Work with the operations and training department for the process and enhance performance., Interacting with clients., Identifying improvement areas & implementing measures to maximise customer satisfaction levels., Preparing reports and analysis., Attend calibrations and maintain variance.

• Databases: SQL Server 2014, 2017, 2019
• Languages: SQL, T-SQL
• Integration Services: SQL Server Integration Services (SSIS)
• Analysis Services: SQL Server Analysis Services (SSAS)
• Reporting Services: SQL Server Reporting Services (SSRS) & Power BI
• Database Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Server Data Tools (SSDT)
• Other Software Components: Team Foundation Services (TFS). Basic Knowledge on Git hub.
• Operating Systems: Windows Server 2008, Windows 7/10