Manoj K
Business Intelligence Developer @OpenText
Signup · Get unlimited contacts
WORK HISTORY
Business Intelligence Developer @OpenText
Waterloo, ON, CA
Extracted the data from various Salesforce applications and applied data standardization and transformation rules in SQL Server and then export back to Unity Salesforce Application.• Prepared multiple destination and source tables with different constraints in SQL server and used relevant views, functions, table variables, T-SQL procedures accordingly handled different types of errors along with execution plans.• Handled SSIS packages for Logging, error handling, complex transformations, Deployment, and production support.• Used SSIS tasks such as Conditional Split, Derived Column, for Data Scrubbing, data validation.• Created tables and constraints as per the design to store the Master Tables data such as Item Master, Product Master, Calendar Master, Transaction Tables.• Created views, functions, stored procedures to supply the data to front end web application.• Extensively used Joins, temp tables in Stored procedures and implemented Error Handling.• Extracted data from various data sources like Salesforce, Excel and CSV Sources using SSIS.• Developed SSIS packages with various complex transformations such as derived column, conditional split, lookup and execute SQL task.• Hands on Debugging and Error Handling in SSIS packages.• Experience in deploying the changes to QA, UAT and Prod environments.Environment: SQL Server 2016/2017/2019 Microsoft Visual Studio, MS Office, SSIS, SSRS, Power BI, Snowflake, Azure SQL.
ABOUT MANOJ K
Highly accomplished MSBI Developer with over 5 years of Experience and Expertise in Designing, Developing and Delivering Business Intelligence Solutions.• Experienced in Data Analysis, Design, Implementation, Administration, and support of Business Intelligence using SQL Server SSIS, SSAS, and SSRS.• Strong programming experience in TSQL, PL/SQL Development (SQL SERVER 2012) and Report Development (SSIS, SSRS), Performance Analysis, Deployment Script Development, Production Support.• Published reports to Azure-based Power BI services (Pro) and schedule subscription and various sharing options (workspace, content pack, and Apps).• Excellent hands-on experience in groups, hierarchies, and measures, KPIs• Expert in working on all phases of Data warehouse from gathering requirements to testing, implementation, and support.• Excellent knowledge in Performance tuning methodologies at a database level, ETL, and Report Level.• Proficient in the ER-Data Modeler, for the designing of Conceptual Design, Logical Design, and Physical Design and setting up the database model.• Excellent knowledge of Data Warehousing methodologies and concepts, including Star schema, Snowflake, ETL processes, Dimensional modelling, and reporting tools.• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.• Expert in Creating, configuring and Fine-tuning SSIS packages, SSRS reports and T-SQL query using tools like SQL profiler Monitoring tool.• Experience in creating jobs, alerts and schedules for SSIS Packages in SQL Server Agent.• Highly proficient in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User Functions, User profiles, Relational Database Models and data Integrity, SQL joins and query Writing.• Proficient in applying transformation rules - Data Conversion, Data Cleansing, Data Aggregation, Data Merging and Data split.• Expert in generating reports using SQL Server Reporting Services (SSRS).• Proficient in SQL Enterprise Manager, SQL Query Analyzer, scheduling jobs with SQL Server Agent, and SQL Profiler.• Strong Knowledge in Data Analytics tools like Power BI• Expertise in DAX & MDX Languages which helps in understanding and analyzing the data.
This profile is compiled from publicly available professional sources. Unifers is not affiliated with or endorsed by LinkedIn. Request removal of this profile.